CICB

CICB — Valuation Models

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

Valuation Summary

ModelIntrinsic Valuevs Price ($25.24)
DCF$320582913.72+1270138226.9%
Graham Number
Reverse DCFimplied g: 0.5%
DDM
EV/EBITDA

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

1 — Discounted Cash Flow (DCF)

Assumptions

Yahoo: $78.18M
Rev: 4.9% / EPS: -18.0%
Default: 9% (no SEC data)

Results

Intrinsic Value / share$320582913.72
Current Price$25.24
Upside / Downside+1270138226.9%
Net Debt (used)$1.05B
Sensitivity: WACC (rows) × Near-term g (cols)
WACC \ Near-term-3.0%1.0%5.0%9.0%13.0%
7.0%$332373755.47$612307162.87$937976908.90$1314903186.06$1749037356.87
8.0%$86057373.20$311370114.55$573097553.45$875612284.01$1223627432.31
9.0%$-84630141.49$102979218.91$320582913.72$571764137.85$860384322.72
10.0%$-209933865.73$-49881965.73$135483267.76$349170324.49$594420620.11
11.0%$-305866220.90$-166810479.94$-5998103.74$179143424.95$391385211.74

2 — Graham Number

Assumptions

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

Results

Graham Number requires positive EPS and positive Book Value per share. EPS is zero or negative.
Graham Number
Current Price$25.24
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.24
Implied Near-term FCF Growth0.5%
Historical Revenue Growth4.9%
Historical Earnings Growth-18.0%
Base FCF (TTM)$78.18M
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: —

Results

This company does not pay a dividend. DDM is not applicable — the intrinsic value shown uses D0 = $0 unless you enter a hypothetical dividend above.
DDM Intrinsic Value / share
Current Price$25.24
Upside / Downside
Formula: D0 × (1+g) / (r − g)

5 — EV/EBITDA Multiple

Assumptions

Yahoo: —
Current: —×
Default: $1.05B

Results

Implied Equity Value / share$-1051912016.00
Current Price$25.24
Upside / Downside-4167638832.2%
Implied EV$0