VALUATION DECK DCF Calculator A DCF is used to estimate what a business is worth today based on the cash it could earn in the future.
You map out a reasonable path for free cash flow, discount those future amounts back to today, and add them up.
If the implied value per share is above the current price the stock might be cheap. If it is below you are probably paying for a story that is already priced in.
Inputs use billions for money fields and billions for shares. Price is dollars per share. Keep units consistent across the calculator.
Same units as FCF: billions USD.
Presets
INTRINSIC VALUE PER SHARE
—
Margin of safety: —
Glow guide: good ≥ +20 percent, warn between −10 percent and +20 percent, bad ≤ −10 percent. If r ≤ g the model halts.
Projected FCF (billions)
Compare scenarios
Uses current Price, FCF₀, Shares, Net debt, and Years; applies the three preset paths.
| Scenario | Growth path (%) | r (%) | g (%) | Intrinsic $/share | Margin of safety |
|---|
Method summary
FCFₜ = FCF₀ × ∏(1 + growthₖ). PVₜ = FCFₜ / (1 + r)ᵗ. Terminal at N: TV = FCFₙ₊₁ / (r − g), with FCFₙ₊₁ = FCFₙ × (1 + g). DCF = Σ PVₜ + TV/(1 + r)ᴺ. Equity = DCF − net debt. Intrinsic/share = Equity ÷ shares. MOS = (Intrinsic − Price) ÷ Price.
To Be Added
