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: 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), 10-K (reporting date: 2017-06-30).
The analysis of short-term operating activity indicates a general trend of lengthening operational cycles, partially offset by strategic changes in payables management to maintain a stable cash conversion cycle.
- Inventory Management Efficiency
- A decline in inventory turnover is observed, moving from a peak of 6.64 in 2018 to 5.14 by 2022. This corresponds with an increase in the average inventory processing period, which rose from 55 days in 2018 to 71 days in 2022, suggesting a slowing rate of inventory liquidation.
- Receivables and Payables Dynamics
- Receivables turnover has remained relatively stable, fluctuating between 6.23 and 7.39, with the average collection period showing a slight improvement from 59 days in 2017 to 54 days in 2022. Conversely, payables turnover experienced significant volatility, peaking at 9.25 in 2020 before dropping to 6.57 in 2022. The average payables payment period reached a low of 39 days in 2020 but extended to 56 days by 2022, indicating a shift toward longer payment terms with suppliers.
- Working Capital and Operational Cycles
- Working capital turnover exhibits high volatility, with significant contractions observed in 2019 (3.17) and 2022 (2.56), indicating a less efficient use of working capital to generate revenue during those periods. The operating cycle expanded from 110 days in 2018 to 125 days in 2022, driven primarily by the slower inventory processing period.
- Cash Conversion Cycle Analysis
- Despite the expansion of the operating cycle, the cash conversion cycle has remained remarkably consistent, ending at 69 days in 2022, the same level as in 2017. This stability is attributed to the extension of the average payables payment period, which effectively neutralized the delays in inventory turnover and the relative stability of receivable collections.
AI Ask an analyst for more
Hi, I’m an AI-powered financial analyst at Stock Analysis on Net.
Without a user account, I tend to respond rather slowly.
How can I help you?
Inventory Turnover
| Jun 30, 2022 | Jun 30, 2021 | Jun 30, 2020 | Jun 30, 2019 | Jun 30, 2018 | Jun 30, 2017 | ||
|---|---|---|---|---|---|---|---|
| Selected Financial Data (US$ in thousands) | |||||||
| Cost of sales | 11,387,267) | 10,449,680) | 10,286,518) | 10,703,484) | 10,762,841) | 9,188,962) | |
| Inventories | 2,214,553) | 2,090,642) | 1,814,631) | 1,678,132) | 1,621,304) | 1,549,494) | |
| Short-term Activity Ratio | |||||||
| Inventory turnover1 | 5.14 | 5.00 | 5.67 | 6.38 | 6.64 | 5.93 | |
| Benchmarks | |||||||
| Inventory Turnover, Competitors2 | |||||||
| Boeing Co. | 0.81 | 0.75 | — | — | — | — | |
| Caterpillar Inc. | 2.54 | 2.53 | — | — | — | — | |
| Eaton Corp. plc | 4.04 | 4.48 | — | — | — | — | |
| GE Aerospace | 3.19 | 3.40 | — | — | — | — | |
| Honeywell International Inc. | 4.04 | 4.29 | — | — | — | — | |
| Lockheed Martin Corp. | 18.68 | 19.45 | — | — | — | — | |
| RTX Corp. | 5.03 | 5.65 | — | — | — | — | |
| Inventory Turnover, Sector | |||||||
| Capital Goods | 2.28 | 2.28 | — | — | — | — | |
| Inventory Turnover, Industry | |||||||
| Industrials | 4.28 | 4.03 | — | — | — | — | |
Based on: 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), 10-K (reporting date: 2017-06-30).
1 2022 Calculation
Inventory turnover = Cost of sales ÷ Inventories
= 11,387,267 ÷ 2,214,553 = 5.14
2 Click competitor name to see calculations.
Between June 30, 2017, and June 30, 2022, a general decline in inventory efficiency is observed. While the cost of sales exhibited overall growth, a consistent and steeper increase in inventory levels resulted in a downward trend for the inventory turnover ratio following a peak in 2018.
- Inventory Levels
- Inventory holdings experienced uninterrupted growth throughout the analyzed period, rising from US$ 1.55 billion in 2017 to US$ 2.21 billion in 2022. A significant acceleration in accumulation occurred between 2020 and 2021, where inventory increased by approximately 15.3%, contributing to a higher capital commitment in stock.
- Cost of Sales
- The cost of sales showed a general upward trajectory despite a period of volatility between 2018 and 2021. After reaching US$ 10.76 billion in 2018, the figure declined to a low of US$ 10.29 billion in 2020 before climbing to a period high of US$ 11.39 billion in 2022. The growth in cost of sales was insufficient to offset the more aggressive growth in inventory levels.
- Inventory Turnover Ratio
- The inventory turnover ratio peaked at 6.64 in 2018 but entered a sustained decline over the subsequent three years, reaching a minimum of 5.00 in 2021. A marginal recovery to 5.14 was recorded in 2022. This overall decrease suggests a slowing of inventory movement and a potential increase in the duration that goods remain in stock before being sold, reflecting a reduction in operating efficiency regarding asset rotation.
AI Ask an analyst for more
Hi, I’m an AI-powered financial analyst at Stock Analysis on Net.
Without a user account, I tend to respond rather slowly.
How can I help you?
Receivables Turnover
| Jun 30, 2022 | Jun 30, 2021 | Jun 30, 2020 | Jun 30, 2019 | Jun 30, 2018 | Jun 30, 2017 | ||
|---|---|---|---|---|---|---|---|
| Selected Financial Data (US$ in thousands) | |||||||
| Net sales | 15,861,608) | 14,347,640) | 13,695,520) | 14,320,324) | 14,302,392) | 12,029,312) | |
| Trade accounts receivable, net | 2,341,504) | 2,183,594) | 1,854,398) | 2,131,054) | 2,145,517) | 1,930,751) | |
| Short-term Activity Ratio | |||||||
| Receivables turnover1 | 6.77 | 6.57 | 7.39 | 6.72 | 6.67 | 6.23 | |
| Benchmarks | |||||||
| Receivables Turnover, Competitors2 | |||||||
| Boeing Co. | 26.46 | 23.58 | — | — | — | — | |
| Caterpillar Inc. | 6.39 | 5.68 | — | — | — | — | |
| Eaton Corp. plc | 5.09 | 5.95 | — | — | — | — | |
| GE Aerospace | 4.09 | 4.55 | — | — | — | — | |
| Honeywell International Inc. | 4.77 | 5.04 | — | — | — | — | |
| Lockheed Martin Corp. | 26.34 | 34.15 | — | — | — | — | |
| RTX Corp. | 7.36 | 6.66 | — | — | — | — | |
| Receivables Turnover, Sector | |||||||
| Capital Goods | 7.36 | 7.57 | — | — | — | — | |
| Receivables Turnover, Industry | |||||||
| Industrials | 8.17 | 7.76 | — | — | — | — | |
Based on: 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), 10-K (reporting date: 2017-06-30).
1 2022 Calculation
Receivables turnover = Net sales ÷ Trade accounts receivable, net
= 15,861,608 ÷ 2,341,504 = 6.77
2 Click competitor name to see calculations.
The analysis of short-term operating activity between June 30, 2017, and June 30, 2022, indicates a stable and efficient management of receivables relative to net sales growth. While net sales experienced fluctuations, the receivables turnover ratio remained within a consistent range, suggesting a disciplined approach to credit and collection policies.
- Net Sales Trends
- Net sales demonstrated a general upward trend, increasing from 12.03 billion US dollars in 2017 to 15.86 billion US dollars by 2022. A temporary contraction was observed on June 30, 2020, when sales decreased to 13.70 billion US dollars, followed by a strong recovery in the subsequent two fiscal years.
- Trade Accounts Receivable Movement
- Net trade accounts receivable largely correlated with sales volume. Balances rose from 1.93 billion US dollars in 2017 to a peak of 2.34 billion US dollars in 2022. A notable decrease in receivables was recorded in 2020, falling to 1.85 billion US dollars, which mirrored the decline in net sales for that period.
- Receivables Turnover Efficiency
- The receivables turnover ratio exhibited a steady performance, beginning at 6.23 in 2017 and ending at 6.77 in 2022. The highest level of efficiency was recorded on June 30, 2020, with a ratio of 7.39, indicating that receivables were collected more rapidly relative to sales during the period of sales contraction. A slight decline to 6.57 occurred in 2021 before the ratio recovered to 6.77 in 2022.
Overall, the data reflects a resilient operational cycle. The ability to maintain a turnover ratio above 6.0 throughout the six-year period suggests that the conversion of credit sales into cash has remained consistent, despite significant fluctuations in total revenue and external economic pressures observed in 2020.
AI Ask an analyst for more
Hi, I’m an AI-powered financial analyst at Stock Analysis on Net.
Without a user account, I tend to respond rather slowly.
How can I help you?
Payables Turnover
| Jun 30, 2022 | Jun 30, 2021 | Jun 30, 2020 | Jun 30, 2019 | Jun 30, 2018 | Jun 30, 2017 | ||
|---|---|---|---|---|---|---|---|
| Selected Financial Data (US$ in thousands) | |||||||
| Cost of sales | 11,387,267) | 10,449,680) | 10,286,518) | 10,703,484) | 10,762,841) | 9,188,962) | |
| Accounts payable, trade | 1,731,925) | 1,667,878) | 1,111,759) | 1,413,155) | 1,430,306) | 1,300,496) | |
| Short-term Activity Ratio | |||||||
| Payables turnover1 | 6.57 | 6.27 | 9.25 | 7.57 | 7.52 | 7.07 | |
| Benchmarks | |||||||
| Payables Turnover, Competitors2 | |||||||
| Boeing Co. | 6.18 | 6.40 | — | — | — | — | |
| Caterpillar Inc. | 4.76 | 4.36 | — | — | — | — | |
| Eaton Corp. plc | 4.51 | 4.75 | — | — | — | — | |
| GE Aerospace | 2.98 | 3.32 | — | — | — | — | |
| Honeywell International Inc. | 3.53 | 3.40 | — | — | — | — | |
| Lockheed Martin Corp. | 27.25 | 74.34 | — | — | — | — | |
| RTX Corp. | 5.40 | 5.93 | — | — | — | — | |
| Payables Turnover, Sector | |||||||
| Capital Goods | 5.21 | 5.60 | — | — | — | — | |
| Payables Turnover, Industry | |||||||
| Industrials | 7.83 | 7.81 | — | — | — | — | |
Based on: 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), 10-K (reporting date: 2017-06-30).
1 2022 Calculation
Payables turnover = Cost of sales ÷ Accounts payable, trade
= 11,387,267 ÷ 1,731,925 = 6.57
2 Click competitor name to see calculations.
The analysis of short-term operating activity between June 30, 2017, and June 30, 2022, reveals a period of volatility in the management of trade payables relative to the cost of sales. While the cost of sales exhibited an overall upward trajectory, growing from 9.19 billion USD in 2017 to 11.39 billion USD in 2022, the payables turnover ratio fluctuated, indicating shifts in the timing of supplier payments and credit utilization.
- Payables Turnover Volatility
- The payables turnover ratio demonstrated a gradual increase from 7.07 in 2017 to a peak of 9.25 in 2020. This peak suggests a period of accelerated payments to suppliers or a reduction in the average credit terms extended by vendors. However, a sharp reversal occurred in 2021, where the ratio dropped to its lowest point of 6.27, before slightly recovering to 6.57 in 2022.
- Accounts Payable Dynamics
- A significant contraction in trade payables is observed in 2020, falling to 1.11 billion USD from 1.41 billion USD the previous year, which contributed to the spike in the turnover ratio. Conversely, from 2021 onward, trade payables increased substantially, reaching 1.73 billion USD by June 30, 2022. This increase in liabilities suggests a strategic shift toward extending the payment cycle or an increase in purchasing volume on credit.
- Operational Correlation
- The divergence between the cost of sales and the payables turnover ratio in the final two years of the period indicates a change in working capital management. Despite the cost of sales reaching its highest level in 2022, the turnover ratio remained lower than the 2017-2020 average. This implies that the company has successfully increased its reliance on supplier financing to support higher operational costs.
AI Ask an analyst for more
Hi, I’m an AI-powered financial analyst at Stock Analysis on Net.
Without a user account, I tend to respond rather slowly.
How can I help you?
Working Capital Turnover
| Jun 30, 2022 | Jun 30, 2021 | Jun 30, 2020 | Jun 30, 2019 | Jun 30, 2018 | Jun 30, 2017 | ||
|---|---|---|---|---|---|---|---|
| Selected Financial Data (US$ in thousands) | |||||||
| Current assets | 12,046,644) | 5,616,750) | 4,885,204) | 7,673,086) | 5,085,238) | 4,779,718) | |
| Less: Current liabilities | 5,859,318) | 3,096,503) | 3,148,373) | 3,151,773) | 3,197,483) | 3,395,860) | |
| Working capital | 6,187,326) | 2,520,247) | 1,736,831) | 4,521,313) | 1,887,755) | 1,383,858) | |
| Net sales | 15,861,608) | 14,347,640) | 13,695,520) | 14,320,324) | 14,302,392) | 12,029,312) | |
| Short-term Activity Ratio | |||||||
| Working capital turnover1 | 2.56 | 5.69 | 7.89 | 3.17 | 7.58 | 8.69 | |
| Benchmarks | |||||||
| Working Capital Turnover, Competitors2 | |||||||
| Boeing Co. | 3.42 | 2.34 | — | — | — | — | |
| Caterpillar Inc. | 4.62 | 3.54 | — | — | — | — | |
| Eaton Corp. plc | 8.70 | 65.65 | — | — | — | — | |
| GE Aerospace | 7.93 | 4.94 | — | — | — | — | |
| Honeywell International Inc. | 7.03 | 5.86 | — | — | — | — | |
| Lockheed Martin Corp. | 12.93 | 11.52 | — | — | — | — | |
| RTX Corp. | 20.15 | 9.75 | — | — | — | — | |
| Working Capital Turnover, Sector | |||||||
| Capital Goods | 6.79 | 5.01 | — | — | — | — | |
| Working Capital Turnover, Industry | |||||||
| Industrials | 10.34 | 6.90 | — | — | — | — | |
Based on: 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), 10-K (reporting date: 2017-06-30).
1 2022 Calculation
Working capital turnover = Net sales ÷ Working capital
= 15,861,608 ÷ 6,187,326 = 2.56
2 Click competitor name to see calculations.
An analysis of operational efficiency from 2017 to 2022 reveals significant fluctuations in the utilization of working capital to generate net sales. While net sales maintained a general upward trajectory, increasing from 12.03 billion to 15.86 billion over the period, the working capital turnover ratio experienced substantial volatility, indicating inconsistent efficiency in the management of short-term assets and liabilities.
- Net Sales Performance
- Net sales exhibited steady growth for the majority of the period, with a brief contraction in 2020. The transition from 12.03 billion in 2017 to 15.86 billion in 2022 represents a consistent expansion of the top line, providing a stable baseline against which operating efficiency was measured.
- Working Capital Trends
- Working capital levels demonstrated erratic behavior, marked by two distinct peaks. A significant increase occurred in 2019, reaching 4.52 billion, followed by a sharp correction in 2020 to 1.74 billion. The most pronounced increase was observed between 2021 and 2022, where working capital rose from 2.52 billion to 6.19 billion, the highest level in the analyzed period.
- Working Capital Turnover Analysis
- The working capital turnover ratio shows a general downward trend, falling from a peak of 8.69 in 2017 to a low of 2.56 in 2022. The ratio suffered sharp declines in 2019 (3.17) and 2022 (2.56), directly correlating with the spikes in working capital. This pattern indicates that the substantial increases in short-term resources during these years did not yield a proportional increase in sales, resulting in diminished operational efficiency.
The inverse relationship between working capital levels and the turnover ratio suggests that the company's ability to generate sales per dollar of working capital has weakened over time. The sharp drop in the ratio by 2022 indicates a potential buildup of inefficient current assets or a strategic shift in liquidity management that has not yet translated into higher sales volume.
AI Ask an analyst for more
Hi, I’m an AI-powered financial analyst at Stock Analysis on Net.
Without a user account, I tend to respond rather slowly.
How can I help you?
Average Inventory Processing Period
| Jun 30, 2022 | Jun 30, 2021 | Jun 30, 2020 | Jun 30, 2019 | Jun 30, 2018 | Jun 30, 2017 | ||
|---|---|---|---|---|---|---|---|
| Selected Financial Data | |||||||
| Inventory turnover | 5.14 | 5.00 | 5.67 | 6.38 | 6.64 | 5.93 | |
| Short-term Activity Ratio (no. days) | |||||||
| Average inventory processing period1 | 71 | 73 | 64 | 57 | 55 | 62 | |
| Benchmarks (no. days) | |||||||
| Average Inventory Processing Period, Competitors2 | |||||||
| Boeing Co. | 452 | 486 | — | — | — | — | |
| Caterpillar Inc. | 144 | 144 | — | — | — | — | |
| Eaton Corp. plc | 90 | 82 | — | — | — | — | |
| GE Aerospace | 114 | 107 | — | — | — | — | |
| Honeywell International Inc. | 90 | 85 | — | — | — | — | |
| Lockheed Martin Corp. | 20 | 19 | — | — | — | — | |
| RTX Corp. | 73 | 65 | — | — | — | — | |
| Average Inventory Processing Period, Sector | |||||||
| Capital Goods | 160 | 160 | — | — | — | — | |
| Average Inventory Processing Period, Industry | |||||||
| Industrials | 85 | 91 | — | — | — | — | |
Based on: 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), 10-K (reporting date: 2017-06-30).
1 2022 Calculation
Average inventory processing period = 365 ÷ Inventory turnover
= 365 ÷ 5.14 = 71
2 Click competitor name to see calculations.
The operational efficiency regarding inventory management exhibits a non-linear trend between 2017 and 2022, characterized by an initial improvement in efficiency followed by a sustained period of decline and a recent marginal recovery.
- Inventory Turnover
- A peak in inventory turnover occurred in 2018 at 6.64, representing the highest rate of inventory circulation within the analyzed timeframe. Following this peak, a consistent downward trend was observed, with the ratio declining to a period low of 5.00 in 2021. A slight reversal of this decline appeared in 2022, as the ratio increased marginally to 5.14.
- Average Inventory Processing Period
- The duration required to process inventory moved inversely to the turnover ratio. The most efficient processing cycle was recorded in 2018 at 55 days. This period lengthened progressively over the next three years, reaching a maximum of 73 days in 2021. By 2022, the processing period contracted slightly to 71 days.
The synchronization of these metrics confirms a period of optimal inventory liquidity in 2018. The subsequent increase in the average processing period and the corresponding decrease in turnover ratios indicate a reduction in the speed of inventory conversion into sales between 2019 and 2021. The most recent figures suggest that the trend of declining efficiency has plateaued, with 2022 showing a slight improvement in the movement of goods.
AI Ask an analyst for more
Hi, I’m an AI-powered financial analyst at Stock Analysis on Net.
Without a user account, I tend to respond rather slowly.
How can I help you?
Average Receivable Collection Period
| Jun 30, 2022 | Jun 30, 2021 | Jun 30, 2020 | Jun 30, 2019 | Jun 30, 2018 | Jun 30, 2017 | ||
|---|---|---|---|---|---|---|---|
| Selected Financial Data | |||||||
| Receivables turnover | 6.77 | 6.57 | 7.39 | 6.72 | 6.67 | 6.23 | |
| Short-term Activity Ratio (no. days) | |||||||
| Average receivable collection period1 | 54 | 56 | 49 | 54 | 55 | 59 | |
| Benchmarks (no. days) | |||||||
| Average Receivable Collection Period, Competitors2 | |||||||
| Boeing Co. | 14 | 15 | — | — | — | — | |
| Caterpillar Inc. | 57 | 64 | — | — | — | — | |
| Eaton Corp. plc | 72 | 61 | — | — | — | — | |
| GE Aerospace | 89 | 80 | — | — | — | — | |
| Honeywell International Inc. | 77 | 72 | — | — | — | — | |
| Lockheed Martin Corp. | 14 | 11 | — | — | — | — | |
| RTX Corp. | 50 | 55 | — | — | — | — | |
| Average Receivable Collection Period, Sector | |||||||
| Capital Goods | 50 | 48 | — | — | — | — | |
| Average Receivable Collection Period, Industry | |||||||
| Industrials | 45 | 47 | — | — | — | — | |
Based on: 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), 10-K (reporting date: 2017-06-30).
1 2022 Calculation
Average receivable collection period = 365 ÷ Receivables turnover
= 365 ÷ 6.77 = 54
2 Click competitor name to see calculations.
The analysis of short-term operating activity reveals a period of increasing efficiency in receivables management between 2017 and 2020, followed by a slight regression and subsequent stabilization through 2022. An inverse correlation is maintained between the turnover ratio and the collection period, indicating consistent operational behavior in the conversion of receivables to cash.
- Receivables Turnover Ratio
- The turnover ratio demonstrated a steady upward trajectory from 6.23 in June 2017 to a peak of 7.39 in June 2020. This trend indicates an improving ability to collect on credit sales. A contraction occurred in June 2021, where the ratio fell to 6.57, before recovering to 6.77 by June 2022. The overall fluctuation suggests a period of volatility in credit cycles around 2021, though the final 2022 figure remains higher than the 2017 baseline.
- Average Receivable Collection Period
- The collection period mirrored the turnover trends, decreasing from 59 days in June 2017 to a low of 49 days in June 2020, representing a significant acceleration in cash inflows. This efficiency gain was partially reversed in June 2021, as the period extended to 56 days. By June 2022, the collection period improved again to 54 days. The data suggests that while there was a temporary slowdown in collections in 2021, the organization has generally maintained a more efficient collection cycle compared to the 2017 starting point.
AI Ask an analyst for more
Hi, I’m an AI-powered financial analyst at Stock Analysis on Net.
Without a user account, I tend to respond rather slowly.
How can I help you?
Operating Cycle
| Jun 30, 2022 | Jun 30, 2021 | Jun 30, 2020 | Jun 30, 2019 | Jun 30, 2018 | Jun 30, 2017 | ||
|---|---|---|---|---|---|---|---|
| Selected Financial Data | |||||||
| Average inventory processing period | 71 | 73 | 64 | 57 | 55 | 62 | |
| Average receivable collection period | 54 | 56 | 49 | 54 | 55 | 59 | |
| Short-term Activity Ratio | |||||||
| Operating cycle1 | 125 | 129 | 113 | 111 | 110 | 121 | |
| Benchmarks | |||||||
| Operating Cycle, Competitors2 | |||||||
| Boeing Co. | 466 | 501 | — | — | — | — | |
| Caterpillar Inc. | 201 | 208 | — | — | — | — | |
| Eaton Corp. plc | 162 | 143 | — | — | — | — | |
| GE Aerospace | 203 | 187 | — | — | — | — | |
| Honeywell International Inc. | 167 | 157 | — | — | — | — | |
| Lockheed Martin Corp. | 34 | 30 | — | — | — | — | |
| RTX Corp. | 123 | 120 | — | — | — | — | |
| Operating Cycle, Sector | |||||||
| Capital Goods | 210 | 208 | — | — | — | — | |
| Operating Cycle, Industry | |||||||
| Industrials | 130 | 138 | — | — | — | — | |
Based on: 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), 10-K (reporting date: 2017-06-30).
1 2022 Calculation
Operating cycle = Average inventory processing period + Average receivable collection period
= 71 + 54 = 125
2 Click competitor name to see calculations.
The operating cycle exhibits a period of volatility over the six-year analysis, characterized by an initial contraction followed by a notable expansion that peaked in 2021.
- Average Inventory Processing Period
- A fluctuating trend is observed in inventory management. After an initial decrease from 62 days in 2017 to 55 days in 2018, the period entered a sustained upward trend, reaching a peak of 73 days in 2021 before marginally declining to 71 days in 2022. This suggests a gradual increase in the time required to move inventory through the production and sales process.
- Average Receivable Collection Period
- The collection period demonstrates relative stability and an overall improvement in efficiency compared to the start of the period. The duration decreased from 59 days in 2017 to a low of 49 days in 2020. Despite a brief increase to 56 days in 2021, the period closed at 54 days in 2022, indicating a consistent ability to convert receivables into cash.
- Operating Cycle
- The total operating cycle is primarily driven by movements in inventory processing rather than receivable collections. The cycle shortened from 121 days in 2017 to 110 days in 2018, remained relatively stable through 2020, and then expanded to a high of 129 days in 2021. The reduction to 125 days in 2022 aligns with a slight improvement in inventory turnover, while the efficiency of the collection process remained steady.
AI Ask an analyst for more
Hi, I’m an AI-powered financial analyst at Stock Analysis on Net.
Without a user account, I tend to respond rather slowly.
How can I help you?
Average Payables Payment Period
| Jun 30, 2022 | Jun 30, 2021 | Jun 30, 2020 | Jun 30, 2019 | Jun 30, 2018 | Jun 30, 2017 | ||
|---|---|---|---|---|---|---|---|
| Selected Financial Data | |||||||
| Payables turnover | 6.57 | 6.27 | 9.25 | 7.57 | 7.52 | 7.07 | |
| Short-term Activity Ratio (no. days) | |||||||
| Average payables payment period1 | 56 | 58 | 39 | 48 | 49 | 52 | |
| Benchmarks (no. days) | |||||||
| Average Payables Payment Period, Competitors2 | |||||||
| Boeing Co. | 59 | 57 | — | — | — | — | |
| Caterpillar Inc. | 77 | 84 | — | — | — | — | |
| Eaton Corp. plc | 81 | 77 | — | — | — | — | |
| GE Aerospace | 123 | 110 | — | — | — | — | |
| Honeywell International Inc. | 103 | 107 | — | — | — | — | |
| Lockheed Martin Corp. | 13 | 5 | — | — | — | — | |
| RTX Corp. | 68 | 62 | — | — | — | — | |
| Average Payables Payment Period, Sector | |||||||
| Capital Goods | 70 | 65 | — | — | — | — | |
| Average Payables Payment Period, Industry | |||||||
| Industrials | 47 | 47 | — | — | — | — | |
Based on: 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), 10-K (reporting date: 2017-06-30).
1 2022 Calculation
Average payables payment period = 365 ÷ Payables turnover
= 365 ÷ 6.57 = 56
2 Click competitor name to see calculations.
The analysis of short-term operating activity reveals a cyclical trend in the management of accounts payable from 2017 through 2022. An initial period of increasing payment frequency was followed by a significant expansion of the payment duration, indicating shifts in working capital management and liquidity strategies.
- Payables Turnover Trends
- Between 2017 and 2020, payables turnover exhibited a consistent upward trajectory, increasing from 7.07 to a peak of 9.25. This trend indicates an acceleration in the rate at which obligations to suppliers were settled. A sharp reversal occurred in 2021, with the turnover ratio dropping to 6.27, followed by a marginal recovery to 6.57 in 2022.
- Average Payables Payment Period Dynamics
- The average payables payment period moved inversely to the turnover ratio, showing a steady decline from 52 days in 2017 to a minimum of 39 days in 2020. This period of acceleration was followed by a substantial increase in the payment cycle, which peaked at 58 days in 2021 and ended at 56 days in 2022. The extension of the payment period in the final two years of the analyzed timeframe suggests a strategic shift toward optimizing cash flow by delaying supplier payments.
AI Ask an analyst for more
Hi, I’m an AI-powered financial analyst at Stock Analysis on Net.
Without a user account, I tend to respond rather slowly.
How can I help you?
Cash Conversion Cycle
| Jun 30, 2022 | Jun 30, 2021 | Jun 30, 2020 | Jun 30, 2019 | Jun 30, 2018 | Jun 30, 2017 | ||
|---|---|---|---|---|---|---|---|
| Selected Financial Data | |||||||
| Average inventory processing period | 71 | 73 | 64 | 57 | 55 | 62 | |
| Average receivable collection period | 54 | 56 | 49 | 54 | 55 | 59 | |
| Average payables payment period | 56 | 58 | 39 | 48 | 49 | 52 | |
| Short-term Activity Ratio | |||||||
| Cash conversion cycle1 | 69 | 71 | 74 | 63 | 61 | 69 | |
| Benchmarks | |||||||
| Cash Conversion Cycle, Competitors2 | |||||||
| Boeing Co. | 407 | 444 | — | — | — | — | |
| Caterpillar Inc. | 124 | 124 | — | — | — | — | |
| Eaton Corp. plc | 81 | 66 | — | — | — | — | |
| GE Aerospace | 80 | 77 | — | — | — | — | |
| Honeywell International Inc. | 64 | 50 | — | — | — | — | |
| Lockheed Martin Corp. | 21 | 25 | — | — | — | — | |
| RTX Corp. | 55 | 58 | — | — | — | — | |
| Cash Conversion Cycle, Sector | |||||||
| Capital Goods | 140 | 143 | — | — | — | — | |
| Cash Conversion Cycle, Industry | |||||||
| Industrials | 83 | 91 | — | — | — | — | |
Based on: 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), 10-K (reporting date: 2017-06-30).
1 2022 Calculation
Cash conversion cycle = Average inventory processing period + Average receivable collection period – Average payables payment period
= 71 + 54 – 56 = 69
2 Click competitor name to see calculations.
The overall cash conversion cycle demonstrates a period of fluctuation between 2017 and 2022, characterized by a mid-period peak and an eventual return to baseline levels. The cycle began at 69 days in 2017, reached a low of 61 days in 2018, and climbed to a peak of 74 days in 2020 before stabilizing back at 69 days by June 30, 2022.
- Average Inventory Processing Period
- A general upward trend is observed starting from 2018, where the period was 55 days, rising to a peak of 73 days in 2021 and concluding at 71 days in 2022. This progression indicates a gradual increase in the duration required to move inventory through the production and sales process.
- Average Receivable Collection Period
- Collection efficiency remained relatively stable over the six-year period, with values ranging from a high of 59 days in 2017 to a low of 49 days in 2020. The period ended at 54 days in 2022, suggesting a consistent and controlled approach to managing accounts receivable.
- Average Payables Payment Period
- Significant volatility is evident in the timing of supplier payments. A marked decline occurred in 2020, reaching a minimum of 39 days, which was followed by a sharp increase to 58 days in 2021. This shift indicates a transition toward more extended payment terms in the latter years of the analysis.
- Cash Conversion Cycle Synthesis
- The peak of the cash conversion cycle in 2020 was driven by the simultaneous increase in inventory processing time and a substantial reduction in the payables payment period. In subsequent years, the cycle was moderated as the increase in the payables payment period served to offset the slower inventory turnover, bringing the total cycle back to its 2017 level.
AI Ask an analyst for more
Hi, I’m an AI-powered financial analyst at Stock Analysis on Net.
Without a user account, I tend to respond rather slowly.
How can I help you?