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 10 of 30 Next »
Ticker Company Dividend Yield % Dividend Per Share Payout Ratio %
ESPEspey Mfg. & Electronics Corp.3.53%$1.6554.01%
F-PCFord Motor Company 6% Notes due3.53%$0.7463.45%
TECTPTectonic Financial, Inc.3.53%$0.3879.28%
AMFCXAmerican Funds American Mutual Fund3.52%$2.0690.87%
CRCCalifornia Resources Corporation3.52%$1.6435.94%
FAFFirst American Financial Corporation3.51%$2.1446.13%
GICGlobal Industrial Company3.51%$1.0358.36%
0R0G.LMondelez International, Inc.3.50%$1.8969.92%
DCPDCP Midstream, LP3.50%$1.4634.00%
LWLamb Weston Holdings, Inc.3.50%$1.4870.35%
WSOWatsco, Inc.3.50%$12.1683.88%
0QYY.LHarley-Davidson, Inc.3.49%$0.7217.57%
LKFNLakeland Financial Corporation3.49%$1.9752.13%
TRSTTrustCo Bank Corp NY3.49%$1.4448.14%
OMCOmnicom Group Inc.3.47%$2.8341.26%
PROVProvident Financial Holdings, Inc.3.47%$0.5561.73%
UTLUnitil Corporation3.47%$1.7061.75%
BF-ABrown-Forman Corporation3.45%$0.9152.84%
COFSChoiceOne Financial Services, Inc.3.45%$1.0070.38%
FCBPFirst Choice Bancorp3.45%$1.0034.34%
NXSTNexstar Media Group, Inc.3.45%$7.2042.75%
STBAS&T Bancorp, Inc.3.45%$1.3529.75%
VABKVirginia National Bankshares Corporation3.45%$1.3755.94%
F-PBFord Motor Company 6.20% Notes3.44%$0.7463.45%
0K3B.LThe Mosaic Company3.43%$0.8722.53%
CPFCentral Pacific Financial Corp.3.43%$1.0743.87%
CTBICommunity Trust Bancorp, Inc.3.43%$1.9337.41%
IIINInsteel Industries, Inc.3.43%$1.1153.05%
JJSFJ&J Snack Foods Corp.3.43%$3.1192.62%
TMPTompkins Financial Corporation3.43%$2.4942.22%
ALRSAlerus Financial Corporation3.41%$0.7739.09%
CNXCConcentrix Corporation3.41%$1.4028.16%
FBPFirst BanCorp.3.41%$0.7134.06%
GLOClough Global Opportunities Fund3.41%$0.1915.90%
OPBKOP Bancorp3.41%$0.4830.19%
PHXPHX Minerals Inc.3.39%$0.1581.44%
WHGWestwood Holdings Group, Inc.3.39%$0.6073.76%
SCVLShoe Carnival, Inc.3.38%$0.5928.17%
OGSONE Gas, Inc.3.37%$2.6161.93%
VALUValue Line, Inc.3.36%$1.2555.36%
WTRGEssential Utilities, Inc.3.36%$1.3054.79%
AVNTAvient Corporation3.35%$1.0686.14%
KTBKontoor Brands, Inc.3.35%$2.0653.00%
VCTRVictory Capital Holdings, Inc.3.35%$2.1548.89%
WAFDWaFd, Inc.3.35%$1.0837.44%
PBProsperity Bancshares, Inc.3.34%$2.3241.44%
PFGPrincipal Financial Group, Inc.3.34%$2.9943.04%
EVBNEvans Bancorp, Inc.3.33%$1.3160.97%
NFYSEnphys Acquisition Corp.3.33%$0.3768.70%
KMPRKemper Corporation3.32%$1.3132.45%