Stock Analysis on Net

Coca-Cola Co. (NYSE:KO)

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

Microsoft Excel

Short-term Activity Ratios (Summary)

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

Microsoft Excel
Jun 27, 2025 Mar 28, 2025 Dec 31, 2024 Sep 27, 2024 Jun 28, 2024 Mar 29, 2024 Dec 31, 2023 Sep 29, 2023 Jun 30, 2023 Mar 31, 2023 Dec 31, 2022 Sep 30, 2022 Jul 1, 2022 Apr 1, 2022 Dec 31, 2021 Oct 1, 2021 Jul 2, 2021 Apr 2, 2021 Dec 31, 2020 Sep 25, 2020 Jun 26, 2020 Mar 27, 2020
Turnover Ratios
Inventory turnover 3.57 3.58 3.88 3.89 3.85 3.72 4.19 4.33 3.94 3.86 4.25 4.74 4.69 4.26 4.50 4.67 4.37 4.04 4.11
Receivables turnover 11.29 11.46 13.19 10.95 10.22 10.86 13.42 12.88 11.12 9.46 12.33 10.60 9.19 8.65 11.01 9.72 9.02 8.89 10.50
Working capital turnover 10.09 19.78 62.92 26.97 19.89 41.66 14.47 13.02 12.70 12.35 15.00 15.68 15.83 11.91 14.90 4.58 5.07 6.14 7.12
Average No. Days
Average inventory processing period 102 102 94 94 95 98 87 84 93 95 86 77 78 86 81 78 84 90 89
Add: Average receivable collection period 32 32 28 33 36 34 27 28 33 39 30 34 40 42 33 38 40 41 35
Operating cycle 134 134 122 127 131 132 114 112 126 134 116 111 118 128 114 116 124 131 124

Based on: 10-Q (reporting date: 2025-06-27), 10-Q (reporting date: 2025-03-28), 10-K (reporting date: 2024-12-31), 10-Q (reporting date: 2024-09-27), 10-Q (reporting date: 2024-06-28), 10-Q (reporting date: 2024-03-29), 10-K (reporting date: 2023-12-31), 10-Q (reporting date: 2023-09-29), 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-07-01), 10-Q (reporting date: 2022-04-01), 10-K (reporting date: 2021-12-31), 10-Q (reporting date: 2021-10-01), 10-Q (reporting date: 2021-07-02), 10-Q (reporting date: 2021-04-02), 10-K (reporting date: 2020-12-31), 10-Q (reporting date: 2020-09-25), 10-Q (reporting date: 2020-06-26), 10-Q (reporting date: 2020-03-27).


Inventory Turnover
The inventory turnover ratio exhibits some fluctuations over the observed periods, with values ranging from a high of 4.74 in December 2022 to a low of approximately 3.57 in June 2025. There is a gradual decline in the ratio from early 2023 onwards, suggesting a slower rate of inventory turnover in more recent quarters compared to late 2020 and 2021.
Receivables Turnover
The receivables turnover ratio demonstrates variability but maintains a generally high level, with peaks reaching 13.42 in December 2023 and 13.19 in March 2025. Despite some dips, such as 8.65 in April 2022 and 9.46 in March 2023, the trend shows an overall capacity to convert receivables into cash relatively efficiently over time.
Working Capital Turnover
The working capital turnover ratio reveals significant volatility, with dramatic spikes at various points, notably 41.66 in March 2024 and 62.92 in March 2025. These peaks are interspersed with lower values in prior quarters, such as 4.58 in December 2020 and 5.07 in September 2020, signaling periods of rapid utilization of working capital alternated with less efficient turnover. The elevated ratios in recent periods indicate a potentially intensified use of working capital to support sales.
Average Inventory Processing Period
This metric shows a moderate degree of fluctuation with values mostly between 77 and 102 days. A declining trend is visible from 89 days in March 2020 to a low around 77 days in December 2021, followed by an increase reaching up to 102 days in mid-2025. This pattern indicates that inventory is processed more quickly in some periods, but there has been a tendency towards longer holding times in the most recent periods.
Average Receivable Collection Period
The average receivable collection period ranges approximately between 27 and 42 days. A general downward trend is noted moving from 41 days in mid-2020 to a low of 27 days by December 2023, suggesting improved efficiency in collecting receivables. However, some variability continues, with intermittent increases back to the mid-30s days in early 2024 and mid-2025.
Operating Cycle
The operating cycle, which combines inventory processing and receivable collection periods, fluctuates between 111 and 134 days. The cycle decreases from a higher range of about 124-131 days in 2020 to a low near 111 days in December 2021. Following this, there are periods of lengthening cycles, reaching 134 days in March 2024 and again in June 2025. These shifts reflect changes in the combined efficiency of inventory handling and receivables management over time.

