Analysis of Short-term (Operating) Activity Ratios
Quarterly Data
Activity ratios measure how efficiently a company performs day-to-day tasks, such us the collection of receivables and management of inventory.
Short-term Activity Ratios (Summary)
ONEOK Inc., short-term (operating) activity ratios (quarterly data)
Based on: 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), 10-K (reporting date: 2018-12-31), 10-Q (reporting date: 2018-09-30), 10-Q (reporting date: 2018-06-30), 10-Q (reporting date: 2018-03-31).
| Short-term activity ratio | Description | The company |
|---|---|---|
| Inventory turnover | An activity ratio calculated as cost of goods sold divided by inventory. | ONEOK Inc. inventory turnover ratio deteriorated from Q4 2022 to Q1 2023 but then improved from Q1 2023 to Q2 2023 exceeding Q4 2022 level. |
| Receivables turnover | An activity ratio equal to revenue divided by receivables. | ONEOK Inc. receivables turnover ratio improved from Q4 2022 to Q1 2023 and from Q1 2023 to Q2 2023. |
| Payables turnover | An activity ratio calculated as cost of goods sold divided by payables. | ONEOK Inc. payables turnover ratio increased from Q4 2022 to Q1 2023 and from Q1 2023 to Q2 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. | |
| Average receivable collection period | An activity ratio equal to the number of days in the period divided by receivables turnover. | ONEOK Inc. number of days of receivables outstanding improved from Q4 2022 to Q1 2023 and from Q1 2023 to Q2 2023. |
| Operating cycle | Equal to average inventory processing period plus average receivables collection period. | ONEOK Inc. operating cycle improved from Q4 2022 to Q1 2023 and from Q1 2023 to Q2 2023. |
| 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. | ONEOK Inc. number of days of payables outstanding decreased from Q4 2022 to Q1 2023 and from Q1 2023 to Q2 2023. |
| Cash conversion cycle | A financial metric that measures the length of time required for a company to convert cash invested in its operations to cash received as a result of its operations; equal to average inventory processing period plus average receivables collection period minus average payables payment period. |
Inventory Turnover
ONEOK Inc., inventory turnover calculation (quarterly data)
| 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 | Dec 31, 2018 | Sep 30, 2018 | Jun 30, 2018 | Mar 31, 2018 | ||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Selected Financial Data (US$ in millions) | |||||||||||||||||||||||||||||
| Cost of sales and fuel | 2,482) | 3,347) | 3,893) | 4,773) | 4,878) | 4,366) | 4,319) | 3,449) | 2,367) | 2,122) | 1,627) | 1,266) | 940) | 1,277) | 1,791) | 1,415) | 1,626) | 1,956) | 2,318) | 2,561) | 2,176) | 2,368) | |||||||
| Inventory | 460) | 556) | 581) | 693) | 774) | 732) | 581) | 776) | 600) | 513) | 371) | 460) | 515) | 386) | 507) | 476) | 362) | 407) | 438) | 555) | 400) | 284) | |||||||
| Short-term Activity Ratio | |||||||||||||||||||||||||||||
| Inventory turnover1 | 31.51 | 30.38 | 30.84 | 26.45 | 21.98 | 19.80 | 21.10 | 12.33 | 12.31 | 11.60 | 13.77 | 11.48 | 10.53 | 15.82 | 13.40 | 15.35 | 23.34 | 22.14 | 21.52 | — | — | — | |||||||
| Benchmarks | |||||||||||||||||||||||||||||
| Inventory Turnover, Competitors2 | |||||||||||||||||||||||||||||
| Chevron Corp. | 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 | 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. | 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.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. | 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. | 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-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), 10-K (reporting date: 2018-12-31), 10-Q (reporting date: 2018-09-30), 10-Q (reporting date: 2018-06-30), 10-Q (reporting date: 2018-03-31).
1 Q2 2023 Calculation
Inventory turnover
= (Cost of sales and fuelQ2 2023
+ Cost of sales and fuelQ1 2023
+ Cost of sales and fuelQ4 2022
+ Cost of sales and fuelQ3 2022)
÷ Inventory
= (2,482 + 3,347 + 3,893 + 4,773)
÷ 460 = 31.51
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. | ONEOK Inc. inventory turnover ratio deteriorated from Q4 2022 to Q1 2023 but then improved from Q1 2023 to Q2 2023 exceeding Q4 2022 level. |
Receivables Turnover
ONEOK Inc., receivables turnover calculation (quarterly data)
| 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 | Dec 31, 2018 | Sep 30, 2018 | Jun 30, 2018 | Mar 31, 2018 | ||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Selected Financial Data (US$ in millions) | |||||||||||||||||||||||||||||
| Revenues | 3,732) | 4,521) | 5,032) | 5,914) | 5,997) | 5,445) | 5,420) | 4,536) | 3,389) | 3,195) | 2,571) | 2,174) | 1,661) | 2,137) | 2,664) | 2,263) | 2,458) | 2,780) | 3,137) | 3,394) | 2,961) | 3,102) | |||||||
| Accounts receivable, net | 1,023) | 1,153) | 1,532) | 1,729) | 1,779) | 1,682) | 1,442) | 1,498) | 1,092) | 910) | 830) | 718) | 609) | 498) | 835) | 719) | 669) | 813) | 819) | 1,085) | 935) | 844) | |||||||
| Short-term Activity Ratio | |||||||||||||||||||||||||||||
| Receivables turnover1 | 18.77 | 18.62 | 14.61 | 13.17 | 12.03 | 11.17 | 11.47 | 9.14 | 10.37 | 10.55 | 10.29 | 12.03 | 14.33 | 19.14 | 12.17 | 14.80 | 17.58 | 15.10 | 15.38 | — | — | — | |||||||
| Benchmarks | |||||||||||||||||||||||||||||
| Receivables Turnover, Competitors2 | |||||||||||||||||||||||||||||
| Chevron Corp. | 11.10 | 12.21 | 11.52 | 10.11 | 7.67 | 7.60 | 8.45 | 8.12 | 7.39 | 6.79 | 8.24 | 10.72 | 13.42 | 13.32 | 10.50 | — | — | — | — | — | — | — | |||||||
| ConocoPhillips | 14.77 | 14.31 | 11.09 | 10.23 | 8.09 | 6.89 | 7.00 | 6.78 | 6.65 | 5.17 | 7.13 | 10.59 | 17.42 | 13.98 | 9.97 | — | — | — | — | — | — | — | |||||||
| Marathon Petroleum Corp. | 15.26 | 17.18 | 13.17 | 12.85 | 9.22 | 8.64 | 10.87 | 10.79 | 8.98 | 9.41 | 12.11 | 16.88 | 22.14 | 21.12 | 15.75 | — | — | — | — | — | — | — | |||||||
| Occidental Petroleum Corp. | 11.07 | 10.85 | 8.56 | 8.98 | 5.31 | 5.34 | 6.17 | 6.39 | 5.94 | 5.41 | 8.42 | 9.57 | 9.12 | 9.36 | 3.20 | — | — | — | — | — | — | — | |||||||
Based on: 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), 10-K (reporting date: 2018-12-31), 10-Q (reporting date: 2018-09-30), 10-Q (reporting date: 2018-06-30), 10-Q (reporting date: 2018-03-31).
1 Q2 2023 Calculation
Receivables turnover
= (RevenuesQ2 2023
+ RevenuesQ1 2023
+ RevenuesQ4 2022
+ RevenuesQ3 2022)
÷ Accounts receivable, net
= (3,732 + 4,521 + 5,032 + 5,914)
÷ 1,023 = 18.77
2 Click competitor name to see calculations.
| Short-term activity ratio | Description | The company |
|---|---|---|
| Receivables turnover | An activity ratio equal to revenue divided by receivables. | ONEOK Inc. receivables turnover ratio improved from Q4 2022 to Q1 2023 and from Q1 2023 to Q2 2023. |
Payables Turnover
ONEOK Inc., payables turnover calculation (quarterly data)
| 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 | Dec 31, 2018 | Sep 30, 2018 | Jun 30, 2018 | Mar 31, 2018 | ||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Selected Financial Data (US$ in millions) | |||||||||||||||||||||||||||||
| Cost of sales and fuel | 2,482) | 3,347) | 3,893) | 4,773) | 4,878) | 4,366) | 4,319) | 3,449) | 2,367) | 2,122) | 1,627) | 1,266) | 940) | 1,277) | 1,791) | 1,415) | 1,626) | 1,956) | 2,318) | 2,561) | 2,176) | 2,368) | |||||||
| Accounts payable | 880) | 1,074) | 1,359) | 1,659) | 1,924) | 1,730) | 1,332) | 1,443) | 1,053) | 930) | 719) | 624) | 755) | 742) | 1,210) | 1,130) | 907) | 1,027) | 1,118) | 1,340) | 1,027) | 773) | |||||||
| Short-term Activity Ratio | |||||||||||||||||||||||||||||
| Payables turnover1 | 16.47 | 15.73 | 13.17 | 11.05 | 8.84 | 8.38 | 9.20 | 6.63 | 7.01 | 6.40 | 7.10 | 8.45 | 7.18 | 8.23 | 5.61 | 6.47 | 9.32 | 8.77 | 8.43 | — | — | — | |||||||
| Benchmarks | |||||||||||||||||||||||||||||
| Payables Turnover, Competitors2 | |||||||||||||||||||||||||||||
| Chevron Corp. | 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 | 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. | 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. | 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 | — | — | — | — | — | — | — | |||||||
| Valero Energy Corp. | 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 | — | — | — | — | — | — | — | |||||||
Based on: 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), 10-K (reporting date: 2018-12-31), 10-Q (reporting date: 2018-09-30), 10-Q (reporting date: 2018-06-30), 10-Q (reporting date: 2018-03-31).
1 Q2 2023 Calculation
Payables turnover
= (Cost of sales and fuelQ2 2023
+ Cost of sales and fuelQ1 2023
+ Cost of sales and fuelQ4 2022
+ Cost of sales and fuelQ3 2022)
÷ Accounts payable
= (2,482 + 3,347 + 3,893 + 4,773)
÷ 880 = 16.47
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. | ONEOK Inc. payables turnover ratio increased from Q4 2022 to Q1 2023 and from Q1 2023 to Q2 2023. |
Working Capital Turnover
ONEOK Inc., working capital turnover calculation (quarterly data)
| 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 | Dec 31, 2018 | Sep 30, 2018 | Jun 30, 2018 | Mar 31, 2018 | ||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Selected Financial Data (US$ in millions) | |||||||||||||||||||||||||||||
| Current assets | 1,863) | 2,569) | 2,548) | 2,765) | 3,026) | 2,641) | 2,374) | 2,667) | 2,236) | 1,998) | 1,870) | 1,721) | 2,180) | 1,488) | 1,470) | 1,968) | 1,401) | 1,343) | 1,399) | 1,808) | 1,434) | 1,291) | |||||||
| Less: Current liabilities | 1,517) | 2,182) | 3,052) | 4,139) | 3,655) | 3,483) | 3,185) | 2,803) | 2,395) | 2,048) | 1,345) | 1,094) | 1,273) | 1,091) | 2,020) | 1,567) | 1,737) | 1,690) | 2,108) | 2,450) | 2,572) | 2,051) | |||||||
| Working capital | 346) | 387) | (504) | (1,373) | (628) | (841) | (810) | (136) | (159) | (50) | 525) | 627) | 907) | 397) | (550) | 400) | (336) | (347) | (710) | (642) | (1,138) | (760) | |||||||
| Revenues | 3,732) | 4,521) | 5,032) | 5,914) | 5,997) | 5,445) | 5,420) | 4,536) | 3,389) | 3,195) | 2,571) | 2,174) | 1,661) | 2,137) | 2,664) | 2,263) | 2,458) | 2,780) | 3,137) | 3,394) | 2,961) | 3,102) | |||||||
| Short-term Activity Ratio | |||||||||||||||||||||||||||||
| Working capital turnover1 | 55.49 | 55.46 | — | — | — | — | — | — | — | — | 16.26 | 13.77 | 9.62 | 23.99 | — | 26.56 | — | — | — | — | — | — | |||||||
| Benchmarks | |||||||||||||||||||||||||||||
| Working Capital Turnover, Competitors2 | |||||||||||||||||||||||||||||
| Chevron Corp. | 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 | 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. | 12.16 | 12.91 | 13.95 | 15.33 | 26.98 | 59.06 | 110.19 | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | |||||||
| Marathon Petroleum Corp. | 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. | 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-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), 10-K (reporting date: 2018-12-31), 10-Q (reporting date: 2018-09-30), 10-Q (reporting date: 2018-06-30), 10-Q (reporting date: 2018-03-31).
1 Q2 2023 Calculation
Working capital turnover
= (RevenuesQ2 2023
+ RevenuesQ1 2023
+ RevenuesQ4 2022
+ RevenuesQ3 2022)
÷ Working capital
= (3,732 + 4,521 + 5,032 + 5,914)
÷ 346 = 55.49
2 Click competitor name to see calculations.
Average Inventory Processing Period
ONEOK Inc., average inventory processing period calculation (quarterly data)
| 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 | Dec 31, 2018 | Sep 30, 2018 | Jun 30, 2018 | Mar 31, 2018 | ||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Selected Financial Data | |||||||||||||||||||||||||||||
| Inventory turnover | 31.51 | 30.38 | 30.84 | 26.45 | 21.98 | 19.80 | 21.10 | 12.33 | 12.31 | 11.60 | 13.77 | 11.48 | 10.53 | 15.82 | 13.40 | 15.35 | 23.34 | 22.14 | 21.52 | — | — | — | |||||||
| Short-term Activity Ratio (no. days) | |||||||||||||||||||||||||||||
| Average inventory processing period1 | 12 | 12 | 12 | 14 | 17 | 18 | 17 | 30 | 30 | 31 | 26 | 32 | 35 | 23 | 27 | 24 | 16 | 16 | 17 | — | — | — | |||||||
| Benchmarks (no. days) | |||||||||||||||||||||||||||||
| Average Inventory Processing Period, Competitors2 | |||||||||||||||||||||||||||||
| Chevron Corp. | 16 | 15 | 13 | 14 | 14 | 13 | 15 | 17 | 20 | 21 | 22 | 20 | 17 | 18 | 15 | — | — | — | — | — | — | — | |||||||
| ConocoPhillips | 7 | 6 | 6 | 6 | 7 | 8 | 10 | 11 | 14 | 18 | 19 | 18 | 15 | 9 | 11 | — | — | — | — | — | — | — | |||||||
| Exxon Mobil Corp. | 24 | 22 | 22 | 23 | 24 | 26 | 25 | 30 | 33 | 37 | 39 | 33 | 34 | 24 | 26 | — | — | — | — | — | — | — | |||||||
| Marathon Petroleum Corp. | 26 | 26 | 21 | 24 | 29 | 28 | 27 | 35 | 39 | 46 | 44 | 36 | 34 | 26 | 34 | — | — | — | — | — | — | — | |||||||
| Occidental Petroleum Corp. | 23 | 24 | 21 | 19 | 17 | 18 | 26 | 29 | 34 | 48 | 39 | 30 | 25 | 23 | 26 | — | — | — | — | — | — | — | |||||||
| Valero Energy Corp. | 18 | 18 | 15 | 15 | 18 | 21 | 21 | 24 | 27 | 34 | 34 | 26 | 23 | 13 | 25 | — | — | — | — | — | — | — | |||||||
Based on: 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), 10-K (reporting date: 2018-12-31), 10-Q (reporting date: 2018-09-30), 10-Q (reporting date: 2018-06-30), 10-Q (reporting date: 2018-03-31).
1 Q2 2023 Calculation
Average inventory processing period = 365 ÷ Inventory turnover
= 365 ÷ 31.51 = 12
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. |
Average Receivable Collection Period
ONEOK Inc., average receivable collection period calculation (quarterly data)
| 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 | Dec 31, 2018 | Sep 30, 2018 | Jun 30, 2018 | Mar 31, 2018 | ||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Selected Financial Data | |||||||||||||||||||||||||||||
| Receivables turnover | 18.77 | 18.62 | 14.61 | 13.17 | 12.03 | 11.17 | 11.47 | 9.14 | 10.37 | 10.55 | 10.29 | 12.03 | 14.33 | 19.14 | 12.17 | 14.80 | 17.58 | 15.10 | 15.38 | — | — | — | |||||||
| Short-term Activity Ratio (no. days) | |||||||||||||||||||||||||||||
| Average receivable collection period1 | 19 | 20 | 25 | 28 | 30 | 33 | 32 | 40 | 35 | 35 | 35 | 30 | 25 | 19 | 30 | 25 | 21 | 24 | 24 | — | — | — | |||||||
| Benchmarks (no. days) | |||||||||||||||||||||||||||||
| Average Receivable Collection Period, Competitors2 | |||||||||||||||||||||||||||||
| Chevron Corp. | 33 | 30 | 32 | 36 | 48 | 48 | 43 | 45 | 49 | 54 | 44 | 34 | 27 | 27 | 35 | — | — | — | — | — | — | — | |||||||
| ConocoPhillips | 25 | 26 | 33 | 36 | 45 | 53 | 52 | 54 | 55 | 71 | 51 | 34 | 21 | 26 | 37 | — | — | — | — | — | — | — | |||||||
| Marathon Petroleum Corp. | 24 | 21 | 28 | 28 | 40 | 42 | 34 | 34 | 41 | 39 | 30 | 22 | 16 | 17 | 23 | — | — | — | — | — | — | — | |||||||
| Occidental Petroleum Corp. | 33 | 34 | 43 | 41 | 69 | 68 | 59 | 57 | 61 | 67 | 43 | 38 | 40 | 39 | 114 | — | — | — | — | — | — | — | |||||||
Based on: 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), 10-K (reporting date: 2018-12-31), 10-Q (reporting date: 2018-09-30), 10-Q (reporting date: 2018-06-30), 10-Q (reporting date: 2018-03-31).
1 Q2 2023 Calculation
Average receivable collection period = 365 ÷ Receivables turnover
= 365 ÷ 18.77 = 19
2 Click competitor name to see calculations.
| Short-term activity ratio | Description | The company |
|---|---|---|
| Average receivable collection period | An activity ratio equal to the number of days in the period divided by receivables turnover. | ONEOK Inc. number of days of receivables outstanding improved from Q4 2022 to Q1 2023 and from Q1 2023 to Q2 2023. |
Operating Cycle
ONEOK Inc., operating cycle calculation (quarterly data)
No. days
| 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 | Dec 31, 2018 | Sep 30, 2018 | Jun 30, 2018 | Mar 31, 2018 | ||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Selected Financial Data | |||||||||||||||||||||||||||||
| Average inventory processing period | 12 | 12 | 12 | 14 | 17 | 18 | 17 | 30 | 30 | 31 | 26 | 32 | 35 | 23 | 27 | 24 | 16 | 16 | 17 | — | — | — | |||||||
| Average receivable collection period | 19 | 20 | 25 | 28 | 30 | 33 | 32 | 40 | 35 | 35 | 35 | 30 | 25 | 19 | 30 | 25 | 21 | 24 | 24 | — | — | — | |||||||
| Short-term Activity Ratio | |||||||||||||||||||||||||||||
| Operating cycle1 | 31 | 32 | 37 | 42 | 47 | 51 | 49 | 70 | 65 | 66 | 61 | 62 | 60 | 42 | 57 | 49 | 37 | 40 | 41 | — | — | — | |||||||
| Benchmarks | |||||||||||||||||||||||||||||
| Operating Cycle, Competitors2 | |||||||||||||||||||||||||||||
| Chevron Corp. | 49 | 45 | 45 | 50 | 62 | 61 | 58 | 62 | 69 | 75 | 66 | 54 | 44 | 45 | 50 | — | — | — | — | — | — | — | |||||||
| ConocoPhillips | 32 | 32 | 39 | 42 | 52 | 61 | 62 | 65 | 69 | 89 | 70 | 52 | 36 | 35 | 48 | — | — | — | — | — | — | — | |||||||
| Marathon Petroleum Corp. | 50 | 47 | 49 | 52 | 69 | 70 | 61 | 69 | 80 | 85 | 74 | 58 | 50 | 43 | 57 | — | — | — | — | — | — | — | |||||||
| Occidental Petroleum Corp. | 56 | 58 | 64 | 60 | 86 | 86 | 85 | 86 | 95 | 115 | 82 | 68 | 65 | 62 | 140 | — | — | — | — | — | — | — | |||||||
Based on: 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), 10-K (reporting date: 2018-12-31), 10-Q (reporting date: 2018-09-30), 10-Q (reporting date: 2018-06-30), 10-Q (reporting date: 2018-03-31).
1 Q2 2023 Calculation
Operating cycle = Average inventory processing period + Average receivable collection period
= 12 + 19 = 31
2 Click competitor name to see calculations.
| Short-term activity ratio | Description | The company |
|---|---|---|
| Operating cycle | Equal to average inventory processing period plus average receivables collection period. | ONEOK Inc. operating cycle improved from Q4 2022 to Q1 2023 and from Q1 2023 to Q2 2023. |
Average Payables Payment Period
ONEOK Inc., average payables payment period calculation (quarterly data)
| 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 | Dec 31, 2018 | Sep 30, 2018 | Jun 30, 2018 | Mar 31, 2018 | ||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Selected Financial Data | |||||||||||||||||||||||||||||
| Payables turnover | 16.47 | 15.73 | 13.17 | 11.05 | 8.84 | 8.38 | 9.20 | 6.63 | 7.01 | 6.40 | 7.10 | 8.45 | 7.18 | 8.23 | 5.61 | 6.47 | 9.32 | 8.77 | 8.43 | — | — | — | |||||||
| Short-term Activity Ratio (no. days) | |||||||||||||||||||||||||||||
| Average payables payment period1 | 22 | 23 | 28 | 33 | 41 | 44 | 40 | 55 | 52 | 57 | 51 | 43 | 51 | 44 | 65 | 56 | 39 | 42 | 43 | — | — | — | |||||||
| Benchmarks (no. days) | |||||||||||||||||||||||||||||
| Average Payables Payment Period, Competitors2 | |||||||||||||||||||||||||||||
| Chevron Corp. | 32 | 28 | 29 | 35 | 44 | 42 | 39 | 42 | 46 | 49 | 42 | 33 | 26 | 30 | 37 | — | — | — | — | — | — | — | |||||||
| ConocoPhillips | 25 | 25 | 28 | 30 | 33 | 33 | 40 | 41 | 45 | 61 | 52 | 39 | 31 | 36 | 36 | — | — | — | — | — | — | — | |||||||
| Marathon Petroleum Corp. | 36 | 33 | 37 | 41 | 58 | 58 | 45 | 47 | 54 | 55 | 43 | 32 | 26 | 28 | 38 | — | — | — | — | — | — | — | |||||||
| Occidental Petroleum Corp. | 41 | 36 | 40 | 37 | 56 | 59 | 55 | 61 | 66 | 76 | 61 | 49 | 51 | 61 | 126 | — | — | — | — | — | — | — | |||||||
| Valero Energy Corp. | 28 | 25 | 29 | 30 | 42 | 44 | 41 | 38 | 46 | 53 | 34 | 26 | 20 | 21 | 36 | — | — | — | — | — | — | — | |||||||
Based on: 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), 10-K (reporting date: 2018-12-31), 10-Q (reporting date: 2018-09-30), 10-Q (reporting date: 2018-06-30), 10-Q (reporting date: 2018-03-31).
1 Q2 2023 Calculation
Average payables payment period = 365 ÷ Payables turnover
= 365 ÷ 16.47 = 22
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. | ONEOK Inc. number of days of payables outstanding decreased from Q4 2022 to Q1 2023 and from Q1 2023 to Q2 2023. |
Cash Conversion Cycle
ONEOK Inc., cash conversion cycle calculation (quarterly data)
No. days
| 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 | Dec 31, 2018 | Sep 30, 2018 | Jun 30, 2018 | Mar 31, 2018 | ||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Selected Financial Data | |||||||||||||||||||||||||||||
| Average inventory processing period | 12 | 12 | 12 | 14 | 17 | 18 | 17 | 30 | 30 | 31 | 26 | 32 | 35 | 23 | 27 | 24 | 16 | 16 | 17 | — | — | — | |||||||
| Average receivable collection period | 19 | 20 | 25 | 28 | 30 | 33 | 32 | 40 | 35 | 35 | 35 | 30 | 25 | 19 | 30 | 25 | 21 | 24 | 24 | — | — | — | |||||||
| Average payables payment period | 22 | 23 | 28 | 33 | 41 | 44 | 40 | 55 | 52 | 57 | 51 | 43 | 51 | 44 | 65 | 56 | 39 | 42 | 43 | — | — | — | |||||||
| Short-term Activity Ratio | |||||||||||||||||||||||||||||
| Cash conversion cycle1 | 9 | 9 | 9 | 9 | 6 | 7 | 9 | 15 | 13 | 9 | 10 | 19 | 9 | -2 | -8 | -7 | -2 | -2 | -2 | — | — | — | |||||||
| Benchmarks | |||||||||||||||||||||||||||||
| Cash Conversion Cycle, Competitors2 | |||||||||||||||||||||||||||||
| Chevron Corp. | 17 | 17 | 16 | 15 | 18 | 19 | 19 | 20 | 23 | 26 | 24 | 21 | 18 | 15 | 13 | — | — | — | — | — | — | — | |||||||
| ConocoPhillips | 7 | 7 | 11 | 12 | 19 | 28 | 22 | 24 | 24 | 28 | 18 | 13 | 5 | -1 | 12 | — | — | — | — | — | — | — | |||||||
| Marathon Petroleum Corp. | 14 | 14 | 12 | 11 | 11 | 12 | 16 | 22 | 26 | 30 | 31 | 26 | 24 | 15 | 19 | — | — | — | — | — | — | — | |||||||
| Occidental Petroleum Corp. | 15 | 22 | 24 | 23 | 30 | 27 | 30 | 25 | 29 | 39 | 21 | 19 | 14 | 1 | 14 | — | — | — | — | — | — | — | |||||||
Based on: 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), 10-K (reporting date: 2018-12-31), 10-Q (reporting date: 2018-09-30), 10-Q (reporting date: 2018-06-30), 10-Q (reporting date: 2018-03-31).
1 Q2 2023 Calculation
Cash conversion cycle = Average inventory processing period + Average receivable collection period – Average payables payment period
= 12 + 19 – 22 = 9
2 Click competitor name to see calculations.
| Short-term activity ratio | Description | The company |
|---|---|---|
| Cash conversion cycle | A financial metric that measures the length of time required for a company to convert cash invested in its operations to cash received as a result of its operations; equal to average inventory processing period plus average receivables collection period minus average payables payment period. |