Analysis of Long-term (Investment) Activity Ratios
Quarterly Data
Activity ratios measure how efficiently a company performs day-to-day tasks, such us the collection of receivables and management of inventory.
Long-term Activity Ratios (Summary)
Walmart Inc., long-term (investment) activity ratios (quarterly data)
Based on: 10-K (reporting date: 2024-01-31), 10-Q (reporting date: 2023-10-31), 10-Q (reporting date: 2023-07-31), 10-Q (reporting date: 2023-04-30), 10-K (reporting date: 2023-01-31), 10-Q (reporting date: 2022-10-31), 10-Q (reporting date: 2022-07-31), 10-Q (reporting date: 2022-04-30), 10-K (reporting date: 2022-01-31), 10-Q (reporting date: 2021-10-31), 10-Q (reporting date: 2021-07-31), 10-Q (reporting date: 2021-04-30), 10-K (reporting date: 2021-01-31), 10-Q (reporting date: 2020-10-31), 10-Q (reporting date: 2020-07-31), 10-Q (reporting date: 2020-04-30), 10-K (reporting date: 2020-01-31), 10-Q (reporting date: 2019-10-31), 10-Q (reporting date: 2019-07-31), 10-Q (reporting date: 2019-04-30), 10-K (reporting date: 2019-01-31), 10-Q (reporting date: 2018-10-31), 10-Q (reporting date: 2018-07-31), 10-Q (reporting date: 2018-04-30).
| Long-term activity ratio | Description | The company |
|---|---|---|
| Net fixed asset turnover | An activity ratio calculated as total revenue divided by net fixed assets. | Walmart Inc. net fixed asset turnover ratio deteriorated from Q2 2024 to Q3 2024 and from Q3 2024 to Q4 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). | Walmart Inc. net fixed asset turnover ratio (with operating lease, right-of-use asset) deteriorated from Q2 2024 to Q3 2024 and from Q3 2024 to Q4 2024. |
| Total asset turnover | An activity ratio calculated as total revenue divided by total assets. | Walmart Inc. total asset turnover ratio deteriorated from Q2 2024 to Q3 2024 but then improved from Q3 2024 to Q4 2024 exceeding Q2 2024 level. |
| Equity turnover | An activity ratio calculated as total revenue divided by shareholders’ equity. | Walmart Inc. equity turnover ratio improved from Q2 2024 to Q3 2024 but then deteriorated significantly from Q3 2024 to Q4 2024. |
Net Fixed Asset Turnover
Walmart Inc., net fixed asset turnover calculation (quarterly data)
| Jan 31, 2024 | Oct 31, 2023 | Jul 31, 2023 | Apr 30, 2023 | Jan 31, 2023 | Oct 31, 2022 | Jul 31, 2022 | Apr 30, 2022 | Jan 31, 2022 | Oct 31, 2021 | Jul 31, 2021 | Apr 30, 2021 | Jan 31, 2021 | Oct 31, 2020 | Jul 31, 2020 | Apr 30, 2020 | Jan 31, 2020 | Oct 31, 2019 | Jul 31, 2019 | Apr 30, 2019 | Jan 31, 2019 | Oct 31, 2018 | Jul 31, 2018 | Apr 30, 2018 | ||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Selected Financial Data (US$ in millions) | |||||||||||||||||||||||||||||||
| Net sales | 171,914) | 159,439) | 160,280) | 151,004) | 162,743) | 151,469) | 151,381) | 140,288) | 151,525) | 139,207) | 139,871) | 137,159) | 150,985) | 133,752) | 136,824) | 133,672) | 140,608) | 126,981) | 129,388) | 122,949) | 137,743) | 123,897) | 127,059) | 121,630) | |||||||
| Property and equipment, including finance lease right-of-use assets, net | 116,665) | 113,277) | 110,285) | 107,459) | 105,679) | 102,150) | 100,520) | 99,246) | 98,866) | 96,468) | 95,730) | 94,975) | 96,206) | 107,161) | 106,025) | 106,483) | 109,625) | 108,481) | 108,623) | 108,408) | 111,395) | 111,349) | 111,017) | 114,800) | |||||||
| Long-term Activity Ratio | |||||||||||||||||||||||||||||||
| Net fixed asset turnover1 | 5.51 | 5.59 | 5.67 | 5.74 | 5.73 | 5.82 | 5.79 | 5.75 | 5.74 | 5.88 | 5.87 | 5.88 | 5.77 | 5.08 | 5.08 | 4.98 | 4.74 | 4.77 | 4.73 | 4.72 | 4.58 | — | — | — | |||||||
| Benchmarks | |||||||||||||||||||||||||||||||
| Net Fixed Asset Turnover, Competitors2 | |||||||||||||||||||||||||||||||
| Costco Wholesale Corp. | — | — | 8.84 | 8.87 | 8.91 | 8.91 | 8.94 | 9.02 | 9.04 | 8.84 | 8.57 | 8.34 | 8.18 | 7.89 | 7.77 | 7.60 | 7.48 | 7.31 | 7.21 | 7.12 | 7.15 | 7.15 | 7.15 | 7.12 | |||||||
| Target Corp. | 3.20 | 3.18 | 3.23 | 3.32 | 3.41 | 3.47 | 3.57 | 3.68 | 3.71 | 3.65 | 3.64 | 3.62 | 3.44 | 3.27 | 3.13 | 2.97 | 2.93 | 2.91 | 2.92 | 2.93 | 2.92 | — | — | — | |||||||
Based on: 10-K (reporting date: 2024-01-31), 10-Q (reporting date: 2023-10-31), 10-Q (reporting date: 2023-07-31), 10-Q (reporting date: 2023-04-30), 10-K (reporting date: 2023-01-31), 10-Q (reporting date: 2022-10-31), 10-Q (reporting date: 2022-07-31), 10-Q (reporting date: 2022-04-30), 10-K (reporting date: 2022-01-31), 10-Q (reporting date: 2021-10-31), 10-Q (reporting date: 2021-07-31), 10-Q (reporting date: 2021-04-30), 10-K (reporting date: 2021-01-31), 10-Q (reporting date: 2020-10-31), 10-Q (reporting date: 2020-07-31), 10-Q (reporting date: 2020-04-30), 10-K (reporting date: 2020-01-31), 10-Q (reporting date: 2019-10-31), 10-Q (reporting date: 2019-07-31), 10-Q (reporting date: 2019-04-30), 10-K (reporting date: 2019-01-31), 10-Q (reporting date: 2018-10-31), 10-Q (reporting date: 2018-07-31), 10-Q (reporting date: 2018-04-30).
1 Q4 2024 Calculation
Net fixed asset turnover
= (Net salesQ4 2024
+ Net salesQ3 2024
+ Net salesQ2 2024
+ Net salesQ1 2024)
÷ Property and equipment, including finance lease right-of-use assets, net
= (171,914 + 159,439 + 160,280 + 151,004)
÷ 116,665 = 5.51
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. | Walmart Inc. net fixed asset turnover ratio deteriorated from Q2 2024 to Q3 2024 and from Q3 2024 to Q4 2024. |
Net Fixed Asset Turnover (including Operating Lease, Right-of-Use Asset)
Walmart Inc., net fixed asset turnover (including operating lease, right-of-use asset) calculation (quarterly data)
| Jan 31, 2024 | Oct 31, 2023 | Jul 31, 2023 | Apr 30, 2023 | Jan 31, 2023 | Oct 31, 2022 | Jul 31, 2022 | Apr 30, 2022 | Jan 31, 2022 | Oct 31, 2021 | Jul 31, 2021 | Apr 30, 2021 | Jan 31, 2021 | Oct 31, 2020 | Jul 31, 2020 | Apr 30, 2020 | Jan 31, 2020 | Oct 31, 2019 | Jul 31, 2019 | Apr 30, 2019 | Jan 31, 2019 | Oct 31, 2018 | Jul 31, 2018 | Apr 30, 2018 | ||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Selected Financial Data (US$ in millions) | |||||||||||||||||||||||||||||||
| Net sales | 171,914) | 159,439) | 160,280) | 151,004) | 162,743) | 151,469) | 151,381) | 140,288) | 151,525) | 139,207) | 139,871) | 137,159) | 150,985) | 133,752) | 136,824) | 133,672) | 140,608) | 126,981) | 129,388) | 122,949) | 137,743) | 123,897) | 127,059) | 121,630) | |||||||
| Property and equipment, including finance lease right-of-use assets, net | 116,665) | 113,277) | 110,285) | 107,459) | 105,679) | 102,150) | 100,520) | 99,246) | 98,866) | 96,468) | 95,730) | 94,975) | 96,206) | 107,161) | 106,025) | 106,483) | 109,625) | 108,481) | 108,623) | 108,408) | 111,395) | 111,349) | 111,017) | 114,800) | |||||||
| Operating lease right-of-use assets | 13,673) | 13,547) | 13,710) | 13,679) | 13,555) | 13,394) | 13,872) | 13,971) | 13,758) | 13,863) | 13,868) | 13,650) | 13,642) | 17,128) | 16,869) | 16,895) | 17,424) | 16,944) | 17,239) | 16,833) | —) | —) | —) | —) | |||||||
| Property and equipment, including finance lease right-of-use assets, net (including operating lease, right-of-use asset) | 130,338) | 126,824) | 123,995) | 121,138) | 119,234) | 115,544) | 114,392) | 113,217) | 112,624) | 110,331) | 109,598) | 108,625) | 109,848) | 124,289) | 122,894) | 123,378) | 127,049) | 125,425) | 125,862) | 125,241) | 111,395) | 111,349) | 111,017) | 114,800) | |||||||
| Long-term Activity Ratio | |||||||||||||||||||||||||||||||
| Net fixed asset turnover (including operating lease, right-of-use asset)1 | 4.93 | 4.99 | 5.04 | 5.09 | 5.08 | 5.15 | 5.09 | 5.04 | 5.04 | 5.14 | 5.13 | 5.14 | 5.05 | 4.38 | 4.38 | 4.30 | 4.09 | 4.12 | 4.08 | 4.09 | 4.58 | — | — | — | |||||||
| Benchmarks | |||||||||||||||||||||||||||||||
| Net Fixed Asset Turnover (including Operating Lease, Right-of-Use Asset), Competitors2 | |||||||||||||||||||||||||||||||
| Costco Wholesale Corp. | — | — | 8.04 | 8.08 | 8.09 | 8.04 | 8.05 | 8.12 | 8.12 | 7.94 | 7.67 | 7.43 | 7.28 | 7.02 | 6.88 | 6.75 | 6.64 | 6.48 | 6.43 | 6.35 | 7.15 | 7.15 | 7.15 | 7.12 | |||||||
| Target Corp. | 2.90 | 2.91 | 2.97 | 3.07 | 3.15 | 3.20 | 3.29 | 3.38 | 3.40 | 3.35 | 3.33 | 3.32 | 3.17 | 3.02 | 2.89 | 2.74 | 2.70 | 2.69 | 2.70 | 2.72 | 2.71 | — | — | — | |||||||
Based on: 10-K (reporting date: 2024-01-31), 10-Q (reporting date: 2023-10-31), 10-Q (reporting date: 2023-07-31), 10-Q (reporting date: 2023-04-30), 10-K (reporting date: 2023-01-31), 10-Q (reporting date: 2022-10-31), 10-Q (reporting date: 2022-07-31), 10-Q (reporting date: 2022-04-30), 10-K (reporting date: 2022-01-31), 10-Q (reporting date: 2021-10-31), 10-Q (reporting date: 2021-07-31), 10-Q (reporting date: 2021-04-30), 10-K (reporting date: 2021-01-31), 10-Q (reporting date: 2020-10-31), 10-Q (reporting date: 2020-07-31), 10-Q (reporting date: 2020-04-30), 10-K (reporting date: 2020-01-31), 10-Q (reporting date: 2019-10-31), 10-Q (reporting date: 2019-07-31), 10-Q (reporting date: 2019-04-30), 10-K (reporting date: 2019-01-31), 10-Q (reporting date: 2018-10-31), 10-Q (reporting date: 2018-07-31), 10-Q (reporting date: 2018-04-30).
1 Q4 2024 Calculation
Net fixed asset turnover (including operating lease, right-of-use asset)
= (Net salesQ4 2024
+ Net salesQ3 2024
+ Net salesQ2 2024
+ Net salesQ1 2024)
÷ Property and equipment, including finance lease right-of-use assets, net (including operating lease, right-of-use asset)
= (171,914 + 159,439 + 160,280 + 151,004)
÷ 130,338 = 4.93
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). | Walmart Inc. net fixed asset turnover ratio (with operating lease, right-of-use asset) deteriorated from Q2 2024 to Q3 2024 and from Q3 2024 to Q4 2024. |
Total Asset Turnover
Walmart Inc., total asset turnover calculation (quarterly data)
| Jan 31, 2024 | Oct 31, 2023 | Jul 31, 2023 | Apr 30, 2023 | Jan 31, 2023 | Oct 31, 2022 | Jul 31, 2022 | Apr 30, 2022 | Jan 31, 2022 | Oct 31, 2021 | Jul 31, 2021 | Apr 30, 2021 | Jan 31, 2021 | Oct 31, 2020 | Jul 31, 2020 | Apr 30, 2020 | Jan 31, 2020 | Oct 31, 2019 | Jul 31, 2019 | Apr 30, 2019 | Jan 31, 2019 | Oct 31, 2018 | Jul 31, 2018 | Apr 30, 2018 | ||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Selected Financial Data (US$ in millions) | |||||||||||||||||||||||||||||||
| Net sales | 171,914) | 159,439) | 160,280) | 151,004) | 162,743) | 151,469) | 151,381) | 140,288) | 151,525) | 139,207) | 139,871) | 137,159) | 150,985) | 133,752) | 136,824) | 133,672) | 140,608) | 126,981) | 129,388) | 122,949) | 137,743) | 123,897) | 127,059) | 121,630) | |||||||
| Total assets | 252,399) | 259,174) | 255,121) | 245,053) | 243,197) | 247,656) | 247,199) | 246,142) | 244,860) | 244,851) | 238,552) | 236,581) | 252,496) | 250,863) | 237,382) | 232,892) | 236,495) | 239,830) | 234,861) | 234,544) | 219,295) | 226,583) | 206,062) | 204,927) | |||||||
| Long-term Activity Ratio | |||||||||||||||||||||||||||||||
| Total asset turnover1 | 2.55 | 2.44 | 2.45 | 2.52 | 2.49 | 2.40 | 2.36 | 2.32 | 2.32 | 2.32 | 2.35 | 2.36 | 2.20 | 2.17 | 2.27 | 2.28 | 2.20 | 2.16 | 2.19 | 2.18 | 2.33 | — | — | — | |||||||
| Benchmarks | |||||||||||||||||||||||||||||||
| Total Asset Turnover, Competitors2 | |||||||||||||||||||||||||||||||
| Costco Wholesale Corp. | — | — | 3.68 | 3.27 | 3.45 | 3.46 | 3.44 | 3.43 | 3.47 | 3.34 | 3.27 | 3.10 | 3.24 | 3.19 | 3.19 | 2.81 | 2.94 | 3.04 | 3.18 | 2.94 | 3.29 | 3.34 | 3.36 | 3.23 | |||||||
| Target Corp. | 1.91 | 1.87 | 2.00 | 2.07 | 2.02 | 1.93 | 2.03 | 2.08 | 1.94 | 1.87 | 1.93 | 1.92 | 1.80 | 1.73 | 1.74 | 1.77 | 1.80 | 1.75 | 1.83 | 1.85 | 1.80 | — | — | — | |||||||
Based on: 10-K (reporting date: 2024-01-31), 10-Q (reporting date: 2023-10-31), 10-Q (reporting date: 2023-07-31), 10-Q (reporting date: 2023-04-30), 10-K (reporting date: 2023-01-31), 10-Q (reporting date: 2022-10-31), 10-Q (reporting date: 2022-07-31), 10-Q (reporting date: 2022-04-30), 10-K (reporting date: 2022-01-31), 10-Q (reporting date: 2021-10-31), 10-Q (reporting date: 2021-07-31), 10-Q (reporting date: 2021-04-30), 10-K (reporting date: 2021-01-31), 10-Q (reporting date: 2020-10-31), 10-Q (reporting date: 2020-07-31), 10-Q (reporting date: 2020-04-30), 10-K (reporting date: 2020-01-31), 10-Q (reporting date: 2019-10-31), 10-Q (reporting date: 2019-07-31), 10-Q (reporting date: 2019-04-30), 10-K (reporting date: 2019-01-31), 10-Q (reporting date: 2018-10-31), 10-Q (reporting date: 2018-07-31), 10-Q (reporting date: 2018-04-30).
1 Q4 2024 Calculation
Total asset turnover
= (Net salesQ4 2024
+ Net salesQ3 2024
+ Net salesQ2 2024
+ Net salesQ1 2024)
÷ Total assets
= (171,914 + 159,439 + 160,280 + 151,004)
÷ 252,399 = 2.55
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. | Walmart Inc. total asset turnover ratio deteriorated from Q2 2024 to Q3 2024 but then improved from Q3 2024 to Q4 2024 exceeding Q2 2024 level. |
Equity Turnover
Walmart Inc., equity turnover calculation (quarterly data)
| Jan 31, 2024 | Oct 31, 2023 | Jul 31, 2023 | Apr 30, 2023 | Jan 31, 2023 | Oct 31, 2022 | Jul 31, 2022 | Apr 30, 2022 | Jan 31, 2022 | Oct 31, 2021 | Jul 31, 2021 | Apr 30, 2021 | Jan 31, 2021 | Oct 31, 2020 | Jul 31, 2020 | Apr 30, 2020 | Jan 31, 2020 | Oct 31, 2019 | Jul 31, 2019 | Apr 30, 2019 | Jan 31, 2019 | Oct 31, 2018 | Jul 31, 2018 | Apr 30, 2018 | ||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Selected Financial Data (US$ in millions) | |||||||||||||||||||||||||||||||
| Net sales | 171,914) | 159,439) | 160,280) | 151,004) | 162,743) | 151,469) | 151,381) | 140,288) | 151,525) | 139,207) | 139,871) | 137,159) | 150,985) | 133,752) | 136,824) | 133,672) | 140,608) | 126,981) | 129,388) | 122,949) | 137,743) | 123,897) | 127,059) | 121,630) | |||||||
| Total Walmart shareholders’ equity | 83,861) | 79,456) | 79,556) | 72,405) | 76,693) | 72,253) | 77,569) | 76,896) | 83,253) | 82,274) | 80,529) | 78,335) | 80,925) | 81,431) | 75,310) | 68,240) | 74,669) | 71,649) | 70,327) | 68,205) | 72,496) | 71,996) | 71,185) | 75,552) | |||||||
| Long-term Activity Ratio | |||||||||||||||||||||||||||||||
| Equity turnover1 | 7.66 | 7.97 | 7.86 | 8.52 | 7.90 | 8.23 | 7.51 | 7.42 | 6.82 | 6.89 | 6.98 | 7.13 | 6.86 | 6.69 | 7.14 | 7.78 | 6.96 | 7.22 | 7.31 | 7.50 | 7.04 | — | — | — | |||||||
| Benchmarks | |||||||||||||||||||||||||||||||
| Equity Turnover, Competitors2 | |||||||||||||||||||||||||||||||
| Costco Wholesale Corp. | — | — | 11.76 | 9.22 | 9.49 | 9.80 | 10.09 | 10.56 | 10.79 | 10.69 | 10.62 | 10.78 | 10.93 | 11.10 | 11.18 | 11.40 | 8.93 | 9.37 | 9.32 | 9.54 | 9.80 | 10.10 | 10.39 | 10.76 | |||||||
| Target Corp. | 7.88 | 8.42 | 8.88 | 9.28 | 9.58 | 9.73 | 10.04 | 9.80 | 8.16 | 7.39 | 6.66 | 6.48 | 6.40 | 6.57 | 6.65 | 7.08 | 6.52 | 6.65 | 6.41 | 6.77 | 6.59 | — | — | — | |||||||
Based on: 10-K (reporting date: 2024-01-31), 10-Q (reporting date: 2023-10-31), 10-Q (reporting date: 2023-07-31), 10-Q (reporting date: 2023-04-30), 10-K (reporting date: 2023-01-31), 10-Q (reporting date: 2022-10-31), 10-Q (reporting date: 2022-07-31), 10-Q (reporting date: 2022-04-30), 10-K (reporting date: 2022-01-31), 10-Q (reporting date: 2021-10-31), 10-Q (reporting date: 2021-07-31), 10-Q (reporting date: 2021-04-30), 10-K (reporting date: 2021-01-31), 10-Q (reporting date: 2020-10-31), 10-Q (reporting date: 2020-07-31), 10-Q (reporting date: 2020-04-30), 10-K (reporting date: 2020-01-31), 10-Q (reporting date: 2019-10-31), 10-Q (reporting date: 2019-07-31), 10-Q (reporting date: 2019-04-30), 10-K (reporting date: 2019-01-31), 10-Q (reporting date: 2018-10-31), 10-Q (reporting date: 2018-07-31), 10-Q (reporting date: 2018-04-30).
1 Q4 2024 Calculation
Equity turnover
= (Net salesQ4 2024
+ Net salesQ3 2024
+ Net salesQ2 2024
+ Net salesQ1 2024)
÷ Total Walmart shareholders’ equity
= (171,914 + 159,439 + 160,280 + 151,004)
÷ 83,861 = 7.66
2 Click competitor name to see calculations.
| Long-term activity ratio | Description | The company |
|---|---|---|
| Equity turnover | An activity ratio calculated as total revenue divided by shareholders’ equity. | Walmart Inc. equity turnover ratio improved from Q2 2024 to Q3 2024 but then deteriorated significantly from Q3 2024 to Q4 2024. |