Interactive models with editable assumptions. All calculations run client-side.
Valuation Summary
Model
Intrinsic Value
vs Price ($17.51)
DCF
$-1978271288030.13
-11297951388050.5%
Graham Number
$83.06
+374.4%
Reverse DCF
—
—
DDM
$23.48
+34.1%
EV/EBITDA
$7037989719.04
+40194115942.5%
Values reflect default assumptions. Adjust inputs in each model below to update.
1 — Discounted Cash Flow (DCF)
Assumptions
Yahoo: -$17.00B
Rev: 8.5% / EPS: 38.8%
Default: 9% (no SEC data)
Results
Intrinsic Value / share$-1978271288030.13
Current Price$17.51
Upside / Downside-11297951388050.5%
Net Debt (used)-$797.00M
Sensitivity: WACC (rows) × Near-term g (cols)
WACC \ Near-term
30.8%
34.8%
38.8%
42.8%
46.8%
7.0%
$-2316279548972.32
$-2684199037719.75
$-3097896731374.34
$-3561538994061.50
$-4079538210148.73
8.0%
$-1821774048236.55
$-2109491235833.23
$-2432895267175.23
$-2795228426851.81
$-3199924240265.85
9.0%
$-1483625877265.32
$-1716550239473.09
$-1978271288030.13
$-2271400617230.27
$-2598703685463.76
10.0%
$-1238996533493.77
$-1432323569742.47
$-1649471341382.20
$-1892596175811.41
$-2163981292658.50
11.0%
$-1054642630114.63
$-1218164463421.52
$-1401764453701.80
$-1607256680561.23
$-1836561846965.27
2 — Graham Number
Assumptions
Graham used 22.5 (15× P/E × 1.5× P/B)
Yahoo: $4.69
Yahoo: $65.37
Results
Graham Number$83.06
Current Price$17.51
Margin of Safety+374.4%
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$17.51
Implied Near-term FCF Growth—
Historical Revenue Growth8.5%
Historical Earnings Growth38.8%
Base FCF (TTM)-$17.00B
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.14
Results
DDM Intrinsic Value / share$23.48
Current Price$17.51
Upside / Downside+34.1%
Formula: D0 × (1+g) / (r − g)
5 — EV/EBITDA Multiple
Assumptions
Yahoo: $5.52B
Current: 1.1×
Default: -$797.00M
Results
Implied Equity Value / share$7037989719.04
Current Price$17.51
Upside / Downside+40194115942.5%
Implied EV$6.24B
Sensitivity: EV/EBITDA multiple (rows) × Net Debt (cols)