Definitive Analysis
Definitive Analysis

Financial Statements

Fundamentals

Valuations

Miscellaneous

Analysis Mode

Search

Consolidated Edison, Inc. (ED)

Company Dividend Discount ModelIndustry: Regulated ElectricSector: Utilities

Valuation Snapshot

Stable Growth$106.34 - $230.27$152.09
Multi-Stage$150.06 - $164.60$157.20
Blended Fair Value$154.64
Current Price$100.52
Upside53.84%
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.34$152.09$230.27
Upside / Downside5.79%51.30%129.08%

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.921,242.991,255.05
Year 2 PV (M)1,305.951,331.691,357.68
Year 3 PV (M)1,372.701,413.471,455.05
Year 4 PV (M)1,431.711,488.701,547.37
Year 5 PV (M)1,483.521,557.691,634.80
PV of Terminal Value (M)46,548.5248,875.8751,295.38
Equity Value (M)53,373.3155,910.4058,545.33
Shares Outstanding (M)355.68355.68355.68
Fair Value$150.06$157.20$164.60
Upside / Downside49.29%56.38%63.75%

High-Yield Dividend Screener

« Prev Page 41 of 151 Next »
Ticker Company Dividend Yield % Dividend Per Share Payout Ratio %
5271.KLPecca Group Berhad3.89%$0.0781.04%
8183.TWOInfo-Tek Corporation3.89%$1.3053.03%
BDMS-R.BKBangkok Dusit Medical Services Public Company Limited3.89%$0.7572.62%
DANHOS13.MXFibra Danhos3.89%$1.0936.98%
FPE.DEFuchs Petrolub SE3.89%$1.1751.86%
S63.SISingapore Technologies Engineering Ltd3.89%$0.3372.94%
SONIC.BKSonic Interfreight Public Company Limited3.89%$0.0633.00%
0QMW.LKuehne + Nagel International AG3.88%$9.9598.58%
600861.SSFESCO Group Co., Ltd.3.88%$0.7134.85%
CIV.PACaisse régionale de Crédit Agricole Mutuel d'Ille-et-Vilaine Société coopérative3.88%$4.0518.13%
DIR-UN.TODream Industrial Real Estate Investment Trust3.88%$0.4965.95%
GGBR3.SAGerdau S.A.3.88%$0.6845.15%
HMC.AXHMC Capital Limited3.88%$0.1611.87%
000728.SZGuoyuan Securities Company Limited3.87%$0.3252.50%
2145.HKShanghai Chicmax Cosmetic Co., Ltd.3.87%$2.6964.24%
600025.SSHuaneng Lancang River Hydropower Inc.3.87%$0.3575.95%
603970.SSSino-Agri Leading Biosciences Co.,Ltd3.87%$0.5074.51%
6509.TWOTaiwan Hopax Chems.Mfg.Co.,Ltd.3.87%$1.2549.65%
AKZA.ASAkzo Nobel N.V.3.87%$2.3195.66%
1763.HKChina Isotope & Radiation Corporation3.86%$0.8332.12%
600761.SSAnhui Heli Co.,Ltd.3.86%$0.8153.66%
605337.SSZhe Jiang Li Zi Yuan Food Co.,Ltd.3.86%$0.4692.31%
BOSS.DEHugo Boss AG3.86%$1.4043.29%
GOFORE.HEGofore Oyj3.86%$0.5283.77%
LOGO.ISLogo Yazilim Sanayi ve Ticaret A.S.3.86%$5.9443.46%
PKTM.VIPIERER Mobility AG3.86%$0.583.67%
SICT.BKSilicon Craft Technology Public Company Limited3.86%$0.0951.68%
000591.SZCECEP Solar Energy Co.,Ltd.3.85%$0.1763.11%
0QKI.LSwisscom AG3.85%$22.0191.35%
215200.KQMegaStudyEdu Co. Ltd3.85%$1,569.9734.80%
2163.TArtner Co.,Ltd.3.85%$81.5765.08%
3265.TWOWinstek Semiconductor Co., Ltd.3.85%$4.8095.49%
6301.TKomatsu Ltd.3.85%$192.6642.48%
9563.SRBena Steel Industries Co.3.85%$1.5884.07%
CPN-R.BKCentral Pattana Public Company Limited3.85%$2.1257.57%
000080.KSHITEJINRO Co., Ltd.3.84%$700.2055.98%
601921.SSZhejiang Publishing & Media Co., Ltd.3.84%$0.3051.98%
9945.TWRuentex Development Co.,Ltd.3.84%$1.1433.31%
AGUAS-A.SNAguas Andinas S.A.3.84%$14.2270.41%
TNKTeekay Tankers Ltd.3.84%$1.9821.29%
WALMEX.MXWal-Mart de México, S.A.B. de C.V.3.84%$2.1674.07%
000810.KSSamsung Fire & Marine Insurance Co., Ltd.3.83%$19,037.8640.33%
0QPW.LZug Estates Holding AG3.83%$85.0029.91%
9910.TWFeng Tay Enterprises Co., Ltd.3.83%$4.3186.98%
CTC-A.TOCanadian Tire Corporation, Limited3.83%$6.7249.69%
LOR.DEL'Oréal S.A.3.83%$13.9859.38%
SOBOSouth Bow Corporation3.83%$1.0769.36%
0799.HKIGG Inc3.82%$0.1512.76%
105630.KSHansae Co., Ltd.3.82%$500.3039.98%
SIX2.DESixt SE3.82%$2.7144.65%