Eli Lilly & Co. (LLY)

Long-term (Investment) Activity Analysis
Quarterly Data

Difficulty: Beginner

Annual Data

Quarterly Data

Activity ratios measure how efficiently a company performs day-to-day tasks, such us the collection of receivables and management of inventory.

Ratios (Summary)
Net Fixed Asset Turnover
Total Asset Turnover
Equity Turnover

Ratios (Summary)

Eli Lilly & Co., long-term (investment) activity ratios (quarterly data)

		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
	Net fixed asset turnover
	Total asset turnover
	Equity turnover

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

Ratio	Description	The company
Net fixed asset turnover	An activity ratio calculated as total revenue divided by net fixed assets.	Eli Lilly & Co.'s net fixed asset turnover improved from Q4 2017 to Q1 2018 and from Q1 2018 to Q2 2018.
Total asset turnover	An activity ratio calculated as total revenue divided by total assets.	Eli Lilly & Co.'s total asset turnover improved from Q4 2017 to Q1 2018 and from Q1 2018 to Q2 2018.
Equity turnover	An activity ratio calculated as total revenue divided by shareholders' equity.	Eli Lilly & Co.'s equity turnover deteriorated from Q4 2017 to Q1 2018 but then improved from Q1 2018 to Q2 2018 exceeding Q4 2017 level.

Net Fixed Asset Turnover

Eli Lilly & Co., net fixed asset turnover calculation (quarterly data)

		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)
	Revenue
	Property and equipment, net of accumulated depreciation
	Ratio
	Net fixed asset turnover¹

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

Q2 2018 Calculations

¹ Net fixed asset turnover = (Revenue_{Q2 2018} + Revenue_{Q1 2018} + Revenue_{Q4 2017} + Revenue_{Q3 2017}) ÷ Property and equipment, net of accumulated depreciation
= ( hidden + hidden + hidden + hidden ) ÷ hidden = hidden

Ratio	Description	The company
Net fixed asset turnover	An activity ratio calculated as total revenue divided by net fixed assets.	Eli Lilly & Co.'s net fixed asset turnover improved from Q4 2017 to Q1 2018 and from Q1 2018 to Q2 2018.

Total Asset Turnover

Eli Lilly & Co., total asset turnover calculation (quarterly data)

		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)
	Revenue
	Total assets
	Ratio
	Total asset turnover¹

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

Q2 2018 Calculations

¹ Total asset turnover = (Revenue_{Q2 2018} + Revenue_{Q1 2018} + Revenue_{Q4 2017} + Revenue_{Q3 2017}) ÷ Total assets
= ( hidden + hidden + hidden + hidden ) ÷ hidden = hidden

Ratio	Description	The company
Total asset turnover	An activity ratio calculated as total revenue divided by total assets.	Eli Lilly & Co.'s total asset turnover improved from Q4 2017 to Q1 2018 and from Q1 2018 to Q2 2018.

Equity Turnover

Eli Lilly & Co., equity turnover calculation (quarterly data)

		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)
	Revenue
	Total Eli Lilly and Company shareholders' equity
	Ratio
	Equity turnover¹

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

Q2 2018 Calculations

¹ Equity turnover = (Revenue_{Q2 2018} + Revenue_{Q1 2018} + Revenue_{Q4 2017} + Revenue_{Q3 2017}) ÷ Total Eli Lilly and Company shareholders' equity
= ( hidden + hidden + hidden + hidden ) ÷ hidden = hidden

Ratio	Description	The company
Equity turnover	An activity ratio calculated as total revenue divided by shareholders' equity.	Eli Lilly & Co.'s equity turnover deteriorated from Q4 2017 to Q1 2018 but then improved from Q1 2018 to Q2 2018 exceeding Q4 2017 level.

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

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

Eli Lilly & Co. (LLY)

Long-term (Investment) Activity AnalysisQuarterly Data

Ratios (Summary)

Net Fixed Asset Turnover

Total Asset Turnover

Equity Turnover

Long-term (Investment) Activity Analysis
Quarterly Data