Common-Size Income Statement
Quarterly Data

Difficulty: Beginner

ConocoPhillips, Common-Size Consolidated Income Statement

Microsoft Excel LibreOffice Calc
3 months ended 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 Dec 31, 2013 Sep 30, 2013 Jun 30, 2013 Mar 31, 2013
Sales and other operating revenues 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   
Purchased commodities -36.03    -42.21    -42.31    -43.75    -43.09    -42.46    -43.30    -43.94    -37.43    -43.45    -42.75    -45.02    -38.95    -41.95    -42.59    -38.93    -39.76    -46.23    -42.10    -41.84    -41.36    -41.18   
Production and operating expenses -15.44    -13.31    -16.39    -18.30    -19.57    -17.17    -19.71    -23.79    -27.02    -26.44    -25.14    -25.25    -21.68    -23.35    -26.26    -16.90    -14.69    -12.29    -14.46    -14.38    -12.52    -11.91   
Cost of operating revenues -51.47% -55.52% -58.70% -62.05% -62.66% -59.63% -63.00% -67.73% -64.45% -69.89% -67.88% -70.27% -60.63% -65.31% -68.85% -55.83% -54.45% -58.53% -56.56% -56.22% -53.88% -53.09%
Gross profit 48.53% 44.48% 41.30% 37.95% 37.34% 40.37% 37.00% 32.27% 35.55% 30.11% 32.12% 29.73% 39.37% 34.69% 31.15% 44.17% 45.55% 41.47% 43.44% 43.78% 46.12% 46.91%
Selling, general and administrative expenses -1.39    -1.13    -2.44    -1.97    -1.98    -1.29    -2.45    -3.16    -3.12    -3.63    -4.50    -4.03    -2.63    -2.06    -1.18    -1.68    -1.58    -1.18    -1.86    -1.83    -1.45    -1.16   
Exploration expenses -0.81    -1.08    -2.65    -1.12    -1.45    -7.32    -5.04    -7.12    -11.41    -9.86    -33.37    -14.61    -6.62    -6.25    -6.90    -3.80    -3.74    -1.92    -2.42    -2.29    -2.40    -1.96   
Depreciation, depletion and amortization -16.91    -16.05    -20.11    -24.04    -23.96    -26.32    -30.27    -37.80    -43.55    -43.88    -37.85    -31.27    -28.08    -27.62    -20.26    -17.35    -14.98    -12.27    -14.28    -13.94    -13.72    -12.76   
Impairments 0.41    -0.14    -1.55    -0.09    -92.82    -2.33    2.67    -1.92    -1.16    -2.66    -33.80    -0.33    -0.94    -0.21    -6.51    -0.89    -0.12    -0.01    -3.76    -0.01    -0.21    -0.01   
Taxes other than income taxes -3.21    -2.08    -2.52    -2.62    -2.92    -3.07    -2.95    -2.51    -3.68    -3.51    -3.91    -2.84    -2.71    -2.90    -2.96    -4.08    -4.43    -4.22    -5.18    -4.87    -4.81    -6.30   
Accretion on discounted liabilities -1.05    -1.00    -1.06    -1.33    -1.36    -1.26    -1.41    -1.68    -2.09    -2.13    -1.88    -1.68    -1.47    -1.57    -1.13    -0.99    -0.87    -0.76    -0.88    -0.78    -0.79    -0.75   
Operating income (loss) 25.58% 23.01% 10.96% 6.77% -87.14% -1.22% -2.45% -21.93% -29.47% -35.56% -83.19% -25.03% -3.09% -5.91% -7.80% 15.37% 19.84% 21.11% 15.05% 20.07% 22.74% 23.97%
Equity in earnings (losses) of affiliates 3.12    2.36    2.44    2.93    2.62    2.66    2.66    -0.94    1.50    -2.91    -0.49    3.07    3.11    2.66    4.65    6.32    4.86    3.71    4.93    5.20    3.70    2.56   
Gain on dispositions 0.65    0.08    0.41    3.68    27.67    0.29    2.32    0.80    2.39    0.45    7.45    0.25    0.63    0.67    0.70    0.03    0.05    0.06    0.15    7.84    0.71    0.41   
Other income (loss) 4.89    -0.59    4.75    0.97    0.69    0.41    1.56    1.71    0.36    0.39    0.56    0.06    0.69    0.38    0.39    0.57    1.45    0.34    0.43    0.36    1.52    0.46   
Interest and debt expense -2.08    -2.09    -2.78    -3.75    -4.51    -4.19    -4.66    -5.22    -5.83    -5.49    -4.26    -3.30    -2.53    -2.62    -1.54    -1.23    -1.12    -1.11    -1.45    -1.11    -1.04    -0.92   
Foreign currency transaction gains (losses) 0.33    -0.34    -0.09    -0.07    -0.19    -0.13    0.46    -0.20    0.32    -0.31    -0.33    0.99    0.10    0.21    0.74    0.07    -0.05    -0.12    0.18    -0.07    0.05    0.25   
Other expense -1.68    -2.24    0.63    -0.76    -3.45    -0.90                                                                   
Income (loss) from continuing operations before income taxes 30.80% 20.19% 16.32% 9.76% -64.31% -3.09% -0.12% -25.78% -30.74% -43.43% -80.26% -23.97% -1.10% -4.61% -2.86% 21.13% 25.03% 23.99% 19.30% 32.29% 27.69% 26.73%
Income tax (provision) benefit -11.35    -9.96    3.36    -3.24    13.79    11.05    -0.16    9.79    10.96    15.00    25.65    9.43    -0.88    8.32    2.65    -7.48    -10.09    -10.26    -7.92    -14.41    -12.21    -12.45   
Income (loss) from continuing operations 19.45% 10.23% 19.68% 6.52% -50.52% 7.97% -0.28% -15.99% -19.78% -28.43% -54.62% -14.54% -1.98% 3.71% -0.21% 13.65% 14.94% 13.73% 11.38% 17.88% 15.48% 14.29%
Income (loss) from discontinued operations                                                             8.92    0.24    0.13    7.51    0.42    -0.02    0.91   
Net income (loss) 19.45% 10.23% 19.68% 6.52% -50.52% 7.97% -0.28% -15.99% -19.78% -28.43% -54.62% -14.54% -1.98% 3.71% -0.21% 22.57% 15.18% 13.86% 18.88% 18.30% 15.45% 15.20%
Net income attributable to noncontrolling interests -0.16    -0.14    -0.23    -0.24    -0.21    -0.17    -0.23    -0.22    -0.24    -0.25    -0.21    -0.21    -0.18    -0.18    -0.13    -0.19    -0.12    -0.09    -0.12    -0.12    -0.10    -0.10   
Net income (loss) attributable to ConocoPhillips 19.29% 10.09% 19.45% 6.28% -50.73% 7.79% -0.51% -16.21% -20.03% -28.69% -54.82% -14.75% -2.16% 3.53% -0.35% 22.38% 15.06% 13.77% 18.76% 18.18% 15.36% 15.10%