Definitive Analysis
Definitive Analysis

Financial Statements

Analysis Mode

Ticker

Industry

Sector

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 51 of 151 Next »
Ticker Company Dividend Yield % Dividend Per Share Payout Ratio %
032560.KSHwang Kum Steel & Technology Co., Ltd3.18%$186.8216.67%
036800.KQNice Information & Telecommunication, Inc.3.18%$810.0915.68%
0E9V.LEnergiekontor AG3.18%$1.1915.28%
0OG6.LSéché Environnement S.A.3.18%$2.3123.47%
BISI.JKPT BISI International Tbk3.18%$28.0058.11%
ESSITY-A.STEssity AB (publ)3.18%$8.3146.35%
WDP.BRWarehouses De Pauw3.18%$0.7043.49%
002030.KSAsia Holdings Co., Ltd.3.17%$10,332.5636.76%
002532.SZTianshan Aluminum Group Co., Ltd.3.17%$0.5150.09%
012280.KSYeong Hwa Metal Co., Ltd.3.17%$30.0812.47%
0QOB.LAutoneum Holding AG3.17%$5.3138.94%
0RV0.LReply S.p.A.3.17%$3.1542.92%
8174.TNippon Gas Co., Ltd.3.17%$94.1480.69%
PTMP.JKPT Mitra Pack Tbk3.17%$2.6677.22%
QGTS.QAQatar Gas Transport Company Limited (Nakilat) (QPSC)3.17%$0.1447.21%
YKBNK.ISYapi ve Kredi Bankasi A.S.3.17%$1.2122.97%
003200.KSIlshin Spinning Co.,Ltd3.16%$378.1131.94%
092730.KQNeoPharm Co. Ltd.3.16%$600.6333.76%
EALT3.SAElectro Aço Altona S.A.3.16%$0.469.60%
028670.KSPan Ocean Co., Ltd.3.15%$119.6221.90%
1508.HKChina Reinsurance (Group) Corporation3.15%$0.0611.64%
2945.TWSimple Mart Retail Co., Ltd.3.15%$1.2058.50%
3167.TTOKAI Holdings Corporation3.15%$34.0942.72%
ACLN.SWAccelleron Industries AG3.15%$1.9453.11%
ALWEC.PAWe.Connect S.A.3.15%$0.7711.96%
PWH.AXPWR Holdings Limited3.15%$0.2572.35%
603115.SSNantong Haixing Electronics Co., Ltd.3.14%$0.5970.53%
603730.SSShanghai Daimay Automotive Interior Co., Ltd3.14%$0.2794.69%
6459.TDaiwa Industries Ltd.3.14%$49.9046.32%
7849.TStarts Publishing Corporation3.14%$119.6231.71%
KDH.BKThonburi Medical Centre Public Company Limited3.14%$2.5432.51%
OISHI.BKOishi Group Public Company Limited3.14%$1.6048.61%
TAALA.HETaaleri Oyj3.14%$0.2433.28%
WIE.VIWienerberger AG3.14%$0.9555.36%
2645.TWEvergreen Aviation Technologies Corporation3.13%$4.4985.07%
4561.TWOKenturn Nano. Tec. Co., Ltd.3.13%$1.0196.50%
601330.SSDynagreen Environmental Protection Group Co., Ltd.3.13%$0.2141.43%
603939.SSYifeng Pharmacy Chain Co., Ltd.3.13%$0.6850.18%
6287.TSato Holdings Corporation3.13%$75.1834.02%
EUCA3.SAEucatex S.A. Indústria e Comércio3.13%$0.6521.57%
MAIRE.MIMaire Tecnimont S.p.A.3.13%$0.4157.25%
MI-UN.TOMinto Apartment Real Estate Investment Trust3.13%$0.4335.25%
100120.KQVieworks Co., Ltd.3.12%$614.2427.04%
601200.SSShanghai Environment Group Co., Ltd3.12%$0.2556.81%
9611.SRArabian United Float Glass Company3.12%$1.0025.86%
000933.SZHenan Shenhuo Coal Industary and Electricity Power Corporation Limited Class A3.11%$0.8544.77%
2402.TWIchia Technologies, Inc.3.11%$1.9778.30%
600352.SSZhejiang Longsheng Group Co.,Ltd3.11%$0.3352.01%
600529.SSShandong Pharmaceutical Glass Co., Ltd3.11%$0.6253.78%
6416.TWCASwell Inc.3.11%$2.8067.49%