Stock Analysis on Net

ConocoPhillips (NYSE:COP)

Analysis of Geographic Areas

Microsoft Excel

Area Asset Turnover

ConocoPhillips, asset turnover by geographic area

Microsoft Excel
Dec 31, 2023 Dec 31, 2022 Dec 31, 2021 Dec 31, 2020 Dec 31, 2019
United States 0.84 1.19 0.69 0.55 0.80
Australia 0.00 0.00 0.00 0.09 0.23
Canada 0.31 0.59 0.38 0.20 0.31
China 0.58 0.74 0.49 0.31 0.53
Indonesia 31.39 1.48 1.45
Libya 2.46 2.22 1.67 0.23 1.65
Malaysia 1.02 1.19 0.78 0.41 0.66
Norway 0.54 0.78 0.55 0.27 0.45
United Kingdom 989.00 6,273.00 2,236.00 336.00 824.50
Other foreign countries 0.00 0.00 0.01 0.01 0.01

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

Area activity ratio Geographic area The company
Area asset turnover United States United States area asset turnover ratio improved from 2021 to 2022 but then slightly deteriorated from 2022 to 2023 not reaching 2021 level.
Australia
Canada Canada area asset turnover ratio improved from 2021 to 2022 but then deteriorated significantly from 2022 to 2023.
China China area asset turnover ratio improved from 2021 to 2022 but then slightly deteriorated from 2022 to 2023 not reaching 2021 level.
Indonesia
Libya Libya area asset turnover ratio improved from 2021 to 2022 and from 2022 to 2023.
Malaysia Malaysia area asset turnover ratio improved from 2021 to 2022 but then slightly deteriorated from 2022 to 2023.
Norway Norway area asset turnover ratio improved from 2021 to 2022 but then deteriorated significantly from 2022 to 2023.
United Kingdom United Kingdom area asset turnover ratio improved from 2021 to 2022 but then deteriorated significantly from 2022 to 2023.
Other foreign countries Other foreign countries area asset turnover ratio deteriorated from 2021 to 2022 and from 2022 to 2023.

Area Asset Turnover: United States

ConocoPhillips; United States; area asset turnover calculation

Microsoft Excel
Dec 31, 2023 Dec 31, 2022 Dec 31, 2021 Dec 31, 2020 Dec 31, 2019
Selected Financial Data (US$ in millions)
Sales and other operating revenues 45,101 60,899 34,847 13,230 21,159
Long-lived assets 53,955 51,200 50,580 24,034 26,566
Area Activity Ratio
Area asset turnover1 0.84 1.19 0.69 0.55 0.80

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

1 2023 Calculation
Area asset turnover = Sales and other operating revenues ÷ Long-lived assets
= 45,101 ÷ 53,955 = 0.84

Area activity ratio Geographic area The company
Area asset turnover United States United States area asset turnover ratio improved from 2021 to 2022 but then slightly deteriorated from 2022 to 2023 not reaching 2021 level.

Area Asset Turnover: Australia

ConocoPhillips; Australia; area asset turnover calculation

Microsoft Excel
Dec 31, 2023 Dec 31, 2022 Dec 31, 2021 Dec 31, 2020 Dec 31, 2019
Selected Financial Data (US$ in millions)
Sales and other operating revenues 605 1,647
Long-lived assets 5,426 6,158 5,579 6,676 7,228
Area Activity Ratio
Area asset turnover1 0.00 0.00 0.00 0.09 0.23

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

1 2023 Calculation
Area asset turnover = Sales and other operating revenues ÷ Long-lived assets
= 0 ÷ 5,426 = 0.00

Area activity ratio Geographic area The company
Area asset turnover Australia

Area Asset Turnover: Canada

ConocoPhillips; Canada; area asset turnover calculation

Microsoft Excel
Dec 31, 2023 Dec 31, 2022 Dec 31, 2021 Dec 31, 2020 Dec 31, 2019
Selected Financial Data (US$ in millions)
Sales and other operating revenues 3,006 3,714 2,494 1,261 1,769
Long-lived assets 9,666 6,269 6,608 6,385 5,769
Area Activity Ratio
Area asset turnover1 0.31 0.59 0.38 0.20 0.31

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

