Definitive Analysis
Loading...
Definitive Analysis

Financial Statements

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 74 of 151 Next »
Ticker Company Dividend Yield % Dividend Per Share Payout Ratio %
PHN.MIPharmanutra S.p.A.1.89%$1.0254.97%
002117.SZTungkong Inc.1.88%$0.2667.89%
031440.KSSHINSEGAE FOOD Inc.1.88%$899.9814.67%
1590.TWAirTAC International Group1.88%$17.9845.66%
2678.HKTexhong Textile Group Limited1.88%$0.096.21%
4112.THodogaya Chemical Co., Ltd.1.88%$42.1632.13%
4739.TITOCHU Techno-Solutions Corporation1.88%$81.1350.53%
600499.SSKeda Industrial Group Co., Ltd.1.88%$0.2634.23%
6594.TNidec Corporation1.88%$40.0525.72%
GFPT-R.BKGFPT Public Company Limited1.88%$0.2010.54%
NGI.AXNavigator Global Investments Limited1.88%$0.0619.77%
SVW.AXSeven Group Holdings Limited1.88%$0.8731.55%
002461.SZGuangzhou Zhujiang Brewery Co., Ltd1.87%$0.1740.51%
002788.SZLuyan Pharma Co.,Ltd.1.87%$0.4049.91%
600600.SSTsingtao Brewery Company Limited1.87%$1.1433.65%
600900.SSChina Yangtze Power Co., Ltd.1.87%$0.5137.99%
603238.SSHangZhou Nbond Nonwovens Co., Ltd.1.87%$0.3348.05%
6875.TMegaChips Corporation1.87%$148.1788.24%
7095.KLP.I.E. Industrial Berhad1.87%$0.0544.49%
8334.TThe Gunma Bank, Ltd.1.87%$32.3726.45%
BVB.DEBorussia Dortmund GmbH & Co. Kommanditgesellschaft auf Aktien1.87%$0.0623.76%
DNG.TODynacor Group Inc.1.87%$0.1028.25%
ICNC-UNIconic Sports Acquisition Corp.1.87%$0.2030.34%
PAZ.SNPaz Corp S.A.1.87%$14.9926.20%
002756.SZYongxing Special Materials Technology Co.,Ltd1.86%$1.0188.45%
006980.KSWoosung Co., Ltd.1.86%$299.972.95%
084110.KQHuons Global Co., Ltd.1.86%$939.2047.07%
4100.SRMakkah Construction & Development Company1.86%$1.4866.05%
603867.SSZhejiang Xinhua Chemical Co.,Ltd1.86%$0.4738.85%
6849.TNihon Kohden Corporation1.86%$31.3228.12%
9515.SRFesh Fash Snack Food Production Company1.86%$0.1824.81%
CIMSA.ISÇimsa Çimento Sanayi ve Ticaret A.S.1.86%$0.8543.17%
EGATIF.BKElectricity Generating Authority Of Thailand- North Bangkok Power Plant Block 1 Infrastructure Fund1.86%$0.1122.36%
ESNTEssent Group Ltd.1.86%$1.2117.35%
RVRC.STRVRC Holding AB (publ)1.86%$1.2044.59%
002803.SZXiamen Jihong Technology Co., Ltd.1.85%$0.3049.75%
2467.TWC Sun Mfg Ltd.1.85%$4.9998.76%
300160.SZJiangsu Xiuqiang Glasswork Co., Ltd.1.85%$0.1037.25%
600609.SSShenyang Jinbei Automotive Company Limited1.85%$0.0941.26%
601882.SSNingbo Haitian Precision Machinery Co.,Ltd.1.85%$0.3641.14%
603199.SSAnhui Jiuhuashan Tourism Development Co., Ltd.1.85%$0.6835.31%
7245.TDaido Metal Co., Ltd.1.85%$18.1630.01%
BTGB2Gold Corp.1.85%$0.0856.43%
COIC.STConcentric AB (publ)1.85%$4.2555.44%
MPCC.OLMPC Container Ships ASA1.85%$0.3256.17%
000823.SZGuangdong Goworld Co., Ltd.1.84%$0.2554.48%
0529.HKSiS International Holdings Limited1.84%$0.043.76%
0KBI.LKnorr-Bremse AG1.84%$1.7566.92%
300866.SZAnker Innovations Limited1.84%$2.1043.92%
4013.SRDr. Sulaiman Al Habib Medical Services Group Company1.84%$4.7270.08%