Consolidated Communications Holdings, Inc.

Consolidated Communications Holdings, Inc.

CNSL
Consolidated Communications Holdings, Inc.US flagNASDAQ Global Select
4.64
USD
-0.01
- -
549.69MMarket Cap

Income Statement (USD)

APIChat
2009 Y
2010 Y
2011 Y
2012 Y
2013 Y
2014 Y
2015 Y
2016 Y
2017 Y
2018 Y
2019 Y
2020 Y
2021 Y
2022 Y
2023 Y
Sales/Revenue/Turnover
406
383
349
478
602
636
776
743
1,060
1,399
1,337
1,304
1,282
1,191
1,110
+ Sales & Services Revenue
406
383
349
478
602
636
776
743
1,060
1,399
1,337
1,304
1,282
1,191
1,110
- Cost of Revenue
145
142
122
176
222
243
328
321
446
612
575
561
570
547
512
+ Cost of Goods & Services
145
142
122
176
222
243
328
321
446
612
575
561
570
547
512
Gross Profit
261
241
227
302
379
393
447
422
614
787
762
743
713
645
598
+ Other Operating Income
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- Operating Expenses
190
175
166
228
275
290
358
331
541
766
680
600
572
602
655
+ Selling, General & Admin
105
88
78
108
135
141
178
157
249
334
299
275
271
302
340
+ Research & Development
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
+ Other Operating Expense
85
87
88
120
139
149
180
174
292
433
381
325
301
300
315
Operating Income (Loss)
71
66
61
73
104
103
89
91
73
21
81
143
141
43
-57
- Non-Operating (Income) Loss
32
24
24
68
57
75
87
53
132
96
105
136
283
248
245
+ Interest Expense, Net
58
51
49
73
86
83
80
77
130
135
137
144
- -
- -
- -
+ Interest Expense
58
51
50
73
86
83
80
77
130
135
137
144
- -
- -
- -
- Interest Income
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
+ Other Non-Op (Income) Loss
-26
-27
-25
-5
-29
-8
7
-24
2
-39
-32
-8
283
248
245
Pretax Income
38
42
37
6
47
28
2
38
-60
-75
-24
8
-142
-205
-302
- Income Tax Expense (Benefit)
12
9
13
1
18
13
3
23
-125
-24
-4
2
-3
-27
-52
- (Income) Loss from Affiliates
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
Income (Loss) from Cont Ops
26
33
24
5
30
15
-1
15
65
-51
-20
6
-139
-178
-250
- Net Extraordinary Losses (Gains)
2
1
-2
- -
-1
1
- -
1
1
1
1
-31
-32
-317
1
+ Discontinued Operations
- -
- -
3
1
1
- -
- -
- -
- -
- -
- -
31
32
318
- -
+ Extraord. & Accounting Changes
2
1
-4
-1
-2
1
- -
1
1
1
1
-62
-64
-636
1
Income (Loss) Incl. MI
24
32
26
5
30
15
-1
15
65
-51
-21
37
-107
140
-251
- Minority Interest
-1
-1
-1
-1
- -
- -
- -
- -
- -
- -
- -
- -
- -
-1
- -
Net Income, GAAP
25
33
26
6
31
15
-1
15
65
-51
-20
37
-107
140
-251
- Preferred Dividends
- -
- -
- -
- -
- -
1
- -
1
1
1
- -
- -
3
40
44
- Other Adjustments
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
Net Income Avail to Common, GAAP
25
32
26
5
30
15
-1
14
64
-52
-21
37
-110
100
-294
EBIT
71
66
61
73
104
103
89
91
73
21
81
143
141
43
-57
EBITDA
156
153
150
194
244
252
269
265
364
454
463
468
441
343
258
EBITDA Margin (%)
38.39
39.92
42.86
40.55
40.51
39.71
34.69
35.69
34.39
32.42
34.61
35.89
34.43
28.79
23.24
EBITA
71
66
61
73
104
103
89
91
73
21
81
143
141
43
-57
Gross Margin (%)
64.19
62.88
65.13
63.19
63.02
61.83
57.67
56.75
57.91
56.27
56.98
57.01
55.58
54.11
53.89
Operating Margin (%)
17.41
17.19
17.62
15.37
17.36
16.2
11.5
12.28
6.85
1.5
6.08
10.98
10.99
3.59
-5.15
Profit Margin (%)
6.13
8.5
7.57
1.18
5.12
2.37
-0.11
2.01
6.13
-3.63
-1.53
2.84
-8.35
11.76
-22.57
Sales per Employee
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
Dividend per Share
1.56
1.55
1.55
1.36
1.56
1.25
1.56
1.56
1.56
1.56
0.78
- -
- -
- -
- -
Depreciation Expense
85
87
88
120
139
149
180
174
292
433
381
325
301
300
315
Basic Weighted Avg Shares
29
30
30
40
40
50
50
50
60
71
71
73
87
112
113
Basic EPS, GAAP
0.85
1.08
0.87
0.13
0.76
0.29
-0.02
0.29
1.06
-0.73
-0.29
0.51
-1.26
0.89
-2.6
Basic EPS from Cont Ops
0.88
1.11
0.81
0.12
0.75
0.31
-0.01
0.3
1.08
-0.72
-0.28
0.08
-1.59
-1.59
-2.21
Diluted Weighted Avg Shares
30
30
30
40
40
50
50
50
60
71
71
73
87
112
113
Diluted EPS, GAAP
0.84
1.08
0.87
0.13
0.76
0.29
-0.02
0.29
1.06
-0.73
-0.29
0.51
-1.26
0.89
-2.6
Diluted EPS from Cont Ops
0.88
1.11
0.81
0.12
0.75
0.31
-0.01
0.3
1.08
-0.72
-0.28
0.08
-1.59
-1.59
-2.21