Turnover Ratios


Average No. Days


Inventory Turnover

Coca-Cola Co., inventory turnover calculation (quarterly data)

Microsoft Excel
Jun 27, 2025 Mar 28, 2025 Dec 31, 2024 Sep 27, 2024 Jun 28, 2024 Mar 29, 2024 Dec 31, 2023 Sep 29, 2023 Jun 30, 2023 Mar 31, 2023 Dec 31, 2022 Sep 30, 2022 Jul 1, 2022 Apr 1, 2022 Dec 31, 2021 Oct 1, 2021 Jul 2, 2021 Apr 2, 2021 Dec 31, 2020 Sep 25, 2020 Jun 26, 2020 Mar 27, 2020
Selected Financial Data (US$ in millions)
Cost of goods sold 4,714 4,163 4,613 4,664 4,812 4,235 4,634 4,657 4,912 4,317 4,513 4,566 4,830 4,091 4,088 3,977 3,787 3,505 3,578 3,471 3,013 3,371
Inventories 5,082 5,102 4,728 4,714 4,763 4,961 4,424 4,252 4,646 4,727 4,233 3,708 3,621 3,741 3,414 3,182 3,281 3,356 3,266 3,264 3,501 3,558
Short-term Activity Ratio
Inventory turnover1 3.57 3.58 3.88 3.89 3.85 3.72 4.19 4.33 3.94 3.86 4.25 4.74 4.69 4.26 4.50 4.67 4.37 4.04 4.11
Benchmarks
Inventory Turnover, Competitors2
Mondelēz International Inc. 5.06 5.76 5.80 5.18 5.35 5.92 6.16 5.78 5.66 5.82 5.97 5.71 6.12 6.33 6.45 5.84 5.67 6.13 6.10
PepsiCo Inc. 6.44 7.32 7.87 7.38 7.12 7.57 7.85 7.59 7.01 7.22 7.77 7.83 7.26 7.95 8.53 8.11 6.82 7.10 7.62
Philip Morris International Inc. 1.22 1.30 1.41 1.43 1.40 1.31 1.20 1.31 1.25 1.10 1.15 1.54 1.41 1.19 1.15 1.20 1.11 1.05 1.00

Based on: 10-Q (reporting date: 2025-06-27), 10-Q (reporting date: 2025-03-28), 10-K (reporting date: 2024-12-31), 10-Q (reporting date: 2024-09-27), 10-Q (reporting date: 2024-06-28), 10-Q (reporting date: 2024-03-29), 10-K (reporting date: 2023-12-31), 10-Q (reporting date: 2023-09-29), 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-07-01), 10-Q (reporting date: 2022-04-01), 10-K (reporting date: 2021-12-31), 10-Q (reporting date: 2021-10-01), 10-Q (reporting date: 2021-07-02), 10-Q (reporting date: 2021-04-02), 10-K (reporting date: 2020-12-31), 10-Q (reporting date: 2020-09-25), 10-Q (reporting date: 2020-06-26), 10-Q (reporting date: 2020-03-27).

1 Q2 2025 Calculation
Inventory turnover = (Cost of goods soldQ2 2025 + Cost of goods soldQ1 2025 + Cost of goods soldQ4 2024 + Cost of goods soldQ3 2024) ÷ Inventories
= (4,714 + 4,163 + 4,613 + 4,664) ÷ 5,082 = 3.57

2 Click competitor name to see calculations.


