Analysis of Long-term (Investment) Activity Ratios
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
Based on: 10-K (reporting date: 2024-01-28), 10-K (reporting date: 2023-01-29), 10-K (reporting date: 2022-01-30), 10-K (reporting date: 2021-01-31), 10-K (reporting date: 2020-02-02), 10-K (reporting date: 2019-02-03).
| 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 improved from 2022 to 2023 but then deteriorated significantly from 2023 to 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 2022 to 2023 and from 2023 to 2024. |
| Total asset turnover | An activity ratio calculated as total revenue divided by total assets. | Home Depot Inc. total asset turnover ratio deteriorated from 2022 to 2023 and from 2023 to 2024. |
Net Fixed Asset Turnover
Home Depot Inc., net fixed asset turnover calculation, comparison to benchmarks
| Jan 28, 2024 | Jan 29, 2023 | Jan 30, 2022 | Jan 31, 2021 | Feb 2, 2020 | Feb 3, 2019 | ||
|---|---|---|---|---|---|---|---|
| Selected Financial Data (US$ in millions) | |||||||
| Net sales | 152,669) | 157,403) | 151,157) | 132,110) | 110,225) | 108,203) | |
| Net property and equipment | 26,154) | 25,631) | 25,199) | 24,705) | 22,770) | 22,375) | |
| Long-term Activity Ratio | |||||||
| Net fixed asset turnover1 | 5.84 | 6.14 | 6.00 | 5.35 | 4.84 | 4.84 | |
| Benchmarks | |||||||
| Net Fixed Asset Turnover, Competitors2 | |||||||
| Amazon.com Inc. | — | 2.82 | 2.75 | 2.93 | 3.41 | 3.86 | |
| Lowe’s Cos. Inc. | 4.89 | 5.53 | 5.05 | 4.68 | 3.86 | 3.87 | |
| TJX Cos. Inc. | 8.25 | 8.63 | 9.21 | 6.38 | 7.83 | 7.42 | |
| Net Fixed Asset Turnover, Sector | |||||||
| Consumer Discretionary Distribution & Retail | — | 3.47 | 3.43 | 3.46 | 3.82 | 4.20 | |
| Net Fixed Asset Turnover, Industry | |||||||
| Consumer Discretionary | — | 3.50 | 3.47 | 3.31 | 3.37 | 3.71 | |
Based on: 10-K (reporting date: 2024-01-28), 10-K (reporting date: 2023-01-29), 10-K (reporting date: 2022-01-30), 10-K (reporting date: 2021-01-31), 10-K (reporting date: 2020-02-02), 10-K (reporting date: 2019-02-03).
1 2024 Calculation
Net fixed asset turnover = Net sales ÷ Net property and equipment
= 152,669 ÷ 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 improved from 2022 to 2023 but then deteriorated significantly from 2023 to 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, comparison to benchmarks
| Jan 28, 2024 | Jan 29, 2023 | Jan 30, 2022 | Jan 31, 2021 | Feb 2, 2020 | Feb 3, 2019 | ||
|---|---|---|---|---|---|---|---|
| Selected Financial Data (US$ in millions) | |||||||
| Net sales | 152,669) | 157,403) | 151,157) | 132,110) | 110,225) | 108,203) | |
| Net property and equipment | 26,154) | 25,631) | 25,199) | 24,705) | 22,770) | 22,375) | |
| Operating lease right-of-use assets | 7,884) | 6,941) | 5,968) | 5,962) | 5,595) | —) | |
| Net property and equipment (including operating lease, right-of-use asset) | 34,038) | 32,572) | 31,167) | 30,667) | 28,365) | 22,375) | |
| Long-term Activity Ratio | |||||||
| Net fixed asset turnover (including operating lease, right-of-use asset)1 | 4.49 | 4.83 | 4.85 | 4.31 | 3.89 | 4.84 | |
| Benchmarks | |||||||
| Net Fixed Asset Turnover (including Operating Lease, Right-of-Use Asset), Competitors2 | |||||||
| Amazon.com Inc. | — | 2.08 | 2.03 | 2.17 | 2.56 | 2.87 | |
| Lowe’s Cos. Inc. | 4.04 | 4.60 | 4.15 | 3.90 | 3.20 | 3.87 | |
| TJX Cos. Inc. | 3.40 | 3.36 | 3.44 | 2.29 | 2.90 | 7.42 | |
| Net Fixed Asset Turnover (including Operating Lease, Right-of-Use Asset), Sector | |||||||
| Consumer Discretionary Distribution & Retail | — | 2.55 | 2.52 | 2.55 | 2.83 | 3.47 | |
| Net Fixed Asset Turnover (including Operating Lease, Right-of-Use Asset), Industry | |||||||
| Consumer Discretionary | — | 2.68 | 2.66 | 2.51 | 2.57 | 3.13 | |
Based on: 10-K (reporting date: 2024-01-28), 10-K (reporting date: 2023-01-29), 10-K (reporting date: 2022-01-30), 10-K (reporting date: 2021-01-31), 10-K (reporting date: 2020-02-02), 10-K (reporting date: 2019-02-03).
1 2024 Calculation
Net fixed asset turnover (including operating lease, right-of-use asset) = Net sales ÷ Net property and equipment (including operating lease, right-of-use asset)
= 152,669 ÷ 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 2022 to 2023 and from 2023 to 2024. |
Total Asset Turnover
Home Depot Inc., total asset turnover calculation, comparison to benchmarks
| Jan 28, 2024 | Jan 29, 2023 | Jan 30, 2022 | Jan 31, 2021 | Feb 2, 2020 | Feb 3, 2019 | ||
|---|---|---|---|---|---|---|---|
| Selected Financial Data (US$ in millions) | |||||||
| Net sales | 152,669) | 157,403) | 151,157) | 132,110) | 110,225) | 108,203) | |
| Total assets | 76,530) | 76,445) | 71,876) | 70,581) | 51,236) | 44,003) | |
| Long-term Activity Ratio | |||||||
| Total asset turnover1 | 1.99 | 2.06 | 2.10 | 1.87 | 2.15 | 2.46 | |
| Benchmarks | |||||||
| Total Asset Turnover, Competitors2 | |||||||
| Amazon.com Inc. | — | 1.09 | 1.11 | 1.12 | 1.20 | 1.25 | |
| Lowe’s Cos. Inc. | 2.07 | 2.22 | 2.16 | 1.92 | 1.83 | 2.07 | |
| TJX Cos. Inc. | 1.82 | 1.76 | 1.71 | 1.04 | 1.73 | 2.72 | |
| Total Asset Turnover, Sector | |||||||
| Consumer Discretionary Distribution & Retail | — | 1.30 | 1.33 | 1.27 | 1.40 | 1.57 | |
| Total Asset Turnover, Industry | |||||||
| Consumer Discretionary | — | 0.97 | 0.96 | 0.88 | 0.84 | 0.94 | |
Based on: 10-K (reporting date: 2024-01-28), 10-K (reporting date: 2023-01-29), 10-K (reporting date: 2022-01-30), 10-K (reporting date: 2021-01-31), 10-K (reporting date: 2020-02-02), 10-K (reporting date: 2019-02-03).
1 2024 Calculation
Total asset turnover = Net sales ÷ Total assets
= 152,669 ÷ 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 deteriorated from 2022 to 2023 and from 2023 to 2024. |
Equity Turnover
Home Depot Inc., equity turnover calculation, comparison to benchmarks
| Jan 28, 2024 | Jan 29, 2023 | Jan 30, 2022 | Jan 31, 2021 | Feb 2, 2020 | Feb 3, 2019 | ||
|---|---|---|---|---|---|---|---|
| Selected Financial Data (US$ in millions) | |||||||
| Net sales | 152,669) | 157,403) | 151,157) | 132,110) | 110,225) | 108,203) | |
| Stockholders’ equity (deficit) | 1,044) | 1,562) | (1,696) | 3,299) | (3,116) | (1,878) | |
| Long-term Activity Ratio | |||||||
| Equity turnover1 | 146.23 | 100.77 | — | 40.05 | — | — | |
| Benchmarks | |||||||
| Equity Turnover, Competitors2 | |||||||
| Amazon.com Inc. | — | 2.85 | 3.52 | 3.40 | 4.13 | 4.52 | |
| Lowe’s Cos. Inc. | — | — | — | 62.35 | 36.59 | 19.57 | |
| TJX Cos. Inc. | 7.42 | 7.85 | 8.09 | 5.51 | 7.01 | 7.72 | |
| Equity Turnover, Sector | |||||||
| Consumer Discretionary Distribution & Retail | — | 4.50 | 5.57 | 4.86 | 6.21 | 7.25 | |
| Equity Turnover, Industry | |||||||
| Consumer Discretionary | — | 3.86 | 4.21 | 3.74 | 4.82 | 5.84 | |
Based on: 10-K (reporting date: 2024-01-28), 10-K (reporting date: 2023-01-29), 10-K (reporting date: 2022-01-30), 10-K (reporting date: 2021-01-31), 10-K (reporting date: 2020-02-02), 10-K (reporting date: 2019-02-03).
1 2024 Calculation
Equity turnover = Net sales ÷ Stockholders’ equity (deficit)
= 152,669 ÷ 1,044 = 146.23
2 Click competitor name to see calculations.