Balance Sheet (USD)

APIChat
2009 Y
2010 Y
2011 Y
2012 Y
2013 Y
2014 Y
2015 Y
2016 Y
2017 Y
2018 Y
2019 Y
2020 Y
2021 Y
2022 Y
2023 Y
Total Current Assets
108
136
162
109
88
134
126
133
214
198
177
341
428
598
256
+ Cash, Cash Equivalents & STI
43
68
106
18
6
7
16
27
16
10
12
156
210
414
5
+ Cash & Cash Equivalents
43
68
106
18
6
7
16
27
16
10
12
156
100
326
5
+ ST Investments
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
111
88
- -
+ Accounts & Notes Receiv
46
49
44
70
62
96
93
78
143
144
123
139
134
121
124
+ Accounts Receivable, Net
42
42
35
58
52
78
69
56
122
133
120
138
133
120
121
+ Notes Receivable, Net
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
+ Loans Receivable, Net
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
+ Other Receivable, Net
4
6
9
12
10
19
24
22
22
11
3
1
1
2
3
+ Inventories
7
8
7
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
+ Raw Materials
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
+ Work In Process
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
+ Finished Goods
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
+ Inventory Adjustments
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
+ Other Inventory
7
8
7
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
+ Other ST Assets
13
12
5
21
20
31
18
28
55
44
42
46
83
63
127
+ Misc ST Assets
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
+ Prepaid Expenses
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
+ ST Derivative & Hedging Assets
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
+ ST Assets Held-for-Sale
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
+ ST Deferred Tax Assets
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
Total Noncurrent Assets
1,119
1,073
1,032
1,684
1,660
2,078
2,012
1,960
3,506
3,337
3,213
3,167
3,285
3,289
3,372
+ Property, Plant & Equip, Net
377
356
338
908
885
1,137
1,093
1,055
2,038
1,927
1,836
1,760
2,019
2,234
2,449
+ Property, Plant & Equip
994
1,031
1,060
1,687
1,785
2,163
2,278
2,401
3,636
3,881
4,064
4,227
4,718
4,989
5,450
- Accumulated Depreciation
617
675
722
779
900
1,026
1,185
1,346
1,598
1,954
2,228
2,466
2,698
2,755
3,001
+ LT Investments & Receivables
99
99
98
110
113
115
106
106
109
111
113
112
11
10
9
+ LT Investments
99
99
98
110
113
115
106
106
109
111
113
112
11
10
9
+ LT Receivables
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
+ Other LT Assets
643
618
596
667
661
825
813
798
1,359
1,299
1,265
1,295
1,255
1,045
914
+ Total Intangible Assets
636
613
591
653
644
821
808
789
1,345
1,276
1,210
1,159
1,098
983
844
+ Goodwill
521
521
521
603
603
765
765
757
1,038
1,035
1,035
1,035
1,013
930
815
+ Other Intangible Assets
116
92
70
50
40
56
44
32
307
240
175
124
84
54
29
+ LT Deferred Tax Assets
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
+ LT Derivative & Hedging Assets
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
+ Misc LT Assets
7
5
5
14
18
4
5
10
14
23
55
136
157
61
71
Total Assets
1,227
1,210
1,194
1,793
1,747
2,212
2,139
2,093
3,719
3,535
3,390
3,507
3,713
3,887
3,628
+ Payables & Accruals
48
44
40
78
59
82
84
92
133
141
114
128
156
147
193
+ Accounts Payable
13
10
7
15
5
15
13
7
24
33
31
25
41
33
60
+ Accrued Taxes
- -
- -
5
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
+ Interest & Dividends Payable
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
+ Other Payables & Accruals
35
34
28
63
54
66
71
85
109
108
83
103
115
113
133
+ ST Debt
- -
- -
9
10
10
10
11
15
30
30
27
18
8
13
18
+ ST Borrowings
- -
- -
9
10
10
10
11
15
30
30
27
18
8
13
18
+ ST Finance Leases
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
+ Other ST Liabilities
29
31
37
57
49
65
49
43
93
112
103
125
121
108
106
+ Deferred Revenue
- -
- -
20
28
26
32
28
26
43
48
46
50
53
47
44
+ Derivatives & Hedging
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
+ Deferred Tax Liabilities
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
+ Misc ST Liabilities
29
31
16
29
23
33
22
17
51
64
57
75
68
61
62
Total Current Liabilities
77
76
85
144
118
156
144
150
256
284
244
270
286
267
317
+ LT Debt
880
884
876
1,208
1,212
1,341
1,378
1,377
2,312
2,304
2,251
2,171
2,119
2,129
2,135
+ LT Borrowings
880
880
876
1,208
1,212
1,341
1,378
1,377
2,312
2,304
2,251
2,171
2,119
2,129
2,135
+ LT Finance Leases
- -
4
5
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
+ Other LT Liabilities
188
178
185
305
265
384
366
390
578
532
548
676
472
445
397
+ Accrued Liabilities
75
74
77
138
180
247
237
244
210
188
173
171
194
274
211
+ Pension Liabilities
80
81
94
157
76
122
113
131
334
314
302
300
215
124
138
+ Deferred Revenue
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
+ Deferred Tax Liabilities
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
+ Derivatives & Hedging
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
+ Misc LT Liabilities
33
24
14
11
10
15
16
15
34
30
73
205
63
47
49
Total Noncurrent Liabilities
1,068
1,062
1,061
1,513
1,477
1,725
1,744
1,766
2,889
2,836
2,799
2,848
2,591
2,575
2,532
Total Liabilities
1,146
1,138
1,146
1,657
1,595
1,881
1,888
1,917
3,145
3,120
3,043
3,118
2,876
2,842
2,849
+ Preferred Equity and Hybrid Capital
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
289
329
373
+ Share Capital & APIC
110
98
80
178
149
358
282
218
616
514
493
526
742
722
683
+ Common Stock
- -
- -
- -
- -
- -
1
1
1
1
1
1
1
1
1
1
+ Additional Paid in Capital
110
98
80
177
148
357
282
218
616
513
492
526
741
720
682
- Treasury Stock
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
+ Retained Earnings
- -
- -
- -
- -
- -
- -
-1
- -
- -
-51
-71
-35
-142
-12
-262
+ Other Equity
-36
-31
-38
-46
-1
-32
-36
-47
-48
-53
-81
-109
-60
-1
-22
Equity Before Minority Interest
75
67
42
132
148
326
246
171
568
410
341
383
829
1,038
771
+ Minority/Non Controlling Interest
6
5
5
4
5
5
5
5
6
6
6
7
7
8
8
Total Equity
81
72
48
136
152
331
251
176
574
416
347
389
836
1,045
779
Total Liabilities & Equity
1,227
1,210
1,194
1,793
1,747
2,212
2,139
2,093
3,719
3,535
3,390
3,507
3,713
3,887
3,628
Shares Outstanding
30
30
30
40
40
50
50
51
71
71
72
79
114
115
116
Number of Employees
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
Capital Leases - Total
- -
4
5
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
Net Debt
837
812
779
1,200
1,216
1,345
1,373
1,365
2,326
2,324
2,266
2,033
2,027
1,816
2,149
Net Debt to Equity
1,037.26
1,130.22
1,629.31
881.66
798.44
406.4
547.65
774.22
405.19
559.23
652.43
522.41
242.38
173.75
275.68
Tangible Common Equity Ratio
-94.05
-90.66
-89.98
-45.32
-44.5
-35.24
-41.9
-46.95
-32.47
-38.06
-39.56
-32.79
-21.03
-9.18
-15.69
Current Ratio
1.39
1.8
1.9
0.76
0.75
0.86
0.88
0.89
0.83
0.7
0.72
1.26
1.5
2.24
0.81
Cash Conversion Cycle
24.67
29.24
38.11
19.74
17.09
22.03
18.96
19.73
17.97
16.32
14.43
17.76
17.35
14.04
6.38

