investorscraft@gmail.com

Intrinsic value of Consolidated Communications Holdings, Inc. (CNSL)

Previous Close$7.08
Intrinsic Value
Upside potential
Previous Close
$7.08

VALUATION INPUT DATA (original, your and others' valuations)

ParameterOrig.Your
Date of valuation (DoV)  
Intrinsic value (IV) at DoV, $/sh  
IV at current val. algorithm, $/sh15.86 

The original valuation is based on fiscal year data as of 2021-12-31 and quarterly data as of 2022-03-31.

Registered users can save their valuation input data

  1. Annual
  2. Quarterly YoY
  3. Quarterly QoQ

Annual revenue growth rates, % (past and forecasted)

NOTE: The bar chart shows historic and forecasted yearly revenue growth rates. Its purpose is to help you in determining what initial revenue rate you want to base your stock valuation on. Please make sure that you are confident in the value you select - for most stocks it is by far the most important parameter in valuation.

Company description

Consolidated Communications Holdings, Inc., together with its subsidiaries, provides telecommunications services to business and residential customers in the United States. It offers high-speed broadband Internet access and voice over Internet protocol (VoIP) phone services; commercial data connectivity services in select markets, including a portfolio of Ethernet services, software defined wide area network, multi-protocol label switching, and private line services; and wholesale services to regional and national interexchange and wireless carriers, including cellular backhaul, dark fiber, and other fiber transport solutions. The company also provides voice services that include local phone and long-distance service packages for business customers; and sells business equipment and provides related hardware and maintenance support, video, and other miscellaneous services. In addition, it offers video services, which consist of high-definition television, digital video recorders (DVR), and/or a whole home DVR; other in-demand streaming content, including DIRECTV, DIRECTV NOW, fuboTV, Philo, HBO NOW, FlixFling, and VEMOX; and network access services, including interstate and intrastate switched access, network special access, and end user access. Further, the company engages in telephone directory publishing, video advertising, billing and support services, and other miscellaneous activities. As of December 31, 2019, it had approximately 836,000 voice connections, 784,000 data connections, and 84,000 video connections. The company serves customers in consumer, commercial, and carrier channels. Consolidated Communications Holdings, Inc. was founded in 1894 and is headquartered in Mattoon, Illinois.

show cash flow forecast

FINANCIAL STATEMENTS FORECAST and PRESENT VALUE CALCULATION

Fiscal year2021(a)2022202320242025202620272028202920302031203220332034203520362037203820392040204120422043204420452046

INCOME STATEMENT

Revenue growth rate, %-1.7NaN
Revenue, $1282NaN
Variable operating expenses, $mNaN
Fixed operating expenses, $mNaN
Total operating expenses, $m1147NaN
Operating income, $m135NaN
EBITDA, $m436NaN
Interest expense (income), $mNaN
Earnings before tax, $m-104NaN
Tax expense, $m6NaN
Net income, $m-110NaN

BALANCE SHEET

Cash and short-term investments, $m210NaN
Total assets, $m3896NaN
Adjusted assets (=assets-cash), $m3686NaN
Average production assets, $m3044NaN
Working capital, $m142NaN
Total debt, $m2152NaN
Total liabilities, $m3067NaN
Total equity, $m829NaN
Debt-to-equity ratio2.596NaN
Adjusted equity ratio0.172NaN

CASH FLOW

Net income, $m-110NaN
Depreciation, amort., depletion, $m301NaN
Funds from operations, $mNaN
Change in working capital, $mNaN
Cash from operations, $m319NaN
Maintenance CAPEX, $mNaN
New CAPEX, $mNaN
Total CAPEX, $m-477NaN
Free cash flow, $m796NaN
Issuance/(repurchase) of shares, $mNaN
Retained Cash Flow, $mNaN
Pot'l extraordinary dividend, $m142
Cash available for distribution, $mNaN
Discount rate, %NaN
PV of cash for distribution, $mNaN
Current shareholders' claim on cash, %NaN
HomeMenuAccount