CIM-PD — Valuation Models

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

Valuation Summary

Model	Intrinsic Value	vs Price ($23.00)
DCF	$-68.28	-396.9%
Graham Number	$22.55	-1.9%
Reverse DCF	—	—
DDM	$50.68	+120.3%
EV/EBITDA	—	—

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

1 — Discounted Cash Flow (DCF)

Assumptions

Base FCF($B)Yahoo: —

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

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

Terminal growth rate(%)

WACC(%)Computed: 2.87%

Computed WACC: 2.87%

Cost of equity (Re)14.49%(Rf 4.30% + β 1.85 × 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)19.77%

Debt weight (D/V)80.23%

Results

Intrinsic Value / share$-68.28

Current Price$23.00

Upside / Downside-396.9%

Net Debt (used)$12.77B

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

WACC \ Near-term	-3.0%	1.0%	5.0%	9.0%	13.0%
7.0%	$-68.28	$-68.28	$-68.28	$-68.28	$-68.28
8.0%	$-68.28	$-68.28	$-68.28	$-68.28	$-68.28
9.0%	$-68.28	$-68.28	$-68.28	$-68.28	$-68.28
10.0%	$-68.28	$-68.28	$-68.28	$-68.28	$-68.28
11.0%	$-68.28	$-68.28	$-68.28	$-68.28	$-68.28

2 — Graham Number

Assumptions

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

EPS (trailing)($)Yahoo: $0.73

Book Value / share($)Yahoo: $30.84

Results

Graham Number$22.55

Current Price$23.00

Margin of Safety-1.9%

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

3 — Reverse DCF (Implied Growth)

Assumptions

WACC(%)Computed: 2.87%

Terminal growth rate(%)

Computed WACC: 2.87%

Cost of equity (Re)14.49%(Rf 4.30% + β 1.85 × 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)19.77%

Debt weight (D/V)80.23%

Results

Reverse DCF requires positive TTM free cash flow.

Current Price$23.00

Implied Near-term FCF Growth—

Historical Revenue Growth—

Historical Earnings Growth—

Base FCF (TTM)—

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: $2.46

Dividend growth rate (g)(%)

Required return (r)(%)

Results

DDM Intrinsic Value / share$50.68

Current Price$23.00

Upside / Downside+120.3%

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

5 — EV/EBITDA Multiple

Assumptions

EBITDA($B)Yahoo: —

Target EV/EBITDA multipleCurrent: —×

Net Debt($B)Default: $12.77B

Results

Implied Equity Value / share$-68.28

Current Price$23.00

Upside / Downside-396.9%

Implied EV$0

← Overview Financial Statements ← Companies