The cost of goods sold (COGS) exhibits fluctuations over the observed periods, with values generally oscillating between approximately 3,000 and 4,800 million US dollars. Notable increases are observed around mid-2022 and mid-2023, peaking near 4,912 million US dollars in June 2023 before slightly declining in subsequent quarters. The early 2020 periods show relatively lower COGS, with a gradual elevation noticeable as time progresses toward 2024 and 2025.

Inventories demonstrate a gradual upward trend throughout the timeline. Starting from approximately 3,558 million US dollars in March 2020, inventory levels increase steadily, reaching a peak around 5,102 million US dollars by March 2025. The growth in inventory appears fairly consistent, with occasional minor declines, such as between mid-2023 and late 2023, but the overall movement is upward.

The inventory turnover ratio, where available, indicates a degree of volatility but generally hovers around the range of 3.5 to 4.7. The ratio peaked at 4.74 in December 2022, suggesting efficient inventory management during that quarter. Subsequent values demonstrate a slight downward trend toward the latter periods, with figures settling closer to 3.5 by mid-2025. This decline in turnover ratio, alongside the rising inventory levels, might imply slower inventory movement or accumulation of stock relative to cost of goods sold in recent quarters.

Cost of Goods Sold (COGS)
Ranges between approximately 3,000 to 4,900 million US dollars, with peaks observed mid-2022 and mid-2023.
Overall upward trajectory with periodic fluctuations, reflecting variable production or sales volumes.
Inventories
Consistent increase from about 3,558 million to over 5,100 million US dollars over five years.
Indicates accumulation of stock, possibly to meet anticipated demand or responding to supply chain factors.
Inventory Turnover Ratio
Values range between approximately 3.5 and 4.7, peaking in late 2022.
Recent downward trend suggests slower inventory movement relative to sales, potentially impacting liquidity or indicating conservative inventory management.

In summary, the financial indicators highlight rising inventory levels coupled with moderately increasing cost of goods sold. The declining inventory turnover ratio in the later periods warrants attention as it may affect working capital efficiency. Monitoring these trends could provide insights on operational efficiency and inventory management strategies moving forward.


Receivables Turnover

Coca-Cola Co., receivables turnover calculation (quarterly data)

Microsoft Excel
Jun 27, 2025 Mar 28, 2025 Dec 31, 2024 Sep 27, 2024 Jun 28, 2024 Mar 29, 2024 Dec 31, 2023 Sep 29, 2023 Jun 30, 2023 Mar 31, 2023 Dec 31, 2022 Sep 30, 2022 Jul 1, 2022 Apr 1, 2022 Dec 31, 2021 Oct 1, 2021 Jul 2, 2021 Apr 2, 2021 Dec 31, 2020 Sep 25, 2020 Jun 26, 2020 Mar 27, 2020
Selected Financial Data (US$ in millions)
Net operating revenues 12,535 11,129 11,544 11,854 12,363 11,300 10,849 11,953 11,972 10,980 10,125 11,063 11,325 10,491 9,464 10,042 10,129 9,020 8,611 8,652 7,150 8,601
Trade accounts receivable, less allowances 4,168 4,091 3,569 4,233 4,545 4,244 3,410 3,495 3,970 4,599 3,487 3,994 4,494 4,641 3,512 3,889 4,036 3,762 3,144 3,827 3,849 4,430
Short-term Activity Ratio
Receivables turnover1 11.29 11.46 13.19 10.95 10.22 10.86 13.42 12.88 11.12 9.46 12.33 10.60 9.19 8.65 11.01 9.72 9.02 8.89 10.50
Benchmarks
Receivables Turnover, Competitors2
Mondelēz International Inc. 10.52 8.44 9.41 9.51 11.37 9.04 9.91 10.12 11.63 9.39 10.20 10.80 12.11 9.94 12.29 10.61 12.51 10.21 11.57
PepsiCo Inc. 7.41 8.47 8.89 7.60 7.71 8.40 8.46 7.78 7.87 8.41 8.50 7.79 7.80 8.58 9.16 8.03 7.67 8.03 8.37
Philip Morris International Inc. 7.82 7.87 10.00 8.78 8.60 8.58 10.16 8.81 8.07 8.80 8.25 8.21 8.32 8.65 10.06 9.10 8.50 8.82 9.88

