Definitive Analysis
Loading...
Definitive Analysis

Financial Statements

Analysis Mode

Ticker

Industry

Sector

The Home Depot, Inc. (HD)

Company Dividend Discount ModelIndustry: Home ImprovementSector: Consumer Cyclical

Valuation Snapshot

Stable Growth$402.72 - $1,357.61$658.98
Multi-Stage$270.15 - $294.70$282.20
Blended Fair Value$470.59
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.72$658.98$1,357.61
Upside / Downside6.44%74.17%258.82%

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.4510,303.0310,497.42
Year 3 PV (M)10,562.8410,866.0611,175.03
Year 4 PV (M)10,981.4911,403.8111,838.19
Year 5 PV (M)11,367.9711,917.0412,487.13
PV of Terminal Value (M)215,880.52226,307.63237,133.81
Equity Value (M)268,526.00280,511.51292,936.74
Shares Outstanding (M)994.00994.00994.00
Fair Value$270.15$282.20$294.70
Upside / Downside-28.60%-25.41%-22.11%

High-Yield Dividend Screener

« Prev Page 61 of 151 Next »
Ticker Company Dividend Yield % Dividend Per Share Payout Ratio %
017810.KSPulmuone Co., Ltd.2.55%$331.6165.57%
023160.KQTae Kwang Corporation2.55%$535.1321.10%
3152.TWOAdvanced Ceramic X Corporation2.55%$3.6636.41%
600415.SSZhejiang China Commodities City Group Co., Ltd.2.55%$0.4153.66%
601808.SSChina Oilfield Services Limited2.55%$0.3643.75%
7606.TUnited Arrows Ltd.2.55%$62.6343.42%
CYRE3.SACyrela Brazil Realty S.A. Empreendimentos e Participações2.55%$0.6112.29%
JUNGH.SWJungheinrich AG2.55%$0.7922.62%
RENT3.SALocaliza Rent a Car S.A.2.55%$1.1166.67%
002380.KSKCC Corporation2.54%$10,000.236.25%
1527.HKZhejiang Tengy Environmental Technology Co., Ltd2.54%$0.054.95%
5212.KLPavilion Real Estate Investment Trust2.54%$0.0539.63%
5489.TWODynaColor, Inc.2.54%$1.0250.42%
600273.SSZhejiang Jiahua Energy Chemical Industry Co.,Ltd.2.54%$0.2228.18%
600724.SSNingbo Fuda Company Limited2.54%$0.1596.79%
7505.TFuso Dentsu Co., Ltd.2.54%$48.5022.36%
8850.TStarts Corporation Inc.2.54%$121.5225.36%
BLAU3.SABlau Farmacêutica S.A.2.54%$0.3519.81%
2367.HKGiant Biogene Holding Co., Ltd.2.53%$0.8722.55%
2701.TWWan Hwa Enterprise Company Ltd.2.53%$0.2852.89%
600963.SSYueyang Forest & Paper Co., Ltd.2.53%$0.1248.95%
603697.SSYouYou Foods Co., Ltd.2.53%$0.3163.16%
CK-R.BKCH. Karnchang Public Company Limited2.53%$0.3025.56%
SCHO.COAktieselskabet Schouw & Co.2.53%$16.8142.51%
003006.SZChongqing Baiya Sanitary Products Co., Ltd.2.52%$0.5580.44%
5191.TSumitomo Riko Company Limited2.52%$66.0123.54%
600406.SSNARI Technology Co., Ltd.2.52%$0.5756.63%
600909.SSHuaan Securities Co., Ltd.2.52%$0.1738.30%
603811.SSZhejiang Cheng Yi Pharmaceutical Co., Ltd.2.52%$0.2637.15%
BESALCO.SNBesalco S.A.2.52%$30.5934.76%
000019.SZShenzhen Cereals Holdings Co., Ltd.2.51%$0.1762.11%
094820.KQIljin Power Co., Ltd.2.51%$320.0148.44%
0QVR.LScandi Standard AB (publ)2.51%$2.4952.58%
4041.TNippon Soda Co., Ltd.2.51%$90.7732.02%
600056.SSChina Meheco Group Co., Ltd.2.51%$0.2671.36%
605169.SSXinjiang Hongtong Natural Gas Co., Ltd.2.51%$0.3391.06%
6691.TWYankey Engineering Co., Ltd.2.51%$13.9262.80%
7483.TDoshisha Co.,Ltd.2.51%$82.9337.87%
GPSC-R.BKGlobal Power Synergy Public Company Limited2.51%$0.9051.48%
HOVE.COHove A/S2.51%$0.1434.71%
NOLA-B.STNolato AB (publ)2.51%$1.5051.20%
0QNH.LHuber+Suhner AG2.50%$3.6149.61%
100840.KSSNT Energy Co., Ltd.2.50%$899.8727.57%
138490.KSKolon Plastics, Inc.2.50%$200.4017.45%
2612.TKadoya Sesame Mills Incorporated2.50%$99.8534.73%
603112.SSShanxi Huaxiang Group Co., Ltd.2.50%$0.4343.19%
603766.SSLoncin Motor Co., Ltd.2.50%$0.4045.87%
ISCTR.ISTürkiye Is Bankasi A.S.2.50%$0.3616.38%
002539.SZChengdu Wintrue Holding Co., Ltd.2.49%$0.2941.75%
2542.TWHighwealth Construction Corp.2.49%$0.9839.34%