Stock Analysis on Net

ConocoPhillips (NYSE:COP)

Analysis of Reportable Segments 

Microsoft Excel LibreOffice Calc

Segment Profit Margin

ConocoPhillips, profit margin by reportable segment

Microsoft Excel LibreOffice Calc
Dec 31, 2021 Dec 31, 2020 Dec 31, 2019 Dec 31, 2018 Dec 31, 2017
Alaska 25.29% -21.10% 27.72% 31.60% 34.71%
Lower 48 16.83% -11.37% 2.81% 10.26% -18.28%
Canada 11.23% -19.57% 9.59% 1.98% 80.68%
Europe, Middle East and North Africa 19.77% 23.35% 62.14% 39.10% 10.67%
Asia Pacific 17.56% 40.71% 32.77% 27.61% -27.35%
Other International -2,675.00% -914.29%

Based on: 10-K (reporting date: 2021-12-31), 10-K (reporting date: 2020-12-31), 10-K (reporting date: 2019-12-31), 10-K (reporting date: 2018-12-31), 10-K (reporting date: 2017-12-31).

Segment profitability ratio Reportable segment The company
Segment profit margin Alaska Alaska segment profit margin ratio deteriorated from 2019 to 2020 but then improved from 2020 to 2021 not reaching 2019 level.
Lower 48 Lower 48 segment profit margin ratio deteriorated from 2019 to 2020 but then improved from 2020 to 2021 exceeding 2019 level.
Canada Canada segment profit margin ratio deteriorated from 2019 to 2020 but then improved from 2020 to 2021 exceeding 2019 level.
Europe, Middle East and North Africa Europe, Middle East and North Africa segment profit margin ratio deteriorated from 2019 to 2020 and from 2020 to 2021.
Asia Pacific Asia Pacific segment profit margin ratio improved from 2019 to 2020 but then deteriorated significantly from 2020 to 2021.
Other International Other International segment profit margin ratio improved from 2019 to 2020 but then slightly deteriorated from 2020 to 2021 not reaching 2019 level.

Segment Profit Margin: Alaska

ConocoPhillips; Alaska; segment profit margin calculation

Microsoft Excel LibreOffice Calc
Dec 31, 2021 Dec 31, 2020 Dec 31, 2019 Dec 31, 2018 Dec 31, 2017
Selected Financial Data (US$ in millions)
Net income (loss) attributable to ConocoPhillips 1,386  (719) 1,520  1,814  1,466 
Sales and other operating revenues 5,480  3,408  5,483  5,740  4,224 
Segment Profitability Ratio
Segment profit margin1 25.29% -21.10% 27.72% 31.60% 34.71%

Based on: 10-K (reporting date: 2021-12-31), 10-K (reporting date: 2020-12-31), 10-K (reporting date: 2019-12-31), 10-K (reporting date: 2018-12-31), 10-K (reporting date: 2017-12-31).

1 2021 Calculation
Segment profit margin = 100 × Net income (loss) attributable to ConocoPhillips ÷ Sales and other operating revenues
= 100 × 1,386 ÷ 5,480 = 25.29%

Segment profitability ratio Reportable segment The company
Segment profit margin Alaska Alaska segment profit margin ratio deteriorated from 2019 to 2020 but then improved from 2020 to 2021 not reaching 2019 level.

Segment Profit Margin: Lower 48

ConocoPhillips; Lower 48; segment profit margin calculation

Microsoft Excel LibreOffice Calc
Dec 31, 2021 Dec 31, 2020 Dec 31, 2019 Dec 31, 2018 Dec 31, 2017
Selected Financial Data (US$ in millions)
Net income (loss) attributable to ConocoPhillips 4,932  (1,122) 436  1,747  (2,371)
Sales and other operating revenues 29,306  9,872  15,514  17,029  12,968 
Segment Profitability Ratio
Segment profit margin1 16.83% -11.37% 2.81% 10.26% -18.28%

Based on: 10-K (reporting date: 2021-12-31), 10-K (reporting date: 2020-12-31), 10-K (reporting date: 2019-12-31), 10-K (reporting date: 2018-12-31), 10-K (reporting date: 2017-12-31).

1 2021 Calculation
Segment profit margin = 100 × Net income (loss) attributable to ConocoPhillips ÷ Sales and other operating revenues
= 100 × 4,932 ÷ 29,306 = 16.83%

Segment profitability ratio Reportable segment The company
Segment profit margin Lower 48 Lower 48 segment profit margin ratio deteriorated from 2019 to 2020 but then improved from 2020 to 2021 exceeding 2019 level.

Segment Profit Margin: Canada

ConocoPhillips; Canada; segment profit margin calculation

Microsoft Excel LibreOffice Calc
Dec 31, 2021 Dec 31, 2020 Dec 31, 2019 Dec 31, 2018 Dec 31, 2017
Selected Financial Data (US$ in millions)
Net income (loss) attributable to ConocoPhillips 458  (326) 279  63  2,564 
Sales and other operating revenues 4,077  1,666  2,910  3,184  3,178 
Segment Profitability Ratio
Segment profit margin1 11.23% -19.57% 9.59% 1.98% 80.68%