Based on: 10-Q (reporting date: 2025-06-27), 10-Q (reporting date: 2025-03-28), 10-K (reporting date: 2024-12-31), 10-Q (reporting date: 2024-09-27), 10-Q (reporting date: 2024-06-28), 10-Q (reporting date: 2024-03-29), 10-K (reporting date: 2023-12-31), 10-Q (reporting date: 2023-09-29), 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-07-01), 10-Q (reporting date: 2022-04-01), 10-K (reporting date: 2021-12-31), 10-Q (reporting date: 2021-10-01), 10-Q (reporting date: 2021-07-02), 10-Q (reporting date: 2021-04-02), 10-K (reporting date: 2020-12-31), 10-Q (reporting date: 2020-09-25), 10-Q (reporting date: 2020-06-26), 10-Q (reporting date: 2020-03-27).

1 Q2 2025 Calculation
Receivables turnover = (Net operating revenuesQ2 2025 + Net operating revenuesQ1 2025 + Net operating revenuesQ4 2024 + Net operating revenuesQ3 2024) ÷ Trade accounts receivable, less allowances
= (12,535 + 11,129 + 11,544 + 11,854) ÷ 4,168 = 11.29

2 Click competitor name to see calculations.


Net Operating Revenues

The net operating revenues exhibit notable fluctuations across the periods analyzed. Starting at 8,601 million US dollars in March 2020, revenues decreased to 7,150 million by June 2020, likely reflecting the initial impacts of adverse external conditions.

Subsequently, revenues rebounded to 8,652 million in September 2020 and stabilized around the 8,600 to 9,000 million range through December 2020 and April 2021. A marked growth phase occurred from the second quarter of 2021, reaching a peak of 11,972 million in June 2023.

Despite some cyclic declines, the general trend from mid-2020 onward is upward, with revenues generally increasing quarter over quarter, culminating in 12,535 million by June 2025. The data indicates recovery and expansion in revenue-generating activities over this timeframe.

Trade Accounts Receivable, Less Allowances

This item demonstrates variability, beginning at 4,430 million US dollars in March 2020, decreasing sharply to 3,849 million in June 2020 and further to 3,144 million by December 2020. This decline may correspond with the reduction in revenues or changes in credit policies.

Following this period, trade receivables generally rose, peaking at 4,641 million in April 2022. Afterward, values slightly fluctuated but remained relatively stable, staying mostly within the 3,400 to 4,500 million range through mid-2025.

Overall, the trade receivables indicate a mixed pattern with initial contraction followed by recovery and relative stabilization, reflecting changes in sales volume, collection efficiency, or credit terms.

Receivables Turnover Ratio

The receivables turnover ratio, which measures how efficiently receivables are collected, shows variation between approximately 8.65 and 13.42 during the periods recorded.

In late 2020, the ratio ranged from 8.89 to 11.01, suggesting moderate collection efficiency. An improving trend is observed in 2022 and 2023, with ratios increasing to as high as 13.42, indicating enhanced collection performance or a shift to shorter credit terms.

However, some fluctuations occur, with ratios dipping below 11 at times, implying periods of relatively slower collection. The overall trajectory suggests progressive improvement in receivables management over the analysed timeframe.


Working Capital Turnover

Coca-Cola Co., working capital turnover calculation (quarterly data)

Microsoft Excel
Jun 27, 2025 Mar 28, 2025 Dec 31, 2024 Sep 27, 2024 Jun 28, 2024 Mar 29, 2024 Dec 31, 2023 Sep 29, 2023 Jun 30, 2023 Mar 31, 2023 Dec 31, 2022 Sep 30, 2022 Jul 1, 2022 Apr 1, 2022 Dec 31, 2021 Oct 1, 2021 Jul 2, 2021 Apr 2, 2021 Dec 31, 2020 Sep 25, 2020 Jun 26, 2020 Mar 27, 2020
Selected Financial Data (US$ in millions)
Current assets 26,609 26,178 25,997 30,288 31,599 29,462 26,732 27,867 27,591 26,880 22,591 24,139 23,141 22,156 22,545 24,240 22,481 21,932 19,240 30,410 29,371 28,234
Less: Current liabilities 21,944 23,808 25,249 28,569 29,263 28,356 23,571 24,409 24,115 23,357 19,724 21,439 20,531 18,787 19,950 15,990 15,299 16,486 14,601 26,891 26,848 32,397
Working capital 4,665 2,370 748 1,719 2,336 1,106 3,161 3,458 3,476 3,523 2,867 2,700 2,610 3,369 2,595 8,250 7,182 5,446 4,639 3,519 2,523 (4,163)
 