1 2023 Calculation
Area asset turnover = Sales and other operating revenues ÷ Long-lived assets
= 3,006 ÷ 9,666 = 0.31

Area activity ratio Geographic area The company
Area asset turnover Canada Canada area asset turnover ratio improved from 2021 to 2022 but then deteriorated significantly from 2022 to 2023.

Area Asset Turnover: China

ConocoPhillips; China; area asset turnover calculation

Microsoft Excel
Dec 31, 2023 Dec 31, 2022 Dec 31, 2021 Dec 31, 2020 Dec 31, 2019
Selected Financial Data (US$ in millions)
Sales and other operating revenues 952 1,135 724 460 772
Long-lived assets 1,635 1,538 1,476 1,491 1,447
Area Activity Ratio
Area asset turnover1 0.58 0.74 0.49 0.31 0.53

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

1 2023 Calculation
Area asset turnover = Sales and other operating revenues ÷ Long-lived assets
= 952 ÷ 1,635 = 0.58

Area activity ratio Geographic area The company
Area asset turnover China China area asset turnover ratio improved from 2021 to 2022 but then slightly deteriorated from 2022 to 2023 not reaching 2021 level.

Area Asset Turnover: Indonesia

ConocoPhillips; Indonesia; area asset turnover calculation

Microsoft Excel
Dec 31, 2023 Dec 31, 2022 Dec 31, 2021 Dec 31, 2020 Dec 31, 2019
Selected Financial Data (US$ in millions)
Sales and other operating revenues 159 879 689 875
Long-lived assets 28 464 605
Area Activity Ratio
Area asset turnover1 31.39 1.48 1.45

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

1 2023 Calculation
Area asset turnover = Sales and other operating revenues ÷ Long-lived assets
= 0 ÷ 0 =

Area activity ratio Geographic area The company
Area asset turnover Indonesia

Area Asset Turnover: Libya

ConocoPhillips; Libya; area asset turnover calculation

Microsoft Excel
Dec 31, 2023 Dec 31, 2022 Dec 31, 2021 Dec 31, 2020 Dec 31, 2019
Selected Financial Data (US$ in millions)
Sales and other operating revenues 1,730 1,582 1,102 155 1,103
Long-lived assets 703 714 659 670 668
Area Activity Ratio
Area asset turnover1 2.46 2.22 1.67 0.23 1.65

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

1 2023 Calculation
Area asset turnover = Sales and other operating revenues ÷ Long-lived assets
= 1,730 ÷ 703 = 2.46

Area activity ratio Geographic area The company
Area asset turnover Libya Libya area asset turnover ratio improved from 2021 to 2022 and from 2022 to 2023.

Area Asset Turnover: Malaysia

ConocoPhillips; Malaysia; area asset turnover calculation

Microsoft Excel
Dec 31, 2023 Dec 31, 2022 Dec 31, 2021 Dec 31, 2020 Dec 31, 2019
Selected Financial Data (US$ in millions)
Sales and other operating revenues 961 1,312 975 610 1,230
Long-lived assets 939 1,107 1,252 1,501 1,871
Area Activity Ratio
Area asset turnover1 1.02 1.19 0.78 0.41 0.66

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

1 2023 Calculation
Area asset turnover = Sales and other operating revenues ÷ Long-lived assets
= 961 ÷ 939 = 1.02

Area activity ratio Geographic area The company
Area asset turnover Malaysia Malaysia area asset turnover ratio improved from 2021 to 2022 but then slightly deteriorated from 2022 to 2023.

Area Asset Turnover: Norway

ConocoPhillips; Norway; area asset turnover calculation

