Microsoft Excel LibreOffice Calc

Eli Lilly & Co. (LLY)

Profitability Analysis
Quarterly Data

Difficulty: Beginner

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

Ratios (Summary)

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

Microsoft Excel LibreOffice Calc
Mar 31, 2019 Dec 31, 2018 Sep 30, 2018 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
Return on Sales
Gross profit margin 74.96% 73.81% 73.39% 72.92% 72.95% 73.46% 73.69% 73.89% 73.78% 73.35% 73.23% 73.72% 74.39% 74.76% 75.13% 74.87% 74.96% 74.85% — — —
Operating profit margin 12.50% 15.15% 12.34% 9.11% 14.88% 9.38% 12.43% 14.23% 12.92% 16.30% 14.31% 14.56% 14.27% 13.47% 13.53% 11.55% 12.00% 13.56% — — —
Net profit margin 26.12% 13.16% 1.85% -0.60% 4.82% -0.89% 9.90% 11.12% 10.13% 12.90% 11.73% 11.97% 11.49% 12.07% 11.97% 10.50% 11.20% 12.19% — — —
Return on Investment
Return on equity (ROE) 252.24% 32.88% 3.44% -1.24% 7.74% -1.76% 14.94% 17.35% 15.58% 19.54% 15.68% 16.85% 15.45% 16.53% 15.49% 14.04% 14.69% 15.55% — — —
Return on assets (ROA) 16.46% 7.36% 1.01% -0.34% 2.53% -0.45% 5.17% 5.98% 5.81% 7.05% 6.50% 6.76% 6.68% 6.77% 6.50% 5.71% 6.15% 6.43% — — —

Based on: 10-Q (filing date: 2019-05-02), 10-K (filing date: 2019-02-19), 10-Q (filing date: 2018-11-06), 10-Q (filing date: 2018-07-25), 10-Q (filing date: 2018-04-27), 10-K (filing date: 2018-02-20), 10-Q (filing date: 2017-10-27), 10-Q (filing date: 2017-07-28), 10-Q (filing date: 2017-05-01), 10-K (filing date: 2017-02-21), 10-Q (filing date: 2016-10-28), 10-Q (filing date: 2016-07-28), 10-Q (filing date: 2016-04-29), 10-K (filing date: 2016-02-19), 10-Q (filing date: 2015-10-30), 10-Q (filing date: 2015-07-30), 10-Q (filing date: 2015-04-30), 10-K (filing date: 2015-02-19), 10-Q (filing date: 2014-10-29), 10-Q (filing date: 2014-07-28), 10-Q (filing date: 2014-04-28).

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 improved from Q3 2018 to Q4 2018 and from Q4 2018 to Q1 2019.
Operating profit margin A profitability ratio calculated as operating income divided by revenue. Eli Lilly & Co.’s operating profit margin improved from Q3 2018 to Q4 2018 but then slightly deteriorated from Q4 2018 to Q1 2019 not reaching Q3 2018 level.
Net profit margin An indicator of profitability, calculated as net income divided by revenue. Eli Lilly & Co.’s net profit margin improved from Q3 2018 to Q4 2018 and from Q4 2018 to Q1 2019.
Ratio Description The company
ROE A profitability ratio calculated as net income divided by shareholders’ equity. Eli Lilly & Co.’s ROE improved from Q3 2018 to Q4 2018 and from Q4 2018 to Q1 2019.
ROA A profitability ratio calculated as net income divided by total assets. Eli Lilly & Co.’s ROA improved from Q3 2018 to Q4 2018 and from Q4 2018 to Q1 2019.

Gross Profit Margin

Eli Lilly & Co., gross profit margin calculation (quarterly data)

Microsoft Excel LibreOffice Calc
Mar 31, 2019 Dec 31, 2018 Sep 30, 2018 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
Selected Financial Data (USD $ in thousands)
Gross margin 3,953,500  4,844,900  4,499,600  4,652,500  4,128,700  4,535,900  4,091,900  4,272,700  3,900,600  4,294,500  3,790,800  3,939,800  3,542,100  3,986,400  3,722,800  3,760,300  3,452,000  3,868,200  3,608,600  3,745,900  3,460,400 
Revenue 5,092,200  6,438,600  6,061,900  6,355,200  5,700,000  6,160,700  5,658,000  5,824,300  5,228,300  5,760,500  5,191,700  5,404,800  4,865,100  5,375,600  4,959,700  4,978,700  4,644,700  5,121,300  4,875,600  4,935,600  4,683,100 
Ratio
Gross profit margin1 74.96% 73.81% 73.39% 72.92% 72.95% 73.46% 73.69% 73.89% 73.78% 73.35% 73.23% 73.72% 74.39% 74.76% 75.13% 74.87% 74.96% 74.85% — — —

