Liquidity Analysis
Quarterly Data

Difficulty: Beginner


Ratios (Summary)

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

Microsoft Excel LibreOffice Calc
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 Dec 31, 2015 Sep 30, 2015 Jun 30, 2015 Mar 31, 2015 Dec 31, 2014 Sep 30, 2014 Jun 30, 2014 Mar 31, 2014 Dec 31, 2013 Sep 30, 2013 Jun 30, 2013 Mar 31, 2013
Current ratio 1.06 1.04 1.03 1.01 1.06 1.04 1.06 1.09 1.08 1.08 1.08 1.10 1.12 1.12 0.89 1.00 1.05 1.07 1.07 1.11 1.14
Quick ratio 0.52 0.54 0.52 0.53 0.58 0.59 0.55 0.56 0.56 0.58 0.54 0.59 0.59 0.62 0.33 0.43 0.47 0.54 0.48 0.51 0.55
Cash ratio 0.52 0.54 0.52 0.53 0.58 0.59 0.55 0.56 0.56 0.58 0.54 0.59 0.59 0.62 0.33 0.43 0.47 0.54 0.48 0.51 0.55
Source: Based on data from Amazon.com Inc. Quarterly and Annual Reports
Ratio Description The company
Current ratio A liquidity ratio calculated as current assets divided by current liabilities. Amazon.com Inc.'s current ratio improved from Q3 2017 to Q4 2017 and from Q4 2017 to Q1 2018.
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 improved from Q3 2017 to Q4 2017 but then slightly deteriorated from Q4 2017 to Q1 2018 not reaching Q3 2017 level.
Cash ratio A liquidity ratio calculated as (cash plus short-term marketable investments) divided by current liabilities. Amazon.com Inc.'s cash ratio improved from Q3 2017 to Q4 2017 but then slightly deteriorated from Q4 2017 to Q1 2018 not reaching Q3 2017 level.

Current Ratio

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

Microsoft Excel LibreOffice Calc
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 Dec 31, 2015 Sep 30, 2015 Jun 30, 2015 Mar 31, 2015 Dec 31, 2014 Sep 30, 2014 Jun 30, 2014 Mar 31, 2014 Dec 31, 2013 Sep 30, 2013 Jun 30, 2013 Mar 31, 2013
Selected Financial Data (USD $ in millions)
Current assets 50,829  60,197  48,578  41,007  39,460  45,781  35,609  32,220  30,513  36,474  28,849  26,391  25,922  31,327  18,572  18,755  19,327  24,625  17,334  16,285  16,313 
Current liabilities 48,045  57,883  47,072  40,520  37,399  43,816  33,498  29,587  28,187  33,899  26,657  23,912  23,177  28,089  20,842  18,751  18,357  22,980  16,135  14,735  14,332 
Ratio
Current ratio1 1.06 1.04 1.03 1.01 1.06 1.04 1.06 1.09 1.08 1.08 1.08 1.10 1.12 1.12 0.89 1.00 1.05 1.07 1.07 1.11 1.14
Source: Based on data from Amazon.com Inc. Quarterly and Annual Reports

Q1 2018 Calculations

1 Current ratio = Current assets ÷ Current liabilities
= 50,829 ÷ 48,045 = 1.06

Ratio Description The company
Current ratio A liquidity ratio calculated as current assets divided by current liabilities. Amazon.com Inc.'s current ratio improved from Q3 2017 to Q4 2017 and from Q4 2017 to Q1 2018.

Quick Ratio

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

Microsoft Excel LibreOffice Calc
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 Dec 31, 2015 Sep 30, 2015 Jun 30, 2015 Mar 31, 2015 Dec 31, 2014 Sep 30, 2014 Jun 30, 2014 Mar 31, 2014 Dec 31, 2013 Sep 30, 2013 Jun 30, 2013 Mar 31, 2013
Selected Financial Data (USD $ in millions)
Cash and cash equivalents 16,676  20,522  12,767  13,203  15,440  19,334  13,656  12,521  12,470  15,890  10,709  10,269  10,237  14,557  5,258  5,057  5,074  8,658  3,872  3,704  4,481 
Marketable securities 8,287  10,464  11,543  8,248  6,091  6,647  4,691  4,019  3,389  3,918  3,719  3,732  3,544  2,859  1,625  2,929  3,592  3,789  3,817  3,759  3,414 
Total quick assets 24,963  30,986  24,310  21,451  21,531  25,981  18,347  16,540  15,859  19,808  14,428  14,001  13,781  17,416  6,883  7,986  8,666  12,447  7,689  7,463  7,895 
Current liabilities 48,045  57,883  47,072  40,520  37,399  43,816  33,498  29,587  28,187  33,899  26,657  23,912  23,177  28,089  20,842  18,751  18,357  22,980  16,135  14,735  14,332 
Ratio
Quick ratio1 0.52 0.54 0.52 0.53 0.58 0.59 0.55 0.56 0.56 0.58 0.54 0.59 0.59 0.62 0.33 0.43 0.47 0.54 0.48 0.51 0.55
Source: Based on data from Amazon.com Inc. Quarterly and Annual Reports

Q1 2018 Calculations

1 Quick ratio = Total quick assets ÷ Current liabilities
= 24,963 ÷ 48,045 = 0.52

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

Cash Ratio

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

Microsoft Excel LibreOffice Calc
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 Dec 31, 2015 Sep 30, 2015 Jun 30, 2015 Mar 31, 2015 Dec 31, 2014 Sep 30, 2014 Jun 30, 2014 Mar 31, 2014 Dec 31, 2013 Sep 30, 2013 Jun 30, 2013 Mar 31, 2013
Selected Financial Data (USD $ in millions)
Cash and cash equivalents 16,676  20,522  12,767  13,203  15,440  19,334  13,656  12,521  12,470  15,890  10,709  10,269  10,237  14,557  5,258  5,057  5,074  8,658  3,872  3,704  4,481 
Marketable securities 8,287  10,464  11,543  8,248  6,091  6,647  4,691  4,019  3,389  3,918  3,719  3,732  3,544  2,859  1,625  2,929  3,592  3,789  3,817  3,759  3,414 
Total cash assets 24,963  30,986  24,310  21,451  21,531  25,981  18,347  16,540  15,859  19,808  14,428  14,001  13,781  17,416  6,883  7,986  8,666  12,447  7,689  7,463  7,895 
Current liabilities 48,045  57,883  47,072  40,520  37,399  43,816  33,498  29,587  28,187  33,899  26,657  23,912  23,177  28,089  20,842  18,751  18,357  22,980  16,135  14,735  14,332 
Ratio
Cash ratio1 0.52 0.54 0.52 0.53 0.58 0.59 0.55 0.56 0.56 0.58 0.54 0.59 0.59 0.62 0.33 0.43 0.47 0.54 0.48 0.51 0.55
Source: Based on data from Amazon.com Inc. Quarterly and Annual Reports

Q1 2018 Calculations

1 Cash ratio = Total cash assets ÷ Current liabilities
= 24,963 ÷ 48,045 = 0.52

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