Educational article

DCF Calculator: Discounted Cash Flow Valuation

Learn DCF valuation step by step: project cash flows, calculate WACC, estimate terminal value, and build a sensitivity analysis.

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 TypePriced byDiscount RateBest For
FCFF (Free Cash Flow to Firm)Debt + equity holdersWACCCompanies with changing capital structure
FCFE (Free Cash Flow to Equity)Equity holders onlyCost 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.

YearRevenueEBITNOPATD&ACapExΔWorking CapFCFF
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:

Formula
Ke = Risk-Free Rate + β × Equity Risk Premium + Country Risk Premium
ComponentSourceExample
Risk-Free Rate (Rf)10-year government bond4.2% (US Treasury)
Beta (β)5-year regression vs. market1.15
Equity Risk Premium (ERP)Historical market excess return5.0%
Country Risk PremiumCDS spread or Damodaran data1.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:

Formula
After-tax Kd = Pre-tax Kd × (1 − Tax Rate)

If a company borrows at 7% and faces a 25% tax rate, the after-tax cost of debt is 5.25%.

WACC

Formula
WACC = Ke × (E / (D + E)) + Kd × (1 − Tax Rate) × (D / (D + E))

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)

Formula
Terminal Value = FCFFₙ₊₁ / (WACC − g)

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

Formula
Terminal Value = EBITDAₙ × (EV/EBITDA 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:

YearFCFFDiscount Factor @ 9.7%Present Value
2025$490.912$45
2026$660.832$55
2027$790.759$60
2028$920.692$64
2029$1100.631$69
Terminal$1,7830.631$1,125
Enterprise Value$1,418

Convert to equity value:

Formula
Equity Value = Enterprise Value − Net Debt + Non-Operating Assets

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.

MetricYour DCF ImpliedSector MedianInterpretation
P/E Ratio22×16×Market expects lower growth
P/B Ratio3.5×2.8×Slight premium justified
ROE18%14%Higher profitability supports premium
Dividend Yield2.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

ErrorCauseFixSource
Using P/E alone for valuationCompresses too much into one ratioDCF as primary; multiples as sanity checkPrice–earnings ratio
Projecting revenue with a flat %Ignores operational driversBuild bottom-up: volume × priceDiscounted cash flow
WACC nominal with real FCFFInflates or deflates value 20–40%Match: both nominal or both realDiscounted cash flow
Terminal growth > WACCProduces infinite or negative valueCap g at nominal GDP (2–4%)Discounted cash flow
Ignoring maintenance CapExOverstates perpetual FCFIn terminal, CapEx ≈ D&ADiscounted cash flow
Beta not releveredDifferent from target capital structureβₑ = βₐ × [1 + (1 − Tax) × D/E target]Return on equity
Forgetting diluted sharesDilutes target price 5–15%Use fully diluted share countStocks
No sensitivity analysisSingle point is misleadingRun WACC × g matrix (minimum 3×3)Discounted cash flow
Mixing dividend yield with total returnYield ignores price changesUse total return for full pictureDividend 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.
FundamentalRadar · educational information, not investment advice.