Stock Analysis on Net
Stock Analysis on Net

Amazon.com Inc. (NASDAQ:AMZN)

Analysis of Liquidity Ratios
Quarterly Data

Beginner level

Liquidity Ratios (Summary)

Amazon.com Inc., liquidity ratios (quarterly data)

Microsoft Excel LibreOffice Calc
Dec 31, 2020 Sep 30, 2020 Jun 30, 2020 Mar 31, 2020 Dec 31, 2019 Sep 30, 2019 Jun 30, 2019 Mar 31, 2019 Dec 31, 2018 Sep 30, 2018 Jun 30, 2018 Mar 31, 2018 Dec 31, 2017 Sep 30, 2017 Jun 30, 2017 Mar 31, 2017 Dec 31, 2016 Sep 30, 2016 Jun 30, 2016 Mar 31, 2016
Current ratio 1.05 1.11 1.18 1.08 1.10 1.10 1.10 1.09 1.10 1.08 1.07 1.06 1.04 1.03 1.01 1.06 1.04 1.06 1.09 1.08
Quick ratio 0.67 0.67 0.76 0.62 0.63 0.60 0.60 0.58 0.60 0.54 0.53 0.52 0.54 0.52 0.53 0.58 0.59 0.55 0.56 0.56
Cash ratio 0.67 0.67 0.76 0.62 0.63 0.60 0.60 0.58 0.60 0.54 0.53 0.52 0.54 0.52 0.53 0.58 0.59 0.55 0.56 0.56

Based on: 10-K (filing date: 2021-02-03), 10-Q (filing date: 2020-10-30), 10-Q (filing date: 2020-07-31), 10-Q (filing date: 2020-05-01), 10-K (filing date: 2020-01-31), 10-Q (filing date: 2019-10-25), 10-Q (filing date: 2019-07-26), 10-Q (filing date: 2019-04-26), 10-K (filing date: 2019-02-01), 10-Q (filing date: 2018-10-26), 10-Q (filing date: 2018-07-27), 10-Q (filing date: 2018-04-27), 10-K (filing date: 2018-02-02), 10-Q (filing date: 2017-10-27), 10-Q (filing date: 2017-07-28), 10-Q (filing date: 2017-04-28), 10-K (filing date: 2017-02-10), 10-Q (filing date: 2016-10-28), 10-Q (filing date: 2016-07-29), 10-Q (filing date: 2016-04-29).

Liquidity ratio Description The company
Current ratio A liquidity ratio calculated as current assets divided by current liabilities. Amazon.com Inc.’s current ratio deteriorated from Q2 2020 to Q3 2020 and from Q3 2020 to Q4 2020.
Quick ratio A liquidity ratio calculated as (cash plus short-term marketable investments plus receivables) divided by current liabilities. Amazon.com Inc.’s quick ratio deteriorated from Q2 2020 to Q3 2020 and from Q3 2020 to Q4 2020.
Cash ratio A liquidity ratio calculated as (cash plus short-term marketable investments) divided by current liabilities. Amazon.com Inc.’s cash ratio deteriorated from Q2 2020 to Q3 2020 and from Q3 2020 to Q4 2020.

Current Ratio

Amazon.com Inc., current ratio calculation (quarterly data)

