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 30 Next »
Ticker Company Dividend Yield % Dividend Per Share Payout Ratio %
GHYPGIM Global High Yield Fund, Inc15.29%$1.8962.38%
BGRBlackRock Energy and Resources Trust15.26%$2.1298.26%
BOEBlackRock Enhanced Global Dividend Trust15.09%$1.7867.28%
FENFirst Trust Energy Income and Growth Fund15.00%$2.4049.79%
SOJESouthern Company (The) Series 214.95%$2.6967.01%
PSFCohen & Steers Select Preferred and Income Fund, Inc.14.84%$3.0256.28%
EVGEaton Vance Short Duration Diversified Income Fund14.82%$1.6271.62%
LDPCohen & Steers Limited Duration Preferred and Income Fund, Inc.14.73%$3.1554.69%
DNPDNP Select Income Fund Inc.14.64%$1.4553.01%
JRSNuveen Real Estate Income Fund14.56%$1.1189.79%
DPGDuff & Phelps Utility and Infrastructure Fund Inc.14.47%$1.8654.60%
BSTBlackRock Science and Technology Trust14.42%$5.8646.91%
MPAIXMorgan Stanley Insti Fd Advantage Portfolio Cl I14.33%$4.0043.20%
JCAPJefferson Capital, Inc. Common Stock14.11%$3.1245.65%
PHTPioneer High Income Fund, Inc.13.99%$1.1961.96%
RZC7.125% Fixed-Rate Reset Subordinated Debentures due 205213.93%$3.5527.34%
RNPCohen & Steers REIT and Preferred Income Fund, Inc.13.88%$2.7761.92%
DOMHDominari Holdings Inc.13.87%$0.7010.86%
STT-PDState Street Corporation13.86%$3.4633.48%
FCTFirst Trust Senior Floating Rate Income Fund II13.80%$1.3867.42%
VIRTVirtu Financial, Inc.13.57%$4.4389.50%
DHFBNY Mellon High Yield Strategies Fund13.55%$0.3461.16%
JHIJohn Hancock Investors Trust13.15%$1.7974.97%
AIOVirtus Artificial Intelligence & Technology Opportunities Fund12.91%$2.8238.01%
UTFCohen & Steers Infrastructure Fund, Inc12.84%$3.1453.56%
DFPFlaherty & Crumrine Dynamic Preferred and Income Fund Inc.12.81%$2.6848.05%
WEAWestern Asset Premier Bond Fund12.81%$1.4380.16%
TPZTortoise Essential Energy Fund12.76%$2.6467.76%
FTFranklin Universal Trust12.72%$1.0256.42%
CSQCalamos Strategic Total Return Fund12.70%$2.4351.10%
HYBThe New America High Income Fund Inc.12.68%$1.0463.42%
NBBNuveen Taxable Municipal Income Fund12.66%$2.0085.04%
RWAYRunway Growth Finance Corp.12.66%$1.1475.51%
ELVTElevate Credit, Inc.12.61%$0.2475.91%
NDPTortoise Energy Independence Fund, Inc.12.60%$5.0986.32%
BCEICivitas Resources, Inc.12.58%$7.0698.41%
GENVRGen Digital Inc. Contingent Value Rights12.54%$0.5054.91%
SOJCThe Southern Company JR 2017B NT 7712.31%$2.6967.01%
BTOJohn Hancock Financial Opportunities Fund12.25%$4.3229.72%
FEIFirst Trust MLP and Energy Income Fund12.21%$1.2058.56%
PCNPIMCO Corporate & Income Strategy Fund12.19%$1.5568.95%
HTDJohn Hancock Tax-Advantaged Dividend Income Fund12.17%$2.9051.08%
NIEVirtus Equity & Convertible Income Fund12.17%$3.0445.26%
PFDFlaherty & Crumrine Preferred Income Fund Inc.11.99%$1.4348.51%
TYGTortoise Energy Infrastructure Corporation11.98%$4.9643.95%
FPLFirst Trust New Opportunities MLP & Energy Fund11.82%$0.9254.20%
BTZBlackRock Credit Allocation Income Trust11.69%$1.2692.75%
BHBFXMadison Dividend Income Fd Cl Y11.61%$2.8540.22%
CGABLThe Carlyle Group Inc. 4.625% Subordinated Notes due 206111.57%$2.0197.92%
DBLDoubleLine Opportunistic Credit Fund11.57%$1.7652.03%