CIG-C

CIG-C — Valuation Models

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

Valuation Summary

ModelIntrinsic Valuevs Price ($3.05)
DCF$-63.56-2183.9%
Graham Number$4.40+44.2%
Reverse DCF
DDM$3.09+1.3%
EV/EBITDA$9.13+199.3%

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$-63.56
Current Price$3.05
Upside / Downside-2183.9%
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%$-63.98$-74.07$-85.79$-99.37$-115.00
8.0%$-55.11$-63.23$-72.65$-83.55$-96.08
9.0%$-48.97$-55.72$-63.56$-72.60$-83.00
10.0%$-44.45$-50.22$-56.89$-64.59$-73.42
11.0%$-41.00$-46.01$-51.80$-58.47$-66.11

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$3.05
Margin of Safety+44.2%
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$3.05
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$3.05
Upside / Downside+1.3%
Formula: D0 × (1+g) / (r − g)

5 — EV/EBITDA Multiple

Assumptions

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

Results

Implied Equity Value / share$9.13
Current Price$3.05
Upside / Downside+199.3%
Implied EV$22.25B
Sensitivity: EV/EBITDA multiple (rows) × Net Debt (cols)
Mult \ Net Debt$7.52B$10.52B$13.52B$16.52B$19.52B
-0.9x$-14.31$-17.44$-20.58$-23.71$-26.85
1.1x$0.55$-2.59$-5.72$-8.86$-12.00
3.1x$15.40$12.27$9.13$5.99$2.86
5.1x$30.25$27.12$23.98$20.85$17.71
7.1x$45.11$41.97$38.84$35.70$32.56