Microsoft Excel LibreOffice Calc
Dec 31, 2020 Sep 30, 2020 Jun 30, 2020 Mar 31, 2020 Dec 31, 2019 Sep 30, 2019 Jun 30, 2019 Mar 31, 2019 Dec 31, 2018 Sep 30, 2018 Jun 30, 2018 Mar 31, 2018 Dec 31, 2017 Sep 30, 2017 Jun 30, 2017 Mar 31, 2017 Dec 31, 2016 Sep 30, 2016 Jun 30, 2016 Mar 31, 2016
Selected Financial Data (US$ in millions)
Current assets 132,733  112,969  110,908  85,985  96,334  79,054  76,790  69,431  75,101  59,885  54,481  50,829  60,197  48,578  41,007  39,460  45,781  35,609  32,220  30,513 
Current liabilities 126,385  101,912  93,896  79,711  87,812  72,136  69,678  63,695  68,391  55,324  50,801  48,045  57,883  47,072  40,520  37,399  43,816  33,498  29,587  28,187 
Liquidity Ratio
Current ratio1 1.05 1.11 1.18 1.08 1.10 1.10 1.10 1.09 1.10 1.08 1.07 1.06 1.04 1.03 1.01 1.06 1.04 1.06 1.09 1.08
Benchmarks
Current Ratio, Competitors2
Costco Wholesale Corp. 1.13 1.11 1.04 1.01 1.01 0.98 0.96 1.02 1.02 1.01 1.00 0.98 0.99 0.81 0.93 0.97 0.98 0.97 1.01 1.03
Dollar General Corp. 1.14 1.12 1.14 1.16 1.55 1.55 1.55 1.65 1.43 1.41 1.42 1.39 1.40 1.34 1.36 1.73 1.72 1.75 1.59 1.57
Home Depot Inc. 1.08 1.08 1.10 1.04 1.11 1.09 1.13 1.17 1.17 1.23 1.30 1.21 1.25 1.34 1.30 1.25 1.36 1.16 1.19 1.06
Lowe’s Cos. Inc. 1.01 1.04 1.06 1.09 0.98 1.00 1.06 1.02 1.06 1.02 1.03 1.04 1.00 1.01 1.01 1.17 1.01 1.02 0.94 0.99
Target Corp. 0.89 0.83 0.84 0.88 0.83 0.83 0.82 0.90 0.95 0.96 0.91 0.95 0.94 1.02 1.05 1.16 1.12 1.10 1.15 1.24
TJX Cos. Inc. 1.24 1.22 1.25 1.23 1.53 1.55 1.64 1.69 1.66 1.53 1.63 1.64 1.63 1.62 1.58 1.60 1.54 1.55 1.63 1.66
Walmart Inc. 0.79 0.81 0.76 0.77 0.80 0.81 0.93 0.73 0.76 0.81 0.78 0.77 0.86 0.86 0.85 0.84 0.93 0.92 0.89 0.89

Based on: 10-K (filing date: 2021-02-03), 10-Q (filing date: 2020-10-30), 10-Q (filing date: 2020-07-31), 10-Q (filing date: 2020-05-01), 10-K (filing date: 2020-01-31), 10-Q (filing date: 2019-10-25), 10-Q (filing date: 2019-07-26), 10-Q (filing date: 2019-04-26), 10-K (filing date: 2019-02-01), 10-Q (filing date: 2018-10-26), 10-Q (filing date: 2018-07-27), 10-Q (filing date: 2018-04-27), 10-K (filing date: 2018-02-02), 10-Q (filing date: 2017-10-27), 10-Q (filing date: 2017-07-28), 10-Q (filing date: 2017-04-28), 10-K (filing date: 2017-02-10), 10-Q (filing date: 2016-10-28), 10-Q (filing date: 2016-07-29), 10-Q (filing date: 2016-04-29).

1 Q4 2020 Calculation
Current ratio = Current assets ÷ Current liabilities
= 132,733 ÷ 126,385 = 1.05

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. Amazon.com Inc.’s current ratio deteriorated from Q2 2020 to Q3 2020 and from Q3 2020 to Q4 2020.

Quick Ratio

Amazon.com Inc., quick ratio calculation (quarterly data)

Microsoft Excel LibreOffice Calc
Dec 31, 2020 Sep 30, 2020 Jun 30, 2020 Mar 31, 2020 Dec 31, 2019 Sep 30, 2019 Jun 30, 2019 Mar 31, 2019 Dec 31, 2018 Sep 30, 2018 Jun 30, 2018 Mar 31, 2018 Dec 31, 2017 Sep 30, 2017 Jun 30, 2017 Mar 31, 2017 Dec 31, 2016 Sep 30, 2016 Jun 30, 2016 Mar 31, 2016
Selected Financial Data (US$ in millions)
Cash and cash equivalents 42,122  29,930  37,466  27,201  36,092  23,255  22,616  23,115  31,750  20,425  19,823  16,676  20,522  12,767  13,203  15,440  19,334  13,656  12,521  12,470 
Marketable securities 42,274  38,472  33,925  22,091  18,929  20,146  18,847  13,905  9,500  9,340  7,227  8,287  10,464  11,543  8,248  6,091  6,647  4,691  4,019  3,389 
Total quick assets 84,396  68,402  71,391  49,292  55,021  43,401  41,463  37,020  41,250  29,765  27,050  24,963  30,986  24,310  21,451  21,531  25,981  18,347  16,540  15,859 
 
