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 44 of 151 Next »
Ticker Company Dividend Yield % Dividend Per Share Payout Ratio %
600583.SSOffshore Oil Engineering Co.,Ltd3.66%$0.2043.97%
601038.SSFirst Tractor Company Limited3.66%$0.5271.49%
601083.SSShanghai Jinjiang Shipping (Group) Co., Ltd.3.66%$0.4135.56%
601860.SSJiangsu Zijin Rural Commercial Bank Co.,Ltd3.66%$0.1025.05%
ENTEL.SNEmpresa Nacional de Telecomunicaciones S.A.3.66%$179.3263.27%
GGRM.JKPT Gudang Garam Tbk3.66%$500.0087.83%
GOB.DECompagnie de Saint-Gobain S.A.3.66%$3.1932.66%
HCLTECH.BOHCL Technologies Limited3.66%$60.0195.42%
LDA.MCLínea Directa Aseguradora, S.A.3.66%$0.0445.97%
QUB.AXQube Holdings Limited3.66%$0.1892.53%
RCIRogers Communications Inc.3.66%$1.3911.08%
RYRoyal Bank of Canada3.66%$6.2443.22%
VTWR.DEVantage Towers AG3.66%$1.1972.52%
2103.TWTSRC Corporation3.65%$0.5586.36%
383800.KSLX Holdings Corp.3.65%$289.9515.18%
3978.HKChina Beststudy Education Group3.65%$0.1427.04%
4952.TWGeneralplus Technology Inc.3.65%$1.2983.85%
QAL.AXQualitas Limited3.65%$0.1366.09%
300628.SZYealink Network Technology Co., Ltd.3.64%$1.3064.58%
688517.SSJinGuan Electric Co., Ltd.3.64%$0.5791.64%
CEZ.PRCEZ, a. s.3.64%$47.1187.97%
EB5.SIFirst Resources Limited3.64%$0.0840.25%
HEIJM.ASKoninklijke Heijmans N.V.3.64%$2.5236.26%
NOVN.SWNovartis AG3.64%$3.9954.32%
0631.HKSany Heavy Equipment International Holdings Company Limited3.63%$0.3138.50%
0MT8.LDrägerwerk AG & Co. KGaA3.63%$2.0031.00%
0N9Z.LEVS Broadcast Equipment S.A.3.63%$1.3426.19%
267980.KQMaeil Dairies Co., Ltd.3.63%$1,244.0920.37%
600968.SSCNOOC Energy Technology & Services Limited3.63%$0.1437.04%
AALI.JKPT Astra Agro Lestari Tbk3.63%$267.9736.41%
EKTER.ATEkter S.A.3.63%$0.1322.08%
IGM.TOIGM Financial Inc.3.63%$2.2551.57%
018670.KSSK Gas Co., Ltd.3.62%$7,934.7324.18%
0RGI.LCosmo Pharmaceuticals N.V.3.62%$3.8148.74%
101530.KSHaitai Confectionery&Foods Co.,ltd.3.62%$250.1327.55%
230360.KQEchomarketing Co.,Ltd.3.62%$503.2355.69%
SANB11.SABanco Santander (Brasil) S.A.3.62%$1.2276.05%
SBSP3.SACompanhia de Saneamento Básico do Estado de São Paulo - SABESP3.62%$4.8245.66%
000786.SZBeijing New Building Materials Public Limited Company3.61%$0.9049.35%
003013.SZGuangzhou Metro Design & Research Institute Co., Ltd.3.61%$0.5137.72%
272550.KSSamyang Packaging Corporation3.61%$482.8352.27%
300908.SZZhongjing Food Co., Ltd.3.61%$1.0081.13%
4188.TMitsubishi Chemical Group Corporation3.61%$33.0539.87%
600332.SSGuangzhou Baiyunshan Pharmaceutical Holdings Company Limited3.61%$0.9350.53%
600742.SSChangchun FAWAY Automobile Components Co.,Ltd3.61%$0.3653.61%
600928.SSBank of Xi'an Co.,Ltd.3.61%$0.1322.27%
CTD.AXCorporate Travel Management Limited3.61%$0.5847.61%
SAMTEL.BKSamart Telcoms Public Company Limited3.61%$0.1583.39%
0K9W.ILHuhtamäki Oyj3.60%$1.0756.07%
0M6I.LHeijmans N.V.3.60%$2.5236.26%