Interactive models with editable assumptions. All calculations run client-side.
Valuation Summary
Model
Intrinsic Value
vs Price ($20.48)
DCF
$-561.02
-2839.4%
Graham Number
$240.20
+1072.8%
Reverse DCF
—
—
DDM
—
—
EV/EBITDA
$21.45
+4.7%
Values reflect default assumptions. Adjust inputs in each model below to update.
1 — Discounted Cash Flow (DCF)
Assumptions
Yahoo: -$3.01B
Rev: 2.6% / EPS: 14.9%
Default: 9% (no SEC data)
Results
Intrinsic Value / share$-560.42
Current Price$20.48
Upside / Downside-2836.4%
Net Debt (used)$54.31B
Sensitivity: WACC (rows) × Near-term g (cols)
WACC \ Near-term
6.9%
10.9%
14.9%
18.9%
22.9%
7.0%
$-582.69
$-654.01
$-736.03
$-829.96
$-937.05
8.0%
$-510.06
$-566.82
$-632.04
$-706.65
$-791.66
9.0%
$-460.00
$-506.75
$-560.42
$-621.76
$-691.60
10.0%
$-423.47
$-462.94
$-508.20
$-559.89
$-618.70
11.0%
$-395.69
$-429.63
$-468.52
$-512.89
$-563.33
2 — Graham Number
Assumptions
Graham used 22.5 (15× P/E × 1.5× P/B)
Yahoo: $1.80
Yahoo: $1421.43
Results
Graham Number$240.20
Current Price$20.48
Margin of Safety+1072.8%
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$20.48
Implied Near-term FCF Growth—
Historical Revenue Growth2.6%
Historical Earnings Growth14.9%
Base FCF (TTM)-$3.01B
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$20.48
Upside / Downside—
Formula: D0 × (1+g) / (r − g)
5 — EV/EBITDA Multiple
Assumptions
Yahoo: $10.07B
Current: 6.0×
Default: $54.31B
Results
Implied Equity Value / share$21.45
Current Price$20.48
Upside / Downside+4.7%
Implied EV$59.98B
Sensitivity: EV/EBITDA multiple (rows) × Net Debt (cols)