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$345.85 - $923.26$529.87
Multi-Stage$246.77 - $269.04$257.70
Blended Fair Value$393.79
Current Price$378.35
Upside4.08%
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.08%9.08%9.08%
Growth Rate5.50%6.50%7.50%
Fair Value$345.85$529.87$923.26
Upside / Downside-8.59%40.05%144.02%

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.08%9.08%9.08%
Growth Rate5.50%6.50%7.50%
Year 1 PV (M)9,578.149,668.939,759.71
Year 2 PV (M)10,016.9610,207.7610,400.35
Year 3 PV (M)10,416.6610,715.6911,020.38
Year 4 PV (M)10,779.3411,193.8811,620.27
Year 5 PV (M)11,106.9911,643.4612,200.46
PV of Terminal Value (M)193,387.82202,728.53212,426.72
Equity Value (M)245,285.91256,158.24267,427.90
Shares Outstanding (M)994.00994.00994.00
Fair Value$246.77$257.70$269.04
Upside / Downside-34.78%-31.89%-28.89%

High-Yield Dividend Screener

« Prev Page 4 of 151 Next »
Ticker Company Dividend Yield % Dividend Per Share Payout Ratio %
EG7.IRFBD Holdings plc12.49%$1.9761.47%
WILCG. Willi-Food International Ltd.12.48%$3.5852.70%
9908.HKJiaXing Gas Group Co., Ltd.12.44%$1.0240.94%
MPMX.JKPT Mitra Pinasthika Mustika Tbk12.44%$120.0095.84%
0QL5.LCarlo Gavazzi Holding AG12.42%$20.0062.49%
GOZ.AXGrowthpoint Properties Australia12.40%$0.3016.37%
1999.HKMan Wah Holdings Limited12.39%$0.5757.62%
1285.HKJiashili Group Limited12.38%$0.1455.24%
600015.SSHua Xia Bank Co., Limited12.36%$0.8549.77%
BNP.DEBNP Paribas S.A.12.28%$10.0751.11%
0836.HKChina Resources Power Holdings Company Limited12.20%$2.1541.97%
BIS.AXBisalloy Steel Group Limited12.19%$0.5981.88%
KBS.BKKhonburi Sugar Public Company Limited12.17%$0.7056.34%
9300.SRAlwaha REIT Fund12.14%$1.1871.67%
2005.HKSSY Group Limited12.13%$0.3550.50%
BGI-UN.TOBrookfield Global Infrastructure Securities Income Fund12.09%$0.9646.13%
2003.HKVCREDIT Holdings Limited12.07%$0.3218.47%
1713.HKSichuan Energy Investment Development Co., Ltd.12.02%$0.2941.35%
NSI.ASNSI N.V.12.02%$2.3330.60%
RIO1.DERio Tinto Group12.02%$8.2864.54%
IGL.AXIVE Group Limited12.01%$0.3574.81%
0G5B.LSto SE & Co. KGaA12.00%$14.6483.41%
CDU.LSConduril - Engenharia, S.A.12.00%$1.8069.00%
2156.HKC&D Property Management Group Co. Limited11.98%$0.3354.74%
0057.HKChen Hsong Holdings Limited11.94%$0.1945.38%
BBSE3.SABB Seguridade Participações S.A.11.93%$4.2691.94%
SWUT.VISW Umwelttechnik Stoiser & Wolschner AG11.93%$3.7034.18%
0Q76.LCBo Territoria S.A.11.92%$0.4461.80%
ALCOF.PACofidur S.A.11.92%$34.8038.87%
0239.HKPak Fah Yeow International Limited11.87%$0.2852.60%
2356.HKDah Sing Banking Group Limited11.87%$1.2941.19%
3311.HKChina State Construction International Holdings Limited11.87%$1.1029.31%
ENGI.PAEngie S.A.11.87%$2.7376.93%
SENA.BKSena Development Public Company Limited11.86%$0.2074.93%
4348.SRAlkhabeer REIT Fund11.85%$0.6698.08%
AWZ.SIMulti-Chem Limited11.83%$0.4160.70%
0331.HKFSE Lifestyle Services Limited11.81%$0.6731.73%
SUL.AXSuper Retail Group Limited11.78%$1.8791.92%
2877.HKChina Shineway Pharmaceutical Group Limited11.77%$1.0139.47%
DSWLDeswell Industries, Inc.11.77%$0.4027.95%
0855.HKChina Water Affairs Group Limited11.75%$0.6256.78%
0659.HKCTF Services Limited11.70%$0.8876.18%
DRA.AXDRA Global Limited11.69%$0.2158.65%
GWA.AXGWA Group Limited11.68%$0.2995.40%
0968.HKXinyi Solar Holdings Limited11.67%$0.3670.18%
ENI-UN.TOEnergy Income Fund11.66%$0.2356.38%
TCF.AX360 Capital Mortgage REIT11.66%$0.6776.18%
3316.HKBinjiang Service Group Co. Ltd.11.65%$2.7669.09%
CC3.SIStarHub Ltd11.65%$0.1381.69%
TFG-R.BKThaifoods Group Public Company Limited11.65%$0.5242.58%