Definitive Analysis
Definitive Analysis

Financial Statements

Analysis Mode

Ticker

Industry

Sector

Consolidated Edison, Inc. (ED)

Company Dividend Discount ModelIndustry: Regulated ElectricSector: Utilities

Valuation Snapshot

Stable Growth$106.34 - $230.27$152.09
Multi-Stage$150.06 - $164.60$157.20
Blended Fair Value$154.64
Current Price$100.52
Upside53.84%
DecisionBuy

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 Rate6.37%6.37%6.37%
Growth Rate1.98%2.98%3.98%
Fair Value$106.34$152.09$230.27
Upside / Downside5.79%51.30%129.08%

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 Rate6.37%6.37%6.37%
Growth Rate1.98%2.98%3.98%
Year 1 PV (M)1,230.921,242.991,255.05
Year 2 PV (M)1,305.951,331.691,357.68
Year 3 PV (M)1,372.701,413.471,455.05
Year 4 PV (M)1,431.711,488.701,547.37
Year 5 PV (M)1,483.521,557.691,634.80
PV of Terminal Value (M)46,548.5248,875.8751,295.38
Equity Value (M)53,373.3155,910.4058,545.33
Shares Outstanding (M)355.68355.68355.68
Fair Value$150.06$157.20$164.60
Upside / Downside49.29%56.38%63.75%

High-Yield Dividend Screener

« Prev Page 49 of 151 Next »
Ticker Company Dividend Yield % Dividend Per Share Payout Ratio %
064960.KSSNT Motiv Co., Ltd.3.32%$1,136.7332.23%
0RNT.LBrødrene A & O Johansen A/S3.32%$3.0743.48%
603676.SSTibet Weixinkang Medicine Co., Ltd.3.32%$0.3567.92%
6791.TWOTaiwan Auto-Design Co.3.32%$3.4985.79%
9432.TNTT, Inc.3.32%$5.2441.63%
AJBU.SIKeppel DC REIT3.32%$0.0751.19%
MFF.AXMFF Capital Investments Limited3.32%$0.166.10%
VZN.SWVZ Holding AG3.32%$4.9645.59%
6438.TWSymtek Automation Asia Co., Ltd.3.31%$4.6960.82%
8272.TWOChanging Information Technology Inc.3.31%$2.5960.59%
ALDEL.PADelfingen Industry S.A.3.31%$1.1538.10%
GJF.OLGjensidige Forsikring ASA3.31%$10.0077.33%
001560.KSCheil Grinding Wheel Ind. Co., Ltd.3.30%$321.6715.39%
002895.SZGuizhou Chanhen Chemical Corporation3.30%$1.2157.70%
0GWB.ILL E Lundbergföretagen AB (publ)3.30%$16.7254.63%
2441.TWGreatek Electronics Inc.3.30%$2.9871.42%
MAVI.ISMavi Giyim Sanayi ve Ticaret A.S.3.30%$1.4153.21%
MTSA3.SAMETISA Metalúrgica Timboense S.A.3.30%$2.5153.64%
3475.TGood Com Asset Co., Ltd.3.29%$41.3153.09%
ARCOArcos Dorados Holdings Inc.3.29%$0.2420.61%
GLINT.LSGlintt - Global Intelligent Technologies, S.A.3.29%$0.0463.67%
LABB.MXGenomma Lab Internacional, S.A.B. de C.V.3.29%$0.5928.90%
009770.KSSam Jung Pulp Co.,Ltd.3.28%$1,000.1513.81%
3050.SRSouthern Province Cement Company3.28%$0.7453.26%
603075.SSHangzhou Heatwell Electric Heating Technology Co., Ltd.3.28%$0.7290.17%
6741.TNippon Signal Co., Ltd.3.28%$42.9832.43%
000088.SZShenzhen Yan Tian Port Holdings Co.,Ltd.3.27%$0.1553.36%
002648.SZSatellite Chemical Co.,Ltd.3.27%$0.5831.65%
005750.KSDaelim B&Co Co.,Ltd.3.27%$152.6038.32%
011760.KSHyundai Corporation3.27%$700.0011.11%
2248.TWOShining Victory Motor Electronic Co., Ltd.3.27%$1.6118.34%
4021.TNissan Chemical Corporation3.27%$175.2852.54%
603439.SSGuiZhou SanLi Pharmaceutical Co.,Ltd3.27%$0.3895.76%
7942.TJSP Corporation3.27%$79.9839.18%
BRIT3.SABrisanet Participações S.A.3.27%$0.0982.21%
IAF-PI.TOiA Financial Corporation Inc.3.27%$0.8225.22%
ORS.MIOrsero S.p.A.3.27%$0.6133.02%
PEHN.SWPrivate Equity Holding AG3.27%$2.0817.62%
4471.TSanyo Chemical Industries Ltd.3.26%$169.9727.59%
5315.TWOUnited Radiant Technology Corporation3.26%$0.8049.66%
603558.SSZhejiang Jasan Holding Group Co., Ltd.3.26%$0.3734.35%
7744.TNoritsu Koki Co., Ltd.3.26%$60.5454.32%
MYTIL.ATMetlen Energy & Metals S.A.3.26%$1.7219.73%
TCW.TOTrican Well Service Ltd.3.26%$0.2035.68%
001040.KSCJ Corporation3.25%$5,626.0348.88%
002507.SZChongqing Fuling Zhacai Group Co., Ltd.3.25%$0.4260.46%
016740.KSDUAL Co., Ltd.3.25%$123.0716.96%
131090.KQSecuve Co., Ltd.3.25%$125.0032.25%
300729.SZLoctek Ergonomic Technology Corp.3.25%$0.4463.17%
300881.SZShengtak New Material Co., Ltd3.25%$1.1065.22%