Microsoft Excel LibreOffice Calc

Facebook Inc. (FB)

Liquidity Analysis
Quarterly Data

Difficulty: Beginner

  • Annual Data
  • Quarterly Data

    • 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
    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 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 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 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
    Source: Based on data from Facebook Inc. Quarterly and Annual Reports
    Ratio Description The company
    Current ratio A liquidity ratio calculated as current assets divided by current liabilities. Facebook Inc.'s current ratio deteriorated from Q4 2017 to Q1 2018 but then slightly improved from Q1 2018 to Q2 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 Q4 2017 to Q1 2018 but then slightly improved from Q1 2018 to Q2 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 Q4 2017 to Q1 2018 but then slightly improved from Q1 2018 to Q2 2018.

    Current Ratio

    Facebook Inc., current ratio calculation (quarterly data)

    Microsoft Excel LibreOffice Calc
    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,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 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 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
    Source: Based on data from Facebook Inc. Quarterly and Annual Reports

    Q2 2018 Calculations

    1 Current ratio = Current assets ÷ Current liabilities
    = 49,833 ÷ 4,670 = 10.67

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

    Quick Ratio

    Facebook Inc., quick ratio calculation (quarterly data)

    Microsoft Excel LibreOffice Calc
    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 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 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 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,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 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 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
    Source: Based on data from Facebook Inc. Quarterly and Annual Reports

    Q2 2018 Calculations

    1 Quick ratio = Total quick assets ÷ Current liabilities
    = 47,899 ÷ 4,670 = 10.26

    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 Q4 2017 to Q1 2018 but then slightly improved from Q1 2018 to Q2 2018.

    Cash Ratio

    Facebook Inc., cash ratio calculation (quarterly data)

    Microsoft Excel LibreOffice Calc
    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 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 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 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 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 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
    Source: Based on data from Facebook Inc. Quarterly and Annual Reports

    Q2 2018 Calculations

    1 Cash ratio = Total cash assets ÷ Current liabilities
    = 42,309 ÷ 4,670 = 9.06

    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 Q4 2017 to Q1 2018 but then slightly improved from Q1 2018 to Q2 2018.