Stock Analysis on Net

Coca-Cola Co. (NYSE:KO)

Analysis of Short-term (Operating) Activity Ratios

Microsoft Excel

Short-term Activity Ratios (Summary)

Coca-Cola Co., short-term (operating) activity ratios

Microsoft Excel
Dec 31, 2024 Dec 31, 2023 Dec 31, 2022 Dec 31, 2021 Dec 31, 2020
Turnover Ratios
Inventory turnover 3.88 4.19 4.25 4.50 4.11
Receivables turnover 13.19 13.42 12.33 11.01 10.50
Payables turnover 3.35 3.31 3.39 3.34 3.82
Working capital turnover 62.92 14.47 15.00 14.90 7.12
Average No. Days
Average inventory processing period 94 87 86 81 89
Add: Average receivable collection period 28 27 30 33 35
Operating cycle 122 114 116 114 124
Less: Average payables payment period 109 110 108 109 96
Cash conversion cycle 13 4 8 5 28

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

Short-term activity ratio Description The company
Inventory turnover An activity ratio calculated as cost of goods sold divided by inventory. Coca-Cola Co. inventory turnover ratio deteriorated from 2022 to 2023 and from 2023 to 2024.
Receivables turnover An activity ratio equal to revenue divided by receivables. Coca-Cola Co. receivables turnover ratio improved from 2022 to 2023 but then slightly deteriorated from 2023 to 2024.
Payables turnover An activity ratio calculated as cost of goods sold divided by payables. Coca-Cola Co. payables turnover ratio decreased from 2022 to 2023 but then slightly increased from 2023 to 2024.
Working capital turnover An activity ratio calculated as revenue divided by working capital. Coca-Cola Co. working capital turnover ratio deteriorated from 2022 to 2023 but then improved from 2023 to 2024 exceeding 2022 level.

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. Coca-Cola Co. number of days of inventory outstanding deteriorated from 2022 to 2023 and from 2023 to 2024.
Average receivable collection period An activity ratio equal to the number of days in the period divided by receivables turnover. Coca-Cola Co. number of days of receivables outstanding improved from 2022 to 2023 but then slightly deteriorated from 2023 to 2024.
Operating cycle Equal to average inventory processing period plus average receivables collection period. Coca-Cola Co. operating cycle improved from 2022 to 2023 but then deteriorated significantly from 2023 to 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.
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. Coca-Cola Co. cash conversion cycle improved from 2022 to 2023 but then deteriorated significantly from 2023 to 2024.

Inventory Turnover

Coca-Cola Co., inventory turnover calculation, comparison to benchmarks

Microsoft Excel
Dec 31, 2024 Dec 31, 2023 Dec 31, 2022 Dec 31, 2021 Dec 31, 2020
Selected Financial Data (US$ in millions)
Cost of goods sold 18,324 18,520 18,000 15,357 13,433
Inventories 4,728 4,424 4,233 3,414 3,266
Short-term Activity Ratio
Inventory turnover1 3.88 4.19 4.25 4.50 4.11
Benchmarks
Inventory Turnover, Competitors2
Mondelēz International Inc. 5.80 6.16 5.97 6.45 6.10
PepsiCo Inc. 7.87 7.85 7.77 8.53 7.62
Philip Morris International Inc. 1.41 1.20 1.15 1.15 1.00
Inventory Turnover, Sector
Food, Beverage & Tobacco 4.10 3.96 3.97 4.17 3.61
Inventory Turnover, Industry
Consumer Staples 8.01 7.60 7.08 8.15 7.71

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

1 2024 Calculation
Inventory turnover = Cost of goods sold ÷ Inventories
= 18,324 ÷ 4,728 = 3.88

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. Coca-Cola Co. inventory turnover ratio deteriorated from 2022 to 2023 and from 2023 to 2024.

Receivables Turnover

Coca-Cola Co., receivables turnover calculation, comparison to benchmarks

Microsoft Excel
Dec 31, 2024 Dec 31, 2023 Dec 31, 2022 Dec 31, 2021 Dec 31, 2020
Selected Financial Data (US$ in millions)
Net operating revenues 47,061 45,754 43,004 38,655 33,014
Trade accounts receivable, less allowances 3,569 3,410 3,487 3,512 3,144
Short-term Activity Ratio
Receivables turnover1 13.19 13.42 12.33 11.01 10.50
Benchmarks
Receivables Turnover, Competitors2
Mondelēz International Inc. 9.41 9.91 10.20 12.29 11.57
PepsiCo Inc. 8.89 8.46 8.50 9.16 8.37
Philip Morris International Inc. 10.00 10.16 8.25 10.06 9.88
Receivables Turnover, Sector
Food, Beverage & Tobacco 9.89 9.78 9.36 10.10 9.47
Receivables Turnover, Industry
Consumer Staples 32.35 32.56 31.53 34.96 33.86

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

