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 22 of 151 Next »
Ticker Company Dividend Yield % Dividend Per Share Payout Ratio %
TC.BKTropical Canning (Thailand) Public Company Limited6.05%$0.3042.33%
8984.TDaiwa House REIT Investment Corporation6.04%$8,653.9981.69%
0R40.LRai Way S.p.A.6.03%$0.3399.60%
3600.HKModern Dental Group Limited6.03%$0.3234.31%
003460.KSYuhwa Securities co.,ltd.6.02%$162.4583.00%
298540.KQThe Nature Holdings Co., Ltd.6.02%$521.4476.58%
6263.TWOPlanet Technology Corporation6.02%$7.8695.87%
NZX.NZNZX Limited6.02%$0.0977.46%
WLMM3.SAWLM Participações e Comércio de Máquinas e Veículos S.A.6.02%$1.2340.06%
1760.HKIntron Technology Holdings Limited6.01%$0.1230.56%
5209.KLGas Malaysia Berhad6.01%$0.2682.61%
ALLAN.PALanson-BCC6.01%$1.9626.09%
QAMC.QAQatar Aluminium Manufacturing Company Q.P.S.C.6.00%$0.1074.36%
0237.HKSafety Godown Company, Limited5.99%$0.1271.07%
8986.TDaiwa Securities Living Investment Corporation5.99%$6,829.9063.32%
ASX.AXASX Limited5.99%$3.0867.16%
MKP.TOMCAN Mortgage Corporation5.99%$1.3574.01%
0QMU.LCompagnie Financière Richemont S.A.5.98%$6.9167.79%
8924.TWOO-TA Precision Industry Co., Ltd.5.98%$4.2980.38%
FMTY14.MXFibra Mty, S.A.P.I. de C.V.5.98%$0.9346.45%
HUMAN.BKHumanica Public Company Limited5.98%$0.3074.76%
603368.SSGuangxi LiuYao Group Co., Ltd5.97%$1.0653.83%
6069.HKSY Holdings Group Limited5.97%$0.6797.72%
ASII.JKPT Astra International Tbk5.97%$405.7550.28%
PXT.TOParex Resources Inc.5.97%$1.1286.22%
SBSafe Bulkers, Inc.5.97%$0.2964.01%
1562.KLSports Toto Berhad5.96%$0.0849.23%
8442.TWWW Holding Inc.5.96%$4.1972.79%
NTV.BKNonthavej Hospital Public Company Limited5.96%$1.3766.11%
WLE.AXWAM Leaders Limited5.96%$0.088.04%
094280.KSHyosung ITX Co. Ltd.5.95%$751.7670.97%
O3P.DEÖsterreichische Post AG5.95%$1.8898.14%
PWO.DEPWO AG5.95%$1.7548.89%
0898.HKMultifield International Holdings Limited5.94%$0.069.32%
1155.KLMalayan Banking Berhad5.94%$0.6272.18%
PORT3.SAWilson Sons S.A.5.94%$1.1173.49%
009680.KSMotonic Corporation5.93%$599.0842.49%
3010.SRArabian Cement Company5.93%$1.2991.83%
PGW.NZPGG Wrightson Limited5.93%$0.1370.38%
0GX2.LNeurones S.A.5.92%$2.4961.25%
4012.SRThob Al Aseel Company5.92%$0.2089.05%
9585.SRMulkia Investment Co.5.92%$2.0137.97%
HEN.DEHenkel AG & Co. KGaA5.92%$3.8741.88%
KKP.BKKiatnakin Phatra Bank Public Company Limited5.92%$4.0263.80%
030000.KSCheil Worldwide Inc.5.91%$1,232.9368.46%
0RCW.LKid ASA5.91%$8.0099.60%
ARSA.MEArsagera Asset Management5.91%$0.5052.65%
DBM.TODoman Building Materials Group Ltd.5.91%$0.5665.99%
DU.AEEmirates Integrated Telecommunications Company PJSC5.91%$0.5895.05%
NXR-UN.TONexus Industrial REIT5.91%$0.4757.77%