Stock Analysis on Net

ConocoPhillips (NYSE:COP)

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

Microsoft Excel

Long-term Activity Ratios (Summary)

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

Microsoft Excel
Dec 31, 2023 Sep 30, 2023 Jun 30, 2023 Mar 31, 2023 Dec 31, 2022 Sep 30, 2022 Jun 30, 2022 Mar 31, 2022 Dec 31, 2021 Sep 30, 2021 Jun 30, 2021 Mar 31, 2021 Dec 31, 2020 Sep 30, 2020 Jun 30, 2020 Mar 31, 2020 Dec 31, 2019 Sep 30, 2019 Jun 30, 2019 Mar 31, 2019
Net fixed asset turnover 0.80 0.91 1.02 1.16 1.21 1.18 1.02 0.83 0.71 0.64 0.51 0.39 0.47 0.51 0.59 0.73 0.77
Total asset turnover 0.59 0.64 0.74 0.83 0.84 0.79 0.70 0.58 0.51 0.41 0.34 0.27 0.30 0.33 0.39 0.45 0.46
Equity turnover 1.14 1.26 1.40 1.58 1.64 1.53 1.30 1.09 1.01 0.82 0.66 0.52 0.63 0.68 0.77 0.94 0.93

Based on: 10-K (reporting date: 2023-12-31), 10-Q (reporting date: 2023-09-30), 10-Q (reporting date: 2023-06-30), 10-Q (reporting date: 2023-03-31), 10-K (reporting date: 2022-12-31), 10-Q (reporting date: 2022-09-30), 10-Q (reporting date: 2022-06-30), 10-Q (reporting date: 2022-03-31), 10-K (reporting date: 2021-12-31), 10-Q (reporting date: 2021-09-30), 10-Q (reporting date: 2021-06-30), 10-Q (reporting date: 2021-03-31), 10-K (reporting date: 2020-12-31), 10-Q (reporting date: 2020-09-30), 10-Q (reporting date: 2020-06-30), 10-Q (reporting date: 2020-03-31), 10-K (reporting date: 2019-12-31), 10-Q (reporting date: 2019-09-30), 10-Q (reporting date: 2019-06-30), 10-Q (reporting date: 2019-03-31).

Long-term activity ratio Description The company
Net fixed asset turnover An activity ratio calculated as total revenue divided by net fixed assets. ConocoPhillips net fixed asset turnover ratio deteriorated from Q2 2023 to Q3 2023 and from Q3 2023 to Q4 2023.
Total asset turnover An activity ratio calculated as total revenue divided by total assets. ConocoPhillips total asset turnover ratio deteriorated from Q2 2023 to Q3 2023 and from Q3 2023 to Q4 2023.
Equity turnover An activity ratio calculated as total revenue divided by shareholders’ equity. ConocoPhillips equity turnover ratio deteriorated from Q2 2023 to Q3 2023 and from Q3 2023 to Q4 2023.

Net Fixed Asset Turnover

ConocoPhillips, net fixed asset turnover calculation (quarterly data)

Microsoft Excel
Dec 31, 2023 Sep 30, 2023 Jun 30, 2023 Mar 31, 2023 Dec 31, 2022 Sep 30, 2022 Jun 30, 2022 Mar 31, 2022 Dec 31, 2021 Sep 30, 2021 Jun 30, 2021 Mar 31, 2021 Dec 31, 2020 Sep 30, 2020 Jun 30, 2020 Mar 31, 2020 Dec 31, 2019 Sep 30, 2019 Jun 30, 2019 Mar 31, 2019
Selected Financial Data (US$ in millions)
Sales and other operating revenues 14,729 14,250 12,351 14,811 18,558 21,013 21,161 17,762 15,120 11,326 9,556 9,826 5,491 4,386 2,749 6,158 7,708 7,756 7,953 9,150
Net properties, plants and equipment, net of accumulated DD&A 70,044 65,561 65,452 65,090 64,866 63,673 64,008 64,642 64,911 56,689 57,717 58,270 39,893 41,269 41,120 40,645 42,269 43,814 44,334 45,942
Long-term Activity Ratio
Net fixed asset turnover1 0.80 0.91 1.02 1.16 1.21 1.18 1.02 0.83 0.71 0.64 0.51 0.39 0.47 0.51 0.59 0.73 0.77
Benchmarks
Net Fixed Asset Turnover, Competitors2
Chevron Corp. 1.28 1.32 1.50 1.62 1.64 1.58 1.43 1.22 1.06 0.91 0.77 0.62 0.60 0.73 0.80 0.91 0.93
Exxon Mobil Corp. 1.56 1.68 1.76 1.92 1.95 1.90 1.68 1.44 1.28 1.10 0.96 0.81 0.78 0.78 0.85 1.00 1.01
Marathon Petroleum Corp. 4.23 4.38 4.47 4.92 4.98 4.89 4.30 3.64 3.20 2.73 2.31 1.83 1.79 2.09 2.14 2.60 2.72
Occidental Petroleum Corp. 0.48 0.50 0.54 0.61 0.63 0.62 0.58 0.49 0.43 0.37 0.32 0.26 0.27 0.29 0.30 0.29 0.25
Pioneer Natural Resources Co. 0.58 0.59 0.63 0.72 0.78 0.81 0.78 0.70 0.60 0.42 0.33 0.30 0.44 0.48 0.51 0.58 0.60
Valero Energy Corp. 4.79 4.99 5.14 5.66 5.69 5.59 5.06 4.27 3.69 3.11 2.66 2.09 2.14 2.48 2.86 3.48 3.70

