Microsoft Excel LibreOffice Calc

Facebook Inc. (FB)

Liquidity Analysis
Quarterly Data

Difficulty: Beginner

Liquidity ratios measure the company’s ability to meet its short-term obligations.

Ratios (Summary)

Facebook Inc., liquidity ratios (quarterly data)

Microsoft Excel LibreOffice Calc
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 Dec 31, 2015 Sep 30, 2015 Jun 30, 2015 Mar 31, 2015 Dec 31, 2014 Sep 30, 2014 Jun 30, 2014 Mar 31, 2014
Current ratio 7.19 9.00 10.67 9.91 12.92 13.37 12.31 12.61 11.97 11.69 12.22 13.16 11.25 10.68 9.01 8.59 9.60 13.06 12.81 13.56
Quick ratio 6.94 8.65 10.26 9.65 12.64 12.92 11.87 12.20 11.63 11.26 11.80 12.70 10.91 9.96 8.47 7.97 9.04 12.65 12.48 13.15
Cash ratio 5.86 7.54 9.06 8.64 11.09 11.59 10.69 11.03 10.24 10.07 10.54 11.40 9.58 8.84 7.51 7.11 7.86 11.55 11.50 12.18

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

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

Current Ratio

Facebook Inc., current ratio calculation (quarterly data)

Microsoft Excel LibreOffice Calc
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 Dec 31, 2015 Sep 30, 2015 Jun 30, 2015 Mar 31, 2015 Dec 31, 2014 Sep 30, 2014 Jun 30, 2014 Mar 31, 2014
Selected Financial Data (USD $ in millions)
Current assets 50,480  49,147  49,833  50,412  48,563  44,203  40,804  36,930  34,401  30,328  27,010  23,812  21,652  19,139  16,951  15,004  13,670  16,115  15,557  14,060 
Current liabilities 7,017  5,462  4,670  5,086  3,760  3,305  3,315  2,928  2,875  2,595  2,211  1,809  1,925  1,792  1,881  1,746  1,424  1,234  1,214  1,037 
Ratio
Current ratio1 7.19 9.00 10.67 9.91 12.92 13.37 12.31 12.61 11.97 11.69 12.22 13.16 11.25 10.68 9.01 8.59 9.60 13.06 12.81 13.56

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

Q4 2018 Calculations

1 Current ratio = Current assets ÷ Current liabilities
= 50,480 ÷ 7,017 = 7.19

Ratio Description The company
Current ratio A liquidity ratio calculated as current assets divided by current liabilities. Facebook Inc.’s current ratio deteriorated from Q2 2018 to Q3 2018 and from Q3 2018 to Q4 2018.

Quick Ratio

Facebook Inc., quick ratio calculation (quarterly data)

Microsoft Excel LibreOffice Calc
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 Dec 31, 2015 Sep 30, 2015 Jun 30, 2015 Mar 31, 2015 Dec 31, 2014 Sep 30, 2014 Jun 30, 2014 Mar 31, 2014
Selected Financial Data (USD $ in millions)
Cash and cash equivalents 10,019  9,637  11,552  12,082  8,079  7,201  6,252  7,104  8,903  6,038  5,108  6,456  4,907  4,308  5,123  3,419  4,315  8,999  4,384  2,998 
Marketable securities 31,095  31,569  30,757  31,874  33,632  31,088  29,200  25,202  20,546  20,102  18,185  14,165  13,527  11,526  9,002  8,994  6,884  5,251  9,572  9,631 
Accounts receivable, net of allowances 7,587  6,058  5,590  5,115  5,832  4,424  3,897  3,415  3,993  3,070  2,801  2,348  2,559  2,010  1,815  1,508  1,678  1,363  1,190  1,006 
Total quick assets 48,701  47,264  47,899  49,071  47,543  42,713  39,349  35,721  33,442  29,210  26,094  22,969  20,993  17,844  15,940  13,921  12,877  15,613  15,146  13,635 
Current liabilities 7,017  5,462  4,670  5,086  3,760  3,305  3,315  2,928  2,875  2,595  2,211  1,809  1,925  1,792  1,881  1,746  1,424  1,234  1,214  1,037 
Ratio
Quick ratio1 6.94 8.65 10.26 9.65 12.64 12.92 11.87 12.20 11.63 11.26 11.80 12.70 10.91 9.96 8.47 7.97 9.04 12.65 12.48 13.15

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

Q4 2018 Calculations

1 Quick ratio = Total quick assets ÷ Current liabilities
= 48,701 ÷ 7,017 = 6.94

Ratio Description The company
Quick ratio A liquidity ratio calculated as (cash plus short-term marketable investments plus receivables) divided by current liabilities. Facebook Inc.’s quick ratio deteriorated from Q2 2018 to Q3 2018 and from Q3 2018 to Q4 2018.

Cash Ratio

Facebook Inc., cash ratio calculation (quarterly data)

Microsoft Excel LibreOffice Calc
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 Dec 31, 2015 Sep 30, 2015 Jun 30, 2015 Mar 31, 2015 Dec 31, 2014 Sep 30, 2014 Jun 30, 2014 Mar 31, 2014
Selected Financial Data (USD $ in millions)
Cash and cash equivalents 10,019  9,637  11,552  12,082  8,079  7,201  6,252  7,104  8,903  6,038  5,108  6,456  4,907  4,308  5,123  3,419  4,315  8,999  4,384  2,998 
Marketable securities 31,095  31,569  30,757  31,874  33,632  31,088  29,200  25,202  20,546  20,102  18,185  14,165  13,527  11,526  9,002  8,994  6,884  5,251  9,572  9,631 
Total cash assets 41,114  41,206  42,309  43,956  41,711  38,289  35,452  32,306  29,449  26,140  23,293  20,621  18,434  15,834  14,125  12,413  11,199  14,250  13,956  12,629 
Current liabilities 7,017  5,462  4,670  5,086  3,760  3,305  3,315  2,928  2,875  2,595  2,211  1,809  1,925  1,792  1,881  1,746  1,424  1,234  1,214  1,037 
Ratio
Cash ratio1 5.86 7.54 9.06 8.64 11.09 11.59 10.69 11.03 10.24 10.07 10.54 11.40 9.58 8.84 7.51 7.11 7.86 11.55 11.50 12.18

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

Q4 2018 Calculations

1 Cash ratio = Total cash assets ÷ Current liabilities
= 41,114 ÷ 7,017 = 5.86

Ratio Description The company
Cash ratio A liquidity ratio calculated as (cash plus short-term marketable investments) divided by current liabilities. Facebook Inc.’s cash ratio deteriorated from Q2 2018 to Q3 2018 and from Q3 2018 to Q4 2018.