GURUFOCUS.COM » STOCK LIST » Communication Services » Telecommunication Services » Consolidated Communications Holdings Inc (NAS:CNSL) » Definitions » Shiller PE Ratio

Consolidated Communications Holdings (Consolidated Communications Holdings) Shiller PE Ratio

: (As of Today)
View and export this data going back to 2005. Start your Free Trial

Shiller PE for Stocks: The True Measure of Stock Valuation


Consolidated Communications Holdings Shiller PE Ratio Historical Data

The historical data trend for Consolidated Communications Holdings's Shiller PE Ratio can be seen below:

* For Operating Data section: All numbers are indicated by the unit behind each term and all currency related amount are in USD.
* For other sections: All numbers are in millions except for per share data, ratio, and percentage. All currency related amount are indicated in the company's associated stock exchange currency.

* Premium members only.

Consolidated Communications Holdings Annual Data
Trend Dec14 Dec15 Dec16 Dec17 Dec18 Dec19 Dec20 Dec21 Dec22 Dec23
Shiller PE Ratio
Premium Member Only Premium Member Only Premium Member Only Premium Member Only Premium Member Only 9.57 14.82 86.77 24.15 -

Consolidated Communications Holdings Quarterly Data
Mar19 Jun19 Sep19 Dec19 Mar20 Jun20 Sep20 Dec20 Mar21 Jun21 Sep21 Dec21 Mar22 Jun22 Sep22 Dec22 Mar23 Jun23 Sep23 Dec23
Shiller PE Ratio Premium Member Only Premium Member Only Premium Member Only Premium Member Only Premium Member Only Premium Member Only Premium Member Only Premium Member Only Premium Member Only Premium Member Only Premium Member Only Premium Member Only Premium Member Only Premium Member Only Premium Member Only 24.15 30.33 - - -

Competitive Comparison

For the Telecom Services subindustry, Consolidated Communications Holdings's Shiller PE Ratio, along with its competitors' market caps and Shiller PE Ratio data, can be viewed below:

* Competitive companies are chosen from companies within the same industry, with headquarter located in same country, with closest market capitalization; x-axis shows the market cap, and y-axis shows the term value; the bigger the dot, the larger the market cap. Note that "N/A" values will not show up in the chart.


Consolidated Communications Holdings Shiller PE Ratio Distribution

For the Telecommunication Services industry and Communication Services sector, Consolidated Communications Holdings's Shiller PE Ratio distribution charts can be found below:

* The bar in red indicates where Consolidated Communications Holdings's Shiller PE Ratio falls into.



Consolidated Communications Holdings Shiller PE Ratio Calculation

For Shiller PE Ratio, the earnings of the past 10 years are inflation-adjusted and averaged. The result is used for P/E calculation. Since it looks at the average over the last 10 years, the Shiller PE Ratio is also called PE10.

The Shiller PE Ratio was first used by professor Robert Shiller to measure the valuation of the overall market. The same calculation is applied here to individual companies.

Consolidated Communications Holdings's E10 for the quarter that ended in Dec. 2023 is calculated as:

For example, Consolidated Communications Holdings's adjusted earnings per share data for the three months ended in Dec. 2023 was:

Adj_EPS=Earnings per Share (Diluted)/CPI of Dec. 2023 (Change)*Current CPI (Dec. 2023)
=-0.51/129.4194*129.4194
=-0.510

Current CPI (Dec. 2023) = 129.4194.

Consolidated Communications Holdings Quarterly Data

Earnings per Share (Diluted) CPI Adj_EPS
201403 0.200 99.695 0.260
201406 0.240 100.560 0.309
201409 0.190 100.428 0.245
201412 -0.220 99.070 -0.287
201503 0.150 99.621 0.195
201506 -0.320 100.684 -0.411
201509 0.050 100.392 0.064
201512 0.090 99.792 0.117
201603 0.150 100.470 0.193
201606 -0.001 101.688 -0.001
201609 0.140 101.861 0.178
201612 0.000 101.863 0.000
201703 -0.070 102.862 -0.088
201706 -0.060 103.349 -0.075
201709 -0.410 104.136 -0.510
201712 1.410 104.011 1.754
201803 -0.160 105.290 -0.197
201806 -0.150 106.317 -0.183
201809 -0.210 106.507 -0.255
201812 -0.200 105.998 -0.244
201903 -0.110 107.251 -0.133
201906 -0.100 108.070 -0.120
201909 0.004 108.329 0.005
201912 -0.080 108.420 -0.095
202003 0.220 108.902 0.261
202006 0.190 108.767 0.226
202009 0.200 109.815 0.236
202012 -0.090 109.897 -0.106
202103 -0.800 111.754 -0.926
202106 -0.710 114.631 -0.802
202109 -0.050 115.734 -0.056
202112 0.120 117.630 0.132
202203 -1.120 121.301 -1.195
202206 -0.100 125.017 -0.104
202209 2.450 125.227 2.532
202212 -0.410 125.222 -0.424
202303 -0.420 127.348 -0.427
202306 -1.050 128.729 -1.056
202309 -0.610 129.860 -0.608
202312 -0.510 129.419 -0.510

