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.37 - $230.39$152.15
Multi-Stage$150.12 - $164.66$157.25
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.81%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.741,413.521,455.10
Year 4 PV (M)1,431.781,488.761,547.44
Year 5 PV (M)1,483.601,557.781,634.89
PV of Terminal Value (M)46,567.7648,896.0651,316.58
Equity Value (M)53,392.7955,930.8458,566.79
Shares Outstanding (M)355.68355.68355.68
Fair Value$150.12$157.25$164.66
Upside / Downside49.34%56.44%63.81%

High-Yield Dividend Screener

« Prev Page 59 of 151 Next »
Ticker Company Dividend Yield % Dividend Per Share Payout Ratio %
QFBQ.QALesha Bank L.L.C2.69%$0.0532.62%
002442.SZLongxing Chemical Stock Co., Ltd.2.68%$0.1799.79%
016800.KSFursys Inc.2.68%$1,200.1730.47%
265520.KQAdvanced Process Systems Corporation2.68%$538.1030.22%
300896.SZImeik Technology Development Co.,Ltd.2.68%$3.8078.17%
3123.TSaibo Co., Ltd.2.68%$16.1426.87%
9057.TEnshu Truck Co.,Ltd.2.68%$96.0831.06%
CHC.AXCharter Hall Group2.68%$0.6553.83%
IFT.AXInfratil Limited2.68%$0.2647.86%
KRZ.IRKerry Group plc2.68%$2.0427.68%
MGH.AXMAAS Group Holdings Limited2.68%$0.1537.02%
NOANorth American Construction Group Ltd.2.68%$0.3932.95%
U06.SISingapore Land Group Limited2.68%$0.0924.45%
000089.SZShenzhen Airport Co., Ltd.2.67%$0.1965.57%
000830.SZLuxi Chemical Group Co., Ltd.2.67%$0.4457.18%
005820.KSWonlim Corporation2.67%$399.8822.01%
007980.KSTP Inc.2.67%$51.627.46%
049800.KSWoojin Plaimm Co., Ltd.2.67%$50.6726.03%
300009.SZAnhui Anke Biotechnology (Group) Co., Ltd.2.67%$0.2662.51%
6220.TWOYFC-Boneagle Electric Co., Ltd.2.67%$0.6989.25%
002753.SZShanxi Yongdong Chemistry Industry Co., Ltd.2.66%$0.1990.03%
011200.KSHMM Co.,Ltd2.66%$537.6722.84%
014830.KSUNID Company Ltd.2.66%$1,782.2616.95%
023450.KSDongnam Chemical Co., Ltd.2.66%$914.8545.96%
210540.KSDY Power Corporation2.66%$350.1314.53%
600729.SSChongqing Department Store Co.,Ltd.2.66%$0.6921.76%
7282.TToyoda Gosei Co., Ltd.2.66%$104.8829.11%
7989.TTachikawa Corporation2.66%$52.4433.02%
9699.TNishio Rent All Co., Ltd.2.66%$125.9628.89%
069730.KSDSR Wire Corp2.65%$99.936.22%
118990.KQMotrex Co., Ltd2.65%$249.2535.67%
OLGERD.ICÖlgerðin Egill Skallagrímsson hf.2.65%$0.4862.79%
084010.KSDaehan Steel Co., Ltd.2.64%$516.5429.55%
0DH7.LAF Gruppen ASA2.64%$4.9752.35%
1504.TWTECO Electric & Machinery Co., Ltd.2.64%$2.2387.91%
2587.TSuntory Beverage & Food Limited2.64%$125.0045.12%
6922.TWONeousys Technology Inc.2.64%$4.5461.30%
SHR.BKS Hotels and Resorts Public Company Limited2.64%$0.0533.96%
002871.SZQingdao Weflo Valve Co., Ltd.2.63%$0.4779.89%
600918.SSZhongtai Securities Co., Ltd.2.63%$0.1768.20%
8572.TAcom Co., Ltd.2.63%$13.0038.71%
LIAB.STLindab International AB (publ)2.63%$5.4076.19%
MYOR.JKPT Mayora Indah Tbk2.63%$57.3845.12%
002443.SZZhejiang Kingland Pipeline and Technologies Co.,Ltd.2.62%$0.2164.11%
039490.KSKiwoom Securities Co., Ltd.2.62%$7,904.3320.30%
155660.KSDSR Corp2.62%$100.1511.70%
4263.SRSAL Saudi Logistics Services Co2.62%$4.2355.27%
AFK.OLArendals Fossekompani ASA2.62%$3.525.05%
INSTAL.STInstalco AB (publ)2.62%$0.6865.47%
000048.SZShenzhen Kingkey Smart Agriculture Times Co.,Ltd2.61%$0.4658.98%