Based on: 10-Q (filing date: 2019-05-02), 10-K (filing date: 2019-02-19), 10-Q (filing date: 2018-11-06), 10-Q (filing date: 2018-07-25), 10-Q (filing date: 2018-04-27), 10-K (filing date: 2018-02-20), 10-Q (filing date: 2017-10-27), 10-Q (filing date: 2017-07-28), 10-Q (filing date: 2017-05-01), 10-K (filing date: 2017-02-21), 10-Q (filing date: 2016-10-28), 10-Q (filing date: 2016-07-28), 10-Q (filing date: 2016-04-29), 10-K (filing date: 2016-02-19), 10-Q (filing date: 2015-10-30), 10-Q (filing date: 2015-07-30), 10-Q (filing date: 2015-04-30), 10-K (filing date: 2015-02-19), 10-Q (filing date: 2014-10-29), 10-Q (filing date: 2014-07-28), 10-Q (filing date: 2014-04-28).

Q1 2019 Calculations

1 Gross profit margin = 100 × (Gross marginQ1 2019 + Gross marginQ4 2018 + Gross marginQ3 2018 + Gross marginQ2 2018) ÷ (RevenueQ1 2019 + RevenueQ4 2018 + RevenueQ3 2018 + RevenueQ2 2018)
= 100 × (3,953,500 + 4,844,900 + 4,499,600 + 4,652,500) ÷ (5,092,200 + 6,438,600 + 6,061,900 + 6,355,200) = 74.96%

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

Operating Profit Margin

Eli Lilly & Co., operating profit margin calculation (quarterly data)

Microsoft Excel LibreOffice Calc
Mar 31, 2019 Dec 31, 2018 Sep 30, 2018 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
Selected Financial Data (USD $ in thousands)
Operating income (loss) 645,100  954,200  1,426,400  (33,200) 1,373,500  229,000  605,500  1,264,400  46,100  876,200  943,500  923,300  715,800  399,900  961,300  803,000  525,200  376,400  562,000  886,600  834,800 
Revenue 5,092,200  6,438,600  6,061,900  6,355,200  5,700,000  6,160,700  5,658,000  5,824,300  5,228,300  5,760,500  5,191,700  5,404,800  4,865,100  5,375,600  4,959,700  4,978,700  4,644,700  5,121,300  4,875,600  4,935,600  4,683,100 
Ratio
Operating profit margin1 12.50% 15.15% 12.34% 9.11% 14.88% 9.38% 12.43% 14.23% 12.92% 16.30% 14.31% 14.56% 14.27% 13.47% 13.53% 11.55% 12.00% 13.56% — — —

Based on: 10-Q (filing date: 2019-05-02), 10-K (filing date: 2019-02-19), 10-Q (filing date: 2018-11-06), 10-Q (filing date: 2018-07-25), 10-Q (filing date: 2018-04-27), 10-K (filing date: 2018-02-20), 10-Q (filing date: 2017-10-27), 10-Q (filing date: 2017-07-28), 10-Q (filing date: 2017-05-01), 10-K (filing date: 2017-02-21), 10-Q (filing date: 2016-10-28), 10-Q (filing date: 2016-07-28), 10-Q (filing date: 2016-04-29), 10-K (filing date: 2016-02-19), 10-Q (filing date: 2015-10-30), 10-Q (filing date: 2015-07-30), 10-Q (filing date: 2015-04-30), 10-K (filing date: 2015-02-19), 10-Q (filing date: 2014-10-29), 10-Q (filing date: 2014-07-28), 10-Q (filing date: 2014-04-28).

Q1 2019 Calculations