Net operating revenues 12,535 11,129 11,544 11,854 12,363 11,300 10,849 11,953 11,972 10,980 10,125 11,063 11,325 10,491 9,464 10,042 10,129 9,020 8,611 8,652 7,150 8,601
Short-term Activity Ratio
Working capital turnover1 10.09 19.78 62.92 26.97 19.89 41.66 14.47 13.02 12.70 12.35 15.00 15.68 15.83 11.91 14.90 4.58 5.07 6.14 7.12
Benchmarks
Working Capital Turnover, Competitors2
Mondelēz International Inc.
PepsiCo Inc.
Philip Morris International Inc. 10.52 10.81 15.29

Based on: 10-Q (reporting date: 2025-06-27), 10-Q (reporting date: 2025-03-28), 10-K (reporting date: 2024-12-31), 10-Q (reporting date: 2024-09-27), 10-Q (reporting date: 2024-06-28), 10-Q (reporting date: 2024-03-29), 10-K (reporting date: 2023-12-31), 10-Q (reporting date: 2023-09-29), 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-07-01), 10-Q (reporting date: 2022-04-01), 10-K (reporting date: 2021-12-31), 10-Q (reporting date: 2021-10-01), 10-Q (reporting date: 2021-07-02), 10-Q (reporting date: 2021-04-02), 10-K (reporting date: 2020-12-31), 10-Q (reporting date: 2020-09-25), 10-Q (reporting date: 2020-06-26), 10-Q (reporting date: 2020-03-27).

1 Q2 2025 Calculation
Working capital turnover = (Net operating revenuesQ2 2025 + Net operating revenuesQ1 2025 + Net operating revenuesQ4 2024 + Net operating revenuesQ3 2024) ÷ Working capital
= (12,535 + 11,129 + 11,544 + 11,854) ÷ 4,665 = 10.09

2 Click competitor name to see calculations.


The financial data reveals several notable trends and fluctuations in key performance indicators over the observed quarters.

Working Capital
Working capital exhibited significant volatility throughout the periods. It started with a negative value in March 2020, indicating potential liquidity challenges at the outset. Following this, there was a consistent upward trend peaking around October 2021, where the working capital reached its highest values, suggesting improved liquidity and operational efficiency during that timeframe. However, post-October 2021, there was a marked decrease with subsequent fluctuations, showing periods of contraction and recovery. The most recent quarters reflect a moderate level of working capital, considerably lower than the peak observed but still positive, which may indicate cautious management of current assets and liabilities.
Net Operating Revenues
Net operating revenues showed general growth with notable seasonal fluctuations. Revenues started at a moderate level in early 2020, experiencing a dip in the second quarter likely reflective of external disruptions during that period. Afterward, revenues recovered and generally trended upward, reaching peak values in mid-2023. Despite some quarters showing minor declines or stabilization, the overall pattern suggests steady revenue growth, indicating robustness in the core business operations over the long term. The last two quarters showed a resurgence in revenues, possibly driven by market expansion or price adjustments.
Working Capital Turnover
Working capital turnover ratios were not reported for the initial quarters. Beginning in late 2020, the ratio showed relatively high values, indicating efficient use of working capital to generate revenues. There was some decline observed through late 2021, but the ratio remained elevated, signifying effective operational management. Subsequently, ratios displayed notable spikes in certain quarters, such as in March and December 2024, suggesting periods of heightened efficiency or perhaps lower working capital bases relative to revenues. The turnover ratio’s volatility indicates fluctuating effectiveness in working capital utilization, with certain periods reflecting exceptional productivity.

Overall, the data reflects a period of recovery and growth in revenues following early disruptions, with working capital management showing periods of both strength and stress. The fluctuations in working capital turnover underscore variable operational efficiency, which may warrant further investigation into underlying causes such as changes in inventory management, receivables, or payables cycles.


