Interactive models with editable assumptions. All calculations run client-side.
Valuation Summary
Model
Intrinsic Value
vs Price ($25.66)
DCF
$-68198159062.68
-265795827003.3%
Graham Number
—
—
Reverse DCF
—
—
DDM
$42.64
+66.2%
EV/EBITDA
$2631628143.49
+10256519843.0%
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$25.66
Upside / Downside-266240385246.1%
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: $-3.47
Yahoo: $3.26
Results
Graham Number requires positive EPS and positive Book Value per share. EPS is zero or negative.
Graham Number—
Current Price$25.66
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$25.66
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.07
Results
DDM Intrinsic Value / share$42.64
Current Price$25.66
Upside / Downside+66.2%
Formula: D0 × (1+g) / (r − g)
5 — EV/EBITDA Multiple
Assumptions
Yahoo: $1.00B
Current: 5.8×
Default: $3.20B
Results
Implied Equity Value / share$2631628143.49
Current Price$25.66
Upside / Downside+10256519843.0%
Implied EV$5.83B
Sensitivity: EV/EBITDA multiple (rows) × Net Debt (cols)