Grufity logoGrufity logo

Home Depot Inc Stock Research

HD

282.52USD-0.09(-0.03%)Market Closed

Market Summary

USD282.52-0.09
Market Closed
-0.03%

HD Stock Price

HD RSI Chart

HD Valuation

Market Cap

287.0B

Price/Earnings (Trailing)

16.78

Price/Sales (Trailing)

1.82

EV/EBITDA

12.29

Price/Free Cashflow

19.64

HD Price/Sales (Trailing)

HD Profitability

Operating Margin

33.51%

EBT Margin

14.39%

Return on Equity

1.3K%

Return on Assets

22.24%

Free Cashflow Yield

5.09%

HD Fundamentals

HD Revenue

Revenue (TTM)

157.4B

Revenue Y/Y

0.31%

Revenue Q/Q

-7.82%

HD Earnings

Earnings (TTM)

17.1B

Earnings Y/Y

0.3%

Earnings Q/Q

-22.52%

Price Action

52 Week Range

261.22347.25
(Low)(High)

Last 7 days

-1.5%

Last 30 days

-4.4%

Last 90 days

-11.4%

Trailing 12 Months

-9.2%

HD Financial Health

Current Ratio

1.39

Debt/Equity

32.16

Debt/Cashflow

0.32

HD Investor Care

Dividend Yield

2.38%

Dividend/Share (TTM)

7.1

Buy Backs (1Y)

1.84%

Diluted EPS (TTM)

16.69

Peers (Alternatives to Home Depot)

View All Peers In Detail
NameMkt Capsorted ascendingRevenuePrice %, 1MReturns, 1YP/EP/SRev 1-YrInc 1-Yr
LARGE-CAP
287.0B
157.4B
-4.39% -9.20%
16.78
1.82
4.13% 4.09%
116.7B
96.0B
-5.39% -12.23%
17.45
1.22
0.77% -18.59%
24.9B
14.2B
-3.44% -1.27%
22.89
1.75
11.57% 9.19%
10.7B
4.3B
4.02% -2.04%
38.26
2.58
24.20% 5.28%
9.0B
31.6B
-16.80% -42.31%
15.67
0.28
7.73% -52.09%
MID-CAP
9.2B
27.8B
-8.85% 32.09%
6.68
0.33
8.84% 16.18%
6.0B
27.0B
-12.48% 8.27%
4.34
0.22
4.41% 0.32%
5.8B
28.2B
-14.95% -35.03%
4.61
0.2
23.46% 18.01%
5.8B
23.4B
-8.18% 32.99%
8.57
0.25
35.05% 69.54%
SMALL-CAP
1.3B
10.8B
2.38% 96.17%
7.93
0.12
47.82% 180.33%
818.3M
7.0B
-17.42% -31.75%
5.98
0.12
0.77% -50.82%
471.0M
1.3B
-15.53% -14.59%
7.56
0.35
25.02% -44.81%
204.5M
314.3M
-21.86% -63.95%
-1.34
0.65
-20.20% -930.89%
100.1M
1.1B
-33.78% -77.26%
-8.29
0.09
-3.62% -128.97%
92.2M
-
64.08% -52.53%
1.2K
0.29
- -

Financials for Home Depot

Income Statement (Last 12 Months)
(In Millions)
* denotes actual numbers (not divided by Millions)
Description(%) Q/Q2023Q12022Q42022Q32022Q22022Q1
Revenue0.1%157,403157,291155,239152,565151,157
Cost Of Revenue0.0%104,625104,577103,186101,330100,325
Gross Profit0.1%52,77852,71452,05351,23550,832
Operating Expenses0.5%28,73928,60228,29428,04727,792
  S&GA Expenses0.5%26,28426,16625,86625,64225,406
