Microsoft Excel LibreOffice Calc

Facebook Inc. (FB)

Analysis of Liquidity Ratios
Quarterly Data

Beginner level

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

Liquidity Ratios (Summary)

Facebook Inc., liquidity ratios (quarterly data)

Microsoft Excel LibreOffice Calc
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 Dec 31, 2015 Sep 30, 2015 Jun 30, 2015 Mar 31, 2015
Current ratio 4.40 4.66 4.47 5.38 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
Quick ratio 4.28 4.50 4.32 5.22 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
Cash ratio 3.64 3.92 3.74 4.57 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

Based on: 10-K (filing date: 2020-01-30), 10-Q (filing date: 2019-10-31), 10-Q (filing date: 2019-07-25), 10-Q (filing date: 2019-04-25), 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).

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

Current Ratio

Facebook Inc., current ratio calculation (quarterly data)

Microsoft Excel LibreOffice Calc
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 Dec 31, 2015 Sep 30, 2015 Jun 30, 2015 Mar 31, 2015
Selected Financial Data (US$ in millions)
Current assets 66,225  62,079  57,961  53,300  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 
Current liabilities 15,053  13,328  12,979  9,908  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 
Liquidity Ratio
Current ratio1 4.40 4.66 4.47 5.38 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
Benchmarks
Current Ratio, Competitors2
Adobe Inc. 0.79 0.74 0.70 0.97 1.13 1.66 2.08 2.12 2.05 2.05 1.99 1.95 2.08 2.16 2.20 2.21 2.18 2.20 2.16 2.22
Alphabet Inc. 3.37 3.78 3.98 3.96 3.92 4.14 4.15 4.87 5.14 5.77 6.01 7.13 6.29 6.88 5.43 5.14 4.67 4.77 4.85 5.60
International Business Machines Corp. 1.02 1.09 1.83 1.36 1.29 1.31 1.32 1.37 1.33 1.41 1.25 1.18 1.21 1.20 1.30 1.37 1.24 1.25 1.27 1.30
Intuit Inc. 1.83 1.85 1.32 1.41 1.14 1.05 0.63 0.67 0.73 0.90 0.60 0.58 0.72 0.81 0.62 0.76 1.47 1.35 1.22 1.79
Microsoft Corp. 2.53 2.97 3.12 2.92 2.90 3.40 2.89 3.12 2.48 2.81 2.05 2.69 2.35 2.90 3.00 2.46 2.50 2.91 2.45 2.52
Oracle Corp. 2.49 2.65 2.80 3.43 3.96 4.33 5.07 3.63 3.08 4.18 3.96 4.92 3.74 4.83 4.26 4.04 4.13 3.72 4.34 4.35
salesforce.com inc. 0.95 0.86 0.80 1.29 0.92 0.82 0.77 0.71 0.83 0.60 0.61 0.74 0.77 0.74 0.71 0.66 0.81 0.74 0.66 0.61

Based on: 10-K (filing date: 2020-01-30), 10-Q (filing date: 2019-10-31), 10-Q (filing date: 2019-07-25), 10-Q (filing date: 2019-04-25), 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).

1 Q4 2019 Calculation
Current ratio = Current assets ÷ Current liabilities
= 66,225 ÷ 15,053 = 4.40

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. Facebook Inc.’s current ratio improved from Q2 2019 to Q3 2019 but then deteriorated significantly from Q3 2019 to Q4 2019.

Quick Ratio

Facebook Inc., quick ratio calculation (quarterly data)

Microsoft Excel LibreOffice Calc
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 Dec 31, 2015 Sep 30, 2015 Jun 30, 2015 Mar 31, 2015
Selected Financial Data (US$ in millions)
Cash and cash equivalents 19,079  15,979  13,877  11,076  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 
Marketable securities 35,776  36,290  34,719  34,167  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 
Accounts receivable, net of allowances 9,518  7,673  7,513  6,475  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 
Total quick assets 64,373  59,942  56,109  51,718  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 
 
