CODI-PC

CODI-PC — Valuation Models

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

Valuation Summary

ModelIntrinsic Valuevs Price ($20.69)
DCF$-2218841255.95-10724220766.7%
Graham Number
Reverse DCF
DDM$40.58+96.1%
EV/EBITDA$2166152436.00+10469562181.3%

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

1 — Discounted Cash Flow (DCF)

Assumptions

Yahoo: -$13.60M
Rev: -5.1% / EPS: —
Default: 9% (no SEC data)

Results

Intrinsic Value / share$-2218841255.95
Current Price$20.69
Upside / Downside-10724220766.7%
Net Debt (used)$1.98B
Sensitivity: WACC (rows) × Near-term g (cols)
WACC \ Near-term-3.0%1.0%5.0%9.0%13.0%
7.0%$-2220892176.47$-2269584304.04$-2326231893.80$-2391795138.08$-2467309227.75
8.0%$-2178047455.58$-2217238764.85$-2262764113.05$-2315384077.17$-2375918466.96
9.0%$-2148357757.89$-2180990872.29$-2218841255.95$-2262532176.31$-2312735297.80
10.0%$-2126562199.50$-2154401918.97$-2186644685.85$-2223813802.33$-2266473086.17
11.0%$-2109875550.63$-2134063159.89$-2162035157.98$-2194239013.24$-2231156736.83

2 — Graham Number

Assumptions

Graham used 22.5 (15× P/E × 1.5× P/B)
Yahoo: $0.86
Yahoo: $-0.48

Results

Graham Number requires positive EPS and positive Book Value per share. BVPS is zero or negative.
Graham Number
Current Price$20.69
Margin of Safety
Formula: √(22.5 × max(0,EPS) × max(0,BVPS))

3 — Reverse DCF (Implied Growth)

Assumptions

Default: 9% (no SEC data)

Results

Reverse DCF requires positive TTM free cash flow.
Current Price$20.69
Implied Near-term FCF Growth
Historical Revenue Growth-5.1%
Historical Earnings Growth
Base FCF (TTM)-$13.60M
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: $1.97

Results

DDM Intrinsic Value / share$40.58
Current Price$20.69
Upside / Downside+96.1%
Formula: D0 × (1+g) / (r − g)

5 — EV/EBITDA Multiple

Assumptions

Yahoo: $192.27M
Current: 21.6×
Default: $1.98B

Results

Implied Equity Value / share$2166152436.00
Current Price$20.69
Upside / Downside+10469562181.3%
Implied EV$4.15B
Sensitivity: EV/EBITDA multiple (rows) × Net Debt (cols)
Mult \ Net Debt$1.98B$1.98B$1.98B$1.98B$1.98B
17.6x$1397080436.00$1397080436.00$1397080436.00$1397080436.00$1397080436.00
19.6x$1781616436.00$1781616436.00$1781616436.00$1781616436.00$1781616436.00
21.6x$2166152436.00$2166152436.00$2166152436.00$2166152436.00$2166152436.00
23.6x$2550688436.00$2550688436.00$2550688436.00$2550688436.00$2550688436.00
25.6x$2935224436.00$2935224436.00$2935224436.00$2935224436.00$2935224436.00