Grufity logoGrufity logo

HD

319.96USD+2.51(+0.79%)Delayedas of 07 Dec 2022, 10:16 am

Home Depot Inc

Market Summary

USD319.96+2.51Delayedas of 07 Dec 2022, 10:16 am
0.79%

HD Alerts

HD Stock Price

RSI Chart

Valuation

Market Cap

305.7B

Price/Earnings

18.11

Price/Sales

1.97

Price/Cashflow

22.15

MarketCap/EBT

13.67

Price/Sales

Profitability

Operating Margin

33.53%

EBT Margin

14.40%

Return on Equity

7.1K%

Return on Assets

22.27%

Fundamentals

Revenue

Revenue Y/Y

5.57%

Revenue Q/Q

-11.23%

Earnings

Earnings (TTM)

17.1B

Earnings Y/Y

5.09%

Earnings Q/Q

-16.12%

Price Action

52 Week Range

262.80412.02
(Low)(High)

Last 7 days

1.1%

Last 30 days

11.8%

Last 90 days

6.7%

Trailing 12 Months

-22.2%

Financial Health

Current Ratio

1.18

Debt/Equity

165.7

Debt/Cashflow

0.35

Investor Care

Dividend Yield

2.38%

Dividend/Share (TTM)

7.1

Diluted EPS (TTM)

16.6

Peers (Alternatives to Home Depot)

View All Peers In Detail
NameMkt Capsorted ascendingRevenuePrice %, 1MReturns, 1YP/EP/SRev 1-YrInc 1-Yr
LARGE-CAP
305.7B
-
11.77% -22.18%
18.11
1.97
7.50% 7.26%
123.4B
96.0B
10.85% -18.12%
14.64
1.29
0.77% -18.59%
24.8B
13.3B
5.57% -2.78%
24.06
1.87
11.67% 17.26%
10.2B
33.7B
4.46% -54.61%
10.5
0.3
29.33% -30.83%
MID-CAP
8.0B
27.1B
14.59% 23.90%
5.73
0.29
8.09% 29.40%
7.9B
3.9B
3.65% -43.45%
28.59
2.03
28.13% -2.57%
7.6B
22.8B
-5.93% 51.65%
11.46
0.33
47.83% 90.20%
5.6B
27.6B
14.14% -22.37%
4.33
0.2
34.63% 35.29%
5.5B
26.9B
13.05% -3.67%
3.75
0.21
7.28% 29.95%
SMALL-CAP
1.2B
7.1B
-4.48% -37.60%
4.99
0.17
5.91% -25.67%
952.4M
10.2B
-11.50% -11.12%
8.26
0.1
55.09% 227.82%
437.6M
1.3B
9.86% -33.39%
4.69
0.34
26.30% -10.40%
238.5M
1.1B
-10.81% -60.10%
9.22
0.21
-3.35% -78.69%
199.4M
314.3M
101.45% -54.88%
-1.41
0.55
-20.20% -930.87%
92.2M
-
64.08% -52.53%
1.2K
0.29
- -

Financials for Home Depot

Income Statement (Last 12 Months)
(In Millions)
Description(%) Q/Q2022Q42022Q32022Q22022Q12021Q4
RevenueNaN%nullnullnullnullnull
Cost Of Revenue1.3%104,577103,186101,330100,32597,898
Gross Profit1.3%52,71452,05351,23550,83249,801
Operating Expenses1.1%28,60228,29428,04727,79227,503
  S&GA Expenses1.2%26,16625,86625,64225,40625,162
Earnings Before Taxes1.2%22,63522,36221,84921,73720,991
Net Income1.2%17,09516,88516,51916,43315,938
* denotes actual numbers (not divided by Millions)
Balance Sheet
(In Millions)
Description(%) Q/Q2022Q42022Q32022Q22022Q12021Q4
Assets1.4%76,86675,82576,56771,87673,031
  Current Assets2.2%33,68132,94133,86729,05530,466
    Cash Equivalents95.6%2,4621,2592,8442,3435,067
  Inventory-1.4%25,71926,08825,29722,06820,582
  Net PPE0.0%25,24025,24725,16625,19924,935
  Goodwill-0.2%7,4347,4517,4507,4497,445
