Stock Analysis on Net

Exxon Mobil Corp. (NYSE:XOM)

Analysis of Short-term (Operating) Activity Ratios
Quarterly Data

Microsoft Excel

Short-term Activity Ratios (Summary)

Exxon Mobil Corp., short-term (operating) 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
Turnover Ratios
Inventory turnover 13.32 14.16 15.02 16.69 16.32 16.05 14.93 13.84 14.73 12.30 11.14 9.86 9.47 10.95 10.88 15.09 13.79
Working capital turnover 10.70 11.56 12.16 12.91 13.95 15.33 26.98 59.06 110.19
Average No. Days
Average inventory processing period 27 26 24 22 22 23 24 26 25 30 33 37 39 33 34 24 26

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).

Short-term activity ratio Description The company
Inventory turnover An activity ratio calculated as cost of goods sold divided by inventory. Exxon Mobil Corp. inventory turnover ratio deteriorated from Q2 2023 to Q3 2023 and from Q3 2023 to Q4 2023.
Working capital turnover An activity ratio calculated as revenue divided by working capital. Exxon Mobil Corp. working capital turnover ratio deteriorated from Q2 2023 to Q3 2023 and from Q3 2023 to Q4 2023.

Short-term activity ratio Description The company
Average inventory processing period An activity ratio equal to the number of days in the period divided by inventory turnover over the period. Exxon Mobil Corp. number of days of inventory outstanding deteriorated from Q2 2023 to Q3 2023 and from Q3 2023 to Q4 2023.

Inventory Turnover

Exxon Mobil Corp., inventory 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 revenue 81,688 88,570 80,795 83,644 93,164 106,512 111,265 87,734 81,305 71,892 65,943 57,552 45,738 45,425 32,277 55,134 63,024 63,422 67,491 61,646
Inventories 25,120 24,450 24,249 23,642 24,435 24,096 23,585 22,177 18,780 19,607 19,275 18,357 18,850 17,885 19,657 16,501 18,528 17,590 18,835 18,332
Short-term Activity Ratio
Inventory turnover1 13.32 14.16 15.02 16.69 16.32 16.05 14.93 13.84 14.73 12.30 11.14 9.86 9.47 10.95 10.88 15.09 13.79
Benchmarks
Inventory Turnover, Competitors2
Chevron Corp. 22.86 21.48 23.28 25.16 28.58 25.22 26.71 27.10 24.68 21.96 18.60 17.05 16.64 18.34 20.86 20.59 23.92
ConocoPhillips 40.16 45.23 53.99 60.05 64.39 61.22 52.97 45.80 37.94 34.71 25.71 20.45 18.75 20.31 24.82 40.74 31.74
Marathon Petroleum Corp. 13.80 12.77 13.99 14.21 17.18 15.28 12.76 13.08 13.66 10.32 9.25 7.91 8.22 10.24 10.69 14.05 10.76
Occidental Petroleum Corp. 13.97 14.84 15.60 15.37 17.79 18.75 21.57 20.63 14.06 12.52 10.63 7.59 9.38 12.01 14.56 16.02 14.09
Valero Energy Corp. 17.39 18.02 20.28 20.76 23.64 23.61 20.24 17.64 17.69 15.05 13.32 10.66 10.87 13.94 15.61 28.30 14.76

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
Inventory turnover = (Sales and other operating revenueQ4 2023 + Sales and other operating revenueQ3 2023 + Sales and other operating revenueQ2 2023 + Sales and other operating revenueQ1 2023) ÷ Inventories
= (81,688 + 88,570 + 80,795 + 83,644) ÷ 25,120 = 13.32

2 Click competitor name to see calculations.

Short-term activity ratio Description The company
Inventory turnover An activity ratio calculated as cost of goods sold divided by inventory. Exxon Mobil Corp. inventory turnover ratio deteriorated from Q2 2023 to Q3 2023 and from Q3 2023 to Q4 2023.

Working Capital Turnover