Based on: 10-K (reporting date: 2021-12-31), 10-K (reporting date: 2020-12-31), 10-K (reporting date: 2019-12-31), 10-K (reporting date: 2018-12-31), 10-K (reporting date: 2017-12-31).

1 2021 Calculation
Segment profit margin = 100 × Net income (loss) attributable to ConocoPhillips ÷ Sales and other operating revenues
= 100 × 458 ÷ 4,077 = 11.23%

Segment profitability ratio Reportable segment The company
Segment profit margin Canada Canada segment profit margin ratio deteriorated from 2019 to 2020 but then improved from 2020 to 2021 exceeding 2019 level.

Segment Profit Margin: Europe, Middle East and North Africa

ConocoPhillips; Europe, Middle East and North Africa; segment profit margin calculation

Microsoft Excel LibreOffice Calc
Dec 31, 2021 Dec 31, 2020 Dec 31, 2019 Dec 31, 2018 Dec 31, 2017
Selected Financial Data (US$ in millions)
Net income (loss) attributable to ConocoPhillips 1,167  448  3,170  2,594  553 
Sales and other operating revenues 5,902  1,919  5,101  6,635  5,181 
Segment Profitability Ratio
Segment profit margin1 19.77% 23.35% 62.14% 39.10% 10.67%

Based on: 10-K (reporting date: 2021-12-31), 10-K (reporting date: 2020-12-31), 10-K (reporting date: 2019-12-31), 10-K (reporting date: 2018-12-31), 10-K (reporting date: 2017-12-31).

1 2021 Calculation
Segment profit margin = 100 × Net income (loss) attributable to ConocoPhillips ÷ Sales and other operating revenues
= 100 × 1,167 ÷ 5,902 = 19.77%

Segment profitability ratio Reportable segment The company
Segment profit margin Europe, Middle East and North Africa Europe, Middle East and North Africa segment profit margin ratio deteriorated from 2019 to 2020 and from 2020 to 2021.

Segment Profit Margin: Asia Pacific

ConocoPhillips; Asia Pacific; segment profit margin calculation

Microsoft Excel LibreOffice Calc
Dec 31, 2021 Dec 31, 2020 Dec 31, 2019 Dec 31, 2018 Dec 31, 2017
Selected Financial Data (US$ in millions)
Net income (loss) attributable to ConocoPhillips 453  962  1,483  1,342  (1,098)
Sales and other operating revenues 2,579  2,363  4,525  4,861  4,014 
Segment Profitability Ratio
Segment profit margin1 17.56% 40.71% 32.77% 27.61% -27.35%

Based on: 10-K (reporting date: 2021-12-31), 10-K (reporting date: 2020-12-31), 10-K (reporting date: 2019-12-31), 10-K (reporting date: 2018-12-31), 10-K (reporting date: 2017-12-31).

1 2021 Calculation
Segment profit margin = 100 × Net income (loss) attributable to ConocoPhillips ÷ Sales and other operating revenues
= 100 × 453 ÷ 2,579 = 17.56%

Segment profitability ratio Reportable segment The company
Segment profit margin Asia Pacific Asia Pacific segment profit margin ratio improved from 2019 to 2020 but then deteriorated significantly from 2020 to 2021.

Segment Profit Margin: Other International

ConocoPhillips; Other International; segment profit margin calculation

Microsoft Excel LibreOffice Calc
Dec 31, 2021 Dec 31, 2020 Dec 31, 2019 Dec 31, 2018 Dec 31, 2017
Selected Financial Data (US$ in millions)
Net income (loss) attributable to ConocoPhillips (107) (64) 263  364  167 
Sales and other operating revenues —  —  — 
Segment Profitability Ratio
Segment profit margin1 -2,675.00% -914.29%

Based on: 10-K (reporting date: 2021-12-31), 10-K (reporting date: 2020-12-31), 10-K (reporting date: 2019-12-31), 10-K (reporting date: 2018-12-31), 10-K (reporting date: 2017-12-31).

1 2021 Calculation
Segment profit margin = 100 × Net income (loss) attributable to ConocoPhillips ÷ Sales and other operating revenues
= 100 × -107 ÷ 4 = -2,675.00%

Segment profitability ratio Reportable segment The company
Segment profit margin Other International Other International segment profit margin ratio improved from 2019 to 2020 but then slightly deteriorated from 2020 to 2021 not reaching 2019 level.

Segment Return on Assets (Segment ROA)

ConocoPhillips, ROA by reportable segment

Microsoft Excel LibreOffice Calc
Dec 31, 2021 Dec 31, 2020 Dec 31, 2019 Dec 31, 2018 Dec 31, 2017
Alaska 9.36% -4.92% 9.84% 12.38% 12.11%
Lower 48 11.83% -9.40% 3.02% 11.73% -16.20%
Canada 6.16% -4.75% 4.39% 1.10% 41.26%
Europe, Middle East and North Africa 12.79% 5.12% 34.20% 23.00% 4.66%
Asia Pacific 4.60% 8.57% 10.93% 9.09% -6.46%
Other International -10,700.00% -28.32% 92.28% 408.99% 172.16%

