Interactive models with editable assumptions. All calculations run client-side.
Valuation Summary
Model
Intrinsic Value
vs Price ($20.70)
DCF
$52534192078.46
+253788367428.8%
Graham Number
$83.82
+304.9%
Reverse DCF
—
implied g: -7.1%
DDM
$26.78
+29.4%
EV/EBITDA
$9764122048.00
+47169671629.5%
Values reflect default assumptions. Adjust inputs in each model below to update.
1 — Discounted Cash Flow (DCF)
Assumptions
Yahoo: $1.96B
Rev: 17.1% / EPS: -53.4%
Default: 9% (no SEC data)
Results
Intrinsic Value / share$52653069335.80
Current Price$20.70
Upside / Downside+254362653696.1%
Net Debt (used)$16.80B
Sensitivity: WACC (rows) × Near-term g (cols)
WACC \ Near-term
9.1%
13.1%
17.1%
21.1%
25.1%
7.0%
$57818012161.22
$71704763342.05
$87640830053.43
$105848046967.85
$126563792181.89
8.0%
$43242833488.54
$54270050021.00
$66913554405.56
$81347710278.25
$97759073578.17
9.0%
$33208157877.57
$42271007913.30
$52653069335.80
$64496165214.07
$77952015051.16
10.0%
$25893943498.22
$33528591533.06
$42266784888.42
$52226745370.60
$63534927090.77
11.0%
$20336946391.76
$26889565929.11
$34382612156.79
$42916474481.53
$52598518113.23
2 — Graham Number
Assumptions
Graham used 22.5 (15× P/E × 1.5× P/B)
Yahoo: $4.83
Yahoo: $64.60
Results
Graham Number$83.82
Current Price$20.70
Margin of Safety+304.9%
Formula: √(22.5 × max(0,EPS) × max(0,BVPS))
3 — Reverse DCF (Implied Growth)
Assumptions
Default: 9% (no SEC data)
Results
Current Price$20.70
Implied Near-term FCF Growth-7.1%
Historical Revenue Growth17.1%
Historical Earnings Growth-53.4%
Base FCF (TTM)$1.96B
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.30
Results
DDM Intrinsic Value / share$26.78
Current Price$20.70
Upside / Downside+29.4%
Formula: D0 × (1+g) / (r − g)
5 — EV/EBITDA Multiple
Assumptions
Yahoo: $2.78B
Current: 9.6×
Default: $16.80B
Results
Implied Equity Value / share$9764122048.00
Current Price$20.70
Upside / Downside+47169671629.5%
Implied EV$26.56B
Sensitivity: EV/EBITDA multiple (rows) × Net Debt (cols)