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


Long-term (Investment) Activity Analysis

Difficulty: Beginner


Ratios (Summary)

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

Microsoft Excel LibreOffice Calc
Dec 31, 2017 Dec 31, 2016 Dec 31, 2015 Dec 31, 2014 Dec 31, 2013
Net fixed asset turnover hidden hidden hidden hidden hidden
Total asset turnover hidden hidden hidden hidden hidden
Equity turnover hidden hidden hidden hidden hidden

Source: Based on data from Eli Lilly & Co. 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 2015 to 2016 and from 2016 to 2017.
Total asset turnover An activity ratio calculated as total revenue divided by total assets. Eli Lilly & Co.'s total asset turnover deteriorated from 2015 to 2016 and from 2016 to 2017.
Equity turnover An activity ratio calculated as total revenue divided by shareholders' equity. Eli Lilly & Co.'s equity turnover improved from 2015 to 2016 and from 2016 to 2017.

Net Fixed Asset Turnover

Eli Lilly & Co., net fixed asset turnover calculation, comparison to benchmarks

Microsoft Excel LibreOffice Calc
Dec 31, 2017 Dec 31, 2016 Dec 31, 2015 Dec 31, 2014 Dec 31, 2013
Selected Financial Data (USD $ in thousands)
Revenue hidden hidden hidden hidden hidden
Property and equipment, net hidden hidden hidden hidden hidden
Ratio
Net fixed asset turnover1 hidden hidden hidden hidden hidden
Benchmarks
Net Fixed Asset Turnover, Competitors
Abbott Laboratories hidden hidden hidden hidden hidden
AbbVie Inc. hidden hidden hidden hidden hidden
Allergan PLC hidden hidden hidden hidden hidden
Amgen Inc. hidden hidden hidden hidden hidden
Biogen Inc. hidden hidden hidden hidden hidden
Bristol-Myers Squibb Co. hidden hidden hidden hidden hidden
Celgene Corp. hidden hidden hidden hidden hidden
Gilead Sciences Inc. hidden hidden hidden hidden hidden
Johnson & Johnson hidden hidden hidden hidden hidden
Merck & Co. Inc. hidden hidden hidden hidden hidden
Pfizer Inc. hidden hidden hidden hidden hidden
Regeneron Pharmaceuticals Inc. hidden hidden hidden hidden hidden
Net Fixed Asset Turnover, Sector
Pharmaceuticals & Biotechnology hidden hidden hidden hidden hidden
Net Fixed Asset Turnover, Industry
Health Care hidden hidden hidden hidden hidden

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

2017 Calculations

1 Net fixed asset turnover = Revenue ÷ Property and equipment, net
= 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 2015 to 2016 and from 2016 to 2017.

Total Asset Turnover

Eli Lilly & Co., total asset turnover calculation, comparison to benchmarks

Microsoft Excel LibreOffice Calc
Dec 31, 2017 Dec 31, 2016 Dec 31, 2015 Dec 31, 2014 Dec 31, 2013
Selected Financial Data (USD $ in thousands)
Revenue hidden hidden hidden hidden hidden
Total assets hidden hidden hidden hidden hidden
Ratio
Total asset turnover1 hidden hidden hidden hidden hidden
Benchmarks
Total Asset Turnover, Competitors
Abbott Laboratories hidden hidden hidden hidden hidden
AbbVie Inc. hidden hidden hidden hidden hidden
Allergan PLC hidden hidden hidden hidden hidden
Amgen Inc. hidden hidden hidden hidden hidden
Biogen Inc. hidden hidden hidden hidden hidden
Bristol-Myers Squibb Co. hidden hidden hidden hidden hidden
Celgene Corp. hidden hidden hidden hidden hidden
Gilead Sciences Inc. hidden hidden hidden hidden hidden
Johnson & Johnson hidden hidden hidden hidden hidden
Merck & Co. Inc. hidden hidden hidden hidden hidden
Pfizer Inc. hidden hidden hidden hidden hidden
Regeneron Pharmaceuticals Inc. hidden hidden hidden hidden hidden
Total Asset Turnover, Sector
Pharmaceuticals & Biotechnology hidden hidden hidden hidden hidden
Total Asset Turnover, Industry
Health Care hidden hidden hidden hidden hidden

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

2017 Calculations

1 Total asset turnover = Revenue ÷ Total assets
= 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 deteriorated from 2015 to 2016 and from 2016 to 2017.

Equity Turnover

Eli Lilly & Co., equity turnover calculation, comparison to benchmarks

Microsoft Excel LibreOffice Calc
Dec 31, 2017 Dec 31, 2016 Dec 31, 2015 Dec 31, 2014 Dec 31, 2013
Selected Financial Data (USD $ in thousands)
Revenue hidden hidden hidden hidden hidden
Total Eli Lilly and Company shareholders' equity hidden hidden hidden hidden hidden
Ratio
Equity turnover1 hidden hidden hidden hidden hidden
Benchmarks
Equity Turnover, Competitors
Abbott Laboratories hidden hidden hidden hidden hidden
AbbVie Inc. hidden hidden hidden hidden hidden
Allergan PLC hidden hidden hidden hidden hidden
Amgen Inc. hidden hidden hidden hidden hidden
Biogen Inc. hidden hidden hidden hidden hidden
Bristol-Myers Squibb Co. hidden hidden hidden hidden hidden
Celgene Corp. hidden hidden hidden hidden hidden
Gilead Sciences Inc. hidden hidden hidden hidden hidden
Johnson & Johnson hidden hidden hidden hidden hidden
Merck & Co. Inc. hidden hidden hidden hidden hidden
Pfizer Inc. hidden hidden hidden hidden hidden
Regeneron Pharmaceuticals Inc. hidden hidden hidden hidden hidden
Equity Turnover, Sector
Pharmaceuticals & Biotechnology hidden hidden hidden hidden hidden
Equity Turnover, Industry
Health Care hidden hidden hidden hidden hidden

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

2017 Calculations

1 Equity turnover = Revenue ÷ Total Eli Lilly and Company shareholders' equity
= 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 improved from 2015 to 2016 and from 2016 to 2017.