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)
Turnover Ratios
Average No. Days
Based on: 10-K (reporting date: 2023-06-30), 10-K (reporting date: 2022-06-30), 10-K (reporting date: 2021-06-30), 10-K (reporting date: 2020-06-30), 10-K (reporting date: 2019-06-30), 10-K (reporting date: 2018-06-30).
The overall operating efficiency of the organization reflects a lengthening of the cash conversion cycle over the analyzed six-year period, moving from 96 days in 2018 to 137 days by 2023. This trend indicates a decrease in the speed at which cash is recovered from investments in working capital, primarily driven by slower inventory movement and a reduction in the average payables payment period.
- Inventory Management Efficiency
- A general decline in inventory turnover is observed, decreasing from 1.76 in 2018 to 1.53 in 2023. This correlates with an increase in the average inventory processing period, which rose from 208 days to 238 days. The peak duration occurred in 2022 at 248 days, suggesting a trend toward slower inventory liquidation and potential challenges in managing stock levels relative to sales.
- Receivables and Collection Performance
- Efficiency in receivables management has improved. The receivables turnover increased from 9.20 in 2018 to 10.96 in 2023, while the average receivable collection period shortened from 40 days to 33 days. This indicates a more aggressive or effective collection process, reducing the time capital remains tied up in outstanding customer invoices.
- Payables and Liquidity Strategy
- The average payables payment period has seen a overall reduction, declining from 152 days in 2018 to 134 days in 2023. The payables turnover ratio increased from 2.41 to 2.73 over the same period. The tendency to settle obligations more quickly, combined with slower inventory turnover, has contributed to the expansion of the cash conversion cycle.
- Operational Cycle and Working Capital Utilization
- The operating cycle expanded from 248 days in 2018 to 271 days in 2023, peaking at 282 days in 2022. This expansion is predominantly attributable to the increased inventory processing time. Meanwhile, the working capital turnover ratio has fluctuated, starting at 4.79, dipping to 3.63 in 2021, and recovering to 5.49 by 2023, indicating varying levels of efficiency in using working capital to generate revenue.
AI Ask an analyst for more
Hi, I’m an AI-powered financial analyst at Stock Analysis on Net.
How can I help you?
Inventory Turnover
| Jun 30, 2023 | Jun 30, 2022 | Jun 30, 2021 | Jun 30, 2020 | Jun 30, 2019 | Jun 30, 2018 | ||
|---|---|---|---|---|---|---|---|
| Selected Financial Data (US$ in millions) | |||||||
| Cost of sales | 4,564) | 4,305) | 3,834) | 3,552) | 3,387) | 2,844) | |
| Inventory and promotional merchandise | 2,979) | 2,920) | 2,505) | 2,062) | 2,006) | 1,618) | |
| Short-term Activity Ratio | |||||||
| Inventory turnover1 | 1.53 | 1.47 | 1.53 | 1.72 | 1.69 | 1.76 | |
| Benchmarks | |||||||
| Inventory Turnover, Competitors2 | |||||||
| Procter & Gamble Co. | 6.05 | 6.09 | 6.20 | — | — | — | |
| Inventory Turnover, Industry | |||||||
| Consumer Staples | 7.60 | 7.08 | 8.15 | — | — | — | |
Based on: 10-K (reporting date: 2023-06-30), 10-K (reporting date: 2022-06-30), 10-K (reporting date: 2021-06-30), 10-K (reporting date: 2020-06-30), 10-K (reporting date: 2019-06-30), 10-K (reporting date: 2018-06-30).
1 2023 Calculation
Inventory turnover = Cost of sales ÷ Inventory and promotional merchandise
= 4,564 ÷ 2,979 = 1.53
2 Click competitor name to see calculations.
Between June 30, 2018, and June 30, 2023, a consistent upward trajectory is observed in both the cost of sales and the value of inventory and promotional merchandise. However, the rate of inventory accumulation has outpaced the growth in the cost of sales, leading to a general decline in operational efficiency regarding stock turnover.
- Cost of Sales Analysis
- The cost of sales grew steadily from US$ 2,844 million in 2018 to US$ 4,564 million in 2023. This represents a sustained increase in the direct costs associated with generating revenue over the six-year period.
- Inventory and Promotional Merchandise Trends
- Inventory levels increased from US$ 1,618 million in 2018 to US$ 2,979 million in 2023. The growth in this asset category was more aggressive than the growth in the cost of sales, indicating a significant expansion of the company's stock holdings.
- Inventory Turnover Ratio Dynamics
- The inventory turnover ratio experienced a general decline, moving from 1.76 in 2018 to a low of 1.47 in 2022. Although a slight recovery to 1.53 occurred in 2023, the ratio remains lower than the levels seen at the beginning of the analyzed period.
The downward trend in the inventory turnover ratio suggests that the company is taking longer to sell its inventory. This pattern indicates that inventory growth has exceeded the growth in sales volume, resulting in a slower conversion of stock into revenue. The slight improvement in 2023 suggests a potential stabilization in inventory management practices following the trough in 2022.
AI Ask an analyst for more
Hi, I’m an AI-powered financial analyst at Stock Analysis on Net.
How can I help you?
Receivables Turnover
| Jun 30, 2023 | Jun 30, 2022 | Jun 30, 2021 | Jun 30, 2020 | Jun 30, 2019 | Jun 30, 2018 | ||
|---|---|---|---|---|---|---|---|
| Selected Financial Data (US$ in millions) | |||||||
| Net sales | 15,910) | 17,737) | 16,215) | 14,294) | 14,863) | 13,683) | |
| Accounts receivable, net | 1,452) | 1,629) | 1,702) | 1,194) | 1,831) | 1,487) | |
| Short-term Activity Ratio | |||||||
| Receivables turnover1 | 10.96 | 10.89 | 9.53 | 11.97 | 8.12 | 9.20 | |
| Benchmarks | |||||||
| Receivables Turnover, Competitors2 | |||||||
| Procter & Gamble Co. | 14.99 | 15.59 | 16.11 | — | — | — | |
| Receivables Turnover, Industry | |||||||
| Consumer Staples | 32.56 | 31.53 | 34.96 | — | — | — | |
Based on: 10-K (reporting date: 2023-06-30), 10-K (reporting date: 2022-06-30), 10-K (reporting date: 2021-06-30), 10-K (reporting date: 2020-06-30), 10-K (reporting date: 2019-06-30), 10-K (reporting date: 2018-06-30).
1 2023 Calculation
Receivables turnover = Net sales ÷ Accounts receivable, net
= 15,910 ÷ 1,452 = 10.96
2 Click competitor name to see calculations.
An analysis of the short-term operating activity indicates fluctuating efficiency in the management of accounts receivable between 2018 and 2023. While net sales reached a peak in 2022, the receivables turnover ratio did not follow a linear trajectory, reflecting variance in credit collection efficiency and asset management over the six-year period.
- Receivables Turnover Trends
- The receivables turnover ratio experienced a decline from 9.20 in 2018 to a period low of 8.12 in 2019. A sharp reversal occurred in 2020, with the ratio increasing to 11.97, marking the highest efficiency level in the observed period. Following this peak, the ratio decreased to 9.53 in 2021 before recovering and stabilizing at 10.89 in 2022 and 10.96 in 2023.
- Correlation Between Sales and Receivables
- Net sales grew from US$ 13,683 million in 2018 to a peak of US$ 17,737 million in 2022, before contracting to US$ 15,910 million in 2023. In 2019, the growth in sales was accompanied by a disproportionate increase in net accounts receivable to US$ 1,831 million, which resulted in the decline of the turnover ratio. In contrast, the efficiency spike in 2020 was driven by a significant reduction in net accounts receivable to US$ 1,194 million, despite a slight decrease in overall net sales.
- Operational Efficiency Insights
- The data suggests an improvement in collection consistency during the final two years of the analysis. Despite a decrease in net sales in 2023, the receivables turnover ratio remained stable and slightly improved to 10.96. This indicates that the reduction in sales was mirrored by a proportional decrease in net accounts receivable, maintaining a steady rate of cash conversion from credit sales.
AI Ask an analyst for more
Hi, I’m an AI-powered financial analyst at Stock Analysis on Net.
How can I help you?
Payables Turnover
| Jun 30, 2023 | Jun 30, 2022 | Jun 30, 2021 | Jun 30, 2020 | Jun 30, 2019 | Jun 30, 2018 | ||
|---|---|---|---|---|---|---|---|
| Selected Financial Data (US$ in millions) | |||||||
| Cost of sales | 4,564) | 4,305) | 3,834) | 3,552) | 3,387) | 2,844) | |
| Accounts payable | 1,670) | 1,822) | 1,692) | 1,177) | 1,490) | 1,182) | |
| Short-term Activity Ratio | |||||||
| Payables turnover1 | 2.73 | 2.36 | 2.27 | 3.02 | 2.27 | 2.41 | |
| Benchmarks | |||||||
| Payables Turnover, Competitors2 | |||||||
| Procter & Gamble Co. | 2.93 | 2.83 | 2.70 | — | — | — | |
| Payables Turnover, Industry | |||||||
| Consumer Staples | 6.95 | 6.37 | 6.65 | — | — | — | |
Based on: 10-K (reporting date: 2023-06-30), 10-K (reporting date: 2022-06-30), 10-K (reporting date: 2021-06-30), 10-K (reporting date: 2020-06-30), 10-K (reporting date: 2019-06-30), 10-K (reporting date: 2018-06-30).
1 2023 Calculation
Payables turnover = Cost of sales ÷ Accounts payable
= 4,564 ÷ 1,670 = 2.73
2 Click competitor name to see calculations.
The financial performance between 2018 and 2023 indicates a consistent expansion in the scale of operations, evidenced by a steady increase in the cost of sales. While the liabilities associated with accounts payable generally trended upward, the payables turnover ratio exhibited volatility, reflecting shifts in the efficiency and timing of supplier payments.
- Cost of Sales Trend
- A continuous growth trajectory is observed in the cost of sales, which rose from 2,844 million USD in 2018 to 4,564 million USD in 2023. This represents a sustained increase in the expenditures required to support the company's revenue generation over the six-year period.
- Accounts Payable Dynamics
- Accounts payable grew from 1,182 million USD in 2018 to a peak of 1,822 million USD in 2022, before declining to 1,670 million USD in 2023. A significant contraction occurred in 2020, where payables decreased to 1,177 million USD, indicating a period of accelerated liability settlement or a temporary reduction in available supplier credit.
- Payables Turnover Analysis
- The payables turnover ratio fluctuated between a low of 2.27 and a high of 3.02. The peak turnover of 3.02 in 2020 coincides with the period of lowest accounts payable relative to cost of sales, signifying the fastest payment cycle of the analyzed timeframe. Following this, the ratio returned to 2.27 in 2021 and ended the period at 2.73 in 2023. These movements suggest a variable approach to managing working capital, alternating between the utilization of supplier credit to maintain liquidity and the acceleration of payments.
AI Ask an analyst for more
Hi, I’m an AI-powered financial analyst at Stock Analysis on Net.
How can I help you?
Working Capital Turnover
| Jun 30, 2023 | Jun 30, 2022 | Jun 30, 2021 | Jun 30, 2020 | Jun 30, 2019 | Jun 30, 2018 | ||
|---|---|---|---|---|---|---|---|
| Selected Financial Data (US$ in millions) | |||||||
| Current assets | 9,139) | 9,298) | 9,768) | 8,892) | 7,212) | 6,168) | |
| Less: Current liabilities | 6,240) | 5,815) | 5,298) | 5,179) | 4,605) | 3,310) | |
| Working capital | 2,899) | 3,483) | 4,470) | 3,713) | 2,607) | 2,858) | |
| Net sales | 15,910) | 17,737) | 16,215) | 14,294) | 14,863) | 13,683) | |
| Short-term Activity Ratio | |||||||
| Working capital turnover1 | 5.49 | 5.09 | 3.63 | 3.85 | 5.70 | 4.79 | |
| Benchmarks | |||||||
| Working Capital Turnover, Competitors2 | |||||||
| Procter & Gamble Co. | — | — | — | — | — | — | |
| Working Capital Turnover, Industry | |||||||
| Consumer Staples | — | — | — | — | — | — | |
Based on: 10-K (reporting date: 2023-06-30), 10-K (reporting date: 2022-06-30), 10-K (reporting date: 2021-06-30), 10-K (reporting date: 2020-06-30), 10-K (reporting date: 2019-06-30), 10-K (reporting date: 2018-06-30).
1 2023 Calculation
Working capital turnover = Net sales ÷ Working capital
= 15,910 ÷ 2,899 = 5.49
2 Click competitor name to see calculations.
An analysis of the operating activity ratios between 2018 and 2023 reveals a period of volatility in working capital management and its corresponding impact on revenue efficiency. The relationship between current assets and liabilities relative to net sales shows a distinct U-shaped trend in efficiency over the observed timeframe.
- Working Capital Trends
- Working capital levels demonstrated significant fluctuations, starting at 2,858 million in 2018 and dipping to 2,607 million in 2019. A substantial upward trend followed, with capital requirements peaking at 4,470 million in 2021. This peak was followed by a steady contraction over the next two years, returning to 2,899 million by June 30, 2023.
- Net Sales Performance
- Net sales grew steadily from 13,683 million in 2018 to a peak of 17,737 million in 2022. While a slight dip occurred in 2020, the general trajectory remained positive until 2023, when a decline to 15,910 million was recorded.
- Working Capital Turnover Efficiency
- The turnover ratio indicates varying levels of operational efficiency. A high efficiency point was reached in 2019 with a ratio of 5.70. This was followed by a two-year decline, reaching a minimum of 3.63 in 2021, which correlates with the period of highest working capital investment. A recovery in efficiency is observed in 2022 and 2023, with the ratio rising to 5.09 and 5.49, respectively. This recovery is primarily attributed to the reduction in working capital during a period where sales remained elevated relative to 2018 levels.
AI Ask an analyst for more
Hi, I’m an AI-powered financial analyst at Stock Analysis on Net.
How can I help you?
Average Inventory Processing Period
| Jun 30, 2023 | Jun 30, 2022 | Jun 30, 2021 | Jun 30, 2020 | Jun 30, 2019 | Jun 30, 2018 | ||
|---|---|---|---|---|---|---|---|
| Selected Financial Data | |||||||
| Inventory turnover | 1.53 | 1.47 | 1.53 | 1.72 | 1.69 | 1.76 | |
| Short-term Activity Ratio (no. days) | |||||||
| Average inventory processing period1 | 238 | 248 | 238 | 212 | 216 | 208 | |
| Benchmarks (no. days) | |||||||
| Average Inventory Processing Period, Competitors2 | |||||||
| Procter & Gamble Co. | 60 | 60 | 59 | — | — | — | |
| Average Inventory Processing Period, Industry | |||||||
| Consumer Staples | 48 | 52 | 45 | — | — | — | |
Based on: 10-K (reporting date: 2023-06-30), 10-K (reporting date: 2022-06-30), 10-K (reporting date: 2021-06-30), 10-K (reporting date: 2020-06-30), 10-K (reporting date: 2019-06-30), 10-K (reporting date: 2018-06-30).
1 2023 Calculation
Average inventory processing period = 365 ÷ Inventory turnover
= 365 ÷ 1.53 = 238
2 Click competitor name to see calculations.
An analysis of the operating activity ratios between 2018 and 2023 reveals a general decline in inventory management efficiency, followed by a slight stabilization in the final year of the period.
- Inventory Turnover Trends
- A general downward trajectory is observed from 2018 to 2022, with the turnover ratio declining from 1.76 to a low of 1.47. This trend indicates a reduction in the frequency with which inventory is sold and replaced during the fiscal year. A marginal recovery occurred in 2023, with the ratio returning to 1.53.
- Average Inventory Processing Period
- The time required to move inventory through the supply chain shows an overall upward trend, increasing from 208 days in 2018 to a peak of 248 days in 2022. This expansion suggests that goods remained in stock for longer durations before being converted into sales. In 2023, the processing period decreased to 238 days, reflecting a modest improvement in inventory velocity.
- Correlation of Activity Ratios
- A consistent inverse relationship is maintained between the turnover ratio and the processing period. The period of lowest operational efficiency in 2022 is characterized by the intersection of the minimum turnover ratio (1.47) and the maximum processing period (248 days).
AI Ask an analyst for more
Hi, I’m an AI-powered financial analyst at Stock Analysis on Net.
How can I help you?
Average Receivable Collection Period
| Jun 30, 2023 | Jun 30, 2022 | Jun 30, 2021 | Jun 30, 2020 | Jun 30, 2019 | Jun 30, 2018 | ||
|---|---|---|---|---|---|---|---|
| Selected Financial Data | |||||||
| Receivables turnover | 10.96 | 10.89 | 9.53 | 11.97 | 8.12 | 9.20 | |
| Short-term Activity Ratio (no. days) | |||||||
| Average receivable collection period1 | 33 | 34 | 38 | 30 | 45 | 40 | |
| Benchmarks (no. days) | |||||||
| Average Receivable Collection Period, Competitors2 | |||||||
| Procter & Gamble Co. | 24 | 23 | 23 | — | — | — | |
| Average Receivable Collection Period, Industry | |||||||
| Consumer Staples | 11 | 12 | 10 | — | — | — | |
Based on: 10-K (reporting date: 2023-06-30), 10-K (reporting date: 2022-06-30), 10-K (reporting date: 2021-06-30), 10-K (reporting date: 2020-06-30), 10-K (reporting date: 2019-06-30), 10-K (reporting date: 2018-06-30).
1 2023 Calculation
Average receivable collection period = 365 ÷ Receivables turnover
= 365 ÷ 10.96 = 33
2 Click competitor name to see calculations.
The analysis of short-term activity ratios between 2018 and 2023 reveals a fluctuating but overall improving efficiency in the management of accounts receivable. The data indicates a strong inverse correlation between the receivables turnover ratio and the average collection period, as expected in standard financial modeling.
- Receivables Turnover Analysis
- The receivables turnover ratio experienced significant volatility, starting at 9.20 in 2018 and dipping to its lowest point of 8.12 in 2019. A sharp increase followed in 2020, reaching a period peak of 11.97. After a correction to 9.53 in 2021, the ratio demonstrated a steady recovery, climbing to 10.89 in 2022 and finishing at 10.96 in 2023.
- Average Receivable Collection Period Trends
- The collection period mirrored the turnover fluctuations, peaking at 45 days in 2019, which represented the lowest point of collection efficiency. This was followed by a substantial improvement in 2020, where the collection period dropped to its minimum of 30 days. Despite a temporary increase to 38 days in 2021, a consistent downward trend was observed over the final two years, with the period reducing to 34 days in 2022 and 33 days in 2023.
- Operational Efficiency Insights
- Comparing the baseline of 2018 to the results of 2023, the average collection period decreased from 40 days to 33 days. This trend suggests a general optimization of credit and collection policies over the six-year period. The stabilization of the turnover ratio above 10.0 and the reduction of the collection period to 33 days indicate an enhanced ability to convert receivables into cash more rapidly than in the 2018-2019 period.
AI Ask an analyst for more
Hi, I’m an AI-powered financial analyst at Stock Analysis on Net.
How can I help you?
Operating Cycle
| Jun 30, 2023 | Jun 30, 2022 | Jun 30, 2021 | Jun 30, 2020 | Jun 30, 2019 | Jun 30, 2018 | ||
|---|---|---|---|---|---|---|---|
| Selected Financial Data | |||||||
| Average inventory processing period | 238 | 248 | 238 | 212 | 216 | 208 | |
| Average receivable collection period | 33 | 34 | 38 | 30 | 45 | 40 | |
| Short-term Activity Ratio | |||||||
| Operating cycle1 | 271 | 282 | 276 | 242 | 261 | 248 | |
| Benchmarks | |||||||
| Operating Cycle, Competitors2 | |||||||
| Procter & Gamble Co. | 84 | 83 | 82 | — | — | — | |
| Operating Cycle, Industry | |||||||
| Consumer Staples | 59 | 64 | 55 | — | — | — | |
Based on: 10-K (reporting date: 2023-06-30), 10-K (reporting date: 2022-06-30), 10-K (reporting date: 2021-06-30), 10-K (reporting date: 2020-06-30), 10-K (reporting date: 2019-06-30), 10-K (reporting date: 2018-06-30).
1 2023 Calculation
Operating cycle = Average inventory processing period + Average receivable collection period
= 238 + 33 = 271
2 Click competitor name to see calculations.
The analysis of the operating cycle from June 30, 2018, to June 30, 2023, reveals a general expansion in the time required to convert resources into cash, primarily driven by an increase in inventory holding durations.
- Average Inventory Processing Period
- A general upward trend is observed in the inventory processing period, which rose from 208 days in 2018 to a peak of 248 days in 2022. Although a slight reduction to 238 days occurred in 2023, the period remains elevated compared to the 2018-2020 baseline. This expansion indicates that a larger proportion of the operating cycle is consumed by the time inventory spends in the warehouse before sale.
- Average Receivable Collection Period
- The collection period exhibits relative stability with minor fluctuations. After reaching a peak of 45 days in 2019, the period trended downward, ending at 33 days in 2023. This suggests that the efficiency of converting accounts receivable into cash has remained consistent or slightly improved, offsetting some of the delays seen in inventory movement.
- Operating Cycle
- The overall operating cycle mirrors the movements of the inventory processing period. The cycle extended from 248 days in 2018 to a maximum of 282 days in 2022, before contracting to 271 days in 2023. The strong correlation between the operating cycle and inventory processing suggests that inventory management is the dominant variable influencing the company's short-term operating liquidity.
AI Ask an analyst for more
Hi, I’m an AI-powered financial analyst at Stock Analysis on Net.
How can I help you?
Average Payables Payment Period
| Jun 30, 2023 | Jun 30, 2022 | Jun 30, 2021 | Jun 30, 2020 | Jun 30, 2019 | Jun 30, 2018 | ||
|---|---|---|---|---|---|---|---|
| Selected Financial Data | |||||||
| Payables turnover | 2.73 | 2.36 | 2.27 | 3.02 | 2.27 | 2.41 | |
| Short-term Activity Ratio (no. days) | |||||||
| Average payables payment period1 | 134 | 154 | 161 | 121 | 161 | 152 | |
| Benchmarks (no. days) | |||||||
| Average Payables Payment Period, Competitors2 | |||||||
| Procter & Gamble Co. | 125 | 129 | 135 | — | — | — | |
| Average Payables Payment Period, Industry | |||||||
| Consumer Staples | 52 | 57 | 55 | — | — | — | |
Based on: 10-K (reporting date: 2023-06-30), 10-K (reporting date: 2022-06-30), 10-K (reporting date: 2021-06-30), 10-K (reporting date: 2020-06-30), 10-K (reporting date: 2019-06-30), 10-K (reporting date: 2018-06-30).
1 2023 Calculation
Average payables payment period = 365 ÷ Payables turnover
= 365 ÷ 2.73 = 134
2 Click competitor name to see calculations.
The analysis of short-term operating activity reveals a fluctuating pattern in the management of accounts payable between 2018 and 2023. The metrics indicate significant variability in the timing of supplier payments rather than a consistent linear trend.
- Payables Turnover
- The payables turnover ratio exhibited volatility over the analyzed period, starting at 2.41 in 2018 and reaching a peak of 3.02 in 2020. After this peak, the ratio declined to 2.27 in 2021, followed by a steady increase to 2.36 in 2022 and 2.73 in 2023. This movement suggests periodic adjustments in the frequency with which supplier obligations are settled.
- Average Payables Payment Period
- The payment period demonstrates a clear inverse correlation with the turnover ratio. The period extended from 152 days in 2018 to a maximum of 161 days in both 2019 and 2021. A significant contraction was observed in 2020, when the payment period dropped to its lowest point of 121 days. Between 2021 and 2023, a downward trend is evident, with the payment period decreasing from 161 days to 134 days, indicating a shift toward more rapid settlement of liabilities to vendors in the most recent periods.
AI Ask an analyst for more
Hi, I’m an AI-powered financial analyst at Stock Analysis on Net.
How can I help you?
Cash Conversion Cycle
| Jun 30, 2023 | Jun 30, 2022 | Jun 30, 2021 | Jun 30, 2020 | Jun 30, 2019 | Jun 30, 2018 | ||
|---|---|---|---|---|---|---|---|
| Selected Financial Data | |||||||
| Average inventory processing period | 238 | 248 | 238 | 212 | 216 | 208 | |
| Average receivable collection period | 33 | 34 | 38 | 30 | 45 | 40 | |
| Average payables payment period | 134 | 154 | 161 | 121 | 161 | 152 | |
| Short-term Activity Ratio | |||||||
| Cash conversion cycle1 | 137 | 128 | 115 | 121 | 100 | 96 | |
| Benchmarks | |||||||
| Cash Conversion Cycle, Competitors2 | |||||||
| Procter & Gamble Co. | -41 | -46 | -53 | — | — | — | |
| Cash Conversion Cycle, Industry | |||||||
| Consumer Staples | 7 | 7 | 0 | — | — | — | |
Based on: 10-K (reporting date: 2023-06-30), 10-K (reporting date: 2022-06-30), 10-K (reporting date: 2021-06-30), 10-K (reporting date: 2020-06-30), 10-K (reporting date: 2019-06-30), 10-K (reporting date: 2018-06-30).
1 2023 Calculation
Cash conversion cycle = Average inventory processing period + Average receivable collection period – Average payables payment period
= 238 + 33 – 134 = 137
2 Click competitor name to see calculations.
The cash conversion cycle has demonstrated a consistent upward trend, extending from 96 days in 2018 to 137 days in 2023. This expansion indicates that capital is tied up in operating activities for longer durations, reflecting a decrease in the overall efficiency of the working capital cycle over the analyzed period.
- Average Inventory Processing Period
- A general increase is observed in the time required to process inventory, rising from 208 days in 2018 to a peak of 248 days in 2022, before settling at 238 days in 2023. This upward trajectory suggests a slowdown in inventory turnover, which serves as the primary driver for the overall extension of the cash conversion cycle.
- Average Receivable Collection Period
- Receivable collection remains the most stable component of the operating cycle. While values fluctuated between a high of 45 days in 2019 and a low of 30 days in 2020, the period ended at 33 days in 2023. This stability indicates consistent efficiency in converting credit sales into cash.
- Average Payables Payment Period
- The duration for settling obligations to suppliers has exhibited significant volatility. Following a period of fluctuation between 121 and 161 days from 2018 to 2021, a downward trend occurred in the final two years, reaching 134 days by 2023. The contraction of this period suggests a reduced reliance on supplier financing, which further contributes to the lengthening of the total cash conversion cycle.
AI Ask an analyst for more
Hi, I’m an AI-powered financial analyst at Stock Analysis on Net.
How can I help you?