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, 2022 Jan 31, 2021 Jan 31, 2020 Jan 31, 2019 Jan 31, 2018 Jan 31, 2017
U.S. operations 5.24 5.02 4.63 4.83 4.67 4.44
Non-U.S. operations 4.49 5.38 3.03 4.04 3.59 3.76

Based on: 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), 10-K (reporting date: 2017-01-31).

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

Area Asset Turnover: U.S. operations

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

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

Based on: 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), 10-K (reporting date: 2017-01-31).

1 2022 Calculation
Area asset turnover = Revenues ÷ Long-lived assets
= 470,295 ÷ 89,795 = 5.24

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

Area Asset Turnover: Non-U.S. operations

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

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

Based on: 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), 10-K (reporting date: 2017-01-31).

1 2022 Calculation
Area asset turnover = Revenues ÷ Long-lived assets
= 102,459 ÷ 22,829 = 4.49

Area activity ratio Geographic area The company
Area asset turnover Non-U.S. operations Non-U.S. operations area asset turnover ratio improved from 2020 to 2021 but then slightly deteriorated from 2021 to 2022.

Revenues

Walmart Inc., revenues by geographic area

US$ in millions

Microsoft Excel
Jan 31, 2022 Jan 31, 2021 Jan 31, 2020 Jan 31, 2019 Jan 31, 2018 Jan 31, 2017
U.S. operations 470,295 436,649 402,532 392,265 380,580 367,784
Non-U.S. operations 102,459 122,502 121,432 122,140 119,763 118,089
Total 572,754 559,151 523,964 514,405 500,343 485,873

Based on: 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), 10-K (reporting date: 2017-01-31).


Long-lived assets

Walmart Inc., long-lived assets by geographic area

US$ in millions

Microsoft Excel
Jan 31, 2022 Jan 31, 2021 Jan 31, 2020 Jan 31, 2019 Jan 31, 2018 Jan 31, 2017
U.S. operations 89,795 87,068 86,944 81,144 81,478 82,746
Non-U.S. operations 22,829 22,780 40,105 30,251 33,340 31,432
Total 112,624 109,848 127,049 111,395 114,818 114,178

Based on: 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), 10-K (reporting date: 2017-01-31).