Definitive Analysis | Institutional-Grade Financial Research
Definitive Analysis
Get Full Access
See Pricing Start Free Trial

The Home Depot, Inc. (HD)

Company Dividend Discount ModelIndustry: Home ImprovementSector: Consumer Cyclical

Valuation Snapshot

Stable Growth$344.12 - $912.86$526.20
Multi-Stage$246.01 - $268.21$256.91
Blended Fair Value$391.55
Current Price$378.35
Upside3.49%
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 Rate9.10%9.10%9.10%
Growth Rate5.50%6.50%7.50%
Fair Value$344.12$526.20$912.86
Upside / Downside-9.05%39.08%141.27%

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 Rate9.10%9.10%9.10%
Growth Rate5.50%6.50%7.50%
Year 1 PV (M)9,576.569,667.339,758.10
Year 2 PV (M)10,013.6610,204.3910,396.92
Year 3 PV (M)10,411.5110,710.3811,014.93
Year 4 PV (M)10,772.2311,186.5011,612.60
Year 5 PV (M)11,097.8311,633.8612,190.40
PV of Terminal Value (M)192,657.97201,963.42211,625.02
Equity Value (M)244,529.75255,365.88266,597.97
Shares Outstanding (M)994.00994.00994.00
Fair Value$246.01$256.91$268.21
Upside / Downside-34.98%-32.10%-29.11%

High-Yield Dividend Screener

« Prev Page 10 of 151 Next »
Ticker Company Dividend Yield % Dividend Per Share Payout Ratio %
BNGA.JKPT Bank CIMB Niaga Tbk8.91%$157.7256.96%
QIGD.QAQatari Investors Group Q.S.C.8.91%$0.1397.17%
MCS-R.BKM.C.S. Steel Public Company Limited8.90%$0.7434.29%
0QR1.LSchweiter Technologies AG8.89%$22.4090.72%
0816.HKJinmao Property Services Co., Limited8.88%$0.2355.27%
3492.TMIRARTH Real Estate Investment Corporation8.88%$8,301.0988.12%
3998.HKBosideng International Holdings Limited8.86%$0.4070.17%
PJP.WAPJP Makrum S.A.8.86%$1.4265.03%
603565.SSShanghai Zhonggu Logistics Co., Ltd.8.84%$0.8987.23%
ALVAP.PAKumulus Vape S.A.8.83%$0.3724.09%
IPS.PAIpsos S.A.8.83%$2.9938.93%
RFF.AXRural Funds Group8.83%$0.1715.19%
KOV.AXKorvest Ltd8.81%$1.2460.47%
0QUS.LG5 Entertainment AB (publ)8.80%$8.0594.74%
9620.SRBalsm Alofoq Medical Co.8.80%$2.4063.98%
PPM.AXPepper Money Limited8.80%$0.2044.77%
VK.PAVallourec S.A.8.80%$1.4183.22%
BBNI.JKPT Bank Negara Indonesia (Persero) Tbk8.79%$374.4666.86%
KJL.BKKijcharoen Engineering Electric Public Company Limited8.79%$0.5473.06%
0856.HKVSTECS Holdings Limited8.78%$0.7147.24%
BA-R.BKBangkok Airways Public Company Limited8.78%$1.3083.23%
PFRM3.SAProfarma Distribuidora de Produtos Farmacêuticos S.A.8.78%$0.7478.88%
0001.HKCK Hutchison Holdings Limited8.77%$4.7359.96%
NOBLE-R.BKNoble Development Public Company Limited8.75%$0.1927.34%
RANA.OLRana Gruber ASA8.75%$6.7583.80%
PDG.BKProdigy Public Company Limited8.74%$0.2690.35%
WHC.AXWhitehaven Coal Limited8.74%$0.6856.57%
DLTA.JKPT Delta Djakarta Tbk8.73%$175.4299.09%
8371.HKTaste Gourmet Group Limited8.70%$0.1853.44%
TRAN.BACompañía de Transporte de Energía Eléctrica en Alta Tensión Transener S.A.8.70%$301.7991.83%
0257.HKChina Everbright Environment Group Limited8.69%$0.4235.73%
EMB.AXEmbelton Limited8.69%$0.7069.10%
HP3A.DERingmetall SE8.69%$0.2438.33%
RDTX.JKPT Roda Vivatex Tbk8.69%$1,103.9395.63%
S56.SISamudera Shipping Line Ltd8.69%$0.1060.61%
1307.TWSan Fang Chemical Industry Co., Ltd.8.68%$2.7091.10%
ASIZ.LAberforth Split Level Income ZDP 20248.68%$11.0447.29%
PIC.AXPerpetual Equity Investment Company Limited8.68%$0.1197.90%
CPHN.SWCPH Chemie + Papier Holding AG8.66%$5.9989.84%
JIN.AXJumbo Interactive Limited8.66%$0.9974.11%
PM-R.BKPremier Marketing Public Company Limited8.66%$1.0390.60%
0546.HKFufeng Group Limited8.65%$0.7030.72%
ITB.DEImperial Brands PLC8.65%$3.0955.77%
LOGG3.SALOG Commercial Properties e Participações S.A.8.64%$2.1949.79%
5547.TWOJioushun Construction Co., Ltd.8.63%$2.2658.13%
TWD.AXTamawood Limited8.62%$0.2480.43%
UNITED.HEUnited Bankers Oyj8.60%$1.6153.91%
DDR.AXDicker Data Limited8.58%$0.8796.73%
PATO.BKPato Chemical Industry Public Company Limited8.58%$0.6098.05%
0371.HKBeijing Enterprises Water Group Limited8.56%$0.2164.00%