Logo image of ED

CONSOLIDATED EDISON INC (ED) Stock Fundamental Analysis

NYSE:ED - New York Stock Exchange, Inc. - US2091151041 - Common Stock - Currency: USD

93.86  +1.29 (+1.39%)

After market: 93.86 0 (0%)

Fundamental Rating

4

ED gets a fundamental rating of 4 out of 10. The analysis compared the fundamentals against 25 industry peers in the Multi-Utilities industry. There are concerns on the financial health of ED while its profitability can be described as average. While showing a medium growth rate, ED is valued expensive at the moment. Finally ED also has an excellent dividend rating.


Dividend Valuation Growth Profitability Health

4

1. Profitability

1.1 Basic Checks

In the past year ED was profitable.
ED had a positive operating cash flow in the past year.
Each year in the past 5 years ED has been profitable.
Each year in the past 5 years ED had a positive operating cash flow.
ED Yearly Net Income VS EBIT VS OCF VS FCFED Yearly Net Income VS EBIT VS OCF VS FCFYearly Net Income VS EBIT VS OCF VS FCF 2015 2016 2017 2018 2019 2020 2021 2022 2023 0 2B -2B

1.2 Ratios

ED has a Return On Assets (2.69%) which is in line with its industry peers.
ED has a worse Return On Equity (8.42%) than 68.00% of its industry peers.
ED's Return On Invested Capital of 3.31% is on the low side compared to the rest of the industry. ED is outperformed by 72.00% of its industry peers.
ED had an Average Return On Invested Capital over the past 3 years of 3.43%. This is in line with the industry average of 3.68%.
Industry RankSector Rank
ROA 2.69%
ROE 8.42%
ROIC 3.31%
ROA(3y)2.78%
ROA(5y)2.48%
ROE(3y)8.88%
ROE(5y)7.99%
ROIC(3y)3.43%
ROIC(5y)3.6%
ED Yearly ROA, ROE, ROICED Yearly ROA, ROE, ROICYearly ROA, ROE, ROIC 2015 2016 2017 2018 2019 2020 2021 2022 2023 2 4 6 8 10

1.3 Margins

The Profit Margin of ED (12.26%) is worse than 64.00% of its industry peers.
ED's Profit Margin has improved in the last couple of years.
Looking at the Operating Margin, with a value of 17.79%, ED is doing worse than 92.00% of the companies in the same industry.
ED's Operating Margin has declined in the last couple of years.
Looking at the Gross Margin, with a value of 79.47%, ED belongs to the top of the industry, outperforming 88.00% of the companies in the same industry.
ED's Gross Margin has been stable in the last couple of years.
Industry RankSector Rank
OM 17.79%
PM (TTM) 12.26%
GM 79.47%
OM growth 3Y-9.81%
OM growth 5Y-4.99%
PM growth 3Y24.09%
PM growth 5Y8.93%
GM growth 3Y-2.32%
GM growth 5Y-0.31%
ED Yearly Profit, Operating, Gross MarginsED Yearly Profit, Operating, Gross MarginsYearly Profit, Operating, Gross Margins 2015 2016 2017 2018 2019 2020 2021 2022 2023 20 40 60 80

3

2. Health

2.1 Basic Checks

The Return on Invested Capital (ROIC) is below the Cost of Capital (WACC), so ED is destroying value.
ED has less shares outstanding than it did 1 year ago.
Compared to 5 years ago, ED has more shares outstanding
ED has a worse debt/assets ratio than last year.
ED Yearly Shares OutstandingED Yearly Shares OutstandingYearly Shares Outstanding 2015 2016 2017 2018 2019 2020 2021 2022 2023 100M 200M 300M
ED Yearly Total Debt VS Total AssetsED Yearly Total Debt VS Total AssetsYearly Total Debt VS Total Assets 2015 2016 2017 2018 2019 2020 2021 2022 2023 20B 40B 60B

2.2 Solvency

