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 7 of 30 Next »
Ticker Company Dividend Yield % Dividend Per Share Payout Ratio %
PLYMPlymouth Industrial REIT, Inc.4.80%$1.0549.94%
SAFTSafety Insurance Group, Inc.4.80%$3.6361.47%
CETCentral Securities Corp.4.79%$2.4313.87%
GBLIGlobal Indemnity Group, LLC4.79%$1.3870.11%
JANIXJanus Henderson Triton Fund Class D4.79%$1.2767.95%
MITNAG Mortgage Investment Trust, Inc. 9.500% Senior Notes due 20294.77%$1.2175.90%
PRUPrudential Financial, Inc.4.77%$5.4373.37%
IFAFXThe Income Fund of America, Class F-1 Shares4.76%$1.2433.91%
AMECXAmerican Funds The Income Fund of America Class A4.74%$1.2433.91%
UMPQUmpqua Holdings Corporation4.74%$0.8454.13%
NFBKNorthfield Bancorp, Inc.4.73%$0.5454.01%
SBSISouthside Bancshares, Inc.4.72%$1.4462.24%
TNLTravel + Leisure Co.4.72%$3.4054.99%
AIRCApartment Income REIT Corp.4.68%$1.8341.27%
SONSonoco Products Company4.68%$2.0832.95%
OFLXOmega Flex, Inc.4.67%$1.3685.30%
FTAIOFTAI Aviation Ltd.4.65%$1.1825.22%
WDWalker & Dunlop, Inc.4.65%$2.7379.29%
0J2Z.LHA Sustainable Infrastructure Capital, Inc.4.63%$1.4766.70%
FLMNFalcon Minerals Corporation4.63%$0.3681.83%
GSRMGSR II Meteora Acquisition Corp.4.62%$0.1532.94%
FBFWXAmerican Funds Retirement Income Portfolio - Moderate Class F-14.61%$0.6379.77%
GPSThe Gap, Inc.4.61%$0.9341.48%
QUADQuad/Graphics, Inc.4.61%$0.2764.56%
BMYBristol-Myers Squibb Company4.59%$2.4582.81%
WTBAWest Bancorporation, Inc.4.56%$0.9952.39%
SCPLSciPlay Corporation4.55%$1.0417.40%
OLPOne Liberty Properties, Inc.4.53%$0.9257.61%
RWAYLRunway Growth Finance Corp. - 74.53%$1.1475.51%
INSWInternational Seaways, Inc.4.52%$2.1248.43%
RWAYZRunway Growth Finance Corp. 8.00% Notes due 20274.52%$1.1475.51%
DDominion Energy, Inc.4.48%$2.6597.13%
TGTTarget Corporation4.48%$4.5054.48%
COLBColumbia Banking System, Inc.4.47%$1.2662.95%
DFPAXBNY Mellon Diversified International Fund Class A4.46%$0.4556.12%
KEYKeyCorp4.46%$0.9495.81%
RPTIXT. Rowe Price Mid-Cap Growth Fund4.46%$4.3859.54%
CGBDCarlyle Secured Lending, Inc.4.45%$0.5655.08%
NEWTPNewtekOne, Inc. Depositary Shares, Non-Cumulative Perpetual Preferred Stock, Series B4.44%$1.0244.14%
PFCPremier Financial Corp.4.43%$1.2468.07%
BFCBank First Corporation4.40%$5.3073.82%
DUKDuke Energy Corporation4.40%$5.1780.55%
0L77.LSkyworks Solutions, Inc.4.37%$2.7990.67%
ESCAEscalade, Incorporated4.35%$0.6065.28%
DINOHF Sinclair Corporation4.34%$2.0396.43%
LBAILakeland Bancorp, Inc.4.34%$0.5844.96%
CVXChevron Corporation4.32%$6.7495.36%
CVBFCVB Financial Corp.4.31%$0.8154.32%
HTBKHeritage Commerce Corp4.30%$0.5273.66%
EQREquity Residential4.28%$2.6689.76%