Based on: 10-K (reporting date: 2023-12-31), 10-Q (reporting date: 2023-09-30), 10-Q (reporting date: 2023-06-30), 10-Q (reporting date: 2023-03-31), 10-K (reporting date: 2022-12-31), 10-Q (reporting date: 2022-09-30), 10-Q (reporting date: 2022-06-30), 10-Q (reporting date: 2022-03-31), 10-K (reporting date: 2021-12-31), 10-Q (reporting date: 2021-09-30), 10-Q (reporting date: 2021-06-30), 10-Q (reporting date: 2021-03-31), 10-K (reporting date: 2020-12-31), 10-Q (reporting date: 2020-09-30), 10-Q (reporting date: 2020-06-30), 10-Q (reporting date: 2020-03-31), 10-K (reporting date: 2019-12-31), 10-Q (reporting date: 2019-09-30), 10-Q (reporting date: 2019-06-30), 10-Q (reporting date: 2019-03-31).

1 Q4 2023 Calculation
Net fixed asset turnover = (Sales and other operating revenuesQ4 2023 + Sales and other operating revenuesQ3 2023 + Sales and other operating revenuesQ2 2023 + Sales and other operating revenuesQ1 2023) ÷ Net properties, plants and equipment, net of accumulated DD&A
= (14,729 + 14,250 + 12,351 + 14,811) ÷ 70,044 = 0.80

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 net fixed asset turnover ratio deteriorated from Q2 2023 to Q3 2023 and from Q3 2023 to Q4 2023.

Total Asset Turnover

ConocoPhillips, total asset turnover calculation (quarterly data)

Microsoft Excel
Dec 31, 2023 Sep 30, 2023 Jun 30, 2023 Mar 31, 2023 Dec 31, 2022 Sep 30, 2022 Jun 30, 2022 Mar 31, 2022 Dec 31, 2021 Sep 30, 2021 Jun 30, 2021 Mar 31, 2021 Dec 31, 2020 Sep 30, 2020 Jun 30, 2020 Mar 31, 2020 Dec 31, 2019 Sep 30, 2019 Jun 30, 2019 Mar 31, 2019
Selected Financial Data (US$ in millions)
Sales and other operating revenues 14,729 14,250 12,351 14,811 18,558 21,013 21,161 17,762 15,120 11,326 9,556 9,826 5,491 4,386 2,749 6,158 7,708 7,756 7,953 9,150
Total assets 95,924 93,651 89,605 91,441 93,829 94,837 93,693 93,308 90,661 87,304 85,403 83,693 62,618 63,157 63,046 65,033 70,514 70,340 71,261 71,498
Long-term Activity Ratio
Total asset turnover1 0.59 0.64 0.74 0.83 0.84 0.79 0.70 0.58 0.51 0.41 0.34 0.27 0.30 0.33 0.39 0.45 0.46
Benchmarks
Total Asset Turnover, Competitors2
Chevron Corp. 0.75 0.77 0.85 0.91 0.91 0.87 0.80 0.71 0.65 0.56 0.48 0.40 0.39 0.47 0.51 0.57 0.59
Exxon Mobil Corp. 0.89 0.93 1.00 1.07 1.08 1.05 0.96 0.86 0.82 0.72 0.64 0.54 0.54 0.55 0.59 0.70 0.70
Marathon Petroleum Corp. 1.73 1.69 1.81 2.00 1.97 1.93 1.65 1.49 1.41 1.15 0.93 0.81 0.82 0.99 1.14 1.37 1.26
Occidental Petroleum Corp. 0.38 0.41 0.44 0.50 0.50 0.50 0.45 0.39 0.35 0.29 0.24 0.21 0.22 0.24 0.24 0.23 0.19
Pioneer Natural Resources Co. 0.53 0.54 0.57 0.63 0.68 0.69 0.64 0.57 0.49 0.38 0.30 0.27 0.37 0.40 0.46 0.50 0.51
Valero Energy Corp. 2.30 2.39 2.59 2.90 2.89 2.87 2.42 2.18 1.97 1.73 1.46 1.19 1.25 1.47 1.78 2.22 2.01

