Interactive models with editable assumptions. All calculations run client-side.
Valuation Summary
Model
Intrinsic Value
vs Price ($27.32)
DCF
$-68198159062.68
-249626315752.9%
Graham Number
—
—
Reverse DCF
—
—
DDM
$48.82
+78.7%
EV/EBITDA
$2802032912.13
+10256305375.2%
Values reflect default assumptions. Adjust inputs in each model below to update.
1 — Discounted Cash Flow (DCF)
Assumptions
Yahoo: -$772.45M
Rev: 32.7% / EPS: 29.8%
Default: 9% (no SEC data)
Results
Intrinsic Value / share$-68312224261.16
Current Price$27.32
Upside / Downside-250043829592.4%
Net Debt (used)$3.20B
Sensitivity: WACC (rows) × Near-term g (cols)
WACC \ Near-term
24.7%
28.7%
32.7%
36.7%
40.7%
7.0%
$-77848086381.60
$-90238700176.65
$-104243635732.61
$-120016755131.75
$-137721427714.10
8.0%
$-62206158723.80
$-71929362426.07
$-82914474293.88
$-95281516946.57
$-109157919559.26
9.0%
$-51494032005.20
$-59392618358.70
$-68312224261.16
$-78349752866.34
$-89608079148.84
10.0%
$-43731636783.76
$-50309798756.27
$-57734802154.26
$-66086842432.67
$-75451050428.93
11.0%
$-37871360292.92
$-43454149538.12
$-49752603258.17
$-56834341719.45
$-64771140820.29
2 — Graham Number
Assumptions
Graham used 22.5 (15× P/E × 1.5× P/B)
Yahoo: —
Yahoo: $3.26
Results
Graham Number requires positive EPS and positive Book Value per share. EPS is zero or negative.
Graham Number—
Current Price$27.32
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$27.32
Implied Near-term FCF Growth—
Historical Revenue Growth32.7%
Historical Earnings Growth29.8%
Base FCF (TTM)-$772.45M
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.37
Results
DDM Intrinsic Value / share$48.82
Current Price$27.32
Upside / Downside+78.7%
Formula: D0 × (1+g) / (r − g)
5 — EV/EBITDA Multiple
Assumptions
Yahoo: $1.00B
Current: 6.0×
Default: $3.20B
Results
Implied Equity Value / share$2802032912.13
Current Price$27.32
Upside / Downside+10256305375.2%
Implied EV$6.00B
Sensitivity: EV/EBITDA multiple (rows) × Net Debt (cols)