Home MarketXLS
Dashboard MarketXLS
Screener MarketXLS
Options Profit Calculator MarketXLS
Stock Ranks MarketXLS
Spreadsheet Builder MarketXLS
Documentation MarketXLS
Logout MarketXLS

CNSL Stock Forecast, Price Targets, Chart, Dividends & Analysis

Consolidated Communications Holdings Inc. logo

Consolidated Communications Holdings Inc.

Sector: Communication Services   

Industry: Telecom Services

4.63
 
USD
  
0.00
  
(0.00%)
Previous close: 4.63  Open: 4.64  Bid: 4.6  Ask: 4.65
52 week range    
4.19   
   4.70
Mkt Cap: 549 M  Avg Vol (90 Days): 344,483
Peers   
IDT / 
VG / 
T / 
VZ / 
EGHT / 
Last updated: Friday 22nd November 2024

Stock Rankings

57
MarketXLS Rank
60
Value
69
Technical
42
Quality
How are these ranks calculated?
Ad slot not ready
Search for a stock

Metrics

Peers

StockDividendMarket Cap (B)PEPrice ($)

CMCSA

0.0289162 B11.5643.5

EGHT

0 B-62.95

IDT

0.00411 B19.4650.22

T

0.0489163 B18.4422.98

VG

20.99

VZ

0.0651177 B17.9542.5
Financials

CNSL Income Statement

