Stock Analysis on Net

Home Depot Inc. (NYSE:HD)

Analysis of Long-term (Investment) Activity Ratios
Quarterly Data

Microsoft Excel

Long-term Activity Ratios (Summary)

Home Depot Inc., long-term (investment) activity ratios (quarterly data)

Microsoft Excel
Oct 27, 2024 Jul 28, 2024 Apr 28, 2024 Jan 28, 2024 Oct 29, 2023 Jul 30, 2023 Apr 30, 2023 Jan 29, 2023 Oct 30, 2022 Jul 31, 2022 May 1, 2022 Jan 30, 2022 Oct 31, 2021 Aug 1, 2021 May 2, 2021 Jan 31, 2021 Nov 1, 2020 Aug 2, 2020 May 3, 2020 Feb 2, 2020 Nov 3, 2019 Aug 4, 2019 May 5, 2019 Feb 3, 2019 Oct 28, 2018 Jul 29, 2018 Apr 29, 2018
Net fixed asset turnover 5.82 5.71 5.84 5.84 5.97 5.98 6.07 6.14 6.23 6.15 6.06 6.00 5.92 5.83 5.73 5.35 5.27 5.10 4.94 4.84 4.94 4.91 4.92 4.84
Net fixed asset turnover (including operating lease, right-of-use asset) 4.41 4.31 4.48 4.49 4.69 4.69 4.78 4.83 4.95 4.95 4.90 4.85 4.79 4.70 4.63 4.31 4.29 4.14 3.96 3.89 3.95 3.90 3.93 4.84
Total asset turnover 1.59 1.57 1.92 1.99 2.03 2.03 2.04 2.06 2.05 2.05 1.99 2.10 2.02 2.04 1.95 1.87 1.88 1.88 1.91 2.15 2.12 2.12 2.13 2.46
Equity turnover 26.72 34.41 83.42 146.23 107.49 116.01 430.25 100.77 121.18 655.02 142.70 69.80 80.86 40.05 81.84

Based on: 10-Q (reporting date: 2024-10-27), 10-Q (reporting date: 2024-07-28), 10-Q (reporting date: 2024-04-28), 10-K (reporting date: 2024-01-28), 10-Q (reporting date: 2023-10-29), 10-Q (reporting date: 2023-07-30), 10-Q (reporting date: 2023-04-30), 10-K (reporting date: 2023-01-29), 10-Q (reporting date: 2022-10-30), 10-Q (reporting date: 2022-07-31), 10-Q (reporting date: 2022-05-01), 10-K (reporting date: 2022-01-30), 10-Q (reporting date: 2021-10-31), 10-Q (reporting date: 2021-08-01), 10-Q (reporting date: 2021-05-02), 10-K (reporting date: 2021-01-31), 10-Q (reporting date: 2020-11-01), 10-Q (reporting date: 2020-08-02), 10-Q (reporting date: 2020-05-03), 10-K (reporting date: 2020-02-02), 10-Q (reporting date: 2019-11-03), 10-Q (reporting date: 2019-08-04), 10-Q (reporting date: 2019-05-05), 10-K (reporting date: 2019-02-03), 10-Q (reporting date: 2018-10-28), 10-Q (reporting date: 2018-07-29), 10-Q (reporting date: 2018-04-29).

Long-term activity ratio Description The company
Net fixed asset turnover An activity ratio calculated as total revenue divided by net fixed assets. Home Depot Inc. net fixed asset turnover ratio deteriorated from Q1 2025 to Q2 2025 but then improved from Q2 2025 to Q3 2025 not reaching Q1 2025 level.
Net fixed asset turnover (including operating lease, right-of-use asset) An activity ratio calculated as total revenue divided by net fixed assets (including operating lease, right-of-use asset). Home Depot Inc. net fixed asset turnover ratio (with operating lease, right-of-use asset) deteriorated from Q1 2025 to Q2 2025 but then improved from Q2 2025 to Q3 2025 not reaching Q1 2025 level.
Total asset turnover An activity ratio calculated as total revenue divided by total assets. Home Depot Inc. total asset turnover ratio deteriorated from Q1 2025 to Q2 2025 but then slightly improved from Q2 2025 to Q3 2025.
Equity turnover An activity ratio calculated as total revenue divided by shareholders’ equity. Home Depot Inc. equity turnover ratio deteriorated from Q1 2025 to Q2 2025 and from Q2 2025 to Q3 2025.

Net Fixed Asset Turnover

Home Depot Inc., net fixed asset turnover calculation (quarterly data)

