Interactive models with editable assumptions. All calculations run client-side.
Valuation Summary
Model
Intrinsic Value
vs Price ($118.81)
DCF
$143.07
+20.4%
Graham Number
$59.92
-49.6%
Reverse DCF
—
implied g: 2.0%
DDM
$53.15
-55.3%
EV/EBITDA
$118.81
-0.0%
Values reflect default assumptions. Adjust inputs in each model below to update.
1 — Discounted Cash Flow (DCF)
Assumptions
Yahoo: $4.12B
Rev: -10.3% / EPS: -58.0%
Default: 9% (no SEC data)
Results
Intrinsic Value / share$143.07
Current Price$118.81
Upside / Downside+20.4%
Net Debt (used)$3.09B
Sensitivity: WACC (rows) × Near-term g (cols)
WACC \ Near-term
-3.0%
1.0%
5.0%
9.0%
13.0%
7.0%
$144.35
$174.84
$210.30
$251.35
$298.62
8.0%
$117.53
$142.07
$170.57
$203.51
$241.41
9.0%
$98.94
$119.37
$143.07
$170.42
$201.85
10.0%
$85.30
$102.73
$122.91
$146.18
$172.89
11.0%
$74.85
$89.99
$107.51
$127.67
$150.78
2 — Graham Number
Assumptions
Graham used 22.5 (15× P/E × 1.5× P/B)
Yahoo: $4.74
Yahoo: $33.66
Results
Graham Number$59.92
Current Price$118.81
Margin of Safety-49.6%
Formula: √(22.5 × max(0,EPS) × max(0,BVPS))
3 — Reverse DCF (Implied Growth)
Assumptions
Default: 9% (no SEC data)
Results
Current Price$118.81
Implied Near-term FCF Growth2.0%
Historical Revenue Growth-10.3%
Historical Earnings Growth-58.0%
Base FCF (TTM)$4.12B
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: $2.58
Results
DDM Intrinsic Value / share$53.15
Current Price$118.81
Upside / Downside-55.3%
Formula: D0 × (1+g) / (r − g)
5 — EV/EBITDA Multiple
Assumptions
Yahoo: $7.02B
Current: 8.6×
Default: $3.09B
Results
Implied Equity Value / share$118.81
Current Price$118.81
Upside / Downside-0.0%
Implied EV$60.55B
Sensitivity: EV/EBITDA multiple (rows) × Net Debt (cols)