Current liabilities 126,385  101,912  93,896  79,711  87,812  72,136  69,678  63,695  68,391  55,324  50,801  48,045  57,883  47,072  40,520  37,399  43,816  33,498  29,587  28,187 
Liquidity Ratio
Quick ratio1 0.67 0.67 0.76 0.62 0.63 0.60 0.60 0.58 0.60 0.54 0.53 0.52 0.54 0.52 0.53 0.58 0.59 0.55 0.56 0.56
Benchmarks
Quick Ratio, Competitors2
Costco Wholesale Corp. 0.60 0.58 0.47 0.45 0.47 0.43 0.41 0.43 0.45 0.44 0.41 0.41 0.41 0.34 0.40 0.40 0.38 0.43 0.41 0.42
Dollar General Corp. 0.05 0.06 0.06 0.07 0.08 0.09 0.09 0.11 0.09 0.08 0.08 0.08 0.07 0.07 0.07 0.09 0.08 0.09 0.08 0.11
Home Depot Inc. 0.23 0.23 0.26 0.21 0.22 0.22 0.31 0.33 0.34 0.36 0.44 0.35 0.32 0.39 0.41 0.35 0.33 0.31 0.40 0.27
Lowe’s Cos. Inc. 0.06 0.06 0.13 0.18 0.05 0.12 0.18 0.11 0.06 0.06 0.13 0.14 0.05 0.09 0.16 0.34 0.07 0.11 0.09 0.12
Target Corp. 0.18 0.06 0.12 0.09 0.10 0.05 0.08 0.09 0.20 0.18 0.18 0.22 0.20 0.10 0.13 0.34 0.32 0.14 0.24 0.26
TJX Cos. Inc. 0.50 0.33 0.39 0.40 0.61 0.52 0.63 0.70 0.70 0.59 0.70 0.75 0.78 0.64 0.58 0.61 0.61 0.51 0.60 0.69
Walmart Inc. 0.20 0.17 0.18 0.18 0.18 0.17 0.29 0.15 0.16 0.16 0.16 0.16 0.19 0.15 0.19 0.18 0.22 0.17 0.17 0.19

Based on: 10-K (filing date: 2021-02-03), 10-Q (filing date: 2020-10-30), 10-Q (filing date: 2020-07-31), 10-Q (filing date: 2020-05-01), 10-K (filing date: 2020-01-31), 10-Q (filing date: 2019-10-25), 10-Q (filing date: 2019-07-26), 10-Q (filing date: 2019-04-26), 10-K (filing date: 2019-02-01), 10-Q (filing date: 2018-10-26), 10-Q (filing date: 2018-07-27), 10-Q (filing date: 2018-04-27), 10-K (filing date: 2018-02-02), 10-Q (filing date: 2017-10-27), 10-Q (filing date: 2017-07-28), 10-Q (filing date: 2017-04-28), 10-K (filing date: 2017-02-10), 10-Q (filing date: 2016-10-28), 10-Q (filing date: 2016-07-29), 10-Q (filing date: 2016-04-29).

1 Q4 2020 Calculation
Quick ratio = Total quick assets ÷ Current liabilities
= 84,396 ÷ 126,385 = 0.67

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. Amazon.com Inc.’s quick ratio deteriorated from Q2 2020 to Q3 2020 and from Q3 2020 to Q4 2020.

Cash Ratio

Amazon.com Inc., cash ratio calculation (quarterly data)

