Interactive models with editable assumptions. All calculations run client-side.
Valuation Summary
Model
Intrinsic Value
vs Price ($45.21)
DCF
$23.35
-48.4%
Graham Number
$11.73
-74.0%
Reverse DCF
—
implied g: 14.0%
DDM
$1.24
-97.3%
EV/EBITDA
$47.28
+4.6%
Values reflect default assumptions. Adjust inputs in each model below to update.
1 — Discounted Cash Flow (DCF)
Assumptions
Yahoo: $792.91M
Rev: 7.3% / EPS: —
Default: 9% (no SEC data)
Results
Intrinsic Value / share$23.27
Current Price$45.21
Upside / Downside-48.5%
Net Debt (used)$7.85B
Sensitivity: WACC (rows) × Near-term g (cols)
WACC \ Near-term
-0.7%
3.3%
7.3%
11.3%
15.3%
7.0%
$24.26
$33.61
$44.46
$56.98
$71.37
8.0%
$15.73
$23.24
$31.93
$41.96
$53.46
9.0%
$9.83
$16.06
$23.27
$31.58
$41.10
10.0%
$5.51
$10.81
$16.94
$23.98
$32.05
11.0%
$2.20
$6.80
$12.10
$18.19
$25.16
2 — Graham Number
Assumptions
Graham used 22.5 (15× P/E × 1.5× P/B)
Yahoo: $0.41
Yahoo: $14.93
Results
Graham Number$11.73
Current Price$45.21
Margin of Safety-74.0%
Formula: √(22.5 × max(0,EPS) × max(0,BVPS))
3 — Reverse DCF (Implied Growth)
Assumptions
Default: 9% (no SEC data)
Results
Current Price$45.21
Implied Near-term FCF Growth14.0%
Historical Revenue Growth7.3%
Historical Earnings Growth—
Base FCF (TTM)$792.91M
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.06
Results
DDM Intrinsic Value / share$1.24
Current Price$45.21
Upside / Downside-97.3%
Formula: D0 × (1+g) / (r − g)
5 — EV/EBITDA Multiple
Assumptions
Yahoo: $1.62B
Current: 14.9×
Default: $7.85B
Results
Implied Equity Value / share$47.28
Current Price$45.21
Upside / Downside+4.6%
Implied EV$24.21B
Sensitivity: EV/EBITDA multiple (rows) × Net Debt (cols)