Interactive models with editable assumptions. All calculations run client-side.
Valuation Summary
Model
Intrinsic Value
vs Price ($74.66)
DCF
$20328960.15
+27228617.1%
Graham Number
$74.22
-0.6%
Reverse DCF
—
implied g: 16.9%
DDM
$45.32
-39.3%
EV/EBITDA
$75.49
+1.1%
Values reflect default assumptions. Adjust inputs in each model below to update.
1 — Discounted Cash Flow (DCF)
Assumptions
Yahoo: $1.36B
Rev: 5.7% / EPS: 414.7%
Default: 9% (no SEC data)
Results
Intrinsic Value / share$20345340.94
Current Price$74.66
Upside / Downside+27250557.6%
Net Debt (used)$11.32B
Sensitivity: WACC (rows) × Near-term g (cols)
WACC \ Near-term
406.7%
410.7%
414.7%
418.7%
422.7%
7.0%
$31782883.48
$33057334.76
$34372345.14
$35728875.10
$37127900.16
8.0%
$24035262.59
$24999040.95
$25993491.21
$27019339.73
$28077324.20
9.0%
$18812623.53
$19566978.74
$20345340.94
$21148278.65
$21976369.27
10.0%
$15093570.23
$15698794.86
$16323280.40
$16967482.96
$17631865.81
11.0%
$12338385.02
$12833129.41
$13343618.67
$13870225.65
$14413329.05
2 — Graham Number
Assumptions
Graham used 22.5 (15× P/E × 1.5× P/B)
Yahoo: $4.66
Yahoo: $52.54
Results
Graham Number$74.22
Current Price$74.66
Margin of Safety-0.6%
Formula: √(22.5 × max(0,EPS) × max(0,BVPS))
3 — Reverse DCF (Implied Growth)
Assumptions
Default: 9% (no SEC data)
Results
Current Price$74.66
Implied Near-term FCF Growth16.9%
Historical Revenue Growth5.7%
Historical Earnings Growth414.7%
Base FCF (TTM)$1.36B
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: $2.20
Results
DDM Intrinsic Value / share$45.32
Current Price$74.66
Upside / Downside-39.3%
Formula: D0 × (1+g) / (r − g)
5 — EV/EBITDA Multiple
Assumptions
Yahoo: $5.41B
Current: 8.8×
Default: $11.32B
Results
Implied Equity Value / share$75.49
Current Price$74.66
Upside / Downside+1.1%
Implied EV$47.80B
Sensitivity: EV/EBITDA multiple (rows) × Net Debt (cols)