Stock Analysis on Net
Stock Analysis on Net
Microsoft Excel LibreOffice Calc

Walmart Inc. (NYSE:WMT)

Analysis of Liquidity Ratios

Beginner level


Liquidity Ratios (Summary)

Walmart Inc., liquidity ratios

Microsoft Excel LibreOffice Calc
Jan 31, 2020 Jan 31, 2019 Jan 31, 2018 Jan 31, 2017 Jan 31, 2016 Jan 31, 2015
Current ratio 0.79 0.80 0.76 0.86 0.93 0.97
Quick ratio 0.20 0.18 0.16 0.19 0.22 0.24
Cash ratio 0.12 0.10 0.09 0.10 0.13 0.14

Based on: 10-K (filing date: 2020-03-20), 10-K (filing date: 2019-03-28), 10-K (filing date: 2018-03-30), 10-K (filing date: 2017-03-31), 10-K (filing date: 2016-03-30), 10-K (filing date: 2015-04-01).

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

Current Ratio

Walmart Inc., current ratio calculation, comparison to benchmarks

Microsoft Excel LibreOffice Calc
Jan 31, 2020 Jan 31, 2019 Jan 31, 2018 Jan 31, 2017 Jan 31, 2016 Jan 31, 2015
Selected Financial Data (US$ in millions)
Current assets 61,806  61,897  59,664  57,689  60,239  63,278 
Current liabilities 77,790  77,477  78,521  66,928  64,619  65,272 
Liquidity Ratio
Current ratio1 0.79 0.80 0.76 0.86 0.93 0.97
Benchmarks
Current Ratio, Competitors2
Amazon.com Inc. 1.10 1.10 1.04 1.04 1.08
Costco Wholesale Corp. 1.01 1.02 0.99 0.98 1.05
Dollar General Corp. 1.14 1.55 1.43 1.40 1.72 1.78
Home Depot Inc. 1.08 1.11 1.17 1.25 1.36 1.36
Lowe’s Cos. Inc. 1.01 0.98 1.06 1.00 1.01 1.08
Target Corp. 0.89 0.83 0.95 0.94 1.12 1.20
TJX Cos. Inc. 1.24 1.53 1.66 1.63 1.54 1.71
Current Ratio, Sector
General Retailers 0.99 0.98 1.00 1.04 1.08
Current Ratio, Industry
Consumer Services 0.96 0.99 0.98 1.02 1.11

Based on: 10-K (filing date: 2020-03-20), 10-K (filing date: 2019-03-28), 10-K (filing date: 2018-03-30), 10-K (filing date: 2017-03-31), 10-K (filing date: 2016-03-30), 10-K (filing date: 2015-04-01).

1 2020 Calculation
Current ratio = Current assets ÷ Current liabilities
= 61,806 ÷ 77,790 = 0.79

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.’s current ratio improved from 2018 to 2019 but then slightly deteriorated from 2019 to 2020.

Quick Ratio

Walmart Inc., quick ratio calculation, comparison to benchmarks

Microsoft Excel LibreOffice Calc
Jan 31, 2020 Jan 31, 2019 Jan 31, 2018 Jan 31, 2017 Jan 31, 2016 Jan 31, 2015
Selected Financial Data (US$ in millions)
Cash and cash equivalents 9,465  7,722  6,756  6,867  8,705  9,135 
Receivables, net 6,284  6,283  5,614  5,835  5,624  6,778 
Total quick assets 15,749  14,005  12,370  12,702  14,329  15,913 
 
Current liabilities 77,790  77,477  78,521  66,928  64,619  65,272 
Liquidity Ratio
Quick ratio1 0.20 0.18 0.16 0.19 0.22 0.24
Benchmarks
Quick Ratio, Competitors2
Amazon.com Inc. 0.83 0.80 0.70 0.74 0.71
Costco Wholesale Corp. 0.47 0.45 0.41 0.38 0.46
Dollar General Corp. 0.05 0.08 0.09 0.07 0.08 0.29
Home Depot Inc. 0.23 0.22 0.34 0.32 0.33 0.28
Lowe’s Cos. Inc. 0.06 0.05 0.06 0.05 0.07 0.06
Target Corp. 0.21 0.13 0.23 0.23 0.35 0.23
TJX Cos. Inc. 0.50 0.61 0.70 0.78 0.61 0.76
Quick Ratio, Sector
General Retailers 0.44 0.41 0.39 0.39 0.38
Quick Ratio, Industry
Consumer Services 0.51 0.50 0.47 0.47 0.49

Based on: 10-K (filing date: 2020-03-20), 10-K (filing date: 2019-03-28), 10-K (filing date: 2018-03-30), 10-K (filing date: 2017-03-31), 10-K (filing date: 2016-03-30), 10-K (filing date: 2015-04-01).

1 2020 Calculation
Quick ratio = Total quick assets ÷ Current liabilities
= 15,749 ÷ 77,790 = 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.’s quick ratio improved from 2018 to 2019 and from 2019 to 2020.

Cash Ratio

Walmart Inc., cash ratio calculation, comparison to benchmarks

Microsoft Excel LibreOffice Calc
Jan 31, 2020 Jan 31, 2019 Jan 31, 2018 Jan 31, 2017 Jan 31, 2016 Jan 31, 2015
Selected Financial Data (US$ in millions)
Cash and cash equivalents 9,465  7,722  6,756  6,867  8,705  9,135 
Total cash assets 9,465  7,722  6,756  6,867  8,705  9,135 
 
Current liabilities 77,790  77,477  78,521  66,928  64,619  65,272 
Liquidity Ratio
Cash ratio1 0.12 0.10 0.09 0.10 0.13 0.14
Benchmarks
Cash Ratio, Competitors2
Amazon.com Inc. 0.63 0.60 0.54 0.59 0.58
Costco Wholesale Corp. 0.41 0.36 0.33 0.30 0.39
Dollar General Corp. 0.05 0.08 0.09 0.07 0.08 0.29
Home Depot Inc. 0.12 0.11 0.22 0.18 0.18 0.15
Lowe’s Cos. Inc. 0.06 0.05 0.06 0.05 0.07 0.06
Target Corp. 0.18 0.10 0.20 0.20 0.32 0.19
TJX Cos. Inc. 0.45 0.55 0.64 0.73 0.56 0.71
Cash Ratio, Sector
General Retailers 0.33 0.30 0.28 0.30 0.28
Cash Ratio, Industry
Consumer Services 0.30 0.30 0.27 0.28 0.30

Based on: 10-K (filing date: 2020-03-20), 10-K (filing date: 2019-03-28), 10-K (filing date: 2018-03-30), 10-K (filing date: 2017-03-31), 10-K (filing date: 2016-03-30), 10-K (filing date: 2015-04-01).

1 2020 Calculation
Cash ratio = Total cash assets ÷ Current liabilities
= 9,465 ÷ 77,790 = 0.12

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.’s cash ratio improved from 2018 to 2019 and from 2019 to 2020.