Interactive models with editable assumptions. All calculations run client-side.
Valuation Summary
Model
Intrinsic Value
vs Price ($98.56)
DCF
$-64993404847.45
-65942983914.4%
Graham Number
—
—
Reverse DCF
—
—
DDM
$206.00
+109.0%
EV/EBITDA
—
—
Values reflect default assumptions. Adjust inputs in each model below to update.
1 — Discounted Cash Flow (DCF)
Assumptions
Yahoo: -$3.36B
Rev: 1.9% / EPS: —
Default: 9% (no SEC data)
Results
Intrinsic Value / share$-64993404847.45
Current Price$98.56
Upside / Downside-65942983914.4%
Net Debt (used)$5.95B
Sensitivity: WACC (rows) × Near-term g (cols)
WACC \ Near-term
-3.0%
1.0%
5.0%
9.0%
13.0%
7.0%
$-65500668730.65
$-77543923170.91
$-91554839736.08
$-107770907347.21
$-126448164659.03
8.0%
$-54903681068.27
$-64597053138.08
$-75857053042.65
$-88871797891.68
$-103844055111.69
9.0%
$-47560387575.05
$-55631690259.59
$-64993404847.45
$-75799687030.15
$-88216662750.31
10.0%
$-42169588929.91
$-49055318551.26
$-57030074733.48
$-66223288285.98
$-76774410923.21
11.0%
$-38042401063.78
$-44024836976.99
$-50943283695.00
$-58908415681.78
$-68039451040.96
2 — Graham Number
Assumptions
Graham used 22.5 (15× P/E × 1.5× P/B)
Yahoo: —
Yahoo: $141.39
Results
Graham Number requires positive EPS and positive Book Value per share. EPS is zero or negative.
Graham Number—
Current Price$98.56
Margin of Safety—
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$98.56
Implied Near-term FCF Growth—
Historical Revenue Growth1.9%
Historical Earnings Growth—
Base FCF (TTM)-$3.36B
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.