Liabilities0.0%75,56875,58878,27673,57271,996
  Current Liabilities-12.8%24,28027,83430,38728,69326,903
  Long Term Debt6.3%41,74039,27139,15836,60436,712
Shareholder's Equity447.7%1,298237-1,696.001,035-
  Retained Earnings3.3%75,46773,07469,84967,58065,951
  Additional Paid-In Capital0.6%12,38512,30912,07912,13211,889
Shares Outstanding-1,035----
* denotes actual numbers (not divided by Millions)
Cashflow (Last 12 Months)
(In Millions)
Description(%) Q/Q2022Q42022Q32022Q22022Q12021Q4
Cashflow From Operations-4.3%13,20613,80614,05016,57114,810
Cashflow From Investing-3.7%-3,082.00-2,972.00-3,142.00-2,969.00-10,851.00
Cashflow From Financing10.8%-12,558.00-14,084.00-14,629.00-19,120.00-13,667.00
  Dividend Payments2.8%7,5777,3697,1726,9856,878
  Buy Backs-19.3%9,57111,86613,32914,80910,374

Risks

What is the probability of a big loss on HD?

52.7%


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

30.8%


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.

Returns

Cumulative Returns on HD

19.9%


10-Year Cumulative Returns

15.7%


7-Year Cumulative Returns

14.3%


5-Year Cumulative Returns

16.4%


3-Year Cumulative Returns

What are the long-term rolling returns for HD?

FIve years rolling returns for Home Depot.

Which funds bought or sold HD recently?

View All Details
Datesorted ascendingFund NameType% Chg$ Change$ Held% Portfolio
2022-11-29
AWM CAPITAL, LLC
NEW
-
205,000
205,000
0.07%
2022-11-29
SALEM CAPITAL MANAGEMENT INC
UNCHANGED
-
6,000
1,055,000
0.84%
2022-11-23
Eagle Bay Advisors LLC
REDUCED
-4.89
-27,084
623,000
0.38%
2022-11-23
CLIENT 1ST ADVISORY GROUP, LLC
NEW
-
200,000
200,000
0.12%
2022-11-23
FSB PREMIER WEALTH MANAGEMENT, INC.
REDUCED
-3.58
-36,000
1,165,000
0.68%
2022-11-23
Invst, LLC
ADDED
2.3
-128,000
1,635,000
0.28%
2022-11-23
Toroso Investments, LLC
ADDED
0.75
108,000
8,058,000
0.34%
2022-11-23
Gould Capital, LLC
UNCHANGED
-
-
15,000
0.01%
2022-11-22
IHT Wealth Management, LLC
ADDED
33.91
1,277,000
4,954,000
0.38%
2022-11-22
B. Riley Wealth Advisors, Inc.
ADDED
58.24
10,723,000
28,835,000
0.87%

1–10 of 47

Latest Funds Activity

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

Home Depot News

MarketWatch

Merck, American Express share gains lead Dow's nearly 50-point climb.11 minutes ago

The Motley Fool

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

256.72

-19.76%

347.14

8.49%

438.34

37.00%

593.39

85.46%

744.42

132.66%

Current Inflation

232.12

-27.45%

307.77

-3.81%

381.92

19.36%

512.54

60.19%

637.85

99.35%

Very High Inflation

202.18

-36.81%

261.15

-18.38%

316.59

-1.05%

419.75

31.19%

516.68

61.48%

Historical Home Depot Fair Value Estimates


Recent SEC filings of Home Depot

View All Filings
Date Filed Form Type Document
Nov 22, 2022
10-Q
Quarterly Report
Nov 18, 2022
4
Insider Trading
Nov 18, 2022
4
Insider Trading
Nov 18, 2022
4
Insider Trading
Nov 18, 2022
4
Insider Trading
Nov 18, 2022
4
Insider Trading
Nov 18, 2022
4
Insider Trading
Nov 18, 2022
4
Insider Trading
Nov 15, 2022
8-K
Current Report
Sep 27, 2022
4
Insider Trading

Latest Insider Trading transactions for HD