Microsoft Excel
Oct 27, 2024 Jul 28, 2024 Apr 28, 2024 Jan 28, 2024 Oct 29, 2023 Jul 30, 2023 Apr 30, 2023 Jan 29, 2023 Oct 30, 2022 Jul 31, 2022 May 1, 2022 Jan 30, 2022 Oct 31, 2021 Aug 1, 2021 May 2, 2021 Jan 31, 2021 Nov 1, 2020 Aug 2, 2020 May 3, 2020 Feb 2, 2020 Nov 3, 2019 Aug 4, 2019 May 5, 2019 Feb 3, 2019 Oct 28, 2018 Jul 29, 2018 Apr 29, 2018
Selected Financial Data (US$ in millions)
Net sales 40,217 43,175 36,418 34,786 37,710 42,916 37,257 35,831 38,872 43,792 38,908 35,719 36,820 41,118 37,500 32,261 33,536 38,053 28,260 25,782 27,223 30,839 26,381 26,491 26,302 30,463 24,947
Net property and equipment 26,573 26,640 25,997 26,154 25,735 25,879 25,674 25,631 25,240 25,247 25,166 25,199 24,935 24,750 24,673 24,705 23,848 23,387 22,697 22,770 22,472 22,387 22,270 22,375 22,054 21,909 21,928
Long-term Activity Ratio
Net fixed asset turnover1 5.82 5.71 5.84 5.84 5.97 5.98 6.07 6.14 6.23 6.15 6.06 6.00 5.92 5.83 5.73 5.35 5.27 5.10 4.94 4.84 4.94 4.91 4.92 4.84
Benchmarks
Net Fixed Asset Turnover, Competitors2
Amazon.com Inc. 2.61 2.74 2.81 2.82 2.82 2.78 2.75 2.75 2.83 2.80 2.84 2.93 3.11 3.32 3.45 3.41 3.48 3.72 3.81 3.86
Lowe’s Cos. Inc. 4.80 4.87 4.89 5.15 5.37 5.50 5.53 5.55 5.10 5.05 5.05 5.03 4.97 4.95 4.68 4.57 4.32 4.00 3.86 3.91 3.94 3.95 3.87
TJX Cos. Inc. 7.98 8.29 8.25 8.36 8.31 8.53 8.63 8.84 9.21 9.43 9.21 8.84 8.46 7.46 6.38 6.67 6.61 7.08 7.83 7.74 7.94 7.88 7.42

Based on: 10-Q (reporting date: 2024-10-27), 10-Q (reporting date: 2024-07-28), 10-Q (reporting date: 2024-04-28), 10-K (reporting date: 2024-01-28), 10-Q (reporting date: 2023-10-29), 10-Q (reporting date: 2023-07-30), 10-Q (reporting date: 2023-04-30), 10-K (reporting date: 2023-01-29), 10-Q (reporting date: 2022-10-30), 10-Q (reporting date: 2022-07-31), 10-Q (reporting date: 2022-05-01), 10-K (reporting date: 2022-01-30), 10-Q (reporting date: 2021-10-31), 10-Q (reporting date: 2021-08-01), 10-Q (reporting date: 2021-05-02), 10-K (reporting date: 2021-01-31), 10-Q (reporting date: 2020-11-01), 10-Q (reporting date: 2020-08-02), 10-Q (reporting date: 2020-05-03), 10-K (reporting date: 2020-02-02), 10-Q (reporting date: 2019-11-03), 10-Q (reporting date: 2019-08-04), 10-Q (reporting date: 2019-05-05), 10-K (reporting date: 2019-02-03), 10-Q (reporting date: 2018-10-28), 10-Q (reporting date: 2018-07-29), 10-Q (reporting date: 2018-04-29).

1 Q3 2025 Calculation
Net fixed asset turnover = (Net salesQ3 2025 + Net salesQ2 2025 + Net salesQ1 2025 + Net salesQ4 2024) ÷ Net property and equipment
= (40,217 + 43,175 + 36,418 + 34,786) ÷ 26,573 = 5.82

2 Click competitor name to see calculations.

Long-term activity ratio Description The company
Net fixed asset turnover An activity ratio calculated as total revenue divided by net fixed assets. Home Depot Inc. net fixed asset turnover ratio deteriorated from Q1 2025 to Q2 2025 but then improved from Q2 2025 to Q3 2025 not reaching Q1 2025 level.

Net Fixed Asset Turnover (including Operating Lease, Right-of-Use Asset)

Home Depot Inc., net fixed asset turnover (including operating lease, right-of-use asset) calculation (quarterly data)

