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)

Profitability Analysis

Difficulty: Beginner

  • Annual Data
  • Quarterly Data

    • Profitability ratios measure the company's ability to generate profitable sales from its resources (assets).

    Ratios (Summary)

    Eli Lilly & Co., profitability ratios

    Microsoft Excel LibreOffice Calc
    Dec 31, 2017 Dec 31, 2016 Dec 31, 2015 Dec 31, 2014 Dec 31, 2013
    Return on Sales
    Gross profit margin hidden% hidden% hidden% hidden% hidden%
    Operating profit margin hidden% hidden% hidden% hidden% hidden%
    Net profit margin hidden% hidden% hidden% hidden% hidden%
    Return on Investment
    Return on equity (ROE) hidden% hidden% hidden% hidden% hidden%
    Return on assets (ROA) hidden% hidden% hidden% hidden% hidden%

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

    Ratio Description The company
    Gross profit margin Gross profit margin indicates the percentage of revenue available to cover operating and other expenditures. Eli Lilly & Co.'s gross profit margin deteriorated from 2015 to 2016 but then slightly improved from 2016 to 2017.
    Operating profit margin A profitability ratio calculated as operating income divided by revenue. Eli Lilly & Co.'s operating profit margin improved from 2015 to 2016 but then deteriorated significantly from 2016 to 2017.
    Net profit margin An indicator of profitability, calculated as net income divided by revenue. Eli Lilly & Co.'s net profit margin improved from 2015 to 2016 but then deteriorated significantly from 2016 to 2017.
    ROE A profitability ratio calculated as net income divided by shareholders' equity. Eli Lilly & Co.'s ROE improved from 2015 to 2016 but then deteriorated significantly from 2016 to 2017.
    ROA A profitability ratio calculated as net income divided by total assets. Eli Lilly & Co.'s ROA improved from 2015 to 2016 but then deteriorated significantly from 2016 to 2017.

    Gross Profit Margin

    Eli Lilly & Co., gross profit margin calculation

    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)
    Gross margin hidden hidden hidden hidden hidden
    Revenue hidden hidden hidden hidden hidden
    Ratio
    Gross profit margin1 hidden% hidden% hidden% hidden% hidden%
    Benchmarks
    Gross Profit Margin, 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%

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

    2017 Calculations

    1 Gross profit margin = 100 × Gross margin ÷ Revenue
    = 100 × hidden ÷ hidden = hidden%

    Ratio Description The company
    Gross profit margin Gross profit margin indicates the percentage of revenue available to cover operating and other expenditures. Eli Lilly & Co.'s gross profit margin deteriorated from 2015 to 2016 but then slightly improved from 2016 to 2017.

    Operating Profit Margin

    Eli Lilly & Co., operating profit margin 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)
    Operating income hidden hidden hidden hidden hidden
    Revenue hidden hidden hidden hidden hidden
    Ratio
    Operating profit margin1 hidden% hidden% hidden% hidden% hidden%
    Benchmarks
    Operating Profit Margin, 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%
    Operating Profit Margin, Sector
    Pharmaceuticals & Biotechnology hidden% hidden% hidden% hidden% hidden%
    Operating Profit Margin, Industry
    Health Care hidden% hidden% hidden% hidden% hidden%

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

    2017 Calculations

    1 Operating profit margin = 100 × Operating income ÷ Revenue
    = 100 × hidden ÷ hidden = hidden%

    Ratio Description The company
    Operating profit margin A profitability ratio calculated as operating income divided by revenue. Eli Lilly & Co.'s operating profit margin improved from 2015 to 2016 but then deteriorated significantly from 2016 to 2017.

    Net Profit Margin

    Eli Lilly & Co., net profit margin 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)
    Net income (loss) hidden hidden hidden hidden hidden
    Revenue hidden hidden hidden hidden hidden
    Ratio
    Net profit margin1 hidden% hidden% hidden% hidden% hidden%
    Benchmarks
    Net Profit Margin, 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 Profit Margin, Sector
    Pharmaceuticals & Biotechnology hidden% hidden% hidden% hidden% hidden%
    Net Profit Margin, Industry
    Health Care hidden% hidden% hidden% hidden% hidden%

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

    2017 Calculations

    1 Net profit margin = 100 × Net income (loss) ÷ Revenue
    = 100 × hidden ÷ hidden = hidden%

    Ratio Description The company
    Net profit margin An indicator of profitability, calculated as net income divided by revenue. Eli Lilly & Co.'s net profit margin improved from 2015 to 2016 but then deteriorated significantly from 2016 to 2017.

    Return on Equity (ROE)

    Eli Lilly & Co., ROE 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)
    Net income (loss) hidden hidden hidden hidden hidden
    Total Eli Lilly and Company shareholders' equity hidden hidden hidden hidden hidden
    Ratio
    ROE1 hidden% hidden% hidden% hidden% hidden%
    Benchmarks
    ROE, 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%
    ROE, Sector
    Pharmaceuticals & Biotechnology hidden% hidden% hidden% hidden% hidden%
    ROE, Industry
    Health Care hidden% hidden% hidden% hidden% hidden%

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

    2017 Calculations

    1 ROE = 100 × Net income (loss) ÷ Total Eli Lilly and Company shareholders' equity
    = 100 × hidden ÷ hidden = hidden%

    Ratio Description The company
    ROE A profitability ratio calculated as net income divided by shareholders' equity. Eli Lilly & Co.'s ROE improved from 2015 to 2016 but then deteriorated significantly from 2016 to 2017.

    Return on Assets (ROA)

    Eli Lilly & Co., ROA 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)
    Net income (loss) hidden hidden hidden hidden hidden
    Total assets hidden hidden hidden hidden hidden
    Ratio
    ROA1 hidden% hidden% hidden% hidden% hidden%
    Benchmarks
    ROA, 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%
    ROA, Sector
    Pharmaceuticals & Biotechnology hidden% hidden% hidden% hidden% hidden%
    ROA, Industry
    Health Care hidden% hidden% hidden% hidden% hidden%

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

    2017 Calculations

    1 ROA = 100 × Net income (loss) ÷ Total assets
    = 100 × hidden ÷ hidden = hidden%

    Ratio Description The company
    ROA A profitability ratio calculated as net income divided by total assets. Eli Lilly & Co.'s ROA improved from 2015 to 2016 but then deteriorated significantly from 2016 to 2017.