Interactive models with editable assumptions. All calculations run client-side.
Valuation Summary
Model
Intrinsic Value
vs Price ($17.69)
DCF
$-4608919768.00
-26053814503.6%
Graham Number
$25.24
+42.7%
Reverse DCF
—
—
DDM
$33.58
+89.8%
EV/EBITDA
—
—
Values reflect default assumptions. Adjust inputs in each model below to update.
1 — Discounted Cash Flow (DCF)
Assumptions
Yahoo: —
Rev: — / EPS: —
Default: 9% (no SEC data)
Results
Intrinsic Value / share$-4608919768.00
Current Price$17.69
Upside / Downside-26053814503.6%
Net Debt (used)$4.61B
Sensitivity: WACC (rows) × Near-term g (cols)
WACC \ Near-term
-3.0%
1.0%
5.0%
9.0%
13.0%
7.0%
$-4608919768.00
$-4608919768.00
$-4608919768.00
$-4608919768.00
$-4608919768.00
8.0%
$-4608919768.00
$-4608919768.00
$-4608919768.00
$-4608919768.00
$-4608919768.00
9.0%
$-4608919768.00
$-4608919768.00
$-4608919768.00
$-4608919768.00
$-4608919768.00
10.0%
$-4608919768.00
$-4608919768.00
$-4608919768.00
$-4608919768.00
$-4608919768.00
11.0%
$-4608919768.00
$-4608919768.00
$-4608919768.00
$-4608919768.00
$-4608919768.00
2 — Graham Number
Assumptions
Graham used 22.5 (15× P/E × 1.5× P/B)
Yahoo: $2.13
Yahoo: $13.27
Results
Graham Number$25.24
Current Price$17.69
Margin of Safety+42.7%
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.69
Implied Near-term FCF Growth—
Historical Revenue Growth—
Historical Earnings Growth—
Base FCF (TTM)—
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.