Definitive Analysis
Loading...
Definitive Analysis

Financial Statements

Company Industry Sector

Periods / Units / Analysis

Fundamentals

Margins Returns Growth Rates Metrics/Ratios

Valuations

Projections DCF DDM EPV Multiples Valuations

Mode

Company Industry Sector

Miscellaneous

Indicators Charts WACC Beta Predictability

Ticker

Industry

Sector

Consolidated Edison, Inc. (ED)

Company Dividend Discount ModelIndustry: Regulated ElectricSector: Utilities

Valuation Snapshot

Stable Growth$106.37 - $230.39$152.15
Multi-Stage$150.12 - $164.66$157.25
Blended Fair Value$154.70
Current Price$100.52
Upside53.90%
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.37$152.15$230.39
Upside / Downside5.81%51.36%129.20%

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.931,243.001,255.07
Year 2 PV (M)1,305.981,331.721,357.71
Year 3 PV (M)1,372.741,413.521,455.10
Year 4 PV (M)1,431.781,488.761,547.44
Year 5 PV (M)1,483.601,557.781,634.89
PV of Terminal Value (M)46,567.7648,896.0651,316.58
Equity Value (M)53,392.7955,930.8458,566.79
Shares Outstanding (M)355.68355.68355.68
Fair Value$150.12$157.25$164.66
Upside / Downside49.34%56.44%63.81%

High-Yield Dividend Screener

« Prev Page 66 of 151 Next »
Ticker ⇵ Company ⇵ Dividend Yield % ▼ Dividend Per Share ⇵ Payout Ratio % ⇵
4151.TKyowa Kirin Co., Ltd.2.30%$58.2379.35%
6526.TSocionext Inc.2.30%$50.3588.64%
8876.TRelo Group, Inc.2.30%$39.4530.35%
8923.TTosei Corporation2.30%$39.4827.05%
CAV1V.HECaverion Oyj2.30%$0.2033.17%
REJL-B.STRejlers AB (publ)2.30%$4.4146.32%
000739.SZApeloa Pharmaceutical Co.,Ltd2.29%$0.3749.76%
0103.HKShougang Century Holdings Limited2.29%$0.0736.62%
016880.KSWoongjin Co., Ltd.2.29%$51.874.40%
0N0B.LWallenius Wilhelmsen ASA2.29%$2.3188.32%
4090.SRTaiba Investments Co.2.29%$0.7550.33%
4322.SRRetal Urban Development Company2.29%$0.2747.98%
DITTO-R.BKDitto (Thailand) Public Company Limited2.29%$0.2531.94%
INDIAMART.BOIndiaMART InterMESH Limited2.29%$49.7955.81%
Q0F.SIIHH Healthcare Berhad2.29%$0.0624.43%
600531.SSHenan Yuguang Gold&Lead Co.,Ltd.2.28%$0.2736.36%
605258.SSJiangsu Xiehe Electronic Co.,Ltd.2.28%$0.7190.23%
9580.SRAl Rashid Industrial Co.2.28%$1.1217.64%
LEMON.HELemonsoft Oyj2.28%$0.1460.80%
NIL-B.STNilörngruppen AB2.28%$1.5028.94%
RAA.DERational AG2.28%$15.0066.90%
002612.SZLancy Co., Ltd.2.27%$0.4619.77%
0S9E.LExtendicare Inc.2.27%$0.4748.82%
1717.HKAusnutria Dairy Corporation Ltd2.27%$0.0525.74%
300898.SZPanda Dairy Corporation2.27%$0.6178.87%
6326.TKubota Corporation2.27%$50.2932.77%
ANN.AXAnsell Limited2.27%$0.8065.03%
KMP-UN.TOKillam Apartment REIT2.27%$0.378.57%
024900.KSDY DEOKYANG Co.,Ltd.2.26%$49.0019.20%
2204.TNakamuraya Co., Ltd.2.26%$69.4851.40%
688389.SSShenzhen Lifotronic Technology Co., Ltd.2.26%$0.2950.03%
ACNAccenture plc2.26%$5.8748.14%
002949.SZShenzhen Capol International & Associatesco., Ltd2.25%$0.3581.66%
082640.KSTong Yang Life Insurance Co., Ltd.2.25%$144.0813.49%
178920.KSPI Advanced Materials Co., Ltd.2.25%$350.0636.50%
4708.TRelia, Inc.2.25%$32.9349.64%
600335.SSSinomach Automobile Co., Ltd.2.25%$0.1548.99%
603087.SSGan & Lee Pharmaceuticals.2.25%$1.5397.20%
6703.TOki Electric Industry Co., Ltd.2.25%$44.7536.33%
9556.SRNofoth Food Products Company2.25%$0.2331.29%
9828.TGenki Global Dining Concepts Corp2.25%$70.0025.83%
L3H.FShell plc2.25%$1.4458.25%
LLYC.MCLlorente & Cuenca, S.A.2.25%$0.1622.13%
PECOS.BOPecos Hotels and Pubs Limited2.25%$6.5032.07%
PTSP.JKPT Pioneerindo Gourmet International Tbk2.25%$22.7326.81%
006890.KSTaekyung Chemical Co., Ltd.2.24%$179.5129.43%
600426.SSShandong Hualu-Hengsheng Chemical Co., Ltd.2.24%$0.7046.22%
601918.SSChina Coal Xinji Energy Co.,Ltd2.24%$0.1518.77%
7547.TWOIntumit Inc.2.24%$1.2840.76%
7984.TKokuyo Co., Ltd.2.24%$19.6244.02%