Stock Analysis on Net

Walmart Inc. (NYSE:WMT)

Analysis of Geographic Areas

Microsoft Excel

Walmart Inc. operates in 2 regions: U.S. operations and Non-U.S. operations.


Area Asset Turnover

Walmart Inc., asset turnover by geographic area

Microsoft Excel
Jan 31, 2023 Jan 31, 2022 Jan 31, 2021 Jan 31, 2020 Jan 31, 2019 Jan 31, 2018
U.S. operations 5.32 5.24 5.02 4.63 4.83 4.67
Non-U.S. operations 4.34 4.49 5.38 3.03 4.04 3.59

Based on: 10-K (reporting date: 2023-01-31), 10-K (reporting date: 2022-01-31), 10-K (reporting date: 2021-01-31), 10-K (reporting date: 2020-01-31), 10-K (reporting date: 2019-01-31), 10-K (reporting date: 2018-01-31).

Area activity ratio Geographic area The company
Area asset turnover U.S. operations U.S. operations area asset turnover ratio improved from 2021 to 2022 and from 2022 to 2023.
Non-U.S. operations Non-U.S. operations area asset turnover ratio deteriorated from 2021 to 2022 and from 2022 to 2023.

Area Asset Turnover: U.S. operations

Walmart Inc.; U.S. operations; area asset turnover calculation

Microsoft Excel
Jan 31, 2023 Jan 31, 2022 Jan 31, 2021 Jan 31, 2020 Jan 31, 2019 Jan 31, 2018
Selected Financial Data (US$ in millions)
Revenues 508,685 470,295 436,649 402,532 392,265 380,580
Long-lived assets 95,567 89,795 87,068 86,944 81,144 81,478
Area Activity Ratio
Area asset turnover1 5.32 5.24 5.02 4.63 4.83 4.67

Based on: 10-K (reporting date: 2023-01-31), 10-K (reporting date: 2022-01-31), 10-K (reporting date: 2021-01-31), 10-K (reporting date: 2020-01-31), 10-K (reporting date: 2019-01-31), 10-K (reporting date: 2018-01-31).

1 2023 Calculation
Area asset turnover = Revenues ÷ Long-lived assets
= 508,685 ÷ 95,567 = 5.32

Area activity ratio Geographic area The company
Area asset turnover U.S. operations U.S. operations area asset turnover ratio improved from 2021 to 2022 and from 2022 to 2023.

Area Asset Turnover: Non-U.S. operations

Walmart Inc.; Non-U.S. operations; area asset turnover calculation

Microsoft Excel
Jan 31, 2023 Jan 31, 2022 Jan 31, 2021 Jan 31, 2020 Jan 31, 2019 Jan 31, 2018
Selected Financial Data (US$ in millions)
Revenues 102,604 102,459 122,502 121,432 122,140 119,763
Long-lived assets 23,667 22,829 22,780 40,105 30,251 33,340
Area Activity Ratio
Area asset turnover1 4.34 4.49 5.38 3.03 4.04 3.59

Based on: 10-K (reporting date: 2023-01-31), 10-K (reporting date: 2022-01-31), 10-K (reporting date: 2021-01-31), 10-K (reporting date: 2020-01-31), 10-K (reporting date: 2019-01-31), 10-K (reporting date: 2018-01-31).

1 2023 Calculation
Area asset turnover = Revenues ÷ Long-lived assets
= 102,604 ÷ 23,667 = 4.34

Area activity ratio Geographic area The company
Area asset turnover Non-U.S. operations Non-U.S. operations area asset turnover ratio deteriorated from 2021 to 2022 and from 2022 to 2023.

Revenues

Walmart Inc., revenues by geographic area

US$ in millions

Microsoft Excel
Jan 31, 2023 Jan 31, 2022 Jan 31, 2021 Jan 31, 2020 Jan 31, 2019 Jan 31, 2018
U.S. operations 508,685 470,295 436,649 402,532 392,265 380,580
Non-U.S. operations 102,604 102,459 122,502 121,432 122,140 119,763
Total 611,289 572,754 559,151 523,964 514,405 500,343

Based on: 10-K (reporting date: 2023-01-31), 10-K (reporting date: 2022-01-31), 10-K (reporting date: 2021-01-31), 10-K (reporting date: 2020-01-31), 10-K (reporting date: 2019-01-31), 10-K (reporting date: 2018-01-31).


Long-lived assets

Walmart Inc., long-lived assets by geographic area

US$ in millions

Microsoft Excel
Jan 31, 2023 Jan 31, 2022 Jan 31, 2021 Jan 31, 2020 Jan 31, 2019 Jan 31, 2018
U.S. operations 95,567 89,795 87,068 86,944 81,144 81,478
Non-U.S. operations 23,667 22,829 22,780 40,105 30,251 33,340
Total 119,234 112,624 109,848 127,049 111,395 114,818

Based on: 10-K (reporting date: 2023-01-31), 10-K (reporting date: 2022-01-31), 10-K (reporting date: 2021-01-31), 10-K (reporting date: 2020-01-31), 10-K (reporting date: 2019-01-31), 10-K (reporting date: 2018-01-31).