Definitive Analysis
Loading...
Definitive Analysis

Financial Statements

Ticker

Industry

Sector

The Home Depot, Inc. (HD)

Company Dividend Discount ModelIndustry: Home ImprovementSector: Consumer Cyclical

Valuation Snapshot

Stable Growth$402.71 - $1,357.51$658.96
Multi-Stage$270.14 - $294.70$282.20
Blended Fair Value$470.58
Current Price$378.35
Upside24.38%
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 Rate8.57%8.57%8.57%
Growth Rate5.50%6.50%7.50%
Fair Value$402.71$658.96$1,357.51
Upside / Downside6.44%74.17%258.80%

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 Rate8.57%8.57%8.57%
Growth Rate5.50%6.50%7.50%
Year 1 PV (M)9,622.739,713.949,805.15
Year 2 PV (M)10,110.4410,303.0110,497.41
Year 3 PV (M)10,562.8110,866.0311,175.00
Year 4 PV (M)10,981.4611,403.7711,838.15
Year 5 PV (M)11,367.9211,917.0012,487.09
PV of Terminal Value (M)215,876.54226,303.46237,129.44
Equity Value (M)268,521.89280,507.21292,932.23
Shares Outstanding (M)994.00994.00994.00
Fair Value$270.14$282.20$294.70
Upside / Downside-28.60%-25.41%-22.11%

High-Yield Dividend Screener

« Prev Page 75 of 151 Next »
Ticker Company Dividend Yield % Dividend Per Share Payout Ratio %
600283.SSQianjiang Water Resources Development Co., Ltd. Class A1.84%$0.1740.35%
600348.SSShan Xi Huayang Group New Energy Co.,Ltd.1.84%$0.1535.88%
601878.SSZheshang Securities Co., Ltd.1.84%$0.2035.18%
603339.SSSquare Technology Group Co.,Ltd1.84%$0.2445.85%
603351.SSNanjing Well Pharmaceutical Group Co.,Ltd.1.84%$0.4843.82%
603637.SSZhenhai Petrochemical Engineering Co. Ltd.1.84%$0.2051.47%
7160.KLPentamaster Corporation Berhad1.84%$0.0796.65%
E28.SIFrencken Group Limited1.84%$0.0328.64%
LATO-B.STInvestment AB Latour (publ)1.84%$4.0954.81%
0GXK.LVBG Group AB (publ)1.83%$7.2642.89%
3402.TToray Industries, Inc.1.83%$18.6947.76%
603726.SSZhejiang Langdi Group Co., Ltd.1.83%$0.4437.76%
AAG.DEAumann AG1.83%$0.2217.47%
CTPNV.ASCTP N.V.1.83%$0.3212.83%
G92.SIChina Aviation Oil (Singapore) Corporation Ltd1.83%$0.0330.20%
002083.SZSunvim Group Co.,Ltd1.82%$0.2263.82%
002393.SZTianjin Lisheng Pharmaceutical Co.,Ltd.1.82%$0.3926.18%
002906.SZForyou Corporation1.82%$0.5639.04%
008040.KSSajodongaone Co.,Ltd1.82%$19.8511.32%
023810.KSINFAC Corporation1.82%$179.9335.31%
4245.TDaiki Axis Co., Ltd.1.82%$12.3669.20%
4568.TDaiichi Sankyo Company, Limited1.82%$60.9238.27%
601956.SSHubei Donper Electromechanical Group Co., Ltd.1.82%$0.1363.00%
6238.TFURYU Corporation1.82%$19.4627.81%
688819.SSTianneng Battery Group Co., Ltd.1.82%$0.6140.50%
7917.TZACROS Corporation1.82%$21.0323.83%
8905.TAEON Mall Co., Ltd.1.82%$50.0279.78%
GAVA.MXAcosta Verde, S.A.B. de C.V.1.82%$3.2514.81%
H13.SIHo Bee Land Limited1.82%$0.0417.64%
RUG.STRugvista Group AB (publ)1.82%$1.2643.10%
SAMART.BKSamart Corporation Public Company Limited1.82%$0.1021.27%
002946.SZNew Hope Dairy Co., Ltd.1.81%$0.3341.97%
0OFP.ILNCC AB (publ)1.81%$3.9924.59%
2040.SRSaudi Ceramic Company1.81%$0.5086.31%
3260.TWOADATA Technology Co., Ltd.1.81%$5.0746.69%
5235SS.KLKLCC Property Holdings Berhad1.81%$0.1638.48%
5321.TWOUnited Recommend International Co., Ltd.1.81%$0.6783.04%
605088.SSGSP Automotive Group Wenzhou Co.,Ltd.1.81%$0.6542.04%
6271.TWTong Hsing Electronic Industries, Ltd.1.81%$2.4332.14%
6754.TAnritsu Corporation1.81%$40.6757.15%
HEBA-B.STHeba Fastighets AB (publ)1.81%$0.5533.11%
VRG.WAVRG S.A.1.81%$0.0922.39%
002552.SZBaoding Technology Co., Ltd.1.80%$0.3061.55%
002811.SZShenzhen Cheng Chung Design Co., Ltd.1.80%$0.2758.86%
0288.HKWH Group Limited1.80%$0.1682.20%
0YSU.LEpiroc AB (publ)1.80%$3.8053.30%
300272.SZCanature Health Technology Co., Ltd.1.80%$0.1382.69%
600461.SSJiangxi Hongcheng Environment Co.,Ltd.1.80%$0.1722.97%
600794.SSZhang Jia Gang Freetrade Science&Technology Group Co.,Ltd.1.80%$0.0799.64%
605099.SSCoCreation Grass Co., Ltd1.80%$0.6440.62%