Based on the Altman-Z score of 1.05, we must say that ED is in the distress zone and has some risk of bankruptcy.
Looking at the Altman-Z score, with a value of 1.05, ED belongs to the top of the industry, outperforming 88.00% of the companies in the same industry.
A Debt/Equity ratio of 1.16 is on the high side and indicates that ED has dependencies on debt financing.
The Debt to Equity ratio of ED (1.16) is better than 88.00% of its industry peers.
Industry RankSector Rank
Debt/Equity 1.16
Debt/FCF N/A
Altman-Z 1.05
ROIC/WACC0.49
WACC6.7%
ED Yearly LT Debt VS Equity VS FCFED Yearly LT Debt VS Equity VS FCFYearly LT Debt VS Equity VS FCF 2015 2016 2017 2018 2019 2020 2021 2022 2023 0 5B 10B 15B 20B

2.3 Liquidity

A Current Ratio of 1.01 indicates that ED should not have too much problems paying its short term obligations.
ED has a better Current ratio (1.01) than 76.00% of its industry peers.
A Quick Ratio of 0.93 indicates that ED may have some problems paying its short term obligations.
ED has a better Quick ratio (0.93) than 100.00% of its industry peers.
Industry RankSector Rank
Current Ratio 1.01
Quick Ratio 0.93
ED Yearly Current Assets VS Current LiabilitesED Yearly Current Assets VS Current LiabilitesYearly Current Assets VS Current Liabilites 2015 2016 2017 2018 2019 2020 2021 2022 2023 2B 4B 6B 8B 10B

4

3. Growth

3.1 Past

ED shows a strong growth in Earnings Per Share. In the last year, the EPS has been growing by 11.29%, which is quite good.
The Earnings Per Share has been growing slightly by 3.17% on average over the past years.
The Revenue has decreased by -1.40% in the past year.
Measured over the past years, ED shows a small growth in Revenue. The Revenue has been growing by 3.51% on average per year.
EPS 1Y (TTM)11.29%
EPS 3Y6.58%
EPS 5Y3.17%
EPS Q2Q%3.7%
Revenue 1Y (TTM)-1.4%
Revenue growth 3Y6.19%
Revenue growth 5Y3.51%
Sales Q2Q%5.68%

3.2 Future

Based on estimates for the next years, ED will show a small growth in Earnings Per Share. The EPS will grow by 6.31% on average per year.
Based on estimates for the next years, ED will show a small growth in Revenue. The Revenue will grow by 4.06% on average per year.
EPS Next Y8.84%
EPS Next 2Y7.02%
EPS Next 3Y6.58%
EPS Next 5Y6.31%
Revenue Next Year1.32%
Revenue Next 2Y2.55%
Revenue Next 3Y2.91%
Revenue Next 5Y4.06%

3.3 Evolution

When comparing the EPS growth rate of the last years to the growth rate of the upcoming years, we see that the growth is accelerating.
When comparing the Revenue growth rate of the last years to the growth rate of the upcoming years, we see that the growth is stable.
ED Yearly Revenue VS EstimatesED Yearly Revenue VS EstimatesYearly Revenue VS Estimates 2014 2015 2016 2017 2018 2019 2020 2021 2022 2023 2024 2025 2026 2027 2028 5B 10B 15B
ED Yearly EPS VS EstimatesED Yearly EPS VS EstimatesYearly EPS VS Estimates 2014 2015 2016 2017 2018 2019 2020 2021 2022 2023 2024 2025 2026 2027 2028 2 4 6

2

4. Valuation

4.1 Price/Earnings Ratio

ED is valuated rather expensively with a Price/Earnings ratio of 17.32.
The rest of the industry has a similar Price/Earnings ratio as ED.
When comparing the Price/Earnings ratio of ED to the average of the S&P500 Index (28.51), we can say ED is valued slightly cheaper.
The Price/Forward Earnings ratio is 16.20, which indicates a correct valuation of ED.
ED's Price/Forward Earnings ratio is in line with the industry average.
Compared to an average S&P500 Price/Forward Earnings ratio of 93.88, ED is valued rather cheaply.
Industry RankSector Rank
PE 17.32
Fwd PE 16.2
ED Price Earnings VS Forward Price EarningsED Price Earnings VS Forward Price Earnings ChartPrice Earnings - Forward Price Earnings PE FPE 20 40 60 80

