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 46 of 151 Next »
Ticker Company Dividend Yield % Dividend Per Share Payout Ratio %
ATCOLAtlas Corp.3.53%$0.8930.47%
AWC-R.BKAsset World Corp Public Company Limited3.53%$0.0737.62%
CCRO3.SACCR S.A.3.53%$0.4866.57%
HMU.DEHMS Bergbau AG3.53%$1.6929.89%
RAUTE.HERaute Oyj3.53%$0.5226.97%
RWE.DERWE AG3.53%$1.6646.76%
SNL.AXSupply Network Limited3.53%$1.1367.28%
0NHS.LNutrien Ltd.3.52%$2.1858.76%
CELL.MICellularline S.p.A.3.52%$0.0934.70%
INFREA.STInfrea AB3.52%$0.5067.57%
ISSP.JKPT Steel Pipe Industry of Indonesia Tbk3.52%$15.0019.85%
MGAMagna International Inc.3.52%$1.9252.47%
PARP.PAGroupe Partouche S.A.3.52%$0.6438.61%
PKI.TOParkland Corporation3.52%$1.4073.81%
SMU.SNSMU S.A.3.52%$5.4946.99%
161390.KSHankook Tire & Technology Co., Ltd.3.51%$2,000.0025.86%
300360.SZHangzhou Sunrise Technology Co., Ltd.3.51%$0.6152.03%
5106.KLAxis Real Estate Investment Trust3.51%$0.0756.99%
601128.SSJiangsu Changshu Rural Commercial Bank Co., Ltd.3.51%$0.2519.56%
INTP.JKPT Indocement Tunggal Prakarsa Tbk3.51%$259.8143.04%
RATO-A.STRatos AB (publ)3.51%$1.3512.15%
002887.SZTianjin LVYIN Landscape and Ecology Construction Co., Ltd3.50%$0.3384.50%
603062.SSMEGA P&C Advanced Materials (Shanghai) Company Limited3.50%$1.6674.27%
CMCLCaledonia Mining Corporation Plc3.50%$0.9235.87%
DLODLocal Limited3.50%$0.4987.74%
LAZLazard Ltd3.50%$1.7467.48%
TWL.MITraWell Co S.p.A.3.50%$0.2128.69%
WJP.SIVICOM Ltd3.50%$0.0666.95%
005610.KSSPC Samlip Co., Ltd.3.49%$1,803.3945.19%
0RFL.LVAT Group AG3.49%$12.5088.50%
2030.HKCabbeen Fashion Limited3.49%$0.0563.92%
5206.TWOKunyue Development Co., Ltd.3.49%$1.1821.91%
5246.KLWestports Holdings Berhad3.49%$0.2071.36%
5989.TH-One Co.,Ltd.3.49%$49.4414.49%
ACO-X.TOATCO Ltd.3.49%$1.9850.80%
CNICanadian National Railway Company3.49%$3.5050.64%
PEAB3.SACompanhia de Participações Aliança da Bahia3.49%$1.3678.68%
026960.KSDong Suh Companies Inc.3.48%$905.3362.72%
055550.KSShinhan Financial Group Co., Ltd.3.48%$2,668.7426.55%
0QK5.LINFICON Holding AG3.48%$3.4443.54%
6722.TWOWhetron Electronics Co.,Ltd.3.48%$1.9924.71%
HOLM-A.STHolmen AB (publ)3.48%$12.2366.11%
002206.SZZhejiang Hailide New Material Co.,Ltd3.47%$0.2043.30%
3004.SRNorthern Region Cement Company3.47%$0.2579.89%
4129.TWOUnited Orthopedic Corporation3.47%$3.8069.70%
600133.SSWuhan East Lake High Technology Group Co., Ltd.3.47%$0.3287.27%
601995.SSChina International Capital Corporation Limited3.47%$1.2162.35%
6471.TNSK Ltd.3.47%$33.8292.34%
CSED3.SACruzeiro do Sul Educacional S.A.3.47%$0.2130.49%
GPRA.JKPT Perdana Gapuraprima Tbk3.47%$5.0018.12%