Stock Analysis on Net

ONEOK Inc. (NYSE:OKE)

This company has been moved to the archive! The financial data has not been updated since August 8, 2023.

Analysis of Short-term (Operating) Activity Ratios

Microsoft Excel

Short-term Activity Ratios (Summary)

ONEOK Inc., short-term (operating) activity ratios

Microsoft Excel
Dec 31, 2022 Dec 31, 2021 Dec 31, 2020 Dec 31, 2019 Dec 31, 2018
Turnover Ratios
Inventory turnover 30.84 21.10 13.77 13.40 21.52
Receivables turnover 14.61 11.47 10.29 12.17 15.38
Payables turnover 13.17 9.20 7.10 5.61 8.44
Working capital turnover 16.26
Average No. Days
Average inventory processing period 12 17 26 27 17
Add: Average receivable collection period 25 32 35 30 24
Operating cycle 37 49 61 57 41
Less: Average payables payment period 28 40 51 65 43
Cash conversion cycle 9 9 10 -8 -2

Based on: 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), 10-K (reporting date: 2018-12-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 improved from 2020 to 2021 and from 2021 to 2022.
Receivables turnover An activity ratio equal to revenue divided by receivables. ONEOK Inc. receivables turnover ratio improved from 2020 to 2021 and from 2021 to 2022.
Payables turnover An activity ratio calculated as cost of goods sold divided by payables. ONEOK Inc. payables turnover ratio increased from 2020 to 2021 and from 2021 to 2022.

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. ONEOK Inc. number of days of inventory outstanding improved from 2020 to 2021 and from 2021 to 2022.
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 2020 to 2021 and from 2021 to 2022.
Operating cycle Equal to average inventory processing period plus average receivables collection period. ONEOK Inc. operating cycle improved from 2020 to 2021 and from 2021 to 2022.
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 2020 to 2021 and from 2021 to 2022.
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, comparison to benchmarks

Microsoft Excel
Dec 31, 2022 Dec 31, 2021 Dec 31, 2020 Dec 31, 2019 Dec 31, 2018
Selected Financial Data (US$ in thousands)
Cost of sales and fuel 17,909,866 12,256,655 5,110,146 6,788,040 9,422,708
Inventory 580,725 580,899 370,988 506,675 437,841
Short-term Activity Ratio
Inventory turnover1 30.84 21.10 13.77 13.40 21.52
Benchmarks
Inventory Turnover, Competitors2
Chevron Corp. 28.58 24.68 16.64 23.92
ConocoPhillips 64.39 37.94 18.75 31.74
Exxon Mobil Corp. 16.32 14.73 9.47 13.79
Marathon Petroleum Corp. 17.18 13.66 8.22 10.76
Occidental Petroleum Corp. 17.79 14.06 9.38 14.09
Valero Energy Corp. 23.64 17.69 10.87 14.76
Inventory Turnover, Sector
Oil, Gas & Consumable Fuels 20.58 17.07 10.64 15.01
Inventory Turnover, Industry
Energy 19.51 16.27 10.31 14.32

Based on: 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), 10-K (reporting date: 2018-12-31).

1 2022 Calculation
Inventory turnover = Cost of sales and fuel ÷ Inventory
= 17,909,866 ÷ 580,725 = 30.84

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 improved from 2020 to 2021 and from 2021 to 2022.

Receivables Turnover

ONEOK Inc., receivables turnover calculation, comparison to benchmarks

Microsoft Excel
Dec 31, 2022 Dec 31, 2021 Dec 31, 2020 Dec 31, 2019 Dec 31, 2018
Selected Financial Data (US$ in thousands)
Revenues 22,386,892 16,540,309 8,542,242 10,164,367 12,593,196
Accounts receivable, net 1,532,292 1,441,786 829,796 835,121 818,958
Short-term Activity Ratio
Receivables turnover1 14.61 11.47 10.29 12.17 15.38
Benchmarks
Receivables Turnover, Competitors2
Chevron Corp. 11.52 8.45 8.24 10.50
ConocoPhillips 11.09 7.00 7.13 9.97
Exxon Mobil Corp. 12.14 10.29 10.93 12.11
Marathon Petroleum Corp. 13.17 10.87 12.11 15.75
Occidental Petroleum Corp. 8.56 6.17 8.42 3.20
Valero Energy Corp. 16.39 11.43 13.50 13.44
Receivables Turnover, Sector
Oil, Gas & Consumable Fuels 12.41 9.58 10.30 11.35
Receivables Turnover, Industry
Energy 11.79 9.24 9.67 10.53

Based on: 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), 10-K (reporting date: 2018-12-31).