4.2 Price Multiples

ED's Enterprise Value to EBITDA ratio is a bit more expensive when compared to the industry. ED is more expensive than 60.00% of the companies in the same industry.
Industry RankSector Rank
P/FCF N/A
EV/EBITDA 11.73
ED Per share dataED EPS, Sales, OCF, FCF, BookValue per sharePer Share Data Per Share 0 20 40 60

4.3 Compensation for Growth

The high PEG Ratio(NY), which compensates the Price/Earnings for growth, indicates an expensive valuation of the company.
PEG (NY)1.96
PEG (5Y)5.47
EPS Next 2Y7.02%
EPS Next 3Y6.58%

7

5. Dividend

5.1 Amount

With a Yearly Dividend Yield of 3.75%, ED has a reasonable but not impressive dividend return.
Compared to an average industry Dividend Yield of 3.87, ED pays a bit more dividend than its industry peers.
ED's Dividend Yield is rather good when compared to the S&P500 average which is at 2.27.
Industry RankSector Rank
Dividend Yield 3.75%

5.2 History

The dividend of ED has a limited annual growth rate of 3.25%.
ED has paid a dividend for at least 10 years, which is a reliable track record.
ED has not decreased its dividend for at least 10 years, so it has a reliable track record of non decreasing dividend.
Dividend Growth(5Y)3.25%
Div Incr Years34
Div Non Decr Years34
ED Yearly Dividends per shareED Yearly Dividends per shareYearly Dividends per share 2015 2016 2017 2018 2019 2020 2021 2022 2023 2024 2025 1 2 3

5.3 Sustainability

59.16% of the earnings are spent on dividend by ED. This is a bit on the high side, but may be sustainable.
The dividend of ED is growing, but earnings are growing more, so the dividend growth is sustainable.
DP59.16%
EPS Next 2Y7.02%
EPS Next 3Y6.58%
ED Yearly Income VS Free CF VS DividendED Yearly Income VS Free CF VS DividendYearly Income VS Free CF VS Dividend 2015 2016 2017 2018 2019 2020 2021 2022 2023 0 1B -1B 2B -2B
ED Dividend Payout.ED Dividend Payout, showing the Payout Ratio.ED Dividend Payout.PayoutRetained Earnings

CONSOLIDATED EDISON INC

NYSE:ED (1/30/2025, 6:40:00 PM)

After market: 93.86 0 (0%)

93.86

+1.29 (+1.39%)