1 Operating profit margin = 100 × (Operating income (loss)Q1 2019 + Operating income (loss)Q4 2018 + Operating income (loss)Q3 2018 + Operating income (loss)Q2 2018) ÷ (RevenueQ1 2019 + RevenueQ4 2018 + RevenueQ3 2018 + RevenueQ2 2018)
= 100 × (645,100 + 954,200 + 1,426,400 + -33,200) ÷ (5,092,200 + 6,438,600 + 6,061,900 + 6,355,200) = 12.50%

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 Q3 2018 to Q4 2018 but then slightly deteriorated from Q4 2018 to Q1 2019 not reaching Q3 2018 level.

Net Profit Margin

Eli Lilly & Co., net profit margin calculation (quarterly data)

Microsoft Excel LibreOffice Calc
Mar 31, 2019 Dec 31, 2018 Sep 30, 2018 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
Selected Financial Data (USD $ in thousands)
Net income (loss) 4,241,600  1,125,000  1,149,500  (259,900) 1,217,400  (1,656,900) 555,600  1,008,000  (110,800) 771,800  778,000  747,700  440,100  478,400  799,700  600,800  529,500  428,500  500,600  733,500  727,900 
Revenue 5,092,200  6,438,600  6,061,900  6,355,200  5,700,000  6,160,700  5,658,000  5,824,300  5,228,300  5,760,500  5,191,700  5,404,800  4,865,100  5,375,600  4,959,700  4,978,700  4,644,700  5,121,300  4,875,600  4,935,600  4,683,100 
Ratio
Net profit margin1 26.12% 13.16% 1.85% -0.60% 4.82% -0.89% 9.90% 11.12% 10.13% 12.90% 11.73% 11.97% 11.49% 12.07% 11.97% 10.50% 11.20% 12.19% — — —

Based on: 10-Q (filing date: 2019-05-02), 10-K (filing date: 2019-02-19), 10-Q (filing date: 2018-11-06), 10-Q (filing date: 2018-07-25), 10-Q (filing date: 2018-04-27), 10-K (filing date: 2018-02-20), 10-Q (filing date: 2017-10-27), 10-Q (filing date: 2017-07-28), 10-Q (filing date: 2017-05-01), 10-K (filing date: 2017-02-21), 10-Q (filing date: 2016-10-28), 10-Q (filing date: 2016-07-28), 10-Q (filing date: 2016-04-29), 10-K (filing date: 2016-02-19), 10-Q (filing date: 2015-10-30), 10-Q (filing date: 2015-07-30), 10-Q (filing date: 2015-04-30), 10-K (filing date: 2015-02-19), 10-Q (filing date: 2014-10-29), 10-Q (filing date: 2014-07-28), 10-Q (filing date: 2014-04-28).

Q1 2019 Calculations

1 Net profit margin = 100 × (Net income (loss)Q1 2019 + Net income (loss)Q4 2018 + Net income (loss)Q3 2018 + Net income (loss)Q2 2018) ÷ (RevenueQ1 2019 + RevenueQ4 2018 + RevenueQ3 2018 + RevenueQ2 2018)
= 100 × (4,241,600 + 1,125,000 + 1,149,500 + -259,900) ÷ (5,092,200 + 6,438,600 + 6,061,900 + 6,355,200) = 26.12%

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

Return on Equity (ROE)

Eli Lilly & Co., ROE calculation (quarterly data)

Microsoft Excel LibreOffice Calc
Mar 31, 2019 Dec 31, 2018 Sep 30, 2018 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
Selected Financial Data (USD $ in thousands)
Net income (loss) 4,241,600  1,125,000  1,149,500  (259,900) 1,217,400  (1,656,900) 555,600  1,008,000  (110,800) 771,800  778,000  747,700  440,100  478,400  799,700  600,800  529,500  428,500  500,600  733,500  727,900 
Total Eli Lilly and Company shareholders’ equity 2,480,300  9,828,700  13,076,600  11,555,200  14,527,000  11,592,200  14,890,300  14,100,800  14,031,000  14,007,700  15,589,200  14,637,300  15,009,900  14,571,300  15,221,400  14,670,300  14,919,800  15,373,200  17,669,300  17,983,700  18,338,100 
Ratio
ROE1 252.24% 32.88% 3.44% -1.24% 7.74% -1.76% 14.94% 17.35% 15.58% 19.54% 15.68% 16.85% 15.45% 16.53% 15.49% 14.04% 14.69% 15.55% — — —

