Home MarketXLS
Dashboard MarketXLS
Screener MarketXLS
Options Profit Calculator MarketXLS
Stock Ranks MarketXLS
Spreadsheet Builder MarketXLS
Documentation MarketXLS
Logout MarketXLS

HD Stock Annual Income Statement. Download in Excel

Home Depot Inc. (The) logo

Home Depot Inc. (The)

Sector: Consumer Cyclical   

Industry: Home Improvement Stores

354.66
 
USD
  
-8.50
  
(-2.34%)
Previous close: 363.16  Open: 360.0  Bid: 354.32  Ask: 355.48
52 week range    
326.31   
   439.37
Mkt Cap: 366,044 M  Avg Vol (90 Days): 3,472,457
Last updated: Monday 16th June 2025

Stock Rankings

56
MarketXLS Rank
80
Value
30
Technical
60
Quality
How are these ranks calculated?
Financials

HD Income Statement

Annual
Jan-16Jan-17Jan-18Jan-19Jan-20Jan-21Jan-22Jan-23Jan-24Jan-25
AcquiredInProcessRnDIncome16,978 M
Amortization of intangibles2,093 M2,275 M2,252 M2,254 M7,126 M7,449 M7,444 M
Basic EPS from continuing operations5.496.477.339.7810.2911.9815.5916.7415.1614.96
Basic EPS total5.496.477.339.7810.2911.9815.5916.7415.1614.96
Basic weighted shares outstanding1,277 M1,229 M1,178 M1,137 M1,093 M1,074 M1,054 M1,022 M999 M990 M
CommissionExpenses72,653 M
Cost of sales58,254 M62,282 M66,548 M71,043 M72,653 M87,257 M100,325 M104,625 M101,709 M106,206 M
Depreciation1,690 M1,754 M1,811 M1,870 M1,989 M2,128 M2,386 M2,455 M2,673 M3,034 M
Depreciation unreconciled1,690 M1,754 M1,811 M1,870 M1,989 M2,128 M2,386 M2,455 M2,673 M3,034 M
DepreciationAndAmortization1,690 M1,754 M1,811 M1,870 M1,989 M2,128 M2,386 M2,455 M2,673 M3,034 M
Diluted EPS total5.466.457.299.7310.2511.9415.5316.6915.1114.91
Diluted normalized net income/share5.466.457.299.7310.2511.9415.5316.6915.1114.91
Diluted weighted shares outstanding1,283 M1,234 M1,184 M1,143 M1,097 M1,078 M1,058 M1,025 M1,002 M993 M
Dividends paid per share2.362.763.564.125.446.06.67.68.369.0
GainOnSaleOfSecurity14,715 M
GeneralAndAdministrativeExpense16,801 M17,132 M17,864 M19,513 M19,740 M24,447 M25,406 M26,284 M26,598 M28,748 M
Gross operating profit30,265 M32,313 M34,356 M37,160 M37,572 M44,853 M50,832 M52,778 M50,960 M53,308 M
ImpairmentOfCapitalAssets72,653 M
Income before tax11,021 M12,491 M13,698 M14,556 M14,715 M16,978 M21,737 M22,477 M19,924 M19,406 M
Income restructuring and M&A87,257 M
Income taxes4,012 M4,534 M5,068 M3,435 M3,473 M4,112 M5,304 M5,372 M4,781 M4,600 M
Interest income14,556 M178 M201 M
InterestExpenseNonOperating919 M972 M1,057 M72,094 M1,201 M1,347 M1,347 M1,617 M1,943 M2,321 M
InterestExpenseOperating66,548 M
MiscOtherSpecialCharges-166 M-36 M-74 M-93 M-73 M-47 M-44 M55 M
Net income from total operations7,009 M7,957 M8,630 M11,121 M11,242 M12,866 M16,433 M17,105 M15,143 M14,806 M
NetIncomeCommonStockholders6,677 M7,885 M22,180 M25,491 M25,811 M12,772 M16,433 M17,105 M15,143 M14,806 M
NetIncomeContinuousOperations7,009 M7,957 M8,630 M11,121 M11,242 M12,866 M16,433 M17,105 M15,143 M14,806 M
NetNonOperatingInterestIncomeExpense-919 M-972 M12,641 M-57,538 M-1,201 M-1,347 M1,303 M1,562 M-126 M-118 M
Normalized income7,164 M8,119 M8,904 M11,746 M100,670 M
Operating income11,774 M13,427 M14,681 M15,530 M15,843 M18,278 M23,040 M24,039 M21,689 M21,526 M
Operating income before depreciation (EBITDA)13,803 M15,436 M83,365 M88,802 M18,212 M20,844 M25,946 M24,094 M25,114 M25,488 M
OperatingExpense18,491 M18,886 M19,675 M21,630 M21,729 M26,575 M27,792 M28,739 M29,271 M31,782 M
Other income net166 M36 M74 M340 M-14,642 M87,304 M-35 M1000000.0-1000000.0
OtherGandA16,801 M17,132 M17,864 M19,513 M19,740 M24,447 M25,406 M26,284 M26,598 M28,748 M
OtherImpairmentOfCapitalAssets247 M
OtherOperatingExpenses-169 M-147 M-74 M16 M-96 M-75 M-80 M-75 M
OtherWriteDown66,548 M87,257 M
PromotionAndAdvertising868 M955 M995 M1,156 M1,186 M909 M1,044 M1,100 M
RealizedCapitalGain14,715 M
RentAndLandingFees922 M984 M1,053 M1,091 M
Research & development expense100,325 M
ResearchExpense100,325 M
RestructringAndMnAIncome87,257 M
Revenue per share2,102 M2,093 M2,275 M2,252 M2,340 M7,293 M7,699 M7,726 M8,759 M19,803 M
SalariesAndWages244 M267 M273 M282 M-49 M-58 M-86 M-73 M
Selling Gen & administrative expense16,801 M17,132 M17,864 M19,513 M92,393 M24,447 M25,406 M26,284 M26,598 M28,748 M
SellingAndMarketingExpense868 M955 M995 M1,156 M72,653 M909 M1,044 M1,100 M1,100 M1,200 M
Special income/charges-71,043 M-72,653 M-87,257 M
Total Income available for interest expense (EBIT)11,940 M13,463 M81,303 M86,650 M15,916 M18,325 M23,084 M24,094 M21,867 M21,727 M
Total common shares outstanding1,253 M1,203 M1,157 M1,104 M1,075 M1,077 M1,033 M1,015 M991 M994 M
Total net income7,009 M7,957 M8,630 M11,121 M11,242 M12,866 M16,433 M17,105 M15,143 M14,806 M
Total ordinary shares994 M994 M994 M994 M994 M994 M994 M994 M994 M994 M
Total revenues88,519 M94,595 M100,904 M108,203 M110,225 M132,110 M151,157 M157,403 M152,669 M159,514 M
TotalExpenses76,745 M81,168 M86,223 M92,673 M94,382 M113,832 M128,117 M133,364 M130,980 M137,988 M
TotalRevenue88,519 M94,595 M100,904 M108,203 M110,225 M132,110 M151,157 M157,403 M152,669 M159,514 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 provides all the tools I need for in-depth stock analysis. It's user-friendly and constantly improving. A must-have for serious investors.

John D.

Financial Analyst

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...

Kirubakaran K.

Investment Professional

MarketXLS is a powerful tool for financial modeling. It integrates seamlessly with Excel and provides real-time data.

David L.

Financial Analyst

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

Lloyd L.

Professional Trader