Add all the adjusted EPS together and divide 10 will get our E10.

Please note that we use the CPI data of the country/region where the company is headquartered. If the CPI data for that country/region is not available, then we will use the CPI data of the United States as default.


Consolidated Communications Holdings  (NAS:CNSL) Shiller PE Ratio Explanation

Compared with the regular PE Ratio, which works poorly for cyclical businesses, the Shiller PE Ratio smoothed out the fluctuations of profit margins during business cycles. Therefore it is more accurate in reflecting the valuation of the company.

If a company has consistent business performance, the Shiller PE Ratio should give similar results to regular PE Ratio.

Compared with the PS Ratio, the Shiller PE Ratio makes the comparison between different industries more meaningful.


Be Aware

Shiller PE Ratio assumes that over the long term, businesses and profitability revert to their means. If a company's business model does not work in the future compared with the past, Shiller PE Ratio and PS Ratio will give false valuations.


Consolidated Communications Holdings Shiller PE Ratio Related Terms

Thank you for viewing the detailed overview of Consolidated Communications Holdings's Shiller PE Ratio provided by GuruFocus.com. Please click on the following links to see related term pages.


Consolidated Communications Holdings (Consolidated Communications Holdings) Business Description

Traded in Other Exchanges
N/A
Address
2116 South 17th Street, Mattoon, IL, USA, 61938-5973
Consolidated Communications Holdings Inc provides communication services for business and residential customers across various states in the U.S. Its business product suite includes data and Internet solutions, voice, data center services, security services, managed and IT services, and an expanded suite of cloud services. It provides wholesale solutions to wireless and wireline carriers and other service providers including data, voice, network connections, and custom fiber builds and last-mile connections. It offers residential high-speed Internet, video, phone, and home security services as well as multi-service residential and small business bundles.
Executives
Fred Graffam officer: Chief Financial Officer 1990 WITTINGTON PLACE, FARMERS BRANCH TX 75234
Solis Michel Marissa director 7221 LANGMUIR DRIVE, MCKINNEY TX 75071
Steven L Childers officer: Chief Financial Officer CONSOLIDATED COMMUNICATIONS, 121 SOUTH 17TH STREET, MATTOON IL 61938-3987
Andrew Frey director 10802 EXECUTIVE CENTER DRIVE, SUITE 300, LITTLE ROCK AR 72211
Searchlight Iii Cvl Gp, Llc 10 percent owner C/O SEARCHLIGHT CAPITAL PARTNERS, L.P., 745 FIFTH AVENUE, 27TH FLOOR, NEW YORK NY 10151
Searchlight Iii Cvl, L.p. 10 percent owner C/O SEARCHLIGHT CAPITAL PARTNERS, L.P., 745 FIFTH AVENUE, 27TH FLOOR, NEW YORK NY 10151
Robert J Currey director
Maribeth S Rahe director 255 E FIFTH STREET, CINCINNATI OH 45202
David G Fuller director 240 WATSON AVE, OAKVILLE A6 L6J 3V1
Udell C Robert Jr director, officer: President and CEO CONSOLIDATED COMMUNICATIONS, 121 SOUTH 17TH STREET, MATTOON IL 61938-3987
Moore Roger H/ca director 12061 BLUEMONT WAY, ATTN: GENERAL COUNSEL, RESTON VA 20190
Thomas A Gerke director GERKE THOMAS A, OVERLAND PARK KS 66251
Timothy D Taron director P.O. BOX 969, ROSEVILLE CA 95661
Dale E Parker director 93 HOYLAKE, ROCKY MOUNT NC 27804
Richard Anthony Lumpkin director 121 SOUTH 17TH STREET, MATTOON IL 61938