Microsoft Excel
Dec 31, 2023 Dec 31, 2022 Dec 31, 2021 Dec 31, 2020 Dec 31, 2019
Selected Financial Data (US$ in millions)
Sales and other operating revenues 2,408 3,415 2,563 1,426 2,349
Long-lived assets 4,489 4,369 4,681 5,294 5,258
Area Activity Ratio
Area asset turnover1 0.54 0.78 0.55 0.27 0.45

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

1 2023 Calculation
Area asset turnover = Sales and other operating revenues ÷ Long-lived assets
= 2,408 ÷ 4,489 = 0.54

Area activity ratio Geographic area The company
Area asset turnover Norway Norway area asset turnover ratio improved from 2021 to 2022 but then deteriorated significantly from 2022 to 2023.

Area Asset Turnover: United Kingdom

ConocoPhillips; United Kingdom; area asset turnover calculation

Microsoft Excel
Dec 31, 2023 Dec 31, 2022 Dec 31, 2021 Dec 31, 2020 Dec 31, 2019
Selected Financial Data (US$ in millions)
Sales and other operating revenues 1,978 6,273 2,236 336 1,649
Long-lived assets 2 1 1 1 2
Area Activity Ratio
Area asset turnover1 989.00 6,273.00 2,236.00 336.00 824.50

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

1 2023 Calculation
Area asset turnover = Sales and other operating revenues ÷ Long-lived assets
= 1,978 ÷ 2 = 989.00

Area activity ratio Geographic area The company
Area asset turnover United Kingdom United Kingdom area asset turnover ratio improved from 2021 to 2022 but then deteriorated significantly from 2022 to 2023.

Area Asset Turnover: Other foreign countries

ConocoPhillips; Other foreign countries; area asset turnover calculation

Microsoft Excel
Dec 31, 2023 Dec 31, 2022 Dec 31, 2021 Dec 31, 2020 Dec 31, 2019
Selected Financial Data (US$ in millions)
Sales and other operating revenues 5 5 8 12 14
Long-lived assets 1,134 1,003 748 1,087 1,308
Area Activity Ratio
Area asset turnover1 0.00 0.00 0.01 0.01 0.01

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

1 2023 Calculation
Area asset turnover = Sales and other operating revenues ÷ Long-lived assets
= 5 ÷ 1,134 = 0.00

Area activity ratio Geographic area The company
Area asset turnover Other foreign countries Other foreign countries area asset turnover ratio deteriorated from 2021 to 2022 and from 2022 to 2023.

Sales and other operating revenues

ConocoPhillips, sales and other operating revenues by geographic area

US$ in millions

Microsoft Excel
Dec 31, 2023 Dec 31, 2022 Dec 31, 2021 Dec 31, 2020 Dec 31, 2019
United States 45,101 60,899 34,847 13,230 21,159
Australia 605 1,647
Canada 3,006 3,714 2,494 1,261 1,769
China 952 1,135 724 460 772
Indonesia 159 879 689 875
Libya 1,730 1,582 1,102 155 1,103
Malaysia 961 1,312 975 610 1,230
Norway 2,408 3,415 2,563 1,426 2,349
United Kingdom 1,978 6,273 2,236 336 1,649
Other foreign countries 5 5 8 12 14
Worldwide consolidated 56,141 78,494 45,828 18,784 32,567

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


Long-lived assets

ConocoPhillips, long-lived assets by geographic area

US$ in millions

Microsoft Excel
Dec 31, 2023 Dec 31, 2022 Dec 31, 2021 Dec 31, 2020 Dec 31, 2019
United States 53,955 51,200 50,580 24,034 26,566
Australia 5,426 6,158 5,579 6,676 7,228
Canada 9,666 6,269 6,608 6,385 5,769
China 1,635 1,538 1,476 1,491 1,447
Indonesia 28 464 605
Libya 703 714 659 670 668
Malaysia 939 1,107 1,252 1,501 1,871
Norway 4,489 4,369 4,681 5,294 5,258
United Kingdom 2 1 1 1 2
Other foreign countries 1,134 1,003 748 1,087 1,308
Worldwide consolidated 77,949 72,359 71,612 47,603 50,722

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