1 2022 Calculation
Receivables turnover = Revenues ÷ Accounts receivable, net
= 22,386,892 ÷ 1,532,292 = 14.61

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 2020 to 2021 and from 2021 to 2022.

Payables Turnover

ONEOK Inc., payables turnover calculation, comparison to benchmarks

Microsoft Excel
Dec 31, 2022 Dec 31, 2021 Dec 31, 2020 Dec 31, 2019 Dec 31, 2018
Selected Financial Data (US$ in thousands)
Cost of sales and fuel 17,909,866 12,256,655 5,110,146 6,788,040 9,422,708
Accounts payable 1,359,475 1,332,391 719,302 1,209,900 1,116,337
Short-term Activity Ratio
Payables turnover1 13.17 9.20 7.10 5.61 8.44
Benchmarks
Payables Turnover, Competitors2
Chevron Corp. 12.44 9.46 8.63 9.92
ConocoPhillips 12.84 9.16 7.04 10.25
Exxon Mobil Corp. 12.02 10.39 10.20 10.35
Marathon Petroleum Corp. 9.91 8.03 8.42 9.48
Occidental Petroleum Corp. 9.09 6.66 5.96 2.91
Valero Energy Corp. 12.54 8.87 10.79 10.15
Payables Turnover, Sector
Oil, Gas & Consumable Fuels 11.75 9.27 9.19 9.35
Payables Turnover, Industry
Energy 11.50 9.15 9.07 9.14

Based on: 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), 10-K (reporting date: 2018-12-31).

1 2022 Calculation
Payables turnover = Cost of sales and fuel ÷ Accounts payable
= 17,909,866 ÷ 1,359,475 = 13.17

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 2020 to 2021 and from 2021 to 2022.

Working Capital Turnover

ONEOK Inc., working capital turnover calculation, comparison to benchmarks

Microsoft Excel
Dec 31, 2022 Dec 31, 2021 Dec 31, 2020 Dec 31, 2019 Dec 31, 2018
Selected Financial Data (US$ in thousands)
Current assets 2,547,775 2,374,374 1,869,775 1,470,334 1,398,632
Less: Current liabilities 3,051,627 3,184,619 1,344,547 2,020,298 2,108,436
Working capital (503,852) (810,245) 525,228 (549,964) (709,804)
 
Revenues 22,386,892 16,540,309 8,542,242 10,164,367 12,593,196
Short-term Activity Ratio
Working capital turnover1 16.26
Benchmarks
Working Capital Turnover, Competitors2
Chevron Corp. 14.61 22.40 24.25 77.75
ConocoPhillips 13.30 11.37 2.80 3.30
Exxon Mobil Corp. 13.95 110.19
Marathon Petroleum Corp. 11.66 9.52 5.53 30.81
Occidental Petroleum Corp. 32.45 13.76 29.88 5.46
Valero Energy Corp. 26.44 26.42 9.89 18.65
Working Capital Turnover, Sector
Oil, Gas & Consumable Fuels 14.98 22.86 23.50 60.26
Working Capital Turnover, Industry
Energy 14.76 22.01 21.93 51.98

Based on: 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), 10-K (reporting date: 2018-12-31).

1 2022 Calculation
Working capital turnover = Revenues ÷ Working capital
= 22,386,892 ÷ -503,852 =

2 Click competitor name to see calculations.


Average Inventory Processing Period

ONEOK Inc., average inventory processing period calculation, comparison to benchmarks

Microsoft Excel
Dec 31, 2022 Dec 31, 2021 Dec 31, 2020 Dec 31, 2019 Dec 31, 2018
Selected Financial Data
Inventory turnover 30.84 21.10 13.77 13.40 21.52
Short-term Activity Ratio (no. days)
Average inventory processing period1 12 17 26 27 17
Benchmarks (no. days)
Average Inventory Processing Period, Competitors2
Chevron Corp. 13 15 22 15
ConocoPhillips 6 10 19 11
Exxon Mobil Corp. 22 25 39 26
Marathon Petroleum Corp. 21 27 44 34
Occidental Petroleum Corp. 21 26 39 26
Valero Energy Corp. 15 21 34 25
Average Inventory Processing Period, Sector
Oil, Gas & Consumable Fuels 18 21 34 24
Average Inventory Processing Period, Industry
Energy 19 22 35 25

Based on: 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), 10-K (reporting date: 2018-12-31).

1 2022 Calculation
Average inventory processing period = 365 ÷ Inventory turnover
= 365 ÷ 30.84 = 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. ONEOK Inc. number of days of inventory outstanding improved from 2020 to 2021 and from 2021 to 2022.

Average Receivable Collection Period

ONEOK Inc., average receivable collection period calculation, comparison to benchmarks

