Stock Analysis on Net
Stock Analysis on Net
Microsoft Excel LibreOffice Calc

ConocoPhillips (NYSE:COP)

Analysis of Long-term (Investment) Activity Ratios
Quarterly Data

Beginner level

Activity ratios measure how efficiently a company performs day-to-day tasks, such us the collection of receivables and management of inventory.

Long-term Activity Ratios (Summary)

ConocoPhillips, long-term (investment) activity ratios (quarterly data)

Microsoft Excel LibreOffice Calc
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
Net fixed asset turnover 0.59 0.73 0.77 0.79 0.82 0.80 0.80 0.78 0.69 0.66 0.64 0.60 0.59 0.48 0.41 0.38 0.38 0.41 0.44 — — —
Total asset turnover 0.39 0.45 0.46 0.49 0.51 0.51 0.52 0.49 0.47 0.43 0.40 0.37 0.35 0.30 0.26 0.25 0.25 0.27 0.30 — — —
Equity turnover 0.77 0.94 0.93 0.98 1.10 1.12 1.14 1.09 1.03 0.99 0.95 0.91 0.91 0.74 0.68 0.64 0.64 0.69 0.74 — — —

Based on: 10-Q (filing date: 2020-08-04), 10-Q (filing date: 2020-05-05), 10-K (filing date: 2020-02-18), 10-Q (filing date: 2019-10-31), 10-Q (filing date: 2019-08-01), 10-Q (filing date: 2019-05-02), 10-K (filing date: 2019-02-19), 10-Q (filing date: 2018-10-30), 10-Q (filing date: 2018-07-31), 10-Q (filing date: 2018-05-01), 10-K (filing date: 2018-02-20), 10-Q (filing date: 2017-10-31), 10-Q (filing date: 2017-08-01), 10-Q (filing date: 2017-05-04), 10-K (filing date: 2017-02-21), 10-Q (filing date: 2016-11-01), 10-Q (filing date: 2016-08-02), 10-Q (filing date: 2016-05-03), 10-K (filing date: 2016-02-23), 10-Q (filing date: 2015-11-03), 10-Q (filing date: 2015-08-04), 10-Q (filing date: 2015-05-05).

Long-term activity ratio Description The company
Net fixed asset turnover An activity ratio calculated as total revenue divided by net fixed assets. ConocoPhillips’s net fixed asset turnover ratio deteriorated from Q4 2019 to Q1 2020 and from Q1 2020 to Q2 2020.
Total asset turnover An activity ratio calculated as total revenue divided by total assets. ConocoPhillips’s total asset turnover ratio deteriorated from Q4 2019 to Q1 2020 and from Q1 2020 to Q2 2020.
Equity turnover An activity ratio calculated as total revenue divided by shareholders’ equity. ConocoPhillips’s equity turnover ratio improved from Q4 2019 to Q1 2020 but then deteriorated significantly from Q1 2020 to Q2 2020.

Net Fixed Asset Turnover

ConocoPhillips, net fixed asset turnover calculation (quarterly data)

Microsoft Excel LibreOffice Calc
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
Selected Financial Data (US$ in millions)
Sales and other operating revenues 2,749  6,158  7,708  7,756  7,953  9,150  9,666  9,449  8,504  8,798  8,119  6,688  6,781  7,518  6,809  6,415  5,348  5,121  6,293  7,262  8,293  7,716 
Net properties, plants and equipment, net of accumulated DD&A 41,120  40,645  42,269  43,814  44,334  45,942  45,698  44,736  46,306  45,997  45,683  46,669  46,846  54,440  58,331  61,649  63,685  66,000  66,446  71,828  74,387  74,220 
Long-term Activity Ratio
Net fixed asset turnover1 0.59 0.73 0.77 0.79 0.82 0.80 0.80 0.78 0.69 0.66 0.64 0.60 0.59 0.48 0.41 0.38 0.38 0.41 0.44 — — —
Benchmarks
Net Fixed Asset Turnover, Competitors2
Chevron Corp. 0.80 0.91 0.93 0.89 0.92 0.94 0.94 0.90 0.84 0.79 0.76 0.72 0.69 0.66 0.60 0.59 0.60 0.64 0.69 — — —
Exxon Mobil Corp. 0.85 1.00 1.01 1.04 1.08 1.11 1.13 1.12 1.06 0.98 0.94 0.89 0.90 0.90 0.90 0.87 0.89 0.95 1.03 — — —

