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 71 of 151 Next »
Ticker Company Dividend Yield % Dividend Per Share Payout Ratio %
603556.SSHexing Electrical Co.,Ltd.2.03%$0.7437.74%
CUERVO.MXBecle, S.A.B. de C.V.2.03%$0.4216.99%
MDIA3.SAM. Dias Branco S.A. Indústria e Comércio de Alimentos2.03%$0.4824.23%
TRH1V.HETrainers' House Oyj2.03%$0.0541.72%
000065.SZNorinco International Cooperation Ltd.2.02%$0.2534.80%
001206.SZTianjin Yiyi Hygiene Products Co.,Ltd2.02%$0.6050.08%
0QND.LBachem Holding AG2.02%$1.2136.62%
300705.SZHunan Jiudian Pharmaceutical Co., Ltd.2.02%$0.3033.69%
3711.TWASE Technology Holding Co., Ltd.2.02%$5.2165.40%
600497.SSYunnan Chihong Zinc & Germanium Co., Ltd.2.02%$0.1565.03%
BMEB3.SABanco Mercantil do Brasil S.A.2.02%$1.2523.03%
COGN3.SACogna Educação S.A.2.02%$0.069.04%
CZG.PRColt CZ Group SE2.02%$15.0050.93%
PINFRA.MXPromotora y Operadora de Infraestructura, S. A. B. de C. V.2.02%$5.3312.11%
002138.SZShenzhen Sunlord Electronics Co.,Ltd.2.01%$0.7256.61%
012630.KSHDC HOLDINGS CO.,Ltd2.01%$351.076.96%
0303.HKVtech Holdings Limited2.01%$1.2497.00%
300519.SZZhejiang Xinguang Pharmaceutical Co., Ltd.2.01%$0.3082.84%
6096.TRareJob Inc.2.01%$6.4030.88%
AKRN.MEPJSC Acron2.01%$363.0128.13%
CGY.TOCalian Group Ltd.2.01%$1.1363.09%
FORUS.SNForus S.A.2.01%$46.8542.68%
INDU-A.STAB Industrivärden (publ)2.01%$8.2525.83%
002773.SZChengdu Kanghong Pharmaceutical Group Co., Ltd2.00%$0.6044.20%
004080.KSShinhung Co., Ltd2.00%$279.3556.15%
600388.SSFujian Longking Co., Ltd.2.00%$0.3342.78%
7199.TPremium Group Co., Ltd.2.00%$38.8033.41%
EVANS.BOEvans Electric Ltd.2.00%$2.5014.08%
PFV.DEPfeiffer Vacuum Technology AG2.00%$3.1699.27%
002996.SZChongqing Shunbo Aluminum Co.,Ltd.1.99%$0.1568.38%
0285.HKBYD Electronic (International) Company Limited1.99%$0.7022.65%
1948.HKUju Holding Limited1.99%$0.0823.66%
301119.SZHangzhou Zhengqiang Corporation Limited1.99%$1.0594.30%
3391.TTsuruha Holdings Inc.1.99%$57.3849.48%
3545.TWFocalTech Systems Co., Ltd.1.99%$1.0236.23%
601579.SSKuaijishan Shaoxing Rice Wine Co., Ltd.1.99%$0.4094.73%
603025.SSBeijing Dahao Technology Corp.,Ltd1.99%$0.3657.13%
603313.SSHealthcare Co., Ltd.1.99%$0.1860.06%
000554.SZSINOPEC Shandong Taishan Pectroleum CO.,LTD.1.98%$0.1338.84%
000997.SZNewland Digital Technology Co.,Ltd.1.98%$0.5650.65%
1381.HKCanvest Environmental Protection Group Company Limited1.98%$0.1012.54%
300795.SZZhejiang Meorient Commerce Exhibition Inc.1.98%$0.2765.37%
600482.SSChina Shipbuilding Industry Group Power Co., Ltd.1.98%$0.4149.72%
6005.TMiura Co., Ltd.1.98%$60.2627.67%
603197.SSShanghai Baolong Automotive Corporation1.98%$0.7361.39%
605058.SSChangzhou Aohong Electronics Co., Ltd.1.98%$0.6058.36%
BLA-R.BKBangkok Life Assurance Public Company Limited1.98%$0.4013.92%
LAS-A.TOLassonde Industries Inc.1.98%$4.3023.88%
NREST.STNordrest Holding AB (publ)1.98%$4.9045.35%
SGER.JKPT Sumber Global Energy Tbk1.98%$8.2746.12%