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

[per Chepakovich valuation model]

other valuations of CNSL

[per Chepakovich valuation model]  See other valuations of CNSL stock

Previous Close$7.94
Intrinsic Value
Upside potential
Previous Close
$7.94

VALUATION INPUT DATA

Revenue, mln $
Initial revenue growth rate (norm.), %
Variable cost ratio, %
Fixed operating expenses, mln $
Production assets / Revenue, %
Working capital / Revenue, %
Interest rate on debt, %
Life of production assets, yrs
Initial discount rate, %
Shares outstanding, mln
Adjusted equity ratio
Adjusted assets / Revenue
Based on fiscal year data as of 2020-12-31 and quarterly data as of 2021-06-30.
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.
  1. Annual
  2. Quarterly YoY
  3. Quarterly QoQ

Annual revenue growth rates, % (past and forecasted)

show cash flow forecast

FINANCIAL STATEMENTS FORECAST and PRESENT VALUE CALCULATION

Fiscal year2020(a)2021202220232024202520262027202820292030203120322033203420352036203720382039204020412042204320442045

INCOME STATEMENT

Revenue growth rate, %-2.5NaN
Revenue, $1304NaN
Variable operating expenses, $mNaN
Fixed operating expenses, $mNaN
Total operating expenses, $m1168NaN
Operating income, $m136NaN
EBITDA, $m460NaN
Interest expense (income), $mNaN
Earnings before tax, $m45NaN
Tax expense, $m11NaN
Net income, $m34NaN

BALANCE SHEET

Cash and short-term investments, $m156NaN
Total assets, $m3693NaN
Adjusted assets (=assets-cash), $m3537NaN
Average production assets, $m3009NaN
Working capital, $m71NaN
Total debt, $m2215NaN
Total liabilities, $m3310NaN
Total equity, $m383NaN
Debt-to-equity ratio5.783NaN
Adjusted equity ratio0.071NaN

CASH FLOW

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