Definitive Analysis | Institutional-Grade Financial Research
Definitive Analysis
Get Full Access
See Pricing Start Free Trial

Consolidated Edison, Inc. (ED)

Company Dividend Discount ModelIndustry: Regulated ElectricSector: Utilities

Valuation Snapshot

Stable Growth$65.78 - $107.99$84.57
Multi-Stage$81.82 - $89.44$85.55
Blended Fair Value$85.06
Current Price$100.52
Upside-15.38%
DecisionDon't Buy

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 Rate9.08%9.08%9.08%
Growth Rate1.98%2.98%3.98%
Fair Value$65.78$84.57$107.99
Upside / Downside-34.56%-15.86%7.43%

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 Rate9.08%9.08%9.08%
Growth Rate1.98%2.98%3.98%
Year 1 PV (M)1,200.381,212.151,223.92
Year 2 PV (M)1,241.961,266.431,291.15
Year 3 PV (M)1,273.051,310.861,349.42
Year 4 PV (M)1,294.831,346.371,399.43
Year 5 PV (M)1,308.401,373.821,441.83
PV of Terminal Value (M)22,781.0323,920.0425,104.16
Equity Value (M)29,099.6430,429.6731,809.90
Shares Outstanding (M)355.68355.68355.68
Fair Value$81.82$85.55$89.44
Upside / Downside-18.61%-14.89%-11.03%

High-Yield Dividend Screener

« Prev Page 5 of 151 Next »
Ticker Company Dividend Yield % Dividend Per Share Payout Ratio %
U11.SIUnited Overseas Bank Limited11.62%$4.1058.46%
9543.SRSaudi Networkers Services Company11.60%$8.7072.96%
0688.HKChina Overseas Land & Investment Limited11.57%$1.4538.43%
0QKP.LPhoenix Mecano AG11.55%$51.5065.02%
601668.SSChina State Construction Engineering Corporation Limited11.55%$0.5954.79%
5983.KLMBM Resources Bhd11.49%$0.6069.77%
601800.SSChina Communications Construction Company Limited11.48%$0.9576.83%
0440.HKDah Sing Financial Holdings Limited11.45%$4.0834.85%
H02.SIHaw Par Corporation Limited11.39%$1.8082.18%
EDV.AXEndeavour Group Limited11.35%$0.4279.74%
102260.KSDongsung Chemical Co., Ltd.11.33%$470.0161.08%
092230.KSKPX Holdings Co.,Ltd.11.32%$8,125.9434.75%
9909.HKPowerlong Commercial Management Holdings Limited11.28%$0.2829.74%
SVR.AXSolvar Limited11.25%$0.2083.01%
HOLCO.ASHolland Colours N.V.11.23%$9.8877.82%
RBN-UN.TOBlue Ribbon Income Fund11.23%$0.9343.10%
0066.HKMTR Corporation Limited11.22%$3.3977.76%
3360.HKFar East Horizon Limited11.17%$0.8944.98%
0934.HKSinopec Kantons Holdings Limited11.16%$0.4758.03%
317400.KSXi S&D Inc.11.16%$481.1664.89%
0146.HKTai Ping Carpets International Limited11.12%$0.2151.92%
096760.KSJW Holdings Corporation11.12%$390.8363.07%
3868.HKXinyi Energy Holdings Limited11.12%$0.1360.32%
BMW3.DEBayerische Motoren Werke AG11.11%$10.5291.60%
1109.HKChina Resources Land Limited11.09%$3.0736.44%
2380.HKChina Power International Development Limited11.08%$0.3656.67%
3900.HKGreentown China Holdings Limited11.07%$0.9398.98%
600016.SSChina Minsheng Banking Corp., Ltd.11.06%$0.4261.11%
BFG.AXBell Financial Group Limited11.06%$0.1590.20%
1571.HKXin Point Holdings Limited11.03%$0.4241.05%
601577.SSBank of Changsha Co., Ltd.11.03%$1.0752.50%
IMMOU.BRImmo Moury SCA11.02%$3.5993.20%
2555.HKSichuan Baicha Baidao Industrial Co., Ltd.11.00%$0.7076.19%
POMO3.SAMarcopolo S.A.10.98%$0.6158.30%
IEL.AXIDP Education Limited10.96%$0.6398.92%
1579.HKYihai International Holding Ltd.10.95%$1.4288.97%
SPTO.JKPT Surya Pertiwi Tbk10.93%$70.5268.08%
TOTG.OLTotens Sparebank10.91%$31.6287.19%
1052.HKYuexiu Transport Infrastructure Limited10.89%$0.5162.60%
601919.SSCOSCO SHIPPING Holdings Co., Ltd.10.89%$1.6567.32%
DETEC.HEDetection Technology Oyj10.89%$1.2399.18%
018500.KSDongwon Metal Co., Ltd.10.86%$150.3024.83%
3799.HKDali Foods Group Company Limited10.86%$0.4172.83%
EBRO.MCEbro Foods, S.A.10.86%$2.0177.79%
023590.KSDaou Technology Inc.10.85%$4,297.7041.75%
0392.HKBeijing Enterprises Holdings Limited10.84%$3.4643.30%
NOVC.DENovo Nordisk A/S10.83%$9.9046.60%
0408.HKYip's Chemical Holdings Limited10.81%$0.2048.65%
4342.SRJadwa Investment - Jadwa Reit Saudi Fund10.80%$1.2085.91%
RIAS-B.CORIAS A/S10.79%$73.9373.44%