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 79 of 151 Next »
Ticker Company Dividend Yield % Dividend Per Share Payout Ratio %
600082.SSTianjin Hi-Tech Development Co.,Ltd.1.68%$0.0772.77%
603815.SSAnhui Gourgen Traffic Construction Co.,Ltd.1.68%$0.1245.85%
7280.TMitsuba Corporation1.68%$17.578.76%
8985.TJapan Hotel REIT Investment Corporation1.68%$1,370.9717.79%
002836.SZGuangdong New Grand Long Packing Co., Ltd.1.67%$0.2597.86%
2419.HKDekon Food & Agriculture Group1.67%$1.167.76%
5357.TYotai Refractories Co., Ltd.1.67%$30.3125.15%
600312.SSHenan Pinggao Electric Co.,Ltd.1.67%$0.2934.28%
600933.SSIKD Co., Ltd.1.67%$0.3431.46%
603259.SSWuXi AppTec Co., Ltd.1.67%$1.5231.50%
688580.SSNanjing Vishee Medical Technology Co., Ltd1.67%$0.8161.33%
8359.TThe Hachijuni Bank, Ltd.1.67%$28.2722.23%
9597.SRLeaf Global Environmental Services Co.1.67%$0.5625.93%
BBMD.JKPT Bank Mestika Dharma Tbk1.67%$34.2540.25%
ELN.MIEL.En. S.p.A.1.67%$0.2325.56%
HARB-B.COHarboes Bryggeri A/S1.67%$2.0018.85%
HARVIA.HEHarvia Oyj1.67%$0.7256.92%
NORBT.OLNorbit ASA1.67%$2.9950.40%
002240.KSKiswire Ltd.1.66%$350.6518.13%
011780.KSKumho Petrochemical Co., Ltd.1.66%$1,950.8219.35%
0QI7.LAddtech AB (publ.)1.66%$3.2043.14%
1346.HKLever Style Corporation1.66%$0.0247.86%
1789.HKAK Medical Holdings Limited1.66%$0.1022.23%
273640.KQYM Tech Co., Ltd.1.66%$139.5629.02%
300039.SZShanghai Kaibao Pharmaceutical CO.,Ltd1.66%$0.1030.28%
603231.SSSolbar Ningbo Protein Technology Co., Ltd.1.66%$0.3032.96%
688575.SSShenzhen YHLO Biotech Co., Ltd.1.66%$0.2493.71%
AKBNK.ISAkbank T.A.S.1.66%$1.2213.20%
TFIITFI International Inc.1.66%$1.7745.37%
002124.SZTech-Bank Food Co., Ltd.1.65%$0.0526.60%
002978.SZSichuan Anning Iron and Titanium Co.,Ltd.1.65%$0.5431.99%
009470.KSSamwha Electric Co.,Ltd.1.65%$500.1426.53%
009900.KSMyoung Shin Industrial Co.,Ltd1.65%$149.459.10%
0743.HKAsia Cement (China) Holdings Corporation1.65%$0.0425.13%
0HDQ.LSynergie SE1.65%$0.509.05%
1308.HKSITC International Holdings Company Limited1.65%$0.4666.51%
2273.HKGushengtang Holdings Limited1.65%$0.4819.04%
300750.SZContemporary Amperex Technology Co., Limited1.65%$6.0743.20%
300856.SZNanjing COSMOS Chemical Co., Ltd.1.65%$0.2283.60%
300932.SZSanyou Corporation Limited1.65%$0.2084.47%
323410.KSKakaoBank Corp.1.65%$360.2837.33%
5101.TThe Yokohama Rubber Co., Ltd.1.65%$99.2824.61%
601228.SSGuangzhou Port Company Limited1.65%$0.0545.08%
603193.SSRunben Biotechnology1.65%$0.4052.98%
603312.SSSuzhou W Deane New Power Elec1.65%$0.7741.51%
9542.SRKeir International Co.1.65%$0.0723.35%
CEVI.STCellaVision AB (publ)1.65%$2.5039.38%
SIISprott Inc.1.65%$1.6761.40%
ZUE.WAZUE S.A.1.65%$0.2151.75%
2758.TWOLouisa Professional Coffee Ltd.1.64%$1.5047.97%