1 2024 Calculation
Receivables turnover = Net operating revenues ÷ Trade accounts receivable, less allowances
= 47,061 ÷ 3,569 = 13.19

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. Coca-Cola Co. receivables turnover ratio improved from 2022 to 2023 but then slightly deteriorated from 2023 to 2024.

Payables Turnover

Coca-Cola Co., payables turnover calculation, comparison to benchmarks

Microsoft Excel
Dec 31, 2024 Dec 31, 2023 Dec 31, 2022 Dec 31, 2021 Dec 31, 2020
Selected Financial Data (US$ in millions)
Cost of goods sold 18,324 18,520 18,000 15,357 13,433
Accounts payable 5,468 5,590 5,307 4,602 3,517
Short-term Activity Ratio
Payables turnover1 3.35 3.31 3.39 3.34 3.82
Benchmarks
Payables Turnover, Competitors2
Mondelēz International Inc. 2.35 2.67 2.67 2.60 2.60
PepsiCo Inc. 3.80 3.60 3.78 3.77 3.59
Philip Morris International Inc. 3.37 3.11 2.80 3.01 3.44
Payables Turnover, Sector
Food, Beverage & Tobacco 3.20 3.22 3.26 3.26 3.32
Payables Turnover, Industry
Consumer Staples 6.94 6.95 6.37 6.65 6.70

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

1 2024 Calculation
Payables turnover = Cost of goods sold ÷ Accounts payable
= 18,324 ÷ 5,468 = 3.35

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. Coca-Cola Co. payables turnover ratio decreased from 2022 to 2023 but then slightly increased from 2023 to 2024.

Working Capital Turnover

Coca-Cola Co., working capital turnover calculation, comparison to benchmarks

Microsoft Excel
Dec 31, 2024 Dec 31, 2023 Dec 31, 2022 Dec 31, 2021 Dec 31, 2020
Selected Financial Data (US$ in millions)
Current assets 25,997 26,732 22,591 22,545 19,240
Less: Current liabilities 25,249 23,571 19,724 19,950 14,601
Working capital 748 3,161 2,867 2,595 4,639
 
Net operating revenues 47,061 45,754 43,004 38,655 33,014
Short-term Activity Ratio
Working capital turnover1 62.92 14.47 15.00 14.90 7.12
Benchmarks
Working Capital Turnover, Competitors2
Mondelēz International Inc.
PepsiCo Inc.
Philip Morris International Inc. 15.29
Working Capital Turnover, Sector
Food, Beverage & Tobacco 164.42
Working Capital Turnover, Industry
Consumer Staples

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

1 2024 Calculation
Working capital turnover = Net operating revenues ÷ Working capital
= 47,061 ÷ 748 = 62.92

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. Coca-Cola Co. working capital turnover ratio deteriorated from 2022 to 2023 but then improved from 2023 to 2024 exceeding 2022 level.

Average Inventory Processing Period

Coca-Cola Co., average inventory processing period calculation, comparison to benchmarks

Microsoft Excel
Dec 31, 2024 Dec 31, 2023 Dec 31, 2022 Dec 31, 2021 Dec 31, 2020
Selected Financial Data
Inventory turnover 3.88 4.19 4.25 4.50 4.11
Short-term Activity Ratio (no. days)
Average inventory processing period1 94 87 86 81 89
Benchmarks (no. days)
Average Inventory Processing Period, Competitors2
Mondelēz International Inc. 63 59 61 57 60
PepsiCo Inc. 46 46 47 43 48
Philip Morris International Inc. 259 305 316 317 366
Average Inventory Processing Period, Sector
Food, Beverage & Tobacco 89 92 92 88 101
Average Inventory Processing Period, Industry
Consumer Staples 46 48 52 45 47

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

1 2024 Calculation
Average inventory processing period = 365 ÷ Inventory turnover
= 365 ÷ 3.88 = 94

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. Coca-Cola Co. number of days of inventory outstanding deteriorated from 2022 to 2023 and from 2023 to 2024.