Based on: 10-K (reporting date: 2021-12-31), 10-K (reporting date: 2020-12-31), 10-K (reporting date: 2019-12-31), 10-K (reporting date: 2018-12-31), 10-K (reporting date: 2017-12-31).

Segment profitability ratio Reportable segment The company
Segment ROA Alaska Alaska segment ROA deteriorated from 2019 to 2020 but then improved from 2020 to 2021 not reaching 2019 level.
Lower 48 Lower 48 segment ROA deteriorated from 2019 to 2020 but then improved from 2020 to 2021 exceeding 2019 level.
Canada Canada segment ROA deteriorated from 2019 to 2020 but then improved from 2020 to 2021 exceeding 2019 level.
Europe, Middle East and North Africa Europe, Middle East and North Africa segment ROA deteriorated from 2019 to 2020 but then slightly improved from 2020 to 2021.
Asia Pacific Asia Pacific segment ROA deteriorated from 2019 to 2020 and from 2020 to 2021.
Other International Other International segment ROA deteriorated from 2019 to 2020 and from 2020 to 2021.

Segment ROA: Alaska

ConocoPhillips; Alaska; segment ROA calculation

Microsoft Excel LibreOffice Calc
Dec 31, 2021 Dec 31, 2020 Dec 31, 2019 Dec 31, 2018 Dec 31, 2017
Selected Financial Data (US$ in millions)
Net income (loss) attributable to ConocoPhillips 1,386  (719) 1,520  1,814  1,466 
Total assets 14,812  14,623  15,453  14,648  12,108 
Segment Profitability Ratio
Segment ROA1 9.36% -4.92% 9.84% 12.38% 12.11%

Based on: 10-K (reporting date: 2021-12-31), 10-K (reporting date: 2020-12-31), 10-K (reporting date: 2019-12-31), 10-K (reporting date: 2018-12-31), 10-K (reporting date: 2017-12-31).

1 2021 Calculation
Segment ROA = 100 × Net income (loss) attributable to ConocoPhillips ÷ Total assets
= 100 × 1,386 ÷ 14,812 = 9.36%

Segment profitability ratio Reportable segment The company
Segment ROA Alaska Alaska segment ROA deteriorated from 2019 to 2020 but then improved from 2020 to 2021 not reaching 2019 level.

Segment ROA: Lower 48

ConocoPhillips; Lower 48; segment ROA calculation

Microsoft Excel LibreOffice Calc
Dec 31, 2021 Dec 31, 2020 Dec 31, 2019 Dec 31, 2018 Dec 31, 2017
Selected Financial Data (US$ in millions)
Net income (loss) attributable to ConocoPhillips 4,932  (1,122) 436  1,747  (2,371)
Total assets 41,699  11,932  14,425  14,888  14,632 
Segment Profitability Ratio
Segment ROA1 11.83% -9.40% 3.02% 11.73% -16.20%

Based on: 10-K (reporting date: 2021-12-31), 10-K (reporting date: 2020-12-31), 10-K (reporting date: 2019-12-31), 10-K (reporting date: 2018-12-31), 10-K (reporting date: 2017-12-31).

1 2021 Calculation
Segment ROA = 100 × Net income (loss) attributable to ConocoPhillips ÷ Total assets
= 100 × 4,932 ÷ 41,699 = 11.83%

Segment profitability ratio Reportable segment The company
Segment ROA Lower 48 Lower 48 segment ROA deteriorated from 2019 to 2020 but then improved from 2020 to 2021 exceeding 2019 level.

Segment ROA: Canada

ConocoPhillips; Canada; segment ROA calculation

Microsoft Excel LibreOffice Calc
Dec 31, 2021 Dec 31, 2020 Dec 31, 2019 Dec 31, 2018 Dec 31, 2017
Selected Financial Data (US$ in millions)
Net income (loss) attributable to ConocoPhillips 458  (326) 279  63  2,564 
Total assets 7,439  6,863  6,350  5,748  6,214 
Segment Profitability Ratio
Segment ROA1 6.16% -4.75% 4.39% 1.10% 41.26%

Based on: 10-K (reporting date: 2021-12-31), 10-K (reporting date: 2020-12-31), 10-K (reporting date: 2019-12-31), 10-K (reporting date: 2018-12-31), 10-K (reporting date: 2017-12-31).

1 2021 Calculation
Segment ROA = 100 × Net income (loss) attributable to ConocoPhillips ÷ Total assets
= 100 × 458 ÷ 7,439 = 6.16%

Segment profitability ratio Reportable segment The company
Segment ROA Canada Canada segment ROA deteriorated from 2019 to 2020 but then improved from 2020 to 2021 exceeding 2019 level.

Segment ROA: Europe, Middle East and North Africa

ConocoPhillips; Europe, Middle East and North Africa; segment ROA calculation

Microsoft Excel LibreOffice Calc
Dec 31, 2021 Dec 31, 2020 Dec 31, 2019 Dec 31, 2018 Dec 31, 2017
Selected Financial Data (US$ in millions)
Net income (loss) attributable to ConocoPhillips 1,167  448  3,170  2,594  553 
Total assets 9,125  8,756  9,269  11,276  11,870 
Segment Profitability Ratio
Segment ROA1 12.79% 5.12% 34.20% 23.00% 4.66%

