Definitive Analysis
Loading...
Definitive Analysis

Financial Statements

Ticker

Industry

Sector

Consolidated Edison, Inc. (ED)

Company Dividend Discount ModelIndustry: Regulated ElectricSector: Utilities

Valuation Snapshot

Stable Growth$106.38 - $230.43$152.16
Multi-Stage$150.14 - $164.68$157.27
Blended Fair Value$154.72
Current Price$100.52
Upside53.92%
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.38$152.16$230.43
Upside / Downside5.83%51.38%129.24%

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.991,331.731,357.72
Year 3 PV (M)1,372.761,413.541,455.12
Year 4 PV (M)1,431.801,488.791,547.46
Year 5 PV (M)1,483.631,557.811,634.92
PV of Terminal Value (M)46,574.4048,903.0451,323.91
Equity Value (M)53,399.5255,937.9158,574.20
Shares Outstanding (M)355.68355.68355.68
Fair Value$150.14$157.27$164.68
Upside / Downside49.36%56.46%63.83%

High-Yield Dividend Screener

« Prev Page 80 of 151 Next »
Ticker Company Dividend Yield % Dividend Per Share Payout Ratio %
301151.SZShanghai Karon Eco-Valve Manufacturing Co., Ltd.1.64%$0.3164.22%
4912.TLion Corporation1.64%$27.1335.97%
5328.TWOHua Jung Components Co.,Ltd.1.64%$0.3573.35%
600256.SSGuanghui Energy Co., Ltd.1.64%$0.0826.14%
605365.SSLeedarson IoT Technology Inc.1.64%$0.4481.91%
6244.TWOMotech Industries Inc.1.64%$0.3498.50%
6367.TDaikin Industries,Ltd.1.64%$330.1235.31%
6383.TDaifuku Co., Ltd.1.64%$80.6636.37%
6454.TMax Co., Ltd.1.64%$113.1545.27%
LSS.PALectra S.A.1.64%$0.4150.95%
MEVA.ATMevaco S.A.1.64%$0.1513.50%
MOVI3.SAMovida Participações S.A.1.64%$0.1619.79%
SRSOLTD.BOSilicon Rental Solutions Ltd.1.64%$1.909.23%
002266.SZZhefu Holding Group Co., Ltd.1.63%$0.0737.41%
0GDU.LParadox Interactive AB (publ)1.63%$5.0082.82%
300121.SZShandong Yanggu Huatai Chemical Co., Ltd.1.63%$0.2153.84%
603013.SSYAPP Automotive Systems Co., Ltd.1.63%$0.4037.85%
603081.SSZhejiang Dafeng Industry Co., Ltd1.63%$0.2392.61%
603194.SSZhejiang E-P Equipment Co Ltd1.63%$0.6429.27%
603221.SSElegant Home-Tech Co., Ltd.1.63%$0.2178.59%
BEI.DEBeiersdorf AG1.63%$1.5225.19%
CLD.WACloud Technologies S.A.1.63%$1.1492.28%
IVS.MIIVS Group S.A.1.63%$0.1262.72%
LDO.MILeonardo S.p.A.1.63%$0.8433.82%
MEOHMethanex Corporation1.63%$0.6724.08%
PARKIN.AEParkin Company PJSC1.63%$0.0949.98%
051900.KSLG H&H Co., Ltd.1.62%$4,377.8370.74%
0F4O.LLotus Bakeries N.V.1.62%$133.7536.00%
300206.SZEdan Instruments, Inc.1.62%$0.2148.61%
5393.TNichias Corporation1.62%$110.0123.11%
603385.SSHuida Sanitary Ware Co., Ltd.1.62%$0.1169.37%
605050.SSFriend Co.,Ltd.1.62%$0.2230.01%
7378.TASIRO Inc.1.62%$23.9320.21%
BPAC11.SABanco BTG Pactual S.A.1.62%$0.8427.38%
GRMNGarmin Ltd.1.62%$3.2840.42%
RUBFILA.BORubfila International Limited1.62%$1.2022.45%
VALO.BABanco de Valores S.A.1.62%$8.9122.52%
WAS.WAWasko S.A.1.62%$0.0319.20%
002152.SZGRG Banking Equipment Co., Ltd.1.61%$0.2265.18%
002457.SZNingxia Qinglong Pipes Industry Group Co., Ltd.1.61%$0.1828.21%
002913.SZAoshikang Technology Co., Ltd.1.61%$0.6960.58%
007570.KSIlyang Pharmaceutical Co.,Ltd1.61%$210.7433.61%
066570.KSLG Electronics Inc.1.61%$1,472.8336.12%
603181.SSZhejiang Huangma Technology Co.,Ltd1.61%$0.2329.53%
603416.SSWuXi Xinje Electric Co.,Ltd.1.61%$0.8959.24%
ABB.AXAussie Broadband Limited1.61%$0.0839.83%
H22.SIHong Leong Asia Ltd.1.61%$0.0431.75%
MATAS.COMatas A/S1.61%$2.0026.57%
SRSN.JKPT Indo Acidatama Tbk1.61%$1.0012.49%
000050.KSKyungbangco.Ltd1.60%$149.6111.55%