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: 2021-12-31), 10-K (reporting date: 2020-12-31), 10-K (reporting date: 2019-12-31), 10-K (reporting date: 2018-12-31), 10-K (reporting date: 2017-12-31).
The analysis reveals distinct trends in the company's operational efficiency and working capital management over the five-year period.
- Inventory Turnover
- There is a general decline in inventory turnover from 2.87 in 2017 to 2.18 in 2021, suggesting a slower movement of inventory and potentially increased holding of stock.
- Receivables Turnover
- The receivables turnover ratio shows an overall improvement, rising from 5.97 in 2017 to 6.84 in 2021, indicating faster collection of receivables and better credit management.
- Payables Turnover
- The payables turnover fluctuates, peaking at 5.37 in 2019 but decreasing to 3.53 by 2021, implying a lengthening in the period taken to pay suppliers over the latter years.
- Working Capital Turnover
- This ratio declines from 3.89 in 2017 to 2.42 in 2020 but significantly increases to 5.4 in 2021. This indicates a substantial improvement in generating revenue from working capital in the most recent year.
- Average Inventory Processing Period
- The average number of days to process inventory increases overall, from 127 days in 2017 to 167 days in 2021, supporting the observation of slower inventory turnover.
- Average Receivable Collection Period
- The collection period for receivables decreases from 61 days in 2017 to 53 days in 2021, reflecting enhanced efficiency in collecting outstanding payments.
- Operating Cycle
- The operating cycle experiences fluctuations but trends upward from 188 days in 2017 to 220 days in 2021, indicating a longer duration between inventory acquisition and cash collection from sales.
- Average Payables Payment Period
- There is an increase in the days taken to pay suppliers, from 78 days in 2017 to 104 days in 2021, which may contribute to improved liquidity or extended credit terms with suppliers.
- Cash Conversion Cycle
- The cash conversion cycle remains relatively stable around 110 to 120 days during the years 2017 to 2020, with a slight decrease to 116 days in 2021, indicating a consistent effectiveness in managing the time between cash outflow and inflow.
Overall, the data indicate an increased focus on accelerating receivables and extending payables, while inventory turnover shows signs of slowing. The substantial rise in working capital turnover in 2021 suggests a marked improvement in utilizing current assets to generate revenue during that year.
Turnover Ratios
Average No. Days
Inventory Turnover
Dec 31, 2021 | Dec 31, 2020 | Dec 31, 2019 | Dec 31, 2018 | Dec 31, 2017 | ||
---|---|---|---|---|---|---|
Selected Financial Data (US$ in thousands) | ||||||
Costs of goods sold | 2,377,102) | 1,527,546) | 1,406,584) | 1,298,424) | 1,090,328) | |
Inventories | 1,089,705) | 603,317) | 522,024) | 544,750) | 380,341) | |
Short-term Activity Ratio | ||||||
Inventory turnover1 | 2.18 | 2.53 | 2.69 | 2.38 | 2.87 | |
Benchmarks | ||||||
Inventory Turnover, Competitors2 | ||||||
Boeing Co. | 0.75 | 0.78 | — | — | — | |
Caterpillar Inc. | 2.53 | 2.55 | — | — | — | |
Eaton Corp. plc | 4.48 | 5.88 | — | — | — | |
GE Aerospace | 3.40 | 3.80 | — | — | — | |
Honeywell International Inc. | 4.29 | 4.94 | — | — | — | |
Lockheed Martin Corp. | 19.45 | 16.01 | — | — | — | |
RTX Corp. | 5.65 | 5.11 | — | — | — | |
Inventory Turnover, Sector | ||||||
Capital Goods | 2.28 | 2.28 | — | — | — | |
Inventory Turnover, Industry | ||||||
Industrials | 4.03 | 3.71 | — | — | — |
Based on: 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), 10-K (reporting date: 2017-12-31).
1 2021 Calculation
Inventory turnover = Costs of goods sold ÷ Inventories
= 2,377,102 ÷ 1,089,705 = 2.18
2 Click competitor name to see calculations.
The analysis of the financial data reveals notable trends over the five-year period from 2017 to 2021 related to costs of goods sold (COGS), inventories, and inventory turnover ratio.
- Costs of Goods Sold (COGS)
-
There is a consistent increase in costs of goods sold from 2017 through 2021. The COGS rose from approximately $1.09 billion in 2017 to about $2.38 billion in 2021, exhibiting significant growth particularly in the final year where the increase was markedly steep compared to prior increments. This points to expanding sales volumes or rising input costs, or a combination thereof.
- Inventories
-
Inventories grew substantially during the period examined. Beginning at $380.3 million in 2017, inventory levels climbed steadily to $1.09 billion by the end of 2021. The growth was relatively gradual until 2020, but a sharp increase occurred in 2021, similar to the pattern observed with COGS. This increase in inventory might indicate preparation for higher sales demand or inefficient inventory management.
- Inventory Turnover Ratio
-
The inventory turnover ratio presents a declining trend, decreasing from 2.87 times in 2017 to 2.18 times in 2021. This downward movement suggests that the company is turning over its inventory less frequently over time. The decrease in turnover ratio may reflect slower sales relative to inventory levels or increased stock holding periods, which could impact liquidity and operational efficiency.
In summary, the company experienced increasing costs of goods sold and rising inventory levels over the five years, accompanied by a declining inventory turnover ratio. The acceleration in inventory and COGS growth in 2021, coupled with a reduced turnover rate, suggests potential challenges in managing inventory efficiently or shifts in sales dynamics, warranting further investigation into supply chain and demand planning processes.
Receivables Turnover
Dec 31, 2021 | Dec 31, 2020 | Dec 31, 2019 | Dec 31, 2018 | Dec 31, 2017 | ||
---|---|---|---|---|---|---|
Selected Financial Data (US$ in thousands) | ||||||
Net sales | 3,737,184) | 2,485,200) | 2,204,336) | 2,023,464) | 1,672,445) | |
Accounts receivable, less allowance for credit losses | 546,466) | 374,906) | 319,538) | 326,133) | 280,002) | |
Short-term Activity Ratio | ||||||
Receivables turnover1 | 6.84 | 6.63 | 6.90 | 6.20 | 5.97 | |
Benchmarks | ||||||
Receivables Turnover, Competitors2 | ||||||
Boeing Co. | 23.58 | 29.75 | — | — | — | |
Caterpillar Inc. | 5.68 | 5.33 | — | — | — | |
Eaton Corp. plc | 5.95 | 6.15 | — | — | — | |
GE Aerospace | 4.55 | 4.37 | — | — | — | |
Honeywell International Inc. | 5.04 | 4.78 | — | — | — | |
Lockheed Martin Corp. | 34.15 | 33.06 | — | — | — | |
RTX Corp. | 6.66 | 6.11 | — | — | — | |
Receivables Turnover, Sector | ||||||
Capital Goods | 7.57 | 7.30 | — | — | — | |
Receivables Turnover, Industry | ||||||
Industrials | 7.76 | 7.57 | — | — | — |
Based on: 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), 10-K (reporting date: 2017-12-31).
1 2021 Calculation
Receivables turnover = Net sales ÷ Accounts receivable, less allowance for credit losses
= 3,737,184 ÷ 546,466 = 6.84
2 Click competitor name to see calculations.
The financial data reveals significant growth and operational trends over the five-year period ending December 31, 2021.
- Net Sales
- Net sales show a consistent upward trend, increasing from $1,672,445 thousand in 2017 to $3,737,184 thousand in 2021. This represents more than a twofold increase in revenue over the period, with the most substantial jump occurring between 2020 and 2021, where net sales rose by approximately 50.4%. This growth indicates an expanding market presence or enhanced sales capabilities.
- Accounts Receivable, Net of Allowance for Credit Losses
- The accounts receivable balance also increased substantially, from $280,002 thousand in 2017 to $546,466 thousand in 2021. This increase aligns with the growth in net sales, reflecting higher sales volumes on credit. The accounts receivable nearly doubled over five years, indicating the company has extended more credit to customers or experienced longer collection periods.
- Receivables Turnover Ratio
- The receivables turnover ratio generally improved from 5.97 in 2017 to 6.84 in 2021, indicating a slight increase in efficiency in collecting receivables. The ratio peaked at 6.9 in 2019, followed by a minor drop to 6.63 in 2020, but recovered slightly in 2021. This suggests that despite the growth in accounts receivable, the company has maintained or even improved its effectiveness in managing credit and collections relative to sales.
Overall, the data suggests robust revenue expansion accompanied by a proportional increase in accounts receivable. The relatively stable and slightly improving receivables turnover ratio indicates effective credit management and collection processes amid growing sales volumes.
Payables Turnover
Dec 31, 2021 | Dec 31, 2020 | Dec 31, 2019 | Dec 31, 2018 | Dec 31, 2017 | ||
---|---|---|---|---|---|---|
Selected Financial Data (US$ in thousands) | ||||||
Costs of goods sold | 2,377,102) | 1,527,546) | 1,406,584) | 1,298,424) | 1,090,328) | |
Accounts payable | 674,208) | 330,247) | 261,977) | 328,091) | 233,639) | |
Short-term Activity Ratio | ||||||
Payables turnover1 | 3.53 | 4.63 | 5.37 | 3.96 | 4.67 | |
Benchmarks | ||||||
Payables Turnover, Competitors2 | ||||||
Boeing Co. | 6.40 | 4.94 | — | — | — | |
Caterpillar Inc. | 4.36 | 4.75 | — | — | — | |
Eaton Corp. plc | 4.75 | 6.24 | — | — | — | |
GE Aerospace | 3.32 | 3.67 | — | — | — | |
Honeywell International Inc. | 3.40 | 3.86 | — | — | — | |
Lockheed Martin Corp. | 74.34 | 64.48 | — | — | — | |
RTX Corp. | 5.93 | 5.56 | — | — | — | |
Payables Turnover, Sector | ||||||
Capital Goods | 5.60 | 5.54 | — | — | — | |
Payables Turnover, Industry | ||||||
Industrials | 7.81 | 7.49 | — | — | — |
Based on: 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), 10-K (reporting date: 2017-12-31).
1 2021 Calculation
Payables turnover = Costs of goods sold ÷ Accounts payable
= 2,377,102 ÷ 674,208 = 3.53
2 Click competitor name to see calculations.
- Costs of Goods Sold
- The costs of goods sold exhibited a consistent upward trend over the five-year period. Beginning at approximately 1.09 billion USD in 2017, the cost increased each year, reaching about 2.38 billion USD by the end of 2021. The most notable surge occurred between 2020 and 2021, where costs rose sharply by over 55%, indicating possible increases in production volume, material costs, or operational expenses during that period.
- Accounts Payable
- Accounts payable also showed growth but with more fluctuations. Starting at roughly 234 million USD in 2017, the value increased to a peak of 328 million USD in 2018, then slightly declined in 2019 to around 262 million USD. Following this dip, the figure rose again significantly, reaching approximately 674 million USD by the end of 2021, which more than doubled the 2017 amount. This suggests an expansion in outstanding supplier payments, possibly reflecting higher procurement or extended payment terms.
- Payables Turnover Ratio
- The payables turnover ratio fluctuated over the reviewed years. It began at 4.67 in 2017, decreased to 3.96 in 2018, peaked at 5.37 in 2019, then declined again to 4.63 in 2020, and finally fell to 3.53 in 2021. The ratio's volatility indicates varying efficiency in managing payables. The decrease in 2021, concurrent with the large rise in accounts payable, may suggest slower payment cycles or changes in credit terms with suppliers.
Working Capital Turnover
Dec 31, 2021 | Dec 31, 2020 | Dec 31, 2019 | Dec 31, 2018 | Dec 31, 2017 | ||
---|---|---|---|---|---|---|
Selected Financial Data (US$ in thousands) | ||||||
Current assets | 1,848,464) | 1,669,733) | 1,195,829) | 1,120,769) | 818,556) | |
Less: Current liabilities | 1,155,907) | 641,524) | 497,064) | 560,706) | 388,872) | |
Working capital | 692,557) | 1,028,209) | 698,765) | 560,063) | 429,684) | |
Net sales | 3,737,184) | 2,485,200) | 2,204,336) | 2,023,464) | 1,672,445) | |
Short-term Activity Ratio | ||||||
Working capital turnover1 | 5.40 | 2.42 | 3.15 | 3.61 | 3.89 | |
Benchmarks | ||||||
Working Capital Turnover, Competitors2 | ||||||
Boeing Co. | 2.34 | 1.69 | — | — | — | |
Caterpillar Inc. | 3.54 | 2.84 | — | — | — | |
Eaton Corp. plc | 65.65 | 5.42 | — | — | — | |
GE Aerospace | 4.94 | 2.26 | — | — | — | |
Honeywell International Inc. | 5.86 | 3.64 | — | — | — | |
Lockheed Martin Corp. | 11.52 | 12.01 | — | — | — | |
RTX Corp. | 9.75 | 7.52 | — | — | — | |
Working Capital Turnover, Sector | ||||||
Capital Goods | 5.01 | 3.24 | — | — | — | |
Working Capital Turnover, Industry | ||||||
Industrials | 6.90 | 4.52 | — | — | — |
Based on: 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), 10-K (reporting date: 2017-12-31).
1 2021 Calculation
Working capital turnover = Net sales ÷ Working capital
= 3,737,184 ÷ 692,557 = 5.40
2 Click competitor name to see calculations.
- Working Capital
- Working capital exhibited a generally increasing trend from 2017 to 2020, rising from approximately 430 million USD in 2017 to over 1 billion USD in 2020. However, in 2021, working capital decreased significantly to around 693 million USD.
- Net Sales
- Net sales showed consistent growth over the entire period. Starting at roughly 1.67 billion USD in 2017, net sales increased each year, reaching approximately 3.74 billion USD in 2021. The most pronounced increase occurred between 2020 and 2021.
- Working Capital Turnover
- The working capital turnover ratio declined steadily from 3.89 in 2017 to 2.42 in 2020, indicating slower sales generation relative to working capital invested. In 2021, there was a sharp rise to 5.4, suggesting that despite a lower working capital base, the company generated substantially higher sales.
- Overall Analysis
- The data reflects an expansion phase with increased sales and working capital until 2020, followed by a strategic reduction in working capital in 2021 combined with accelerated sales growth. The significant increase in working capital turnover in 2021 indicates improved efficiency in using working capital to generate sales. The decline in working capital alongside growth in sales may suggest better inventory management, receivables collection, or other operational improvements leading to enhanced liquidity and asset utilization.
Average Inventory Processing Period
Dec 31, 2021 | Dec 31, 2020 | Dec 31, 2019 | Dec 31, 2018 | Dec 31, 2017 | ||
---|---|---|---|---|---|---|
Selected Financial Data | ||||||
Inventory turnover | 2.18 | 2.53 | 2.69 | 2.38 | 2.87 | |
Short-term Activity Ratio (no. days) | ||||||
Average inventory processing period1 | 167 | 144 | 135 | 153 | 127 | |
Benchmarks (no. days) | ||||||
Average Inventory Processing Period, Competitors2 | ||||||
Boeing Co. | 486 | 467 | — | — | — | |
Caterpillar Inc. | 144 | 143 | — | — | — | |
Eaton Corp. plc | 82 | 62 | — | — | — | |
GE Aerospace | 107 | 96 | — | — | — | |
Honeywell International Inc. | 85 | 74 | — | — | — | |
Lockheed Martin Corp. | 19 | 23 | — | — | — | |
RTX Corp. | 65 | 71 | — | — | — | |
Average Inventory Processing Period, Sector | ||||||
Capital Goods | 160 | 160 | — | — | — | |
Average Inventory Processing Period, Industry | ||||||
Industrials | 91 | 99 | — | — | — |
Based on: 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), 10-K (reporting date: 2017-12-31).
1 2021 Calculation
Average inventory processing period = 365 ÷ Inventory turnover
= 365 ÷ 2.18 = 167
2 Click competitor name to see calculations.
- Inventory Turnover
- The inventory turnover ratio exhibits a declining trend from 2017 to 2021. It decreased from 2.87 in 2017 to 2.18 in 2021, indicating a reduction in the frequency with which inventory is sold and replaced over the years.
- Average Inventory Processing Period
- The average inventory processing period shows an increasing trend during the same period. Beginning at 127 days in 2017, it rose to 167 days in 2021, reflecting longer durations on average before inventory is sold or used.
- Overall Analysis
- The simultaneous decrease in inventory turnover and increase in the average inventory processing period suggest that inventory management efficiency has weakened over the analyzed timeframe. The company appears to be holding onto inventory for extended periods, which may impact working capital and operational efficiency.
Average Receivable Collection Period
Dec 31, 2021 | Dec 31, 2020 | Dec 31, 2019 | Dec 31, 2018 | Dec 31, 2017 | ||
---|---|---|---|---|---|---|
Selected Financial Data | ||||||
Receivables turnover | 6.84 | 6.63 | 6.90 | 6.20 | 5.97 | |
Short-term Activity Ratio (no. days) | ||||||
Average receivable collection period1 | 53 | 55 | 53 | 59 | 61 | |
Benchmarks (no. days) | ||||||
Average Receivable Collection Period, Competitors2 | ||||||
Boeing Co. | 15 | 12 | — | — | — | |
Caterpillar Inc. | 64 | 68 | — | — | — | |
Eaton Corp. plc | 61 | 59 | — | — | — | |
GE Aerospace | 80 | 83 | — | — | — | |
Honeywell International Inc. | 72 | 76 | — | — | — | |
Lockheed Martin Corp. | 11 | 11 | — | — | — | |
RTX Corp. | 55 | 60 | — | — | — | |
Average Receivable Collection Period, Sector | ||||||
Capital Goods | 48 | 50 | — | — | — | |
Average Receivable Collection Period, Industry | ||||||
Industrials | 47 | 48 | — | — | — |
Based on: 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), 10-K (reporting date: 2017-12-31).
1 2021 Calculation
Average receivable collection period = 365 ÷ Receivables turnover
= 365 ÷ 6.84 = 53
2 Click competitor name to see calculations.
- Receivables Turnover
- The receivables turnover ratio demonstrates a generally increasing trend over the five-year period. Starting at 5.97 in 2017, the ratio gradually rises to 6.2 in 2018, then further improves to 6.9 in 2019. Although there is a slight dip to 6.63 in 2020, the ratio rebounds to 6.84 by the end of 2021. This pattern indicates an overall enhancement in the efficiency of the company's processes for collecting receivables during these years.
- Average Receivable Collection Period
- The average receivable collection period exhibits a decreasing trend, reflecting an improvement in the speed of converting receivables into cash. Beginning at 61 days in 2017, the period shortens to 59 days in 2018 and further declines notably to 53 days in 2019. There is a minor increase to 55 days in 2020, but the period decreases again to 53 days by 2021. This decrease, in line with the increase in receivables turnover, suggests more efficient credit management and collection practices.
Operating Cycle
Dec 31, 2021 | Dec 31, 2020 | Dec 31, 2019 | Dec 31, 2018 | Dec 31, 2017 | ||
---|---|---|---|---|---|---|
Selected Financial Data | ||||||
Average inventory processing period | 167 | 144 | 135 | 153 | 127 | |
Average receivable collection period | 53 | 55 | 53 | 59 | 61 | |
Short-term Activity Ratio | ||||||
Operating cycle1 | 220 | 199 | 188 | 212 | 188 | |
Benchmarks | ||||||
Operating Cycle, Competitors2 | ||||||
Boeing Co. | 501 | 479 | — | — | — | |
Caterpillar Inc. | 208 | 211 | — | — | — | |
Eaton Corp. plc | 143 | 121 | — | — | — | |
GE Aerospace | 187 | 179 | — | — | — | |
Honeywell International Inc. | 157 | 150 | — | — | — | |
Lockheed Martin Corp. | 30 | 34 | — | — | — | |
RTX Corp. | 120 | 131 | — | — | — | |
Operating Cycle, Sector | ||||||
Capital Goods | 208 | 210 | — | — | — | |
Operating Cycle, Industry | ||||||
Industrials | 138 | 147 | — | — | — |
Based on: 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), 10-K (reporting date: 2017-12-31).
1 2021 Calculation
Operating cycle = Average inventory processing period + Average receivable collection period
= 167 + 53 = 220
2 Click competitor name to see calculations.
- Average inventory processing period
- The average inventory processing period demonstrated a fluctuating yet overall increasing trend over the years under review. Starting at 127 days in 2017, it rose sharply to 153 days in 2018, then declined to 135 days in 2019. However, subsequent years saw a renewed increase, reaching 144 days in 2020 and peaking at 167 days in 2021. This suggests a lengthening duration for inventory turnover, which could indicate slower inventory movement or accumulation of stock over time.
- Average receivable collection period
- The average receivable collection period showed a mild decreasing trend from 61 days in 2017 to 53 days in 2021. After an initial slight decline to 59 days in 2018 and further reductions to 53 days in 2019, there was a minor increase to 55 days in 2020, followed by a return to 53 days in 2021. This illustrates a general improvement in the efficiency of receivables collection, with minor year-to-year variability.
- Operating cycle
- The operating cycle experienced an overall increasing pattern during the period analyzed. It began at 188 days in 2017, rose substantially to 212 days in 2018, then fell back to 188 days in 2019. From 2019 onwards, the operating cycle lengthened progressively to 199 days in 2020 and reached 220 days in 2021. This increase is primarily influenced by the lengthening inventory processing period, indicating a longer total cash conversion cycle and potential impact on working capital management.
Average Payables Payment Period
Dec 31, 2021 | Dec 31, 2020 | Dec 31, 2019 | Dec 31, 2018 | Dec 31, 2017 | ||
---|---|---|---|---|---|---|
Selected Financial Data | ||||||
Payables turnover | 3.53 | 4.63 | 5.37 | 3.96 | 4.67 | |
Short-term Activity Ratio (no. days) | ||||||
Average payables payment period1 | 104 | 79 | 68 | 92 | 78 | |
Benchmarks (no. days) | ||||||
Average Payables Payment Period, Competitors2 | ||||||
Boeing Co. | 57 | 74 | — | — | — | |
Caterpillar Inc. | 84 | 77 | — | — | — | |
Eaton Corp. plc | 77 | 58 | — | — | — | |
GE Aerospace | 110 | 100 | — | — | — | |
Honeywell International Inc. | 107 | 95 | — | — | — | |
Lockheed Martin Corp. | 5 | 6 | — | — | — | |
RTX Corp. | 62 | 66 | — | — | — | |
Average Payables Payment Period, Sector | ||||||
Capital Goods | 65 | 66 | — | — | — | |
Average Payables Payment Period, Industry | ||||||
Industrials | 47 | 49 | — | — | — |
Based on: 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), 10-K (reporting date: 2017-12-31).
1 2021 Calculation
Average payables payment period = 365 ÷ Payables turnover
= 365 ÷ 3.53 = 104
2 Click competitor name to see calculations.
The payables turnover ratio and average payables payment period exhibit fluctuating patterns over the five-year period ending in 2021.
- Payables Turnover Ratio
- The ratio started at 4.67 in 2017, decreased to 3.96 in 2018, rose significantly to 5.37 in 2019, then decreased again to 4.63 in 2020, and finally dropped further to 3.53 in 2021. This indicates variability in how frequently the company paid off its suppliers, with a peak efficiency in 2019 followed by a marked decline by 2021.
- Average Payables Payment Period (Days)
- The payment period exhibits an inverse trend relative to the turnover ratio. It was 78 days in 2017, increased to 92 days in 2018, then shortened significantly to 68 days in 2019. It lengthened again to 79 days in 2020 and extended further to 104 days in 2021. The rising payment period in the later years suggests the company took longer to settle its payables, with the longest period observed in 2021.
Overall, the data suggests that after achieving a higher payables turnover and a shorter payment period in 2019, the company’s payment efficiency declined in subsequent years, potentially reflecting changes in payment policies, liquidity management, or supplier terms that resulted in slower payments. The increase in the average payment period to over 100 days by 2021 highlights a significant extension in the time taken to pay suppliers.
Cash Conversion Cycle
Dec 31, 2021 | Dec 31, 2020 | Dec 31, 2019 | Dec 31, 2018 | Dec 31, 2017 | ||
---|---|---|---|---|---|---|
Selected Financial Data | ||||||
Average inventory processing period | 167 | 144 | 135 | 153 | 127 | |
Average receivable collection period | 53 | 55 | 53 | 59 | 61 | |
Average payables payment period | 104 | 79 | 68 | 92 | 78 | |
Short-term Activity Ratio | ||||||
Cash conversion cycle1 | 116 | 120 | 120 | 120 | 110 | |
Benchmarks | ||||||
Cash Conversion Cycle, Competitors2 | ||||||
Boeing Co. | 444 | 405 | — | — | — | |
Caterpillar Inc. | 124 | 134 | — | — | — | |
Eaton Corp. plc | 66 | 63 | — | — | — | |
GE Aerospace | 77 | 79 | — | — | — | |
Honeywell International Inc. | 50 | 55 | — | — | — | |
Lockheed Martin Corp. | 25 | 28 | — | — | — | |
RTX Corp. | 58 | 65 | — | — | — | |
Cash Conversion Cycle, Sector | ||||||
Capital Goods | 143 | 144 | — | — | — | |
Cash Conversion Cycle, Industry | ||||||
Industrials | 91 | 98 | — | — | — |
Based on: 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), 10-K (reporting date: 2017-12-31).
1 2021 Calculation
Cash conversion cycle = Average inventory processing period + Average receivable collection period – Average payables payment period
= 167 + 53 – 104 = 116
2 Click competitor name to see calculations.
- Average Inventory Processing Period
- The average inventory processing period shows an overall increasing trend from 127 days in 2017 to 167 days in 2021, indicating that the time taken to process inventory has lengthened by 40 days over the five-year span. This suggests a slower turnover of inventory, which may imply challenges in inventory management or changes in demand patterns.
- Average Receivable Collection Period
- The average receivable collection period exhibits a slight downward trend, decreasing from 61 days in 2017 to 53 days in 2021, with a minor fluctuation in 2020. This improvement indicates enhanced efficiency in collecting receivables, which can positively impact cash flow management.
- Average Payables Payment Period
- The average payables payment period demonstrates variability with an overall increase from 78 days in 2017 to 104 days in 2021. Notably, there was a dip in 2019 to 68 days, but the subsequent years show an increasing trend, which may reflect longer payment terms negotiated with suppliers or delayed payments to conserve cash.
- Cash Conversion Cycle
- The cash conversion cycle remains relatively stable, fluctuating narrowly between 110 and 120 days from 2017 to 2020, and slightly decreasing to 116 days in 2021. Despite changes in inventory and payables periods, the overall cycle duration shows minimal variation, indicating a consistent cash flow conversion timeframe over the years.