Home MarketXLS
Dashboard MarketXLS
Screener MarketXLS
Options Profit Calculator MarketXLS
Stock Ranks MarketXLS
Spreadsheet Builder MarketXLS
Documentation MarketXLS
Logout MarketXLS
Home Depot Inc. (The) logo

Home Depot Inc. (The)

Sector: Consumer Cyclical   

Industry: Home Improvement Stores

282.61
 
USD
  
-6.82
  
(-2.36%)
Optionable: Yes  Market Cap: 293,759 M  90-day average vol: 3,670,908

Previous close: 289.43  Open: 290.09  Bid: 284.0  Ask: 284.0
52 week range    
264.51   
   347.25
Peers   
LOW / 
LL / 
Last updated: Thursday 23rd March 2023
53
MarketXLS Rank
80
Value
23
Technical
57
Quality

Get Access to 1 Billion Usable Market data points IN YOUR EXCEL SHEETS WITH EASY TO USE EXCEL FUNCTIONS

Get started today
Search for a stock
Are you?
twitterstocktwits
Metrics

Peers

StockDividendMarket Cap (B)PEPrice ($)

BLDR

13 B9.267.52

LL

0 B6.813.94

LOW

0.014161 B20.6227.02
Financials

HD Income Statement

Annual
Save
Jan-14Jan-15Jan-16Jan-17Jan-18Jan-19Jan-20Jan-21Jan-22Jan-23
Total revenues78,812 M83,176 M88,519 M94,595 M100,904 M108,203 M110,225 M132,110 M151,157 M157,403 M
Cost of sales50,010 M52,855 M56,218 M60,090 M64,235 M68,609 M70,050 M84,347 M96,987 M101,130 M
Gross operating profit27,045 M28,535 M30,438 M32,532 M34,607 M37,442 M37,879 M45,244 M51,308 M53,298 M
Selling Gen & administrative expense16,122 M16,280 M16,801 M17,132 M17,864 M19,513 M19,740 M24,447 M25,406 M26,284 M
Research & development expense0000000000
Operating income9,166 M10,469 M11,774 M13,427 M14,681 M15,777 M15,843 M18,278 M23,040 M24,039 M
floaterest income0000000000
floaterest expense0000000000
Other income net00000-263 M0000
Pre-tax Income (EBT)8,467 M9,976 M11,021 M12,491 M13,698 M14,556 M14,715 M16,978 M21,737 M22,477 M
Income taxes3,082 M3,631 M4,012 M4,534 M5,068 M3,435 M3,473 M4,112 M5,304 M5,372 M
Net income from total operations5,385 M6,345 M7,009 M7,957 M8,630 M11,121 M11,242 M12,866 M16,433 M17,105 M
Minority floaterest0000000000
Total net income5,385 M6,345 M7,009 M7,957 M8,630 M11,121 M11,242 M12,866 M16,433 M17,105 M
Preferred dividendsN/AN/AN/AN/AN/AN/AN/AN/AN/AN/A
Net income available for common5,385 M6,345 M7,009 M7,957 M8,630 M11,121 M11,242 M12,866 M16,433 M17,105 M
Depreciation1,757 M1,786 M1,863 M1,973 M2,062 M2,152 M2,296 M2,519 M2,862 M2,975 M
Amortization0000000000
Operating income before depreciation (EBITDA)10,935 M12,592 M13,803 M15,436 M16,817 M17,759 M18,212 M20,844 M25,946 M27,069 M
Total Income available for floaterest expense (EBIT)0000000000
Basic EPS total3.784.745.496.477.339.7810.2911.9815.5916.74
Diluted EPS total3.764.715.466.457.299.7310.2511.9415.5316.69
Call: 1-877-778-8358
Ankur Mohan MarketXLS
I am so happy you are here. My name is Ankur and I am the founder/CEO of MarketXLS. Over the past four years, I have helped more than 2500 customers to implement their own investment research strategies and monitoring systems in Excel.
Implement “your own” investment strategies in Excel with thousands of MarketXLS functions and starter sheets.
Get started today