Interactive models with editable assumptions. All calculations run client-side.
Valuation Summary
Model
Intrinsic Value
vs Price ($34.95)
DCF
$221.77
+534.5%
Graham Number
$32.73
-6.3%
Reverse DCF
—
implied g: -20.0%
DDM
$26.99
-22.8%
EV/EBITDA
$37.95
+8.6%
Values reflect default assumptions. Adjust inputs in each model below to update.
1 — Discounted Cash Flow (DCF)
Assumptions
Yahoo: $20.80B
Rev: -34.9% / EPS: -6.1%
Default: 9% (no SEC data)
Results
Intrinsic Value / share$221.77
Current Price$34.95
Upside / Downside+534.5%
Net Debt (used)-$6.73B
Sensitivity: WACC (rows) × Near-term g (cols)
WACC \ Near-term
-3.0%
1.0%
5.0%
9.0%
13.0%
7.0%
$223.64
$268.05
$319.72
$379.52
$448.40
8.0%
$184.56
$220.30
$261.83
$309.82
$365.04
9.0%
$157.48
$187.24
$221.77
$261.62
$307.41
10.0%
$137.60
$162.99
$192.40
$226.30
$265.21
11.0%
$122.38
$144.44
$169.95
$199.33
$233.00
2 — Graham Number
Assumptions
Graham used 22.5 (15× P/E × 1.5× P/B)
Yahoo: $2.25
Yahoo: $21.17
Results
Graham Number$32.73
Current Price$34.95
Margin of Safety-6.3%
Formula: √(22.5 × max(0,EPS) × max(0,BVPS))
3 — Reverse DCF (Implied Growth)
Assumptions
Default: 9% (no SEC data)
Results
Current Price$34.95
Implied Near-term FCF Growth-20.0%
Historical Revenue Growth-34.9%
Historical Earnings Growth-6.1%
Base FCF (TTM)$20.80B
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.31
Results
DDM Intrinsic Value / share$26.99
Current Price$34.95
Upside / Downside-22.8%
Formula: D0 × (1+g) / (r − g)
5 — EV/EBITDA Multiple
Assumptions
Yahoo: $9.29B
Current: 6.1×
Default: -$6.73B
Results
Implied Equity Value / share$37.95
Current Price$34.95
Upside / Downside+8.6%
Implied EV$56.89B
Sensitivity: EV/EBITDA multiple (rows) × Net Debt (cols)