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 4 of 151 Next »
Ticker Company Dividend Yield % Dividend Per Share Payout Ratio %
EG7.IRFBD Holdings plc12.49%$1.9761.47%
WILCG. Willi-Food International Ltd.12.48%$3.5852.70%
9908.HKJiaXing Gas Group Co., Ltd.12.44%$1.0240.94%
MPMX.JKPT Mitra Pinasthika Mustika Tbk12.44%$120.0095.84%
0QL5.LCarlo Gavazzi Holding AG12.42%$20.0062.49%
GOZ.AXGrowthpoint Properties Australia12.40%$0.3016.37%
1999.HKMan Wah Holdings Limited12.39%$0.5757.62%
1285.HKJiashili Group Limited12.38%$0.1455.24%
600015.SSHua Xia Bank Co., Limited12.36%$0.8549.77%
BNP.DEBNP Paribas S.A.12.28%$10.0751.11%
0836.HKChina Resources Power Holdings Company Limited12.20%$2.1541.97%
BIS.AXBisalloy Steel Group Limited12.19%$0.5981.88%
KBS.BKKhonburi Sugar Public Company Limited12.17%$0.7056.34%
9300.SRAlwaha REIT Fund12.14%$1.1871.67%
2005.HKSSY Group Limited12.13%$0.3550.50%
BGI-UN.TOBrookfield Global Infrastructure Securities Income Fund12.09%$0.9646.13%
2003.HKVCREDIT Holdings Limited12.07%$0.3218.47%
1713.HKSichuan Energy Investment Development Co., Ltd.12.02%$0.2941.35%
NSI.ASNSI N.V.12.02%$2.3330.60%
RIO1.DERio Tinto Group12.02%$8.2864.54%
IGL.AXIVE Group Limited12.01%$0.3574.81%
0G5B.LSto SE & Co. KGaA12.00%$14.6483.41%
CDU.LSConduril - Engenharia, S.A.12.00%$1.8069.00%
2156.HKC&D Property Management Group Co. Limited11.98%$0.3354.74%
0057.HKChen Hsong Holdings Limited11.94%$0.1945.38%
BBSE3.SABB Seguridade Participações S.A.11.93%$4.2691.94%
SWUT.VISW Umwelttechnik Stoiser & Wolschner AG11.93%$3.7034.18%
0Q76.LCBo Territoria S.A.11.92%$0.4461.80%
ALCOF.PACofidur S.A.11.92%$34.8038.87%
0239.HKPak Fah Yeow International Limited11.87%$0.2852.60%
2356.HKDah Sing Banking Group Limited11.87%$1.2941.19%
3311.HKChina State Construction International Holdings Limited11.87%$1.1029.31%
ENGI.PAEngie S.A.11.87%$2.7376.93%
SENA.BKSena Development Public Company Limited11.86%$0.2074.93%
4348.SRAlkhabeer REIT Fund11.85%$0.6698.08%
AWZ.SIMulti-Chem Limited11.83%$0.4160.70%
0331.HKFSE Lifestyle Services Limited11.81%$0.6731.73%
SUL.AXSuper Retail Group Limited11.78%$1.8791.92%
2877.HKChina Shineway Pharmaceutical Group Limited11.77%$1.0139.47%
DSWLDeswell Industries, Inc.11.77%$0.4027.95%
0855.HKChina Water Affairs Group Limited11.75%$0.6256.78%
0659.HKCTF Services Limited11.70%$0.8876.18%
DRA.AXDRA Global Limited11.69%$0.2158.65%
GWA.AXGWA Group Limited11.68%$0.2995.40%
0968.HKXinyi Solar Holdings Limited11.67%$0.3670.18%
ENI-UN.TOEnergy Income Fund11.66%$0.2356.38%
TCF.AX360 Capital Mortgage REIT11.66%$0.6776.18%
3316.HKBinjiang Service Group Co. Ltd.11.65%$2.7669.09%
CC3.SIStarHub Ltd11.65%$0.1381.69%
TFG-R.BKThaifoods Group Public Company Limited11.65%$0.5242.58%