Microsoft Excel LibreOffice Calc

Walmart Inc. (NYSE:WMT)

Paying users zone. Data is hidden behind: .

We accept:

Visa Mastercard American Express Maestro Discover JCB PayPal Apple Pay Google Pay
Verified by Visa MasterCard SecureCode American Express SafeKey
Unlock

This is a one-time payment. There is no automatic renewal.

Analysis of Long-term (Investment) Activity Ratios
Quarterly Data

Beginner level

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)

Microsoft Excel LibreOffice Calc
Jan 31, 2020 Oct 31, 2019 Jul 31, 2019 Apr 30, 2019 Jan 31, 2019 Oct 31, 2018 Jul 31, 2018 Apr 30, 2018 Jan 31, 2018 Oct 31, 2017 Jul 31, 2017 Apr 30, 2017 Jan 31, 2017 Oct 31, 2016 Jul 31, 2016 Apr 30, 2016 Jan 31, 2016 Oct 31, 2015 Jul 31, 2015 Apr 30, 2015 Jan 31, 2015 Oct 31, 2014 Jul 31, 2014 Apr 30, 2014
Net fixed asset turnover
Net fixed asset turnover (including operating lease, right-of-use asset)
Total asset turnover
Equity turnover

Based on: 10-K (filing date: 2020-03-20), 10-Q (filing date: 2019-12-04), 10-Q (filing date: 2019-09-06), 10-Q (filing date: 2019-06-07), 10-K (filing date: 2019-03-28), 10-Q (filing date: 2018-11-30), 10-Q (filing date: 2018-09-06), 10-Q (filing date: 2018-06-04), 10-K (filing date: 2018-03-30), 10-Q (filing date: 2017-12-01), 10-Q (filing date: 2017-08-31), 10-Q (filing date: 2017-06-02), 10-K (filing date: 2017-03-31), 10-Q (filing date: 2016-12-01), 10-Q (filing date: 2016-08-31), 10-Q (filing date: 2016-06-03), 10-K (filing date: 2016-03-30), 10-Q (filing date: 2015-12-02), 10-Q (filing date: 2015-09-09), 10-Q (filing date: 2015-06-05), 10-K (filing date: 2015-04-01), 10-Q (filing date: 2014-12-01), 10-Q (filing date: 2014-09-05), 10-Q (filing date: 2014-06-06).

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.’s net fixed asset turnover ratio improved from Q2 2020 to Q3 2020 but then slightly deteriorated from Q3 2020 to Q4 2020 not reaching Q2 2020 level.
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.’s net fixed asset turnover ratio (with operating lease, right-of-use asset) improved from Q2 2020 to Q3 2020 but then slightly deteriorated from Q3 2020 to Q4 2020 not reaching Q2 2020 level.
Total asset turnover An activity ratio calculated as total revenue divided by total assets. Walmart Inc.’s total asset turnover ratio deteriorated from Q2 2020 to Q3 2020 but then improved from Q3 2020 to Q4 2020 exceeding Q2 2020 level.
Equity turnover An activity ratio calculated as total revenue divided by shareholders’ equity. Walmart Inc.’s equity turnover ratio deteriorated from Q2 2020 to Q3 2020 and from Q3 2020 to Q4 2020.

Net Fixed Asset Turnover

Walmart Inc., net fixed asset turnover calculation (quarterly data)

Microsoft Excel LibreOffice Calc
Jan 31, 2020 Oct 31, 2019 Jul 31, 2019 Apr 30, 2019 Jan 31, 2019 Oct 31, 2018 Jul 31, 2018 Apr 30, 2018 Jan 31, 2018 Oct 31, 2017 Jul 31, 2017 Apr 30, 2017 Jan 31, 2017 Oct 31, 2016 Jul 31, 2016 Apr 30, 2016 Jan 31, 2016 Oct 31, 2015 Jul 31, 2015 Apr 30, 2015 Jan 31, 2015 Oct 31, 2014 Jul 31, 2014 Apr 30, 2014
Selected Financial Data (US$ in millions)
Net sales
Property and equipment, including finance lease right-of-use assets, net
Long-term Activity Ratio
Net fixed asset turnover1
Benchmarks
Net Fixed Asset Turnover, Competitors2
Amazon.com Inc.
Costco Wholesale Corp.
Dollar General Corp.
Home Depot Inc.
Lowe’s Cos. Inc.
Target Corp.
TJX Cos. Inc.

