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)
Based on: 10-K (reporting date: 2024-06-29), 10-K (reporting date: 2023-07-01), 10-K (reporting date: 2022-07-02), 10-K (reporting date: 2021-07-03), 10-K (reporting date: 2020-06-27), 10-K (reporting date: 2019-06-29).
An analysis of short-term operating activity indicates a high level of stability in the overall cash conversion process, despite fluctuations in individual operational components between 2019 and 2024. While specific turnover ratios experienced volatility—particularly around 2021—the company has consistently maintained a tight cash conversion cycle, suggesting an effective balance between inventory management, receivable collections, and payable obligations.
- Inventory and Operating Cycle Management
- Inventory turnover showed a decline from 15.14 in 2019 to a low of 11.35 in 2021, which corresponded with an increase in the average inventory processing period from 24 to 32 days. However, efficiency recovered in subsequent years, with the turnover ratio returning to 13.73 by 2024 and the processing period stabilizing at 27 days. This fluctuation contributed to a peak in the operating cycle of 59 days in 2021, which has since contracted to 52 days.
- Receivables Collection Efficiency
- The receivables turnover and collection period remained remarkably consistent over the six-year period. The average receivable collection period fluctuated minimally between 20 and 27 days, ending at 25 days in 2024. This stability indicates a disciplined credit policy and a predictable stream of cash inflows from customers.
- Payables and Cash Conversion Cycle
- The average payables payment period saw a significant extension in 2021, reaching 43 days from a baseline of 32 days in 2019. This extension in payment terms mirrored the slowdown in inventory turnover, effectively offsetting the longer operating cycle. As a result, the cash conversion cycle remained nearly constant, oscillating between 15 and 18 days, ending at 16 days in 2024. This suggests that the company successfully used its payables to finance the temporary increase in operating cycle length.
- Working Capital Productivity
- A substantial upward trend is observed in working capital turnover, which rose from 29.49 in 2019 to 43.75 in 2024, despite a sharp temporary dip to 9.39 in 2020. This trajectory indicates a significant increase in the efficiency with which the company utilizes its net current assets and liabilities to generate sales volume.
AI Ask an analyst for more
Turnover Ratios
Average No. Days
Inventory Turnover
| Jun 29, 2024 | Jul 1, 2023 | Jul 2, 2022 | Jul 3, 2021 | Jun 27, 2020 | Jun 29, 2019 | ||
|---|---|---|---|---|---|---|---|
| Selected Financial Data (US$ in millions) | |||||||
| Cost of sales | 64,236) | 62,370) | 56,316) | 41,941) | 42,992) | 48,705) | |
| Inventories | 4,678) | 4,481) | 4,437) | 3,695) | 3,095) | 3,216) | |
| Short-term Activity Ratio | |||||||
| Inventory turnover1 | 13.73 | 13.92 | 12.69 | 11.35 | 13.89 | 15.14 | |
| Benchmarks | |||||||
| Inventory Turnover, Competitors2 | |||||||
| Costco Wholesale Corp. | 11.92 | 12.77 | 11.13 | 12.01 | 11.84 | — | |
| Target Corp. | 6.55 | 6.10 | 5.39 | 6.21 | — | — | |
| Walmart Inc. | 8.93 | 8.20 | 7.59 | 9.35 | — | — | |
| Inventory Turnover, Sector | |||||||
| Consumer Staples Distribution & Retail | 9.25 | 8.75 | 7.96 | 9.41 | — | — | |
| Inventory Turnover, Industry | |||||||
| Consumer Staples | 8.01 | 7.60 | 7.08 | 8.15 | — | — | |
Based on: 10-K (reporting date: 2024-06-29), 10-K (reporting date: 2023-07-01), 10-K (reporting date: 2022-07-02), 10-K (reporting date: 2021-07-03), 10-K (reporting date: 2020-06-27), 10-K (reporting date: 2019-06-29).
1 2024 Calculation
Inventory turnover = Cost of sales ÷ Inventories
= 64,236 ÷ 4,678 = 13.73
2 Click competitor name to see calculations.
An analysis of the operational activity ratios indicates a period of volatility between 2019 and 2021, followed by a phase of recovery and stabilization from 2022 through 2024. The fluctuations in the inventory turnover ratio reflect the evolving relationship between cost of sales and inventory accumulation.
- Cost of Sales Trends
- Cost of sales experienced a contraction from 2019 to 2021, declining from US$ 48,705 million to a low of US$ 41,941 million. Following this period, a significant upward trend was observed, with cost of sales increasing steadily to reach US$ 64,236 million by June 29, 2024, indicating a substantial increase in business volume or input costs.
- Inventory Level Progression
- Inventories remained relatively stable between 2019 and 2020 before entering a consistent growth trajectory. From a low of US$ 3,095 million in 2020, inventory levels rose to US$ 4,678 million by 2024. This upward trend suggests a strategic increase in stock holdings or an adjustment to supply chain requirements to support higher sales volumes.
- Inventory Turnover Analysis
- The inventory turnover ratio declined from 15.14 in 2019 to a minimum of 11.35 in 2021, signaling a period of decreased operational efficiency in moving stock. A recovery began in 2022, with the ratio climbing back to 13.92 by 2023. The most recent figure of 13.73 in 2024 suggests that the turnover rate has stabilized, balancing the increase in cost of sales against the growth in total inventory assets.
AI Ask an analyst for more
Receivables Turnover
| Jun 29, 2024 | Jul 1, 2023 | Jul 2, 2022 | Jul 3, 2021 | Jun 27, 2020 | Jun 29, 2019 | ||
|---|---|---|---|---|---|---|---|
| Selected Financial Data (US$ in millions) | |||||||
| Sales | 78,844) | 76,325) | 68,636) | 51,298) | 52,893) | 60,114) | |
| Accounts receivable, less allowances | 5,324) | 5,092) | 4,839) | 3,782) | 2,894) | 4,182) | |
| Short-term Activity Ratio | |||||||
| Receivables turnover1 | 14.81 | 14.99 | 14.18 | 13.57 | 18.28 | 14.38 | |
| Benchmarks | |||||||
| Receivables Turnover, Competitors2 | |||||||
| Costco Wholesale Corp. | 91.74 | 104.03 | 99.39 | 106.52 | 105.30 | — | |
| Target Corp. | 120.55 | 93.34 | 126.95 | 148.27 | — | — | |
| Walmart Inc. | 73.06 | 76.37 | 68.57 | 85.21 | — | — | |
| Receivables Turnover, Sector | |||||||
| Consumer Staples Distribution & Retail | 80.57 | 83.67 | 78.94 | 93.95 | — | — | |
| Receivables Turnover, Industry | |||||||
| Consumer Staples | 32.35 | 32.56 | 31.53 | 34.96 | — | — | |
Based on: 10-K (reporting date: 2024-06-29), 10-K (reporting date: 2023-07-01), 10-K (reporting date: 2022-07-02), 10-K (reporting date: 2021-07-03), 10-K (reporting date: 2020-06-27), 10-K (reporting date: 2019-06-29).
1 2024 Calculation
Receivables turnover = Sales ÷ Accounts receivable, less allowances
= 78,844 ÷ 5,324 = 14.81
2 Click competitor name to see calculations.
An analysis of operating activity reveals a period of initial volatility followed by sustained growth in both top-line revenue and accounts receivable balances between 2019 and 2024. Sales experienced a contraction through 2021 before entering a consistent upward trajectory, increasing from 51,298 million in 2021 to 78,844 million by June 2024.
- Receivables Turnover Volatility (2019-2021)
- A notable peak in the receivables turnover ratio occurred in 2020, reaching 18.28. This spike coincided with a decrease in sales and a significant reduction in accounts receivable to 2,894 million, indicating a period of accelerated collection or more restrictive credit terms. This peak was short-lived, as the ratio declined to 13.57 in 2021, driven by a rise in outstanding receivables despite stagnant sales.
- Operational Scaling and Stabilization (2022-2024)
- From 2022 through 2024, the turnover ratio stabilized, fluctuating within a narrow range between 14.18 and 14.99. During this period, sales grew substantially, and accounts receivable increased to 5,324 million. The consistency of the turnover ratio during this expansion suggests that credit management efficiency has scaled proportionally with the increase in business volume.
- Long-term Asset Management Trend
- The overall trend demonstrates a return to operational stability. The final recorded ratio of 14.81 in 2024 is closely aligned with the 2019 level of 14.38, suggesting that the organization has maintained a disciplined approach to receivables management despite the significant increase in the absolute volume of credit extended to customers.
AI Ask an analyst for more
Payables Turnover
| Jun 29, 2024 | Jul 1, 2023 | Jul 2, 2022 | Jul 3, 2021 | Jun 27, 2020 | Jun 29, 2019 | ||
|---|---|---|---|---|---|---|---|
| Selected Financial Data (US$ in millions) | |||||||
| Cost of sales | 64,236) | 62,370) | 56,316) | 41,941) | 42,992) | 48,705) | |
| Accounts payable | 6,290) | 6,026) | 5,753) | 4,885) | 3,447) | 4,315) | |
| Short-term Activity Ratio | |||||||
| Payables turnover1 | 10.21 | 10.35 | 9.79 | 8.59 | 12.47 | 11.29 | |
| Benchmarks | |||||||
| Payables Turnover, Competitors2 | |||||||
| Costco Wholesale Corp. | 11.45 | 12.16 | 11.17 | 10.49 | 10.23 | — | |
| Target Corp. | 6.43 | 6.10 | 4.84 | 5.15 | — | — | |
| Walmart Inc. | 8.63 | 8.63 | 7.76 | 8.55 | — | — | |
| Payables Turnover, Sector | |||||||
| Consumer Staples Distribution & Retail | 8.95 | 8.96 | 7.94 | 8.40 | — | — | |
| Payables Turnover, Industry | |||||||
| Consumer Staples | 6.94 | 6.95 | 6.37 | 6.65 | — | — | |
Based on: 10-K (reporting date: 2024-06-29), 10-K (reporting date: 2023-07-01), 10-K (reporting date: 2022-07-02), 10-K (reporting date: 2021-07-03), 10-K (reporting date: 2020-06-27), 10-K (reporting date: 2019-06-29).
1 2024 Calculation
Payables turnover = Cost of sales ÷ Accounts payable
= 64,236 ÷ 6,290 = 10.21
2 Click competitor name to see calculations.
The analysis of short-term operating activity reveals a period of volatility in payables management followed by a phase of stabilization between 2019 and 2024.
- Cost of Sales and Accounts Payable Trends
- Cost of sales experienced a decline from 2019 to 2021, reaching a low of 41,941 million US dollars, before entering a sustained growth trajectory that peaked at 64,236 million US dollars in 2024. Concurrently, accounts payable decreased in 2020 but grew consistently thereafter, increasing from 3,447 million US dollars in 2020 to 6,290 million US dollars in 2024.
- Payables Turnover Volatility
- The payables turnover ratio demonstrated significant fluctuations during the observed period. An initial increase to 12.47 in 2020 was followed by a sharp contraction to 8.59 in 2021, marking the lowest turnover rate within the period. This contraction indicates a slower rate of payment to suppliers relative to the cost of goods sold, suggesting an increase in the average payment period during that fiscal year.
- Operational Stabilization
- Following the 2021 low, the turnover ratio showed a recovery trend, rising to 9.79 in 2022 and 10.35 in 2023, before stabilizing at 10.21 in 2024. This trajectory suggests a normalization of credit management and payment cycles as operational costs and supplier obligations scaled upward in the post-2021 period.
AI Ask an analyst for more
Working Capital Turnover
| Jun 29, 2024 | Jul 1, 2023 | Jul 2, 2022 | Jul 3, 2021 | Jun 27, 2020 | Jun 29, 2019 | ||
|---|---|---|---|---|---|---|---|
| Selected Financial Data (US$ in millions) | |||||||
| Current assets | 11,043) | 10,608) | 10,483) | 10,734) | 12,348) | 8,142) | |
| Less: Current liabilities | 9,241) | 8,540) | 8,750) | 7,320) | 6,718) | 6,103) | |
| Working capital | 1,802) | 2,068) | 1,733) | 3,414) | 5,630) | 2,038) | |
| Sales | 78,844) | 76,325) | 68,636) | 51,298) | 52,893) | 60,114) | |
| Short-term Activity Ratio | |||||||
| Working capital turnover1 | 43.75 | 36.91 | 39.60 | 15.03 | 9.39 | 29.49 | |
| Benchmarks | |||||||
| Working Capital Turnover, Competitors2 | |||||||
| Costco Wholesale Corp. | — | 103.53 | 319.10 | 3,000.81 | 49.82 | — | |
| Target Corp. | — | — | — | 148.27 | — | — | |
| Walmart Inc. | — | — | — | — | — | — | |
| Working Capital Turnover, Sector | |||||||
| Consumer Staples Distribution & Retail | — | — | — | — | — | — | |
| Working Capital Turnover, Industry | |||||||
| Consumer Staples | — | — | — | — | — | — | |
Based on: 10-K (reporting date: 2024-06-29), 10-K (reporting date: 2023-07-01), 10-K (reporting date: 2022-07-02), 10-K (reporting date: 2021-07-03), 10-K (reporting date: 2020-06-27), 10-K (reporting date: 2019-06-29).
1 2024 Calculation
Working capital turnover = Sales ÷ Working capital
= 78,844 ÷ 1,802 = 43.75
2 Click competitor name to see calculations.
The financial performance from 2019 to 2024 reveals a period of significant volatility followed by a phase of aggressive operational efficiency and revenue growth. A notable fluctuation in working capital coincided with a temporary dip in sales, leading to a sharp contraction in turnover efficiency that has since been reversed and improved upon.
- Working Capital Trends
- Working capital experienced a substantial surge in 2020, peaking at 5,630 million USD, which represented more than a twofold increase from the 2,038 million USD reported in 2019. Following this peak, a consistent downward trend was observed through 2022, where levels fell to 1,733 million USD. The most recent periods show stabilization, with working capital maintaining a range between 1,802 million and 2,068 million USD.
- Sales Performance
- Revenue exhibited a contraction between 2019 and 2021, falling from 60,114 million USD to a low of 51,298 million USD. However, a strong recovery phase began in 2022, with sales climbing to 68,636 million USD and continuing an upward trajectory to reach 78,844 million USD by June 2024. This indicates a sustained growth period in top-line revenue over the last three fiscal years.
- Working Capital Turnover Efficiency
- The working capital turnover ratio reflects the combined impact of the fluctuations in liquidity and sales. The ratio dropped precipitously from 29.49 in 2019 to 9.39 in 2020, driven by the simultaneous increase in working capital and decrease in sales. A recovery began in 2021, followed by a sharp increase to 39.60 in 2022. The ratio reached its highest point in 2024 at 43.75, signifying a high level of efficiency in utilizing short-term assets and liabilities to generate sales.
The overall trend indicates that after a period of liquidity buildup and revenue decline, the organization has successfully optimized its operating cycle. The current trajectory shows a leaner working capital base supporting significantly higher sales volumes, resulting in superior capital turnover compared to the 2019 baseline.
AI Ask an analyst for more
Average Inventory Processing Period
| Jun 29, 2024 | Jul 1, 2023 | Jul 2, 2022 | Jul 3, 2021 | Jun 27, 2020 | Jun 29, 2019 | ||
|---|---|---|---|---|---|---|---|
| Selected Financial Data | |||||||
| Inventory turnover | 13.73 | 13.92 | 12.69 | 11.35 | 13.89 | 15.14 | |
| Short-term Activity Ratio (no. days) | |||||||
| Average inventory processing period1 | 27 | 26 | 29 | 32 | 26 | 24 | |
| Benchmarks (no. days) | |||||||
| Average Inventory Processing Period, Competitors2 | |||||||
| Costco Wholesale Corp. | 31 | 29 | 33 | 30 | 31 | — | |
| Target Corp. | 56 | 60 | 68 | 59 | — | — | |
| Walmart Inc. | 41 | 45 | 48 | 39 | — | — | |
| Average Inventory Processing Period, Sector | |||||||
| Consumer Staples Distribution & Retail | 39 | 42 | 46 | 39 | — | — | |
| Average Inventory Processing Period, Industry | |||||||
| Consumer Staples | 46 | 48 | 52 | 45 | — | — | |
Based on: 10-K (reporting date: 2024-06-29), 10-K (reporting date: 2023-07-01), 10-K (reporting date: 2022-07-02), 10-K (reporting date: 2021-07-03), 10-K (reporting date: 2020-06-27), 10-K (reporting date: 2019-06-29).
1 2024 Calculation
Average inventory processing period = 365 ÷ Inventory turnover
= 365 ÷ 13.73 = 27
2 Click competitor name to see calculations.
Analysis of short-term operating activity reveals a cyclical pattern in inventory management over the six-year period from 2019 to 2024. A notable decline in inventory efficiency occurred between 2019 and 2021, followed by a recovery and stabilization phase through 2024.
- Inventory Turnover
- The turnover ratio experienced a steady decline from a peak of 15.14 in 2019 to a minimum of 11.35 in 2021. This downward movement indicates a reduction in the frequency with which inventory was sold and replaced during this period. Beginning in 2022, a corrective trend emerged, with the ratio increasing to 13.92 in 2023 before stabilizing at 13.73 in 2024.
- Average Inventory Processing Period
- The time required to process inventory moved in inverse correlation with the turnover ratio. The processing period extended from 24 days in 2019 to a peak of 32 days in 2021, representing the point of lowest operational velocity. Subsequently, the period shortened to 26 days by 2023 and remained relatively stable at 27 days in 2024.
- Operational Efficiency Correlation
- The synchronicity between the turnover ratio and the processing period highlights a significant operational shift peaking in 2021. The eight-day increase in the processing period relative to 2019 levels suggests temporary inefficiencies or strategic inventory accumulation. The subsequent return to a processing period of 27 days indicates a restoration of operational throughput and a return toward baseline efficiency levels.
AI Ask an analyst for more
Average Receivable Collection Period
| Jun 29, 2024 | Jul 1, 2023 | Jul 2, 2022 | Jul 3, 2021 | Jun 27, 2020 | Jun 29, 2019 | ||
|---|---|---|---|---|---|---|---|
| Selected Financial Data | |||||||
| Receivables turnover | 14.81 | 14.99 | 14.18 | 13.57 | 18.28 | 14.38 | |
| Short-term Activity Ratio (no. days) | |||||||
| Average receivable collection period1 | 25 | 24 | 26 | 27 | 20 | 25 | |
| Benchmarks (no. days) | |||||||
| Average Receivable Collection Period, Competitors2 | |||||||
| Costco Wholesale Corp. | 4 | 4 | 4 | 3 | 3 | — | |
| Target Corp. | 3 | 4 | 3 | 2 | — | — | |
| Walmart Inc. | 5 | 5 | 5 | 4 | — | — | |
| Average Receivable Collection Period, Sector | |||||||
| Consumer Staples Distribution & Retail | 5 | 4 | 5 | 4 | — | — | |
| Average Receivable Collection Period, Industry | |||||||
| Consumer Staples | 11 | 11 | 12 | 10 | — | — | |
Based on: 10-K (reporting date: 2024-06-29), 10-K (reporting date: 2023-07-01), 10-K (reporting date: 2022-07-02), 10-K (reporting date: 2021-07-03), 10-K (reporting date: 2020-06-27), 10-K (reporting date: 2019-06-29).
1 2024 Calculation
Average receivable collection period = 365 ÷ Receivables turnover
= 365 ÷ 14.81 = 25
2 Click competitor name to see calculations.
The analysis of short-term operating activity reveals a consistent pattern of efficiency in the management of receivables over the six-year period ending June 29, 2024. The metrics indicate a high level of stability, with a period of volatility between 2020 and 2021 followed by a return to baseline operational levels.
- Receivables Turnover
- A peak in turnover was observed in June 2020, reaching 18.28, indicating the most efficient conversion of receivables into cash during the period analyzed. This was followed by a contraction to 13.57 in July 2021. Since 2021, the ratio has demonstrated a gradual recovery and stabilization, fluctuating between 14.18 and 14.99, and ending at 14.81 in June 2024.
- Average Receivable Collection Period
- The collection period mirrored the turnover trends inversely, dropping to a low of 20 days in June 2020. A subsequent increase to 27 days in July 2021 represented the longest collection cycle in the analyzed timeframe. Over the following three years, the collection period trended downward from 26 days in 2022 to 24 days in 2023, ultimately settling at 25 days in June 2024.
- Operational Trend Synthesis
- The overall trend suggests a return to a normalized operating cycle. Following the fluctuations experienced between 2020 and 2021, the collection period has converged back to the 25-day mark observed in 2019. This indicates a sustainable and predictable credit collection process with minimal long-term variance in credit risk or customer payment behavior.
AI Ask an analyst for more
Operating Cycle
| Jun 29, 2024 | Jul 1, 2023 | Jul 2, 2022 | Jul 3, 2021 | Jun 27, 2020 | Jun 29, 2019 | ||
|---|---|---|---|---|---|---|---|
| Selected Financial Data | |||||||
| Average inventory processing period | 27 | 26 | 29 | 32 | 26 | 24 | |
| Average receivable collection period | 25 | 24 | 26 | 27 | 20 | 25 | |
| Short-term Activity Ratio | |||||||
| Operating cycle1 | 52 | 50 | 55 | 59 | 46 | 49 | |
| Benchmarks | |||||||
| Operating Cycle, Competitors2 | |||||||
| Costco Wholesale Corp. | 35 | 33 | 37 | 33 | 34 | — | |
| Target Corp. | 59 | 64 | 71 | 61 | — | — | |
| Walmart Inc. | 46 | 50 | 53 | 43 | — | — | |
| Operating Cycle, Sector | |||||||
| Consumer Staples Distribution & Retail | 44 | 46 | 51 | 43 | — | — | |
| Operating Cycle, Industry | |||||||
| Consumer Staples | 57 | 59 | 64 | 55 | — | — | |
Based on: 10-K (reporting date: 2024-06-29), 10-K (reporting date: 2023-07-01), 10-K (reporting date: 2022-07-02), 10-K (reporting date: 2021-07-03), 10-K (reporting date: 2020-06-27), 10-K (reporting date: 2019-06-29).
1 2024 Calculation
Operating cycle = Average inventory processing period + Average receivable collection period
= 27 + 25 = 52
2 Click competitor name to see calculations.
The operating cycle exhibits a period of relative stability characterized by a distinct disruption during the 2021 fiscal year. After a slight contraction in 2020, the cycle experienced a significant expansion before trending back toward historical norms over the subsequent three years.
- Average Inventory Processing Period
- Inventory turnover efficiency demonstrated a gradual decline, peaking in July 2021 at 32 days compared to 24 days in June 2019. Following this peak, a correction trend is observed, with the period contracting to 26 days in 2023 and settling at 27 days in 2024, suggesting a return to standardized inventory management levels.
- Average Receivable Collection Period
- The collection of receivables remained consistently within a narrow range of 20 to 27 days. A notable dip to 20 days occurred in 2020, followed by a peak of 27 days in 2021. The period has since stabilized, ending at 25 days in 2024, indicating a consistent ability to convert receivables into cash.
- Operating Cycle
- The overall operating cycle reflects the combined impact of inventory and receivable fluctuations. The duration expanded from 49 days in 2019 to a maximum of 59 days in 2021. This increase represents the most significant deviation in operational liquidity during the analyzed period. By June 2024, the cycle moderated to 52 days, aligning closely with the baseline observed at the start of the period.
AI Ask an analyst for more
Average Payables Payment Period
| Jun 29, 2024 | Jul 1, 2023 | Jul 2, 2022 | Jul 3, 2021 | Jun 27, 2020 | Jun 29, 2019 | ||
|---|---|---|---|---|---|---|---|
| Selected Financial Data | |||||||
| Payables turnover | 10.21 | 10.35 | 9.79 | 8.59 | 12.47 | 11.29 | |
| Short-term Activity Ratio (no. days) | |||||||
| Average payables payment period1 | 36 | 35 | 37 | 43 | 29 | 32 | |
| Benchmarks (no. days) | |||||||
| Average Payables Payment Period, Competitors2 | |||||||
| Costco Wholesale Corp. | 32 | 30 | 33 | 35 | 36 | — | |
| Target Corp. | 57 | 60 | 75 | 71 | — | — | |
| Walmart Inc. | 42 | 42 | 47 | 43 | — | — | |
| Average Payables Payment Period, Sector | |||||||
| Consumer Staples Distribution & Retail | 41 | 41 | 46 | 43 | — | — | |
| Average Payables Payment Period, Industry | |||||||
| Consumer Staples | 53 | 52 | 57 | 55 | — | — | |
Based on: 10-K (reporting date: 2024-06-29), 10-K (reporting date: 2023-07-01), 10-K (reporting date: 2022-07-02), 10-K (reporting date: 2021-07-03), 10-K (reporting date: 2020-06-27), 10-K (reporting date: 2019-06-29).
1 2024 Calculation
Average payables payment period = 365 ÷ Payables turnover
= 365 ÷ 10.21 = 36
2 Click competitor name to see calculations.
The management of short-term obligations demonstrates a period of significant volatility followed by a phase of normalization. Between 2019 and 2024, there were notable fluctuations in the efficiency of payables settlement, characterized by a sharp extension of the payment cycle in 2021 and a subsequent return toward baseline levels.
- Payables Turnover
- A peak in turnover was observed in 2020 at 12.47, following an initial value of 11.29 in 2019, indicating an acceleration in the payment of supplier obligations. This trend reversed sharply in 2021, with the ratio dropping to a period low of 8.59. In the following three years, a consistent recovery trend is evident, as the ratio climbed to 9.79 in 2022, 10.35 in 2023, and settled at 10.21 by June 2024.
- Average Payables Payment Period
- The payment duration decreased from 32 days in 2019 to 29 days in 2020. A significant spike occurred in 2021, where the period extended to 43 days, representing a substantial increase in the time taken to settle liabilities. This extension was followed by a gradual reduction to 37 days in 2022 and 35 days in 2023, concluding with a stable figure of 36 days in 2024. This suggests a strategic extension of credit terms in 2021, followed by a transition back to a standardized operating cycle.
AI Ask an analyst for more
Cash Conversion Cycle
| Jun 29, 2024 | Jul 1, 2023 | Jul 2, 2022 | Jul 3, 2021 | Jun 27, 2020 | Jun 29, 2019 | ||
|---|---|---|---|---|---|---|---|
| Selected Financial Data | |||||||
| Average inventory processing period | 27 | 26 | 29 | 32 | 26 | 24 | |
| Average receivable collection period | 25 | 24 | 26 | 27 | 20 | 25 | |
| Average payables payment period | 36 | 35 | 37 | 43 | 29 | 32 | |
| Short-term Activity Ratio | |||||||
| Cash conversion cycle1 | 16 | 15 | 18 | 16 | 17 | 17 | |
| Benchmarks | |||||||
| Cash Conversion Cycle, Competitors2 | |||||||
| Costco Wholesale Corp. | 3 | 3 | 4 | -2 | -2 | — | |
| Target Corp. | 2 | 4 | -4 | -10 | — | — | |
| Walmart Inc. | 4 | 8 | 6 | 0 | — | — | |
| Cash Conversion Cycle, Sector | |||||||
| Consumer Staples Distribution & Retail | 3 | 5 | 5 | 0 | — | — | |
| Cash Conversion Cycle, Industry | |||||||
| Consumer Staples | 4 | 7 | 7 | 0 | — | — | |
Based on: 10-K (reporting date: 2024-06-29), 10-K (reporting date: 2023-07-01), 10-K (reporting date: 2022-07-02), 10-K (reporting date: 2021-07-03), 10-K (reporting date: 2020-06-27), 10-K (reporting date: 2019-06-29).
1 2024 Calculation
Cash conversion cycle = Average inventory processing period + Average receivable collection period – Average payables payment period
= 27 + 25 – 36 = 16
2 Click competitor name to see calculations.
The cash conversion cycle has demonstrated remarkable stability from 2019 to 2024, fluctuating only slightly between a minimum of 15 days and a maximum of 18 days. This consistency suggests a disciplined approach to working capital management, ensuring that the time elapsed between the outlay of cash for inventory and the receipt of cash from sales remains minimal and predictable.
- Inventory Processing Period
- The period required to process inventory showed an upward trend peaking at 32 days in 2021, before receding and stabilizing at 27 days by 2024. This volatility suggests a period of temporary inventory accumulation or slower throughput mid-cycle, which subsequently returned to near-baseline levels.
- Receivable Collection Period
- Collection times remained relatively constant, fluctuating within a tight range of 20 to 27 days. A brief dip to 20 days occurred in 2020, followed by a peak of 27 days in 2021, before settling at 25 days in 2024, indicating a consistent ability to collect payments from customers.
- Payables Payment Period
- A significant extension in the payment period is observed, particularly in 2021 when it reached a peak of 43 days. While this figure declined in subsequent years, it remained higher than the 2019-2020 levels, closing at 36 days in 2024. This indicates a strategic utilization of supplier credit to maintain liquidity.
- Working Capital Synchronization
- The stability of the overall cash conversion cycle is primarily attributed to the synchronization of operational components. Notably, the simultaneous increase in inventory and receivable days in 2021 was offset by a corresponding surge in the payables payment period, effectively neutralizing the potential negative impact on the net cash cycle.
AI Ask an analyst for more