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
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 Dec 31, 2013 Sep 30, 2013 Jun 30, 2013 Mar 31, 2013
Current ratio 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 11.88 10.72 10.58 10.39
Quick ratio 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 11.42 10.37 10.21 9.53
Cash ratio 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 10.41 9.48 9.49 8.91

Based on: 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), 10-K (filing date: 2014-01-31), 10-Q (filing date: 2013-11-01), 10-Q (filing date: 2013-07-25), 10-Q (filing date: 2013-05-02).

Ratio Description The company
Current ratio A liquidity ratio calculated as current assets divided by current liabilities. Facebook Inc.'s current ratio improved from Q1 2018 to Q2 2018 but then deteriorated significantly from Q2 2018 to Q3 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 improved from Q1 2018 to Q2 2018 but then deteriorated significantly from Q2 2018 to Q3 2018.
Cash ratio A liquidity ratio calculated as (cash plus short-term marketable investments) divided by current liabilities. Facebook Inc.'s cash ratio improved from Q1 2018 to Q2 2018 but then deteriorated significantly from Q2 2018 to Q3 2018.

Current Ratio

Facebook Inc., current ratio calculation (quarterly data)

Microsoft Excel LibreOffice Calc
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 Dec 31, 2013 Sep 30, 2013 Jun 30, 2013 Mar 31, 2013
Selected Financial Data (USD $ in millions)
Current assets 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  13,070  10,549  11,421  11,042 
Current liabilities 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  1,100  984  1,080  1,063 
Ratio
Current ratio1 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 11.88 10.72 10.58 10.39

Based on: 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), 10-K (filing date: 2014-01-31), 10-Q (filing date: 2013-11-01), 10-Q (filing date: 2013-07-25), 10-Q (filing date: 2013-05-02).

Q3 2018 Calculations

1 Current ratio = Current assets ÷ Current liabilities
= 49,147 ÷ 5,462 = 9.00

Ratio Description The company
Current ratio A liquidity ratio calculated as current assets divided by current liabilities. Facebook Inc.'s current ratio improved from Q1 2018 to Q2 2018 but then deteriorated significantly from Q2 2018 to Q3 2018.

Quick Ratio

Facebook Inc., quick ratio calculation (quarterly data)

Microsoft Excel LibreOffice Calc
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 Dec 31, 2013 Sep 30, 2013 Jun 30, 2013 Mar 31, 2013
Selected Financial Data (USD $ in millions)
Cash and cash equivalents 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  3,323  3,100  3,001  2,325 
Marketable securities 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  8,126  6,228  7,251  7,147 
Accounts receivable, net of allowances 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  1,109  872  775  659 
Total quick assets 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  12,558  10,200  11,027  10,131 
Current liabilities 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  1,100  984  1,080  1,063 
Ratio
Quick ratio1 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 11.42 10.37 10.21 9.53

Based on: 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), 10-K (filing date: 2014-01-31), 10-Q (filing date: 2013-11-01), 10-Q (filing date: 2013-07-25), 10-Q (filing date: 2013-05-02).

Q3 2018 Calculations

1 Quick ratio = Total quick assets ÷ Current liabilities
= 47,264 ÷ 5,462 = 8.65

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 improved from Q1 2018 to Q2 2018 but then deteriorated significantly from Q2 2018 to Q3 2018.

Cash Ratio

Facebook Inc., cash ratio calculation (quarterly data)

Microsoft Excel LibreOffice Calc
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 Dec 31, 2013 Sep 30, 2013 Jun 30, 2013 Mar 31, 2013
Selected Financial Data (USD $ in millions)
Cash and cash equivalents 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  3,323  3,100  3,001  2,325 
Marketable securities 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  8,126  6,228  7,251  7,147 
Total cash assets 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  11,449  9,328  10,252  9,472 
Current liabilities 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  1,100  984  1,080  1,063 
Ratio
Cash ratio1 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 10.41 9.48 9.49 8.91

Based on: 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), 10-K (filing date: 2014-01-31), 10-Q (filing date: 2013-11-01), 10-Q (filing date: 2013-07-25), 10-Q (filing date: 2013-05-02).

Q3 2018 Calculations

1 Cash ratio = Total cash assets ÷ Current liabilities
= 41,206 ÷ 5,462 = 7.54

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 improved from Q1 2018 to Q2 2018 but then deteriorated significantly from Q2 2018 to Q3 2018.