HD
NYEHome Depot Inc. (The)
Consumer Cyclical•Home Improvement Stores
Watchlists:
Last updated: Tuesday 15th July 2025
365.20
-4.84 (-1.31%)
Prev Close:370.11
Open:369.975
Bid:365.06
Ask:366.5
52 Week Range
326.31439.37
Volume:3,322,979
Mkt Cap:365,636 M
62
MarketXLS Rank ®
Buy
Price Target
$419.98
+15.0%
Metrics
Valuation
24.96
Range data not available
Returns
0.67%
4.68%
4.52%
5.09%
35.82%
60.93%
-4.85%
Growth
EPS
QoQ
N/A
YoY
N/A
Revenue
QoQ
N/A
YoY
N/A
Free Cash Flow
QoQ
N/A
YoY
N/A
Peers
Risk
Risk Metrics
Financial Scores
-1.01
6.19
Dividends
Dividend Metrics
Dividend Yields
Dividend Dates
6/5/2025
3/27/2025
Analyst Estimates
EPS Estimates
Target Prices
Growth Estimates
Financial Health
Cash Metrics
Liquidity Ratios
1.10
0.20
Debt Metrics
Other Metrics
Financial Scores
3.0
Technicals
Technical Oscillators
Moving Averages
Volatility Metrics
Profitability
Return Ratios
Margin Ratios
Financial Scores
Financials
Financial Statements
HD - Income Statement (Annual)
| Jan-25 | Jan-24 | Jan-23 | Jan-22 | Jan-21 | Jan-20 | Jan-19 | Jan-18 | Jan-17 | Jan-16 | |
|---|---|---|---|---|---|---|---|---|---|---|
| Acquired In Process Rn D Income | 16,978 M | |||||||||
| Commission Expenses | 72,653 M | |||||||||
| Depreciation And Amortization | 3,034 M | 2,673 M | 2,455 M | 2,386 M | 2,128 M | 1,989 M | 1,870 M | 1,811 M | 1,754 M | 1,690 M |
| Gain On Sale Of Security | 14,715 M | |||||||||
| General And Administrative Expense | 28,748 M | 26,598 M | 26,284 M | 25,406 M | 24,447 M | 19,740 M | 19,513 M | 17,864 M | 17,132 M | 16,801 M |
| Gross Profit Margin (profit Margin After CGS) | 53,308 M | 50,960 M | 52,778 M | 50,832 M | 44,853 M | 37,572 M | 37,160 M | 34,356 M | 32,313 M | 30,265 M |
| Impairment Of Capital Assets | 72,653 M | |||||||||
| Interest Expense Non Operating | 2,321 M | 1,943 M | 1,617 M | 1,347 M | 1,347 M | 1,201 M | 72,094 M | 1,057 M | 972 M | 919 M |
| Interest Expense Operating | 66,548 M | |||||||||
| Misc Other Special Charges | 55 M | -44 M | -47 M | -73 M | -93 M | -74 M | -36 M | -166 M | ||
| Net Income (loss) | 14,806 M | 15,143 M | 17,105 M | 16,433 M | 12,866 M | 11,242 M | 11,121 M | 8,630 M | 7,957 M | 7,009 M |
| Net Income Common Stockholders | 14,806 M | 15,143 M | 17,105 M | 16,433 M | 12,772 M | 25,811 M | 25,491 M | 22,180 M | 7,885 M | 6,677 M |
| Net Income Continuous Operations | 14,806 M | 15,143 M | 17,105 M | 16,433 M | 12,866 M | 11,242 M | 11,121 M | 8,630 M | 7,957 M | 7,009 M |
| Net Non Operating Interest Income Expense | -118 M | -126 M | 1,562 M | 1,303 M | -1,347 M | -1,201 M | -57,538 M | 12,641 M | -972 M | -919 M |
| Normalized Income | 100,670 M | 11,746 M | 8,904 M | 8,119 M | 7,164 M | |||||
| Operating Income | 21,526 M | 21,689 M | 24,039 M | 23,040 M | 18,278 M | 15,843 M | 15,530 M | 14,681 M | 13,427 M | 11,774 M |
| Operating Income Before Depreciation (EBITDA) | 25,488 M | 25,114 M | 24,094 M | 25,946 M | 20,844 M | 18,212 M | 88,802 M | 83,365 M | 15,436 M | 13,803 M |
| Operating Expense | 31,782 M | 29,271 M | 28,739 M | 27,792 M | 26,575 M | 21,729 M | 21,630 M | 19,675 M | 18,886 M | 18,491 M |
| Other Gand A | 28,748 M | 26,598 M | 26,284 M | 25,406 M | 24,447 M | 19,740 M | 19,513 M | 17,864 M | 17,132 M | 16,801 M |
| Other Impairment Of Capital Assets | 247 M | |||||||||
| Other Operating Expenses | -75 M | -80 M | -75 M | -96 M | 16 M | -74 M | -147 M | -169 M | ||
| Other Write Down | 87,257 M | 66,548 M | ||||||||
| Promotion And Advertising | 1,100 M | 1,044 M | 909 M | 1,186 M | 1,156 M | 995 M | 955 M | 868 M | ||
| Realized Capital Gain | 14,715 M | |||||||||
| Rent And Landing Fees | 1,091 M | 1,053 M | 984 M | 922 M | ||||||
| Research Expense | 100,325 M | |||||||||
| Restructring And Mn A Income | 87,257 M | |||||||||
| Salaries And Wages | -73 M | -86 M | -58 M | -49 M | 282 M | 273 M | 267 M | 244 M | ||
| Selling And Marketing Expense | 1,200 M | 1,100 M | 1,100 M | 1,044 M | 909 M | 72,653 M | 1,156 M | 995 M | 955 M | 868 M |
| Total Income Available For Interest Expense (EBIT) | 21,727 M | 21,867 M | 24,094 M | 23,084 M | 18,325 M | 15,916 M | 86,650 M | 81,303 M | 13,463 M | 11,940 M |
| Total Revenues | 159,514 M | 152,669 M | 157,403 M | 151,157 M | 132,110 M | 110,225 M | 108,203 M | 100,904 M | 94,595 M | 88,519 M |
| Total Expenses | 137,988 M | 130,980 M | 133,364 M | 128,117 M | 113,832 M | 94,382 M | 92,673 M | 86,223 M | 81,168 M | 76,745 M |
| Total Revenue | 159,514 M | 152,669 M | 157,403 M | 151,157 M | 132,110 M | 110,225 M | 108,203 M | 100,904 M | 94,595 M | 88,519 M |
| Write Off | 71,043 M | |||||||||
| Amord | 19,803 M | 8,759 M | 7,726 M | 7,699 M | 7,293 M | 2,340 M | 2,252 M | 2,275 M | 2,093 M | 2,102 M |
| Avgshs | 990 M | 999 M | 1,022 M | 1,054 M | 1,074 M | 1,093 M | 1,137 M | 1,178 M | 1,229 M | 1,277 M |
| Avgshsdt | 993 M | 1,002 M | 1,025 M | 1,058 M | 1,078 M | 1,097 M | 1,143 M | 1,184 M | 1,234 M | 1,283 M |
| Basiceps | 14.96 | 15.16 | 16.74 | 15.59 | 11.98 | 10.29 | 9.78 | 7.33 | 6.47 | 5.49 |
| Basicepscont | 14.96 | 15.16 | 16.74 | 15.59 | 11.98 | 10.29 | 9.78 | 7.33 | 6.47 | 5.49 |
| Cor | 106,206 M | 101,709 M | 104,625 M | 100,325 M | 87,257 M | 72,653 M | 71,043 M | 66,548 M | 62,282 M | 58,254 M |
| Depamor | 3,034 M | 2,673 M | 2,455 M | 2,386 M | 2,128 M | 1,989 M | 1,870 M | 1,811 M | 1,754 M | 1,690 M |
| Dileps | 14.91 | 15.11 | 16.69 | 15.53 | 11.94 | 10.25 | 9.73 | 7.29 | 6.45 | 5.46 |
| Dilepscont | 14.91 | 15.11 | 16.69 | 15.53 | 11.94 | 10.25 | 9.73 | 7.29 | 6.45 | 5.46 |
| Div Per Share | 9.0 | 8.36 | 7.6 | 6.6 | 6.0 | 5.44 | 4.12 | 3.56 | 2.76 | 2.36 |
| Intinc | 201 M | 178 M | 14,556 M | |||||||
| Netincdisc | 14,806 M | 15,143 M | 17,105 M | 16,433 M | 12,866 M | 11,242 M | 11,121 M | 8,630 M | 7,957 M | 7,009 M |
| Othincexp | -1000000.0 | 1000000.0 | -35 M | 87,304 M | -14,642 M | 340 M | 74 M | 36 M | 166 M | |
| Pretaxinc | 19,406 M | 19,924 M | 22,477 M | 21,737 M | 16,978 M | 14,715 M | 14,556 M | 13,698 M | 12,491 M | 11,021 M |
| Resdev | 100,325 M | |||||||||
| Restruct | 87,257 M | |||||||||
| Sga | 28,748 M | 26,598 M | 26,284 M | 25,406 M | 24,447 M | 92,393 M | 19,513 M | 17,864 M | 17,132 M | 16,801 M |
| Shsout | 994 M | 991 M | 1,015 M | 1,033 M | 1,077 M | 1,075 M | 1,104 M | 1,157 M | 1,203 M | 1,253 M |
| Specincchg | -87,257 M | -72,653 M | -71,043 M | |||||||
| Taxprov | 4,600 M | 4,781 M | 5,372 M | 5,304 M | 4,112 M | 3,473 M | 3,435 M | 5,068 M | 4,534 M | 4,012 M |
Call: 1-877-778-8358 
Welcome! I'm Ankur, the founder and CEO of MarketXLS. With more than ten years of experience, I have assisted over 2,500 customers in developing personalized investment research strategies and monitoring systems using Excel.
I invite you to book a demo with me or my team to save time, enhance your investment research, and streamline your workflows.
I invite you to book a demo with me or my team to save time, enhance your investment research, and streamline your workflows.
Implement "your own" investment strategies in Excel with thousands of MarketXLS functions and templates.
MarketXLS provides all the tools I need for in-depth stock analysis. It's user-friendly and constantly improving. A must-have for serious investors.
I have been using MarketXLS for the last 6+ years and they really enhanced the product every year and now in the journey of bringing in AI...
MarketXLS is a powerful tool for financial modeling. It integrates seamlessly with Excel and provides real-time data.
I have used lots of stock and option information services. This is the only one which gives me what I need inside Excel.