EBITDA1.3%26,57826,22525,634--
EBITDA Margin0.0%0.17*0.17*0.17*--
Earnings Before Taxes-0.7%22,47722,63522,36221,84921,737
EBT Margin-0.1%0.14*0.14*0.14*--
Interest Expenses7.3%1,6171,5071,4351,3801,347
Net Income0.1%17,10517,09516,88516,51916,433
Net Income Margin-0.1%0.11*0.11*0.11*--
Free Cahsflow-4.3%13,20613,80614,050--
Balance Sheet
(In Millions)
* denotes actual numbers (not divided by Millions)
Description(%) Q/Q2023Q12022Q42022Q32022Q22022Q1
Assets-0.5%76,44576,86675,82576,56771,876
  Current Assets-3.6%32,47133,68132,94133,86729,055
    Cash Equivalents12.0%2,7572,4621,2592,8442,343
  Inventory-3.2%24,88625,71926,08825,29722,068
  Net PPE1.5%25,63125,24025,24725,16625,199
  Goodwill0.1%7,4447,4347,4517,4507,449
Liabilities-0.9%74,88375,56875,58878,27673,572
  Current Liabilities-4.8%23,11024,28027,83430,38728,693
  Long Term Debt0.5%41,96241,74039,27139,15836,604
Shareholder's Equity20.3%1,5621,298237-1,696-
  Retained Earnings1.9%76,89675,46773,07469,84967,580
  Additional Paid-In Capital1.7%12,59212,38512,30912,07912,132
Shares Outstanding-0.4%1,0161,0201,0241,0291,035
Cashflow (Last 12 Months)
(In Millions)
Description(%) Q/Q2023Q12022Q42022Q32022Q22022Q1
Cashflow From Operations10.7%14,61513,20613,80614,05016,571
  Share Based Compensation-1.9%366373369368399
Cashflow From Investing-1.9%-3,140-3,082-2,972-3,142-2,969
Cashflow From Financing12.5%-10,993-12,558-14,084-14,629-19,120
  Dividend Payments2.8%7,7897,5777,3697,1726,985
  Buy Backs-30.0%6,6969,57111,86613,32914,809

Risks for HD

What is the probability of a big loss on HD?

57.7%


Probability that Home Depot stock will be more than 20% underwater in next one year

31.9%


Probability that Home Depot stock will be more than 30% underwater in next one year.

0%


Probability that Home Depot stock will be more than 40% underwater in next one year.
*Calculated based on probability distribution of losses observed in actual data in the last 5 years.

How does HD drawdown profile look like?

Y-axis is the maximum loss one would have experienced if Home Depot was unfortunately bought at previous high price.

Drawdowns

Returns for HD

Cumulative Returns on HD

17.6%


10-Year Cumulative Returns

14.2%


7-Year Cumulative Returns

13.0%


5-Year Cumulative Returns

22.8%


3-Year Cumulative Returns

What are the long-term rolling returns for HD?

FIve years rolling returns for Home Depot.

Annualized Returns

Which funds bought or sold HD recently?

View All Details
Datesorted ascendingFund NameType% Chg$ Change$ Held% Portfolio
2023-03-15
B. Riley Wealth Advisors, Inc.
added
0.03
4,179,970
33,015,000
0.92%
2023-03-14
AWM CAPITAL, LLC
sold off
-100
-205,000
-
-%
2023-03-13
Claro Advisors LLC
added
24.18
664,864
2,210,860
0.72%
2023-03-10
Financial Alternatives, Inc
new
-
1,903,150
1,903,150
1.89%
2023-03-10
MATHER GROUP, LLC.
reduced
-6.15
141,345
2,037,340
0.04%
2023-03-10
VICTORY CAPITAL MANAGEMENT INC
added
6.54
35,388,700
196,554,000
0.22%
2023-03-08
SHEETS SMITH WEALTH MANAGEMENT
added
0.09
45,548
356,548
0.06%
2023-03-08
Capital Asset Advisory Services LLC
added
2.47
687,316
4,391,320
0.35%
2023-03-07
Great Lakes Retirement, Inc.
new
-
747,062
747,062
0.19%
2023-03-07
Nordwand Advisors, LLC
new
-
4,849,400
4,849,400
0.60%

1–10 of 48