Microsoft Excel
Oct 27, 2024 Jul 28, 2024 Apr 28, 2024 Jan 28, 2024 Oct 29, 2023 Jul 30, 2023 Apr 30, 2023 Jan 29, 2023 Oct 30, 2022 Jul 31, 2022 May 1, 2022 Jan 30, 2022 Oct 31, 2021 Aug 1, 2021 May 2, 2021 Jan 31, 2021 Nov 1, 2020 Aug 2, 2020 May 3, 2020 Feb 2, 2020 Nov 3, 2019 Aug 4, 2019 May 5, 2019 Feb 3, 2019 Oct 28, 2018 Jul 29, 2018 Apr 29, 2018
Selected Financial Data (US$ in millions)
Net sales 40,217 43,175 36,418 34,786 37,710 42,916 37,257 35,831 38,872 43,792 38,908 35,719 36,820 41,118 37,500 32,261 33,536 38,053 28,260 25,782 27,223 30,839 26,381 26,491 26,302 30,463 24,947
 
Net property and equipment 26,573 26,640 25,997 26,154 25,735 25,879 25,674 25,631 25,240 25,247 25,166 25,199 24,935 24,750 24,673 24,705 23,848 23,387 22,697 22,770 22,472 22,387 22,270 22,375 22,054 21,909 21,928
Operating lease right-of-use assets 8,521 8,613 7,913 7,884 7,071 7,139 6,931 6,941 6,523 6,132 5,980 5,968 5,903 5,960 5,864 5,962 5,433 5,436 5,634 5,595 5,638 5,789 5,629
Net property and equipment (including operating lease, right-of-use asset) 35,094 35,253 33,910 34,038 32,806 33,018 32,605 32,572 31,763 31,379 31,146 31,167 30,838 30,710 30,537 30,667 29,281 28,823 28,331 28,365 28,110 28,176 27,899 22,375 22,054 21,909 21,928
Long-term Activity Ratio
Net fixed asset turnover (including operating lease, right-of-use asset)1 4.41 4.31 4.48 4.49 4.69 4.69 4.78 4.83 4.95 4.95 4.90 4.85 4.79 4.70 4.63 4.31 4.29 4.14 3.96 3.89 3.95 3.90 3.93 4.84
Benchmarks
Net Fixed Asset Turnover (including Operating Lease, Right-of-Use Asset), Competitors2
Amazon.com Inc. 1.97 2.05 2.09 2.08 2.07 2.04 2.03 2.03 2.10 2.09 2.13 2.17 2.30 2.51 2.61 2.56 2.59 2.80 2.85 2.87
Lowe’s Cos. Inc. 3.94 4.00 4.04 4.26 4.43 4.58 4.60 4.62 4.17 4.15 4.15 4.12 4.14 4.11 3.90 3.79 3.59 3.31 3.20 3.23 3.24 3.25 3.87
TJX Cos. Inc. 3.37 3.41 3.40 3.36 3.29 3.34 3.36 3.38 3.45 3.47 3.44 3.19 3.02 2.66 2.29 2.38 2.38 2.58 2.90 2.84 2.86 2.86 7.42

Based on: 10-Q (reporting date: 2024-10-27), 10-Q (reporting date: 2024-07-28), 10-Q (reporting date: 2024-04-28), 10-K (reporting date: 2024-01-28), 10-Q (reporting date: 2023-10-29), 10-Q (reporting date: 2023-07-30), 10-Q (reporting date: 2023-04-30), 10-K (reporting date: 2023-01-29), 10-Q (reporting date: 2022-10-30), 10-Q (reporting date: 2022-07-31), 10-Q (reporting date: 2022-05-01), 10-K (reporting date: 2022-01-30), 10-Q (reporting date: 2021-10-31), 10-Q (reporting date: 2021-08-01), 10-Q (reporting date: 2021-05-02), 10-K (reporting date: 2021-01-31), 10-Q (reporting date: 2020-11-01), 10-Q (reporting date: 2020-08-02), 10-Q (reporting date: 2020-05-03), 10-K (reporting date: 2020-02-02), 10-Q (reporting date: 2019-11-03), 10-Q (reporting date: 2019-08-04), 10-Q (reporting date: 2019-05-05), 10-K (reporting date: 2019-02-03), 10-Q (reporting date: 2018-10-28), 10-Q (reporting date: 2018-07-29), 10-Q (reporting date: 2018-04-29).

1 Q3 2025 Calculation
Net fixed asset turnover (including operating lease, right-of-use asset) = (Net salesQ3 2025 + Net salesQ2 2025 + Net salesQ1 2025 + Net salesQ4 2024) ÷ Net property and equipment (including operating lease, right-of-use asset)
= (40,217 + 43,175 + 36,418 + 34,786) ÷ 35,094 = 4.41