Based on: 10-Q (filing date: 2020-08-04), 10-Q (filing date: 2020-05-05), 10-K (filing date: 2020-02-18), 10-Q (filing date: 2019-10-31), 10-Q (filing date: 2019-08-01), 10-Q (filing date: 2019-05-02), 10-K (filing date: 2019-02-19), 10-Q (filing date: 2018-10-30), 10-Q (filing date: 2018-07-31), 10-Q (filing date: 2018-05-01), 10-K (filing date: 2018-02-20), 10-Q (filing date: 2017-10-31), 10-Q (filing date: 2017-08-01), 10-Q (filing date: 2017-05-04), 10-K (filing date: 2017-02-21), 10-Q (filing date: 2016-11-01), 10-Q (filing date: 2016-08-02), 10-Q (filing date: 2016-05-03), 10-K (filing date: 2016-02-23), 10-Q (filing date: 2015-11-03), 10-Q (filing date: 2015-08-04), 10-Q (filing date: 2015-05-05).

1 Q2 2020 Calculation
Net fixed asset turnover = (Sales and other operating revenuesQ2 2020 + Sales and other operating revenuesQ1 2020 + Sales and other operating revenuesQ4 2019 + Sales and other operating revenuesQ3 2019) ÷ Net properties, plants and equipment, net of accumulated DD&A
= (2,749 + 6,158 + 7,708 + 7,756) ÷ 41,120 = 0.59

2 Click competitor name to see calculations.

Long-term activity ratio Description The company
Net fixed asset turnover An activity ratio calculated as total revenue divided by net fixed assets. ConocoPhillips’s net fixed asset turnover ratio deteriorated from Q4 2019 to Q1 2020 and from Q1 2020 to Q2 2020.

Total Asset Turnover

ConocoPhillips, total asset turnover calculation (quarterly data)

Microsoft Excel LibreOffice Calc
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
Selected Financial Data (US$ in millions)
Sales and other operating revenues 2,749  6,158  7,708  7,756  7,953  9,150  9,666  9,449  8,504  8,798  8,119  6,688  6,781  7,518  6,809  6,415  5,348  5,121  6,293  7,262  8,293  7,716 
Total assets 63,046  65,033  70,514  70,340  71,261  71,498  69,980  70,556  68,936  70,727  73,362  74,861  78,004  87,973  89,772  94,284  96,054  99,834  97,484  105,949  112,003  110,042 
Long-term Activity Ratio
Total asset turnover1 0.39 0.45 0.46 0.49 0.51 0.51 0.52 0.49 0.47 0.43 0.40 0.37 0.35 0.30 0.26 0.25 0.25 0.27 0.30 — — —
Benchmarks
Total Asset Turnover, Competitors2
Chevron Corp. 0.51 0.57 0.59 0.57 0.60 0.61 0.63 0.60 0.57 0.54 0.53 0.50 0.49 0.46 0.42 0.42 0.43 0.46 0.49 — — —
Exxon Mobil Corp. 0.59 0.70 0.70 0.73 0.75 0.77 0.81 0.78 0.75 0.71 0.68 0.65 0.66 0.66 0.66 0.64 0.66 0.71 0.77 — — —

Based on: 10-Q (filing date: 2020-08-04), 10-Q (filing date: 2020-05-05), 10-K (filing date: 2020-02-18), 10-Q (filing date: 2019-10-31), 10-Q (filing date: 2019-08-01), 10-Q (filing date: 2019-05-02), 10-K (filing date: 2019-02-19), 10-Q (filing date: 2018-10-30), 10-Q (filing date: 2018-07-31), 10-Q (filing date: 2018-05-01), 10-K (filing date: 2018-02-20), 10-Q (filing date: 2017-10-31), 10-Q (filing date: 2017-08-01), 10-Q (filing date: 2017-05-04), 10-K (filing date: 2017-02-21), 10-Q (filing date: 2016-11-01), 10-Q (filing date: 2016-08-02), 10-Q (filing date: 2016-05-03), 10-K (filing date: 2016-02-23), 10-Q (filing date: 2015-11-03), 10-Q (filing date: 2015-08-04), 10-Q (filing date: 2015-05-05).

