Microsoft Excel LibreOffice Calc

Walmart Inc. (WMT)


Liquidity Analysis

Difficulty: Beginner


Ratios (Summary)

Walmart Inc., liquidity ratios

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

Based on: 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), 10-K (filing date: 2014-03-21).

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

Current Ratio

Walmart Inc., current ratio calculation, comparison to benchmarks

Microsoft Excel LibreOffice Calc
Jan 31, 2019 Jan 31, 2018 Jan 31, 2017 Jan 31, 2016 Jan 31, 2015 Jan 31, 2014
Selected Financial Data (US$ in millions)
Current assets 61,897  59,664  57,689  60,239  63,278  61,185 
Current liabilities 77,477  78,521  66,928  64,619  65,272  69,345 
Ratio
Current ratio1 0.80 0.76 0.86 0.93 0.97 0.88
Benchmarks
Current Ratio, Competitors2
Amazon.com Inc. 1.10 1.04 1.04 1.08 1.12
Costco Wholesale Corp. 1.02 0.99 0.98 1.05 1.22
eBay Inc. 1.60 2.19 2.31 3.49 1.51
Home Depot Inc. 1.11 1.17 1.25 1.36 1.36 1.42
Lowe’s Cos. Inc. 0.98 1.06 1.00 1.01 1.08 1.16
Netflix Inc. 1.49 1.40 1.25 1.54 1.48
Target Corp. 0.83 0.95 0.94 1.12 1.20 0.91
TJX Cos. Inc. 1.53 1.66 1.63 1.54 1.71 1.72
Current Ratio, Sector
General Retailers 1.00 1.03 1.07 1.12 1.09
Current Ratio, Industry
Consumer Services 0.94 0.95 1.03 1.08 1.09

Based on: 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), 10-K (filing date: 2014-03-21).

1 2019 Calculation
Current ratio = Current assets ÷ Current liabilities
= 61,897 ÷ 77,477 = 0.80

2 Click competitor name to see calculations.

Ratio Description The company
Current ratio A liquidity ratio calculated as current assets divided by current liabilities. Walmart Inc.’s current ratio deteriorated from 2017 to 2018 but then slightly improved from 2018 to 2019.

Quick Ratio

Walmart Inc., quick ratio calculation, comparison to benchmarks

Microsoft Excel LibreOffice Calc
Jan 31, 2019 Jan 31, 2018 Jan 31, 2017 Jan 31, 2016 Jan 31, 2015 Jan 31, 2014
Selected Financial Data (US$ in millions)
Cash and cash equivalents 7,722  6,756  6,867  8,705  9,135  7,281 
Receivables, net 6,283  5,614  5,835  5,624  6,778  6,677 
Total quick assets 14,005  12,370  12,702  14,329  15,913  13,958 
 
Current liabilities 77,477  78,521  66,928  64,619  65,272  69,345 
Ratio
Quick ratio1 0.18 0.16 0.19 0.22 0.24 0.20
Benchmarks
Quick Ratio, Competitors2
Amazon.com Inc. 0.80 0.70 0.74 0.71 0.74
Costco Wholesale Corp. 0.45 0.41 0.38 0.46 0.59
eBay Inc. 1.26 1.85 2.01 2.98 1.43
Home Depot Inc. 0.22 0.34 0.32 0.33 0.28 0.31
Lowe’s Cos. Inc. 0.05 0.06 0.05 0.07 0.06 0.06
Netflix Inc. 0.58 0.52 0.38 0.65 0.60
Target Corp. 0.13 0.23 0.23 0.35 0.23 0.10
TJX Cos. Inc. 0.61 0.70 0.78 0.61 0.76 0.75
Quick Ratio, Sector
General Retailers 0.44 0.42 0.43 0.42 0.46
Quick Ratio, Industry
Consumer Services 0.49 0.48 0.52 0.51 0.53

Based on: 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), 10-K (filing date: 2014-03-21).

1 2019 Calculation
Quick ratio = Total quick assets ÷ Current liabilities
= 14,005 ÷ 77,477 = 0.18

2 Click competitor name to see calculations.

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 deteriorated from 2017 to 2018 but then improved from 2018 to 2019 not reaching 2017 level.

Cash Ratio

Walmart Inc., cash ratio calculation, comparison to benchmarks

Microsoft Excel LibreOffice Calc
Jan 31, 2019 Jan 31, 2018 Jan 31, 2017 Jan 31, 2016 Jan 31, 2015 Jan 31, 2014
Selected Financial Data (US$ in millions)
Cash and cash equivalents 7,722  6,756  6,867  8,705  9,135  7,281 
Total cash assets 7,722  6,756  6,867  8,705  9,135  7,281 
 
Current liabilities 77,477  78,521  66,928  64,619  65,272  69,345 
Ratio
Cash ratio1 0.10 0.09 0.10 0.13 0.14 0.10
Benchmarks
Cash Ratio, Competitors2
Amazon.com Inc. 0.60 0.54 0.59 0.58 0.62
Costco Wholesale Corp. 0.36 0.33 0.30 0.39 0.51
eBay Inc. 1.10 1.66 1.86 2.71 0.58
Home Depot Inc. 0.11 0.22 0.18 0.18 0.15 0.18
Lowe’s Cos. Inc. 0.05 0.06 0.05 0.07 0.06 0.06
Netflix Inc. 0.58 0.52 0.38 0.65 0.60
Target Corp. 0.10 0.20 0.20 0.32 0.19 0.05
TJX Cos. Inc. 0.55 0.64 0.73 0.56 0.71 0.69
Cash Ratio, Sector
General Retailers 0.33 0.32 0.33 0.32 0.29
Cash Ratio, Industry
Consumer Services 0.28 0.27 0.31 0.30 0.29

Based on: 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), 10-K (filing date: 2014-03-21).

1 2019 Calculation
Cash ratio = Total cash assets ÷ Current liabilities
= 7,722 ÷ 77,477 = 0.10

2 Click competitor name to see calculations.

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 deteriorated from 2017 to 2018 but then improved from 2018 to 2019 not reaching 2017 level.