Microsoft Excel
Dec 31, 2022 Dec 31, 2021 Dec 31, 2020 Dec 31, 2019 Dec 31, 2018
Selected Financial Data
Receivables turnover 14.61 11.47 10.29 12.17 15.38
Short-term Activity Ratio (no. days)
Average receivable collection period1 25 32 35 30 24
Benchmarks (no. days)
Average Receivable Collection Period, Competitors2
Chevron Corp. 32 43 44 35
ConocoPhillips 33 52 51 37
Exxon Mobil Corp. 30 35 33 30
Marathon Petroleum Corp. 28 34 30 23
Occidental Petroleum Corp. 43 59 43 114
Valero Energy Corp. 22 32 27 27
Average Receivable Collection Period, Sector
Oil, Gas & Consumable Fuels 29 38 35 32
Average Receivable Collection Period, Industry
Energy 31 40 38 35

Based on: 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), 10-K (reporting date: 2018-12-31).

1 2022 Calculation
Average receivable collection period = 365 ÷ Receivables turnover
= 365 ÷ 14.61 = 25

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 2020 to 2021 and from 2021 to 2022.

Operating Cycle

ONEOK Inc., operating cycle calculation, comparison to benchmarks

No. days

Microsoft Excel
Dec 31, 2022 Dec 31, 2021 Dec 31, 2020 Dec 31, 2019 Dec 31, 2018
Selected Financial Data
Average inventory processing period 12 17 26 27 17
Average receivable collection period 25 32 35 30 24
Short-term Activity Ratio
Operating cycle1 37 49 61 57 41
Benchmarks
Operating Cycle, Competitors2
Chevron Corp. 45 58 66 50
ConocoPhillips 39 62 70 48
Exxon Mobil Corp. 52 60 72 56
Marathon Petroleum Corp. 49 61 74 57
Occidental Petroleum Corp. 64 85 82 140
Valero Energy Corp. 37 53 61 52
Operating Cycle, Sector
Oil, Gas & Consumable Fuels 47 59 69 56
Operating Cycle, Industry
Energy 50 62 73 60

Based on: 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), 10-K (reporting date: 2018-12-31).

1 2022 Calculation
Operating cycle = Average inventory processing period + Average receivable collection period
= 12 + 25 = 37

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 2020 to 2021 and from 2021 to 2022.

Average Payables Payment Period

ONEOK Inc., average payables payment period calculation, comparison to benchmarks

Microsoft Excel
Dec 31, 2022 Dec 31, 2021 Dec 31, 2020 Dec 31, 2019 Dec 31, 2018
Selected Financial Data
Payables turnover 13.17 9.20 7.10 5.61 8.44
Short-term Activity Ratio (no. days)
Average payables payment period1 28 40 51 65 43
Benchmarks (no. days)
Average Payables Payment Period, Competitors2
Chevron Corp. 29 39 42 37
ConocoPhillips 28 40 52 36
Exxon Mobil Corp. 30 35 36 35
Marathon Petroleum Corp. 37 45 43 38
Occidental Petroleum Corp. 40 55 61 126
Valero Energy Corp. 29 41 34 36
Average Payables Payment Period, Sector
Oil, Gas & Consumable Fuels 31 39 40 39
Average Payables Payment Period, Industry
Energy 32 40 40 40

Based on: 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), 10-K (reporting date: 2018-12-31).

1 2022 Calculation
Average payables payment period = 365 ÷ Payables turnover
= 365 ÷ 13.17 = 28

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 2020 to 2021 and from 2021 to 2022.

Cash Conversion Cycle

ONEOK Inc., cash conversion cycle calculation, comparison to benchmarks

No. days

Microsoft Excel
Dec 31, 2022 Dec 31, 2021 Dec 31, 2020 Dec 31, 2019 Dec 31, 2018
Selected Financial Data
Average inventory processing period 12 17 26 27 17
Average receivable collection period 25 32 35 30 24
Average payables payment period 28 40 51 65 43
Short-term Activity Ratio
Cash conversion cycle1 9 9 10 -8 -2
Benchmarks
Cash Conversion Cycle, Competitors2
Chevron Corp. 16 19 24 13
ConocoPhillips 11 22 18 12
Exxon Mobil Corp. 22 25 36 21
Marathon Petroleum Corp. 12 16 31 19
Occidental Petroleum Corp. 24 30 21 14
Valero Energy Corp. 8 12 27 16
Cash Conversion Cycle, Sector
Oil, Gas & Consumable Fuels 16 20 29 17
Cash Conversion Cycle, Industry
Energy 18 22 33 20

Based on: 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), 10-K (reporting date: 2018-12-31).

1 2022 Calculation
Cash conversion cycle = Average inventory processing period + Average receivable collection period – Average payables payment period
= 12 + 2528 = 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.