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 43 of 151 Next »
Ticker Company Dividend Yield % Dividend Per Share Payout Ratio %
9541.SRAcademy Of Learning Company3.74%$0.4378.32%
BBCA.JKPT Bank Central Asia Tbk3.74%$300.0564.91%
BKGI.BKBangkok Genomics Innovation Public Company Limited3.74%$0.0588.71%
DACDanaos Corporation3.74%$3.5614.02%
JKON.JKPT Jaya Konstruksi Manggala Pratama Tbk3.74%$3.2545.42%
MDKI.JKPT Emdeki Utama Tbk3.74%$8.0062.54%
NORCO.OLNorconsult ASA3.74%$1.6672.73%
SLCE3.SASLC Agrícola S.A.3.74%$0.5541.84%
3948.HKInner Mongolia Yitai Coal Co., Ltd.3.73%$0.6524.32%
IDPR.JKPT Indonesia Pondasi Raya Tbk3.73%$10.0075.77%
KIMBERA.MXKimberly-Clark de México, S. A. B. de C. V.3.73%$1.4357.51%
PGMN3.SAEmpreendimentos Pague Menos S.A.3.73%$0.2374.59%
QIBK.QAQatar Islamic Bank (Q.P.S.C.)3.73%$0.8944.73%
002367.SZCanny Elevator Co., Ltd.3.72%$0.3060.41%
600300.SSV V Food & Beverage Co.,Ltd3.72%$0.1351.92%
603899.SSShanghai M&G Stationery Inc.3.72%$1.0169.72%
RHC.AXRamsay Health Care Limited3.72%$1.2932.49%
000999.SZChina Resources Sanjiu Medical & Pharmaceutical Co., Ltd.3.71%$1.0663.26%
214180.KQHecto Innovation Co., Ltd.3.71%$602.8723.75%
603948.SSZhejiang Jianye Chemical Co., Ltd.3.71%$1.0175.31%
6089.TWill Group, Inc.3.71%$44.4274.52%
QNNS.QAQatar Navigation Q.P.S.C.3.71%$0.4038.98%
016610.KSDB Securities Co., Ltd.3.70%$404.3430.24%
2471.TS-Pool, Inc.3.70%$10.1043.62%
3430.TWOChitec Technology Co., Ltd.3.70%$2.5075.20%
4560.TWStrong H Machinery Technology (Cayman) Incorporation3.70%$1.2042.07%
5347.KLTenaga Nasional Berhad3.70%$0.5162.35%
LOOMIS.STLoomis AB (publ)3.70%$14.1053.46%
MIDW-A.STMidway Holding AB (publ)3.70%$0.9165.00%
PNDORA.COPandora A/S3.70%$25.7237.06%
SPVI.BKS P V I Public Company Limited3.70%$0.0837.67%
3401.TTeijin Limited3.69%$49.9735.81%
BZU.MIBuzzi Unicem S.p.A.3.69%$1.9018.48%
CWP.AXCedar Woods Properties Limited3.69%$0.3115.67%
CX.STCombinedX AB (publ)3.69%$1.3755.29%
REH.AXReece Limited3.69%$0.4943.22%
000783.SZChangjiang Securities Company Limited3.68%$0.3043.98%
014820.KSDongwon Systems Corporation3.68%$916.7745.73%
2245.HKLygend Resources & Technology Co., Ltd.3.68%$0.9136.29%
5DD.SIMicro-Mechanics (Holdings) Ltd.3.68%$0.0666.85%
600598.SSHeilongjiang Agriculture Company Limited3.68%$0.5589.21%
601156.SSEastern Air Logistics Co., Ltd.3.68%$0.6841.00%
NICL.JKPT PAM Mineral Tbk3.68%$51.0099.38%
PNBN.JKP.T. Bank Pan Indonesia Tbk3.68%$42.0037.86%
3617.TWCyber Power Systems, Inc.3.67%$7.6445.54%
5296.KLMr D.I.Y. Group (M) Berhad3.67%$0.0687.61%
600535.SSTasly Pharmaceutical Group Co., Ltd3.67%$0.5575.36%
8424.TFuyo General Lease Co., Ltd.3.67%$157.5152.44%
9937.TWNational Petroleum Co., Ltd.3.67%$2.1088.32%
KEMIRA.HEKemira Oyj3.67%$0.7249.87%