Latest Funds Activity

Are funds buying HD calls or puts?
Calls
Puts
Are funds bullish or bearish(Calls - Puts)?
Net Call Options
No. of funds that own HD
No. of Funds

Home Depot News

MarketWatch

Lowe's Cos. stock underperforms Thursday when compared to competitors.

MarketWatch,
4 hours ago

Yahoo Finance

Schedule 13G FIlings of Home Depot

Date FiledName of FilerPercent of ClassNo. of SharesForm Type
Feb 09, 2023
vanguard group inc
9.35%
95,336,930
SC 13G/A
Feb 07, 2023
blackrock inc.
7.5%
76,257,443
SC 13G/A
Feb 10, 2022
vanguard group inc
8.93%
93,202,329
SC 13G/A
Feb 01, 2022
blackrock inc.
6.7%
70,040,522
SC 13G/A
Feb 10, 2021
vanguard group inc
8.33%
89,730,498
SC 13G/A
Feb 05, 2021
blackrock inc.
6.7%
72,153,993
SC 13G/A
Feb 14, 2020
capital world investors
3.6%
39,391,515
SC 13G/A
Feb 12, 2020
vanguard group inc
7.68%
83,857,531
SC 13G/A
Feb 05, 2020
blackrock inc.
6.6%
72,021,860
SC 13G/A

HD Fair Value

Home Depot fair value in different scenarios

The table shows the Fair Value estimates for Home Depot for various scenarios. Disclaimer: These are just estimations from a model. None of the models are good at predicting the future. Please dont buy or sell stocks based on these outputs.
Fair ValueVery PessimisticPessimisticBase CaseOptimisticVery Optimistic
Very Low Inflation

229.84

-18.65%

281.99

-0.19%

385.42

36.42%

552.80

95.67%

679.23

140.42%
Current Inflation

208.98

-26.03%

252.86

-10.50%

339.08

20.02%

479.08

69.57%

583.97

106.70%
Very High Inflation

183.39

-35.09%

217.84

-22.89%

284.73

0.78%

394.13

39.51%

475.21

68.20%

Historical Home Depot Fair Value Estimates


Very Pessimistic Case
Pessimistic Case
Fair Value
Optimistic Case
Very Optimistic Case
Closing Stock Price

Recent SEC filings of Home Depot

View All Filings
Date Filed Form Type Document
Mar 15, 2023
10-K
Annual Report
Mar 15, 2023
4
Insider Trading
Mar 01, 2023
4
Insider Trading
Feb 28, 2023
8-K
Current Report
Feb 24, 2023
4
Insider Trading
Feb 24, 2023
4
Insider Trading
Feb 24, 2023
4
Insider Trading
Feb 24, 2023
4
Insider Trading
Feb 24, 2023
4
Insider Trading
Feb 24, 2023
4
Insider Trading

Latest Insider Trading transactions for HD

Filter Transactions
Datesorted ascendingNameBuy/Sell$ ValueAvg. Price# SharesTitle
2023-03-13
Decker Edward P.
sold (taxes)
-2,662,630
286
-9,293
chair, president and ceo
2023-02-27
Gibbs Stephen L
sold (taxes)
-100,643
296
-340
vp, cao & controller
2023-02-22
Roseborough Teresa Wynn
acquired
-
-
10,540
evp, gen. counsel & corp. sec.
2023-02-22
Padilla Hector A
acquired
-
-
3,659
evp - outside sales & service
2023-02-22
Deaton John A.
sold (taxes)
-381,042
296
-1,286
evp - supply chain & prod. dev
2023-02-22
Decker Edward P.
sold (taxes)
-1,572,170
296
-5,306
chair, president and ceo
2023-02-22
Carey Matt
acquired
-
-
12,882
evp, customer experience
2023-02-22
Deaton John A.
acquired
-
-
3,951
evp - supply chain & prod. dev
2023-02-22
Siddiqui Fahim
acquired
-
-
3,951
evp and cio
2023-02-22
Campbell Ann Marie
sold (taxes)
-1,572,460
296
-5,307
evp - u.s. stores & int'l ops

