Saturday 17 October 2026 Export HD’s income statement to Excel — free account

The Home Depot, Inc.

HD Consumer Cyclical Home Improvement Retail

The Home Depot, Inc.’s revenue for fiscal 2026 (year ended January 2026) was $164.7 billion, up 3.24% from fiscal 2025. In the quarter to July 2026, revenue grew 5.71%, EPS grew 4.36%, free cash flow grew 21.0% and total debt rose 1.11%, each against the same quarter a year earlier. Member of the S&P 500 and Dow Jones; dividend growth for twenty-five consecutive years.

309.32 1.08 +0.35%

Follow HD

Alert me

Market cap: $307.5B
P/E: 21.6×
Fwd P/E: 21.5×
Dividend yield: 3.00%
F-score: 4/9
Altman Z: 5.92
Beneish M: −2.42
Dividend safety: 64/100

Overview Business Profile Financial Analysis Income Statement Balance Sheet Cash Flow Metrics & Ratios Filings 10-Q 10-K

	Jan '17	Jan '18	Jan '19	Jan '20	Jan '21	Jan '22	Jan '23	Jan '24	Jan '25	Jan '26
Piotroski F-Score Full definition →	6	6	7	5	6	6	5	5	5	4
P/E ratio Full definition →	21.20	27.45	18.77	22.17	22.52	23.55	19.38	23.30	27.56	26.50
Altman Z-Score Full definition →	7.12	7.98	7.88	7.37	6.56	7.64	7.31	7.38	6.48	5.92
P/S ratio Full definition →	1.79	2.35	1.93	2.26	2.20	2.56	2.10	2.31	2.56	2.28
Altman Z″-Score (non-manufacturers) Full definition →	5.46	5.58	6.04	5.49	4.97	5.23	6.22	6.15	4.83	4.54
P/FCF ratio Full definition →	20.62	23.25	19.46	22.65	17.71	27.62	28.82	19.65	24.98	29.69
P/Operating CF Full definition →	90.71	103.35	66.69	86.15	203.69	121.44	72.12	74.50	87.32	112.18
Beneish M-Score Full definition →	(2.64)	(2.88)	(2.79)	(2.04)	(2.32)	(2.38)	(2.34)	(2.80)	(2.12)	(2.42)
Dividend Safety Score Full definition →	—	—	—	—	—	—	—	—	—	64
P/B ratio Full definition →	39.02	162.76	0.00	0.00	87.92	0.00	212.10	337.75	61.42	29.30
Price to Tangible BV Full definition →	75.48	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00
EV/Sales Full definition →	2.01	2.58	2.18	2.53	2.42	2.81	2.36	2.57	2.88	2.61
EV/EBITDA Full definition →	12.35	15.53	13.35	15.36	15.36	16.39	13.76	15.76	18.17	17.19
EV/Operating CF Full definition →	19.44	21.62	17.93	20.36	16.95	25.62	25.44	18.56	23.20	26.33
EV/FCF Full definition →	23.19	25.55	22.02	25.31	19.50	30.31	32.34	21.90	28.15	33.99
Quick Ratio Full definition →	0.32	0.34	0.22	0.23	0.47	0.20	0.26	0.32	0.23	0.22
Current Ratio Full definition →	1.25	1.17	1.11	1.08	1.23	1.01	1.41	1.35	1.11	1.06
Net Debt/EBITDA Full definition →	1.37	1.40	1.55	1.62	1.41	1.46	1.50	1.62	2.05	2.17
Debt/Assets Full definition →	54.93%	60.70%	66.36%	61.45%	52.76%	55.77%	56.50%	57.64%	55.54%	53.07%
Debt/Equity Full definition →	5.45	18.59	(15.55)	(10.10)	11.29	(23.64)	27.65	42.25	8.04	4.35
Asset Turnover Full definition →	2.23	2.31	2.44	2.31	2.17	2.12	2.12	2.00	1.85	1.64
Operating CF/Net income Full definition →	1.23	1.39	1.18	1.22	1.46	1.01	0.85	1.40	1.34	1.15
Capex/Depreciation Full definition →	(0.80)	(0.90)	(1.13)	(1.17)	(0.98)	(0.90)	(1.05)	(0.99)	(0.93)	(0.89)
Interest Coverage Full definition →	13.81	13.89	14.78	13.19	13.57	17.10	14.87	11.16	9.27	8.66
ROE Full definition →	149.44%	298.25%	(5,245.75%)	(450.22%)	14,061.20%	2,050.28%	(25,529.85%)	1,162.16%	385.37%	145.54%
ROA Full definition →	18.74%	19.73%	25.12%	23.61%	21.12%	23.07%	23.06%	19.80%	17.15%	14.07%
ROIC Full definition →	33.04%	36.87%	38.00%	37.74%	35.00%	39.95%	35.77%	32.75%	23.05%	19.43%
Return on Tangible Assets Full definition →	31.20%	34.78%	45.98%	46.44%	42.86%	64.29%	48.88%	44.65%	49.81%	47.21%
Average Days of Receivables Full definition →	7.83	7.06	6.53	6.97	8.27	8.27	7.69	7.96	11.22	12.41
Research and Development Expense of Revenue Full definition →	0.00%	0.00%	0.00%	0.00%	0.00%	0.00%	0.00%	0.00%	0.00%	0.00%
Selling, General and Administrative Expense of Revenue Full definition →	18.11%	17.70%	18.03%	17.91%	18.51%	16.81%	16.70%	17.42%	18.02%	18.64%
Intangible Assets out of Total Assets Full definition →	0.05	0.05	0.05	0.04	0.10	0.10	0.10	0.16	0.30	0.31
Share Based Compensation of Revenue Full definition →	0.28%	0.27%	0.26%	0.23%	0.23%	0.26%	0.23%	0.25%	0.28%	0.32%
Graham Net Nets Full definition →	(0.12)	(0.10)	(0.13)	(0.14)	(0.13)	(0.12)	(0.13)	(0.13)	(0.14)	(0.15)
Graham Number Full definition →	22.69	14.26	0.00	0.00	28.79	0.00	23.99	18.87	47.50	64.37
Earnings Yield Full definition →	4.72%	3.64%	5.33%	4.51%	4.44%	4.25%	5.16%	4.29%	3.63%	3.77%
Free Cash Flow Yield Full definition →	4.85%	4.30%	5.14%	4.42%	5.65%	3.62%	3.47%	5.09%	4.00%	3.37%
Revenue per Share Full definition →	76.97	85.66	95.17	100.85	123.01	143.41	154.01	152.82	161.13	165.84
Operating CF per Share Full definition →	7.96	10.21	11.58	12.52	17.54	15.72	14.30	21.19	20.01	16.44
Capex per Share Full definition →	(1.29)	(1.57)	(2.15)	(2.45)	(2.29)	(2.43)	(3.05)	(3.23)	(3.52)	(3.70)
Free Cash Flow per Share Full definition →	6.67	8.64	9.43	10.07	15.25	13.29	11.25	17.96	16.49	12.74
Cash per Share Full definition →	2.07	3.05	1.56	1.95	7.35	2.22	2.70	3.76	1.68	1.40
Shareholders Equity per Share Full definition →	3.53	1.23	(1.65)	(2.85)	3.07	(1.61)	1.53	1.05	6.71	12.90
Interest Debt per Share Full definition →	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00
Book value per Share Full definition →	3.53	1.23	(1.65)	(2.85)	3.07	(1.61)	1.53	1.05	6.71	12.90
Free Cash Flow Full definition →	8,200.00	10,181.00	10,723.00	11,009.00	16,376.00	14,005.00	11,496.00	17,946.00	16,325.00	12,646.00
Working Capital Full definition →	3,591.00	2,739.00	1,813.00	1,435.00	5,311.00	362.00	9,361.00	7,760.00	3,022.00	1,967.00
Capital Expenditures Full definition →	(1,583.00)	(1,850.00)	(2,442.00)	(2,678.00)	(2,463.00)	(2,566.00)	(3,119.00)	(3,226.00)	(3,485.00)	(3,679.00)
Net Current Asset Value Full definition →	(20,909.00)	(24,142.00)	(27,352.00)	(34,542.00)	(38,805.00)	(44,517.00)	(42,412.00)	(45,711.00)	(57,796.00)	(57,891.00)
EV/EBIT Full definition →	14.16	17.72	15.20	17.59	17.47	18.43	15.46	18.12	21.35	20.58
Capex to Sales Full definition →	0.02	0.02	0.02	0.02	0.02	0.02	0.02	0.02	0.02	0.02
Price to Operating Income Full definition →	12.59	16.12	13.44	15.74	15.87	16.79	13.78	16.26	18.95	17.97
Other line items
Depreciation/Fixed assets Full definition →	0.09	0.09	0.10	0.10	0.10	0.11	0.12	0.12	0.14	0.15
Cash ROIC Full definition →	26.91%	31.74%	36.85%	36.10%	33.81%	34.38%	24.20%	36.69%	26.47%	18.07%
Accounts Receivable Turnover Full definition →	48.28	50.69	55.66	54.54	51.83	47.10	46.69	45.95	38.76	31.37
Accounts Payable Turnover Full definition →	9.18	9.34	9.47	9.35	9.00	8.00	8.40	9.47	9.67	9.37
Inventory Turnover Full definition →	5.11	5.26	5.33	5.11	5.60	5.19	4.46	4.44	4.78	4.46
Average Days of Payables Full definition →	41.02	39.73	39.84	39.12	48.55	48.98	39.92	36.02	41.03	38.19
Days of Inventory on Hand Full definition →	73.54	69.92	71.54	73.00	69.55	80.29	86.82	75.28	80.59	85.81
Average Receivables Full definition →	1,959.50	1,990.50	1,944.00	2,021.00	2,549.00	3,209.00	3,371.50	3,322.50	4,115.50	5,250.00
Average Payables Full definition →	6,782.50	7,122.00	7,499.50	7,771.00	9,696.50	12,534.00	12,452.50	10,740.00	10,987.50	11,714.50
Average Inventory Full definition →	12,179.00	12,648.50	13,336.50	14,228.00	15,579.00	19,347.50	23,477.00	22,931.00	22,213.50	24,634.00
Average Assets Full definition →	42,469.50	43,747.50	44,266.00	47,619.50	60,908.50	71,228.50	74,160.50	76,487.50	86,324.50	100,607.00
Average Common Equity Full definition →	5,324.50	2,893.50	(212.00)	(2,497.00)	91.50	801.50	(67.00)	1,303.00	3,842.00	9,726.50

Fold the line items

Columns are period end dates

Stockrow Weekly