2 Click competitor name to see calculations.

Long-term activity ratio Description The company
Net fixed asset turnover (including operating lease, right-of-use asset) An activity ratio calculated as total revenue divided by net fixed assets (including operating lease, right-of-use asset). Home Depot Inc. net fixed asset turnover ratio (with operating lease, right-of-use asset) deteriorated from Q1 2025 to Q2 2025 but then improved from Q2 2025 to Q3 2025 not reaching Q1 2025 level.

Total Asset Turnover

Home Depot Inc., total asset turnover calculation (quarterly data)

Microsoft Excel
Oct 27, 2024 Jul 28, 2024 Apr 28, 2024 Jan 28, 2024 Oct 29, 2023 Jul 30, 2023 Apr 30, 2023 Jan 29, 2023 Oct 30, 2022 Jul 31, 2022 May 1, 2022 Jan 30, 2022 Oct 31, 2021 Aug 1, 2021 May 2, 2021 Jan 31, 2021 Nov 1, 2020 Aug 2, 2020 May 3, 2020 Feb 2, 2020 Nov 3, 2019 Aug 4, 2019 May 5, 2019 Feb 3, 2019 Oct 28, 2018 Jul 29, 2018 Apr 29, 2018
Selected Financial Data (US$ in millions)
Net sales 40,217 43,175 36,418 34,786 37,710 42,916 37,257 35,831 38,872 43,792 38,908 35,719 36,820 41,118 37,500 32,261 33,536 38,053 28,260 25,782 27,223 30,839 26,381 26,491 26,302 30,463 24,947
Total assets 97,264 96,846 79,230 76,530 75,577 76,387 76,386 76,445 76,866 75,825 76,567 71,876 73,031 70,769 72,567 70,581 66,919 63,349 58,737 51,236 52,309 52,010 51,515 44,003 45,200 46,232 46,650
Long-term Activity Ratio
Total asset turnover1 1.59 1.57 1.92 1.99 2.03 2.03 2.04 2.06 2.05 2.05 1.99 2.10 2.02 2.04 1.95 1.87 1.88 1.88 1.91 2.15 2.12 2.12 2.13 2.46
Benchmarks
Total Asset Turnover, Competitors2
Amazon.com Inc. 1.06 1.09 1.11 1.09 1.14 1.13 1.13 1.11 1.17 1.16 1.16 1.12 1.20 1.23 1.30 1.20 1.23 1.25 1.34 1.25
Lowe’s Cos. Inc. 1.87 1.88 2.07 2.12 2.09 2.09 2.22 2.04 2.04 1.92 2.16 1.93 1.92 1.84 1.92 1.68 1.55 1.62 1.83 1.80 1.76 1.66 2.07
TJX Cos. Inc. 1.82 1.85 1.82 1.72 1.77 1.75 1.76 1.73 1.83 1.80 1.71 1.52 1.50 1.25 1.04 1.06 1.27 1.45 1.73 1.67 1.75 1.76 2.72

Based on: 10-Q (reporting date: 2024-10-27), 10-Q (reporting date: 2024-07-28), 10-Q (reporting date: 2024-04-28), 10-K (reporting date: 2024-01-28), 10-Q (reporting date: 2023-10-29), 10-Q (reporting date: 2023-07-30), 10-Q (reporting date: 2023-04-30), 10-K (reporting date: 2023-01-29), 10-Q (reporting date: 2022-10-30), 10-Q (reporting date: 2022-07-31), 10-Q (reporting date: 2022-05-01), 10-K (reporting date: 2022-01-30), 10-Q (reporting date: 2021-10-31), 10-Q (reporting date: 2021-08-01), 10-Q (reporting date: 2021-05-02), 10-K (reporting date: 2021-01-31), 10-Q (reporting date: 2020-11-01), 10-Q (reporting date: 2020-08-02), 10-Q (reporting date: 2020-05-03), 10-K (reporting date: 2020-02-02), 10-Q (reporting date: 2019-11-03), 10-Q (reporting date: 2019-08-04), 10-Q (reporting date: 2019-05-05), 10-K (reporting date: 2019-02-03), 10-Q (reporting date: 2018-10-28), 10-Q (reporting date: 2018-07-29), 10-Q (reporting date: 2018-04-29).

1 Q3 2025 Calculation
Total asset turnover = (Net salesQ3 2025 + Net salesQ2 2025 + Net salesQ1 2025 + Net salesQ4 2024) ÷ Total assets
= (40,217 + 43,175 + 36,418 + 34,786) ÷ 97,264 = 1.59