Chartmill FA Rating
GICS SectorUtilities
GICS IndustryGroupUtilities
GICS IndustryMulti-Utilities
Earnings (Last)11-07 2024-11-07/amc
Earnings (Next)02-20 2025-02-20/amc
Inst Owners70.39%
Inst Owner Change-0.16%
Ins Owners0.17%
Ins Owner Change3.43%
Market Cap33.18B
Analysts55
Price Target103.5 (10.27%)
Short Float %4.23%
Short Ratio6.57
Dividend
Industry RankSector Rank
Dividend Yield 3.75%
Yearly Dividend3.13
Dividend Growth(5Y)3.25%
DP59.16%
Div Incr Years34
Div Non Decr Years34
Ex-Date02-19 2025-02-19 (0.85)
Surprises & Revisions
EPS beat(2)2
Avg EPS beat(2)0.59%
Min EPS beat(2)0.58%
Max EPS beat(2)0.61%
EPS beat(4)4
Avg EPS beat(4)3.32%
Min EPS beat(4)0.58%
Max EPS beat(4)10.88%
EPS beat(8)5
Avg EPS beat(8)2.52%
EPS beat(12)8
Avg EPS beat(12)3.72%
EPS beat(16)9
Avg EPS beat(16)1.21%
Revenue beat(2)0
Avg Revenue beat(2)-5.36%
Min Revenue beat(2)-8.52%
Max Revenue beat(2)-2.2%
Revenue beat(4)0
Avg Revenue beat(4)-6.49%
Min Revenue beat(4)-9.7%
Max Revenue beat(4)-2.2%
Revenue beat(8)2
Avg Revenue beat(8)-0.46%
Revenue beat(12)6
Avg Revenue beat(12)3.15%
Revenue beat(16)9
Avg Revenue beat(16)2.21%
PT rev (1m)-0.06%
PT rev (3m)3.46%
EPS NQ rev (1m)0%
EPS NQ rev (3m)-1.06%
EPS NY rev (1m)0%
EPS NY rev (3m)0.8%
Revenue NQ rev (1m)0%
Revenue NQ rev (3m)-2.56%
Revenue NY rev (1m)0%
Revenue NY rev (3m)-0.54%
Valuation
Industry RankSector Rank
PE 17.32
Fwd PE 16.2
P/S 2.21
P/FCF N/A
P/OCF 10.12
P/B 1.52
P/tB 1.54
EV/EBITDA 11.73
EPS(TTM)5.42
EY5.77%
EPS(NY)5.8
Fwd EY6.17%
FCF(TTM)-4.14
FCFYN/A
OCF(TTM)9.28
OCFY9.88%
SpS42.54
BVpS61.95
TBVpS60.8
PEG (NY)1.96
PEG (5Y)5.47
Profitability
Industry RankSector Rank
ROA 2.69%
ROE 8.42%
ROCE 4.27%
ROIC 3.31%
ROICexc 3.31%
ROICexgc 3.34%
OM 17.79%
PM (TTM) 12.26%
GM 79.47%
FCFM N/A
ROA(3y)2.78%
ROA(5y)2.48%
ROE(3y)8.88%
ROE(5y)7.99%
ROIC(3y)3.43%
ROIC(5y)3.6%
ROICexc(3y)3.49%
ROICexc(5y)3.67%
ROICexgc(3y)3.55%
ROICexgc(5y)3.76%
ROCE(3y)4.45%
ROCE(5y)4.66%
ROICexcg growth 3Y-7.69%
ROICexcg growth 5Y-6.4%
ROICexc growth 3Y-6.83%
ROICexc growth 5Y-5.71%
OM growth 3Y-9.81%
OM growth 5Y-4.99%
PM growth 3Y24.09%
PM growth 5Y8.93%
GM growth 3Y-2.32%
GM growth 5Y-0.31%
F-Score5
Asset Turnover0.22
Health
Industry RankSector Rank
Debt/Equity 1.16
Debt/FCF N/A
Debt/EBITDA 5.31
Cap/Depr 223%
Cap/Sales 31.53%
Interest Coverage 2.62
Cash Conversion 68.3%
Profit Quality N/A
Current Ratio 1.01
Quick Ratio 0.93
Altman-Z 1.05
F-Score5
WACC6.7%
ROIC/WACC0.49
Cap/Depr(3y)207.71%
Cap/Depr(5y)209.58%
Cap/Sales(3y)28.93%
Cap/Sales(5y)29.67%
Profit Quality(3y)N/A
Profit Quality(5y)N/A
High Growth Momentum
Growth
EPS 1Y (TTM)11.29%
EPS 3Y6.58%
EPS 5Y3.17%
EPS Q2Q%3.7%
EPS Next Y8.84%
EPS Next 2Y7.02%
EPS Next 3Y6.58%
EPS Next 5Y6.31%
Revenue 1Y (TTM)-1.4%
Revenue growth 3Y6.19%
Revenue growth 5Y3.51%
Sales Q2Q%5.68%
Revenue Next Year1.32%
Revenue Next 2Y2.55%
Revenue Next 3Y2.91%
Revenue Next 5Y4.06%
EBIT growth 1Y10.17%
EBIT growth 3Y-4.23%
EBIT growth 5Y-1.65%
EBIT Next Year69.87%
EBIT Next 3Y25.26%
EBIT Next 5Y17.95%
FCF growth 1Y-229.28%
FCF growth 3YN/A
FCF growth 5YN/A
OCF growth 1Y-9.89%
OCF growth 3Y-0.64%
OCF growth 5Y-4.36%