Definitive Analysis
Loading...
Definitive Analysis

Financial Statements

Ticker

Industry

Sector

Consolidated Edison, Inc. (ED)

Company Dividend Discount ModelIndustry: Regulated ElectricSector: Utilities

Valuation Snapshot

Stable Growth$106.37 - $230.39$152.15
Multi-Stage$150.12 - $164.67$157.26
Blended Fair Value$154.70
Current Price$100.52
Upside53.90%
DecisionBuy

Dividend History & Growth Metrics (10Y)

Metric5Y CAGR10Y CAGR2024202320222021202020192018201720162015
DPS3.55%4.06%3.093.083.062.902.742.602.372.262.152.06
YoY Growth--0.36%0.64%5.73%5.64%5.52%9.74%4.86%5.24%4.09%-0.81%
Dividend Yield--2.80%3.41%3.20%3.06%3.66%3.33%2.81%2.90%2.76%2.69%

Stable Growth Model (Adjusted)

(USD in Millions except Per Share Data)
Net Income To Common (M)2,035.00
(-) Cash Dividends Paid (M)1,147.00
(=) Cash Retained (M)888.00
MetricLOWBASEHIGH
Required Retention Ratio20.0%12.5%7.5%
(=) Cash Required (M)407.00254.38152.63
Cash Retained (M)888.00888.00888.00
(-) Cash Required (M)-407.00-254.38-152.63
(=) Excess Retained (M)481.00633.63735.38
(/) Shares Outstanding (M)355.68355.68355.68
(=) Excess Retained per Share1.351.782.07
LTM Dividend per Share3.223.223.22
(+) Excess Retained per Share1.351.782.07
(=) Adjusted Dividend4.585.015.29
WACC / Discount Rate6.37%6.37%6.37%
Growth Rate1.98%2.98%3.98%
Fair Value$106.37$152.15$230.39
Upside / Downside5.82%51.36%129.20%

Multi-Stage Model: Projections

(USD in Millions)
MetricTTMDec-27Dec-28Dec-29Dec-30Dec-31Terminal
Net Income (M)2,035.002,095.722,158.262,222.662,288.982,357.292,428.00
Payout Ratio56.36%63.09%69.82%76.55%83.27%90.00%92.50%
Projected Dividends (M)1,147.001,322.211,506.861,701.351,906.102,121.562,245.90

Multi-Stage Valuation

MetricLOWBASEHIGH
WACC / Discount Rate6.37%6.37%6.37%
Growth Rate1.98%2.98%3.98%
Year 1 PV (M)1,230.931,243.001,255.07
Year 2 PV (M)1,305.981,331.721,357.71
Year 3 PV (M)1,372.751,413.531,455.10
Year 4 PV (M)1,431.781,488.771,547.44
Year 5 PV (M)1,483.601,557.781,634.90
PV of Terminal Value (M)46,568.6448,897.0051,317.56
Equity Value (M)53,393.6955,931.7958,567.78
Shares Outstanding (M)355.68355.68355.68
Fair Value$150.12$157.26$164.67
Upside / Downside49.34%56.44%63.81%

High-Yield Dividend Screener

« Prev Page 74 of 151 Next »
Ticker Company Dividend Yield % Dividend Per Share Payout Ratio %
PHN.MIPharmanutra S.p.A.1.89%$1.0254.97%
002117.SZTungkong Inc.1.88%$0.2667.89%
031440.KSSHINSEGAE FOOD Inc.1.88%$899.9814.67%
1590.TWAirTAC International Group1.88%$17.9845.66%
2678.HKTexhong Textile Group Limited1.88%$0.096.21%
4112.THodogaya Chemical Co., Ltd.1.88%$42.1632.13%
4739.TITOCHU Techno-Solutions Corporation1.88%$81.1350.53%
600499.SSKeda Industrial Group Co., Ltd.1.88%$0.2634.23%
6594.TNidec Corporation1.88%$40.0525.72%
GFPT-R.BKGFPT Public Company Limited1.88%$0.2010.54%
NGI.AXNavigator Global Investments Limited1.88%$0.0619.77%
SVW.AXSeven Group Holdings Limited1.88%$0.8731.55%
002461.SZGuangzhou Zhujiang Brewery Co., Ltd1.87%$0.1740.51%
002788.SZLuyan Pharma Co.,Ltd.1.87%$0.4049.91%
600600.SSTsingtao Brewery Company Limited1.87%$1.1433.65%
600900.SSChina Yangtze Power Co., Ltd.1.87%$0.5137.99%
603238.SSHangZhou Nbond Nonwovens Co., Ltd.1.87%$0.3348.05%
6875.TMegaChips Corporation1.87%$148.1788.24%
7095.KLP.I.E. Industrial Berhad1.87%$0.0544.49%
8334.TThe Gunma Bank, Ltd.1.87%$32.3726.45%
BVB.DEBorussia Dortmund GmbH & Co. Kommanditgesellschaft auf Aktien1.87%$0.0623.76%
DNG.TODynacor Group Inc.1.87%$0.1028.25%
ICNC-UNIconic Sports Acquisition Corp.1.87%$0.2030.34%
PAZ.SNPaz Corp S.A.1.87%$14.9926.20%
002756.SZYongxing Special Materials Technology Co.,Ltd1.86%$1.0188.45%
006980.KSWoosung Co., Ltd.1.86%$299.972.95%
084110.KQHuons Global Co., Ltd.1.86%$939.2047.07%
4100.SRMakkah Construction & Development Company1.86%$1.4866.05%
603867.SSZhejiang Xinhua Chemical Co.,Ltd1.86%$0.4738.85%
6849.TNihon Kohden Corporation1.86%$31.3228.12%
9515.SRFesh Fash Snack Food Production Company1.86%$0.1824.81%
CIMSA.ISÇimsa Çimento Sanayi ve Ticaret A.S.1.86%$0.8543.17%
EGATIF.BKElectricity Generating Authority Of Thailand- North Bangkok Power Plant Block 1 Infrastructure Fund1.86%$0.1122.36%
ESNTEssent Group Ltd.1.86%$1.2117.35%
RVRC.STRVRC Holding AB (publ)1.86%$1.2044.59%
002803.SZXiamen Jihong Technology Co., Ltd.1.85%$0.3049.75%
2467.TWC Sun Mfg Ltd.1.85%$4.9998.76%
300160.SZJiangsu Xiuqiang Glasswork Co., Ltd.1.85%$0.1037.25%
600609.SSShenyang Jinbei Automotive Company Limited1.85%$0.0941.26%
601882.SSNingbo Haitian Precision Machinery Co.,Ltd.1.85%$0.3641.14%
603199.SSAnhui Jiuhuashan Tourism Development Co., Ltd.1.85%$0.6835.31%
7245.TDaido Metal Co., Ltd.1.85%$18.1630.01%
BTGB2Gold Corp.1.85%$0.0856.43%
COIC.STConcentric AB (publ)1.85%$4.2555.44%
MPCC.OLMPC Container Ships ASA1.85%$0.3256.17%
000823.SZGuangdong Goworld Co., Ltd.1.84%$0.2554.48%
0529.HKSiS International Holdings Limited1.84%$0.043.76%
0KBI.LKnorr-Bremse AG1.84%$1.7566.92%
300866.SZAnker Innovations Limited1.84%$2.1043.92%
4013.SRDr. Sulaiman Al Habib Medical Services Group Company1.84%$4.7270.08%