Definitive Analysis
Loading...
Definitive Analysis

Financials

Fundamentals

Ticker

Industry

Sector

The Home Depot, Inc. (HD)

Company Dividend Discount ModelIndustry: Home ImprovementSector: Consumer Cyclical

Valuation Snapshot

Stable Growth$402.71 - $1,357.51$658.96
Multi-Stage$270.14 - $294.70$282.20
Blended Fair Value$470.58
Current Price$378.35
Upside24.38%
DecisionDon't Buy

Dividend History & Growth Metrics (10Y)

Metric5Y CAGR10Y CAGR2025202420232022202120202019201820172016
DPS8.43%13.44%8.988.437.847.036.495.994.734.243.423.05
YoY Growth--6.51%7.63%11.51%8.28%8.27%26.66%11.68%23.74%12.31%19.80%
Dividend Yield--2.48%2.50%2.63%2.29%1.97%2.70%2.37%2.29%2.22%2.24%

Stable Growth Model (Adjusted)

(USD in Millions except Per Share Data)
Net Income To Common (M)14,582.00
(-) Cash Dividends Paid (M)9,098.00
(=) Cash Retained (M)5,484.00
MetricLOWBASEHIGH
Required Retention Ratio20.0%12.5%7.5%
(=) Cash Required (M)2,916.401,822.751,093.65
Cash Retained (M)5,484.005,484.005,484.00
(-) Cash Required (M)-2,916.40-1,822.75-1,093.65
(=) Excess Retained (M)2,567.603,661.254,390.35
(/) Shares Outstanding (M)994.00994.00994.00
(=) Excess Retained per Share2.583.684.42
LTM Dividend per Share9.159.159.15
(+) Excess Retained per Share2.583.684.42
(=) Adjusted Dividend11.7412.8413.57
WACC / Discount Rate8.57%8.57%8.57%
Growth Rate5.50%6.50%7.50%
Fair Value$402.71$658.96$1,357.51
Upside / Downside6.44%74.17%258.80%

Multi-Stage Model: Projections

(USD in Millions)
MetricTTMDec-27Dec-28Dec-29Dec-30Dec-31Terminal
Net Income (M)14,582.0015,529.8316,539.2717,614.3218,759.2519,978.6020,577.96
Payout Ratio62.39%67.91%73.44%78.96%84.48%90.00%92.50%
Projected Dividends (M)9,098.0010,546.8712,145.6413,907.7015,847.5217,980.7419,034.61

Multi-Stage Valuation

MetricLOWBASEHIGH
WACC / Discount Rate8.57%8.57%8.57%
Growth Rate5.50%6.50%7.50%
Year 1 PV (M)9,622.739,713.949,805.15
Year 2 PV (M)10,110.4410,303.0110,497.41
Year 3 PV (M)10,562.8110,866.0311,175.00
Year 4 PV (M)10,981.4611,403.7711,838.15
Year 5 PV (M)11,367.9211,917.0012,487.09
PV of Terminal Value (M)215,876.54226,303.46237,129.44
Equity Value (M)268,521.89280,507.21292,932.23
Shares Outstanding (M)994.00994.00994.00
Fair Value$270.14$282.20$294.70
Upside / Downside-28.60%-25.41%-22.11%

High-Yield Dividend Screener

« Prev Page 68 of 151 Next »
Ticker Company Dividend Yield % Dividend Per Share Payout Ratio %
0316.HKOrient Overseas (International) Limited2.19%$2.7948.77%
3109.TShikibo Ltd.2.19%$22.8930.55%
3679.TZIGExN Co., Ltd.2.19%$10.5526.56%
4516.TNippon Shinyaku Co., Ltd.2.19%$123.8726.14%
4617.TChugoku Marine Paints, Ltd.2.19%$96.7242.42%
600051.SSNingbo United Group Co.,Ltd.2.19%$0.1755.08%
603799.SSZhejiang Huayou Cobalt Co., Ltd2.19%$1.4948.01%
7233.KLDufu Technology Corp. Berhad2.19%$0.0495.65%
9064.TYamato Holdings Co., Ltd.2.19%$48.3336.15%
9948.TARCS Company Limited2.19%$74.0133.92%
000049.SZShenzhen Desay Battery Technology Co., Ltd.2.18%$0.5954.00%
000153.SZAnhui Fengyuan Pharmaceutical Co., Ltd.2.18%$0.1455.80%
002237.SZShandong Humon Smelting Co., Ltd.2.18%$0.2961.47%
002626.SZXiamen Kingdomway Group Company2.18%$0.4354.26%
2468.TWFortune Information Systems Corp2.18%$0.9078.36%
300815.SZEIT Environmental Development Group Co.,Ltd2.18%$0.5038.67%
300910.SZXinxiang Richful Lube Additive Co., Ltd2.18%$1.2345.00%
4908.TWOAPAC Opto Electronics Inc.2.18%$1.7472.09%
601369.SSXi'an Shaangu Power Co., Ltd.2.18%$0.2237.55%
067160.KQSoop Co., Ltd.2.17%$1,492.2515.52%
3898.HKZhuzhou CRRC Times Electric Co., Ltd.2.17%$0.8329.19%
4507.TShionogi & Co., Ltd.2.17%$61.6530.72%
603383.SSFujian Apex Software Co.,LTD2.17%$0.7883.82%
603568.SSZhejiang Weiming Environment Protection Co., Ltd.2.17%$0.5534.14%
7181.TJapan Post Insurance Co., Ltd.2.17%$102.1324.56%
053800.KQAhnLab, Inc.2.16%$1,304.4028.50%
0QI9.LCreades AB2.16%$1.5916.64%
601233.SSTongkun Group Co., Ltd.2.16%$0.3750.52%
605056.SSXianheng International Science&Technology Co., Ltd.2.16%$0.3657.45%
MGICMagic Software Enterprises Ltd.2.16%$0.5669.02%
002311.SZGuangdong Haid Group Co., Limited2.15%$1.1939.51%
3727.TAplix Corporation2.15%$3.4454.78%
603586.SSShandong Gold Phoenix Co.,Ltd2.15%$0.4151.17%
6268.TNabtesco Corporation2.15%$80.7460.45%
ATRLJ-B.STAtrium Ljungberg AB (publ)2.15%$0.7141.67%
BPAN4.SABanco Pan S.A.2.15%$0.2441.77%
NCM.AXNewcrest Mining Limited2.15%$0.5038.39%
PARAUCO.SNParque Arauco S.A.2.15%$62.7342.33%
SHANG.BKShangri-La Hotel Public Company Limited2.15%$1.0056.93%
VZUG.SWV-ZUG Holding AG2.15%$0.9119.03%
WTIF.SGWisdomTree Japan Equity UCITS ETF2.15%$0.9891.42%
002258.SZLier Chemical Co.,LTD.2.14%$0.2848.19%
002605.SZShanghai Yaoji Technology Co., Ltd.2.14%$0.5042.55%
0GZV.ILGetinge AB (publ)2.14%$4.6761.88%
0PMJ.LSiemens Healthineers AG2.14%$0.9549.72%
300482.SZGuangzhou Wondfo Biotech Co.,Ltd2.14%$0.4274.45%
5288.KLSime Darby Property Berhad2.14%$0.0342.63%
603218.SSRiyue Heavy Industry Co., Ltd.2.14%$0.2852.42%
BXB.AXBrambles Limited2.14%$0.4940.03%
POBS.BOPlatinumOne Business Services2.14%$3.0015.69%