1 Q2 2020 Calculation
Total asset turnover = (Sales and other operating revenuesQ2 2020 + Sales and other operating revenuesQ1 2020 + Sales and other operating revenuesQ4 2019 + Sales and other operating revenuesQ3 2019) ÷ Total assets
= (2,749 + 6,158 + 7,708 + 7,756) ÷ 63,046 = 0.39

2 Click competitor name to see calculations.

Long-term activity ratio Description The company
Total asset turnover An activity ratio calculated as total revenue divided by total assets. ConocoPhillips’s total asset turnover ratio deteriorated from Q4 2019 to Q1 2020 and from Q1 2020 to Q2 2020.

Equity Turnover

ConocoPhillips, equity turnover calculation (quarterly data)

Microsoft Excel LibreOffice Calc
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
Selected Financial Data (US$ in millions)
Sales and other operating revenues 2,749  6,158  7,708  7,756  7,953  9,150  9,666  9,449  8,504  8,798  8,119  6,688  6,781  7,518  6,809  6,415  5,348  5,121  6,293  7,262  8,293  7,716 
Common stockholders’ equity 31,493  31,315  34,981  35,146  32,976  32,859  31,939  31,950  31,042  30,546  30,607  30,500  30,286  35,353  34,974  36,170  37,544  39,089  39,762  44,210  48,620  48,652 
Long-term Activity Ratio
Equity turnover1 0.77 0.94 0.93 0.98 1.10 1.12 1.14 1.09 1.03 0.99 0.95 0.91 0.91 0.74 0.68 0.64 0.64 0.69 0.74 — — —
Benchmarks
Equity Turnover, Competitors2
Chevron Corp. 0.86 0.94 0.97 0.93 0.98 1.01 1.03 1.01 0.96 0.93 0.91 0.88 0.85 0.81 0.76 0.74 0.76 0.80 0.85 — — —
Exxon Mobil Corp. 1.19 1.37 1.33 1.37 1.42 1.44 1.46 1.46 1.40 1.31 1.26 1.25 1.27 1.29 1.31 1.28 1.33 1.40 1.52 — — —

Based on: 10-Q (filing date: 2020-08-04), 10-Q (filing date: 2020-05-05), 10-K (filing date: 2020-02-18), 10-Q (filing date: 2019-10-31), 10-Q (filing date: 2019-08-01), 10-Q (filing date: 2019-05-02), 10-K (filing date: 2019-02-19), 10-Q (filing date: 2018-10-30), 10-Q (filing date: 2018-07-31), 10-Q (filing date: 2018-05-01), 10-K (filing date: 2018-02-20), 10-Q (filing date: 2017-10-31), 10-Q (filing date: 2017-08-01), 10-Q (filing date: 2017-05-04), 10-K (filing date: 2017-02-21), 10-Q (filing date: 2016-11-01), 10-Q (filing date: 2016-08-02), 10-Q (filing date: 2016-05-03), 10-K (filing date: 2016-02-23), 10-Q (filing date: 2015-11-03), 10-Q (filing date: 2015-08-04), 10-Q (filing date: 2015-05-05).

1 Q2 2020 Calculation
Equity turnover = (Sales and other operating revenuesQ2 2020 + Sales and other operating revenuesQ1 2020 + Sales and other operating revenuesQ4 2019 + Sales and other operating revenuesQ3 2019) ÷ Common stockholders’ equity
= (2,749 + 6,158 + 7,708 + 7,756) ÷ 31,493 = 0.77

2 Click competitor name to see calculations.

Long-term activity ratio Description The company
Equity turnover An activity ratio calculated as total revenue divided by shareholders’ equity. ConocoPhillips’s equity turnover ratio improved from Q4 2019 to Q1 2020 but then deteriorated significantly from Q1 2020 to Q2 2020.