Stock Analysis on Net

Walmart Inc. (NYSE:WMT)

Analysis of Liquidity Ratios 

Microsoft Excel

Liquidity Ratios (Summary)

Walmart Inc., liquidity ratios

Microsoft Excel
Jan 31, 2024 Jan 31, 2023 Jan 31, 2022 Jan 31, 2021 Jan 31, 2020 Jan 31, 2019
Current ratio 0.83 0.82 0.93 0.97 0.79 0.80
Quick ratio 0.20 0.18 0.26 0.26 0.20 0.18
Cash ratio 0.11 0.09 0.17 0.19 0.12 0.10

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

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

Current Ratio

Walmart Inc., current ratio calculation, comparison to benchmarks

Microsoft Excel
Jan 31, 2024 Jan 31, 2023 Jan 31, 2022 Jan 31, 2021 Jan 31, 2020 Jan 31, 2019
Selected Financial Data (US$ in millions)
Current assets 76,877 75,655 81,070 90,067 61,806 61,897
Current liabilities 92,415 92,198 87,379 92,645 77,790 77,477
Liquidity Ratio
Current ratio1 0.83 0.82 0.93 0.97 0.79 0.80
Benchmarks
Current Ratio, Competitors2
Costco Wholesale Corp. 1.07 1.02 1.00 1.13 1.01
Target Corp. 0.91 0.92 0.99 1.03 0.89 0.83
Current Ratio, Sector
Consumer Staples Distribution & Retail 0.89 0.96 0.99 0.88 0.85
Current Ratio, Industry
Consumer Staples 0.85 0.89 0.93 0.90 0.80

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

1 2024 Calculation
Current ratio = Current assets ÷ Current liabilities
= 76,877 ÷ 92,415 = 0.83

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 deteriorated from 2022 to 2023 but then slightly improved from 2023 to 2024.

Quick Ratio

Walmart Inc., quick ratio calculation, comparison to benchmarks

Microsoft Excel
Jan 31, 2024 Jan 31, 2023 Jan 31, 2022 Jan 31, 2021 Jan 31, 2020 Jan 31, 2019
Selected Financial Data (US$ in millions)
Cash and cash equivalents 9,867 8,625 14,760 17,741 9,465 7,722
Receivables, net 8,796 7,933 8,280 6,516 6,284 6,283
Total quick assets 18,663 16,558 23,040 24,257 15,749 14,005
 
Current liabilities 92,415 92,198 87,379 92,645 77,790 77,477
Liquidity Ratio
Quick ratio1 0.20 0.18 0.26 0.26 0.20 0.18
Benchmarks
Quick Ratio, Competitors2
Costco Wholesale Corp. 0.52 0.42 0.47 0.60 0.47
Target Corp. 0.27 0.20 0.33 0.48 0.24 0.18
Quick Ratio, Sector
Consumer Staples Distribution & Retail 0.26 0.31 0.34 0.29 0.24
Quick Ratio, Industry
Consumer Staples 0.38 0.39 0.43 0.46 0.36

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

1 2024 Calculation
Quick ratio = Total quick assets ÷ Current liabilities
= 18,663 ÷ 92,415 = 0.20

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 deteriorated from 2022 to 2023 but then slightly improved from 2023 to 2024.

Cash Ratio

Walmart Inc., cash ratio calculation, comparison to benchmarks

Microsoft Excel
Jan 31, 2024 Jan 31, 2023 Jan 31, 2022 Jan 31, 2021 Jan 31, 2020 Jan 31, 2019
Selected Financial Data (US$ in millions)
Cash and cash equivalents 9,867 8,625 14,760 17,741 9,465 7,722
Total cash assets 9,867 8,625 14,760 17,741 9,465 7,722
 
Current liabilities 92,415 92,198 87,379 92,645 77,790 77,477
Liquidity Ratio
Cash ratio1 0.11 0.09 0.17 0.19 0.12 0.10
Benchmarks
Cash Ratio, Competitors2
Costco Wholesale Corp. 0.45 0.35 0.41 0.54 0.41
Target Corp. 0.20 0.11 0.27 0.42 0.18 0.10
Cash Ratio, Sector
Consumer Staples Distribution & Retail 0.18 0.22 0.27 0.22 0.16
Cash Ratio, Industry
Consumer Staples 0.23 0.24 0.30 0.32 0.23

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

1 2024 Calculation
Cash ratio = Total cash assets ÷ Current liabilities
= 9,867 ÷ 92,415 = 0.11

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 deteriorated from 2022 to 2023 but then slightly improved from 2023 to 2024.