Analysis of Long-term (Investment) Activity Ratios
Quarterly Data
Activity ratios measure how efficiently a company performs day-to-day tasks, such us the collection of receivables and management of inventory.
Long-term Activity Ratios (Summary)
Home Depot Inc., long-term (investment) activity ratios (quarterly data)
Based on: 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 Q2 2024 to Q3 2024 and from Q3 2024 to Q4 2024. |
| 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 Q2 2024 to Q3 2024 and from Q3 2024 to Q4 2024. |
| Total asset turnover | An activity ratio calculated as total revenue divided by total assets. | Home Depot Inc. total asset turnover ratio improved from Q2 2024 to Q3 2024 but then deteriorated significantly from Q3 2024 to Q4 2024. |
| Equity turnover | An activity ratio calculated as total revenue divided by shareholders’ equity. | Home Depot Inc. equity turnover ratio deteriorated from Q2 2024 to Q3 2024 but then improved from Q3 2024 to Q4 2024 exceeding Q2 2024 level. |
Net Fixed Asset Turnover
Home Depot Inc., net fixed asset turnover calculation (quarterly data)
| 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 | 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,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.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.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.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. | 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-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 Q4 2024 Calculation
Net fixed asset turnover
= (Net salesQ4 2024
+ Net salesQ3 2024
+ Net salesQ2 2024
+ Net salesQ1 2024)
÷ Net property and equipment
= (34,786 + 37,710 + 42,916 + 37,257)
÷ 26,154 = 5.84
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 Q2 2024 to Q3 2024 and from Q3 2024 to Q4 2024. |
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)
| 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 | 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,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 | 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) | 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.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. | — | — | — | — | 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. | 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.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-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 Q4 2024 Calculation
Net fixed asset turnover (including operating lease, right-of-use asset)
= (Net salesQ4 2024
+ Net salesQ3 2024
+ Net salesQ2 2024
+ Net salesQ1 2024)
÷ Net property and equipment (including operating lease, right-of-use asset)
= (34,786 + 37,710 + 42,916 + 37,257)
÷ 34,038 = 4.49
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 Q2 2024 to Q3 2024 and from Q3 2024 to Q4 2024. |
Total Asset Turnover
Home Depot Inc., total asset turnover calculation (quarterly data)
| 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 | 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 | 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.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.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. | 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.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-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 Q4 2024 Calculation
Total asset turnover
= (Net salesQ4 2024
+ Net salesQ3 2024
+ Net salesQ2 2024
+ Net salesQ1 2024)
÷ Total assets
= (34,786 + 37,710 + 42,916 + 37,257)
÷ 76,530 = 1.99
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 improved from Q2 2024 to Q3 2024 but then deteriorated significantly from Q3 2024 to Q4 2024. |
Equity Turnover
Home Depot Inc., equity turnover calculation (quarterly data)
| 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 | 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) | 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 | 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.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.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-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 Q4 2024 Calculation
Equity turnover
= (Net salesQ4 2024
+ Net salesQ3 2024
+ Net salesQ2 2024
+ Net salesQ1 2024)
÷ Stockholders’ equity (deficit)
= (34,786 + 37,710 + 42,916 + 37,257)
÷ 1,044 = 146.23
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 Q2 2024 to Q3 2024 but then improved from Q3 2024 to Q4 2024 exceeding Q2 2024 level. |