Stock Analysis on Net
Stock Analysis on Net

Eli Lilly & Co. (NYSE:LLY)

Common-Size Income Statement
Quarterly Data

Beginner level

Eli Lilly & Co., common-size consolidated income statement (quarterly data)

Microsoft Excel LibreOffice Calc
3 months ended: Jun 30, 2020 Mar 31, 2020 Dec 31, 2019 Sep 30, 2019 Jun 30, 2019 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
Revenue 100.00 100.00 100.00 100.00 100.00 100.00 100.00 100.00 100.00 100.00 100.00 100.00 100.00 100.00 100.00 100.00 100.00 100.00 100.00 100.00 100.00 100.00
Cost of sales -22.22 -20.74 -20.98 -21.45 -19.96 -22.36 -24.75 -25.77 -26.79 -27.57 -26.37 -27.68 -26.64 -25.39 -25.45 -26.98 -27.11 -27.19 -25.84 -24.94 -24.47 -25.68
Gross margin 77.78% 79.26% 79.02% 78.55% 80.04% 77.64% 75.25% 74.23% 73.21% 72.43% 73.63% 72.32% 73.36% 74.61% 74.55% 73.02% 72.89% 72.81% 74.16% 75.06% 75.53% 74.32%
Research and development -25.28 -23.76 -25.87 -25.21 -24.88 -24.16 -22.58 -22.16 -20.98 -20.65 -23.91 -23.32 -21.48 -23.68 -25.18 -23.81 -24.72 -25.10 -26.87 -23.05 -23.49 -22.38
Marketing, selling, and administrative -26.34 -26.44 -27.77 -25.79 -28.14 -29.79 -28.91 -26.67 -26.02 -26.32 -28.90 -27.49 -29.32 -29.54 -31.08 -30.15 -30.02 -30.30 -33.45 -31.77 -32.85 -32.80
Acquired in-process research and development -4.40 -0.89 0.00 -1.42 -0.44 -2.69 -5.12 -0.49 -25.56 0.00 -0.81 -3.62 0.00 -16.40 -0.52 0.00 0.00 0.00 -3.70 0.00 -1.61 -5.51
Asset impairment, restructuring, and other special charges 0.00 -1.02 -2.48 0.00 0.00 -8.32 -3.82 -1.37 -1.17 -1.37 -16.28 -7.18 -0.86 -4.09 -2.56 -0.88 -1.07 -2.70 -2.70 -0.85 -1.45 -2.33
Operating income (loss) 21.76% 27.15% 22.90% 26.12% 26.58% 12.67% 14.82% 23.53% -0.52% 24.10% 3.72% 10.70% 21.71% 0.88% 15.21% 18.17% 17.08% 14.71% 7.44% 19.38% 16.13% 11.31%
Other, net, income (expense) 8.13 1.52 4.30 -0.45 -0.57 1.69 -0.24 -0.25 0.60 1.18 0.89 -0.25 -0.07 0.29 0.27 0.52 0.39 -3.06 0.83 1.74 -2.48 2.00
Income before income taxes 29.89% 28.67% 27.20% 25.67% 26.01% 14.36% 14.58% 23.28% 0.08% 25.28% 4.61% 10.46% 21.64% 1.17% 15.48% 18.70% 17.48% 11.65% 8.27% 21.13% 13.65% 13.30%
Income taxes -4.21 -3.81 -2.74 -2.77 -2.46 -3.34 2.89 -4.31 -4.17 -3.92 -31.51 -0.64 -4.34 -3.29 -2.09 -3.71 -3.64 -2.60 0.63 -5.00 -1.58 -1.90
Net income (loss) from continuing operations 25.68% 24.86% 24.46% 22.90% 23.55% 11.02% 17.47% 18.96% -4.09% 21.36% -26.89% 9.82% 17.31% -2.12% 13.40% 14.99% 13.83% 9.05% 8.90% 16.12% 12.07% 11.40%
Net income from discontinued operations 0.00 0.00 0.00 0.00 0.00 72.28 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00
Net income (loss) 25.68% 24.86% 24.46% 22.90% 23.55% 83.30% 17.47% 18.96% -4.09% 21.36% -26.89% 9.82% 17.31% -2.12% 13.40% 14.99% 13.83% 9.05% 8.90% 16.12% 12.07% 11.40%

Based on: 10-Q (filing date: 2020-07-31), 10-Q (filing date: 2020-05-01), 10-K (filing date: 2020-02-19), 10-Q (filing date: 2019-10-25), 10-Q (filing date: 2019-08-02), 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).

Income statement item Description The company
Operating income (loss) The net result for the period of deducting operating expenses from operating revenues. Eli Lilly & Co.’s operating income (loss) as a percentage of revenue increased from Q4 2019 to Q1 2020 but then decreased significantly from Q1 2020 to Q2 2020.
Income before income taxes Amount of income (loss) from continuing operations, including income (loss) from equity method investments, before deduction of income tax expense (benefit), and income (loss) attributable to noncontrolling interest. Eli Lilly & Co.’s income before income taxes as a percentage of revenue increased from Q4 2019 to Q1 2020 and from Q1 2020 to Q2 2020.
Net income (loss) The portion of profit or loss for the period, net of income taxes, which is attributable to the parent. Eli Lilly & Co.’s net income (loss) as a percentage of revenue increased from Q4 2019 to Q1 2020 and from Q1 2020 to Q2 2020.