Stock Analysis on Net

Home Depot Inc. (NYSE:HD)

Analysis of Geographic Areas 

Microsoft Excel

Home Depot Inc. operates in 2 regions: In the U.S. and Outside the U.S..


Area Asset Turnover

Home Depot Inc., asset turnover by geographic area

Microsoft Excel
Jan 28, 2024 Jan 29, 2023 Jan 30, 2022 Jan 31, 2021 Feb 2, 2020 Feb 3, 2019
In the U.S. 6.00 6.28 6.12 5.50 4.99 4.99
Outside the U.S. 4.48 4.88 4.89 3.98 3.60 3.61

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).

Area activity ratio Geographic area The company
Area asset turnover In the U.S. In the U.S. area asset turnover ratio improved from 2022 to 2023 but then deteriorated significantly from 2023 to 2024.
Outside the U.S. Outside the U.S. area asset turnover ratio deteriorated from 2022 to 2023 and from 2023 to 2024.

Area Asset Turnover: In the U.S.

Home Depot Inc.; In the U.S.; area asset turnover calculation

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 140,083 144,840 138,920 122,158 101,333 99,386
Net property and equipment 23,347 23,057 22,696 22,205 20,302 19,930
Area Activity Ratio
Area asset turnover1 6.00 6.28 6.12 5.50 4.99 4.99

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
Area asset turnover = Net sales ÷ Net property and equipment
= 140,083 ÷ 23,347 = 6.00

Area activity ratio Geographic area The company
Area asset turnover In the U.S. In the U.S. area asset turnover ratio improved from 2022 to 2023 but then deteriorated significantly from 2023 to 2024.

Area Asset Turnover: Outside the U.S.

Home Depot Inc.; Outside the U.S.; area asset turnover calculation

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 12,586 12,563 12,237 9,952 8,892 8,817
Net property and equipment 2,807 2,574 2,503 2,500 2,468 2,445
Area Activity Ratio
Area asset turnover1 4.48 4.88 4.89 3.98 3.60 3.61

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
Area asset turnover = Net sales ÷ Net property and equipment
= 12,586 ÷ 2,807 = 4.48

Area activity ratio Geographic area The company
Area asset turnover Outside the U.S. Outside the U.S. area asset turnover ratio deteriorated from 2022 to 2023 and from 2023 to 2024.

Net property and equipment

Home Depot Inc., net property and equipment by geographic area

US$ in millions

Microsoft Excel
Jan 28, 2024 Jan 29, 2023 Jan 30, 2022 Jan 31, 2021 Feb 2, 2020 Feb 3, 2019
In the U.S. 23,347 23,057 22,696 22,205 20,302 19,930
Outside the U.S. 2,807 2,574 2,503 2,500 2,468 2,445
Total 26,154 25,631 25,199 24,705 22,770 22,375

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).


Net sales

Home Depot Inc., net sales by geographic area

US$ in millions

Microsoft Excel
Jan 28, 2024 Jan 29, 2023 Jan 30, 2022 Jan 31, 2021 Feb 2, 2020 Feb 3, 2019
In the U.S. 140,083 144,840 138,920 122,158 101,333 99,386
Outside the U.S. 12,586 12,563 12,237 9,952 8,892 8,817
Total 152,669 157,403 151,157 132,110 110,225 108,203

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).