Definitive Analysis
Loading...
Definitive Analysis

Financial Statements

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.67$157.26
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.82%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.751,413.531,455.10
Year 4 PV (M)1,431.781,488.771,547.44
Year 5 PV (M)1,483.601,557.781,634.90
PV of Terminal Value (M)46,568.6448,897.0051,317.56
Equity Value (M)53,393.6955,931.7958,567.78
Shares Outstanding (M)355.68355.68355.68
Fair Value$150.12$157.26$164.67
Upside / Downside49.34%56.44%63.81%

High-Yield Dividend Screener

« Prev Page 69 of 151 Next »
Ticker Company Dividend Yield % Dividend Per Share Payout Ratio %
SIE.DESiemens AG2.14%$5.1641.34%
TBIG.JKPT Tower Bersama Infrastructure Tbk2.14%$55.6585.41%
VNX.DENXP Semiconductors N.V.2.14%$4.0549.93%
010100.KSKorea Movenex Co., Ltd.2.13%$99.689.18%
300154.SZShenzhen Riland Industry Group Co., Ltd2.13%$0.2190.73%
600848.SSShanghai Lingang Holdings Co.,Ltd.2.13%$0.2539.80%
7259.TAisin Corporation2.13%$62.3927.27%
ALBRK.ISAlbaraka Türk Katilim Bankasi A.S.2.13%$0.173.51%
BURBurford Capital Limited2.13%$0.1947.60%
ECSC.LECSC Group plc2.13%$1.1222.10%
PR9.BKPraram 9 Hospital Public Company Limited2.13%$0.4038.51%
000630.SZTongling Nonferrous Metals Group Co.,Ltd.2.12%$0.1392.15%
000878.SZYunnan Copper Co., Ltd.2.12%$0.4467.43%
002223.SZJiangsu Yuyue Medical Equipment & Supply Co., Ltd.2.12%$0.8146.42%
002731.SZShenyang Cuihua Gold and Silver Jewelry Co., Ltd.2.12%$0.2724.86%
0RKK.LVolati AB2.12%$2.2057.57%
0RVK.LBefesa S.A.2.12%$0.7464.88%
163560.KSDRB Industrial Co., Ltd.2.12%$146.7836.08%
2641.TWOFranbo Lines Corp.2.12%$0.4325.10%
443060.KSHdhms2.12%$4,099.9369.50%
605500.SSForest Packaging Group Co.,Ltd.2.12%$0.1989.23%
6455.TMorita Holdings Corporation2.12%$58.4524.57%
CCOLA.ISCoca-Cola Içecek Anonim Sirketi2.12%$1.2625.02%
MTWI.JKPT Malacca Trust Wuwungan Insurance Tbk2.12%$7.8425.68%
PNDX-B.STPandox AB (publ)2.12%$4.2540.78%
000860.KSKangnam Jevisco Co., Ltd2.11%$292.3959.03%
002440.SZZhejiang Runtu Co., Ltd.2.11%$0.1660.72%
002973.SZQiaoyin City Management Co.,Ltd.2.11%$0.2959.79%
0400.HKIngdan, Inc.2.11%$0.0622.33%
0Z4I.LSunny Optical Technology (Group) Company Limited2.11%$0.7115.45%
200771.SZHangzhou Steam Turbine Co., Ltd.2.11%$0.2859.18%
285130.KSSK Chemicals Co.,Ltd2.11%$1,396.2531.71%
688558.SSNantong Guosheng Intelligence Technology Group Co., Ltd.2.11%$0.6153.65%
NRDF.CONordfyns Bank A/S2.11%$13.0894.24%
001880.KSDL Construction Co., Ltd.2.10%$300.9316.73%
002967.SZGRG Metrology & Test Group Co. Ltd. Class A2.10%$0.4662.67%
023350.KSKorea Engineering Consultants Corp.2.10%$100.0016.54%
1423.TWReward Wool Industry Corporation2.10%$0.7918.73%
2811.TKagome Co., Ltd.2.10%$56.5639.32%
601456.SSGuolian Minsheng Securities Co., Ltd.2.10%$0.2168.71%
U10.SIUOB-Kay Hian Holdings Limited2.10%$0.0524.07%
UNBL.PAUnibel S.A.2.10%$24.7334.10%
3979.TUluru.Co.,Ltd.2.09%$8.7136.14%
600309.SSWanhua Chemical Group Co., Ltd.2.09%$1.6045.09%
7714.TWOUniforce Technology Corp.2.09%$3.8369.36%
ALIG.STAlimak Group AB (publ)2.09%$2.9845.61%
002226.SZAnhui Jiangnan Chemical Industry Co., Ltd.2.08%$0.1239.66%
002706.SZShanghai Liangxin Electrical Co.,LTD.2.08%$0.2279.51%
002763.SZShenzhen Huijie Group Co., Ltd.2.08%$0.1578.60%
4016.SRMiddle East Pharmaceutical Industries Company2.08%$2.3548.29%