Definitive Analysis
Loading...
Definitive Analysis

Financial Statements

Periods / Units / Analysis

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 68 of 151 Next »
Ticker Company Dividend Yield % Dividend Per Share Payout Ratio %
0316.HKOrient Overseas (International) Limited2.19%$2.7948.77%
3109.TShikibo Ltd.2.19%$22.8930.55%
3679.TZIGExN Co., Ltd.2.19%$10.5526.56%
4516.TNippon Shinyaku Co., Ltd.2.19%$123.8726.14%
4617.TChugoku Marine Paints, Ltd.2.19%$96.7242.42%
600051.SSNingbo United Group Co.,Ltd.2.19%$0.1755.08%
603799.SSZhejiang Huayou Cobalt Co., Ltd2.19%$1.4948.01%
7233.KLDufu Technology Corp. Berhad2.19%$0.0495.65%
9064.TYamato Holdings Co., Ltd.2.19%$48.3336.15%
9948.TARCS Company Limited2.19%$74.0133.92%
000049.SZShenzhen Desay Battery Technology Co., Ltd.2.18%$0.5954.00%
000153.SZAnhui Fengyuan Pharmaceutical Co., Ltd.2.18%$0.1455.80%
002237.SZShandong Humon Smelting Co., Ltd.2.18%$0.2961.47%
002626.SZXiamen Kingdomway Group Company2.18%$0.4354.26%
2468.TWFortune Information Systems Corp2.18%$0.9078.36%
300815.SZEIT Environmental Development Group Co.,Ltd2.18%$0.5038.67%
300910.SZXinxiang Richful Lube Additive Co., Ltd2.18%$1.2345.00%
4908.TWOAPAC Opto Electronics Inc.2.18%$1.7472.09%
601369.SSXi'an Shaangu Power Co., Ltd.2.18%$0.2237.55%
067160.KQSoop Co., Ltd.2.17%$1,492.2515.52%
3898.HKZhuzhou CRRC Times Electric Co., Ltd.2.17%$0.8329.19%
4507.TShionogi & Co., Ltd.2.17%$61.6530.72%
603383.SSFujian Apex Software Co.,LTD2.17%$0.7883.82%
603568.SSZhejiang Weiming Environment Protection Co., Ltd.2.17%$0.5534.14%
7181.TJapan Post Insurance Co., Ltd.2.17%$102.1324.56%
053800.KQAhnLab, Inc.2.16%$1,304.4028.50%
0QI9.LCreades AB2.16%$1.5916.64%
601233.SSTongkun Group Co., Ltd.2.16%$0.3750.52%
605056.SSXianheng International Science&Technology Co., Ltd.2.16%$0.3657.45%
MGICMagic Software Enterprises Ltd.2.16%$0.5669.02%
002311.SZGuangdong Haid Group Co., Limited2.15%$1.1939.51%
3727.TAplix Corporation2.15%$3.4454.78%
603586.SSShandong Gold Phoenix Co.,Ltd2.15%$0.4151.17%
6268.TNabtesco Corporation2.15%$80.7460.45%
ATRLJ-B.STAtrium Ljungberg AB (publ)2.15%$0.7141.67%
BPAN4.SABanco Pan S.A.2.15%$0.2441.77%
NCM.AXNewcrest Mining Limited2.15%$0.5038.39%
PARAUCO.SNParque Arauco S.A.2.15%$62.7342.33%
SHANG.BKShangri-La Hotel Public Company Limited2.15%$1.0056.93%
VZUG.SWV-ZUG Holding AG2.15%$0.9119.03%
WTIF.SGWisdomTree Japan Equity UCITS ETF2.15%$0.9891.42%
002258.SZLier Chemical Co.,LTD.2.14%$0.2848.19%
002605.SZShanghai Yaoji Technology Co., Ltd.2.14%$0.5042.55%
0GZV.ILGetinge AB (publ)2.14%$4.6761.88%
0PMJ.LSiemens Healthineers AG2.14%$0.9549.72%
300482.SZGuangzhou Wondfo Biotech Co.,Ltd2.14%$0.4274.45%
5288.KLSime Darby Property Berhad2.14%$0.0342.63%
603218.SSRiyue Heavy Industry Co., Ltd.2.14%$0.2852.42%
BXB.AXBrambles Limited2.14%$0.4940.03%
POBS.BOPlatinumOne Business Services2.14%$3.0015.69%