Microsoft Excel LibreOffice Calc
Dec 31, 2020 Sep 30, 2020 Jun 30, 2020 Mar 31, 2020 Dec 31, 2019 Sep 30, 2019 Jun 30, 2019 Mar 31, 2019 Dec 31, 2018 Sep 30, 2018 Jun 30, 2018 Mar 31, 2018 Dec 31, 2017 Sep 30, 2017 Jun 30, 2017 Mar 31, 2017 Dec 31, 2016 Sep 30, 2016 Jun 30, 2016 Mar 31, 2016
Selected Financial Data (US$ in millions)
Cash and cash equivalents 42,122  29,930  37,466  27,201  36,092  23,255  22,616  23,115  31,750  20,425  19,823  16,676  20,522  12,767  13,203  15,440  19,334  13,656  12,521  12,470 
Marketable securities 42,274  38,472  33,925  22,091  18,929  20,146  18,847  13,905  9,500  9,340  7,227  8,287  10,464  11,543  8,248  6,091  6,647  4,691  4,019  3,389 
Total cash assets 84,396  68,402  71,391  49,292  55,021  43,401  41,463  37,020  41,250  29,765  27,050  24,963  30,986  24,310  21,451  21,531  25,981  18,347  16,540  15,859 
 
Current liabilities 126,385  101,912  93,896  79,711  87,812  72,136  69,678  63,695  68,391  55,324  50,801  48,045  57,883  47,072  40,520  37,399  43,816  33,498  29,587  28,187 
Liquidity Ratio
Cash ratio1 0.67 0.67 0.76 0.62 0.63 0.60 0.60 0.58 0.60 0.54 0.53 0.52 0.54 0.52 0.53 0.58 0.59 0.55 0.56 0.56
Benchmarks
Cash Ratio, Competitors2
Costco Wholesale Corp. 0.54 0.52 0.38 0.38 0.41 0.36 0.32 0.35 0.36 0.36 0.31 0.34 0.33 0.27 0.32 0.32 0.30 0.35 0.31 0.34
Dollar General Corp. 0.05 0.06 0.06 0.07 0.08 0.09 0.09 0.11 0.09 0.08 0.08 0.08 0.07 0.07 0.07 0.09 0.08 0.09 0.08 0.11
Home Depot Inc. 0.12 0.11 0.14 0.10 0.11 0.10 0.19 0.20 0.22 0.22 0.31 0.22 0.18 0.25 0.28 0.21 0.18 0.19 0.30 0.17
Lowe’s Cos. Inc. 0.06 0.06 0.13 0.18 0.05 0.12 0.18 0.11 0.06 0.06 0.13 0.14 0.05 0.09 0.16 0.34 0.07 0.11 0.09 0.12
Target Corp. 0.18 0.06 0.12 0.09 0.10 0.05 0.08 0.09 0.20 0.18 0.18 0.22 0.20 0.10 0.13 0.34 0.32 0.14 0.24 0.26
TJX Cos. Inc. 0.45 0.27 0.33 0.34 0.55 0.45 0.56 0.63 0.64 0.53 0.63 0.68 0.73 0.58 0.52 0.55 0.56 0.45 0.54 0.63
Walmart Inc. 0.12 0.10 0.12 0.12 0.10 0.11 0.22 0.10 0.09 0.09 0.09 0.09 0.10 0.08 0.11 0.11 0.13 0.10 0.09 0.11

Based on: 10-K (filing date: 2021-02-03), 10-Q (filing date: 2020-10-30), 10-Q (filing date: 2020-07-31), 10-Q (filing date: 2020-05-01), 10-K (filing date: 2020-01-31), 10-Q (filing date: 2019-10-25), 10-Q (filing date: 2019-07-26), 10-Q (filing date: 2019-04-26), 10-K (filing date: 2019-02-01), 10-Q (filing date: 2018-10-26), 10-Q (filing date: 2018-07-27), 10-Q (filing date: 2018-04-27), 10-K (filing date: 2018-02-02), 10-Q (filing date: 2017-10-27), 10-Q (filing date: 2017-07-28), 10-Q (filing date: 2017-04-28), 10-K (filing date: 2017-02-10), 10-Q (filing date: 2016-10-28), 10-Q (filing date: 2016-07-29), 10-Q (filing date: 2016-04-29).

1 Q4 2020 Calculation
Cash ratio = Total cash assets ÷ Current liabilities
= 84,396 ÷ 126,385 = 0.67

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. Amazon.com Inc.’s cash ratio deteriorated from Q2 2020 to Q3 2020 and from Q3 2020 to Q4 2020.