Interactive models with editable assumptions. All calculations run client-side.
Valuation Summary
Model
Intrinsic Value
vs Price ($38.94)
DCF
$-45269.74
-116355.1%
Graham Number
$14.65
-62.4%
Reverse DCF
—
—
DDM
$37.49
-3.7%
EV/EBITDA
$105.37
+170.6%
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$-45200.52
Current Price$38.94
Upside / Downside-116177.3%
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%
$-60849.61
$-67209.12
$-74091.12
$-81527.18
$-89550.11
8.0%
$-46722.31
$-51598.73
$-56875.61
$-62577.14
$-68728.46
9.0%
$-37141.36
$-41012.08
$-45200.52
$-49725.86
$-54608.05
10.0%
$-30273.17
$-33423.04
$-36831.33
$-40513.63
$-44486.17
11.0%
$-25148.29
$-27760.36
$-30586.62
$-33639.98
$-36933.87
2 — Graham Number
Assumptions
Graham used 22.5 (15× P/E × 1.5× P/B)
Yahoo: $0.90
Yahoo: $10.61
Results
Graham Number$14.65
Current Price$38.94
Margin of Safety-62.4%
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$38.94
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.82
Results
DDM Intrinsic Value / share$37.49
Current Price$38.94
Upside / Downside-3.7%
Formula: D0 × (1+g) / (r − g)
5 — EV/EBITDA Multiple
Assumptions
Yahoo: $9.82B
Current: 11.2×
Default: $61.30B
Results
Implied Equity Value / share$105.37
Current Price$38.94
Upside / Downside+170.6%
Implied EV$109.90B
Sensitivity: EV/EBITDA multiple (rows) × Net Debt (cols)