Stock Analysis on Net

Valero Energy Corp. (NYSE:VLO)

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

Microsoft Excel

Short-term Activity Ratios (Summary)

Valero Energy Corp., short-term (operating) activity ratios (quarterly data)

Microsoft Excel
Mar 31, 2024 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 16.36 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
Payables turnover 10.39 10.49 10.15 13.04 14.75 12.54 12.04 8.69 8.31 8.87 9.54 8.00 6.88 10.79 14.26 18.19 17.61 10.15
Working capital turnover 14.71 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
Average No. Days
Average inventory processing period 22 21 20 18 18 15 15 18 21 21 24 27 34 34 26 23 13 25
Less: Average payables payment period 35 35 36 28 25 29 30 42 44 41 38 46 53 34 26 20 21 36

Based on: 10-Q (reporting date: 2024-03-31), 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. Valero Energy Corp. inventory turnover ratio deteriorated from Q3 2023 to Q4 2023 and from Q4 2023 to Q1 2024.
Payables turnover An activity ratio calculated as cost of goods sold divided by payables. Valero Energy Corp. payables turnover ratio increased from Q3 2023 to Q4 2023 but then slightly decreased from Q4 2023 to Q1 2024.
Working capital turnover An activity ratio calculated as revenue divided by working capital. Valero Energy Corp. working capital turnover ratio deteriorated from Q3 2023 to Q4 2023 and from Q4 2023 to Q1 2024.

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. Valero Energy Corp. number of days of inventory outstanding deteriorated from Q3 2023 to Q4 2023 and from Q4 2023 to Q1 2024.
Average payables payment period An estimate of the average number of days it takes a company to pay its suppliers; equal to the number of days in the period divided by payables turnover ratio for the period.

Inventory Turnover

Valero Energy Corp., inventory turnover calculation (quarterly data)

Microsoft Excel
Mar 31, 2024 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)
Cost of sales 29,776 33,540 34,634 31,528 32,132 37,071 40,431 45,162 36,923 33,993 28,602 27,039 21,214 16,834 16,207 8,424 24,187 25,876 26,130 27,810 23,730
Inventories 7,912 7,583 7,513 6,961 7,455 6,752 6,628 7,147 7,174 6,265 6,227 6,103 5,881 6,038 5,357 5,420 3,675 7,013 6,376 6,281 6,554
Short-term Activity Ratio
Inventory turnover1 16.36 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
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
Exxon Mobil Corp. 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
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

Based on: 10-Q (reporting date: 2024-03-31), 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 Q1 2024 Calculation
Inventory turnover = (Cost of salesQ1 2024 + Cost of salesQ4 2023 + Cost of salesQ3 2023 + Cost of salesQ2 2023) ÷ Inventories
= (29,776 + 33,540 + 34,634 + 31,528) ÷ 7,912 = 16.36

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. Valero Energy Corp. inventory turnover ratio deteriorated from Q3 2023 to Q4 2023 and from Q4 2023 to Q1 2024.

Payables Turnover

Valero Energy Corp., payables turnover calculation (quarterly data)

Microsoft Excel
Mar 31, 2024 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)
Cost of sales 29,776 33,540 34,634 31,528 32,132 37,071 40,431 45,162 36,923 33,993 28,602 27,039 21,214 16,834 16,207 8,424 24,187 25,876 26,130 27,810 23,730
Accounts payable 12,458 12,567 13,342 10,825 10,498 12,728 13,003 16,643 15,236 12,495 9,820 10,168 9,113 6,082 5,237 4,652 5,906 10,205 9,504 10,135 10,005
Short-term Activity Ratio
Payables turnover1 10.39 10.49 10.15 13.04 14.75 12.54 12.04 8.69 8.31 8.87 9.54 8.00 6.88 10.79 14.26 18.19 17.61 10.15
Benchmarks
Payables Turnover, Competitors2
Chevron Corp. 9.64 9.35 11.48 12.94 12.44 10.46 8.28 8.78 9.46 8.79 7.88 7.45 8.63 10.93 13.94 12.30 9.92
ConocoPhillips 11.04 11.72 14.52 14.88 12.84 12.02 11.18 11.03 9.16 8.83 8.15 5.94 7.04 9.47 11.83 10.20 10.25
Marathon Petroleum Corp. 9.34 8.18 10.22 11.20 9.91 9.01 6.27 6.27 8.03 7.79 6.75 6.68 8.42 11.31 14.15 12.91 9.48
Occidental Petroleum Corp. 7.75 7.50 8.87 10.11 9.09 9.78 6.49 6.22 6.66 5.98 5.51 4.83 5.96 7.43 7.09 5.98 2.91

