Microsoft Excel LibreOffice Calc

Common-Size Income Statement

Difficulty: Beginner

ConocoPhillips, Common-Size Consolidated Income Statement

Microsoft Excel LibreOffice Calc
12 months ended Dec 31, 2017 Dec 31, 2016 Dec 31, 2015 Dec 31, 2014 Dec 31, 2013
Sales and other operating revenues 100.00 100.00 100.00 100.00 100.00
Purchased commodities -42.86 -42.18 -42.03 -42.07 -41.61
Production and operating expenses -17.77 -23.92 -23.73 -16.96 -13.30
Cost of operating revenues -60.63% -66.10% -65.76% -59.04% -54.92%
Gross profit 39.37% 33.90% 34.24% 40.96% 45.08%
Selling, general and administrative expenses -1.93 -3.05 -3.22 -1.40 -1.57
Exploration expenses -3.22 -8.08 -14.18 -3.89 -2.26
Depreciation, depletion and amortization -23.52 -38.25 -30.82 -15.86 -13.66
Impairments -22.68 -0.59 -7.59 -1.63 -0.97
Taxes other than income taxes -2.78 -3.12 -3.05 -3.98 -5.30
Accretion on discounted liabilities -1.24 -1.79 -1.63 -0.92 -0.80
Operating income (loss) -16.00% -20.98% -26.27% 13.29% 20.52%
Equity in earnings of affiliates 2.65 0.22 2.22 4.81 4.08
Gain on dispositions 7.48 1.52 2.00 0.19 2.28
Interest income 0.38 0.24 0.15 0.16 0.21
Other, net 1.43 0.84 0.27 0.54 0.48
Other income 1.82% 1.08% 0.42% 0.70% 0.69%
Interest and debt expense -3.77 -5.25 -3.11 -1.23 -1.12
Foreign currency transaction gains (losses) -0.12 0.08 0.25 0.13 0.11
Other expense -1.04 0.00 0.00 0.00 0.00
Income (loss) from continuing operations before income taxes -8.98% -23.34% -24.49% 17.88% 26.55%
Income tax (provision) benefit 6.26 8.32 9.70 -6.82 -11.78
Income (loss) from continuing operations -2.72% -15.02% -14.78% 11.06% 14.77%
Income from discontinued operations 0.00 0.00 0.00 2.15 2.16
Net income (loss) -2.72% -15.02% -14.78% 13.21% 16.94%
Net income attributable to noncontrolling interests -0.21 -0.24 -0.19 -0.13 -0.11
Net income (loss) attributable to ConocoPhillips -2.94% -15.26% -14.98% 13.08% 16.83%

Based on: 10-K (filing date: 2018-02-20), 10-K (filing date: 2017-02-21), 10-K (filing date: 2016-02-23), 10-K (filing date: 2015-02-24), 10-K (filing date: 2014-02-25).

Item Description The company
Operating income (loss) The net result for the period of deducting operating expenses from operating revenues. ConocoPhillips's operating income (loss) as a percentage of sales and other operating revenues increased from 2015 to 2016 and from 2016 to 2017.
Income (loss) from continuing operations 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. ConocoPhillips's income (loss) from continuing operations before income taxes as a percentage of sales and other operating revenues increased from 2015 to 2016 and from 2016 to 2017.
Net income (loss) attributable to ConocoPhillips The portion of profit or loss for the period, net of income taxes, which is attributable to the parent. ConocoPhillips's net income (loss) attributable to ConocoPhillips as a percentage of sales and other operating revenues declined from 2015 to 2016 but then increased from 2016 to 2017 exceeding 2015 level.