CIG

CIG — Valuation Models

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

Valuation Summary

ModelIntrinsic Valuevs Price ($2.37)
DCF$-31.93-1447.3%
Graham Number$4.40+85.6%
Reverse DCF
DDM$3.09+30.4%
EV/EBITDA$3.56+50.4%

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

1 — Discounted Cash Flow (DCF)

Assumptions

Yahoo: -$2.69B
Rev: 4.6% / EPS: -75.7%
Default: 9% (no SEC data)

Results

Intrinsic Value / share$-31.93
Current Price$2.37
Upside / Downside-1447.3%
Net Debt (used)$13.52B
Sensitivity: WACC (rows) × Near-term g (cols)
WACC \ Near-term-3.0%1.0%5.0%9.0%13.0%
7.0%$-32.15$-37.21$-43.10$-49.92$-57.78
8.0%$-27.69$-31.77$-36.50$-41.97$-48.27
9.0%$-24.60$-27.99$-31.93$-36.48$-41.70
10.0%$-22.33$-25.23$-28.58$-32.45$-36.89
11.0%$-20.60$-23.11$-26.02$-29.37$-33.21

2 — Graham Number

Assumptions

Graham used 22.5 (15× P/E × 1.5× P/B)
Yahoo: $0.44
Yahoo: $1.95

Results

Graham Number$4.40
Current Price$2.37
Margin of Safety+85.6%
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$2.37
Implied Near-term FCF Growth
Historical Revenue Growth4.6%
Historical Earnings Growth-75.7%
Base FCF (TTM)-$2.69B
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: $0.15

Results

DDM Intrinsic Value / share$3.09
Current Price$2.37
Upside / Downside+30.4%
Formula: D0 × (1+g) / (r − g)

5 — EV/EBITDA Multiple

Assumptions

Yahoo: $7.10B
Current: 2.9×
Default: $13.52B

Results

Implied Equity Value / share$3.56
Current Price$2.37
Upside / Downside+50.4%
Implied EV$20.30B
Sensitivity: EV/EBITDA multiple (rows) × Net Debt (cols)
Mult \ Net Debt$7.52B$10.52B$13.52B$16.52B$19.52B
-1.1x$-8.21$-9.79$-11.36$-12.94$-14.51
0.9x$-0.75$-2.32$-3.90$-5.47$-7.05
2.9x$6.72$5.14$3.56$1.99$0.41
4.9x$14.18$12.60$11.03$9.45$7.88
6.9x$21.64$20.06$18.49$16.91$15.34