Interactive models with editable assumptions. All calculations run client-side.
Valuation Summary
Model
Intrinsic Value
vs Price ($42.82)
DCF
$-7537804375.77
-17603466647.8%
Graham Number
$25.38
-40.7%
Reverse DCF
—
—
DDM
$9.06
-78.8%
EV/EBITDA
$43.68
+2.0%
Values reflect default assumptions. Adjust inputs in each model below to update.
1 — Discounted Cash Flow (DCF)
Assumptions
Yahoo: -$149.62M
Rev: 108.1% / EPS: 1041.2%
Default: 9% (no SEC data)
Results
Intrinsic Value / share$-7537804375.77
Current Price$42.82
Upside / Downside-17603466647.8%
Net Debt (used)$179.83M
Sensitivity: WACC (rows) × Near-term g (cols)
WACC \ Near-term
1033.2%
1037.2%
1041.2%
1045.2%
1049.2%
7.0%
$-12369720730.35
$-12589582248.80
$-12812558997.55
$-13038683964.87
$-13267990371.08
8.0%
$-9326018038.75
$-9491780261.45
$-9659891178.37
$-9830375660.67
$-10003258754.44
9.0%
$-7277276564.76
$-7406624104.04
$-7537804375.77
$-7670836787.41
$-7805740882.91
10.0%
$-5820696009.70
$-5924154035.86
$-6029077964.47
$-6135483318.47
$-6243385730.02
11.0%
$-4743467197.68
$-4827778374.03
$-4913284159.99
$-4999997205.72
$-5087930250.33
2 — Graham Number
Assumptions
Graham used 22.5 (15× P/E × 1.5× P/B)
Yahoo: $1.79
Yahoo: $15.99
Results
Graham Number$25.38
Current Price$42.82
Margin of Safety-40.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$42.82
Implied Near-term FCF Growth—
Historical Revenue Growth108.1%
Historical Earnings Growth1041.2%
Base FCF (TTM)-$149.62M
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: $0.44
Results
DDM Intrinsic Value / share$9.06
Current Price$42.82
Upside / Downside-78.8%
Formula: D0 × (1+g) / (r − g)
5 — EV/EBITDA Multiple
Assumptions
Yahoo: $762.84M
Current: 14.8×
Default: $179.83M
Results
Implied Equity Value / share$43.68
Current Price$42.82
Upside / Downside+2.0%
Implied EV$11.26B
Sensitivity: EV/EBITDA multiple (rows) × Net Debt (cols)