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-12-31), 10-K (reporting date: 2021-12-31), 10-K (reporting date: 2020-12-31), 10-K (reporting date: 2019-12-31), 10-K (reporting date: 2018-12-31).
An analysis of short-term activity ratios between 2018 and 2022 reveals a general decline in operational efficiency, characterized primarily by a significant expansion of the cash conversion cycle and a deceleration in inventory turnover.
- Inventory Management
- Inventory turnover experienced a marked decline from a peak of 5.76 in 2019 to 2.28 in 2022. This trend is mirrored in the average inventory processing period, which grew from 63 days in 2019 to 160 days by 2022. This suggests a substantial increase in the duration that goods remain in stock before being sold.
- Receivables Management
- Receivables turnover demonstrated volatility, reaching a low of 2.69 in 2021 before recovering to 3.32 in 2022. The average receivable collection period followed a similar pattern, peaking at 136 days in 2021 but improving to 110 days in 2022, indicating a recent increase in the efficiency of credit collections.
- Payables Management
- A downward trend in payables turnover is observed, falling from 10.65 in 2018 to 7.70 in 2022. Consequently, the average payables payment period increased from 34 days in 2018 to 47 days in 2022, reflecting a trend toward extending the timeframe for settling supplier obligations.
- Operating and Cash Conversion Cycles
- The operating cycle expanded significantly from 164 days in 2019 to 270 days in 2022, driven largely by the slowing movement of inventory. This resulted in a prolonged cash conversion cycle, which increased from 122 days in 2019 to 223 days in 2022, indicating that a larger amount of capital is tied up in operations for a longer duration.
Working capital turnover remained relatively stable throughout the period, fluctuating between a low of 0.94 and a high of 1.25. This suggests that despite the lengthening of individual components of the operating cycle, the overall relationship between working capital and generated sales remained consistent.
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
| Dec 31, 2022 | Dec 31, 2021 | Dec 31, 2020 | Dec 31, 2019 | Dec 31, 2018 | ||
|---|---|---|---|---|---|---|
| Selected Financial Data (US$ in thousands) | ||||||
| Cost of sales | 461,297) | 322,471) | 264,672) | 223,574) | 161,485) | |
| Inventory | 202,471) | 108,688) | 89,958) | 38,845) | 33,763) | |
| Short-term Activity Ratio | ||||||
| Inventory turnover1 | 2.28 | 2.97 | 2.94 | 5.76 | 4.78 | |
| 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-12-31), 10-K (reporting date: 2021-12-31), 10-K (reporting date: 2020-12-31), 10-K (reporting date: 2019-12-31), 10-K (reporting date: 2018-12-31).
1 2022 Calculation
Inventory turnover = Cost of sales ÷ Inventory
= 461,297 ÷ 202,471 = 2.28
2 Click competitor name to see calculations.
The financial trajectory between 2018 and 2022 reveals a significant expansion in operational scale, accompanied by a notable decline in inventory management efficiency. While the cost of sales grew steadily throughout the period, the accumulation of inventory occurred at a much more aggressive rate, resulting in a sustained downward trend for the inventory turnover ratio after 2019.
- Cost of Sales Growth
- A consistent upward trend is observed, with costs rising from 161,485 thousand US$ in 2018 to 461,297 thousand US$ in 2022. This represents a substantial increase in the volume of goods sold and overall business activity over the five-year period.
- Inventory Accumulation
- Inventory levels experienced exponential growth, increasing from 33,763 thousand US$ in 2018 to 202,471 thousand US$ in 2022. Particularly sharp increases occurred in 2020 and 2022, where inventory levels nearly doubled compared to the preceding years, far outpacing the growth in the cost of sales.
- Inventory Turnover Performance
- The turnover ratio reached a peak of 5.76 in 2019 before experiencing a sharp contraction to 2.94 in 2020. Following a period of relative stabilization in 2021 at 2.97, the ratio further declined to 2.28 by the end of 2022, indicating that inventory is being cycled through the business significantly slower than in the early part of the analyzed period.
The divergence between the growth rate of the cost of sales and the growth rate of inventory suggests a potential shift in operational strategy, such as strategic stockpiling to mitigate supply chain risks or a decrease in the velocity of product movement. The marked decline in the turnover ratio since 2019 implies an increasing amount of capital tied up in non-liquid assets, which may impact short-term 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?
Receivables Turnover
| Dec 31, 2022 | Dec 31, 2021 | Dec 31, 2020 | Dec 31, 2019 | Dec 31, 2018 | ||
|---|---|---|---|---|---|---|
| Selected Financial Data (US$ in thousands) | ||||||
| Net sales | 1,189,935) | 863,381) | 681,003) | 530,860) | 420,068) | |
| Accounts and notes receivable, net of allowance | 358,190) | 320,819) | 229,201) | 146,878) | 130,579) | |
| Short-term Activity Ratio | ||||||
| Receivables turnover1 | 3.32 | 2.69 | 2.97 | 3.61 | 3.22 | |
| 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-12-31), 10-K (reporting date: 2021-12-31), 10-K (reporting date: 2020-12-31), 10-K (reporting date: 2019-12-31), 10-K (reporting date: 2018-12-31).
1 2022 Calculation
Receivables turnover = Net sales ÷ Accounts and notes receivable, net of allowance
= 1,189,935 ÷ 358,190 = 3.32
2 Click competitor name to see calculations.
Between 2018 and 2022, a consistent and aggressive expansion in net sales was observed, with revenue increasing from $420.1 million to approximately $1.19 billion. This growth was accompanied by a steady rise in accounts and notes receivable, which grew from $130.6 million to $358.2 million over the same period. While both metrics trended upward, the efficiency of receivables collection, as measured by the receivables turnover ratio, experienced a period of volatility before recovering in the final year of the analysis.
- Revenue and Asset Growth
- Net sales demonstrated a strong upward trajectory, nearly tripling over the five-year period. Accounts and notes receivable followed a similar growth pattern, indicating that the increase in credit extended to customers was proportional to the scaling of business operations.
- Receivables Turnover Trends
- The turnover ratio initially improved from 3.22 in 2018 to 3.61 in 2019, suggesting an increase in the efficiency of converting receivables into cash. However, a downward trend emerged in 2020 and 2021, with the ratio falling to 2.97 and 2.69, respectively. This decline indicates a slowing of the collection cycle or a shift toward more lenient credit terms during those years.
- Efficiency Recovery
- A notable reversal in the collection trend occurred in 2022, where the receivables turnover ratio rose to 3.32. This recovery suggests a strengthening of credit management practices and a return to collection efficiencies comparable to those observed in 2018 and 2019, despite the significantly higher volume of 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
| Dec 31, 2022 | Dec 31, 2021 | Dec 31, 2020 | Dec 31, 2019 | Dec 31, 2018 | ||
|---|---|---|---|---|---|---|
| Selected Financial Data (US$ in thousands) | ||||||
| Cost of sales | 461,297) | 322,471) | 264,672) | 223,574) | 161,485) | |
| Accounts payable | 59,918) | 32,220) | 24,142) | 25,874) | 15,164) | |
| Short-term Activity Ratio | ||||||
| Payables turnover1 | 7.70 | 10.01 | 10.96 | 8.64 | 10.65 | |
| 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-12-31), 10-K (reporting date: 2021-12-31), 10-K (reporting date: 2020-12-31), 10-K (reporting date: 2019-12-31), 10-K (reporting date: 2018-12-31).
1 2022 Calculation
Payables turnover = Cost of sales ÷ Accounts payable
= 461,297 ÷ 59,918 = 7.70
2 Click competitor name to see calculations.
The financial data indicates a period of significant expansion in operational costs paired with a strategic shift in the management of short-term liabilities between 2018 and 2022.
- Cost of Sales Trends
- A consistent upward trajectory is observed in the cost of sales, which increased from 161,485 thousand US$ in 2018 to 461,297 thousand US$ in 2022. This growth reflects a substantial increase in the scale of operations and the volume of goods or services required to generate revenue over the five-year period.
- Accounts Payable Management
- Accounts payable experienced a general increase, rising from 15,164 thousand US$ in 2018 to 59,918 thousand US$ in 2022. A particularly sharp increase is noted between 2021 and 2022, where the balance nearly doubled, indicating a higher accumulation of short-term obligations to suppliers.
- Payables Turnover Performance
- The payables turnover ratio exhibits volatility, moving from 10.65 in 2018 to a peak of 10.96 in 2020, before declining to 7.70 in 2022. This overall downward trend, particularly the drop in the final year, suggests a decrease in the frequency with which the company settles its accounts payable, effectively extending the average time taken to pay suppliers.
The observed correlation between the rising cost of sales and the declining turnover ratio suggests that the company is increasingly leveraging supplier credit to support its operational growth, thereby preserving cash flow as it scales.
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
| Dec 31, 2022 | Dec 31, 2021 | Dec 31, 2020 | Dec 31, 2019 | Dec 31, 2018 | ||
|---|---|---|---|---|---|---|
| Selected Financial Data (US$ in thousands) | ||||||
| Current assets | 1,805,278) | 1,109,490) | 981,952) | 619,091) | 558,155) | |
| Less: Current liabilities | 602,646) | 418,521) | 256,331) | 195,566) | 166,011) | |
| Working capital | 1,202,632) | 690,969) | 725,621) | 423,525) | 392,144) | |
| Net sales | 1,189,935) | 863,381) | 681,003) | 530,860) | 420,068) | |
| Short-term Activity Ratio | ||||||
| Working capital turnover1 | 0.99 | 1.25 | 0.94 | 1.25 | 1.07 | |
| 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-12-31), 10-K (reporting date: 2021-12-31), 10-K (reporting date: 2020-12-31), 10-K (reporting date: 2019-12-31), 10-K (reporting date: 2018-12-31).
1 2022 Calculation
Working capital turnover = Net sales ÷ Working capital
= 1,189,935 ÷ 1,202,632 = 0.99
2 Click competitor name to see calculations.
Financial performance from 2018 to 2022 is characterized by substantial growth in both net sales and working capital. Net sales exhibited a consistent upward trajectory, increasing from $420.1 million in 2018 to $1.19 billion in 2022. Simultaneously, working capital expanded significantly, rising from $392.1 million to $1.20 billion over the same period, indicating a substantial increase in the current asset base relative to current liabilities.
- Working Capital Turnover Trend
- The working capital turnover ratio demonstrated a fluctuating pattern throughout the five-year period, ranging between 0.94 and 1.25. Peak efficiency was observed in 2019 and 2021, where the ratio reached 1.25, suggesting a more effective utilization of short-term assets to generate revenue during those specific years.
- Analysis of Efficiency Declines
- Downward shifts in the turnover ratio were noted in 2020 (0.94) and 2022 (0.99). These declines coincide with periods of sharp increases in working capital. Specifically, the 2020 dip followed a surge in working capital from $423.5 million to $725.6 million, and the 2022 dip occurred as working capital climbed to $1.20 billion. This indicates that the expansion of operating liquidity outpaced the growth of net sales during these intervals.
- Operational Insights
- While revenue growth remained steady, the inconsistent turnover ratio suggests that the investment in working capital has not scaled linearly with sales. The pattern reflects a cycle of aggressive liquidity accumulation followed by periods of improved asset turnover, resulting in a ratio that oscillates around the 1.0 mark.
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
| Dec 31, 2022 | Dec 31, 2021 | Dec 31, 2020 | Dec 31, 2019 | Dec 31, 2018 | ||
|---|---|---|---|---|---|---|
| Selected Financial Data | ||||||
| Inventory turnover | 2.28 | 2.97 | 2.94 | 5.76 | 4.78 | |
| Short-term Activity Ratio (no. days) | ||||||
| Average inventory processing period1 | 160 | 123 | 124 | 63 | 76 | |
| 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-12-31), 10-K (reporting date: 2021-12-31), 10-K (reporting date: 2020-12-31), 10-K (reporting date: 2019-12-31), 10-K (reporting date: 2018-12-31).
1 2022 Calculation
Average inventory processing period = 365 ÷ Inventory turnover
= 365 ÷ 2.28 = 160
2 Click competitor name to see calculations.
An analysis of the operational efficiency regarding inventory management reveals a significant deterioration in turnover performance over the five-year period from 2018 to 2022. While initial improvements were observed in 2019, subsequent years indicate a marked slowdown in the movement of goods through the supply chain.
- Inventory Turnover Trends
- The inventory turnover ratio peaked in 2019 at 5.76, reflecting optimal efficiency. However, a sharp decline occurred in 2020, with the ratio dropping to 2.94. This downward trajectory continued through 2022, where the ratio reached a period low of 2.28, indicating that inventory is being turned over significantly fewer times per year than in previous periods.
- Average Inventory Processing Period
- The duration required to process inventory has increased substantially. After reaching a minimum of 63 days in 2019, the processing period spiked to 124 days in 2020. Following a period of relative stability in 2021, the processing period escalated further to 160 days by the end of 2022. This represents a more than twofold increase in the time inventory remains on hand compared to the 2019 low.
- Operational Implications
- The inverse correlation between the turnover ratio and the processing period highlights a growing inefficiency in inventory management. The extension of the processing period to 160 days suggests increased capital tied up in non-liquid assets and a potentially higher risk of inventory obsolescence or increased carrying costs.
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
| Dec 31, 2022 | Dec 31, 2021 | Dec 31, 2020 | Dec 31, 2019 | Dec 31, 2018 | ||
|---|---|---|---|---|---|---|
| Selected Financial Data | ||||||
| Receivables turnover | 3.32 | 2.69 | 2.97 | 3.61 | 3.22 | |
| Short-term Activity Ratio (no. days) | ||||||
| Average receivable collection period1 | 110 | 136 | 123 | 101 | 113 | |
| 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-12-31), 10-K (reporting date: 2021-12-31), 10-K (reporting date: 2020-12-31), 10-K (reporting date: 2019-12-31), 10-K (reporting date: 2018-12-31).
1 2022 Calculation
Average receivable collection period = 365 ÷ Receivables turnover
= 365 ÷ 3.32 = 110
2 Click competitor name to see calculations.
An analysis of short-term operating activity reveals a fluctuating trend in credit management efficiency between 2018 and 2022. The capacity to convert receivables into cash experienced a period of contraction between 2019 and 2021, followed by a strong recovery in the final year of the period.
- Receivables Turnover
- The turnover ratio increased from 3.22 in 2018 to a peak of 3.61 in 2019. A subsequent downward trend was observed over the following two years, with the ratio falling to 2.97 in 2020 and reaching a low of 2.69 in 2021. This trend reversed in 2022, as the ratio climbed back to 3.32, indicating an acceleration in the frequency of receivable collection.
- Average Receivable Collection Period
- The collection period fluctuated in inverse correlation with the turnover ratio. A reduction to 101 days in 2019 was followed by a steady increase, peaking at 136 days in 2021. A significant improvement in collection efficiency occurred in 2022, with the period decreasing to 110 days, representing the most efficient collection cycle within the analyzed five-year window.
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
| Dec 31, 2022 | Dec 31, 2021 | Dec 31, 2020 | Dec 31, 2019 | Dec 31, 2018 | ||
|---|---|---|---|---|---|---|
| Selected Financial Data | ||||||
| Average inventory processing period | 160 | 123 | 124 | 63 | 76 | |
| Average receivable collection period | 110 | 136 | 123 | 101 | 113 | |
| Short-term Activity Ratio | ||||||
| Operating cycle1 | 270 | 259 | 247 | 164 | 189 | |
| 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-12-31), 10-K (reporting date: 2021-12-31), 10-K (reporting date: 2020-12-31), 10-K (reporting date: 2019-12-31), 10-K (reporting date: 2018-12-31).
1 2022 Calculation
Operating cycle = Average inventory processing period + Average receivable collection period
= 160 + 110 = 270
2 Click competitor name to see calculations.
The operating cycle has exhibited a significant upward trend over the five-year period, expanding from 189 days in 2018 to 270 days by the end of 2022. This extension indicates a slowing in the time required to convert investment in inventory and receivables back into cash, reflecting a decrease in short-term operational efficiency.
- Average Inventory Processing Period
- A substantial increase is observed in the time required to process inventory. After a brief decline to 63 days in 2019, the period surged to 124 days in 2020 and continued to rise, reaching a peak of 160 days in 2022. This trend suggests a growing accumulation of inventory or a decrease in the rate of product turnover.
- Average Receivable Collection Period
- The collection period has demonstrated fluctuation rather than a linear trend. The period improved from 113 days in 2018 to 101 days in 2019, before increasing to a peak of 136 days in 2021. A notable improvement occurred in 2022, where the collection period decreased to 110 days, suggesting enhanced efficiency in credit recovery toward the end of the analyzed period.
- Operating Cycle Correlation
- The overall lengthening of the operating cycle is primarily driven by the inventory processing period, which has grown consistently since 2019. While the receivable collection period provided some offset in 2022 through a reduction in collection days, it was insufficient to counteract the continued expansion of the inventory holding 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?
Average Payables Payment Period
| Dec 31, 2022 | Dec 31, 2021 | Dec 31, 2020 | Dec 31, 2019 | Dec 31, 2018 | ||
|---|---|---|---|---|---|---|
| Selected Financial Data | ||||||
| Payables turnover | 7.70 | 10.01 | 10.96 | 8.64 | 10.65 | |
| Short-term Activity Ratio (no. days) | ||||||
| Average payables payment period1 | 47 | 36 | 33 | 42 | 34 | |
| 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-12-31), 10-K (reporting date: 2021-12-31), 10-K (reporting date: 2020-12-31), 10-K (reporting date: 2019-12-31), 10-K (reporting date: 2018-12-31).
1 2022 Calculation
Average payables payment period = 365 ÷ Payables turnover
= 365 ÷ 7.70 = 47
2 Click competitor name to see calculations.
The analysis of short-term operating activity ratios between 2018 and 2022 reveals a fluctuating pattern in the management of accounts payable, characterized by a general extension of the duration required to settle obligations with suppliers.
- Payables Turnover
- The payables turnover ratio demonstrates notable volatility throughout the observed period. A decrease from 10.65 in 2018 to 8.64 in 2019 was followed by a peak of 10.96 in 2020. However, a subsequent decline occurred over the following two years, with the ratio reaching a five-year low of 7.70 by December 31, 2022, indicating a slowing frequency of supplier payments.
- Average Payables Payment Period
- The average payment period exhibits an inverse correlation with the turnover ratio. The cycle began at 34 days in 2018, rose to 42 days in 2019, and contracted to its lowest level of 33 days in 2020. Since that point, a steady upward trend is observed, with the payment period extending to 36 days in 2021 and peaking at 47 days in 2022.
- Working Capital Implications
- The expansion of the payment cycle from 33 days in 2020 to 47 days in 2022 suggests a shift in working capital management. This trend indicates that a larger portion of cash is being retained within the business for longer periods, potentially due to more favorable credit terms negotiated with vendors or a deliberate strategy to optimize 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?
Cash Conversion Cycle
| Dec 31, 2022 | Dec 31, 2021 | Dec 31, 2020 | Dec 31, 2019 | Dec 31, 2018 | ||
|---|---|---|---|---|---|---|
| Selected Financial Data | ||||||
| Average inventory processing period | 160 | 123 | 124 | 63 | 76 | |
| Average receivable collection period | 110 | 136 | 123 | 101 | 113 | |
| Average payables payment period | 47 | 36 | 33 | 42 | 34 | |
| Short-term Activity Ratio | ||||||
| Cash conversion cycle1 | 223 | 223 | 214 | 122 | 155 | |
| 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-12-31), 10-K (reporting date: 2021-12-31), 10-K (reporting date: 2020-12-31), 10-K (reporting date: 2019-12-31), 10-K (reporting date: 2018-12-31).
1 2022 Calculation
Cash conversion cycle = Average inventory processing period + Average receivable collection period – Average payables payment period
= 160 + 110 – 47 = 223
2 Click competitor name to see calculations.
The cash conversion cycle exhibits a marked increase over the analyzed five-year period, indicating a lengthening of the time required to convert working capital into cash. After a temporary improvement in 2019, the cycle expanded significantly from 122 days to 223 days by 2021, remaining stagnant at that level through 2022.
- Average Inventory Processing Period
- A significant upward trend is observed in the time required to process inventory. While the period decreased to 63 days in 2019, it nearly doubled to 124 days in 2020 and continued to climb, reaching a peak of 160 days by 2022. This indicates a reduction in inventory turnover efficiency or a strategic increase in stock holdings.
- Average Receivable Collection Period
- Receivable collection times show moderate volatility. The period reached a high of 136 days in 2021 before improving to 110 days in 2022. Despite the recent recovery, the collection period remains higher than the 2019 low of 101 days, reflecting fluctuations in credit management or client payment behavior.
- Average Payables Payment Period
- The timeframe for settling obligations to suppliers has remained relatively stable compared to other activity ratios, though it reached its highest point of 47 days in 2022. This slight extension in payment terms provides a marginal offset to the widening gaps in inventory and receivable cycles.
- Net Effect on Liquidity
- The substantial expansion of the cash conversion cycle is primarily driven by the sharp increase in the inventory processing period. The combined effect of slower inventory movement and fluctuating receivable collections has resulted in a cycle that is 68 days longer in 2022 than it was in 2018, suggesting a higher requirement for working capital to sustain operations.
AI Ask an analyst for more
Hi, I’m an AI-powered financial analyst at Stock Analysis on Net.
How can I help you?