Interactive models with editable assumptions. All calculations run client-side.
Valuation Summary
Model
Intrinsic Value
vs Price ($49.87)
DCF
$38.78
-22.2%
Graham Number
—
—
Reverse DCF
—
implied g: 9.6%
DDM
—
—
EV/EBITDA
$49.99
+0.2%
Values reflect default assumptions. Adjust inputs in each model below to update.
1 — Discounted Cash Flow (DCF)
Assumptions
Yahoo: $1.15B
Rev: 0.0% / EPS: —
Default: 9% (no SEC data)
Results
Intrinsic Value / share$38.78
Current Price$49.87
Upside / Downside-22.2%
Net Debt (used)-$1.34B
Sensitivity: WACC (rows) × Near-term g (cols)
WACC \ Near-term
-3.0%
1.0%
5.0%
9.0%
13.0%
7.0%
$39.09
$46.51
$55.13
$65.12
$76.62
8.0%
$32.56
$38.53
$45.47
$53.48
$62.70
9.0%
$28.04
$33.01
$38.78
$45.43
$53.08
10.0%
$24.72
$28.96
$33.87
$39.54
$46.03
11.0%
$22.18
$25.87
$30.13
$35.03
$40.65
2 — Graham Number
Assumptions
Graham used 22.5 (15× P/E × 1.5× P/B)
Yahoo: $-0.08
Yahoo: $21.46
Results
Graham Number requires positive EPS and positive Book Value per share. EPS is zero or negative.
Graham Number—
Current Price$49.87
Margin of Safety—
Formula: √(22.5 × max(0,EPS) × max(0,BVPS))
3 — Reverse DCF (Implied Growth)
Assumptions
Default: 9% (no SEC data)
Results
Current Price$49.87
Implied Near-term FCF Growth9.6%
Historical Revenue Growth0.0%
Historical Earnings Growth—
Base FCF (TTM)$1.15B
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$49.87
Upside / Downside—
Formula: D0 × (1+g) / (r − g)
5 — EV/EBITDA Multiple
Assumptions
Yahoo: $2.05B
Current: 12.9×
Default: -$1.34B
Results
Implied Equity Value / share$49.99
Current Price$49.87
Upside / Downside+0.2%
Implied EV$26.43B
Sensitivity: EV/EBITDA multiple (rows) × Net Debt (cols)