Eli Lilly & Co. (LLY)

Liquidity Analysis Quarterly Data

Difficulty: Beginner

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

Eli Lilly & Co., liquidity ratios (quarterly data)

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 deteriorated from Q3 2017 to Q4 2017 but then improved from Q4 2017 to Q1 2018 exceeding Q3 2017 level.
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 Q3 2017 to Q4 2017 and from Q4 2017 to Q1 2018.
Cash ratio	A liquidity ratio calculated as (cash plus short-term marketable investments) divided by current liabilities.	Eli Lilly & Co.'s cash ratio improved from Q3 2017 to Q4 2017 but then deteriorated significantly from Q4 2017 to Q1 2018.

Eli Lilly & Co., current ratio calculation (quarterly data)

		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
	Current liabilities
	Ratio
	Current ratio¹

Source: Based on data from Eli Lilly & Co. Quarterly and Annual Reports

Q1 2018 Calculations

¹ Current ratio = Current assets ÷ Current liabilities
= ÷ =

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

Eli Lilly & Co., quick ratio calculation (quarterly data)

		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
	Short-term investments
	Accounts receivable, net of allowances
	Other receivables
	Total quick assets
	Current liabilities
	Ratio
	Quick ratio¹

Source: Based on data from Eli Lilly & Co. Quarterly and Annual Reports

Q1 2018 Calculations

¹ Quick ratio = Total quick assets ÷ Current liabilities
= ÷ =

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 Q3 2017 to Q4 2017 and from Q4 2017 to Q1 2018.

Eli Lilly & Co., cash ratio calculation (quarterly data)

		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
	Short-term investments
	Total cash assets
	Current liabilities
	Ratio
	Cash ratio¹

Source: Based on data from Eli Lilly & Co. Quarterly and Annual Reports

Q1 2018 Calculations

¹ Cash ratio = Total cash assets ÷ Current liabilities
= ÷ =

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

	Eli Lilly & Co.	Other companies (not purchased previously)
Long-term Trends
Financial Statements
Common-Size Financial Statements
Ratios
Relative Valuation
Discounted Cash Flow (DCF) Valuation
Analysis
Financial Reporting Quality

	All companies
Long-term Trends
Financial Statements
Common-Size Financial Statements
Ratios
Relative Valuation
Discounted Cash Flow (DCF) Valuation
Analysis
Financial Reporting Quality