Cash Flow Statement (USD)

APIChat
2009 Y
2010 Y
2011 Y
2012 Y
2013 Y
2014 Y
2015 Y
2016 Y
2017 Y
2018 Y
2019 Y
2020 Y
2021 Y
2022 Y
2023 Y
+ Net Income
26
33
24
5
30
15
-1
15
65
-51
-20
37
-107
141
-250
+ Depreciation & Amortization
85
87
88
120
139
149
180
174
292
433
381
325
301
300
315
+ Non-Cash Items
3
-2
13
12
28
35
63
32
-120
-41
-23
-20
143
-201
39
+ Stock-Based Compensation
2
2
2
2
3
4
3
3
3
5
7
8
10
11
8
+ Deferred Income Taxes
- -
-2
9
-1
16
10
6
21
-126
-26
-5
8
6
59
-56
+ Asset Impairment Charge
- -
- -
- -
1
- -
- -
- -
- -
- -
- -
- -
- -
6
132
78
+ Other Non-Cash Adj
1
-2
2
9
9
21
54
8
4
-20
-24
-36
121
-402
10
+ Chg in Non-Cash Work Cap
2
-2
-1
-18
-28
-12
-23
-3
-27
16
1
23
-18
-16
10
+ (Inc) Dec in Accts Receiv
4
-4
4
-5
8
8
4
8
-2
9
23
-2
4
5
-11
+ (Inc) Dec in Inventories
1
-1
1
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
+ (Inc) Dec in Prepaid Assets
- -
- -
- -
-1
-1
2
- -
-14
1
-13
-2
-7
-13
-8
-10
+ Inc (Dec) in Accts Payable
-2
1
-5
-12
-36
-23
-27
3
-26
20
-21
33
-9
-13
31
+ Inc (Dec) in Other
- -
1
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
+ Net Cash From Disc Ops
- -
- -
5
3
-4
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
Cash from Operating Activities
116
116
130
123
164
188
219
218
210
357
339
365
319
224
115
+ Change in Fixed & Intang
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
+ Disp in Fixed & Intang
1
1
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
+ Disp of Fixed Prod Assets
1
1
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
+ Disp of Intangible Assets
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
+ Acq of Fixed & Intang
-42
-43
-42
-77
-107
-109
-134
-125
-181
-245
-232
-218
-480
-620
-515
+ Acq of Fixed Prod Assets
-42
-43
-42
-77
-107
-109
-134
-125
-181
-245
-232
-218
-480
-620
-515
+ Acq of Intangible Assets
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
+ Cash (Repurchase) of Equity
-1
-1
-1
-1
-1
-2
-1
-1
-1
-1
- -
349
73
-1
-2
+ Increase in Capital Stock
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
350
75
- -
- -
+ Decrease in Capital Stock
-1
-1
-1
-1
-1
-2
-1
-1
-1
-1
- -
-1
-2
-1
-2
+ Net Change in LT Investment
- -
- -
- -
-7
- -
- -
1
- -
- -
- -
- -
- -
-110
25
92
+ Dec in LT Investment
- -
- -
- -
- -
- -
- -
1
- -
- -
- -
- -
- -
66
327
92
+ Inc in LT Investment
- -
- -
- -
-7
- -
- -
- -
- -
- -
- -
- -
- -
-176
-303
- -
+ Net Cash From Acq & Div
- -
- -
- -
-385
- -
-140
- -
17
-862
21
- -
- -
- -
589
- -
+ Cash from Divestitures
- -
- -
- -
- -
- -
- -
- -
30
- -
21
- -
- -
- -
589
- -
+ Cash for Acq of Subs
- -
- -
- -
-385
- -
-140
- -
-13
-862
- -
- -
- -
- -
- -
- -
+ Cash for JVs
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
+ Other Investing Activities
- -
- -
1
1
3
2
14
- -
1
2
14
7
3
23
6
+ Net Cash From Disc Ops
- -
- -
- -
- -
2
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
Cash from Investing Activities
-42
-42
-41
-469
-105
-247
-120
-108
-1,043
-221
-218
-210
-586
16
-417
+ Dividends Paid
-46
-46
-46
-54
-62
-62
-78
-78
-94
-110
-55
- -
- -
- -
- -
+ Net Cash From Debt
-1
- -
- -
333
-2
132
-6
-9
933
-31
-63
-300
147
-10
-15
+ Cash From Debt
- -
- -
- -
843
989
280
364
937
1,052
190
195
2,021
550
- -
- -
+ Repayments of Debt
-1
- -
- -
-510
-991
-148
-370
-946
-119
-221
-258
-2,322
-403
-10
-15
+ Other Financing Activities
- -
-2
-3
-20
-7
-8
-5
-10
-17
- -
- -
-61
-8
-3
- -
+ Net Cash From Disc Ops
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
Cash from Financing Activities
-47
-49
-51
257
-72
60
-90
-99
821
-142
-118
-12
212
-14
-18
Effect of Foreign Exchange Rates
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
Net Changes in Cash
27
25
38
-88
-12
1
9
11
-11
-6
3
143
-56
226
-321
EBITDA
156
153
150
194
244
252
269
265
364
454
463
468
441
343
258
EBITDA Margin (%)
38.39
39.92
42.86
40.55
40.51
39.71
34.69
35.69
34.39
32.42
34.61
35.89
34.43
28.79
23.24
Free Cash Flow
74
73
88
46
57
79
85
93
29
113
107
147
-161
-396
-400
Net Cash Paid for Acquisitions
- -
- -
- -
385
- -
140
- -
-17
862
-21
- -
- -
- -
-589
- -
Free Cash Flow to Firm
113
113
120
110
111
123
60
124
- -
- -
- -
259
- -
- -
- -
Free Cash Flow to Equity
74
73
87
378
54
210
79
83
961
81
44
-153
271
-406
-416
Free Cash Flow per Basic Share
2.52
2.46
2.94
1.16
1.43
1.57
1.7
1.85
0.48
1.59
1.51
2.03
-1.85
-3.55
-3.54
Price/Free Cash Flow
1.44
1.74
1.73
1.8
1.79
3.13
2.14
3.01
1.55
1.08
0.48
0.61
0.82
0.47
0.78
Cash Flow to Net Income
4.67
3.56
4.9
21.85
5.33
12.46
-248.78
14.62
3.23
-7.03
-16.64
9.87
-2.98
1.6
-0.46
Capital Expenditures
-42
-43
-42
-77
-107
-109
-134
-125
-181
-245
-232
-218
-480
-620
-515