Based on: 10-K (reporting date: 2021-12-31), 10-K (reporting date: 2020-12-31), 10-K (reporting date: 2019-12-31), 10-K (reporting date: 2018-12-31), 10-K (reporting date: 2017-12-31).

1 2021 Calculation
Segment ROA = 100 × Net income (loss) attributable to ConocoPhillips ÷ Total assets
= 100 × 1,167 ÷ 9,125 = 12.79%

Segment profitability ratio Reportable segment The company
Segment ROA Europe, Middle East and North Africa Europe, Middle East and North Africa segment ROA deteriorated from 2019 to 2020 but then slightly improved from 2020 to 2021.

Segment ROA: Asia Pacific

ConocoPhillips; Asia Pacific; segment ROA calculation

Microsoft Excel LibreOffice Calc
Dec 31, 2021 Dec 31, 2020 Dec 31, 2019 Dec 31, 2018 Dec 31, 2017
Selected Financial Data (US$ in millions)
Net income (loss) attributable to ConocoPhillips 453  962  1,483  1,342  (1,098)
Total assets 9,840  11,231  13,568  14,758  16,985 
Segment Profitability Ratio
Segment ROA1 4.60% 8.57% 10.93% 9.09% -6.46%

Based on: 10-K (reporting date: 2021-12-31), 10-K (reporting date: 2020-12-31), 10-K (reporting date: 2019-12-31), 10-K (reporting date: 2018-12-31), 10-K (reporting date: 2017-12-31).

1 2021 Calculation
Segment ROA = 100 × Net income (loss) attributable to ConocoPhillips ÷ Total assets
= 100 × 453 ÷ 9,840 = 4.60%

Segment profitability ratio Reportable segment The company
Segment ROA Asia Pacific Asia Pacific segment ROA deteriorated from 2019 to 2020 and from 2020 to 2021.

Segment ROA: Other International

ConocoPhillips; Other International; segment ROA calculation

Microsoft Excel LibreOffice Calc
Dec 31, 2021 Dec 31, 2020 Dec 31, 2019 Dec 31, 2018 Dec 31, 2017
Selected Financial Data (US$ in millions)
Net income (loss) attributable to ConocoPhillips (107) (64) 263  364  167 
Total assets 226  285  89  97 
Segment Profitability Ratio
Segment ROA1 -10,700.00% -28.32% 92.28% 408.99% 172.16%

Based on: 10-K (reporting date: 2021-12-31), 10-K (reporting date: 2020-12-31), 10-K (reporting date: 2019-12-31), 10-K (reporting date: 2018-12-31), 10-K (reporting date: 2017-12-31).

1 2021 Calculation
Segment ROA = 100 × Net income (loss) attributable to ConocoPhillips ÷ Total assets
= 100 × -107 ÷ 1 = -10,700.00%

Segment profitability ratio Reportable segment The company
Segment ROA Other International Other International segment ROA deteriorated from 2019 to 2020 and from 2020 to 2021.

Segment Asset Turnover

ConocoPhillips, asset turnover by reportable segment

Microsoft Excel LibreOffice Calc
Dec 31, 2021 Dec 31, 2020 Dec 31, 2019 Dec 31, 2018 Dec 31, 2017
Alaska 0.37 0.23 0.35 0.39 0.35
Lower 48 0.70 0.83 1.08 1.14 0.89
Canada 0.55 0.24 0.46 0.55 0.51
Europe, Middle East and North Africa 0.65 0.22 0.55 0.59 0.44
Asia Pacific 0.26 0.21 0.33 0.33 0.24
Other International 4.00 0.03 0.00 0.00 0.00

Based on: 10-K (reporting date: 2021-12-31), 10-K (reporting date: 2020-12-31), 10-K (reporting date: 2019-12-31), 10-K (reporting date: 2018-12-31), 10-K (reporting date: 2017-12-31).

Segment activity ratio Reportable segment The company
Segment asset turnover Alaska Alaska segment asset turnover ratio deteriorated from 2019 to 2020 but then improved from 2020 to 2021 exceeding 2019 level.
Lower 48 Lower 48 segment asset turnover ratio deteriorated from 2019 to 2020 and from 2020 to 2021.
Canada Canada segment asset turnover ratio deteriorated from 2019 to 2020 but then improved from 2020 to 2021 exceeding 2019 level.
Europe, Middle East and North Africa Europe, Middle East and North Africa segment asset turnover ratio deteriorated from 2019 to 2020 but then improved from 2020 to 2021 exceeding 2019 level.
Asia Pacific Asia Pacific segment asset turnover ratio deteriorated from 2019 to 2020 but then slightly improved from 2020 to 2021.
Other International Other International segment asset turnover ratio improved from 2019 to 2020 and from 2020 to 2021.

Segment Asset Turnover: Alaska

ConocoPhillips; Alaska; segment asset turnover calculation

Microsoft Excel LibreOffice Calc
Dec 31, 2021 Dec 31, 2020 Dec 31, 2019 Dec 31, 2018 Dec 31, 2017
Selected Financial Data (US$ in millions)
Sales and other operating revenues 5,480  3,408  5,483  5,740  4,224 
Total assets 14,812  14,623  15,453  14,648  12,108 
Segment Activity Ratio
Segment asset turnover1 0.37 0.23 0.35 0.39 0.35