Annual
Dec-14Dec-15Dec-16Dec-17Dec-18Dec-19Dec-20Dec-21Dec-22Dec-23
AccruedPreferredStockDividends3 M40 M44 M
AcquisitionExpense8 M14 M
Amortization of intangibles-10 M-13 M-13 M-28 M-66 M1,035 M1,035 M1,013 M930 M815 M
Basic EPS from continuing operations-0.290.47-1.26-1.9-2.6
Basic EPS total-0.290.47-1.260.87-2.6
Basic weighted shares outstanding42 M50 M50 M60 M71 M71 M73 M87 M112 M113 M
BasicDiscontinuousOperations2.77
Cost of sales561 M570 M547 M512 M
Depreciation149 M508 M497 M738 M1,045 M381 M325 M301 M300 M315 M
Depreciation unreconciled149 M508 M497 M738 M1,045 M381 M325 M301 M300 M315 M
DepreciationAndAmortization149 M508 M497 M738 M1,045 M381 M325 M301 M300 M315 M
Diluted EPS total0.35-0.020.291.07-0.73-0.290.47-1.260.87-2.6
Diluted normalized net income/share-1.26-1.9-2.6
Diluted weighted shares outstanding43 M44 M51 M61 M70 M71 M87 M112 M113 M
DilutedDiscontinuousOperations2.77
Dividends paid per share1.551.551.551.551.550.39
Earnings from equity interest97 M105 M95 M103 M99 M99 M
EarningsFromEquityInterestNetOfTax97 M105 M95 M103 M99 M99 M
GainOnSaleOfPPE-4 M-9 M
GainOnSaleOfSecurity400000.06 M
GainsLossOnDisposalOfDiscontinuedOperations-9 M295 M
GeneralAndAdministrativeExpense-7 M-12 M-13 M-24 M-32 M299 M275 M271 M302 M340 M
Gross operating profit636 M776 M743 M1,060 M1,399 M1,337 M743 M713 M645 M598 M
ImpairmentOfCapitalAssets610000.0
Income before tax28 M2 M38 M-60 M-75 M-24 M48 M-142 M-205 M-302 M
Income restructuring and M&A-100000.0-6 M
Income taxes13 M3 M23 M-125 M-24 M-4 M2 M-3 M-27 M-52 M
Interest income-48 M-43 M-44 M-98 M-95 M-137 M-144 M-175 M-125 M-152 M
InterestExpenseNonOperating2 M144 M1 M1 M3 M
InterestExpenseOperating-73 M-77 M-70 M-106 M-122 M-130 M-121 M-123 M-119 M-143 M
MinorityInterests-321000.0-210000.0-265000.0-354000.0-263000.0-452000.0-325000.0-392000.0-564000.0-456000.0
MiscOtherSpecialCharges-15 M-43 M-5 M-503000.01 M-6 M-9 M-16 M13 M8 M
Net income from total operations15 M-881000.015 M65 M-51 M-20 M37 M-107 M140 M-251 M
NetIncomeCommonStockholders15 M-881000.015 M65 M-51 M1,091 M34 M-110 M97 M-294 M
NetIncomeContinuousOperations15 M-881000.015 M65 M-51 M-20 M37 M-110 M100 M-294 M
NetIncomeDiscontinuousOperations32 M318 M
NetNonOperatingInterestIncomeExpense-48 M-43 M-44 M-98 M-95 M-137 M-144 M-175 M-125 M-152 M
Normalized income-246 M
Operating income103 M89 M89 M73 M21 M81 M136 M135 M-93 M-158 M
Operating income before depreciation (EBITDA)109 M109 M146 M143 M240 M235 M468 M441 M343 M258 M
OperatingExpense533 M687 M654 M987 M1,378 M105 M47 M2 M55 M157 M
Other income net27 M44 M7 M34 M645000.06 M9 M21 M123 M79 M
OtherGainLossFromDispositionOfDiscontinuedOperations42 M23 M
OtherGandA-7 M-12 M-13 M-24 M-32 M299 M275 M271 M302 M340 M
OtherImpairmentOfCapitalAssets6 M132 M78 M
OtherOperatingExpenses3 M-1000.03 M7 M9 M25 M19 M16 M17 M19 M
OtherWriteOff-2 M-3 M-3 M-7 M-11 M9 M7 M7 M7 M7 M
OtherunderPreferredStockDividend3 M40 M44 M
PreferredStockDividends3 M40 M44 M
PromotionAndAdvertising-8 M-8 M-9 M-11 M-11 M12 M11 M19 M35 M35 M
RentAndLandingFees-7 M-12 M-13 M-24 M-32 M
RestructringAndMnAIncome-100000.0-6 M
Revenue per share-10 M-13 M-13 M-28 M-66 M1,047 M1,043 M1,017 M934 M820 M
SalariesAndWages243 M-3 M-3 M-3 M-5 M-575 M-561 M-570 M-547 M-512 M
Selling Gen & administrative expense141 M178 M157 M249 M334 M299 M275 M271 M302 M340 M
SellingAndMarketingExpense141 M178 M157 M249 M334 M12 M11 M19 M35 M35 M
SellingExpense141 M178 M157 M249 M334 M
Special income/charges100000.0-610000.06 M
Total Income available for interest expense (EBIT)-45 M-75 M-31 M-166 M-197 M-151 M143 M141 M43 M-57 M
Total common shares outstanding50 M50 M51 M71 M71 M72 M79 M114 M115 M116 M
Total net income15 M-881000.015 M65 M-51 M-20 M37 M-107 M140 M-251 M
Total ordinary shares118 M118 M118 M118 M118 M118 M118 M118 M118 M118 M
Total revenues636 M776 M743 M1,060 M1,399 M1,337 M1,304 M1,282 M1,191 M1,110 M
TotalExpenses533 M687 M654 M987 M1,378 M105 M47 M2 M55 M157 M
TotalRevenue636 M776 M743 M1,060 M1,399 M1,337 M1,304 M1,282 M1,191 M1,110 M
WriteDown-12 M
Call: 1-877-778-8358
Ankur Mohan MarketXLS
Welcome! I'm Ankur, the founder and CEO of MarketXLS. With more than ten years of experience, I have assisted over 2,500 customers in developing personalized investment research strategies and monitoring systems using Excel.

I invite you to book a demo with me or my team to save time, enhance your investment research, and streamline your workflows.
Implement “your own” investment strategies in Excel with thousands of MarketXLS functions and templates.

MarketXLS is a complete Excel stock solution

Kevin Hsu

StockKevin.com

I have used lots of stock and option information services. This is the only one which gives me what I need inside Excel

Lloyd Lenase

Option Day Trader

MarketXLS is a data junkie’s dream. It gives me the flexibility to mine for hidden treasures.

Dave

Swing trader since 2011

I like to access historical closing prices on a particular date. That makes tracking performance easy.

Patrick Cusatis, Ph.D., CFA

Associate Professor of Finance - Penn State University