Exxon Mobil Corp., working capital 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)
Current assets 96,609 101,142 91,760 97,224 97,631 99,289 93,163 77,255 59,154 55,555 52,842 48,195 44,893 48,693 53,016 50,249 50,052 50,008 51,743 51,576
Less: Current liabilities 65,316 71,186 61,815 66,666 69,045 74,057 80,110 72,059 56,643 61,856 62,238 60,150 56,363 56,468 57,270 64,773 63,989 64,195 70,287 66,632
Working capital 31,293 29,956 29,945 30,558 28,586 25,232 13,053 5,196 2,511 (6,301) (9,396) (11,955) (11,470) (7,775) (4,254) (14,524) (13,937) (14,187) (18,544) (15,056)
 
Sales and other operating revenue 81,688 88,570 80,795 83,644 93,164 106,512 111,265 87,734 81,305 71,892 65,943 57,552 45,738 45,425 32,277 55,134 63,024 63,422 67,491 61,646
Short-term Activity Ratio
Working capital turnover1 10.70 11.56 12.16 12.91 13.95 15.33 26.98 59.06 110.19
Benchmarks
Working Capital Turnover, Competitors2
Chevron Corp. 22.20 23.91 16.54 15.89 14.61 15.53 17.08 13.09 22.40 19.37 24.04 32.46 24.25 20.28 39.55 414.01 77.75
ConocoPhillips 12.98 8.76 16.88 16.56 13.30 11.63 9.84 9.02 11.37 3.72 3.24 3.02 2.80 3.27 3.51 4.18 3.30
Marathon Petroleum Corp. 12.38 10.45 10.63 11.29 11.66 12.38 11.41 12.01 9.52 5.95 4.60 4.92 5.53 6.93 30.75 55.50 30.81
Occidental Petroleum Corp. 50.58 32.45 44.63 49.75 21.36 13.76 28.72 5.99 11.43 29.88 102.74 10.72 5.46
Valero Energy Corp. 15.37 16.82 17.97 21.87 26.44 31.24 28.60 37.33 26.42 21.15 15.70 12.04 9.89 10.44 16.04 38.84 18.65

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
Working capital turnover = (Sales and other operating revenueQ4 2023 + Sales and other operating revenueQ3 2023 + Sales and other operating revenueQ2 2023 + Sales and other operating revenueQ1 2023) ÷ Working capital
= (81,688 + 88,570 + 80,795 + 83,644) ÷ 31,293 = 10.70

2 Click competitor name to see calculations.

Short-term activity ratio Description The company
Working capital turnover An activity ratio calculated as revenue divided by working capital. Exxon Mobil Corp. working capital turnover ratio deteriorated from Q2 2023 to Q3 2023 and from Q3 2023 to Q4 2023.

Average Inventory Processing Period

Exxon Mobil Corp., average inventory processing period 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
Inventory turnover 13.32 14.16 15.02 16.69 16.32 16.05 14.93 13.84 14.73 12.30 11.14 9.86 9.47 10.95 10.88 15.09 13.79
Short-term Activity Ratio (no. days)
Average inventory processing period1 27 26 24 22 22 23 24 26 25 30 33 37 39 33 34 24 26
Benchmarks (no. days)
Average Inventory Processing Period, Competitors2
Chevron Corp. 16 17 16 15 13 14 14 13 15 17 20 21 22 20 17 18 15
ConocoPhillips 9 8 7 6 6 6 7 8 10 11 14 18 19 18 15 9 11
Marathon Petroleum Corp. 26 29 26 26 21 24 29 28 27 35 39 46 44 36 34 26 34
Occidental Petroleum Corp. 26 25 23 24 21 19 17 18 26 29 34 48 39 30 25 23 26
Valero Energy Corp. 21 20 18 18 15 15 18 21 21 24 27 34 34 26 23 13 25

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
Average inventory processing period = 365 ÷ Inventory turnover
= 365 ÷ 13.32 = 27

2 Click competitor name to see calculations.

Short-term activity ratio Description The company
Average inventory processing period An activity ratio equal to the number of days in the period divided by inventory turnover over the period. Exxon Mobil Corp. number of days of inventory outstanding deteriorated from Q2 2023 to Q3 2023 and from Q3 2023 to Q4 2023.