Based on: 10-K (filing date: 2020-03-20), 10-Q (filing date: 2019-12-04), 10-Q (filing date: 2019-09-06), 10-Q (filing date: 2019-06-07), 10-K (filing date: 2019-03-28), 10-Q (filing date: 2018-11-30), 10-Q (filing date: 2018-09-06), 10-Q (filing date: 2018-06-04), 10-K (filing date: 2018-03-30), 10-Q (filing date: 2017-12-01), 10-Q (filing date: 2017-08-31), 10-Q (filing date: 2017-06-02), 10-K (filing date: 2017-03-31), 10-Q (filing date: 2016-12-01), 10-Q (filing date: 2016-08-31), 10-Q (filing date: 2016-06-03), 10-K (filing date: 2016-03-30), 10-Q (filing date: 2015-12-02), 10-Q (filing date: 2015-09-09), 10-Q (filing date: 2015-06-05), 10-K (filing date: 2015-04-01), 10-Q (filing date: 2014-12-01), 10-Q (filing date: 2014-09-05), 10-Q (filing date: 2014-06-06).

1 Q4 2020 Calculation
Net fixed asset turnover = (Net salesQ4 2020 + Net salesQ3 2020 + Net salesQ2 2020 + Net salesQ1 2020) ÷ Property and equipment, including finance lease right-of-use assets, net
= ( + + + ) ÷ =

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.’s net fixed asset turnover ratio improved from Q2 2020 to Q3 2020 but then slightly deteriorated from Q3 2020 to Q4 2020 not reaching Q2 2020 level.

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)

Microsoft Excel LibreOffice Calc
Jan 31, 2020 Oct 31, 2019 Jul 31, 2019 Apr 30, 2019 Jan 31, 2019 Oct 31, 2018 Jul 31, 2018 Apr 30, 2018 Jan 31, 2018 Oct 31, 2017 Jul 31, 2017 Apr 30, 2017 Jan 31, 2017 Oct 31, 2016 Jul 31, 2016 Apr 30, 2016 Jan 31, 2016 Oct 31, 2015 Jul 31, 2015 Apr 30, 2015 Jan 31, 2015 Oct 31, 2014 Jul 31, 2014 Apr 30, 2014
Selected Financial Data (US$ in millions)
Net sales
 
Property and equipment, including finance lease right-of-use assets, net
Operating lease right-of-use assets, net
Property and equipment, including finance lease right-of-use assets, net (including operating lease, right-of-use asset)
Long-term Activity Ratio
Net fixed asset turnover (including operating lease, right-of-use asset)1
Benchmarks
Net Fixed Asset Turnover (including Operating Lease, Right-of-Use Asset), Competitors2
Amazon.com Inc.
Costco Wholesale Corp.
Dollar General Corp.
Home Depot Inc.
Lowe’s Cos. Inc.
Target Corp.
TJX Cos. Inc.

Based on: 10-K (filing date: 2020-03-20), 10-Q (filing date: 2019-12-04), 10-Q (filing date: 2019-09-06), 10-Q (filing date: 2019-06-07), 10-K (filing date: 2019-03-28), 10-Q (filing date: 2018-11-30), 10-Q (filing date: 2018-09-06), 10-Q (filing date: 2018-06-04), 10-K (filing date: 2018-03-30), 10-Q (filing date: 2017-12-01), 10-Q (filing date: 2017-08-31), 10-Q (filing date: 2017-06-02), 10-K (filing date: 2017-03-31), 10-Q (filing date: 2016-12-01), 10-Q (filing date: 2016-08-31), 10-Q (filing date: 2016-06-03), 10-K (filing date: 2016-03-30), 10-Q (filing date: 2015-12-02), 10-Q (filing date: 2015-09-09), 10-Q (filing date: 2015-06-05), 10-K (filing date: 2015-04-01), 10-Q (filing date: 2014-12-01), 10-Q (filing date: 2014-09-05), 10-Q (filing date: 2014-06-06).

1 Q4 2020 Calculation
Net fixed asset turnover (including operating lease, right-of-use asset) = (Net salesQ4 2020 + Net salesQ3 2020 + Net salesQ2 2020 + Net salesQ1 2020) ÷ Property and equipment, including finance lease right-of-use assets, net (including operating lease, right-of-use asset)
= ( + + + ) ÷ =

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.’s net fixed asset turnover ratio (with operating lease, right-of-use asset) improved from Q2 2020 to Q3 2020 but then slightly deteriorated from Q3 2020 to Q4 2020 not reaching Q2 2020 level.

Total Asset Turnover

Walmart Inc., total asset turnover calculation (quarterly data)