Based on: 10-K (reporting date: 2021-12-31), 10-K (reporting date: 2020-12-31), 10-K (reporting date: 2019-12-31), 10-K (reporting date: 2018-12-31), 10-K (reporting date: 2017-12-31).

1 2021 Calculation
Segment asset turnover = Sales and other operating revenues ÷ Total assets
= 5,480 ÷ 14,812 = 0.37

Segment activity ratio Reportable segment The company
Segment asset turnover Alaska Alaska segment asset turnover ratio deteriorated from 2019 to 2020 but then improved from 2020 to 2021 exceeding 2019 level.

Segment Asset Turnover: Lower 48

ConocoPhillips; Lower 48; segment asset turnover calculation

Microsoft Excel LibreOffice Calc
Dec 31, 2021 Dec 31, 2020 Dec 31, 2019 Dec 31, 2018 Dec 31, 2017
Selected Financial Data (US$ in millions)
Sales and other operating revenues 29,306  9,872  15,514  17,029  12,968 
Total assets 41,699  11,932  14,425  14,888  14,632 
Segment Activity Ratio
Segment asset turnover1 0.70 0.83 1.08 1.14 0.89

Based on: 10-K (reporting date: 2021-12-31), 10-K (reporting date: 2020-12-31), 10-K (reporting date: 2019-12-31), 10-K (reporting date: 2018-12-31), 10-K (reporting date: 2017-12-31).

1 2021 Calculation
Segment asset turnover = Sales and other operating revenues ÷ Total assets
= 29,306 ÷ 41,699 = 0.70

Segment activity ratio Reportable segment The company
Segment asset turnover Lower 48 Lower 48 segment asset turnover ratio deteriorated from 2019 to 2020 and from 2020 to 2021.

Segment Asset Turnover: Canada

ConocoPhillips; Canada; segment asset turnover calculation

Microsoft Excel LibreOffice Calc
Dec 31, 2021 Dec 31, 2020 Dec 31, 2019 Dec 31, 2018 Dec 31, 2017
Selected Financial Data (US$ in millions)
Sales and other operating revenues 4,077  1,666  2,910  3,184  3,178 
Total assets 7,439  6,863  6,350  5,748  6,214 
Segment Activity Ratio
Segment asset turnover1 0.55 0.24 0.46 0.55 0.51

Based on: 10-K (reporting date: 2021-12-31), 10-K (reporting date: 2020-12-31), 10-K (reporting date: 2019-12-31), 10-K (reporting date: 2018-12-31), 10-K (reporting date: 2017-12-31).

1 2021 Calculation
Segment asset turnover = Sales and other operating revenues ÷ Total assets
= 4,077 ÷ 7,439 = 0.55

Segment activity ratio Reportable segment The company
Segment asset turnover Canada Canada segment asset turnover ratio deteriorated from 2019 to 2020 but then improved from 2020 to 2021 exceeding 2019 level.

Segment Asset Turnover: Europe, Middle East and North Africa

ConocoPhillips; Europe, Middle East and North Africa; segment asset turnover calculation

Microsoft Excel LibreOffice Calc
Dec 31, 2021 Dec 31, 2020 Dec 31, 2019 Dec 31, 2018 Dec 31, 2017
Selected Financial Data (US$ in millions)
Sales and other operating revenues 5,902  1,919  5,101  6,635  5,181 
Total assets 9,125  8,756  9,269  11,276  11,870 
Segment Activity Ratio
Segment asset turnover1 0.65 0.22 0.55 0.59 0.44

Based on: 10-K (reporting date: 2021-12-31), 10-K (reporting date: 2020-12-31), 10-K (reporting date: 2019-12-31), 10-K (reporting date: 2018-12-31), 10-K (reporting date: 2017-12-31).

1 2021 Calculation
Segment asset turnover = Sales and other operating revenues ÷ Total assets
= 5,902 ÷ 9,125 = 0.65

Segment activity ratio Reportable segment The company
Segment asset turnover Europe, Middle East and North Africa Europe, Middle East and North Africa segment asset turnover ratio deteriorated from 2019 to 2020 but then improved from 2020 to 2021 exceeding 2019 level.

Segment Asset Turnover: Asia Pacific

ConocoPhillips; Asia Pacific; segment asset turnover calculation

Microsoft Excel LibreOffice Calc
Dec 31, 2021 Dec 31, 2020 Dec 31, 2019 Dec 31, 2018 Dec 31, 2017
Selected Financial Data (US$ in millions)
Sales and other operating revenues 2,579  2,363  4,525  4,861  4,014 
Total assets 9,840  11,231  13,568  14,758  16,985 
Segment Activity Ratio
Segment asset turnover1 0.26 0.21 0.33 0.33 0.24

Based on: 10-K (reporting date: 2021-12-31), 10-K (reporting date: 2020-12-31), 10-K (reporting date: 2019-12-31), 10-K (reporting date: 2018-12-31), 10-K (reporting date: 2017-12-31).

1 2021 Calculation
Segment asset turnover = Sales and other operating revenues ÷ Total assets
= 2,579 ÷ 9,840 = 0.26