Average Receivable Collection Period

Coca-Cola Co., average receivable collection period calculation, comparison to benchmarks

Microsoft Excel
Dec 31, 2024 Dec 31, 2023 Dec 31, 2022 Dec 31, 2021 Dec 31, 2020
Selected Financial Data
Receivables turnover 13.19 13.42 12.33 11.01 10.50
Short-term Activity Ratio (no. days)
Average receivable collection period1 28 27 30 33 35
Benchmarks (no. days)
Average Receivable Collection Period, Competitors2
Mondelēz International Inc. 39 37 36 30 32
PepsiCo Inc. 41 43 43 40 44
Philip Morris International Inc. 37 36 44 36 37
Average Receivable Collection Period, Sector
Food, Beverage & Tobacco 37 37 39 36 39
Average Receivable Collection Period, Industry
Consumer Staples 11 11 12 10 11

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

1 2024 Calculation
Average receivable collection period = 365 ÷ Receivables turnover
= 365 ÷ 13.19 = 28

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. Coca-Cola Co. number of days of receivables outstanding improved from 2022 to 2023 but then slightly deteriorated from 2023 to 2024.

Operating Cycle

Coca-Cola Co., operating cycle calculation, comparison to benchmarks

No. days

Microsoft Excel
Dec 31, 2024 Dec 31, 2023 Dec 31, 2022 Dec 31, 2021 Dec 31, 2020
Selected Financial Data
Average inventory processing period 94 87 86 81 89
Average receivable collection period 28 27 30 33 35
Short-term Activity Ratio
Operating cycle1 122 114 116 114 124
Benchmarks
Operating Cycle, Competitors2
Mondelēz International Inc. 102 96 97 87 92
PepsiCo Inc. 87 89 90 83 92
Philip Morris International Inc. 296 341 360 353 403
Operating Cycle, Sector
Food, Beverage & Tobacco 126 129 131 124 140
Operating Cycle, Industry
Consumer Staples 57 59 64 55 58

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

1 2024 Calculation
Operating cycle = Average inventory processing period + Average receivable collection period
= 94 + 28 = 122

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. Coca-Cola Co. operating cycle improved from 2022 to 2023 but then deteriorated significantly from 2023 to 2024.

Average Payables Payment Period

Coca-Cola Co., average payables payment period calculation, comparison to benchmarks

Microsoft Excel
Dec 31, 2024 Dec 31, 2023 Dec 31, 2022 Dec 31, 2021 Dec 31, 2020
Selected Financial Data
Payables turnover 3.35 3.31 3.39 3.34 3.82
Short-term Activity Ratio (no. days)
Average payables payment period1 109 110 108 109 96
Benchmarks (no. days)
Average Payables Payment Period, Competitors2
Mondelēz International Inc. 155 136 137 141 140
PepsiCo Inc. 96 101 97 97 102
Philip Morris International Inc. 108 117 130 121 106
Average Payables Payment Period, Sector
Food, Beverage & Tobacco 114 113 112 112 110
Average Payables Payment Period, Industry
Consumer Staples 53 52 57 55 54

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

1 2024 Calculation
Average payables payment period = 365 ÷ Payables turnover
= 365 ÷ 3.35 = 109

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.

Cash Conversion Cycle

Coca-Cola Co., cash conversion cycle calculation, comparison to benchmarks

No. days

Microsoft Excel
Dec 31, 2024 Dec 31, 2023 Dec 31, 2022 Dec 31, 2021 Dec 31, 2020
Selected Financial Data
Average inventory processing period 94 87 86 81 89
Average receivable collection period 28 27 30 33 35
Average payables payment period 109 110 108 109 96
Short-term Activity Ratio
Cash conversion cycle1 13 4 8 5 28
Benchmarks
Cash Conversion Cycle, Competitors2
Mondelēz International Inc. -53 -40 -40 -54 -48
PepsiCo Inc. -9 -12 -7 -14 -10
Philip Morris International Inc. 188 224 230 232 297
Cash Conversion Cycle, Sector
Food, Beverage & Tobacco 12 16 19 12 30
Cash Conversion Cycle, Industry
Consumer Staples 4 7 7 0 4

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

1 2024 Calculation
Cash conversion cycle = Average inventory processing period + Average receivable collection period – Average payables payment period
= 94 + 28109 = 13

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. Coca-Cola Co. cash conversion cycle improved from 2022 to 2023 but then deteriorated significantly from 2023 to 2024.