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.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 14 of 151 Next »
Ticker Company Dividend Yield % Dividend Per Share Payout Ratio %
FGG.AXFuture Generation Global Limited7.59%$0.1235.11%
WINNER.BKWinner Group Enterprise Public Company Limited7.59%$0.1677.25%
1666.HKTong Ren Tang Technologies Co. Ltd.7.58%$0.3439.83%
ALHOP.PAHopscotch Global PR Group7.58%$1.0034.20%
4305.TWOShih-Kuen Plastics Co., Ltd.7.57%$3.1886.35%
KLEE-B.COBrd. Klee A/S7.57%$284.4657.64%
TACC.BKT.A.C. Consumer Public Company Limited7.56%$0.3986.66%
PCC.BKPrecise Corporation Public Company Limited7.55%$0.2054.85%
2180.HKManpowerGroup Greater China Limited7.54%$0.3930.76%
BASGZ.ISBaskent Dogalgaz Dagitim Gayrimenkul Yatirim Ortakligi A.S.7.54%$3.4364.56%
ISAE4.SAISA Energía Brasil S.A.7.54%$2.0345.68%
TRPL4.SACTEEP - Companhia de Transmissão de Energia Elétrica Paulista S.A.7.53%$1.8837.46%
QH-R.BKQuality Houses Public Company Limited7.52%$0.1063.63%
0189.HKDongyue Group Limited7.51%$0.8267.14%
3034.KLHap Seng Consolidated Berhad7.50%$0.2189.85%
9985.HKWEILONG Delicious Global Holdings Ltd7.50%$0.8387.47%
CBQK.QAThe Commercial Bank (P.S.Q.C.)7.50%$0.3248.96%
BMGB4.SABanco BMG S.A.7.49%$0.3767.48%
DJW.AXDjerriwarrh Investments Limited7.49%$0.2378.76%
JSMR.JKPT Jasa Marga (Persero) Tbk7.49%$256.8147.02%
TGMA3.SATegma Gestão Logística S.A.7.49%$2.7365.23%
014440.KSYoungbo Chemical Co., Ltd.7.48%$350.9938.29%
CPW.BKCopperwired Public Company Limited7.48%$0.1585.48%
003080.KSSBSUNGBO Co., Ltd.7.47%$205.009.79%
226320.KSIt'S Hanbul Co., Ltd.7.47%$887.8495.70%
AYGAZ.ISAygaz A.S.7.47%$14.7993.51%
3290.TOne REIT, Inc.7.46%$6,781.0766.29%
TOTL.JKPT Total Bangun Persada Tbk7.46%$75.0067.24%
1497.HKXiamen Yan Palace Bird's Nest Indus7.45%$0.4461.94%
ANIM.MIAnima Holding S.p.A.7.45%$0.4555.56%
DCC-R.BKDynasty Ceramic Public Company Limited7.45%$0.0981.26%
0751.HKSkyworth Group Limited7.44%$0.3953.99%
8957.TTokyu REIT, Inc.7.44%$15,400.2079.77%
2504.TWGoldsun Building Materials Co., Ltd.7.43%$2.8186.16%
KEPL3.SAKepler Weber S.A.7.43%$0.7389.80%
POLY.BKPolynet Public Company Limited7.43%$0.5288.16%
XTB.WAXTB S.A.7.43%$5.4679.70%
TIPH.BKDhipaya Group Holdings Public Company Limited7.42%$1.5476.50%
ALFRE.PAFreelance.com S.A.7.40%$0.1623.60%
RING.OLSpareBank 1 Ringerike Hadeland7.40%$30.8074.39%
SEAOIL.BKSea Oil Public Company Limited7.39%$0.2246.45%
IRC.BKInoue Rubber (Thailand) Public Company Limited7.36%$0.8790.55%
ILM-R.BKIndex Living Mall Public Company Limited7.34%$1.0067.79%
SHIPSeanergy Maritime Holdings Corp.7.34%$0.6791.71%
5009.TWOGloria Material Technology Corp.7.33%$2.3477.68%
9922.HKJiumaojiu International Holdings Limited7.33%$0.1455.41%
8977.THankyu Hanshin REIT, Inc.7.32%$12,179.9195.79%
BAREIT.BKBA Airport Leasehold Real Estate Investment Trust7.32%$0.7589.39%
SIDO.JKPT Industri Jamu dan Farmasi Sido Muncul Tbk7.32%$39.5596.37%
0QQK.LMeier Tobler Group AG7.31%$2.8980.26%