Consolidated Communications Holdings Inc
NASDAQ:CNSL
Intrinsic Value
Consolidated Communications Holdings, Inc. engages in the provision of business and broadband communications services. [ Read More ]
The intrinsic value of one
CNSL
stock under the Base Case scenario is
18.11
USD.
Compared to the current market price of 4.24 USD,
Consolidated Communications Holdings Inc
is
Undervalued by 77%.
Consolidated Communications Holdings Inc's market capitalization is 492.6m USD.
CNSL stock price is 4.24 USD.
CNSL stock price (4.24 USD) is 77% less than its Intrinsic Value (18.11 USD).
CNSL. Open DCF Valuation
CNSL stock price (4.24 USD) is 77% less than its Relative Value (18.11 USD). Open Relative Valuation
CNSL has upside potential of 4% compared to the average analyst price target.
Open Wall St Estimates
CNSL's Revenue is forecast to grow at a rate of 3% per year over the next 3 years.
CNSL's Revenue has dropped by 7% over the past 12 months.
CNSL's ROIC (Return on Invested Capital) has decreased in the last 3 years from 4% to -1%.
CNSL's long-term assets (4B USD) exceed its long-term liabilties (3B USD).
CNSL has negative Operating Income for the last twelve months.
CNSL's Revenue has been falling by 5% per year for the last 3 years.
CNSL's ROIC (Return on Invested Capital) for the past 12 months is negative and is equal to -1%.
CNSL's short-term liabilties (317m USD) exceed its short-term assets (256m USD).
CNSL has a very low three-year average ROIC (Return on Invested Capital): 2%. The company is not efficient at using invested capital to generate operating income.
CNSL's ROE (Return on Equity) has significantly decreased in the last 3 years from -13% to -33%, and is approaching profitability.
CNSL has negative Net Income for the last twelve months.
CNSL's ROE (Return on Equity) for the past 12 months is negative and is equal to -33%.
CNSL has positive Gross Profit for the last twelve months.
CNSL's D/E (Debt to Equity) is very high and is equal to 2.77.
CNSL has negative three-year average ROE (Return on Equity): -11%. The company is not efficient at transforming stockholders' equity into net income.
CNSL has negative Free Cash Flow for the last twelve months.
CNSL has positive Net Debt. This means that the company has more debt (2B USD) than cash and short-term investments (5m USD).
CNSL's Altman Z-Score is very low and is equal to 0.24.
CNSL doesn't generate enough operating income (-57m USD) to safely cover interest payments on its debt (143m USD).
Valuation Backtest
Consolidated Communications Holdings Inc
Run backtest to discover the historical profit from buying and selling
CNSL
stocks based on their intrinsic value.
Analyze the historical link between intrinsic value and market price to make more informed investment decisions.
Fundamental Analysis
Consolidated Communications Holdings Inc
Balance Sheet Decomposition
Consolidated Communications Holdings Inc
| Current Assets | 256.2m |
| Cash & Short-Term Investments | 4.8m |
| Receivables | 124.1m |
| Other Current Assets | 127.3m |
| Non-Current Assets | 3.4B |
| Long-Term Investments | 8.9m |
| PP&E | 2.4B |
| Intangibles | 843.8m |
| Other Non-Current Assets | 70.6m |
| Current Liabilities | 317.2m |
| Accounts Payable | 60.1m |
| Accrued Liabilities | 190.9m |
| Other Current Liabilities | 66.3m |
| Non-Current Liabilities | 2.5B |
| Long-Term Debt | 2.1B |
| Other Non-Current Liabilities | 405m |
Earnings Waterfall
Consolidated Communications Holdings Inc
|
Revenue
|
1.1B
USD
|
|
Cost of Revenue
|
-511.9m
USD
|
|
Gross Profit
|
598.3m
USD
|
|
Operating Expenses
|
-655.4m
USD
|
|
Operating Income
|
-57.2m
USD
|
|
Other Expenses
|
-237.3m
USD
|
|
Net Income
|
-294.4m
USD
|
Free Cash Flow Analysis
Consolidated Communications Holdings Inc
CNSL Profitability Score
Profitability Due Diligence
Consolidated Communications Holdings Inc's profitability score is 32/100. The higher the profitability score, the more profitable the company is.
Score
Consolidated Communications Holdings Inc's profitability score is 32/100. The higher the profitability score, the more profitable the company is.
CNSL Solvency Score
Solvency Due Diligence
Consolidated Communications Holdings Inc's solvency score is 17/100. The higher the solvency score, the more solvent the company is.
Score
Consolidated Communications Holdings Inc's solvency score is 17/100. The higher the solvency score, the more solvent the company is.
Wall St
Price Targets
CNSL Price Targets Summary
Consolidated Communications Holdings Inc
According to Wall Street analysts, the average 1-year price target for
CNSL
is 4.42 USD
with a low forecast of 4.04 USD and a high forecast of 4.94 USD.
Ownership
CNSL Insider Trading
Buy and sell transactions by insiders
| Period | Sold | Bought | Net |
|---|---|---|---|
| 3 Months |
|
|
|
| 6 Months |
|
|
|
| 9 Months |
|
|
|
| 12 Months |
|
|
|
Shareholder Return
CNSL Price
Consolidated Communications Holdings Inc
| Average Annual Return | 0.84% |
| Standard Deviation of Annual Returns | 52.29% |
| Max Drawdown | -78% |
| Market Capitalization | 492.6m USD |
| Shares Outstanding | 116 003 000 |
| Percentage of Shares Shorted | 5.33% |
Company Profile
Consolidated Communications Holdings Inc
Country
Industry
Market Cap
Dividend Yield
Description
Consolidated Communications Holdings, Inc. engages in the provision of business and broadband communications services. The company is headquartered in Mattoon, Illinois and currently employs 3,200 full-time employees. The company went IPO on 2005-07-22. The firm offers fiber network, which spans approximately 52,400 fiber route miles. The company also offers residential high-speed Internet, video, phone and home security services, as well as multi-service residential and small business bundles. Its business products include data and Internet solutions, voice, data center services, security services, managed and information technology (IT) services, and a suite of cloud services. The Commercial and Carrier services include data and transport services, voice services and others. The Consumer business includes broadband services, video services, voice services, subsidies, network access services, and other products and services. The broadband services include residential customers for subscriptions to its Voice over Internet Protocol (VoIP) and data products.
Contact
IPO
Employees
Officers
The intrinsic value of one
CNSL
stock under the Base Case scenario is
18.11
USD.
Compared to the current market price of 4.24 USD,
Consolidated Communications Holdings Inc
is
Undervalued by 77%.
You don't have any saved screeners yet