Filter Transactions
Datesorted ascendingNameBuy/Sell$ ValueAvg. Price# SharesTitle
2022-11-29
Hourigan Timothy A.
GIFTED
-
-
-300
EVP - Human Resources
2022-11-18
KINNAIRD JEFFREY G
ACQUIRED
868,079
135.574
6,403
EVP - Merchandising
2022-11-18
KINNAIRD JEFFREY G
SOLD
-1,995,500
311.65
-6,403
EVP - Merchandising
2022-11-17
Campbell Ann Marie
SOLD
-71,481.7
310.79
-230
EVP - U.S. Stores & Int'l Ops
2022-11-17
Siddiqui Fahim
SOLD
-622,580
311.29
-2,000
EVP and CIO
2022-11-16
Decker Edward P.
SOLD
-13,873,800
314.756
-44,078
Chair, President and CEO
2022-11-16
Roseborough Teresa Wynn
SOLD
-1,558,600
311.72
-5,000
EVP, Gen. Counsel & Corp. Sec.
2022-11-16
Carey Matt
SOLD
-3,007,320
315.63
-9,528
EVP, Customer Experience
2022-11-16
Decker Edward P.
ACQUIRED
3,690,280
83.7215
44,078
Chair, President and CEO
2022-11-16
Santilli Paula
BOUGHT
499,911
315.8
1,583
-

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

2022-10-30
Consolidated Statements of Earnings (Unaudited) - USD ($)
shares in Millions, $ in Millions
3 Months Ended9 Months Ended
Oct. 30, 2022
Oct. 31, 2021
Oct. 30, 2022
Oct. 31, 2021
Income Statement [Abstract]    
Net sales$ 38,872$ 36,820$ 121,572$ 115,438
Cost of sales25,64824,25780,72076,468
Gross profit13,22412,56340,85238,970
Operating expenses:    
Selling, general and administrative6,4686,16819,73518,975
Depreciation and amortization6086001,8301,780
Total operating expenses7,0766,76821,56520,755
Operating income6,1485,79519,28718,215
Interest and other (income) expense:    
Interest income and other, net(7)(15)(12)(26)
Interest expense4133411,1661,006
Interest and other, net4063261,154980
Earnings before provision for income taxes5,7425,46918,13317,235
Provision for income taxes1,4031,3404,3904,154
Net earnings$ 4,339$ 4,129$ 13,743$ 13,081
Basic weighted average common shares (in shares)1,0201,0491,0241,059
Basic earnings per share (in dollars per share)$ 4.25$ 3.94$ 13.42$ 12.35
Diluted weighted average common shares (in shares)1,0231,0531,0281,063
Diluted earnings per share (in dollars per share)$ 4.24$ 3.92$ 13.37$ 12.31

HD Balance Sheet

2022-10-30
Consolidated Balance Sheets (Unaudited) - USD ($)
$ in Millions
Oct. 30, 2022
Jan. 30, 2022
Current assets:  
Cash and cash equivalents$ 2,462$ 2,343
Receivables, net3,7323,426
Merchandise inventories25,71922,068
Other current assets1,7681,218
Total current assets33,68129,055
Net property and equipment25,24025,199
Operating lease right-of-use assets6,5235,968
Goodwill7,4347,449
Other assets3,9884,205
Total assets76,86671,876
Current liabilities:  
Short-term debt01,035
Accounts payable12,40213,462
Accrued salaries and related expenses1,9342,426
Sales taxes payable640848
Deferred revenue3,1733,596
Current installments of long-term debt1,2242,447
Current operating lease liabilities942830
Other accrued expenses3,9654,049
Total current liabilities24,28028,693
Long-term debt, excluding current installments41,74036,604
Long-term operating lease liabilities5,8075,353
Other long-term liabilities3,7412,922
Total liabilities75,56873,572
Common stock, par value $0.05; authorized: 10,000 shares; issued: 1,793 shares at October 30, 2022 and 1,792 shares at January 30, 2022; outstanding: 1,020 shares at October 30, 2022 and 1,035 shares at January 30, 20229090
Paid-in capital12,38512,132
Retained earnings75,46767,580
Accumulated other comprehensive loss(856)(704)
Treasury stock, at cost, 773 shares at October 30, 2022 and 757 shares at January 30, 2022(85,788)(80,794)
Total stockholders’ equity (deficit)1,298(1,696)
Total liabilities and stockholders’ equity$ 76,866$ 71,876