Definitive Analysis
Definitive Analysis

Financial Statements

Fundamentals

Valuations

Miscellaneous

Analysis Mode

Search

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 22 of 151 Next »
Ticker Company Dividend Yield % Dividend Per Share Payout Ratio %
TC.BKTropical Canning (Thailand) Public Company Limited6.05%$0.3042.33%
8984.TDaiwa House REIT Investment Corporation6.04%$8,653.9981.69%
0R40.LRai Way S.p.A.6.03%$0.3399.60%
3600.HKModern Dental Group Limited6.03%$0.3234.31%
003460.KSYuhwa Securities co.,ltd.6.02%$162.4583.00%
298540.KQThe Nature Holdings Co., Ltd.6.02%$521.4476.58%
6263.TWOPlanet Technology Corporation6.02%$7.8695.87%
NZX.NZNZX Limited6.02%$0.0977.46%
WLMM3.SAWLM Participações e Comércio de Máquinas e Veículos S.A.6.02%$1.2340.06%
1760.HKIntron Technology Holdings Limited6.01%$0.1230.56%
5209.KLGas Malaysia Berhad6.01%$0.2682.61%
ALLAN.PALanson-BCC6.01%$1.9626.09%
QAMC.QAQatar Aluminium Manufacturing Company Q.P.S.C.6.00%$0.1074.36%
0237.HKSafety Godown Company, Limited5.99%$0.1271.07%
8986.TDaiwa Securities Living Investment Corporation5.99%$6,829.9063.32%
ASX.AXASX Limited5.99%$3.0867.16%
MKP.TOMCAN Mortgage Corporation5.99%$1.3574.01%
0QMU.LCompagnie Financière Richemont S.A.5.98%$6.9167.79%
8924.TWOO-TA Precision Industry Co., Ltd.5.98%$4.2980.38%
FMTY14.MXFibra Mty, S.A.P.I. de C.V.5.98%$0.9346.45%
HUMAN.BKHumanica Public Company Limited5.98%$0.3074.76%
603368.SSGuangxi LiuYao Group Co., Ltd5.97%$1.0653.83%
6069.HKSY Holdings Group Limited5.97%$0.6797.72%
ASII.JKPT Astra International Tbk5.97%$405.7550.28%
PXT.TOParex Resources Inc.5.97%$1.1286.22%
SBSafe Bulkers, Inc.5.97%$0.2964.01%
1562.KLSports Toto Berhad5.96%$0.0849.23%
8442.TWWW Holding Inc.5.96%$4.1972.79%
NTV.BKNonthavej Hospital Public Company Limited5.96%$1.3766.11%
WLE.AXWAM Leaders Limited5.96%$0.088.04%
094280.KSHyosung ITX Co. Ltd.5.95%$751.7670.97%
O3P.DEÖsterreichische Post AG5.95%$1.8898.14%
PWO.DEPWO AG5.95%$1.7548.89%
0898.HKMultifield International Holdings Limited5.94%$0.069.32%
1155.KLMalayan Banking Berhad5.94%$0.6272.18%
PORT3.SAWilson Sons S.A.5.94%$1.1173.49%
009680.KSMotonic Corporation5.93%$599.0842.49%
3010.SRArabian Cement Company5.93%$1.2991.83%
PGW.NZPGG Wrightson Limited5.93%$0.1370.38%
0GX2.LNeurones S.A.5.92%$2.4961.25%
4012.SRThob Al Aseel Company5.92%$0.2089.05%
9585.SRMulkia Investment Co.5.92%$2.0137.97%
HEN.DEHenkel AG & Co. KGaA5.92%$3.8741.88%
KKP.BKKiatnakin Phatra Bank Public Company Limited5.92%$4.0263.80%
030000.KSCheil Worldwide Inc.5.91%$1,232.9368.46%
0RCW.LKid ASA5.91%$8.0099.60%
ARSA.MEArsagera Asset Management5.91%$0.5052.65%
DBM.TODoman Building Materials Group Ltd.5.91%$0.5665.99%
DU.AEEmirates Integrated Telecommunications Company PJSC5.91%$0.5895.05%
NXR-UN.TONexus Industrial REIT5.91%$0.4757.77%