Stock Analysis on Net

Walmart Inc. (NYSE:WMT)

Analysis of Geographic Areas

Microsoft Excel LibreOffice Calc

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