Segment activity ratio Reportable segment The company
Segment asset turnover Asia Pacific Asia Pacific segment asset turnover ratio deteriorated from 2019 to 2020 but then slightly improved from 2020 to 2021.

Segment Asset Turnover: Other International

ConocoPhillips; Other International; segment asset turnover calculation

Microsoft Excel LibreOffice Calc
Dec 31, 2021 Dec 31, 2020 Dec 31, 2019 Dec 31, 2018 Dec 31, 2017
Selected Financial Data (US$ in millions)
Sales and other operating revenues —  —  — 
Total assets 226  285  89  97 
Segment Activity Ratio
Segment asset turnover1 4.00 0.03 0.00 0.00 0.00

Based on: 10-K (reporting date: 2021-12-31), 10-K (reporting date: 2020-12-31), 10-K (reporting date: 2019-12-31), 10-K (reporting date: 2018-12-31), 10-K (reporting date: 2017-12-31).

1 2021 Calculation
Segment asset turnover = Sales and other operating revenues ÷ Total assets
= 4 ÷ 1 = 4.00

Segment activity ratio Reportable segment The company
Segment asset turnover Other International Other International segment asset turnover ratio improved from 2019 to 2020 and from 2020 to 2021.

Segment Capital Expenditures to Depreciation

ConocoPhillips, capital expenditures to depreciation by reportable segment

Microsoft Excel LibreOffice Calc
Dec 31, 2021 Dec 31, 2020 Dec 31, 2019 Dec 31, 2018 Dec 31, 2017
Alaska 0.98 1.04 1.88 1.71 0.79
Lower 48 0.77 0.56 1.05 1.34 0.32
Canada 0.52 1.90 1.59 1.47 0.44
Europe, Middle East and North Africa 0.62 0.77 0.80 0.84 0.66
Asia Pacific 0.26 0.47 0.45 0.52 0.13
Other International

Based on: 10-K (reporting date: 2021-12-31), 10-K (reporting date: 2020-12-31), 10-K (reporting date: 2019-12-31), 10-K (reporting date: 2018-12-31), 10-K (reporting date: 2017-12-31).

Segment financial ratio Reportable segment The company
Segment capital expenditures to depreciation Alaska Alaska segment capital expenditures to depreciation ratio deteriorated from 2019 to 2020 and from 2020 to 2021.
Lower 48 Lower 48 segment capital expenditures to depreciation ratio deteriorated from 2019 to 2020 but then slightly improved from 2020 to 2021.
Canada Canada segment capital expenditures to depreciation ratio improved from 2019 to 2020 but then deteriorated significantly from 2020 to 2021.
Europe, Middle East and North Africa Europe, Middle East and North Africa segment capital expenditures to depreciation ratio deteriorated from 2019 to 2020 and from 2020 to 2021.
Asia Pacific Asia Pacific segment capital expenditures to depreciation ratio improved from 2019 to 2020 but then deteriorated significantly from 2020 to 2021.
Other International

Segment Capital Expenditures to Depreciation: Alaska

ConocoPhillips; Alaska; segment capital expenditures to depreciation calculation

Microsoft Excel LibreOffice Calc
Dec 31, 2021 Dec 31, 2020 Dec 31, 2019 Dec 31, 2018 Dec 31, 2017
Selected Financial Data (US$ in millions)
Capital expenditures and investments 982  1,038  1,513  1,298  815 
Depreciation, depletion, amortization and impairments 1,002  996  805  760  1,026 
Segment Financial Ratio
Segment capital expenditures to depreciation1 0.98 1.04 1.88 1.71 0.79

Based on: 10-K (reporting date: 2021-12-31), 10-K (reporting date: 2020-12-31), 10-K (reporting date: 2019-12-31), 10-K (reporting date: 2018-12-31), 10-K (reporting date: 2017-12-31).

1 2021 Calculation
Segment capital expenditures to depreciation = Capital expenditures and investments ÷ Depreciation, depletion, amortization and impairments
= 982 ÷ 1,002 = 0.98

Segment financial ratio Reportable segment The company
Segment capital expenditures to depreciation Alaska Alaska segment capital expenditures to depreciation ratio deteriorated from 2019 to 2020 and from 2020 to 2021.

Segment Capital Expenditures to Depreciation: Lower 48

ConocoPhillips; Lower 48; segment capital expenditures to depreciation calculation

Microsoft Excel LibreOffice Calc
Dec 31, 2021 Dec 31, 2020 Dec 31, 2019 Dec 31, 2018 Dec 31, 2017
Selected Financial Data (US$ in millions)
Capital expenditures and investments 3,129  1,881  3,394  3,184  2,136 
Depreciation, depletion, amortization and impairments 4,067  3,358  3,224  2,370  6,693 
Segment Financial Ratio
Segment capital expenditures to depreciation1 0.77 0.56 1.05 1.34 0.32

Based on: 10-K (reporting date: 2021-12-31), 10-K (reporting date: 2020-12-31), 10-K (reporting date: 2019-12-31), 10-K (reporting date: 2018-12-31), 10-K (reporting date: 2017-12-31).

