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 76 of 151 Next »
Ticker Company Dividend Yield % Dividend Per Share Payout Ratio %
DR.TOMedical Facilities Corporation1.80%$0.287.21%
PINE3.SABanco Pine S.A.1.80%$0.2316.47%
SVED-B.STSvedbergs i Dalstorp AB (publ)1.80%$1.2532.77%
002296.SZHeNan Splendor Science & Technology Co., Ltd.1.79%$0.2025.74%
002349.SZJinghua Pharmaceutical Group Co., Ltd.1.79%$0.1347.07%
002841.SZGuangzhou Shiyuan Electronic Technology Company Limited1.79%$0.7153.65%
007690.KSKukdo Chemical Co., Ltd.1.79%$569.7119.70%
010690.KSHWASHIN CO.,Ltd1.79%$145.8913.31%
049770.KSDongwon F&B Co., Ltd.1.79%$800.0312.97%
1836.HKStella International Holdings Limited1.79%$0.2778.00%
5ML.SIOld Chang Kee Ltd.1.79%$0.0221.40%
603456.SSZhejiang Jiuzhou Pharmaceutical Co., Ltd1.79%$0.3239.16%
6245.THIRANO TECSEED Co.,Ltd.1.79%$29.9248.19%
9999.HKNetEase, Inc.1.79%$4.1136.47%
EFK.WAKorporacja Gospodarcza Efekt S.A.1.79%$0.103.27%
IFSH.JKPT Ifishdeco Tbk1.79%$14.6252.99%
WGSH.JKPT Wira Global Solusi Tbk1.79%$5.0059.74%
001060.KSJW Pharmaceutical Corporation1.78%$458.4617.63%
001332.SZWuxi Chemical Equipment Co., Ltd.1.78%$1.0044.53%
002312.SZSichuan Development Lomon Co., Ltd.1.78%$0.1967.49%
002900.KSTYM Corporation1.78%$112.2711.09%
003018.SZJinFu Technology Co., Ltd.1.78%$0.3168.11%
003023.SZChengdu Rainbow Appliance (Group) Shares Co., Ltd.1.78%$0.4051.85%
004490.KSSebang Global Battery Co., Ltd.1.78%$1,112.7311.15%
0KFH.LRevenio Group Oyj1.78%$0.4058.60%
1357.HKMeitu, Inc.1.78%$0.1344.58%
300610.SZYangzhou Chenhua New Material Co., Ltd.1.78%$0.2163.13%
3543.TKOMEDA Holdings Co., Ltd.1.78%$54.0341.58%
5450.TWONam Liong Global Corporation1.78%$0.2545.91%
600458.SSZhuzhou Times New Material Technology Co., Ltd.1.78%$0.2437.98%
603037.SSShanghai Carthane Co.,Ltd.1.78%$0.2678.70%
603876.SSJiangsu Dingsheng New Material Joint-Stock Co.,Ltd1.78%$0.2764.69%
603916.SSSobute New Materials Co., Ltd1.78%$0.1762.46%
6167.TFuji Die Co.,Ltd.1.78%$15.9369.67%
6981.TMurata Manufacturing Co., Ltd.1.78%$57.8845.13%
FLEXD.LSFlexdeal Simfe S.A.1.78%$0.0938.33%
MIKA.JKPT Mitra Keluarga Karyasehat Tbk1.78%$43.0046.34%
SARKY.ISSarkuysan Elektrolitik Bakir Sanayi ve Ticaret A.S.1.78%$0.3353.78%
002249.SZZhongshan Broad-Ocean Motor Co., Ltd.1.77%$0.1944.29%
012330.KSHyundai Mobis Co.,Ltd1.77%$6,540.9013.98%
111770.KSYoungone Corporation1.77%$1,406.1316.14%
2754.TTokatsu Holdings Co.,Ltd.1.77%$14.3118.28%
600236.SSGuangxi Guiguan Electric PowerCo.,Ltd.1.77%$0.1442.95%
603605.SSProya Cosmetics Co.,Ltd.1.77%$1.2130.20%
603759.SSHaitian Water Group Co.,Ltd1.77%$0.1932.54%
688076.SSSinopep-Allsino Bio Pharmaceutical Co.,Ltd.1.77%$0.6742.24%
8015.TToyota Tsusho Corporation1.77%$93.3828.94%
9722.TFujita Kanko Inc.1.77%$46.655.91%
9962.TMISUMI Group Inc.1.77%$43.3636.74%
ADORFO.BOAdor Fontech Limited1.77%$2.5238.55%