Interactive models with editable assumptions. All calculations run client-side.
Valuation Summary
Model
Intrinsic Value
vs Price ($77.78)
DCF
$-336.84
-533.1%
Graham Number
$18.40
-76.3%
Reverse DCF
—
—
DDM
—
—
EV/EBITDA
$1944.66
+2400.2%
Values reflect default assumptions. Adjust inputs in each model below to update.
1 — Discounted Cash Flow (DCF)
Assumptions
Yahoo: -$756.90M
Rev: 9.4% / EPS: -81.8%
Default: 9% (no SEC data)
Results
Intrinsic Value / share$-336.84
Current Price$77.78
Upside / Downside-533.1%
Net Debt (used)$915.00M
Sensitivity: WACC (rows) × Near-term g (cols)
WACC \ Near-term
1.4%
5.4%
9.4%
13.4%
17.4%
7.0%
$-347.52
$-412.44
$-487.59
$-574.13
$-673.36
8.0%
$-286.36
$-338.33
$-398.41
$-467.53
$-546.70
9.0%
$-244.09
$-287.14
$-336.84
$-393.97
$-459.32
10.0%
$-213.15
$-249.69
$-291.83
$-340.21
$-395.50
11.0%
$-189.54
$-221.13
$-257.52
$-299.25
$-346.91
2 — Graham Number
Assumptions
Graham used 22.5 (15× P/E × 1.5× P/B)
Yahoo: $5.96
Yahoo: $2.52
Results
Graham Number$18.40
Current Price$77.78
Margin of Safety-76.3%
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$77.78
Implied Near-term FCF Growth—
Historical Revenue Growth9.4%
Historical Earnings Growth-81.8%
Base FCF (TTM)-$756.90M
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: —
Results
This company does not pay a dividend. DDM is not applicable — the intrinsic value shown uses D0 = $0 unless you enter a hypothetical dividend above.
DDM Intrinsic Value / share—
Current Price$77.78
Upside / Downside—
Formula: D0 × (1+g) / (r − g)
5 — EV/EBITDA Multiple
Assumptions
Yahoo: $606.96M
Current: 173.7×
Default: $915.00M
Results
Implied Equity Value / share$1944.66
Current Price$77.78
Upside / Downside+2400.2%
Implied EV$105.43B
Sensitivity: EV/EBITDA multiple (rows) × Net Debt (cols)