1 2021 Calculation
Segment capital expenditures to depreciation = Capital expenditures and investments ÷ Depreciation, depletion, amortization and impairments
= 3,129 ÷ 4,067 = 0.77

Segment financial ratio Reportable segment The company
Segment capital expenditures to depreciation Lower 48 Lower 48 segment capital expenditures to depreciation ratio deteriorated from 2019 to 2020 but then slightly improved from 2020 to 2021.

Segment Capital Expenditures to Depreciation: Canada

ConocoPhillips; Canada; segment capital expenditures to depreciation calculation

Microsoft Excel LibreOffice Calc
Dec 31, 2021 Dec 31, 2020 Dec 31, 2019 Dec 31, 2018 Dec 31, 2017
Selected Financial Data (US$ in millions)
Capital expenditures and investments 203  651  368  477  202 
Depreciation, depletion, amortization and impairments 392  342  232  324  461 
Segment Financial Ratio
Segment capital expenditures to depreciation1 0.52 1.90 1.59 1.47 0.44

Based on: 10-K (reporting date: 2021-12-31), 10-K (reporting date: 2020-12-31), 10-K (reporting date: 2019-12-31), 10-K (reporting date: 2018-12-31), 10-K (reporting date: 2017-12-31).

1 2021 Calculation
Segment capital expenditures to depreciation = Capital expenditures and investments ÷ Depreciation, depletion, amortization and impairments
= 203 ÷ 392 = 0.52

Segment financial ratio Reportable segment The company
Segment capital expenditures to depreciation Canada Canada segment capital expenditures to depreciation ratio improved from 2019 to 2020 but then deteriorated significantly from 2020 to 2021.

Segment Capital Expenditures to Depreciation: Europe, Middle East and North Africa

ConocoPhillips; Europe, Middle East and North Africa; segment capital expenditures to depreciation calculation

Microsoft Excel LibreOffice Calc
Dec 31, 2021 Dec 31, 2020 Dec 31, 2019 Dec 31, 2018 Dec 31, 2017
Selected Financial Data (US$ in millions)
Capital expenditures and investments 534  600  708  877  872 
Depreciation, depletion, amortization and impairments 862  775  887  1,041  1,313 
Segment Financial Ratio
Segment capital expenditures to depreciation1 0.62 0.77 0.80 0.84 0.66

Based on: 10-K (reporting date: 2021-12-31), 10-K (reporting date: 2020-12-31), 10-K (reporting date: 2019-12-31), 10-K (reporting date: 2018-12-31), 10-K (reporting date: 2017-12-31).

1 2021 Calculation
Segment capital expenditures to depreciation = Capital expenditures and investments ÷ Depreciation, depletion, amortization and impairments
= 534 ÷ 862 = 0.62

Segment financial ratio Reportable segment The company
Segment capital expenditures to depreciation Europe, Middle East and North Africa Europe, Middle East and North Africa segment capital expenditures to depreciation ratio deteriorated from 2019 to 2020 and from 2020 to 2021.

Segment Capital Expenditures to Depreciation: Asia Pacific

ConocoPhillips; Asia Pacific; segment capital expenditures to depreciation calculation

Microsoft Excel LibreOffice Calc
Dec 31, 2021 Dec 31, 2020 Dec 31, 2019 Dec 31, 2018 Dec 31, 2017
Selected Financial Data (US$ in millions)
Capital expenditures and investments 390  384  584  718  482 
Depreciation, depletion, amortization and impairments 1,483  809  1,285  1,382  3,819 
Segment Financial Ratio
Segment capital expenditures to depreciation1 0.26 0.47 0.45 0.52 0.13

Based on: 10-K (reporting date: 2021-12-31), 10-K (reporting date: 2020-12-31), 10-K (reporting date: 2019-12-31), 10-K (reporting date: 2018-12-31), 10-K (reporting date: 2017-12-31).

1 2021 Calculation
Segment capital expenditures to depreciation = Capital expenditures and investments ÷ Depreciation, depletion, amortization and impairments
= 390 ÷ 1,483 = 0.26

Segment financial ratio Reportable segment The company
Segment capital expenditures to depreciation Asia Pacific Asia Pacific segment capital expenditures to depreciation ratio improved from 2019 to 2020 but then deteriorated significantly from 2020 to 2021.

Segment Capital Expenditures to Depreciation: Other International

ConocoPhillips; Other International; segment capital expenditures to depreciation calculation

Microsoft Excel LibreOffice Calc
Dec 31, 2021 Dec 31, 2020 Dec 31, 2019 Dec 31, 2018 Dec 31, 2017
Selected Financial Data (US$ in millions)
Capital expenditures and investments 33  121  21 
Depreciation, depletion, amortization and impairments —  —  —  —  — 
Segment Financial Ratio
Segment capital expenditures to depreciation1

Based on: 10-K (reporting date: 2021-12-31), 10-K (reporting date: 2020-12-31), 10-K (reporting date: 2019-12-31), 10-K (reporting date: 2018-12-31), 10-K (reporting date: 2017-12-31).

1 2021 Calculation
Segment capital expenditures to depreciation = Capital expenditures and investments ÷ Depreciation, depletion, amortization and impairments
= 33 ÷ 0 =