1–10 of 50

Edward P. Decker
65535
The Home Depot, Inc. operates as a home improvement retailer. It operates The Home Depot stores that sell various building materials, home improvement products, lawn and garden products, and décor products, as well as facilities maintenance, repair, and operations products The company also offers installation services for flooring, cabinets and cabinet makeovers, countertops, furnaces and central air systems, and windows. In addition, it provides tool and equipment rental services. The company primarily serves homeowners; and professional renovators/remodelers, general contractors, maintenance professionals, handymen, property managers, building service contractors, and specialty tradesmen, such as electricians, plumbers, and painters. It also sells its products through websites, including homedepot.com; blinds.com, an online site for custom window coverings; and thecompanystore.com, an online site for textiles and décor products. As of December 31, 2021, the company operated 2,317 stores in the United States. The Home Depot, Inc. was incorporated in 1978 and is based in Atlanta, Georgia.

HD Income Statement

2023-01-29
Consolidated Statements of Earnings - USD ($)
shares in Millions, $ in Millions
12 Months Ended
Jan. 29, 2023
Jan. 30, 2022
Jan. 31, 2021
Income Statement [Abstract]   
Net sales$ 157,403$ 151,157$ 132,110
Cost of sales104,625100,32587,257
Gross profit52,77850,83244,853
Operating expenses:   
Selling, general and administrative26,28425,40624,447
Depreciation and amortization2,4552,3862,128
Total operating expenses28,73927,79226,575
Operating income24,03923,04018,278
Interest and other (income) expense:   
Interest income and other, net(55)(44)(47)
Interest expense1,6171,3471,347
Interest and other, net1,5621,3031,300
Earnings before provision for income taxes22,47721,73716,978
Provision for income taxes5,3725,3044,112
Net earnings$ 17,105$ 16,433$ 12,866
Basic weighted average common shares (in shares)1,0221,0541,074
Basic earnings per share (in dollars per share)$ 16.74$ 15.59$ 11.98
Diluted weighted average common shares (in shares)1,0251,0581,078
Diluted earnings per share (in dollars per share)$ 16.69$ 15.53$ 11.94

HD Balance Sheet

2023-01-29
Consolidated Balance Sheets - USD ($)
$ in Millions
Jan. 29, 2023
Jan. 30, 2022
Current assets:  
Cash and cash equivalents$ 2,757$ 2,343
Receivables, net3,3173,426
Merchandise inventories24,88622,068
Other current assets1,5111,218
Total current assets32,47129,055
Net property and equipment25,63125,199
Operating lease right-of-use assets6,9415,968
Goodwill7,4447,449
Other assets3,9584,205
Total assets76,44571,876
Current liabilities:  
Short-term debt01,035
Accounts payable11,44313,462
Accrued salaries and related expenses1,9912,426
Sales taxes payable528848
Deferred revenue3,0643,596
Income taxes payable50158
Current installments of long-term debt1,2312,447
Current operating lease liabilities945830
Other accrued expenses3,8583,891
Total current liabilities23,11028,693
Long-term debt, excluding current installments41,96236,604
Long-term operating lease liabilities6,2265,353
Deferred income taxes1,019909
Other long-term liabilities2,5662,013
Total liabilities74,88373,572
Commitments and contingencies (Note 11)
Common stock, par value $0.05; authorized: 10,000 shares; issued: 1,794 shares at January 29, 2023 and 1,792 shares at January 30, 2022; outstanding: 1,016 shares at January 29, 2023 and 1,035 shares at January 30, 20229090
Paid-in capital12,59212,132
Retained earnings76,89667,580
Accumulated other comprehensive loss(718)(704)
Treasury stock, at cost, 778 shares at January 29, 2023 and 757 shares at January 30, 2022(87,298)(80,794)
Total stockholders’ equity (deficit)1,562(1,696)
Total liabilities and stockholders’ equity$ 76,445$ 71,876