Interactive models with editable assumptions. All calculations run client-side.
Valuation Summary
Model
Intrinsic Value
vs Price ($63.26)
DCF
$27223064201.00
+43033613875.7%
Graham Number
—
—
Reverse DCF
—
implied g: -15.8%
DDM
$77.25
+22.1%
EV/EBITDA
$35043559304.70
+55396078472.1%
Values reflect default assumptions. Adjust inputs in each model below to update.
1 — Discounted Cash Flow (DCF)
Assumptions
Yahoo: $996.41M
Rev: 15.6% / EPS: —
Default: 9% (no SEC data)
Results
Intrinsic Value / share$27223064201.00
Current Price$63.26
Upside / Downside+43033613875.7%
Net Debt (used)$5.15B
Sensitivity: WACC (rows) × Near-term g (cols)
WACC \ Near-term
7.6%
11.6%
15.6%
19.6%
23.6%
7.0%
$29377220812.62
$35872671668.69
$43338624606.97
$51881505581.96
$61615294226.04
8.0%
$22696467543.29
$27862103025.79
$33794002681.68
$40575894120.80
$48297434898.47
9.0%
$18093731090.88
$22345355375.85
$27223064201.00
$32795019571.07
$39134200592.22
10.0%
$14736260287.21
$18322957778.78
$22433924729.07
$27126028648.40
$32460147190.66
11.0%
$12183310679.51
$15265931668.52
$18795774035.38
$22821167524.70
$27393842467.32
2 — Graham Number
Assumptions
Graham used 22.5 (15× P/E × 1.5× P/B)
Yahoo: —
Yahoo: $12.12
Results
Graham Number requires positive EPS and positive Book Value per share. EPS is zero or negative.
Graham Number—
Current Price$63.26
Margin of Safety—
Formula: √(22.5 × max(0,EPS) × max(0,BVPS))
3 — Reverse DCF (Implied Growth)
Assumptions
Default: 9% (no SEC data)
Results
Current Price$63.26
Implied Near-term FCF Growth-15.8%
Historical Revenue Growth15.6%
Historical Earnings Growth—
Base FCF (TTM)$996.41M
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: $3.75
Results
DDM Intrinsic Value / share$77.25
Current Price$63.26
Upside / Downside+22.1%
Formula: D0 × (1+g) / (r − g)
5 — EV/EBITDA Multiple
Assumptions
Yahoo: $979.90M
Current: 41.0×
Default: $5.15B
Results
Implied Equity Value / share$35043559304.70
Current Price$63.26
Upside / Downside+55396078472.1%
Implied EV$40.20B
Sensitivity: EV/EBITDA multiple (rows) × Net Debt (cols)