Stock Analysis on Net

Walmart Inc. (NYSE:WMT)

Analysis of Liquidity Ratios 

Microsoft Excel LibreOffice Calc

Liquidity Ratios (Summary)

Walmart Inc., liquidity ratios

Microsoft Excel LibreOffice Calc
Jan 31, 2022 Jan 31, 2021 Jan 31, 2020 Jan 31, 2019 Jan 31, 2018 Jan 31, 2017
Current ratio 0.93 0.97 0.79 0.80 0.76 0.86
Quick ratio 0.26 0.26 0.20 0.18 0.16 0.19
Cash ratio 0.17 0.19 0.12 0.10 0.09 0.10

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

Liquidity ratio Description The company
Current ratio A liquidity ratio calculated as current assets divided by current liabilities. Walmart Inc. current ratio improved from 2020 to 2021 but then slightly deteriorated from 2021 to 2022.
Quick ratio A liquidity ratio calculated as (cash plus short-term marketable investments plus receivables) divided by current liabilities. Walmart Inc. quick ratio improved from 2020 to 2021 and from 2021 to 2022.
Cash ratio A liquidity ratio calculated as (cash plus short-term marketable investments) divided by current liabilities. Walmart Inc. cash ratio improved from 2020 to 2021 but then slightly deteriorated from 2021 to 2022.

Current Ratio

Walmart Inc., current ratio calculation, comparison to benchmarks

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)
Current assets 81,070  90,067  61,806  61,897  59,664  57,689 
Current liabilities 87,379  92,645  77,790  77,477  78,521  66,928 
Liquidity Ratio
Current ratio1 0.93 0.97 0.79 0.80 0.76 0.86
Benchmarks
Current Ratio, Competitors2
Costco Wholesale Corp. 1.00 1.13 1.01 1.02 0.99
Current Ratio, Sector
Food & Staples Retailing 0.98 0.88 0.85 0.81 0.89
Current Ratio, Industry
Consumer Staples 0.91 0.91 0.81 0.80 1.01

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
Current ratio = Current assets ÷ Current liabilities
= 81,070 ÷ 87,379 = 0.93

2 Click competitor name to see calculations.

Liquidity ratio Description The company
Current ratio A liquidity ratio calculated as current assets divided by current liabilities. Walmart Inc. current ratio improved from 2020 to 2021 but then slightly deteriorated from 2021 to 2022.

Quick Ratio

Walmart Inc., quick ratio calculation, comparison to benchmarks

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)
Cash and cash equivalents 14,760  17,741  9,465  7,722  6,756  6,867 
Receivables, net 8,280  6,516  6,284  6,283  5,614  5,835 
Total quick assets 23,040  24,257  15,749  14,005  12,370  12,702 
 
Current liabilities 87,379  92,645  77,790  77,477  78,521  66,928 
Liquidity Ratio
Quick ratio1 0.26 0.26 0.20 0.18 0.16 0.19
Benchmarks
Quick Ratio, Competitors2
Costco Wholesale Corp. 0.47 0.60 0.47 0.45 0.41
Quick Ratio, Sector
Food & Staples Retailing 0.31 0.30 0.25 0.22 0.24
Quick Ratio, Industry
Consumer Staples 0.43 0.49 0.39 0.39 0.54

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
Quick ratio = Total quick assets ÷ Current liabilities
= 23,040 ÷ 87,379 = 0.26

2 Click competitor name to see calculations.

Liquidity ratio Description The company
Quick ratio A liquidity ratio calculated as (cash plus short-term marketable investments plus receivables) divided by current liabilities. Walmart Inc. quick ratio improved from 2020 to 2021 and from 2021 to 2022.

Cash Ratio

Walmart Inc., cash ratio calculation, comparison to benchmarks

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)
Cash and cash equivalents 14,760  17,741  9,465  7,722  6,756  6,867 
Total cash assets 14,760  17,741  9,465  7,722  6,756  6,867 
 
Current liabilities 87,379  92,645  77,790  77,477  78,521  66,928 
Liquidity Ratio
Cash ratio1 0.17 0.19 0.12 0.10 0.09 0.10
Benchmarks
Cash Ratio, Competitors2
Costco Wholesale Corp. 0.41 0.54 0.41 0.36 0.33
Cash Ratio, Sector
Food & Staples Retailing 0.25 0.22 0.17 0.14 0.15
Cash Ratio, Industry
Consumer Staples 0.29 0.35 0.25 0.27 0.39

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
Cash ratio = Total cash assets ÷ Current liabilities
= 14,760 ÷ 87,379 = 0.17

2 Click competitor name to see calculations.

Liquidity ratio Description The company
Cash ratio A liquidity ratio calculated as (cash plus short-term marketable investments) divided by current liabilities. Walmart Inc. cash ratio improved from 2020 to 2021 but then slightly deteriorated from 2021 to 2022.