Interactive models with editable assumptions. All calculations run client-side.
Valuation Summary
Model
Intrinsic Value
vs Price ($26.31)
DCF
$161.83
+515.1%
Graham Number
$41.48
+57.7%
Reverse DCF
—
implied g: 7.2%
DDM
$26.37
+0.2%
EV/EBITDA
$30.15
+14.6%
Values reflect default assumptions. Adjust inputs in each model below to update.
1 — Discounted Cash Flow (DCF)
Assumptions
Yahoo: $3.26B
Rev: -0.3% / EPS: 26.1%
Default: 9% (no SEC data)
Results
Intrinsic Value / share$162.18
Current Price$26.31
Upside / Downside+516.4%
Net Debt (used)$40.74B
Sensitivity: WACC (rows) × Near-term g (cols)
WACC \ Near-term
18.1%
22.1%
26.1%
30.1%
34.1%
7.0%
$186.41
$226.50
$272.09
$323.73
$382.01
8.0%
$139.39
$170.99
$206.90
$247.56
$293.42
9.0%
$107.12
$132.90
$162.18
$195.32
$232.68
10.0%
$83.69
$105.25
$129.73
$157.41
$188.61
11.0%
$65.95
$84.33
$105.18
$128.75
$155.29
2 — Graham Number
Assumptions
Graham used 22.5 (15× P/E × 1.5× P/B)
Yahoo: $4.96
Yahoo: $15.42
Results
Graham Number$41.48
Current Price$26.31
Margin of Safety+57.7%
Formula: √(22.5 × max(0,EPS) × max(0,BVPS))
3 — Reverse DCF (Implied Growth)
Assumptions
Default: 9% (no SEC data)
Results
Current Price$26.31
Implied Near-term FCF Growth7.2%
Historical Revenue Growth-0.3%
Historical Earnings Growth26.1%
Base FCF (TTM)$3.26B
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$26.31
Upside / Downside+0.2%
Formula: D0 × (1+g) / (r − g)
5 — EV/EBITDA Multiple
Assumptions
Yahoo: $10.76B
Current: 6.4×
Default: $40.74B
Results
Implied Equity Value / share$30.15
Current Price$26.31
Upside / Downside+14.6%
Implied EV$68.85B
Sensitivity: EV/EBITDA multiple (rows) × Net Debt (cols)