Intrinsic Value (FCF DCF)
DIY DCF: project FCF, add terminal value, discount back, convert EV → Equity → Intrinsic per share.
High
Bucket uses ±10% vs market price.
DIY Inputs (FCF DCF)
Tip: Keep units consistent. If you input FCF in billions, also input Net Debt in billions.
Scale: in billions
Quick sanity checks
- Use the same scale for FCF and Net Debt (numbers vs millions vs billions).
- Discount rate should usually be greater than long-run growth; terminal multiple should be realistic.
- If results look absurd, check shares and scaling first.
Intrinsic value per share
$109
Equity Value / diluted shares
Over/Undervalued
-55.5%
(Intrinsic / Price) - 1
PV of forecast FCFs
$448,028,090,083
Sum of discounted FCFs (years 1..N)
PV of terminal value
$1,246,399,194,292
Discounted terminal value at year N
Enterprise value (EV)
$1,694,427,284,376
PV forecast + PV terminal
Equity value
$1,694,427,284,376
EV − Net Debt
Valuation range
Fair band: ±10% around Intrinsic
Intrinsic
Price
LowFairHigh
Low boundary
98.39
Intrinsic
109.32
High boundary
120.25
The bar is visualized over ±30% around Intrinsic (for readability).
DCF projection table
FCF is projected with constant growth during the forecast period.
| Year | FCF | Discount factor | PV(FCF) |
|---|---|---|---|
| 1 | $106,000,000,000 | 0.9091 | $96,363,636,364 |
| 2 | $112,360,000,000 | 0.8264 | $92,859,504,132 |
| 3 | $119,101,600,000 | 0.7513 | $89,482,794,891 |
| 4 | $126,247,696,000 | 0.6830 | $86,228,875,077 |
| 5 | $133,822,557,760 | 0.6209 | $83,093,279,619 |
| Terminal Value (undiscounted) | $2,007,338,366,400 | ||
Disclaimer: This tool is for informational purposes only and does not constitute investment advice.