2 Click competitor name to see calculations.

Long-term activity ratio Description The company
Total asset turnover An activity ratio calculated as total revenue divided by total assets. Home Depot Inc. total asset turnover ratio deteriorated from Q1 2025 to Q2 2025 but then slightly improved from Q2 2025 to Q3 2025.

Equity Turnover

Home Depot Inc., equity turnover calculation (quarterly data)

Microsoft Excel
Oct 27, 2024 Jul 28, 2024 Apr 28, 2024 Jan 28, 2024 Oct 29, 2023 Jul 30, 2023 Apr 30, 2023 Jan 29, 2023 Oct 30, 2022 Jul 31, 2022 May 1, 2022 Jan 30, 2022 Oct 31, 2021 Aug 1, 2021 May 2, 2021 Jan 31, 2021 Nov 1, 2020 Aug 2, 2020 May 3, 2020 Feb 2, 2020 Nov 3, 2019 Aug 4, 2019 May 5, 2019 Feb 3, 2019 Oct 28, 2018 Jul 29, 2018 Apr 29, 2018
Selected Financial Data (US$ in millions)
Net sales 40,217 43,175 36,418 34,786 37,710 42,916 37,257 35,831 38,872 43,792 38,908 35,719 36,820 41,118 37,500 32,261 33,536 38,053 28,260 25,782 27,223 30,839 26,381 26,491 26,302 30,463 24,947
Stockholders’ equity (deficit) 5,786 4,420 1,820 1,044 1,430 1,335 362 1,562 1,298 237 (1,709) (1,696) 1,035 2,069 1,748 3,299 1,535 (414) (3,490) (3,116) (1,082) (1,160) (2,143) (1,878) 1,320 2,009 1,687
Long-term Activity Ratio
Equity turnover1 26.72 34.41 83.42 146.23 107.49 116.01 430.25 100.77 121.18 655.02 142.70 69.80 80.86 40.05 81.84
Benchmarks
Equity Turnover, Competitors2
Amazon.com Inc. 2.39 2.56 2.73 2.85 3.03 3.19 3.40 3.52 3.65 3.70 3.57 3.40 3.80 3.86 4.06 4.13 4.20 4.36 4.54 4.52
Lowe’s Cos. Inc. 212.01 62.35 20.95 18.46 43.17 36.59 29.20 27.19 22.15 19.57
TJX Cos. Inc. 7.15 7.32 7.42 7.66 7.75 7.83 7.85 8.70 9.20 8.91 8.09 7.08 6.75 6.16 5.51 6.00 7.24 7.78 7.01 7.33 7.55 7.71 7.72

Based on: 10-Q (reporting date: 2024-10-27), 10-Q (reporting date: 2024-07-28), 10-Q (reporting date: 2024-04-28), 10-K (reporting date: 2024-01-28), 10-Q (reporting date: 2023-10-29), 10-Q (reporting date: 2023-07-30), 10-Q (reporting date: 2023-04-30), 10-K (reporting date: 2023-01-29), 10-Q (reporting date: 2022-10-30), 10-Q (reporting date: 2022-07-31), 10-Q (reporting date: 2022-05-01), 10-K (reporting date: 2022-01-30), 10-Q (reporting date: 2021-10-31), 10-Q (reporting date: 2021-08-01), 10-Q (reporting date: 2021-05-02), 10-K (reporting date: 2021-01-31), 10-Q (reporting date: 2020-11-01), 10-Q (reporting date: 2020-08-02), 10-Q (reporting date: 2020-05-03), 10-K (reporting date: 2020-02-02), 10-Q (reporting date: 2019-11-03), 10-Q (reporting date: 2019-08-04), 10-Q (reporting date: 2019-05-05), 10-K (reporting date: 2019-02-03), 10-Q (reporting date: 2018-10-28), 10-Q (reporting date: 2018-07-29), 10-Q (reporting date: 2018-04-29).

1 Q3 2025 Calculation
Equity turnover = (Net salesQ3 2025 + Net salesQ2 2025 + Net salesQ1 2025 + Net salesQ4 2024) ÷ Stockholders’ equity (deficit)
= (40,217 + 43,175 + 36,418 + 34,786) ÷ 5,786 = 26.72

2 Click competitor name to see calculations.

Long-term activity ratio Description The company
Equity turnover An activity ratio calculated as total revenue divided by shareholders’ equity. Home Depot Inc. equity turnover ratio deteriorated from Q1 2025 to Q2 2025 and from Q2 2025 to Q3 2025.