Stock Analysis on Net

Home Depot Inc. (NYSE:HD)

Analysis of Long-term (Investment) Activity Ratios 

Microsoft Excel

Long-term Activity Ratios (Summary)

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

Microsoft Excel
Jan 28, 2024 Jan 29, 2023 Jan 30, 2022 Jan 31, 2021 Feb 2, 2020 Feb 3, 2019
Net fixed asset turnover 5.84 6.14 6.00 5.35 4.84 4.84
Net fixed asset turnover (including operating lease, right-of-use asset) 4.49 4.83 4.85 4.31 3.89 4.84
Total asset turnover 1.99 2.06 2.10 1.87 2.15 2.46
Equity turnover 146.23 100.77 40.05

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

Microsoft Excel
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. 5.53 5.05 4.68 3.86 3.87
TJX Cos. Inc. 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.24 3.18 2.98 2.99 3.28

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

Microsoft Excel
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.60 4.15 3.90 3.20 3.87
TJX Cos. Inc. 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.53 2.48 2.32 2.34 2.83

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

Microsoft Excel
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.22 2.16 1.92 1.83 2.07
TJX Cos. Inc. 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.95 0.93 0.84 0.81 0.92

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

Microsoft Excel
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.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.85 4.15 3.60 4.40 5.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
Equity turnover = Net sales ÷ Stockholders’ equity (deficit)
= 152,669 ÷ 1,044 = 146.23

2 Click competitor name to see calculations.