Definitive Analysis
Definitive Analysis
Financial Statements
Periods / Units
Fundamentals
Valuations
Miscellaneous
Analysis Mode
Full Access
See Pricing Start Trial

Consolidated Edison, Inc. (ED)

Company Dividend Discount ModelIndustry: Regulated ElectricSector: Utilities

Valuation Snapshot

Stable Growth$65.62 - $107.61$84.33
Multi-Stage$81.56 - $89.16$85.29
Blended Fair Value$84.81
Current Price$100.52
Upside-15.63%
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.10%9.10%9.10%
Growth Rate1.98%2.98%3.98%
Fair Value$65.62$84.33$107.61
Upside / Downside-34.72%-16.11%7.05%

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.10%9.10%9.10%
Growth Rate1.98%2.98%3.98%
Year 1 PV (M)1,200.181,211.951,223.72
Year 2 PV (M)1,241.551,266.011,290.72
Year 3 PV (M)1,272.421,310.211,348.75
Year 4 PV (M)1,293.981,345.481,398.51
Year 5 PV (M)1,307.321,372.681,440.64
PV of Terminal Value (M)22,695.0523,829.7625,009.42
Equity Value (M)29,010.4930,336.1131,711.75
Shares Outstanding (M)355.68355.68355.68
Fair Value$81.56$85.29$89.16
Upside / Downside-18.86%-15.15%-11.30%

High-Yield Dividend Screener

« Prev Page 18 of 30 Next »
Ticker Company Dividend Yield % Dividend Per Share Payout Ratio %
HBCPHome Bancorp, Inc.1.92%$1.1019.54%
SLMSLM Corporation1.92%$0.5317.47%
UVEUniversal Insurance Holdings, Inc.1.92%$0.6114.30%
WALWestern Alliance Bancorporation1.92%$1.6420.05%
0JZ1.LMasco Corporation1.91%$1.2331.44%
0L8B.LSouthern Copper Corporation1.91%$2.8060.30%
BKRBaker Hughes Company1.91%$0.9030.82%
BPACBullpen Parlay Acquisition Company1.91%$0.2036.09%
ELVElevance Health Inc.1.91%$6.7527.56%
NGVCNatural Grocers by Vitamin Cottage, Inc.1.91%$0.4723.70%
SYBTStock Yards Bancorp, Inc.1.91%$1.2527.22%
0JVQ.LLowe's Companies, Inc.1.90%$4.6738.55%
ATERXAB Sustainable Global Thematic Fund Class R1.90%$2.8436.57%
BLLBall Corporation1.90%$1.329.47%
EAIEntergy Arkansas, Inc. 1M BD 4.875%661.90%$0.409.71%
MMCMarsh & McLennan Companies, Inc.1.90%$3.4741.48%
THOThor Industries, Inc.1.90%$2.0037.63%
TRGPTarga Resources Corp.1.90%$3.5546.50%
TTCThe Toro Company1.90%$1.5245.26%
0K8M.LNorfolk Southern Corporation1.89%$5.4241.12%
FDXFedEx Corporation1.89%$5.5432.63%
ALLThe Allstate Corporation1.87%$3.8112.13%
BERYBerry Global Group, Inc.1.87%$1.2624.23%
NHCNational HealthCare Corporation1.87%$2.4437.72%
PRDOPerdoceo Education Corporation1.87%$0.5423.03%
ABTAbbott Laboratories1.86%$2.3128.93%
TNETTriNet Group, Inc.1.86%$1.0638.35%
BTMDbiote Corp.1.85%$0.055.82%
WDFCWD-40 Company1.85%$3.6554.36%
AMTBAmerant Bancorp Inc.1.84%$0.3622.80%
BNHBrookfield Finance Inc. 4.625%1.84%$0.3070.51%
MGRCMcGrath RentCorp1.84%$1.9332.75%
NATINational Instruments Corporation1.84%$1.1082.38%
OTISOtis Worldwide Corporation1.84%$1.6347.44%
WSWorthington Steel, Inc.1.84%$0.6526.98%
KBHKB Home1.83%$1.0513.68%
WRBW. R. Berkley Corporation1.83%$1.2726.69%
PIPRPiper Sandler Companies1.82%$6.3647.91%
SFBSServisFirst Bancshares, Inc.1.82%$1.3027.90%
YUMYum! Brands, Inc.1.82%$2.7354.40%
LVSLas Vegas Sands Corp.1.81%$1.1851.99%
HNVRHanover Bancorp, Inc.1.80%$0.4126.32%
TSCOTractor Supply Company1.79%$0.9143.76%
CLIMack-Cali Realty Corporation1.78%$0.3321.71%
RRRRed Rock Resorts, Inc.1.78%$1.1260.48%
SBRSabine Royalty Trust1.78%$1.2523.02%
TMUST-Mobile US, Inc.1.78%$3.5533.70%
BWFGBankwell Financial Group, Inc.1.77%$0.8021.59%
DGXQuest Diagnostics Incorporated1.77%$3.0735.81%
JPMJPMorgan Chase & Co.1.77%$5.7527.69%