Definitive Analysis
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 13 of 151 Next »
Ticker Company Dividend Yield % Dividend Per Share Payout Ratio %
PCR.WAPCC Rokita S.A.7.82%$5.0595.33%
TQR.BKTQR Public Company Limited7.82%$0.3990.56%
KGI.BKKGI Securities (Thailand) Public Company Limited7.81%$0.3162.80%
PRDA.JKPT Prodia Widyahusada Tbk7.81%$180.5285.06%
AIMIRT.BKAIM Industrial Growth Freehold and Leasehold Real Estate Investment Trust7.80%$0.8581.01%
AKRA.JKPT AKR Corporindo Tbk7.80%$99.8882.20%
SPREME.BKSupreme Distribution Public Company Limited7.80%$0.1190.62%
AYV.PAAyvens7.79%$0.9171.87%
1378.HKChina Hongqiao Group Limited7.78%$2.6556.89%
NRG.PANRJ Group S.A.7.78%$0.6363.81%
D2O.AXDuxton Water Limited7.77%$0.1250.68%
TVO-R.BKThai Vegetable Oil Public Company Limited7.77%$1.7462.11%
C38U.SICapitaLand Integrated Commercial Trust7.76%$0.1874.73%
002839.SZJiangsu Zhangjiagang Rural Commercial Bank Co., Ltd7.75%$0.3544.09%
0710.HKBOE Varitronix Limited7.75%$0.4239.15%
0951.HKChaowei Power Holdings Limited7.75%$0.1120.52%
1681.HKConsun Pharmaceutical Group Limited7.75%$1.2055.92%
AXA.DEAXA S.A.7.75%$3.1752.74%
RND.AXRand Mining Limited7.75%$0.2057.47%
601881.SSChina Galaxy Securities Co., Ltd.7.74%$1.2298.30%
TA1.DETelekom Austria AG7.74%$0.7679.04%
0746.HKLee & Man Chemical Company Limited7.73%$0.4035.48%
NESN.SWNestlé S.A.7.73%$6.0972.83%
2633.HKJacobson Pharma Corporation Limited7.72%$0.1036.63%
000498.SZShandong Hi-Speed Road and Bridge Group Co., Ltd.7.71%$0.4748.64%
0016.HKSun Hung Kai Properties Limited7.71%$7.4556.97%
0QKE.LVontobel Holding AG7.70%$4.4661.99%
HAEK.DEHaemato AG7.70%$1.6385.37%
2688.HKENN Energy Holdings Limited7.68%$5.3950.36%
ASIMAR.BKAsian Marine Services Public Company Limited7.68%$0.1260.54%
SAMS.PASamse S.A.7.68%$10.2556.16%
SEC.AXSpheria Emerging Companies Limited7.68%$0.2215.84%
UVAN.BKUnivanich Palm Oil Public Company Limited7.68%$1.0063.09%
JCT.BKJack Chia Industries (Thailand) Public Company Limited7.67%$6.4483.85%
KFL.NZKingfish Limited7.67%$0.1038.05%
ALRIB.PARiber S.A.7.65%$0.2771.18%
DXI.AXDexus Industria REIT7.65%$0.2117.56%
NISP.JKPT Bank OCBC NISP Tbk7.65%$106.0049.91%
SCG.AXScentre Group7.65%$0.3291.06%
002572.SZSuofeiya Home Collection Co., Ltd.7.62%$1.0488.29%
035000.KSHS Ad Inc.7.62%$648.8381.78%
JMT-R.BKJMT Network Services Public Company Limited7.62%$0.6769.23%
SQU.DEVinci S.A.7.62%$9.2455.99%
0QP2.LZurich Insurance Group AG7.61%$32.4879.70%
BAMI.MIBanco BPM S.p.A.7.61%$1.0080.93%
600795.SSGD Power Development Co.,Ltd7.60%$0.3892.13%
BTI.AXBailador Technology Investments Limited7.60%$0.0934.83%
SMPC.BKSahamitr Pressure Container Public Company Limited7.60%$0.6757.18%
0O33.LOeneo S.A.7.59%$0.7076.88%
BOREO.HEBoreo Oyj7.59%$1.0882.86%