Investor Workbench / Financial Modeling / DCF Quick · Free

DCF Valuation — 5-Year Quick Model

A 5-year free-cash-flow projection with terminal value and a WACC × terminal-growth sensitivity grid. Pure browser math — nothing's sent to a server, your inputs stay on your device. Share the result by copying the URL. For a full enterprise model (full WACC builder, debt schedule, LBO returns, scenario comparison, AI critique, PDF export, save-to-workbench), upgrade to the Pro modeler.

Inputs

Operating

Discounting

Capital Structure

Valuation

5-Year FCF Projection

Year Revenue ($M) FCF Margin FCF ($M) Discount Factor PV of FCF ($M)

Sensitivity — WACC × Terminal Growth (Implied Per-Share Value $)

Need the full enterprise build?

Move to the DCF + LBO Pro Modeler for the work an analyst actually ships:

  • Full WACC builder (CAPM, cost of debt, target capital structure)
  • 11×11 two-way sensitivity grids — change any two inputs
  • LBO sources & uses + debt amortization schedule + exit MOIC / IRR
  • 3-scenario comparison (bear / base / bull) side-by-side
  • AI critique — "what's structurally wrong with this model" against comp benchmarks
  • PDF export + save to your Investor Workbench (CRM-linked)
How the math works

FCF projection — Year-t revenue grows at the CAGR you supplied. Year-t FCF margin interpolates linearly from Starting FCF Margin to Year-5 FCF Margin. Year-t FCF = Year-t revenue × Year-t margin.

Discounting — Each year's FCF is discounted to PV using 1 / (1 + WACC)^t. The model assumes end-of-year cash flows (simpler than mid-year convention; the Pro modeler offers both).

Terminal value — Computed with the perpetuity-growth (Gordon Growth) method: TV = FCF_year5 × (1 + g) / (WACC − g), where g is the terminal growth rate. TV is then discounted back at (1 + WACC)^5.

Enterprise value = Σ PV(FCF₁…₅) + PV(TV). Equity value = EV + Cash − Debt. Per-share value = Equity value / Diluted shares.

Sensitivity grid — Holds every other input constant and varies WACC by ±200 bps (in 100-bps steps) and terminal growth by ±100 bps (in 50-bps steps). The center cell (your base assumption) is highlighted in orange.

What the quick model intentionally omits — Mid-year discounting convention, separate cost-of-debt and cost-of-equity (CAPM build), tax-rate adjustments on terminal FCF, stock-based-compensation handling, working-capital normalization, and non-operating-asset roll-ins. All of those land in the Pro modeler.