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.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 70 of 151 Next »
Ticker Company Dividend Yield % Dividend Per Share Payout Ratio %
6101.TTsugami Corporation2.08%$59.7021.18%
9549.SRAbdulaziz and Mansour Ibrahim Albabtin Co.2.08%$0.5029.71%
FPAR-A.STFastPartner AB (publ)2.08%$0.9755.03%
GRNG.STGränges AB (publ)2.08%$3.0934.78%
ZGNErmenegildo Zegna N.V.2.08%$0.2228.26%
000983.SZShanxi Coking Coal Energy Group Co.,Ltd.2.07%$0.1344.44%
006090.KSOyang Corporation2.07%$187.5543.67%
0O1O.LVetoquinol S.A.2.07%$1.7419.10%
1748.HKXin Yuan Enterprises Group Limited2.07%$0.0462.70%
4677.KLYTL Corporation Berhad2.07%$0.0426.42%
603136.SSJiangsu Tianmu Lake Tourism Co.,Ltd2.07%$0.2464.23%
7965.TZojirushi Corporation2.07%$32.3536.35%
MRSA3B.SAMRS Logística S.A.2.07%$0.8118.86%
OCL.AXObjective Corporation Limited2.07%$0.3457.76%
TRTNTriton International Limited2.07%$1.6528.50%
001219.SZQingdao Foods CO.,LTD.2.06%$0.2955.25%
002351.SZEdifier Technology Co., Ltd.2.06%$0.2553.80%
004830.KSDuksung Co., Ltd.2.06%$100.3019.66%
600120.SSZhejiang Orient Financial Holdings Group Co., Ltd.2.06%$0.1332.28%
600143.SSKingfa Sci. & Tech. Co., Ltd.2.06%$0.4085.82%
7735.TSCREEN Holdings Co., Ltd.2.06%$314.4332.13%
ALSO3.SAAliansce Sonae Shopping Centers S.A.2.06%$0.529.27%
MLIA.JKPT Mulia Industrindo Tbk2.06%$6.9827.72%
REA.AXREA Group Limited2.06%$3.8151.46%
THEON.ASTheon International PLC2.06%$0.5552.53%
000902.SZYONFER Agricultural Technology Co., Ltd.2.05%$0.3226.06%
002938.SZAvary Holding(Shenzhen)Co., Limited2.05%$1.0459.37%
036930.KQJUSUNG ENGINEERING Co., Ltd.2.05%$625.5045.79%
086280.KSHyundai Glovis Co., Ltd.2.05%$3,700.1019.97%
2730.TEDION Corporation2.05%$43.4130.64%
4191.SRAbdullah Saad Mohammed Abo Moati for Bookstores Company2.05%$1.0176.56%
9527.SRAme Company For Medical Supplies2.05%$2.0027.73%
BMIN3.SABanco Mercantil de Investimentos S.A.2.05%$0.4728.32%
GUAR3.SAGuararapes Confecções S.A.2.05%$0.1820.09%
MGROS.ISMigros Ticaret A.S.2.05%$10.8831.41%
MLL.DEMüller - Die lila Logistik AG2.05%$0.106.76%
RAY-A.TOStingray Group Inc.2.05%$0.3039.32%
VIVA3.SAVivara Participações S.A.2.05%$0.6620.93%
268280.KSMiwon Specialty Chemical Co., Ltd.2.04%$2,814.5722.79%
2869.HKGreentown Service Group Co. Ltd.2.04%$0.0917.96%
450330.KQHass2.04%$131.7935.27%
605589.SSJinan Shengquan Group Share Holding Co., Ltd.2.04%$0.5844.86%
CEK.DECeoTronics AG2.04%$0.2634.71%
CSAP.JKPT Catur Sentosa Adiprana Tbk2.04%$6.5030.53%
ROTH.PARothschild & Co SCA2.04%$0.7813.71%
2476.TWG-SHANK Enterprise Co., Ltd.2.03%$1.8549.48%
2852.KLCahya Mata Sarawak Berhad2.03%$0.0328.80%
3788.HKChina Hanking Holdings Limited2.03%$0.0836.16%
4004.SRDallah Healthcare Company2.03%$2.5449.37%
601607.SSShanghai Pharmaceuticals Holding Co., Ltd2.03%$0.3623.77%