CCLDO

CCLDO — Valuation Models

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

Valuation Summary

ModelIntrinsic Valuevs Price ($25.55)
DCF$287002070.94+1123295676.7%
Graham Number
Reverse DCFimplied g: -20.0%
DDM$45.11+76.6%
EV/EBITDA$1083240699.00+4239689524.3%

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

1 — Discounted Cash Flow (DCF)

Assumptions

Yahoo: $13.33M
Rev: 8.8% / EPS: —
Default: 9% (no SEC data)

Results

Intrinsic Value / share$287002070.94
Current Price$25.55
Upside / Downside+1123295676.7%
Net Debt (used)$5.41M
Sensitivity: WACC (rows) × Near-term g (cols)
WACC \ Near-term0.8%4.8%8.8%12.8%16.8%
7.0%$295788427.98$355199647.67$424009598.77$503313431.30$594288869.09
8.0%$240324274.90$287917217.27$342969118.66$406345193.39$478975721.97
9.0%$201979569.52$241428449.39$287002070.94$339407670.07$399405528.95
10.0%$173902356.89$207409737.05$246070536.92$290477127.32$341266192.90
11.0%$152465486.43$181454949.54$214860966.38$253188889.50$296981775.83

2 — Graham Number

Assumptions

Graham used 22.5 (15× P/E × 1.5× P/B)
Yahoo: —
Yahoo: $1.36

Results

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

3 — Reverse DCF (Implied Growth)

Assumptions

Default: 9% (no SEC data)

Results

Current Price$25.55
Implied Near-term FCF Growth-20.0%
Historical Revenue Growth8.8%
Historical Earnings Growth
Base FCF (TTM)$13.33M
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.19

Results

DDM Intrinsic Value / share$45.11
Current Price$25.55
Upside / Downside+76.6%
Formula: D0 × (1+g) / (r − g)

5 — EV/EBITDA Multiple

Assumptions

Yahoo: $15.67M
Current: 69.5×
Default: $5.41M

Results

Implied Equity Value / share$1083240699.00
Current Price$25.55
Upside / Downside+4239689524.3%
Implied EV$1.09B
Sensitivity: EV/EBITDA multiple (rows) × Net Debt (cols)
Mult \ Net Debt-$1.99B-$994.59M$5.41M$1.01B$2.01B
65.5x$3020556699.00$2020556699.00$1020556699.00$20556699.00$-979443301.00
67.5x$3051898699.00$2051898699.00$1051898699.00$51898699.00$-948101301.00
69.5x$3083240699.00$2083240699.00$1083240699.00$83240699.00$-916759301.00
71.5x$3114582699.00$2114582699.00$1114582699.00$114582699.00$-885417301.00
73.5x$3145924699.00$2145924699.00$1145924699.00$145924699.00$-854075301.00