Interactive models with editable assumptions. All calculations run client-side.
Valuation Summary
Model
Intrinsic Value
vs Price ($17.09)
DCF
$-20880229322017.20
-122178053376444.1%
Graham Number
$16.77
-1.9%
Reverse DCF
—
—
DDM
$26.37
+54.3%
EV/EBITDA
$38533809364.99
+225475771491.5%
Values reflect default assumptions. Adjust inputs in each model below to update.
1 — Discounted Cash Flow (DCF)
Assumptions
Yahoo: -$8.25B
Rev: 15.8% / EPS: 106.3%
Default: 9% (no SEC data)
Results
Intrinsic Value / share$-20848302827808.08
Current Price$17.09
Upside / Downside-121991239484056.0%
Net Debt (used)$61.30B
Sensitivity: WACC (rows) × Near-term g (cols)
WACC \ Near-term
98.3%
102.3%
106.3%
110.3%
114.3%
7.0%
$-28066296343836.90
$-30999559154134.23
$-34173814803978.61
$-37603624180114.31
$-41304123376120.25
8.0%
$-21550214978005.31
$-23799415907627.57
$-26233325247524.22
$-28863099755664.58
$-31700336822808.89
9.0%
$-17131094166472.77
$-18916426166183.29
$-20848302827808.08
$-22935572886474.25
$-25187434472756.13
10.0%
$-13963206801561.25
$-15416054135678.73
$-16988094430151.64
$-18686522401548.86
$-20518816781621.93
11.0%
$-11599406931672.92
$-12804199795704.88
$-14107781824482.85
$-15516113977648.64
$-17035392465242.98
2 — Graham Number
Assumptions
Graham used 22.5 (15× P/E × 1.5× P/B)
Yahoo: $1.18
Yahoo: $10.61
Results
Graham Number$16.77
Current Price$17.09
Margin of Safety-1.9%
Formula: √(22.5 × max(0,EPS) × max(0,BVPS))
3 — Reverse DCF (Implied Growth)
Assumptions
Default: 9% (no SEC data)
Results
Reverse DCF requires positive TTM free cash flow.
Current Price$17.09
Implied Near-term FCF Growth—
Historical Revenue Growth15.8%
Historical Earnings Growth106.3%
Base FCF (TTM)-$8.25B
Implied growth is the FCF growth rate (yrs 1–5) that makes the DCF intrinsic value equal the current price. Long-term growth is set to half the implied near-term rate.
4 — Dividend Discount Model (DDM)
Assumptions
Yahoo: $1.28
Results
DDM Intrinsic Value / share$26.37
Current Price$17.09
Upside / Downside+54.3%
Formula: D0 × (1+g) / (r − g)
5 — EV/EBITDA Multiple
Assumptions
Yahoo: $9.82B
Current: 10.2×
Default: $61.30B
Results
Implied Equity Value / share$38533809364.99
Current Price$17.09
Upside / Downside+225475771491.5%
Implied EV$99.83B
Sensitivity: EV/EBITDA multiple (rows) × Net Debt (cols)