Based on: 10-Q (filing date: 2019-05-02), 10-K (filing date: 2019-02-19), 10-Q (filing date: 2018-11-06), 10-Q (filing date: 2018-07-25), 10-Q (filing date: 2018-04-27), 10-K (filing date: 2018-02-20), 10-Q (filing date: 2017-10-27), 10-Q (filing date: 2017-07-28), 10-Q (filing date: 2017-05-01), 10-K (filing date: 2017-02-21), 10-Q (filing date: 2016-10-28), 10-Q (filing date: 2016-07-28), 10-Q (filing date: 2016-04-29), 10-K (filing date: 2016-02-19), 10-Q (filing date: 2015-10-30), 10-Q (filing date: 2015-07-30), 10-Q (filing date: 2015-04-30), 10-K (filing date: 2015-02-19), 10-Q (filing date: 2014-10-29), 10-Q (filing date: 2014-07-28), 10-Q (filing date: 2014-04-28).

Q1 2019 Calculations

1 ROE = 100 × (Net income (loss)Q1 2019 + Net income (loss)Q4 2018 + Net income (loss)Q3 2018 + Net income (loss)Q2 2018) ÷ Total Eli Lilly and Company shareholders’ equity
= 100 × (4,241,600 + 1,125,000 + 1,149,500 + -259,900) ÷ 2,480,300 = 252.24%

Ratio Description The company
ROE A profitability ratio calculated as net income divided by shareholders’ equity. Eli Lilly & Co.’s ROE improved from Q3 2018 to Q4 2018 and from Q4 2018 to Q1 2019.

Return on Assets (ROA)

Eli Lilly & Co., ROA calculation (quarterly data)

Microsoft Excel LibreOffice Calc
Mar 31, 2019 Dec 31, 2018 Sep 30, 2018 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
Selected Financial Data (USD $ in thousands)
Net income (loss) 4,241,600  1,125,000  1,149,500  (259,900) 1,217,400  (1,656,900) 555,600  1,008,000  (110,800) 771,800  778,000  747,700  440,100  478,400  799,700  600,800  529,500  428,500  500,600  733,500  727,900 
Total assets 38,006,800  43,908,400  44,625,100  42,359,200  44,355,600  44,981,000  43,010,400  40,946,500  37,624,300  38,805,900  37,590,300  36,475,300  34,691,800  35,568,900  36,304,700  36,036,600  35,653,900  37,178,200  34,648,800  35,018,400  34,756,900 
Ratio
ROA1 16.46% 7.36% 1.01% -0.34% 2.53% -0.45% 5.17% 5.98% 5.81% 7.05% 6.50% 6.76% 6.68% 6.77% 6.50% 5.71% 6.15% 6.43% — — —

Based on: 10-Q (filing date: 2019-05-02), 10-K (filing date: 2019-02-19), 10-Q (filing date: 2018-11-06), 10-Q (filing date: 2018-07-25), 10-Q (filing date: 2018-04-27), 10-K (filing date: 2018-02-20), 10-Q (filing date: 2017-10-27), 10-Q (filing date: 2017-07-28), 10-Q (filing date: 2017-05-01), 10-K (filing date: 2017-02-21), 10-Q (filing date: 2016-10-28), 10-Q (filing date: 2016-07-28), 10-Q (filing date: 2016-04-29), 10-K (filing date: 2016-02-19), 10-Q (filing date: 2015-10-30), 10-Q (filing date: 2015-07-30), 10-Q (filing date: 2015-04-30), 10-K (filing date: 2015-02-19), 10-Q (filing date: 2014-10-29), 10-Q (filing date: 2014-07-28), 10-Q (filing date: 2014-04-28).

Q1 2019 Calculations

1 ROA = 100 × (Net income (loss)Q1 2019 + Net income (loss)Q4 2018 + Net income (loss)Q3 2018 + Net income (loss)Q2 2018) ÷ Total assets
= 100 × (4,241,600 + 1,125,000 + 1,149,500 + -259,900) ÷ 38,006,800 = 16.46%

Ratio Description The company
ROA A profitability ratio calculated as net income divided by total assets. Eli Lilly & Co.’s ROA improved from Q3 2018 to Q4 2018 and from Q4 2018 to Q1 2019.