Assumptions
DCF Methodology Reference ▼
Free Cash Flow
FCF = EBIT × (1 − Tax Rate)
+ D&A − CapEx − ΔNWC
NOPAT + non-cash add-back − reinvestment.
Cost of Equity (CAPM)
CoE = Risk-Free Rate
+ Beta × Equity Risk Premium
Required return given systematic risk.
WACC
WACC = (E/(D+E)) × CoE
+ (D/(D+E)) × After-Tax CoD
After-Tax CoD = Pre-Tax CoD × (1−Tax)
Weighted average of equity and debt costs.
Terminal Value
TV = Final FCF × (1 + g) / (WACC − g) Condition: g < WACC
Gordon Growth Model beyond the forecast horizon.
Enterprise Value
EV = Σ FCFₜ/(1+WACC)^(t−0.5) + TV/(1+WACC)^(N−0.5)
Mid-year convention applied to all cash flows.
Equity Bridge & Upside
Equity Value = EV − Debt + Cash Target Price = Equity Value / Shares Upside = (Target − Price) / Price × 100
Bridge from EV to per-share intrinsic value.
CAPM / WACC Breakdown
Cost of Equity (CAPM)–
After-Tax Cost of Debt–
Market Cap ($M)–
Net Debt ($M)–
Equity Weight–
Debt Weight–
WACC–
DCF Projection Schedule (mid-year discounting)
| Year | Revenue | EBIT | NOPAT | D&A | CapEx | ΔNWC | FCF | Disc. Factor | PV FCF |
|---|
DCF Valuation Summary
Sum PV of FCFs ($M)–
Terminal FCF ($M)–
Terminal Value ($M)–
PV of Terminal Value ($M)–
Enterprise Value ($M)–
Equity Value ($M)–
DCF Implied Price–
TV % of EV–
Upside / Downside–
Valuation Signal–
Residual Income Model (RIM)
Total Book Value ($M)–
Projected NI Year 1 ($M)–
Residual Income Year 1 ($M)–
PV of Residual Incomes ($M)–
RIM Implied Price–
Formula: BV₀ + PV(RI) where RI₁ = NI₁ − BV₀ × Cost of Equity. Less sensitive to terminal value than DCF (~72% anchored on book value).
Abnormal Earnings Growth (AEG)
NI Year 1 ($M)–
NI Year 2 ($M)–
Reinvestment Benchmark ($M)–
AEG Year 2 ($M)–
AEG₂ = NI₂ − [NI₁ + r × (NI₁ − Div₁)]. Positive = company earns more on retained earnings than its cost of equity.
Market Multiples
| Multiple | Value | Formula | Industry Fit |
|---|
Scenario Comparison
Calculate and save up to 3 scenarios to compare them here.
| Ticker | Price | DCF Price | Upside / Down | WACC | TV % EV | Main Multiple | Signal |
|---|