Microsoft Excel LibreOffice Calc
Jan 31, 2020 Oct 31, 2019 Jul 31, 2019 Apr 30, 2019 Jan 31, 2019 Oct 31, 2018 Jul 31, 2018 Apr 30, 2018 Jan 31, 2018 Oct 31, 2017 Jul 31, 2017 Apr 30, 2017 Jan 31, 2017 Oct 31, 2016 Jul 31, 2016 Apr 30, 2016 Jan 31, 2016 Oct 31, 2015 Jul 31, 2015 Apr 30, 2015 Jan 31, 2015 Oct 31, 2014 Jul 31, 2014 Apr 30, 2014
Selected Financial Data (US$ in millions)
Net sales
Total assets
Long-term Activity Ratio
Total asset turnover1
Benchmarks
Total Asset Turnover, Competitors2
Amazon.com Inc.
Costco Wholesale Corp.
Dollar General Corp.
Home Depot Inc.
Lowe’s Cos. Inc.
Target Corp.
TJX Cos. Inc.

Based on: 10-K (filing date: 2020-03-20), 10-Q (filing date: 2019-12-04), 10-Q (filing date: 2019-09-06), 10-Q (filing date: 2019-06-07), 10-K (filing date: 2019-03-28), 10-Q (filing date: 2018-11-30), 10-Q (filing date: 2018-09-06), 10-Q (filing date: 2018-06-04), 10-K (filing date: 2018-03-30), 10-Q (filing date: 2017-12-01), 10-Q (filing date: 2017-08-31), 10-Q (filing date: 2017-06-02), 10-K (filing date: 2017-03-31), 10-Q (filing date: 2016-12-01), 10-Q (filing date: 2016-08-31), 10-Q (filing date: 2016-06-03), 10-K (filing date: 2016-03-30), 10-Q (filing date: 2015-12-02), 10-Q (filing date: 2015-09-09), 10-Q (filing date: 2015-06-05), 10-K (filing date: 2015-04-01), 10-Q (filing date: 2014-12-01), 10-Q (filing date: 2014-09-05), 10-Q (filing date: 2014-06-06).

1 Q4 2020 Calculation
Total asset turnover = (Net salesQ4 2020 + Net salesQ3 2020 + Net salesQ2 2020 + Net salesQ1 2020) ÷ Total assets
= ( + + + ) ÷ =

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.’s total asset turnover ratio deteriorated from Q2 2020 to Q3 2020 but then improved from Q3 2020 to Q4 2020 exceeding Q2 2020 level.

Equity Turnover

Walmart Inc., equity turnover calculation (quarterly data)

Microsoft Excel LibreOffice Calc
Jan 31, 2020 Oct 31, 2019 Jul 31, 2019 Apr 30, 2019 Jan 31, 2019 Oct 31, 2018 Jul 31, 2018 Apr 30, 2018 Jan 31, 2018 Oct 31, 2017 Jul 31, 2017 Apr 30, 2017 Jan 31, 2017 Oct 31, 2016 Jul 31, 2016 Apr 30, 2016 Jan 31, 2016 Oct 31, 2015 Jul 31, 2015 Apr 30, 2015 Jan 31, 2015 Oct 31, 2014 Jul 31, 2014 Apr 30, 2014
Selected Financial Data (US$ in millions)
Net sales
Total Walmart shareholders’ equity
Long-term Activity Ratio
Equity turnover1
Benchmarks
Equity Turnover, Competitors2
Amazon.com Inc.
Costco Wholesale Corp.
Dollar General Corp.
Home Depot Inc.
Lowe’s Cos. Inc.
Target Corp.
TJX Cos. Inc.

Based on: 10-K (filing date: 2020-03-20), 10-Q (filing date: 2019-12-04), 10-Q (filing date: 2019-09-06), 10-Q (filing date: 2019-06-07), 10-K (filing date: 2019-03-28), 10-Q (filing date: 2018-11-30), 10-Q (filing date: 2018-09-06), 10-Q (filing date: 2018-06-04), 10-K (filing date: 2018-03-30), 10-Q (filing date: 2017-12-01), 10-Q (filing date: 2017-08-31), 10-Q (filing date: 2017-06-02), 10-K (filing date: 2017-03-31), 10-Q (filing date: 2016-12-01), 10-Q (filing date: 2016-08-31), 10-Q (filing date: 2016-06-03), 10-K (filing date: 2016-03-30), 10-Q (filing date: 2015-12-02), 10-Q (filing date: 2015-09-09), 10-Q (filing date: 2015-06-05), 10-K (filing date: 2015-04-01), 10-Q (filing date: 2014-12-01), 10-Q (filing date: 2014-09-05), 10-Q (filing date: 2014-06-06).

1 Q4 2020 Calculation
Equity turnover = (Net salesQ4 2020 + Net salesQ3 2020 + Net salesQ2 2020 + Net salesQ1 2020) ÷ Total Walmart shareholders’ equity
= ( + + + ) ÷ =

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.’s equity turnover ratio deteriorated from Q2 2020 to Q3 2020 and from Q3 2020 to Q4 2020.