Home Depot Inc Stock Research

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

Name	Mkt Capsorted ascending	Revenue	Price %, 1M	Returns, 1Y	P/E	P/S	Rev 1-Yr	Inc 1-Yr
LARGE-CAP
HD	287.0B	157.4B	-4.39%	-9.20%	16.78	1.82	4.13%	4.09%
LOW	116.7B	96.0B	-5.39%	-12.23%	17.45	1.22	0.77%	-18.59%
TSCO	24.9B	14.2B	-3.44%	-1.27%	22.89	1.75	11.57%	9.19%
FND	10.7B	4.3B	4.02%	-2.04%	38.26	2.58	24.20%	5.28%
KMX	9.0B	31.6B	-16.80%	-42.31%	15.67	0.28	7.73%	-52.09%
MID-CAP
PAG	9.2B	27.8B	-8.85%	32.09%	6.68	0.33	8.84%	16.18%
AN	6.0B	27.0B	-12.48%	8.27%	4.34	0.22	4.41%	0.32%
LAD	5.8B	28.2B	-14.95%	-35.03%	4.61	0.2	23.46%	18.01%
MUSA	5.8B	23.4B	-8.18%	32.99%	8.57	0.25	35.05%	69.54%
SMALL-CAP
TA	1.3B	10.8B	2.38%	96.17%	7.93	0.12	47.82%	180.33%
CWH	818.3M	7.0B	-17.42%	-31.75%	5.98	0.12	0.77%	-50.82%
CRMT	471.0M	1.3B	-15.53%	-14.59%	7.56	0.35	25.02%	-44.81%
GRWG	204.5M	314.3M	-21.86%	-63.95%	-1.34	0.65	-20.20%	-930.89%
LL	100.1M	1.1B	-33.78%	-77.26%	-8.29	0.09	-3.62%	-128.97%
LMPX	92.2M	-	64.08%	-52.53%	1.2K	0.29	-	-

Financials for Home Depot

* denotes actual numbers (not divided by Millions)
Income Statement (Last 12 Months)					(In Millions)
Description	(%) Q/Q	2023Q1	2022Q4	2022Q3	2022Q2	2022Q1
Revenue	0.1%	157,403	157,291	155,239	152,565	151,157
Cost Of Revenue	0.0%	104,625	104,577	103,186	101,330	100,325
Gross Profit	0.1%	52,778	52,714	52,053	51,235	50,832
Operating Expenses	0.5%	28,739	28,602	28,294	28,047	27,792
S&GA Expenses	0.5%	26,284	26,166	25,866	25,642	25,406
EBITDA	1.3%	26,578	26,225	25,634	-	-
EBITDA Margin	0.0%	0.17*	0.17*	0.17*	-	-
Earnings Before Taxes	-0.7%	22,477	22,635	22,362	21,849	21,737
EBT Margin	-0.1%	0.14*	0.14*	0.14*	-	-
Interest Expenses	7.3%	1,617	1,507	1,435	1,380	1,347
Net Income	0.1%	17,105	17,095	16,885	16,519	16,433
Net Income Margin	-0.1%	0.11*	0.11*	0.11*	-	-
Free Cahsflow	-4.3%	13,206	13,806	14,050	-	-

* denotes actual numbers (not divided by Millions)
Balance Sheet					(In Millions)
Description	(%) Q/Q	2023Q1	2022Q4	2022Q3	2022Q2	2022Q1
Assets	-0.5%	76,445	76,866	75,825	76,567	71,876
Current Assets	-3.6%	32,471	33,681	32,941	33,867	29,055
Cash Equivalents	12.0%	2,757	2,462	1,259	2,844	2,343
Inventory	-3.2%	24,886	25,719	26,088	25,297	22,068
Net PPE	1.5%	25,631	25,240	25,247	25,166	25,199
Goodwill	0.1%	7,444	7,434	7,451	7,450	7,449
Liabilities	-0.9%	74,883	75,568	75,588	78,276	73,572
Current Liabilities	-4.8%	23,110	24,280	27,834	30,387	28,693
Long Term Debt	0.5%	41,962	41,740	39,271	39,158	36,604
Shareholder's Equity	20.3%	1,562	1,298	237	-1,696	-
Retained Earnings	1.9%	76,896	75,467	73,074	69,849	67,580
Additional Paid-In Capital	1.7%	12,592	12,385	12,309	12,079	12,132
Shares Outstanding	-0.4%	1,016	1,020	1,024	1,029	1,035

Cashflow (Last 12 Months)					(In Millions)
Description	(%) Q/Q	2023Q1	2022Q4	2022Q3	2022Q2	2022Q1
Cashflow From Operations	10.7%	14,615	13,206	13,806	14,050	16,571
Share Based Compensation	-1.9%	366	373	369	368	399
Cashflow From Investing	-1.9%	-3,140	-3,082	-2,972	-3,142	-2,969
Cashflow From Financing	12.5%	-10,993	-12,558	-14,084	-14,629	-19,120
Dividend Payments	2.8%	7,789	7,577	7,369	7,172	6,985
Buy Backs	-30.0%	6,696	9,571	11,866	13,329	14,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.

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 ascending	Fund Name	Type	% 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%

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

Schedule 13G FIlings of Home Depot

Date Filed	Name of Filer	Percent of Class	No. of Shares	Form 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 Value	Very Pessimistic	Pessimistic	Base Case	Optimistic	Very 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 ascending	Name	Buy/Sell	$ Value	Avg. Price	# Shares	Title
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

About Home Depot

Edward P. Decker

www.homedepot.com

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 sales	104,625	100,325	87,257
Gross profit	52,778	50,832	44,853
Operating expenses:
Selling, general and administrative	26,284	25,406	24,447
Depreciation and amortization	2,455	2,386	2,128
Total operating expenses	28,739	27,792	26,575
Operating income	24,039	23,040	18,278
Interest and other (income) expense:
Interest income and other, net	(55)	(44)	(47)
Interest expense	1,617	1,347	1,347
Interest and other, net	1,562	1,303	1,300
Earnings before provision for income taxes	22,477	21,737	16,978
Provision for income taxes	5,372	5,304	4,112
Net earnings	$ 17,105	$ 16,433	$ 12,866
Basic weighted average common shares (in shares)	1,022	1,054	1,074
Basic earnings per share (in dollars per share)	$ 16.74	$ 15.59	$ 11.98
Diluted weighted average common shares (in shares)	1,025	1,058	1,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, net	3,317	3,426
Merchandise inventories	24,886	22,068
Other current assets	1,511	1,218
Total current assets	32,471	29,055
Net property and equipment	25,631	25,199
Operating lease right-of-use assets	6,941	5,968
Goodwill	7,444	7,449
Other assets	3,958	4,205
Total assets	76,445	71,876
Current liabilities:
Short-term debt	0	1,035
Accounts payable	11,443	13,462
Accrued salaries and related expenses	1,991	2,426
Sales taxes payable	528	848
Deferred revenue	3,064	3,596
Income taxes payable	50	158
Current installments of long-term debt	1,231	2,447
Current operating lease liabilities	945	830
Other accrued expenses	3,858	3,891
Total current liabilities	23,110	28,693
Long-term debt, excluding current installments	41,962	36,604
Long-term operating lease liabilities	6,226	5,353
Deferred income taxes	1,019	909
Other long-term liabilities	2,566	2,013
Total liabilities	74,883	73,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, 2022	90	90
Paid-in capital	12,592	12,132
Retained earnings	76,896	67,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