CCK — Valuation Models

Interactive models with editable assumptions. All calculations run client-side.

Valuation Summary

Model	Intrinsic Value	vs Price ($116.11)
DCF	$117.21	+0.9%
Graham Number	$61.90	-46.7%
Reverse DCF	—	implied g: 7.6%
DDM	$28.84	-75.2%
EV/EBITDA	$118.87	+2.4%

Values reflect default assumptions. Adjust inputs in each model below to update.

1 — Discounted Cash Flow (DCF)

Assumptions

Base FCF($B)Yahoo: $909.50M

Near-term growth (yrs 1–5)(%)Rev: 7.7% / EPS: -56.4%

Long-term growth (yrs 6–10)(%)

Terminal growth rate(%)

WACC(%)Computed: 5.60%

Computed WACC: 5.60%

Cost of equity (Re)8.18%(Rf 4.30% + β 0.71 × ERP 5.50%)

Cost of debt (Rd)0.00%(no debt / unavailable → 0%)

Tax rate (T)21.00%(US statutory fallback)

Equity weight (E/V)68.45%

Debt weight (D/V)31.55%

Results

Intrinsic Value / share$306.77

Current Price$116.11

Upside / Downside+164.2%

Net Debt (used)$5.41B

Sensitivity: WACC (rows) × Near-term g (cols)

WACC \ Near-term	-0.3%	3.7%	7.7%	11.7%	15.7%
7.0%	$121.45	$155.07	$194.05	$239.04	$290.71
8.0%	$90.58	$117.54	$148.77	$184.76	$226.05
9.0%	$69.22	$91.60	$117.48	$147.27	$181.41
10.0%	$53.57	$72.60	$94.58	$119.85	$148.78
11.0%	$41.62	$58.10	$77.11	$98.94	$123.91

2 — Graham Number

Assumptions

MultiplierGraham used 22.5 (15× P/E × 1.5× P/B)

EPS (trailing)($)Yahoo: $6.37

Book Value / share($)Yahoo: $26.74

Results

Graham Number$61.90

Current Price$116.11

Margin of Safety-46.7%

Formula: √(22.5 × max(0,EPS) × max(0,BVPS))

3 — Reverse DCF (Implied Growth)

Assumptions

WACC(%)Computed: 5.60%

Terminal growth rate(%)

Computed WACC: 5.60%

Cost of equity (Re)8.18%(Rf 4.30% + β 0.71 × ERP 5.50%)

Cost of debt (Rd)0.00%(no debt / unavailable → 0%)

Tax rate (T)21.00%(US statutory fallback)

Equity weight (E/V)68.45%

Debt weight (D/V)31.55%

Results

Current Price$116.11

Implied Near-term FCF Growth-4.0%

Historical Revenue Growth7.7%

Historical Earnings Growth-56.4%

Base FCF (TTM)$909.50M

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

Annual dividend D0($/share)Yahoo: $1.40

Dividend growth rate (g)(%)

Required return (r)(%)

Results

DDM Intrinsic Value / share$28.84

Current Price$116.11

Upside / Downside-75.2%

Formula: D0 × (1+g) / (r − g)

5 — EV/EBITDA Multiple

Assumptions

EBITDA($B)Yahoo: $2.08B

Target EV/EBITDA multipleCurrent: 9.1×

Net Debt($B)Default: $5.41B

Results

Implied Equity Value / share$118.87

Current Price$116.11

Upside / Downside+2.4%

Implied EV$18.89B

Sensitivity: EV/EBITDA multiple (rows) × Net Debt (cols)

Mult \ Net Debt	$3.41B	$4.41B	$5.41B	$6.41B	$7.41B
5.1x	$63.07	$54.26	$45.44	$36.63	$27.81
7.1x	$99.79	$90.97	$82.15	$73.34	$64.52
9.1x	$136.50	$127.68	$118.87	$110.05	$101.23
11.1x	$173.21	$164.40	$155.58	$146.76	$137.95
13.1x	$209.93	$201.11	$192.29	$183.48	$174.66

← Overview Financial Statements ← Companies