Based on: 10-Q (reporting date: 2024-03-31), 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 Q1 2024 Calculation
Payables turnover = (Cost of salesQ1 2024 + Cost of salesQ4 2023 + Cost of salesQ3 2023 + Cost of salesQ2 2023) ÷ Accounts payable
= (29,776 + 33,540 + 34,634 + 31,528) ÷ 12,458 = 10.39

2 Click competitor name to see calculations.

Short-term activity ratio Description The company
Payables turnover An activity ratio calculated as cost of goods sold divided by payables. Valero Energy Corp. payables turnover ratio increased from Q3 2023 to Q4 2023 but then slightly decreased from Q4 2023 to Q1 2024.

Working Capital Turnover

Valero Energy Corp., working capital turnover calculation (quarterly data)

Microsoft Excel
Mar 31, 2024 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 25,674 26,221 26,577 23,695 23,335 24,133 22,696 27,409 23,313 21,165 18,790 19,372 17,591 15,844 15,422 12,762 11,465 18,969 17,033 17,811 18,480
Less: Current liabilities 16,149 16,802 17,592 14,948 15,365 17,461 17,237 21,969 19,785 16,851 14,313 14,214 12,307 9,283 8,122 7,300 8,732 13,160 12,130 12,548 12,913
Working capital 9,525 9,419 8,985 8,747 7,970 6,672 5,459 5,440 3,528 4,314 4,477 5,158 5,284 6,561 7,300 5,462 2,733 5,809 4,903 5,263 5,567
 
Revenues, includes excise taxes on sales by certain of foreign operations 31,759 35,414 38,404 34,509 36,439 41,746 44,454 51,641 38,542 35,903 29,520 27,748 20,806 16,604 15,809 10,397 22,102 27,879 27,249 28,933 24,263
Short-term Activity Ratio
Working capital turnover1 14.71 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
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
Exxon Mobil Corp. 10.70 11.56 12.16 12.91 13.95 15.33 26.98 59.06 110.19
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

Based on: 10-Q (reporting date: 2024-03-31), 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 Q1 2024 Calculation
Working capital turnover = (Revenues, includes excise taxes on sales by certain of foreign operationsQ1 2024 + Revenues, includes excise taxes on sales by certain of foreign operationsQ4 2023 + Revenues, includes excise taxes on sales by certain of foreign operationsQ3 2023 + Revenues, includes excise taxes on sales by certain of foreign operationsQ2 2023) ÷ Working capital
= (31,759 + 35,414 + 38,404 + 34,509) ÷ 9,525 = 14.71

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. Valero Energy Corp. working capital turnover ratio deteriorated from Q3 2023 to Q4 2023 and from Q4 2023 to Q1 2024.

Average Inventory Processing Period

Valero Energy Corp., average inventory processing period calculation (quarterly data)

Microsoft Excel
Mar 31, 2024 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 16.36 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
Short-term Activity Ratio (no. days)
Average inventory processing period1 22 21 20 18 18 15 15 18 21 21 24 27 34 34 26 23 13 25
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
Exxon Mobil Corp. 27 26 24 22 22 23 24 26 25 30 33 37 39 33 34 24 26
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

Based on: 10-Q (reporting date: 2024-03-31), 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 Q1 2024 Calculation
Average inventory processing period = 365 ÷ Inventory turnover
= 365 ÷ 16.36 = 22

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. Valero Energy Corp. number of days of inventory outstanding deteriorated from Q3 2023 to Q4 2023 and from Q4 2023 to Q1 2024.

Average Payables Payment Period

Valero Energy Corp., average payables payment period calculation (quarterly data)

Microsoft Excel
Mar 31, 2024 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
Payables turnover 10.39 10.49 10.15 13.04 14.75 12.54 12.04 8.69 8.31 8.87 9.54 8.00 6.88 10.79 14.26 18.19 17.61 10.15
Short-term Activity Ratio (no. days)
Average payables payment period1 35 35 36 28 25 29 30 42 44 41 38 46 53 34 26 20 21 36
Benchmarks (no. days)
Average Payables Payment Period, Competitors2
Chevron Corp. 38 39 32 28 29 35 44 42 39 42 46 49 42 33 26 30 37
ConocoPhillips 33 31 25 25 28 30 33 33 40 41 45 61 52 39 31 36 36
Marathon Petroleum Corp. 39 45 36 33 37 41 58 58 45 47 54 55 43 32 26 28 38
Occidental Petroleum Corp. 47 49 41 36 40 37 56 59 55 61 66 76 61 49 51 61 126

Based on: 10-Q (reporting date: 2024-03-31), 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 Q1 2024 Calculation
Average payables payment period = 365 ÷ Payables turnover
= 365 ÷ 10.39 = 35

2 Click competitor name to see calculations.

Short-term activity ratio Description The company
Average payables payment period An estimate of the average number of days it takes a company to pay its suppliers; equal to the number of days in the period divided by payables turnover ratio for the period.