Definitive Analysis | Institutional-Grade Financial Research
Definitive Analysis
Get Full Access
See Pricing Start Free Trial

Consolidated Edison, Inc. (ED)

Company Dividend Discount ModelIndustry: Regulated ElectricSector: Utilities

Valuation Snapshot

Stable Growth$65.78 - $107.99$84.57
Multi-Stage$81.82 - $89.44$85.55
Blended Fair Value$85.06
Current Price$100.52
Upside-15.38%
DecisionDon't Buy

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 Rate9.08%9.08%9.08%
Growth Rate1.98%2.98%3.98%
Fair Value$65.78$84.57$107.99
Upside / Downside-34.56%-15.86%7.43%

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 Rate9.08%9.08%9.08%
Growth Rate1.98%2.98%3.98%
Year 1 PV (M)1,200.381,212.151,223.92
Year 2 PV (M)1,241.961,266.431,291.15
Year 3 PV (M)1,273.051,310.861,349.42
Year 4 PV (M)1,294.831,346.371,399.43
Year 5 PV (M)1,308.401,373.821,441.83
PV of Terminal Value (M)22,781.0323,920.0425,104.16
Equity Value (M)29,099.6430,429.6731,809.90
Shares Outstanding (M)355.68355.68355.68
Fair Value$81.82$85.55$89.44
Upside / Downside-18.61%-14.89%-11.03%

High-Yield Dividend Screener

« Prev Page 2 of 151 Next »
Ticker Company Dividend Yield % Dividend Per Share Payout Ratio %
0081.HKChina Overseas Grand Oceans Group Limited15.97%$0.3160.87%
QRF.BRQrf Comm. VA15.92%$1.6488.42%
INC-UN.TOIncome Financial Trust15.90%$1.4843.23%
QRI.AXQualitas Real Estate Income Fund15.90%$0.2594.00%
9172.KLFormosa Prosonic Industries Berhad15.89%$0.1872.55%
1099.HKSinopharm Group Co. Ltd.15.88%$3.1363.13%
XBBDC.MCBanco Bradesco S.A.15.82%$0.4623.31%
LPIN.JKPT Multi Prima Sejahtera Tbk15.59%$69.5396.86%
LFG.AXLiberty Financial Group Limited15.46%$0.6679.98%
ALPDX.PAPiscines Desjoyaux S.A.15.43%$2.0088.06%
2660.HKZengame Technology Holding Limited15.29%$0.3942.93%
CD3.AXCD Private Equity Fund III15.14%$0.1791.41%
PAGSPagSeguro Digital Ltd.15.12%$1.4619.46%
0912.HKSuga International Holdings Limited15.10%$0.1669.91%
RUI.PARubis15.03%$4.8772.73%
WAM.AXWAM Capital Limited15.01%$0.2767.95%
0113.HKDickson Concepts (International) Limited15.00%$0.8467.46%
0830.HKChina State Construction Development Holdings Limited14.96%$0.1834.59%
FFARM.ASForFarmers N.V.14.96%$0.6785.82%
BM.BKBangkok Sheet Metal Public Company Limited14.94%$0.1777.02%
DGS.TODividend Growth Split Corp.14.90%$1.1529.30%
6110.HKTopsports International Holdings Limited14.83%$0.4376.21%
GLB.AXGlobe International Limited14.83%$0.3872.14%
MOT.AXMetrics Income Opportunities Trust14.82%$0.2879.33%
CIQ-UN.TOCanadian High Income Equity Fund14.80%$1.0424.28%
BBVA.DEBanco Bilbao Vizcaya Argentaria, S.A.14.69%$0.6438.92%
601169.SSBank of Beijing Co., Ltd.14.63%$0.8064.51%
0184.HKKeck Seng Investments (Hong Kong) Limited14.62%$0.3123.90%
0881.HKZhongsheng Group Holdings Limited14.56%$1.7065.93%
6626.HKYuexiu Services Group Limited14.51%$0.3664.32%
ALNU.MEPJSC ALROSA-Nyurba14.51%$9,491.6654.89%
NONG.OLSpareBank 1 Nord-Norge14.36%$21.7372.60%
0640.HKInfinity Development Holdings Company Limited14.32%$0.3651.92%
2558.HKJinshang Bank Co., Ltd.14.28%$0.2031.14%
0270.HKGuangdong Investment Limited14.27%$0.9899.44%
0517.HKCOSCO SHIPPING International (Hong Kong) Co., Ltd.14.01%$0.8888.71%
2560.HKAnhui Conch Material Technology Co Ltd14.01%$0.2449.79%
WTCM.MEJoint Stock Company "World Trade Center Moscow"13.98%$1.9924.33%
6186.HKChina Feihe Limited13.94%$0.5681.20%
601186.SSChina Railway Construction Corporation Limited13.92%$1.0764.40%
CFEB.BRCompagnie d'Entreprises CFE S.A.13.92%$1.2171.32%
PMV.AXPremier Investments Limited13.92%$1.9251.67%
601229.SSBank of Shanghai Co., Ltd.13.82%$1.4093.74%
2120.HKWenzhou Kangning Hospital Co., Ltd.13.78%$1.3769.01%
DLNGDynagas LNG Partners LP13.72%$0.5131.08%
MXT.AXMetrics Master Income Trust13.71%$0.2785.17%
0085.HKChina Electronics Huada Technology Company Limited13.70%$0.1947.52%
0046.HKComputer And Technologies Holdings Limited13.69%$0.2285.50%
601328.SSBank of Communications Co., Ltd.13.66%$0.9992.22%
AKER.OLAker ASA13.66%$106.4372.10%