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 4 of 30 Next »
Ticker Company Dividend Yield % Dividend Per Share Payout Ratio %
VKQInvesco Municipal Trust8.62%$0.8469.07%
ARCCAres Capital Corporation8.61%$1.7691.56%
TPVGTriplePoint Venture Growth BDC Corp.8.52%$0.5767.26%
C-PJCitigroup Inc.8.49%$2.1326.99%
RVTRoyce Value Trust Inc.8.42%$1.3639.40%
OGNOrganon & Co.8.37%$0.6131.54%
MITTAG Mortgage Investment Trust, Inc.8.12%$0.7043.47%
CAGConagra Brands, Inc.8.06%$1.3978.70%
NOGNorthern Oil and Gas, Inc.8.02%$1.7794.64%
PAAPlains All American Pipeline, L.P.8.00%$1.4690.71%
TSLXSixth Street Specialty Lending, Inc.8.00%$1.7385.26%
ACCOACCO Brands Corporation7.90%$0.2967.00%
ETDEthan Allen Interiors Inc.7.90%$1.8197.75%
CQPCheniere Energy Partners, L.P.7.82%$4.2388.03%
UNMAUnum Group 6.250% JR NT587.69%$1.7933.52%
WRB-PHW.R. Berkley Corporation 4.125%7.68%$1.2726.69%
JHSJohn Hancock Income Securities Trust7.65%$0.8994.90%
NIDNuveen Intermediate Duration Municipal Term Fund7.59%$1.0284.59%
HWCPZHancock Whitney Corporation - 67.58%$1.7731.35%
WRB-PGW.R. Berkley Corporation 4.25%7.54%$1.2726.69%
NMTNuveen Massachusetts Quality Municipal Income Fund7.48%$0.8580.62%
LOANManhattan Bridge Capital, Inc.7.45%$0.3574.53%
OPALOPAL Fuels Inc.7.43%$0.1846.94%
ZIONLZions Bancorporation N.A. - 6.97.42%$1.8632.04%
GMTAGATX Corporation SR NT 20667.41%$1.8621.29%
IIMInvesco Value Municipal Income Trust7.41%$0.9264.33%
JMMNuveen Multi-Market Income Fund7.28%$0.4461.06%
BKEThe Buckle, Inc.7.26%$3.9196.21%
MHIPioneer Municipal High Income Fund, Inc.7.19%$0.6413.70%
ORIOld Republic International Corporation7.19%$3.1193.13%
PMFPIMCO Municipal Income Fund7.07%$0.5992.59%
RYNRayonier Inc.7.04%$1.5230.67%
DRQDril-Quip, Inc.7.02%$1.0850.37%
TRINITrinity Capital Inc. 7.875% Notes Due 20297.02%$1.7883.48%
C-PNCitigroup Capital XIII TR PFD SECS7.01%$2.1326.99%
VPVInvesco Pennsylvania Value Municipal Income Trust6.98%$0.7360.22%
VCVInvesco California Value Municipal Income Trust6.97%$0.7860.58%
EOTEaton Vance National Municipal Opportunities Trust6.96%$1.1869.84%
FLATXFidelity Latin America Fund6.92%$1.1539.63%
EGYVAALCO Energy, Inc.6.91%$0.2592.67%
NOMNuveen Missouri Quality Municipal Income Fund6.91%$0.8278.81%
UBCPUnited Bancorp, Inc.6.90%$0.9996.30%
TBCAT&T Inc. 5.625% Global Notes d6.89%$1.7255.65%
GTNGray Media, Inc.6.87%$0.3334.04%
HEPHolly Energy Partners, L.P.6.86%$1.4074.08%
AFGAmerican Financial Group, Inc.6.85%$9.2396.49%
BANFPBFC Capital Trust II PFD TR 7.20%6.85%$1.8025.72%
CFG-PDCitizens Financial Group, Inc.6.83%$1.7143.60%
RCIIRent-A-Center, Inc.6.81%$1.8279.98%
SPHSuburban Propane Partners, L.P.6.81%$1.2778.56%