Definitive Analysis
Definitive Analysis

Financial Statements

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 21 of 30 Next »
Ticker Company Dividend Yield % Dividend Per Share Payout Ratio %
GATXGATX Corporation1.45%$2.4728.36%
SFStifel Financial Corp.1.45%$1.8630.82%
0HFN.LAnalog Devices, Inc.1.44%$3.9084.88%
HAYNHaynes International, Inc.1.44%$0.8830.16%
0I58.LCummins Inc.1.43%$7.4238.53%
0HRJ.LCSX Corporation1.42%$0.5133.32%
OLEDUniversal Display Corporation1.42%$1.7337.24%
BBWBuild-A-Bear Workshop, Inc.1.41%$0.8619.50%
LBCLuther Burbank Corporation1.41%$0.1317.07%
SNDRSchneider National, Inc.1.41%$0.3858.72%
0R13.LChurch & Dwight Co., Inc.1.40%$1.1636.55%
COHNCohen & Company Inc.1.40%$0.3548.05%
HLIHoulihan Lokey, Inc.1.40%$2.4839.81%
PATKPatrick Industries, Inc.1.40%$1.5444.05%
CXTCrane NXT, Co.1.39%$0.6624.82%
ESBAEmpire State Realty OP, L.P.1.39%$0.0949.94%
MMSMaximus, Inc.1.39%$1.2121.54%
WYNNWynn Resorts, Limited1.39%$1.7034.98%
ATENA10 Networks, Inc.1.38%$0.2434.61%
HYACHaymaker Acquisition Corp. III1.38%$0.1637.41%
ISTRInvestar Holding Corporation1.38%$0.3618.11%
MCYMercury General Corporation1.38%$1.2716.00%
ACUAcme United Corporation1.37%$0.5528.31%
DEDeere & Company1.36%$6.3434.22%
HYAC-UNHaymaker Acquisition Corp. 41.36%$0.1637.41%
RTXRTX Corporation1.36%$2.5652.52%
0HIN.LAssurant, Inc.1.35%$3.2219.47%
ALAir Lease Corporation1.35%$0.869.51%
BGCPBGC Partners, Inc.1.34%$0.0611.88%
ESRTEmpire State Realty Trust, Inc.1.34%$0.0949.94%
HUMHumana Inc.1.34%$3.5533.23%
ZEUSOlympic Steel, Inc.1.34%$0.5950.16%
0K9L.LNucor Corporation1.33%$2.2231.04%
BYByline Bancorp, Inc.1.33%$0.3913.97%
LPXLouisiana-Pacific Corporation1.33%$1.0935.19%
OPOFOld Point Financial Corporation1.33%$0.5632.91%
WSMWilliams-Sonoma, Inc.1.33%$2.5027.85%
RUSHARush Enterprises, Inc.1.32%$0.7121.15%
VLEOXValue Line Small Cap Opportunities Fund, Inc. Investor Class1.32%$0.7956.29%
0IW7.LGlobal Payments Inc.1.31%$1.0113.82%
APOApollo Global Management, Inc.1.31%$1.9227.59%
EMPEntergy Mississippi, Inc. 1M BD 661.31%$0.276.72%
NDSNNordson Corporation1.31%$3.1536.67%
ROKRockwell Automation, Inc.1.31%$5.2368.01%
UMBFUMB Financial Corporation1.31%$1.5218.87%
0L3I.LThe Charles Schwab Corporation1.30%$1.2928.42%
0R2X.LCorning Incorporated1.30%$1.1572.69%
EBAYeBay Inc.1.30%$1.1324.20%
GGGGraco Inc.1.30%$1.0736.31%
HESHess Corporation1.30%$1.9426.90%