Average Inventory Processing Period

Coca-Cola Co., average inventory processing period calculation (quarterly data)

Microsoft Excel
Jun 27, 2025 Mar 28, 2025 Dec 31, 2024 Sep 27, 2024 Jun 28, 2024 Mar 29, 2024 Dec 31, 2023 Sep 29, 2023 Jun 30, 2023 Mar 31, 2023 Dec 31, 2022 Sep 30, 2022 Jul 1, 2022 Apr 1, 2022 Dec 31, 2021 Oct 1, 2021 Jul 2, 2021 Apr 2, 2021 Dec 31, 2020 Sep 25, 2020 Jun 26, 2020 Mar 27, 2020
Selected Financial Data
Inventory turnover 3.57 3.58 3.88 3.89 3.85 3.72 4.19 4.33 3.94 3.86 4.25 4.74 4.69 4.26 4.50 4.67 4.37 4.04 4.11
Short-term Activity Ratio (no. days)
Average inventory processing period1 102 102 94 94 95 98 87 84 93 95 86 77 78 86 81 78 84 90 89
Benchmarks (no. days)
Average Inventory Processing Period, Competitors2
Mondelēz International Inc. 72 63 63 70 68 62 59 63 65 63 61 64 60 58 57 62 64 60 60
PepsiCo Inc. 57 50 46 49 51 48 46 48 52 51 47 47 50 46 43 45 54 51 48
Philip Morris International Inc. 299 281 259 255 260 279 305 278 291 330 316 237 259 306 317 305 330 349 366

Based on: 10-Q (reporting date: 2025-06-27), 10-Q (reporting date: 2025-03-28), 10-K (reporting date: 2024-12-31), 10-Q (reporting date: 2024-09-27), 10-Q (reporting date: 2024-06-28), 10-Q (reporting date: 2024-03-29), 10-K (reporting date: 2023-12-31), 10-Q (reporting date: 2023-09-29), 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-07-01), 10-Q (reporting date: 2022-04-01), 10-K (reporting date: 2021-12-31), 10-Q (reporting date: 2021-10-01), 10-Q (reporting date: 2021-07-02), 10-Q (reporting date: 2021-04-02), 10-K (reporting date: 2020-12-31), 10-Q (reporting date: 2020-09-25), 10-Q (reporting date: 2020-06-26), 10-Q (reporting date: 2020-03-27).

1 Q2 2025 Calculation
Average inventory processing period = 365 ÷ Inventory turnover
= 365 ÷ 3.57 = 102

2 Click competitor name to see calculations.


Inventory Turnover
The inventory turnover ratio shows an overall downward trend across the observed periods, starting from 4.11 and reaching values around 3.57 by the end of the latest period. Initially, the ratio fluctuates moderately, with peaks near 4.74 observed around late 2022, followed by a gradual decline through 2023 and 2024. This decreasing trend indicates a slowing in the frequency with which inventory is sold and replaced.
Average Inventory Processing Period
Corresponding to the inventory turnover trend, the average inventory processing period exhibits an opposite pattern, increasing from approximately 89 days to over 100 days by the end of the series. After a period of improvement with lower processing days around late 2021 and early 2022, the processing period lengthens steadily, suggesting that inventory remains in stock for longer durations as time progresses.
Relationship and Implications
There is an inverse correlation between inventory turnover and the average inventory processing period, reflecting the typical dynamic where lower turnover ratios correspond to longer holding periods. The observed trends imply a potential decline in operational efficiency related to inventory management, which may affect liquidity and working capital management. Extended inventory holding periods could indicate slower sales or overstocking that might increase storage costs and risk of obsolescence.

Average Receivable Collection Period

Coca-Cola Co., average receivable collection period calculation (quarterly data)

