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

363.36
 
USD
  
-2.72
  
(-0.74%)
Optionable: Yes  Market Cap: 366,025 M  90-day average vol: 3,471,459

Previous close: 366.08  Open: 366.43  Bid: 363.0  Ask: 363.36
52 week range    
274.26   
   396.87
Last updated: Monday 22nd July 2024
68
MarketXLS Rank
80
Value
69
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

🎉 Exciting news! 🎉

You are invited to join our Discord Channel.

Interact, learn, and grow with experts in the markets!

Join our Discord

Metrics

Peers

StockDividendMarket Cap (B)PEPrice ($)
Financials

HD Income Statement

Annual
Jan-15Jan-16Jan-17Jan-18Jan-19Jan-20Jan-21Jan-22Jan-23Jan-24
AcquiredInProcessRnDIncome16,978 M
Amortization of intangibles1,353 M2,093 M2,275 M2,252 M2,254 M7,126 M7,449 M7,444 M8,455 M
Basic EPS from continuing operations4.746.477.339.7810.2911.9815.5916.7415.16
Basic EPS total4.745.496.477.339.7810.2911.9815.5916.7415.16
Basic weighted shares outstanding1,338 M1,277 M1,229 M1,178 M1,137 M1,093 M1,074 M1,054 M1,022 M999 M
CommissionExpenses72,653 M
Cost of sales54,222 M58,254 M62,282 M66,548 M71,043 M72,653 M87,257 M100,325 M104,625 M101,709 M
Depreciation1,640 M1,690 M1,754 M1,811 M1,870 M1,989 M2,128 M2,386 M2,455 M2,673 M
Depreciation unreconciled1,640 M1,690 M1,754 M1,811 M1,870 M1,989 M2,128 M2,386 M2,455 M2,673 M
DepreciationAndAmortization1,640 M1,690 M1,754 M1,811 M1,870 M1,989 M2,128 M2,386 M2,455 M2,673 M
Diluted EPS total4.715.466.457.299.7310.2511.9415.5316.6915.11
Diluted normalized net income/share4.716.457.299.7310.2511.9415.5316.6915.11
Diluted weighted shares outstanding1,346 M1,283 M1,234 M1,184 M1,143 M1,097 M1,078 M1,058 M1,025 M1,002 M
Dividends paid per share1.882.763.564.125.446.06.67.68.36
GainOnSaleOfSecurity14,715 M
GeneralAndAdministrativeExpense16,280 M-922 M17,132 M17,864 M19,513 M19,740 M24,447 M25,406 M26,284 M26,598 M
Gross operating profit28,389 M30,265 M32,313 M34,356 M37,160 M37,572 M44,853 M50,832 M52,778 M50,960 M
ImpairmentOfCapitalAssets72,653 M
Income before tax9,976 M11,021 M12,491 M13,698 M14,556 M14,715 M16,978 M21,737 M22,477 M19,924 M
Income restructuring and M&A87,257 M
Income taxes3,631 M4,012 M4,534 M5,068 M3,435 M3,473 M4,112 M5,304 M5,372 M4,781 M
Interest income337 M166 M14,556 M
InterestExpenseNonOperating830 M919 M972 M1,057 M72,094 M1,201 M1,347 M1,347 M1,617 M1,943 M
InterestExpenseOperating66,548 M
MiscOtherSpecialCharges-337 M27 M-36 M-74 M-93 M-73 M-47 M-44 M55 M178 M
Net income from total operations6,345 M7,009 M7,957 M8,630 M11,121 M11,242 M12,866 M16,433 M17,105 M15,143 M
NetIncomeCommonStockholders5,671 M7,009 M7,885 M22,180 M25,491 M25,811 M12,772 M16,433 M17,105 M15,143 M
NetIncomeContinuousOperations6,345 M7,009 M7,957 M8,630 M11,121 M11,242 M12,866 M16,433 M17,105 M15,143 M
NetNonOperatingInterestIncomeExpense-830 M-753 M-972 M12,641 M-57,538 M-1,201 M-1,347 M-1,347 M-1,617 M-1,943 M
Normalized income6,484 M8,119 M8,904 M11,746 M100,670 M15,740 M
Operating income10,469 M11,774 M13,427 M14,681 M15,530 M15,843 M18,278 M23,040 M24,039 M21,689 M
Operating income before depreciation (EBITDA)12,592 M13,803 M15,436 M83,365 M88,802 M18,212 M20,844 M25,946 M27,069 M25,114 M
OperatingExpense17,920 M18,491 M18,886 M19,675 M21,630 M21,729 M26,575 M27,792 M28,739 M29,271 M
Other income net337 M-27 M36 M74 M340 M-14,642 M87,304 M44 M-55 M-178 M
OtherGandA16,280 M-922 M17,132 M17,864 M19,513 M19,740 M24,447 M25,406 M26,284 M26,598 M
OtherImpairmentOfCapitalAssets247 M
OtherOperatingExpenses-179 M-169 M-147 M-74 M16 M-96 M-75 M-80 M104,625 M-74 M
OtherWriteDown66,548 M87,257 M
PromotionAndAdvertising884 M-868 M955 M995 M1,156 M1,186 M909 M1,044 M1,100 M1,100 M
RealizedCapitalGain14,715 M
RentAndLandingFees918 M-922 M984 M1,053 M1,091 M
Research & development expense100,325 M
ResearchExpense100,325 M
RestructringAndMnAIncome87,257 M
Revenue per share1,353 M2,093 M2,275 M2,252 M2,340 M7,293 M7,699 M7,726 M8,759 M
SalariesAndWages225 M-244 M267 M273 M282 M-49 M-58 M-86 M-73 M-79 M
Selling Gen & administrative expense16,280 M16,801 M17,132 M17,864 M19,513 M92,393 M24,447 M25,406 M26,284 M26,598 M
SellingAndMarketingExpense884 M16,801 M955 M995 M1,156 M72,653 M909 M1,044 M1,100 M1,100 M
SellingExpense16,834 M16,801 M
Special income/charges-71,043 M-72,653 M-87,257 M
Total Income available for interest expense (EBIT)10,806 M11,940 M13,463 M81,303 M86,650 M15,916 M18,325 M23,084 M24,094 M21,867 M
Total common shares outstanding1,307 M1,253 M1,203 M1,157 M1,104 M1,075 M1,077 M1,033 M1,015 M991 M
Total net income6,345 M7,009 M7,957 M8,630 M11,121 M11,242 M12,866 M16,433 M17,105 M15,143 M
Total ordinary shares992 M992 M992 M992 M992 M992 M992 M992 M992 M992 M
Total revenues83,176 M88,519 M94,595 M100,904 M108,203 M110,225 M132,110 M151,157 M157,403 M152,669 M
TotalExpenses72,707 M76,745 M81,168 M86,223 M92,673 M94,382 M113,832 M128,117 M133,364 M130,980 M
TotalRevenue83,176 M88,519 M94,595 M100,904 M108,203 M110,225 M132,110 M151,157 M157,403 M152,669 M
WriteOff71,043 M
Call: 1-877-778-8358
Ankur Mohan MarketXLS
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.
Implement “your own” investment strategies in Excel with thousands of MarketXLS functions and templates.

MarketXLS is a complete Excel stock solution

Kevin Hsu

StockKevin.com

I have used lots of stock and option information services. This is the only one which gives me what I need inside Excel

Lloyd Lenase

Option Day Trader

MarketXLS is a data junkie’s dream. It gives me the flexibility to mine for hidden treasures.

Dave

Swing trader since 2011

I like to access historical closing prices on a particular date. That makes tracking performance easy.

Patrick Cusatis, Ph.D., CFA

Associate Professor of Finance - Penn State University