Paying users zone. Data is covered by hidden.

  • Get to Eli Lilly & Co. for $17.99, or

  • get to whole website for at least 3 months from $49.99.

Microsoft Excel LibreOffice Calc

Eli Lilly & Co. (LLY)

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)

    Eli Lilly & Co., 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 hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden
    Quick ratio hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden
    Cash ratio hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden
    Source: Based on data from Eli Lilly & Co. Quarterly and Annual Reports
    Ratio Description The company
    Current ratio A liquidity ratio calculated as current assets divided by current liabilities. Eli Lilly & Co.'s current ratio improved from Q4 2017 to Q1 2018 but then slightly deteriorated 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. Eli Lilly & Co.'s quick ratio deteriorated from Q4 2017 to Q1 2018 but then improved from Q1 2018 to Q2 2018 exceeding Q4 2017 level.
    Cash ratio A liquidity ratio calculated as (cash plus short-term marketable investments) divided by current liabilities. Eli Lilly & Co.'s cash ratio deteriorated from Q4 2017 to Q1 2018 but then improved from Q1 2018 to Q2 2018 not reaching Q4 2017 level.

    Current Ratio

    Eli Lilly & Co., 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 thousands)
    Current assets hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden
    Current liabilities hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden
    Ratio
    Current ratio1 hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden
    Source: Based on data from Eli Lilly & Co. Quarterly and Annual Reports

    Q2 2018 Calculations

    1 Current ratio = Current assets ÷ Current liabilities
    = hidden ÷ hidden = hidden

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

    Quick Ratio

    Eli Lilly & Co., 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 thousands)
    Cash and cash equivalents hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden
    Short-term investments hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden
    Accounts receivable, net of allowances hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden
    Other receivables hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden
    Total quick assets hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden
    Current liabilities hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden
    Ratio
    Quick ratio1 hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden
    Source: Based on data from Eli Lilly & Co. Quarterly and Annual Reports

    Q2 2018 Calculations

    1 Quick ratio = Total quick assets ÷ Current liabilities
    = hidden ÷ hidden = hidden

    Ratio Description The company
    Quick ratio A liquidity ratio calculated as (cash plus short-term marketable investments plus receivables) divided by current liabilities. Eli Lilly & Co.'s quick ratio deteriorated from Q4 2017 to Q1 2018 but then improved from Q1 2018 to Q2 2018 exceeding Q4 2017 level.

    Cash Ratio

    Eli Lilly & Co., 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 thousands)
    Cash and cash equivalents hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden
    Short-term investments hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden
    Total cash assets hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden
    Current liabilities hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden
    Ratio
    Cash ratio1 hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden hidden
    Source: Based on data from Eli Lilly & Co. Quarterly and Annual Reports

    Q2 2018 Calculations

    1 Cash ratio = Total cash assets ÷ Current liabilities
    = hidden ÷ hidden = hidden

    Ratio Description The company
    Cash ratio A liquidity ratio calculated as (cash plus short-term marketable investments) divided by current liabilities. Eli Lilly & Co.'s cash ratio deteriorated from Q4 2017 to Q1 2018 but then improved from Q1 2018 to Q2 2018 not reaching Q4 2017 level.