Microsoft Excel
Jun 27, 2025 Mar 28, 2025 Dec 31, 2024 Sep 27, 2024 Jun 28, 2024 Mar 29, 2024 Dec 31, 2023 Sep 29, 2023 Jun 30, 2023 Mar 31, 2023 Dec 31, 2022 Sep 30, 2022 Jul 1, 2022 Apr 1, 2022 Dec 31, 2021 Oct 1, 2021 Jul 2, 2021 Apr 2, 2021 Dec 31, 2020 Sep 25, 2020 Jun 26, 2020 Mar 27, 2020
Selected Financial Data
Receivables turnover 11.29 11.46 13.19 10.95 10.22 10.86 13.42 12.88 11.12 9.46 12.33 10.60 9.19 8.65 11.01 9.72 9.02 8.89 10.50
Short-term Activity Ratio (no. days)
Average receivable collection period1 32 32 28 33 36 34 27 28 33 39 30 34 40 42 33 38 40 41 35
Benchmarks (no. days)
Average Receivable Collection Period, Competitors2
Mondelēz International Inc. 35 43 39 38 32 40 37 36 31 39 36 34 30 37 30 34 29 36 32
PepsiCo Inc. 49 43 41 48 47 43 43 47 46 43 43 47 47 43 40 45 48 45 44
Philip Morris International Inc. 47 46 37 42 42 43 36 41 45 41 44 44 44 42 36 40 43 41 37

Based on: 10-Q (reporting date: 2025-06-27), 10-Q (reporting date: 2025-03-28), 10-K (reporting date: 2024-12-31), 10-Q (reporting date: 2024-09-27), 10-Q (reporting date: 2024-06-28), 10-Q (reporting date: 2024-03-29), 10-K (reporting date: 2023-12-31), 10-Q (reporting date: 2023-09-29), 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-07-01), 10-Q (reporting date: 2022-04-01), 10-K (reporting date: 2021-12-31), 10-Q (reporting date: 2021-10-01), 10-Q (reporting date: 2021-07-02), 10-Q (reporting date: 2021-04-02), 10-K (reporting date: 2020-12-31), 10-Q (reporting date: 2020-09-25), 10-Q (reporting date: 2020-06-26), 10-Q (reporting date: 2020-03-27).

1 Q2 2025 Calculation
Average receivable collection period = 365 ÷ Receivables turnover
= 365 ÷ 11.29 = 32

2 Click competitor name to see calculations.


The receivables turnover ratio exhibits fluctuations over the observed periods, generally ranging between approximately 8.6 and 13.4. After missing data in early quarters, a level of 10.5 is recorded in late 2020, followed by a decline reaching near 8.65 in early 2022. Subsequently, there is a rising trend with peaks above 12 in late 2022 and late 2023, reaching the highest turnover ratio of about 13.42 in December 2023. The ratio somewhat moderates afterward but stays above 10 into mid-2025.

The average receivable collection period inversely reflects these turnover trends, moving between roughly 27 and 42 days. After initial values around 35 days in late 2020, this metric lengthens to over 41 days by mid-2021 and early 2022, indicating slower collections. Then, a downward adjustment occurs with a reducing trend to as low as 27 days in late 2023, signaling improved efficiency in receivables collection. Slight fluctuations occur thereafter, with days increasing again to the low 30s by mid-2025.

Receivables Turnover Ratio
Shows notable variability, with a tendency toward improvement after a dip in early 2022; peaks during late 2022 and 2023 suggest stronger collection performance during these quarters.
Average Receivable Collection Period
Varies inversely to turnover ratios, with longer collection periods early in the dataset transitioning to shorter periods later, reflecting enhanced collection efficiency, particularly around late 2023.

The data generally indicates a cycle of slower receivables collection during 2021 and early 2022 followed by a pronounced improvement in subsequent periods. This could suggest seasonal or market-driven influences impacting collection efficiency. The improvements in turnover and reduced collection days in later quarters point to more effective working capital management and potentially better cash flow generation.


Operating Cycle

Coca-Cola Co., operating cycle calculation (quarterly data)

No. days