Segment financial ratio Reportable segment The company
Segment capital expenditures to depreciation Other International

Sales and other operating revenues

ConocoPhillips, sales and other operating revenues by reportable segment

US$ in millions

Microsoft Excel LibreOffice Calc
Dec 31, 2021 Dec 31, 2020 Dec 31, 2019 Dec 31, 2018 Dec 31, 2017
Alaska 5,480  3,408  5,483  5,740  4,224 
Lower 48 29,306  9,872  15,514  17,029  12,968 
Canada 4,077  1,666  2,910  3,184  3,178 
Europe, Middle East and North Africa 5,902  1,919  5,101  6,635  5,181 
Asia Pacific 2,579  2,363  4,525  4,861  4,014 
Other International —  —  — 
Intersegment eliminations (1,595) (469) (1,187) (1,200) (563)
Corporate and Other 75  18  221  168  104 
Consolidated 45,828  18,784  32,567  36,417  29,106 

Based on: 10-K (reporting date: 2021-12-31), 10-K (reporting date: 2020-12-31), 10-K (reporting date: 2019-12-31), 10-K (reporting date: 2018-12-31), 10-K (reporting date: 2017-12-31).


Depreciation, depletion, amortization and impairments

ConocoPhillips, depreciation, depletion, amortization and impairments by reportable segment

US$ in millions

Microsoft Excel LibreOffice Calc
Dec 31, 2021 Dec 31, 2020 Dec 31, 2019 Dec 31, 2018 Dec 31, 2017
Alaska 1,002  996  805  760  1,026 
Lower 48 4,067  3,358  3,224  2,370  6,693 
Canada 392  342  232  324  461 
Europe, Middle East and North Africa 862  775  887  1,041  1,313 
Asia Pacific 1,483  809  1,285  1,382  3,819 
Other International —  —  —  —  — 
Corporate and Other 76  54  62  106  134 
Consolidated 7,882  6,334  6,495  5,983  13,446 

Based on: 10-K (reporting date: 2021-12-31), 10-K (reporting date: 2020-12-31), 10-K (reporting date: 2019-12-31), 10-K (reporting date: 2018-12-31), 10-K (reporting date: 2017-12-31).


Net income (loss) attributable to ConocoPhillips

ConocoPhillips, net income (loss) attributable to conocophillips by reportable segment

US$ in millions

Microsoft Excel LibreOffice Calc
Dec 31, 2021 Dec 31, 2020 Dec 31, 2019 Dec 31, 2018 Dec 31, 2017
Alaska 1,386  (719) 1,520  1,814  1,466 
Lower 48 4,932  (1,122) 436  1,747  (2,371)
Canada 458  (326) 279  63  2,564 
Europe, Middle East and North Africa 1,167  448  3,170  2,594  553 
Asia Pacific 453  962  1,483  1,342  (1,098)
Other International (107) (64) 263  364  167 
Corporate and Other (210) (1,880) 38  (1,667) (2,136)
Consolidated 8,079  (2,701) 7,189  6,257  (855)

Based on: 10-K (reporting date: 2021-12-31), 10-K (reporting date: 2020-12-31), 10-K (reporting date: 2019-12-31), 10-K (reporting date: 2018-12-31), 10-K (reporting date: 2017-12-31).


Total assets

ConocoPhillips, total assets by reportable segment

US$ in millions

Microsoft Excel LibreOffice Calc
Dec 31, 2021 Dec 31, 2020 Dec 31, 2019 Dec 31, 2018 Dec 31, 2017
Alaska 14,812  14,623  15,453  14,648  12,108 
Lower 48 41,699  11,932  14,425  14,888  14,632 
Canada 7,439  6,863  6,350  5,748  6,214 
Europe, Middle East and North Africa 9,125  8,756  9,269  11,276  11,870 
Asia Pacific 9,840  11,231  13,568  14,758  16,985 
Other International 226  285  89  97 
Corporate and Other 7,745  8,987  11,164  8,573  11,456 
Consolidated 90,661  62,618  70,514  69,980  73,362 

Based on: 10-K (reporting date: 2021-12-31), 10-K (reporting date: 2020-12-31), 10-K (reporting date: 2019-12-31), 10-K (reporting date: 2018-12-31), 10-K (reporting date: 2017-12-31).


Capital expenditures and investments

ConocoPhillips, capital expenditures and investments by reportable segment

US$ in millions

Microsoft Excel LibreOffice Calc
Dec 31, 2021 Dec 31, 2020 Dec 31, 2019 Dec 31, 2018 Dec 31, 2017
Alaska 982  1,038  1,513  1,298  815 
Lower 48 3,129  1,881  3,394  3,184  2,136 
Canada 203  651  368  477  202 
Europe, Middle East and North Africa 534  600  708  877  872 
Asia Pacific 390  384  584  718  482 
Other International 33  121  21 
Corporate and Other 53  40  61  190  63 
Consolidated 5,324  4,715  6,636  6,750  4,591 

Based on: 10-K (reporting date: 2021-12-31), 10-K (reporting date: 2020-12-31), 10-K (reporting date: 2019-12-31), 10-K (reporting date: 2018-12-31), 10-K (reporting date: 2017-12-31).