Based on: 10-K (reporting date: 2023-12-31), 10-Q (reporting date: 2023-09-30), 10-Q (reporting date: 2023-06-30), 10-Q (reporting date: 2023-03-31), 10-K (reporting date: 2022-12-31), 10-Q (reporting date: 2022-09-30), 10-Q (reporting date: 2022-06-30), 10-Q (reporting date: 2022-03-31), 10-K (reporting date: 2021-12-31), 10-Q (reporting date: 2021-09-30), 10-Q (reporting date: 2021-06-30), 10-Q (reporting date: 2021-03-31), 10-K (reporting date: 2020-12-31), 10-Q (reporting date: 2020-09-30), 10-Q (reporting date: 2020-06-30), 10-Q (reporting date: 2020-03-31), 10-K (reporting date: 2019-12-31), 10-Q (reporting date: 2019-09-30), 10-Q (reporting date: 2019-06-30), 10-Q (reporting date: 2019-03-31).

1 Q4 2023 Calculation
Total asset turnover = (Sales and other operating revenuesQ4 2023 + Sales and other operating revenuesQ3 2023 + Sales and other operating revenuesQ2 2023 + Sales and other operating revenuesQ1 2023) ÷ Total assets
= (14,729 + 14,250 + 12,351 + 14,811) ÷ 95,924 = 0.59

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 total asset turnover ratio deteriorated from Q2 2023 to Q3 2023 and from Q3 2023 to Q4 2023.

Equity Turnover

ConocoPhillips, equity turnover calculation (quarterly data)

Microsoft Excel
Dec 31, 2023 Sep 30, 2023 Jun 30, 2023 Mar 31, 2023 Dec 31, 2022 Sep 30, 2022 Jun 30, 2022 Mar 31, 2022 Dec 31, 2021 Sep 30, 2021 Jun 30, 2021 Mar 31, 2021 Dec 31, 2020 Sep 30, 2020 Jun 30, 2020 Mar 31, 2020 Dec 31, 2019 Sep 30, 2019 Jun 30, 2019 Mar 31, 2019
Selected Financial Data (US$ in millions)
Sales and other operating revenues 14,729 14,250 12,351 14,811 18,558 21,013 21,161 17,762 15,120 11,326 9,556 9,826 5,491 4,386 2,749 6,158 7,708 7,756 7,953 9,150
Common stockholders’ equity 49,279 47,745 47,531 47,783 48,003 49,079 50,202 49,218 45,406 44,115 44,276 43,155 29,849 30,783 31,493 31,315 34,981 35,146 32,976 32,859
Long-term Activity Ratio
Equity turnover1 1.14 1.26 1.40 1.58 1.64 1.53 1.30 1.09 1.01 0.82 0.66 0.52 0.63 0.68 0.77 0.94 0.93
Benchmarks
Equity Turnover, Competitors2
Chevron Corp. 1.22 1.23 1.35 1.46 1.48 1.43 1.34 1.21 1.12 0.99 0.87 0.73 0.72 0.79 0.86 0.94 0.97
Exxon Mobil Corp. 1.63 1.73 1.83 1.99 2.04 2.08 1.99 1.81 1.64 1.50 1.35 1.15 1.14 1.10 1.19 1.37 1.33
Marathon Petroleum Corp. 6.08 5.87 6.10 6.49 6.40 6.58 6.06 5.65 4.58 3.63 3.03 3.26 3.14 3.69 4.07 4.89 3.68
Occidental Petroleum Corp. 0.93 1.00 1.08 1.20 1.22 1.26 1.21 1.16 1.28 1.18 1.07 0.90 0.96 1.00 0.92 0.74 0.60
Pioneer Natural Resources Co. 0.84 0.86 0.93 1.05 1.08 1.08 1.00 0.89 0.78 0.62 0.50 0.45 0.61 0.66 0.70 0.77 0.80
Valero Energy Corp. 5.49 5.82 6.08 6.98 7.49 7.78 7.42 7.00 6.18 5.42 4.59 3.57 3.45 3.96 4.42 5.63 4.97

Based on: 10-K (reporting date: 2023-12-31), 10-Q (reporting date: 2023-09-30), 10-Q (reporting date: 2023-06-30), 10-Q (reporting date: 2023-03-31), 10-K (reporting date: 2022-12-31), 10-Q (reporting date: 2022-09-30), 10-Q (reporting date: 2022-06-30), 10-Q (reporting date: 2022-03-31), 10-K (reporting date: 2021-12-31), 10-Q (reporting date: 2021-09-30), 10-Q (reporting date: 2021-06-30), 10-Q (reporting date: 2021-03-31), 10-K (reporting date: 2020-12-31), 10-Q (reporting date: 2020-09-30), 10-Q (reporting date: 2020-06-30), 10-Q (reporting date: 2020-03-31), 10-K (reporting date: 2019-12-31), 10-Q (reporting date: 2019-09-30), 10-Q (reporting date: 2019-06-30), 10-Q (reporting date: 2019-03-31).

1 Q4 2023 Calculation
Equity turnover = (Sales and other operating revenuesQ4 2023 + Sales and other operating revenuesQ3 2023 + Sales and other operating revenuesQ2 2023 + Sales and other operating revenuesQ1 2023) ÷ Common stockholders’ equity
= (14,729 + 14,250 + 12,351 + 14,811) ÷ 49,279 = 1.14

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 equity turnover ratio deteriorated from Q2 2023 to Q3 2023 and from Q3 2023 to Q4 2023.