Microsoft Excel
Jun 27, 2025 Mar 28, 2025 Dec 31, 2024 Sep 27, 2024 Jun 28, 2024 Mar 29, 2024 Dec 31, 2023 Sep 29, 2023 Jun 30, 2023 Mar 31, 2023 Dec 31, 2022 Sep 30, 2022 Jul 1, 2022 Apr 1, 2022 Dec 31, 2021 Oct 1, 2021 Jul 2, 2021 Apr 2, 2021 Dec 31, 2020 Sep 25, 2020 Jun 26, 2020 Mar 27, 2020
Selected Financial Data
Average inventory processing period 102 102 94 94 95 98 87 84 93 95 86 77 78 86 81 78 84 90 89
Average receivable collection period 32 32 28 33 36 34 27 28 33 39 30 34 40 42 33 38 40 41 35
Short-term Activity Ratio
Operating cycle1 134 134 122 127 131 132 114 112 126 134 116 111 118 128 114 116 124 131 124
Benchmarks
Operating Cycle, Competitors2
Mondelēz International Inc. 107 106 102 108 100 102 96 99 96 102 97 98 90 95 87 96 93 96 92
PepsiCo Inc. 106 93 87 97 98 91 89 95 98 94 90 94 97 89 83 90 102 96 92
Philip Morris International Inc. 346 327 296 297 302 322 341 319 336 371 360 281 303 348 353 345 373 390 403

Based on: 10-Q (reporting date: 2025-06-27), 10-Q (reporting date: 2025-03-28), 10-K (reporting date: 2024-12-31), 10-Q (reporting date: 2024-09-27), 10-Q (reporting date: 2024-06-28), 10-Q (reporting date: 2024-03-29), 10-K (reporting date: 2023-12-31), 10-Q (reporting date: 2023-09-29), 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-07-01), 10-Q (reporting date: 2022-04-01), 10-K (reporting date: 2021-12-31), 10-Q (reporting date: 2021-10-01), 10-Q (reporting date: 2021-07-02), 10-Q (reporting date: 2021-04-02), 10-K (reporting date: 2020-12-31), 10-Q (reporting date: 2020-09-25), 10-Q (reporting date: 2020-06-26), 10-Q (reporting date: 2020-03-27).

1 Q2 2025 Calculation
Operating cycle = Average inventory processing period + Average receivable collection period
= 102 + 32 = 134

2 Click competitor name to see calculations.


The analysis of the financial periods reveals several noteworthy trends in the company's operational efficiency as measured by inventory and receivable management, as well as the overall operating cycle.

Average Inventory Processing Period

This metric shows fluctuations over the periods observed. From early 2020 to mid-2021, the processing period remained relatively stable, with values around the upper 80s to lower 90s in days. Starting in late 2021, a downward trend is visible, reaching a low of 77 days by the end of 2021. However, this was followed by volatility in 2022 and 2023, with periods of increase peaking at 98 days by early 2024. The trend indicates varying efficiency in inventory turnover, with some recent softness as the period extends over 100 days in the last two periods of 2025, suggesting a potential slowdown in inventory movement or changes in inventory management practices.

Average Receivable Collection Period

The receivable collection period exhibits moderate fluctuations within a range of roughly 27 to 42 days throughout the observed timeline. There is no strong long-term upward or downward trend noticeable. The collection period increased slightly in the middle of the timeline around mid-2021, with a peak at 42 days, followed by a decline to the upper 20s by late 2023, indicating some improvements in collection efficiency. Nonetheless, the values again trend upward slightly but remain near the mid-30s towards the end, suggesting a relatively consistent but moderately fluctuating collection pattern.

Operating Cycle

The operating cycle, which combines inventory processing and receivable collection, broadly mirrors the variability seen in inventory and receivables periods. After increasing to a peak of 131 days mid-2020 and 2024, it declines at certain intervals, reaching lows around 111 to 112 days at the end of 2021 and 2023 respectively. This cyclical pattern points to alternating periods of operational efficiency and slowdown. The overall trend suggests that while the company has managed to reduce the operating cycle at times, particularly at the end of 2021 and 2023, recent periods show an extension back towards the higher levels, indicating challenges in maintaining a consistently shorter operating cycle.

In summary, the data reflects dynamic changes in working capital components, with inventory management showing the most pronounced variability. While efforts to optimize receivables seem to have had some positive effect during certain periods, the overall operating cycle remains subject to fluctuations primarily driven by inventory processing durations. Attention to managing inventory levels more consistently could improve operational efficiency and shorten the operating cycle in the future.