GURUFOCUS.COM » STOCK LIST » Utilities » Utilities - Regulated » Consolidated Edison Inc (BSP:E1DI34) » Definitions » Cyclically Adjusted Price-to-FCF

Consolidated Edison (BSP:E1DI34) Cyclically Adjusted Price-to-FCF : (As of Apr. 28, 2024)


View and export this data going back to 2020. Start your Free Trial

What is Consolidated Edison Cyclically Adjusted Price-to-FCF?

Shiller PE for Stocks: The True Measure of Stock Valuation


Consolidated Edison Cyclically Adjusted Price-to-FCF Historical Data

The historical data trend for Consolidated Edison's Cyclically Adjusted Price-to-FCF 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 Edison Cyclically Adjusted Price-to-FCF Chart

Consolidated Edison Annual Data
Trend Dec14 Dec15 Dec16 Dec17 Dec18 Dec19 Dec20 Dec21 Dec22 Dec23
Cyclically Adjusted Price-to-FCF
Get a 7-Day Free Trial Premium Member Only Premium Member Only 164.27 - - - -

Consolidated Edison Quarterly Data
Mar19 Jun19 Sep19 Dec19 Mar20 Jun20 Sep20 Dec20 Mar21 Jun21 Sep21 Dec21 Mar22 Jun22 Sep22 Dec22 Mar23 Jun23 Sep23 Dec23
Cyclically Adjusted Price-to-FCF Get a 7-Day Free Trial 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 - - - - -

Competitive Comparison of Consolidated Edison's Cyclically Adjusted Price-to-FCF

For the Utilities - Regulated Electric subindustry, Consolidated Edison's Cyclically Adjusted Price-to-FCF, along with its competitors' market caps and Cyclically Adjusted Price-to-FCF 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 Edison's Cyclically Adjusted Price-to-FCF Distribution in the Utilities - Regulated Industry

For the Utilities - Regulated industry and Utilities sector, Consolidated Edison's Cyclically Adjusted Price-to-FCF distribution charts can be found below:

* The bar in red indicates where Consolidated Edison's Cyclically Adjusted Price-to-FCF falls into.



Consolidated Edison Cyclically Adjusted Price-to-FCF Calculation

Like the Shiller PE Ratio, the Cyclically Adjusted Price-to-FCF takes the Free Cash Flow per Share from the past 10 years, adjusts it for inflation, and then calculates the average. This average is then used for the P/FCF calculation. Because it considers this 10-year average, it's often referred to as the CAPFCF Ratio.

The Shiller PE Ratio was first used by professor Robert Shiller to measure the valuation of the overall market. The similar calculation is applied by GuruFocus to calculate the Cyclically Adjusted Price-to-FCF.

Consolidated Edison's Cyclically Adjusted FCF per Share for the quarter that ended in Dec. 2023 is calculated as:

For example, Consolidated Edison's adjusted Free Cash Flow per Share data for the three months ended in Dec. 2023 was:

Adj_FreeCashFlowPerShare=Free Cash Flow per Share/CPI of Dec. 2023 (Change)*Current CPI (Dec. 2023)
=-1.981/129.4194*129.4194
=-1.981

Current CPI (Dec. 2023) = 129.4194.

Consolidated Edison Quarterly Data

Free Cash Flow per Share CPI Adj_FreeCashFlowPerShare
201403 -1.324 99.695 -1.719
201406 1.544 100.560 1.987
201409 -0.537 100.428 -0.692
201412 2.139 99.070 2.794
201503 -0.176 99.621 -0.229
201506 0.884 100.684 1.136
201509 -0.922 100.392 -1.189
201512 1.500 99.792 1.945
201603 -1.813 100.470 -2.335
201606 1.396 101.688 1.777
201609 -0.601 101.861 -0.764
201612 -0.351 101.863 -0.446
201703 -1.935 102.862 -2.435
201706 1.627 103.349 2.037
201709 -0.673 104.136 -0.836
201712 0.702 104.011 0.873
201803 -3.588 105.290 -4.410
201806 0.066 106.317 0.080
201809 -2.493 106.507 -3.029
201812 1.524 105.998 1.861
201903 -2.179 107.251 -2.629
201906 1.171 108.070 1.402
201909 -2.745 108.329 -3.279
201912 1.596 108.420 1.905
202003 -3.541 108.902 -4.208
202006 -0.937 108.767 -1.115
202009 -6.327 109.815 -7.457
202012 -2.429 109.897 -2.860
202103 -5.914 111.754 -6.849
202106 0.741 114.631 0.837
202109 -4.890 115.734 -5.468
202112 0.430 117.630 0.473
202203 -2.726 121.301 -2.908
202206 2.911 125.017 3.014
202209 -3.367 125.227 -3.480
202212 1.495 125.222 1.545
202303 -8.073 127.348 -8.204
202306 0.175 128.729 0.176
202309 -7.013 129.860 -6.989
202312 -1.981 129.419 -1.981

Add all the adjusted free cash flow per share together and divide 10 will get our Cyclically Adjusted FCF per Share.

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 Edison  (BSP:E1DI34) Cyclically Adjusted Price-to-FCF Explanation

Compared with the regular Price-to-Free-Cash-Flow, which works poorly for cyclical businesses, the Cyclically Adjusted Price-to-FCF smoothed out the fluctuations of free cash flow during business cycles. Therefore it is more accurate in reflecting the valuation of the company.

If a company has consistent business performance, the Cyclically Adjusted Price-to-FCF should give similar results to regular Price-to-Free-Cash-Flow.


Consolidated Edison Cyclically Adjusted Price-to-FCF Related Terms

Thank you for viewing the detailed overview of Consolidated Edison's Cyclically Adjusted Price-to-FCF provided by GuruFocus.com. Please click on the following links to see related term pages.


Consolidated Edison (BSP:E1DI34) Business Description

Traded in Other Exchanges
Address
4 Irving Place, Room 700, New York, NY, USA, 10003
Con Ed is a holding company for Consolidated Edison of New York, or CECONY, and Orange & Rockland, or O&R. These utilities provide steam, natural gas, and electricity to customers in southeastern New York—including New York City—and small parts of New Jersey. The two utilities generate nearly all of Con Ed's earnings following the sale of its clean energy business to RWE in early 2023.

Consolidated Edison (BSP:E1DI34) Headlines

No Headlines