Definitive Analysis
Definitive Analysis

Financial Statements

Fundamentals

Valuations

Miscellaneous

Analysis Mode

Search

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 36 of 151 Next »
Ticker Company Dividend Yield % Dividend Per Share Payout Ratio %
603317.SSSichuan Teway Food Group Co.,Ltd4.37%$0.5599.52%
ATRUST.ATAlpha Trust Mutual Fund and Alternative Investment Fund Management S.A.4.37%$0.5666.75%
BAM-R.BKBangkok Commercial Asset Management Public Company Limited4.37%$0.3550.66%
BPP-R.BKBanpu Power Public Company Limited4.37%$0.5585.50%
CRR-UN.TOCrombie Real Estate Investment Trust4.37%$0.6776.03%
U14.SIUOL Group Limited4.37%$0.3828.25%
016710.KSDaesung Holdings Co., Ltd.4.36%$368.1823.51%
093050.KSLF Corp.4.36%$772.5624.62%
600285.SSHenan Lingrui Pharmaceutical Co., Ltd.4.36%$0.9064.11%
EMAARDEV.AEEmaar Development PJSC4.36%$0.6827.01%
EN.PABouygues S.A.4.36%$1.9772.18%
HWX.TOHeadwater Exploration Inc.4.36%$0.4257.78%
PIRC.MIPirelli & C. S.p.A.4.36%$0.2651.67%
ZWACK.BDZwack Unicum Nyrt.4.36%$1,500.0088.31%
000531.SZGuangzhou Hengyun Enterprises Holding Ltd4.35%$0.2868.19%
000538.SZYunnan Baiyao Group Co.,Ltd4.35%$2.4784.67%
4792.TYAMADA Consulting Group Co.,Ltd.4.35%$76.8861.51%
603165.SSZhejiang Rongsheng Environmental Protection Paper Joint Stock Co., Ltd.4.35%$0.5573.83%
SBFG3.SAGrupo SBF S.A.4.35%$0.5537.97%
000240.KSHankook & Company Co., Ltd.4.34%$1,090.2033.39%
WCP.TOWhitecap Resources Inc.4.34%$0.5168.17%
8595.TJAFCO Group Co., Ltd.4.33%$104.3181.02%
ADW-A.TOAndrew Peller Limited4.33%$0.2364.87%
ITRNIturan Location and Control Ltd.4.33%$1.8464.72%
MRG-UN.TOMorguard North American Residential Real Estate Investment Trust4.33%$0.7528.03%
SYNEX-R.BKSynnex (Thailand) Public Company Limited4.33%$0.4353.70%
002275.SZGuilin Sanjin Pharmaceutical Co., Ltd.4.32%$0.6168.51%
091700.KQPartron Co., Ltd.4.32%$299.9351.71%
000333.SZMidea Group Co., Ltd.4.31%$3.3757.37%
002460.KSHS Hwasung Co., Ltd.4.31%$499.9314.25%
002833.SZGuangzhou KDT Machinery Co.,Ltd.4.31%$0.7074.51%
1050.HKKarrie International Holdings Limited4.31%$0.1159.43%
2763.TFTGroup Co., Ltd.4.31%$55.3330.88%
SB1NO.OLSpareBank 1 Sørøst-Norge4.31%$8.5049.18%
018250.KSAekyung Industrial Co., Ltd.4.30%$579.5745.50%
300441.SZNingbo BaoSi Energy Equipment Co., Ltd.4.30%$0.3272.05%
4042.TTosoh Corporation4.30%$101.0478.91%
4261.SRTheeb Rent A Car Company4.30%$1.6436.96%
AVIA.JKPT Avia Avian Tbk4.30%$22.3878.99%
PREVA.ASValue8 N.V.4.30%$0.2111.56%
SONYN.MXSony Group Corporation4.30%$20.0110.30%
SYMC.BKSymphony Communication Public Company Limited4.30%$0.1542.26%
TOA.BKTOA Paint (Thailand) Public Company Limited4.30%$0.5846.29%
2546.TWKedge Construction Co., Ltd.4.29%$3.6945.15%
267290.KSKyungdong City Gas Co., Ltd4.29%$875.0617.76%
601168.SSWestern Mining Co.,Ltd.4.29%$1.1989.92%
INH.DEINDUS Holding AG4.29%$1.2259.56%
OSP-R.BKOsotspa Public Company Limited4.29%$0.6959.37%
PE1.AXPengana Private Equity Trust4.29%$0.0632.51%
003540.KSDaishin Securities Co., Ltd.4.28%$1,158.7444.30%