Current liabilities 15,053  13,328  12,979  9,908  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 
Liquidity Ratio
Quick ratio1 4.28 4.50 4.32 5.22 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
Benchmarks
Quick Ratio, Competitors2
Adobe Inc. 0.70 0.64 0.62 0.86 1.06 1.58 1.99 2.04 2.00 1.98 1.91 1.86 1.99 2.07 2.09 2.10 2.11 2.07 2.02 2.07
Alphabet Inc. 3.21 3.62 3.84 3.80 3.75 3.97 3.99 4.71 4.97 5.58 5.82 6.91 6.00 6.64 5.20 4.87 4.38 4.47 4.56 5.16
International Business Machines Corp. 0.87 0.91 1.68 1.19 1.12 1.13 1.14 1.19 1.19 1.22 1.09 1.00 1.04 1.02 1.11 1.20 1.07 1.03 1.03 1.03
Intuit Inc. 1.44 1.57 0.94 0.89 0.86 0.83 0.41 0.42 0.45 0.74 0.41 0.33 0.53 0.64 0.36 0.32 1.03 1.08 0.87 1.27
Microsoft Corp. 2.35 2.80 2.93 2.72 2.74 3.24 2.77 2.96 2.37 2.67 1.94 2.52 2.22 2.66 2.75 2.24 2.30 2.65 2.24 2.28
Oracle Corp. 2.31 2.45 2.63 3.26 3.78 4.14 4.86 3.49 2.95 3.99 3.79 4.74 3.57 4.62 4.09 3.86 3.92 3.48 4.09 4.12
salesforce.com inc. 0.82 0.68 0.64 1.13 0.83 0.71 0.67 0.61 0.74 0.50 0.46 0.63 0.68 0.61 0.54 0.49 0.66 0.55 0.48 0.47

Based on: 10-K (filing date: 2020-01-30), 10-Q (filing date: 2019-10-31), 10-Q (filing date: 2019-07-25), 10-Q (filing date: 2019-04-25), 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).

1 Q4 2019 Calculation
Quick ratio = Total quick assets ÷ Current liabilities
= 64,373 ÷ 15,053 = 4.28

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. Facebook Inc.’s quick ratio improved from Q2 2019 to Q3 2019 but then deteriorated significantly from Q3 2019 to Q4 2019.

Cash Ratio

Facebook Inc., cash ratio calculation (quarterly data)

Microsoft Excel LibreOffice Calc
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 Dec 31, 2015 Sep 30, 2015 Jun 30, 2015 Mar 31, 2015
Selected Financial Data (US$ in millions)
Cash and cash equivalents 19,079  15,979  13,877  11,076  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 
Marketable securities 35,776  36,290  34,719  34,167  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 
Total cash assets 54,855  52,269  48,596  45,243  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 
 
Current liabilities 15,053  13,328  12,979  9,908  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 
Liquidity Ratio
Cash ratio1 3.64 3.92 3.74 4.57 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
Benchmarks
Cash Ratio, Competitors2
Adobe Inc. 0.51 0.47 0.45 0.61 0.75 1.30 1.70 1.74 1.65 1.67 1.62 1.57 1.69 1.77 1.81 1.84 1.80 1.78 1.76 1.78
Alphabet Inc. 2.65 3.09 3.27 3.25 3.15 3.40 3.42 4.05 4.21 4.84 5.07 6.06 5.15 5.80 4.52 4.26 3.78 3.94 4.02 4.56
International Business Machines Corp. 0.24 0.31 1.10 0.47 0.32 0.40 0.34 0.37 0.34 0.36 0.34 0.29 0.24 0.29 0.32 0.43 0.24 0.28 0.25 0.25
Intuit Inc. 1.39 1.46 0.67 0.84 0.81 0.72 0.24 0.37 0.40 0.64 0.23 0.28 0.48 0.56 0.14 0.25 0.97 0.98 0.65 1.17
Microsoft Corp. 1.93 2.44 2.54 2.41 2.29 2.87 2.46 2.68 2.06 2.42 1.73 2.33 1.91 2.38 2.41 2.01 1.94 2.34 1.90 2.00
Oracle Corp. 2.03 2.23 2.43 3.07 3.50 3.92 4.62 3.31 2.73 3.76 3.56 4.52 3.26 4.29 3.81 3.63 3.56 3.17 3.73 3.86
salesforce.com inc. 0.39 0.43 0.40 0.91 0.45 0.50 0.47 0.42 0.30 0.24 0.22 0.40 0.24 0.34 0.28 0.26 0.23 0.31 0.24 0.26

Based on: 10-K (filing date: 2020-01-30), 10-Q (filing date: 2019-10-31), 10-Q (filing date: 2019-07-25), 10-Q (filing date: 2019-04-25), 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).

1 Q4 2019 Calculation
Cash ratio = Total cash assets ÷ Current liabilities
= 54,855 ÷ 15,053 = 3.64

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. Facebook Inc.’s cash ratio improved from Q2 2019 to Q3 2019 but then deteriorated significantly from Q3 2019 to Q4 2019.