DCF Calculator: Discounted Cash Flow Valuation Step by Step
A DCF calculator turns projected future cash flows into a present-value estimate of what a business, project, or asset is worth today. The method discounts each cash flow by a rate that reflects its risk and timing, then sums the results into a net present value. Discounted cash flow analysis has been used since the 1800s and was formalized in modern economics by Irving Fisher and John Burr Williams in the 1930s Discounted cash flow.
This guide walks through every step: choosing the right cash flow type, projecting free cash flow, calculating the discount rate, estimating terminal value, running sensitivity, and cross-checking with market multiples.
TL;DR
- DCF = Σ (FCFₜ / (1+r)ᵗ) + Terminal Value / (1+r)ⁿ — sum discounted free cash flows plus a terminal value.
- FCFF (firm-level) uses EBIT after tax; FCFE (equity-level) uses net income. Pick the one that matches your discount rate.
- Terminal value typically represents 60–80% of total value. Use Gordon Growth with growth ≤ nominal GDP, or an exit multiple.
- Sensitivity analysis is mandatory: ±0.5% in the discount rate or ±0.25% in growth can shift valuation by 15–30%.
A DCF calculator takes three inputs — projected cash flows, a discount rate, and a terminal value assumption — and outputs a present-value estimate. It does not create value; it reveals whether the market price is consistent with your assumptions about growth, margins, and cost of capital.
The method is widely used in investment finance, corporate financial management, real estate development, and patent valuation Discounted cash flow. Unlike a P/E ratio, which compresses price and earnings into a single number, a DCF forces you to model revenue drivers, reinvestment needs, and capital structure explicitly P/E ratio.
Step 1: Choose FCFF or FCFE
| Cash Flow Type | Priced by | Discount Rate | Best For |
|---|---|---|---|
| FCFF (Free Cash Flow to Firm) | Debt + equity holders | WACC | Companies with changing capital structure |
| FCFE (Free Cash Flow to Equity) | Equity holders only | Cost of equity (Ke) | Stable debt, or direct equity valuation |
FCFF formula: EBIT × (1 − Tax Rate) + Depreciation & Amortization − CapEx − Change in Working Capital.
FCFE formula: Net Income + Depreciation & Amortization − CapEx − Change in Working Capital + Net Borrowing.
If a company's debt-to-equity ratio is expected to shift significantly, use FCFF with WACC. If capital structure is stable, FCFE with Ke is simpler and equally valid.
Step 2: Project Free Cash Flow (5–10 Years)
Build a bottom-up projection. Start with revenue drivers — unit volume × price for a manufacturer, occupancy × rent per square meter for a real estate fund — then work down to cash flow.
| Year | Revenue | EBIT | NOPAT | D&A | CapEx | ΔWorking Cap | FCFF |
|---|---|---|---|---|---|---|---|
| 2025 | $1,000 | $150 | $99 | $50 | ($80) | ($20) | $49 |
| 2026 | $1,100 | $175 | $116 | $55 | ($90) | ($15) | $66 |
| 2027 | $1,210 | $195 | $129 | $60 | ($100) | ($10) | $79 |
| 2028 | $1,331 | $215 | $142 | $65 | ($110) | ($5) | $92 |
| 2029 | $1,464 | $235 | $155 | $70 | ($115) | $0 | $110 |
NOPAT = EBIT × (1 − Tax Rate). In the example above, the tax rate is 34%.
Revenue growth should slow each year as the business approaches maturity. A 10% growth rate in year one might drop to 5% by year five, then flatten to a terminal rate.
Step 3: Calculate the Discount Rate
Cost of Equity (Ke) — CAPM
The most common approach is the Capital Asset Pricing Model:
| Component | Source | Example |
|---|---|---|
| Risk-Free Rate (Rf) | 10-year government bond | 4.2% (US Treasury) |
| Beta (β) | 5-year regression vs. market | 1.15 |
| Equity Risk Premium (ERP) | Historical market excess return | 5.0% |
| Country Risk Premium | CDS spread or Damodaran data | 1.5% (emerging markets) |
Example: Ke = 4.2% + 1.15 × 5.0% + 1.5% = 12.3%.
Beta measures how much a stock moves relative to the broader market. A beta of 1.15 means the stock tends to move 15% more than the market in either direction Price–earnings ratio.
Cost of Debt (Kd)
Use the yield-to-maturity on existing debt or the current borrowing rate. Adjust for taxes:
If a company borrows at 7% and faces a 25% tax rate, the after-tax cost of debt is 5.25%.
WACC
Where E = market value of equity, D = market value of debt.
Using the example above: Ke = 12.3%, Kd(after-tax) = 5.25%, equity weight = 70%, debt weight = 30%.
WACC = 12.3% × 0.70 + 5.25% × 0.30 = 9.7%.
Step 4: Calculate Terminal Value
Terminal value captures all cash flows beyond the explicit forecast period. It typically accounts for 60–80% of total enterprise value and is highly sensitive to growth and discount rate assumptions Discounted cash flow.
Method A: Gordon Growth (Perpetual Growth)
Where g is the perpetual growth rate. Use a conservative g — typically the long-term inflation rate or nominal GDP growth (2–4% for developed markets).
Example: FCFF₂₀₂₉ = $110; g = 3.0%; WACC = 9.7%.
Terminal Value = $110 × 1.03 / (0.097 − 0.03) = $1,783.
Method B: Exit Multiple
Use a sector-appropriate multiple. If the industry trades at 10× EV/EBITDA and year-5 EBITDA is $250:
Terminal Value = $250 × 10 = $2,500.
Cross-check both methods. If they diverge by more than 20%, revisit your assumptions.
Step 5: Discount and Sum
Discount each projected FCFF and the terminal value back to present:
| Year | FCFF | Discount Factor @ 9.7% | Present Value |
|---|---|---|---|
| 2025 | $49 | 0.912 | $45 |
| 2026 | $66 | 0.832 | $55 |
| 2027 | $79 | 0.759 | $60 |
| 2028 | $92 | 0.692 | $64 |
| 2029 | $110 | 0.631 | $69 |
| Terminal | $1,783 | 0.631 | $1,125 |
| Enterprise Value | $1,418 |
Convert to equity value:
If net debt is $400 and non-operating assets are $50:
Equity Value = $1,418 − $400 + $50 = $1,068.
Divide by diluted shares outstanding to get a per-share target price.
Step 6: Sensitivity Analysis
Vary the two most impactful inputs — discount rate and terminal growth — in a matrix:
| Target Price ($) | WACC 8.7% | WACC 9.7% | WACC 10.7% |
|---|---|---|---|
| g = 2.0% | $14.20 | $11.80 | $10.05 |
| g = 3.0% | $16.50 | $13.60 | $11.55 |
| g = 4.0% | $19.40 | $15.90 | $13.40 |
A ±1% move in WACC shifts valuation by roughly 15–20%. A ±1% move in g shifts it by 10–15%. Document the range, not a single point.
Cross-Check with Market Multiples
A DCF output should be validated against market comparables. If your DCF implies a P/E of 25× but the sector trades at 15×, investigate the gap.
| Metric | Your DCF Implied | Sector Median | Interpretation |
|---|---|---|---|
| P/E Ratio | 22× | 16× | Market expects lower growth |
| P/B Ratio | 3.5× | 2.8× | Slight premium justified |
| ROE | 18% | 14% | Higher profitability supports premium |
| Dividend Yield | 2.1% | 3.0% | Lower payout, more reinvestment |
The P/E ratio can be interpreted as the number of years of current earnings needed to recoup the share price. A P/E of 16 means the market expects roughly 16 years of earnings at current levels to equal the price paid Price–earnings ratio. ROE is a key driver of sustainable growth: g = ROE × retention ratio. A company with 18% ROE and a 50% payout ratio can grow earnings at roughly 9% organically Return on equity ROE explained.
Dividend yield measures annual dividends relative to share price. A 2.1% yield means $2.10 in dividends per $100 of price. High yields can signal undervaluation or a coming dividend cut — a pattern known as a "yield trap" Dividend yield Dividend yield guide.
Stocks represent ownership in a company and offer potential for capital appreciation and dividend income, but prices fluctuate and losses are possible Stocks.
Common Errors and Fixes
| Error | Cause | Fix | Source |
|---|---|---|---|
| Using P/E alone for valuation | Compresses too much into one ratio | DCF as primary; multiples as sanity check | Price–earnings ratio |
| Projecting revenue with a flat % | Ignores operational drivers | Build bottom-up: volume × price | Discounted cash flow |
| WACC nominal with real FCFF | Inflates or deflates value 20–40% | Match: both nominal or both real | Discounted cash flow |
| Terminal growth > WACC | Produces infinite or negative value | Cap g at nominal GDP (2–4%) | Discounted cash flow |
| Ignoring maintenance CapEx | Overstates perpetual FCF | In terminal, CapEx ≈ D&A | Discounted cash flow |
| Beta not relevered | Different from target capital structure | βₑ = βₐ × [1 + (1 − Tax) × D/E target] | Return on equity |
| Forgetting diluted shares | Dilutes target price 5–15% | Use fully diluted share count | Stocks |
| No sensitivity analysis | Single point is misleading | Run WACC × g matrix (minimum 3×3) | Discounted cash flow |
| Mixing dividend yield with total return | Yield ignores price changes | Use total return for full picture | Dividend yield |
FAQ
What is a DCF calculator? A DCF calculator projects future free cash flows and discounts them to present value using a rate that reflects risk. The sum of discounted cash flows plus terminal value gives an estimate of intrinsic worth.
FCFF or FCFE — which should I use? Use FCFF when capital structure is expected to change; discount with WACC. Use FCFE when debt is stable; discount with cost of equity. FCFF values the entire firm; FCFE values equity directly.
How do I pick the perpetual growth rate? Use long-term inflation or nominal GDP growth — typically 2–4% for developed markets. Never set g above WACC; the formula breaks mathematically.
Why does terminal value dominate DCF results? Terminal value often represents 60–80% of total enterprise value because it captures decades of cash flows beyond the explicit forecast. Small changes in g or WACC produce large swings.
How do I validate a DCF output? Cross-check with sector P/E, P/B, EV/EBITDA, and ROE. If your DCF implies a multiple far from the sector median, revisit your growth or margin assumptions.
Can I use DCF for companies with negative cash flow? Yes, but projections become highly speculative. Extend the explicit forecast to 10–15 years until the company reaches positive FCF, and use a higher discount rate to reflect risk.
What is the difference between dividend yield and DCF? Dividend yield measures current income relative to price. DCF values the entire cash flow stream, including reinvested earnings. A low-yield growth stock can have a high DCF value if reinvestment generates strong future cash flows.
How often should I update a DCF model? Update whenever material inputs change: earnings reports, interest rate shifts, M&A activity, or changes in the competitive landscape. A static DCF becomes stale within a quarter for most companies.
Sources
- Discounted cash flow — Core methodology: NPV formula, WACC, CAPM, terminal value, and historical context.
- Price–earnings ratio — P/E interpretation, historical S&P 500 averages (~14–16×), and cross-check methodology.
- Return on equity — ROE as a growth driver (g = ROE × retention) and DuPont decomposition framework.
- Stocks — SEC investor education on equity ownership, capital appreciation, and risk factors.
- Dividend yield — Yield trap warning, trailing vs. forward yield conventions, and relationship to total return.