Analysis of Short-term (Operating) Activity Ratios
Quarterly Data
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)
Cummins Inc., short-term (operating) activity ratios (quarterly data)
Based on: 10-Q (reporting date: 2024-03-31), 10-K (reporting date: 2023-12-31), 10-Q (reporting date: 2023-09-30), 10-Q (reporting date: 2023-06-30), 10-Q (reporting date: 2023-03-31), 10-K (reporting date: 2022-12-31), 10-Q (reporting date: 2022-09-30), 10-Q (reporting date: 2022-06-30), 10-Q (reporting date: 2022-03-31), 10-K (reporting date: 2021-12-31), 10-Q (reporting date: 2021-10-03), 10-Q (reporting date: 2021-07-04), 10-Q (reporting date: 2021-04-04), 10-K (reporting date: 2020-12-31), 10-Q (reporting date: 2020-09-27), 10-Q (reporting date: 2020-06-28), 10-Q (reporting date: 2020-03-29).
- Inventory Turnover
- The inventory turnover ratio showed a declining trend from early 2020 through late 2022, decreasing from 4.7 to a low of 3.6. However, beginning in 2023, the ratio began to recover, rising steadily to 4.55 by the end of 2023 before slightly decreasing to 4.47 in early 2024. This indicates a gradual improvement in inventory management efficiency after a period of increased inventory holding.
- Receivables Turnover
- The receivables turnover ratio experienced a general decline from 6.44 in early 2020 to a low around 4.96 in the first quarter of 2021, suggesting slower collection of receivables during that time. From mid-2021 onwards, the ratio improved steadily, reaching 6.23 in the first quarter of 2024, indicating enhanced effectiveness in receivables collection over recent periods.
- Payables Turnover
- Payables turnover showed fluctuations but generally declined from 6.36 in early 2020 to around 4.82 in early 2021, implying longer payment periods to suppliers. A subsequent gradual improvement occurred through late 2021 and into 2023, with the ratio rising to peaks near 6.06 by late 2023, reflecting a return to faster payments. A slight reduction was noted in early 2024.
- Working Capital Turnover
- Working capital turnover registered a marked decline early in the dataset, dropping sharply from 8.04 to a low around 3.56 through late 2020. From 2021, a steady recovery was evident, with a significant peak at 14.84 in late 2023, before settling back to 8.65 in early 2024. This suggests the company achieved substantially higher utilization of working capital during this peak period, followed by normalization.
- Average Inventory Processing Period
- The average inventory processing period increased from 78 days at the start of 2020 to a peak of 101 days by late 2022, indicating slower inventory turnover and longer holding periods. A reversal occurred in 2023, with the period declining consistently to 80 days by late 2023 and slightly increasing to 82 days in early 2024, corresponding with the improvement in inventory turnover ratio.
- Average Receivable Collection Period
- The receivable collection period extended from 57 days in early 2020 to around 74 days in early 2021, implying longer credit terms or slower customer payments. Thereafter, a gradual decrease to 59 days occurred by early 2024, suggesting improved collection efficiency and tighter credit management.
- Operating Cycle
- The operating cycle lengthened from 135 days in early 2020 to a high near 165 days during 2022 and early 2023. It then steadily shortened to around 141 days by early 2024, indicating an overall improvement in the management of inventory and receivables after a period of extended cash conversion time.
- Average Payables Payment Period
- The average time to pay suppliers increased from 57 days to a peak of approximately 76 days during early 2021, reflecting possibly extended payment terms or delayed payments. Subsequently, the period decreased to around 60 days by late 2023, stabilizing near 63 days early in 2024.
- Cash Conversion Cycle
- The cash conversion cycle exhibited volatility, increasing from 78 days in early 2020 to a peak of 95 days in mid-2020, then fluctuating around low-90s until late 2022. From 2023 onward, there was a steady decline to 78 days by early 2024, signaling improved efficiency in converting resources into cash over this recent timeframe.
Turnover Ratios
Average No. Days
Inventory Turnover
Cummins Inc., inventory turnover calculation (quarterly data)
| Mar 31, 2024 | Dec 31, 2023 | Sep 30, 2023 | Jun 30, 2023 | Mar 31, 2023 | Dec 31, 2022 | Sep 30, 2022 | Jun 30, 2022 | Mar 31, 2022 | Dec 31, 2021 | Oct 3, 2021 | Jul 4, 2021 | Apr 4, 2021 | Dec 31, 2020 | Sep 27, 2020 | Jun 28, 2020 | Mar 29, 2020 | |||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Selected Financial Data (US$ in millions) | |||||||||||||||||||||||
| Cost of sales | 6,362) | 6,542) | 6,360) | 6,490) | 6,424) | 5,951) | 5,691) | 4,860) | 4,853) | 4,533) | 4,554) | 4,633) | 4,606) | 4,469) | 3,769) | 2,962) | 3,717) | ||||||
| Inventories | 5,758) | 5,677) | 5,906) | 6,026) | 5,878) | 5,603) | 5,543) | 4,765) | 4,586) | 4,355) | 4,322) | 4,076) | 3,753) | 3,425) | 3,470) | 3,655) | 3,579) | ||||||
| Short-term Activity Ratio | |||||||||||||||||||||||
| Inventory turnover1 | 4.47 | 4.55 | 4.27 | 4.08 | 3.90 | 3.81 | 3.60 | 3.95 | 4.05 | 4.21 | 4.23 | 4.29 | 4.21 | 4.36 | 4.24 | 4.16 | 4.70 | ||||||
| Benchmarks | |||||||||||||||||||||||
| Inventory Turnover, Competitors2 | |||||||||||||||||||||||
| Boeing Co. | 0.82 | 0.88 | 0.87 | 0.88 | 0.83 | 0.81 | 0.78 | 0.74 | 0.74 | 0.75 | 0.77 | 0.76 | 0.74 | — | — | — | — | ||||||
| Caterpillar Inc. | 2.50 | 2.58 | 2.47 | 2.42 | 2.38 | 2.54 | 2.36 | 2.40 | 2.46 | 2.53 | 2.44 | 2.49 | 2.46 | — | — | — | — | ||||||
| Eaton Corp. plc | 3.85 | 3.95 | 3.93 | 3.93 | 3.94 | 4.04 | 3.95 | 3.87 | 4.03 | 4.48 | 4.73 | 4.86 | 5.12 | — | — | — | — | ||||||
| GE Aerospace | 2.58 | 3.05 | 3.02 | 3.15 | 3.32 | 3.19 | 3.10 | 3.04 | 3.25 | 3.40 | 3.21 | 3.28 | 3.46 | — | — | — | — | ||||||
| Honeywell International Inc. | 3.65 | 3.72 | 3.76 | 3.82 | 3.90 | 4.04 | 4.09 | 4.06 | 4.20 | 4.55 | 4.72 | 4.88 | 4.85 | — | — | — | — | ||||||
| Lockheed Martin Corp. | 18.67 | 18.87 | 17.88 | 16.82 | 16.63 | 18.68 | 18.09 | 16.20 | 18.12 | 19.45 | 19.81 | 18.64 | 17.58 | — | — | — | — | ||||||
| RTX Corp. | 4.76 | 4.83 | 4.60 | 4.68 | 4.81 | 5.03 | 5.03 | 5.14 | 5.33 | 5.65 | 5.57 | 5.49 | 5.48 | — | — | — | — | ||||||
Based on: 10-Q (reporting date: 2024-03-31), 10-K (reporting date: 2023-12-31), 10-Q (reporting date: 2023-09-30), 10-Q (reporting date: 2023-06-30), 10-Q (reporting date: 2023-03-31), 10-K (reporting date: 2022-12-31), 10-Q (reporting date: 2022-09-30), 10-Q (reporting date: 2022-06-30), 10-Q (reporting date: 2022-03-31), 10-K (reporting date: 2021-12-31), 10-Q (reporting date: 2021-10-03), 10-Q (reporting date: 2021-07-04), 10-Q (reporting date: 2021-04-04), 10-K (reporting date: 2020-12-31), 10-Q (reporting date: 2020-09-27), 10-Q (reporting date: 2020-06-28), 10-Q (reporting date: 2020-03-29).
1 Q1 2024 Calculation
Inventory turnover
= (Cost of salesQ1 2024
+ Cost of salesQ4 2023
+ Cost of salesQ3 2023
+ Cost of salesQ2 2023)
÷ Inventories
= (6,362 + 6,542 + 6,360 + 6,490)
÷ 5,758 = 4.47
2 Click competitor name to see calculations.
The cost of sales exhibited fluctuations over the observed periods. Initially, it decreased from US$ 3,717 million to US$ 2,962 million by mid-2020, followed by a steady increase peaking around the end of 2022 at approximately US$ 5,951 million. The figure slightly declined but generally remained elevated into 2024, indicating rising expenses associated with sales activities over the recent quarters.
Inventories showed a gradual upward trend throughout the durations analyzed. Starting at roughly US$ 3,579 million, inventories increased in most quarters, reaching a high point near US$ 6,026 million by mid-2023 before a minor decline and stabilization around US$ 5,758 million by early 2024. This trend might suggest elevated stock levels or buildup of inventory consistent with production or demand expectations.
The inventory turnover ratio, representing how efficiently inventory is utilized or sold, declined from a ratio of 4.7 down to a low near 3.6 by late 2022. This reduction indicates slower movement or higher accumulation of inventory relative to sales during that period. Subsequently, a recovery is observable with the ratio climbing back up to approximately 4.55 in late 2023 and slightly declining to 4.47 by early 2024, suggesting some improvement in inventory management and sales efficiency in recent quarters.
- Cost of Sales
- Initial decline in early 2020 followed by a consistent rise to a peak in late 2022.
- Moderate decline and stabilization observed in 2023 and early 2024.
- The overall increase signals higher cost burdens related to sales activities over time.
- Inventories
- Steady increase over the period, demonstrating higher inventory holdings.
- Minor fluctuations with a peak around mid-2023 and slight decline thereafter.
- Implied buildup in inventory which may relate to production planning or demand anticipation.
- Inventory Turnover Ratio
- Declined from 4.7 to approximately 3.6 by late 2022, indicating slower inventory turnover.
- Improved thereafter, rising to about 4.55 and slightly dipping in early 2024.
- This suggests recent enhanced efficiency in inventory utilization or sales velocity.
Receivables Turnover
Cummins Inc., receivables turnover calculation (quarterly data)
| Mar 31, 2024 | Dec 31, 2023 | Sep 30, 2023 | Jun 30, 2023 | Mar 31, 2023 | Dec 31, 2022 | Sep 30, 2022 | Jun 30, 2022 | Mar 31, 2022 | Dec 31, 2021 | Oct 3, 2021 | Jul 4, 2021 | Apr 4, 2021 | Dec 31, 2020 | Sep 27, 2020 | Jun 28, 2020 | Mar 29, 2020 | |||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Selected Financial Data (US$ in millions) | |||||||||||||||||||||||
| Net sales | 8,403) | 8,543) | 8,431) | 8,638) | 8,453) | 7,770) | 7,333) | 6,586) | 6,385) | 5,850) | 5,968) | 6,111) | 6,092) | 5,830) | 5,118) | 3,852) | 5,011) | ||||||
| Accounts and notes receivable, net | 5,463) | 5,583) | 5,662) | 5,863) | 5,834) | 5,202) | 4,799) | 4,156) | 4,368) | 3,990) | 4,152) | 4,132) | 4,209) | 3,820) | 3,628) | 3,441) | 3,505) | ||||||
| Short-term Activity Ratio | |||||||||||||||||||||||
| Receivables turnover1 | 6.23 | 6.10 | 5.88 | 5.49 | 5.17 | 5.40 | 5.45 | 5.96 | 5.57 | 6.02 | 5.78 | 5.60 | 4.96 | 5.19 | 5.39 | 5.87 | 6.44 | ||||||
| Benchmarks | |||||||||||||||||||||||
| Receivables Turnover, Competitors2 | |||||||||||||||||||||||
| Boeing Co. | 25.83 | 29.37 | 24.99 | 24.99 | 24.65 | 26.46 | 22.98 | 20.27 | 25.37 | 23.58 | 27.95 | 24.76 | 23.97 | — | — | — | — | ||||||
| Caterpillar Inc. | 6.86 | 6.86 | 6.95 | 6.56 | 6.37 | 6.39 | 6.59 | 6.10 | 5.46 | 5.68 | 5.97 | 5.51 | 5.07 | — | — | — | — | ||||||
| Eaton Corp. plc | 5.06 | 5.18 | 5.07 | 5.01 | 5.05 | 5.09 | 5.28 | 5.15 | 5.39 | 5.95 | 5.75 | 5.72 | 5.79 | — | — | — | — | ||||||
| GE Aerospace | 3.90 | 4.17 | 4.61 | 4.67 | 5.00 | 4.09 | 4.19 | 4.39 | 4.43 | 4.55 | 4.83 | 4.74 | 4.59 | — | — | — | — | ||||||
| Honeywell International Inc. | 4.94 | 4.87 | 4.65 | 4.52 | 4.57 | 4.77 | 4.74 | 4.45 | 4.82 | 5.04 | 4.78 | 4.89 | 4.89 | — | — | — | — | ||||||
| Lockheed Martin Corp. | 30.86 | 31.69 | 28.14 | 19.67 | 25.61 | 26.34 | 26.06 | 18.87 | 26.02 | 34.15 | 29.27 | 25.59 | 29.81 | — | — | — | — | ||||||
| RTX Corp. | 6.91 | 6.36 | 6.67 | 7.13 | 6.81 | 7.36 | 7.15 | 6.28 | 7.15 | 6.66 | 6.69 | 6.99 | 6.03 | — | — | — | — | ||||||
Based on: 10-Q (reporting date: 2024-03-31), 10-K (reporting date: 2023-12-31), 10-Q (reporting date: 2023-09-30), 10-Q (reporting date: 2023-06-30), 10-Q (reporting date: 2023-03-31), 10-K (reporting date: 2022-12-31), 10-Q (reporting date: 2022-09-30), 10-Q (reporting date: 2022-06-30), 10-Q (reporting date: 2022-03-31), 10-K (reporting date: 2021-12-31), 10-Q (reporting date: 2021-10-03), 10-Q (reporting date: 2021-07-04), 10-Q (reporting date: 2021-04-04), 10-K (reporting date: 2020-12-31), 10-Q (reporting date: 2020-09-27), 10-Q (reporting date: 2020-06-28), 10-Q (reporting date: 2020-03-29).
1 Q1 2024 Calculation
Receivables turnover
= (Net salesQ1 2024
+ Net salesQ4 2023
+ Net salesQ3 2023
+ Net salesQ2 2023)
÷ Accounts and notes receivable, net
= (8,403 + 8,543 + 8,431 + 8,638)
÷ 5,463 = 6.23
2 Click competitor name to see calculations.
The financial data for the analyzed periods reveal several notable trends in sales, receivables, and efficiency ratios.
- Net Sales
- Net sales experienced fluctuations between March 2020 and March 2024, initially dropping in mid-2020 but recovering steadily thereafter. From a low point of approximately 3,852 million US dollars in June 2020, sales rose consistently through 2021 and 2022, reaching a peak above 8,600 million US dollars in mid-2023. The final quarter of the latest period shows a slight decline but remains substantially higher than early 2020 levels, indicating overall growth in revenue over the four-year span.
- Accounts and Notes Receivable, Net
- The net accounts and notes receivable values rose in parallel with the improving sales figures but showed some volatility. After a moderate increase from around 3,441 million US dollars in June 2020 to a peak over 5,800 million US dollars in early 2023, receivables slightly decreased towards the end of the period under review. The increase in receivables generally aligns with higher sales volumes, although the short-term drops in receivables towards the end of 2023 and early 2024 may suggest improved collections or changes in credit policies.
- Receivables Turnover Ratio
- The receivables turnover ratio, which measures the efficiency of credit and collection efforts, declined from 6.44 in March 2020 to a low near 4.96 in April 2021, coinciding with periods of reduced sales and increased receivables. Following this nadir, the ratio recovered progressively, exceeding 6.0 by late 2023 and early 2024. This rebound implies enhancements in managing receivables and faster collection cycles, possibly reflecting improved operational efficiency or changes in customer payment behavior.
Overall, the data demonstrates a recovery and expansion trend in sales following mid-2020 lows, accompanied by a general increase in receivables in support of higher revenues. The improvement in the receivables turnover ratio over the longer term suggests that the company has strengthened its credit management and collection practices, leading to more effective liquidity management as sales volumes grew.
Payables Turnover
Cummins Inc., payables turnover calculation (quarterly data)
| Mar 31, 2024 | Dec 31, 2023 | Sep 30, 2023 | Jun 30, 2023 | Mar 31, 2023 | Dec 31, 2022 | Sep 30, 2022 | Jun 30, 2022 | Mar 31, 2022 | Dec 31, 2021 | Oct 3, 2021 | Jul 4, 2021 | Apr 4, 2021 | Dec 31, 2020 | Sep 27, 2020 | Jun 28, 2020 | Mar 29, 2020 | |||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Selected Financial Data (US$ in millions) | |||||||||||||||||||||||
| Cost of sales | 6,362) | 6,542) | 6,360) | 6,490) | 6,424) | 5,951) | 5,691) | 4,860) | 4,853) | 4,533) | 4,554) | 4,633) | 4,606) | 4,469) | 3,769) | 2,962) | 3,717) | ||||||
| Accounts payable, principally trade | 4,476) | 4,260) | 4,262) | 4,308) | 4,636) | 4,252) | 4,000) | 3,405) | 3,497) | 3,021) | 3,210) | 3,172) | 3,279) | 2,820) | 2,597) | 2,281) | 2,648) | ||||||
| Short-term Activity Ratio | |||||||||||||||||||||||
| Payables turnover1 | 5.75 | 6.06 | 5.92 | 5.70 | 4.95 | 5.02 | 4.98 | 5.52 | 5.31 | 6.07 | 5.69 | 5.51 | 4.82 | 5.29 | 5.67 | 6.67 | 6.36 | ||||||
| Benchmarks | |||||||||||||||||||||||
| Payables Turnover, Competitors2 | |||||||||||||||||||||||
| Boeing Co. | 5.92 | 5.86 | 6.18 | 6.28 | 6.37 | 6.18 | 6.36 | 6.17 | 6.73 | 6.40 | 6.20 | 5.45 | 4.90 | — | — | — | — | ||||||
| Caterpillar Inc. | 5.44 | 5.41 | 5.54 | 5.09 | 4.68 | 4.76 | 4.81 | 4.72 | 4.43 | 4.36 | 4.61 | 4.57 | 4.46 | — | — | — | — | ||||||
| Eaton Corp. plc | 4.38 | 4.39 | 4.48 | 4.52 | 4.55 | 4.51 | 4.61 | 4.43 | 4.67 | 4.75 | 5.11 | 5.22 | 5.66 | — | — | — | — | ||||||
| GE Aerospace | 2.99 | 3.27 | 3.26 | 3.41 | 3.57 | 2.98 | 3.14 | 3.14 | 3.32 | 3.32 | 3.33 | 3.35 | 3.56 | — | — | — | — | ||||||
| Honeywell International Inc. | 3.57 | 3.36 | 3.51 | 3.49 | 3.50 | 3.53 | 3.68 | 3.63 | 3.66 | 3.61 | 3.83 | 3.76 | 3.86 | — | — | — | — | ||||||
| Lockheed Martin Corp. | 17.38 | 25.56 | 15.51 | 16.97 | 17.65 | 27.25 | 21.48 | 24.07 | 21.92 | 74.34 | 37.83 | 36.15 | 30.31 | — | — | — | — | ||||||
| RTX Corp. | 5.60 | 5.31 | 5.37 | 5.54 | 5.42 | 5.40 | 5.82 | 5.36 | 6.28 | 5.93 | 6.06 | 6.52 | 5.67 | — | — | — | — | ||||||
Based on: 10-Q (reporting date: 2024-03-31), 10-K (reporting date: 2023-12-31), 10-Q (reporting date: 2023-09-30), 10-Q (reporting date: 2023-06-30), 10-Q (reporting date: 2023-03-31), 10-K (reporting date: 2022-12-31), 10-Q (reporting date: 2022-09-30), 10-Q (reporting date: 2022-06-30), 10-Q (reporting date: 2022-03-31), 10-K (reporting date: 2021-12-31), 10-Q (reporting date: 2021-10-03), 10-Q (reporting date: 2021-07-04), 10-Q (reporting date: 2021-04-04), 10-K (reporting date: 2020-12-31), 10-Q (reporting date: 2020-09-27), 10-Q (reporting date: 2020-06-28), 10-Q (reporting date: 2020-03-29).
1 Q1 2024 Calculation
Payables turnover
= (Cost of salesQ1 2024
+ Cost of salesQ4 2023
+ Cost of salesQ3 2023
+ Cost of salesQ2 2023)
÷ Accounts payable, principally trade
= (6,362 + 6,542 + 6,360 + 6,490)
÷ 4,476 = 5.75
2 Click competitor name to see calculations.
The financial data reveals several notable trends related to cost of sales, accounts payable, and payables turnover over the examined periods.
- Cost of Sales
- Cost of sales initially declined from the first quarter of 2020 through the second quarter, reaching a low point in June 2020. Subsequently, it showed a rising trend, with some fluctuations, and peaked in the fourth quarter of 2022. Thereafter, although there was a slight decrease in the first quarter of 2023, the cost of sales surged again through mid-2023 before slightly dropping and then stabilizing by the first quarter of 2024. Overall, this metric has generally increased over the full period, more than doubling from the lowest point in mid-2020.
- Accounts Payable, Principally Trade
- Accounts payable exhibited a moderate rise over the entire timeframe. After a decrease from the first to the second quarter of 2020, accounts payable increased consistently with minor short-term fluctuations. The largest increases are seen from mid-2021 to the end of 2022, followed by some variability but generally maintaining elevated levels through the early part of 2024. This suggests a growing reliance on trade credit or extended payment timelines coinciding with increased cost of sales.
- Payables Turnover Ratio
- This ratio, which measures the efficiency of payments to suppliers, started relatively high in early 2020, indicating rapid payment cycles. It then declined sharply through 2020, reaching its lowest point in early 2021. Afterward, the ratio experienced some recovery, rising steadily through 2021 and early 2022 before fluctuating around a moderate level in subsequent quarters. By early 2024, the ratio remains lower than at the outset but shows signs of stabilization. This pattern suggests that payment velocity slowed during the height of the pandemic impact and its aftermath, with gradual improvement but not a full return to prior efficiency.
In summary, the data indicates expanding operational scale or inflationary pressures reflected in the rising cost of sales, accompanied by increasing accounts payable balances. The payables turnover ratio’s decline and partial recovery imply a shift towards longer payment terms or changes in supplier negotiations, possibly aimed at managing cash flows in a challenging economic environment.
Working Capital Turnover
Cummins Inc., working capital turnover calculation (quarterly data)
| Mar 31, 2024 | Dec 31, 2023 | Sep 30, 2023 | Jun 30, 2023 | Mar 31, 2023 | Dec 31, 2022 | Sep 30, 2022 | Jun 30, 2022 | Mar 31, 2022 | Dec 31, 2021 | Oct 3, 2021 | Jul 4, 2021 | Apr 4, 2021 | Dec 31, 2020 | Sep 27, 2020 | Jun 28, 2020 | Mar 29, 2020 | |||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Selected Financial Data (US$ in millions) | |||||||||||||||||||||||
| Current assets | 15,620) | 15,198) | 15,912) | 15,410) | 15,368) | 14,451) | 14,398) | 12,762) | 12,596) | 12,309) | 12,320) | 11,931) | 12,122) | 11,897) | 11,062) | 9,834) | 9,790) | ||||||
| Less: Current liabilities | 11,686) | 12,903) | 11,126) | 11,045) | 11,923) | 11,421) | 10,530) | 7,671) | 7,512) | 7,084) | 6,861) | 6,604) | 6,660) | 6,335) | 5,709) | 6,916) | 6,982) | ||||||
| Working capital | 3,934) | 2,295) | 4,786) | 4,365) | 3,445) | 3,030) | 3,868) | 5,091) | 5,084) | 5,225) | 5,459) | 5,327) | 5,462) | 5,562) | 5,353) | 2,918) | 2,808) | ||||||
| Net sales | 8,403) | 8,543) | 8,431) | 8,638) | 8,453) | 7,770) | 7,333) | 6,586) | 6,385) | 5,850) | 5,968) | 6,111) | 6,092) | 5,830) | 5,118) | 3,852) | 5,011) | ||||||
| Short-term Activity Ratio | |||||||||||||||||||||||
| Working capital turnover1 | 8.65 | 14.84 | 6.96 | 7.38 | 8.75 | 9.27 | 6.76 | 4.87 | 4.78 | 4.60 | 4.40 | 4.35 | 3.82 | 3.56 | 3.65 | 6.93 | 8.04 | ||||||
| Benchmarks | |||||||||||||||||||||||
| Working Capital Turnover, Competitors2 | |||||||||||||||||||||||
| Boeing Co. | 5.76 | 5.78 | 5.46 | 4.80 | 4.61 | 3.42 | 3.13 | 2.87 | 2.51 | 2.34 | 2.02 | 2.00 | 1.88 | — | — | — | — | ||||||
| Caterpillar Inc. | 5.64 | 5.23 | 4.27 | 5.29 | 4.25 | 4.62 | 4.35 | 3.93 | 3.83 | 3.54 | 2.87 | 2.80 | 2.52 | — | — | — | — | ||||||
| Eaton Corp. plc | 5.58 | 5.91 | 6.61 | 6.16 | 7.01 | 8.70 | 10.69 | — | — | 65.65 | 12.41 | 21.65 | 5.34 | — | — | — | — | ||||||
| GE Aerospace | 6.93 | 7.24 | 8.11 | 5.70 | 5.87 | 7.93 | 13.29 | 10.55 | 7.14 | 4.94 | 1.57 | 1.57 | 1.27 | — | — | — | — | ||||||
| Honeywell International Inc. | 3.37 | 7.39 | 5.98 | 5.16 | 7.79 | 7.03 | 7.91 | 8.84 | 8.07 | 5.86 | 5.94 | 4.52 | 4.27 | — | — | — | — | ||||||
| Lockheed Martin Corp. | 13.24 | 18.85 | 11.04 | 10.56 | 12.81 | 12.93 | 14.03 | 14.28 | 15.14 | 11.52 | 10.48 | 12.30 | 11.93 | — | — | — | — | ||||||
| RTX Corp. | 23.64 | 41.62 | 44.25 | 16.99 | 12.76 | 20.15 | 19.15 | 17.77 | 11.41 | 9.75 | 8.11 | 10.24 | 9.77 | — | — | — | — | ||||||
Based on: 10-Q (reporting date: 2024-03-31), 10-K (reporting date: 2023-12-31), 10-Q (reporting date: 2023-09-30), 10-Q (reporting date: 2023-06-30), 10-Q (reporting date: 2023-03-31), 10-K (reporting date: 2022-12-31), 10-Q (reporting date: 2022-09-30), 10-Q (reporting date: 2022-06-30), 10-Q (reporting date: 2022-03-31), 10-K (reporting date: 2021-12-31), 10-Q (reporting date: 2021-10-03), 10-Q (reporting date: 2021-07-04), 10-Q (reporting date: 2021-04-04), 10-K (reporting date: 2020-12-31), 10-Q (reporting date: 2020-09-27), 10-Q (reporting date: 2020-06-28), 10-Q (reporting date: 2020-03-29).
1 Q1 2024 Calculation
Working capital turnover
= (Net salesQ1 2024
+ Net salesQ4 2023
+ Net salesQ3 2023
+ Net salesQ2 2023)
÷ Working capital
= (8,403 + 8,543 + 8,431 + 8,638)
÷ 3,934 = 8.65
2 Click competitor name to see calculations.
The financial data exhibits notable fluctuations and trends across the examined periods.
- Working Capital
- The working capital displayed variability over time, initially rising from $2,808 million to a peak of $5,562 million in December 2020. Subsequently, it generally declined with intermittent increases, reaching a low of $2,295 million in December 2023 before partially recovering to $3,934 million by March 2024. This pattern indicates periods of capital efficiency fluctuation, potentially influenced by operational or market factors.
- Net Sales
- Net sales showed a general upward trend over the periods, increasing from $5,011 million in March 2020 to a peak near $8,638 million in June 2023. Minor fluctuations occurred towards the latter periods, with a slight decrease to $8,403 million by March 2024. The steady sales growth reflects a positive demand outlook or successful market expansion strategies.
- Working Capital Turnover
- Working capital turnover, calculated as the ratio of net sales to working capital, demonstrated significant volatility. Initially high at 8.04, it dropped to a low of 3.56 by December 2020, coinciding with the peak in working capital. Subsequently, turnover rose again, reaching an exceptional value of 14.84 in December 2023 when working capital was at its lowest. The ratio then normalized to 8.65 by March 2024. This inverse relationship suggests periods of either increased efficiency in asset utilization or potential liquidity tightening.
Collectively, the data suggests a dynamic environment with cycles of capital investment and optimization impacting working capital levels, alongside robust growth in sales. The inverse correlation between working capital and turnover underscores shifts in operational efficiency or capital allocation strategies over time.
Average Inventory Processing Period
Cummins Inc., average inventory processing period calculation (quarterly data)
| Mar 31, 2024 | Dec 31, 2023 | Sep 30, 2023 | Jun 30, 2023 | Mar 31, 2023 | Dec 31, 2022 | Sep 30, 2022 | Jun 30, 2022 | Mar 31, 2022 | Dec 31, 2021 | Oct 3, 2021 | Jul 4, 2021 | Apr 4, 2021 | Dec 31, 2020 | Sep 27, 2020 | Jun 28, 2020 | Mar 29, 2020 | |||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Selected Financial Data | |||||||||||||||||||||||
| Inventory turnover | 4.47 | 4.55 | 4.27 | 4.08 | 3.90 | 3.81 | 3.60 | 3.95 | 4.05 | 4.21 | 4.23 | 4.29 | 4.21 | 4.36 | 4.24 | 4.16 | 4.70 | ||||||
| Short-term Activity Ratio (no. days) | |||||||||||||||||||||||
| Average inventory processing period1 | 82 | 80 | 85 | 90 | 94 | 96 | 101 | 93 | 90 | 87 | 86 | 85 | 87 | 84 | 86 | 88 | 78 | ||||||
| Benchmarks (no. days) | |||||||||||||||||||||||
| Average Inventory Processing Period, Competitors2 | |||||||||||||||||||||||
| Boeing Co. | 443 | 415 | 419 | 416 | 438 | 452 | 468 | 494 | 493 | 486 | 475 | 478 | 496 | — | — | — | — | ||||||
| Caterpillar Inc. | 146 | 141 | 148 | 151 | 154 | 144 | 155 | 152 | 148 | 144 | 150 | 146 | 149 | — | — | — | — | ||||||
| Eaton Corp. plc | 95 | 92 | 93 | 93 | 93 | 90 | 92 | 94 | 90 | 82 | 77 | 75 | 71 | — | — | — | — | ||||||
| GE Aerospace | 141 | 120 | 121 | 116 | 110 | 114 | 118 | 120 | 112 | 107 | 114 | 111 | 105 | — | — | — | — | ||||||
| Honeywell International Inc. | 100 | 98 | 97 | 96 | 94 | 90 | 89 | 90 | 87 | 80 | 77 | 75 | 75 | — | — | — | — | ||||||
| Lockheed Martin Corp. | 20 | 19 | 20 | 22 | 22 | 20 | 20 | 23 | 20 | 19 | 18 | 20 | 21 | — | — | — | — | ||||||
| RTX Corp. | 77 | 76 | 79 | 78 | 76 | 73 | 73 | 71 | 69 | 65 | 65 | 66 | 67 | — | — | — | — | ||||||
Based on: 10-Q (reporting date: 2024-03-31), 10-K (reporting date: 2023-12-31), 10-Q (reporting date: 2023-09-30), 10-Q (reporting date: 2023-06-30), 10-Q (reporting date: 2023-03-31), 10-K (reporting date: 2022-12-31), 10-Q (reporting date: 2022-09-30), 10-Q (reporting date: 2022-06-30), 10-Q (reporting date: 2022-03-31), 10-K (reporting date: 2021-12-31), 10-Q (reporting date: 2021-10-03), 10-Q (reporting date: 2021-07-04), 10-Q (reporting date: 2021-04-04), 10-K (reporting date: 2020-12-31), 10-Q (reporting date: 2020-09-27), 10-Q (reporting date: 2020-06-28), 10-Q (reporting date: 2020-03-29).
1 Q1 2024 Calculation
Average inventory processing period = 365 ÷ Inventory turnover
= 365 ÷ 4.47 = 82
2 Click competitor name to see calculations.
The analysis of the inventory turnover ratio and the average inventory processing period over the specified quarterly periods reveals notable trends and fluctuations in inventory management efficiency.
- Inventory Turnover Ratio
- The inventory turnover ratio displays a general decline from 4.7 in the first quarter of 2020 down to a low of 3.6 in the third quarter of 2022, indicating slower inventory movement during this period. Subsequent quarters show a recovery trend, with the ratio rising steadily to 4.55 by the fourth quarter of 2023, before slightly declining to 4.47 in the first quarter of 2024. This suggests an initial period of reduced inventory efficiency, followed by gradual improvement towards more effective turnover rates.
- Average Inventory Processing Period
- The average inventory processing period inversely mirrors the trends observed in inventory turnover. It increases from 78 days in the first quarter of 2020, peaking at 101 days in the third quarter of 2022, indicating longer durations for inventory to be sold or used. Following this peak, a consistent reduction in processing period is observed, decreasing to 80 days in the fourth quarter of 2023, with a slight increase to 82 days in the latest quarter. This pattern confirms the initial extension in holding times before operational adjustments prompted improved inventory processing efficiency.
- Overall Insights
- The period from early 2020 to mid-2022 illustrates a phase of deteriorating inventory turnover and prolonged processing periods, likely reflecting challenges in demand, supply chain disruptions, or inventory management practices. Improvements from late 2022 onward highlight a strategic or operational response to these challenges, resulting in more efficient inventory handling. The relative stability and return of turnover metrics toward earlier levels suggest the company has taken measures to optimize inventory cycles, improving capital use and potentially impacting profitability positively.
Average Receivable Collection Period
Cummins Inc., average receivable collection period calculation (quarterly data)
| Mar 31, 2024 | Dec 31, 2023 | Sep 30, 2023 | Jun 30, 2023 | Mar 31, 2023 | Dec 31, 2022 | Sep 30, 2022 | Jun 30, 2022 | Mar 31, 2022 | Dec 31, 2021 | Oct 3, 2021 | Jul 4, 2021 | Apr 4, 2021 | Dec 31, 2020 | Sep 27, 2020 | Jun 28, 2020 | Mar 29, 2020 | |||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Selected Financial Data | |||||||||||||||||||||||
| Receivables turnover | 6.23 | 6.10 | 5.88 | 5.49 | 5.17 | 5.40 | 5.45 | 5.96 | 5.57 | 6.02 | 5.78 | 5.60 | 4.96 | 5.19 | 5.39 | 5.87 | 6.44 | ||||||
| Short-term Activity Ratio (no. days) | |||||||||||||||||||||||
| Average receivable collection period1 | 59 | 60 | 62 | 66 | 71 | 68 | 67 | 61 | 66 | 61 | 63 | 65 | 74 | 70 | 68 | 62 | 57 | ||||||
| Benchmarks (no. days) | |||||||||||||||||||||||
| Average Receivable Collection Period, Competitors2 | |||||||||||||||||||||||
| Boeing Co. | 14 | 12 | 15 | 15 | 15 | 14 | 16 | 18 | 14 | 15 | 13 | 15 | 15 | — | — | — | — | ||||||
| Caterpillar Inc. | 53 | 53 | 53 | 56 | 57 | 57 | 55 | 60 | 67 | 64 | 61 | 66 | 72 | — | — | — | — | ||||||
| Eaton Corp. plc | 72 | 70 | 72 | 73 | 72 | 72 | 69 | 71 | 68 | 61 | 63 | 64 | 63 | — | — | — | — | ||||||
| GE Aerospace | 93 | 87 | 79 | 78 | 73 | 89 | 87 | 83 | 82 | 80 | 76 | 77 | 80 | — | — | — | — | ||||||
| Honeywell International Inc. | 74 | 75 | 79 | 81 | 80 | 77 | 77 | 82 | 76 | 72 | 76 | 75 | 75 | — | — | — | — | ||||||
| Lockheed Martin Corp. | 12 | 12 | 13 | 19 | 14 | 14 | 14 | 19 | 14 | 11 | 12 | 14 | 12 | — | — | — | — | ||||||
| RTX Corp. | 53 | 57 | 55 | 51 | 54 | 50 | 51 | 58 | 51 | 55 | 55 | 52 | 61 | — | — | — | — | ||||||
Based on: 10-Q (reporting date: 2024-03-31), 10-K (reporting date: 2023-12-31), 10-Q (reporting date: 2023-09-30), 10-Q (reporting date: 2023-06-30), 10-Q (reporting date: 2023-03-31), 10-K (reporting date: 2022-12-31), 10-Q (reporting date: 2022-09-30), 10-Q (reporting date: 2022-06-30), 10-Q (reporting date: 2022-03-31), 10-K (reporting date: 2021-12-31), 10-Q (reporting date: 2021-10-03), 10-Q (reporting date: 2021-07-04), 10-Q (reporting date: 2021-04-04), 10-K (reporting date: 2020-12-31), 10-Q (reporting date: 2020-09-27), 10-Q (reporting date: 2020-06-28), 10-Q (reporting date: 2020-03-29).
1 Q1 2024 Calculation
Average receivable collection period = 365 ÷ Receivables turnover
= 365 ÷ 6.23 = 59
2 Click competitor name to see calculations.
The financial data reveals notable trends in the receivables management over the periods analyzed. The receivables turnover ratio exhibits fluctuations, indicating variability in the effectiveness of collections. Initially, there is a decline from 6.44 to a low of 4.96, followed by a recovery and gradual improvement, reaching a peak of 6.23 in the latest period. This suggests an improvement in the company’s ability to convert receivables into cash more frequently over time after a period of slower turnover.
Correspondingly, the average receivable collection period, measured in days, shows an inverse pattern relative to the turnover ratio. It begins at 57 days, increases to a high of 74 days, indicating longer collection times during that phase, then gradually decreases to 59 days by the most recent period. This reduction in days implies enhanced efficiency in collecting receivables in recent quarters.
Overall, the analysis points toward a period of initial deterioration in receivables management efficiency, followed by a consistent improvement. The recent quarters exhibit stronger collections performance, which is beneficial for cash flow and working capital management. Such trends could indicate refined credit policies or improved customer payment behavior over the analyzed timeframe.
Operating Cycle
Cummins Inc., operating cycle calculation (quarterly data)
No. days
| Mar 31, 2024 | Dec 31, 2023 | Sep 30, 2023 | Jun 30, 2023 | Mar 31, 2023 | Dec 31, 2022 | Sep 30, 2022 | Jun 30, 2022 | Mar 31, 2022 | Dec 31, 2021 | Oct 3, 2021 | Jul 4, 2021 | Apr 4, 2021 | Dec 31, 2020 | Sep 27, 2020 | Jun 28, 2020 | Mar 29, 2020 | |||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Selected Financial Data | |||||||||||||||||||||||
| Average inventory processing period | 82 | 80 | 85 | 90 | 94 | 96 | 101 | 93 | 90 | 87 | 86 | 85 | 87 | 84 | 86 | 88 | 78 | ||||||
| Average receivable collection period | 59 | 60 | 62 | 66 | 71 | 68 | 67 | 61 | 66 | 61 | 63 | 65 | 74 | 70 | 68 | 62 | 57 | ||||||
| Short-term Activity Ratio | |||||||||||||||||||||||
| Operating cycle1 | 141 | 140 | 147 | 156 | 165 | 164 | 168 | 154 | 156 | 148 | 149 | 150 | 161 | 154 | 154 | 150 | 135 | ||||||
| Benchmarks | |||||||||||||||||||||||
| Operating Cycle, Competitors2 | |||||||||||||||||||||||
| Boeing Co. | 457 | 427 | 434 | 431 | 453 | 466 | 484 | 512 | 507 | 501 | 488 | 493 | 511 | — | — | — | — | ||||||
| Caterpillar Inc. | 199 | 194 | 201 | 207 | 211 | 201 | 210 | 212 | 215 | 208 | 211 | 212 | 221 | — | — | — | — | ||||||
| Eaton Corp. plc | 167 | 162 | 165 | 166 | 165 | 162 | 161 | 165 | 158 | 143 | 140 | 139 | 134 | — | — | — | — | ||||||
| GE Aerospace | 234 | 207 | 200 | 194 | 183 | 203 | 205 | 203 | 194 | 187 | 190 | 188 | 185 | — | — | — | — | ||||||
| Honeywell International Inc. | 174 | 173 | 176 | 177 | 174 | 167 | 166 | 172 | 163 | 152 | 153 | 150 | 150 | — | — | — | — | ||||||
| Lockheed Martin Corp. | 32 | 31 | 33 | 41 | 36 | 34 | 34 | 42 | 34 | 30 | 30 | 34 | 33 | — | — | — | — | ||||||
| RTX Corp. | 130 | 133 | 134 | 129 | 130 | 123 | 124 | 129 | 120 | 120 | 120 | 118 | 128 | — | — | — | — | ||||||
Based on: 10-Q (reporting date: 2024-03-31), 10-K (reporting date: 2023-12-31), 10-Q (reporting date: 2023-09-30), 10-Q (reporting date: 2023-06-30), 10-Q (reporting date: 2023-03-31), 10-K (reporting date: 2022-12-31), 10-Q (reporting date: 2022-09-30), 10-Q (reporting date: 2022-06-30), 10-Q (reporting date: 2022-03-31), 10-K (reporting date: 2021-12-31), 10-Q (reporting date: 2021-10-03), 10-Q (reporting date: 2021-07-04), 10-Q (reporting date: 2021-04-04), 10-K (reporting date: 2020-12-31), 10-Q (reporting date: 2020-09-27), 10-Q (reporting date: 2020-06-28), 10-Q (reporting date: 2020-03-29).
1 Q1 2024 Calculation
Operating cycle = Average inventory processing period + Average receivable collection period
= 82 + 59 = 141
2 Click competitor name to see calculations.
The financial data reveals distinct patterns in the company's working capital management over the specified periods.
- Average Inventory Processing Period
-
This metric reflects the average time inventory remains before being sold. Initially, the period increased from 78 days to a peak around 101 days in late 2022. Subsequently, the trend reversed, declining steadily to a low of 80 days by the first quarter of 2024.
The early increase suggests a slowdown in inventory turnover, possibly due to supply chain disruptions or demand uncertainties, while the later decrease indicates an improvement in inventory management and more efficient turnover.
- Average Receivable Collection Period
-
The average time to collect receivables showed an overall upward trend from 57 days to a peak of 74 days around early 2021. After this peak, the period decreased consistently to 59 days by March 2024.
This pattern implies that the company initially experienced a longer delay in collecting payments, potentially due to extended payment terms or customer payment difficulties, but later tightened credit policies or improved collections efficiency.
- Operating Cycle
-
The operating cycle, representing the total time from inventory acquisition to cash collection, increased progressively from 135 days to a high of 168 days in third quarter 2022. From that point, a downward trend ensued, bringing the cycle down to approximately 140 days by early 2024.
The lengthening of the operating cycle in the earlier periods indicates a build-up of working capital tied up in inventory and receivables, potentially stressing liquidity. The subsequent reduction demonstrates enhanced operational efficiency and working capital management improvements.
In summary, the company faced elongation in inventory turnover and receivable collection times during the earlier period, contributing to a prolonged operating cycle. However, recent quarters show a reversal of these trends, signaling positive developments in operational efficiency and cash flow conversion.
Average Payables Payment Period
Cummins Inc., average payables payment period calculation (quarterly data)
| Mar 31, 2024 | Dec 31, 2023 | Sep 30, 2023 | Jun 30, 2023 | Mar 31, 2023 | Dec 31, 2022 | Sep 30, 2022 | Jun 30, 2022 | Mar 31, 2022 | Dec 31, 2021 | Oct 3, 2021 | Jul 4, 2021 | Apr 4, 2021 | Dec 31, 2020 | Sep 27, 2020 | Jun 28, 2020 | Mar 29, 2020 | |||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Selected Financial Data | |||||||||||||||||||||||
| Payables turnover | 5.75 | 6.06 | 5.92 | 5.70 | 4.95 | 5.02 | 4.98 | 5.52 | 5.31 | 6.07 | 5.69 | 5.51 | 4.82 | 5.29 | 5.67 | 6.67 | 6.36 | ||||||
| Short-term Activity Ratio (no. days) | |||||||||||||||||||||||
| Average payables payment period1 | 63 | 60 | 62 | 64 | 74 | 73 | 73 | 66 | 69 | 60 | 64 | 66 | 76 | 69 | 64 | 55 | 57 | ||||||
| Benchmarks (no. days) | |||||||||||||||||||||||
| Average Payables Payment Period, Competitors2 | |||||||||||||||||||||||
| Boeing Co. | 62 | 62 | 59 | 58 | 57 | 59 | 57 | 59 | 54 | 57 | 59 | 67 | 74 | — | — | — | — | ||||||
| Caterpillar Inc. | 67 | 67 | 66 | 72 | 78 | 77 | 76 | 77 | 82 | 84 | 79 | 80 | 82 | — | — | — | — | ||||||
| Eaton Corp. plc | 83 | 83 | 82 | 81 | 80 | 81 | 79 | 82 | 78 | 77 | 71 | 70 | 65 | — | — | — | — | ||||||
| GE Aerospace | 122 | 112 | 112 | 107 | 102 | 123 | 116 | 116 | 110 | 110 | 109 | 109 | 103 | — | — | — | — | ||||||
| Honeywell International Inc. | 102 | 109 | 104 | 105 | 104 | 103 | 99 | 101 | 100 | 101 | 95 | 97 | 95 | — | — | — | — | ||||||
| Lockheed Martin Corp. | 21 | 14 | 24 | 22 | 21 | 13 | 17 | 15 | 17 | 5 | 10 | 10 | 12 | — | — | — | — | ||||||
| RTX Corp. | 65 | 69 | 68 | 66 | 67 | 68 | 63 | 68 | 58 | 62 | 60 | 56 | 64 | — | — | — | — | ||||||
Based on: 10-Q (reporting date: 2024-03-31), 10-K (reporting date: 2023-12-31), 10-Q (reporting date: 2023-09-30), 10-Q (reporting date: 2023-06-30), 10-Q (reporting date: 2023-03-31), 10-K (reporting date: 2022-12-31), 10-Q (reporting date: 2022-09-30), 10-Q (reporting date: 2022-06-30), 10-Q (reporting date: 2022-03-31), 10-K (reporting date: 2021-12-31), 10-Q (reporting date: 2021-10-03), 10-Q (reporting date: 2021-07-04), 10-Q (reporting date: 2021-04-04), 10-K (reporting date: 2020-12-31), 10-Q (reporting date: 2020-09-27), 10-Q (reporting date: 2020-06-28), 10-Q (reporting date: 2020-03-29).
1 Q1 2024 Calculation
Average payables payment period = 365 ÷ Payables turnover
= 365 ÷ 5.75 = 63
2 Click competitor name to see calculations.
The analysis of the payables turnover ratio reveals a fluctuating pattern over the examined quarters. Initially, the ratio stood at 6.36 and showed an increase to 6.67 before experiencing a decline to a low of 4.82. Following this trough, a gradual recovery is observed with the ratio rising again, peaking at 6.07, then fluctuating moderately around values ranging between 4.95 and 6.06 in the most recent periods. This indicates variability in the efficiency with which the company manages its accounts payable, reflecting changes in the pace at which suppliers are paid.
Correspondingly, the average payables payment period demonstrates an inverse trajectory relative to the payables turnover. Beginning at 57 days in the earliest quarter, it extended to a maximum of 76 days, signaling a lengthening of the time taken to settle payables. This elongation suggests a potential strategic adjustment in payment practices or cash flow management. In the subsequent quarters, the payment period contracts gradually, falling back to approximately 60 to 63 days, indicating a partial normalization of payment timing.
When considered together, these trends suggest that the company's accounts payable management has experienced periods of both accelerated and decelerated payment flows. The elongated payment periods and reduced turnover ratio in certain intervals may point to either deliberate deferment of payments to maintain liquidity or variations in operating conditions affecting supplier payments. The recent trend towards stabilization in both metrics highlights an effort to balance payment terms with operational and financial objectives.
- Payables Turnover Ratio
- Shows variability with initial improvement, a pronounced dip mid-period, and moderate recovery thereafter, indicating fluctuating payment velocity.
- Average Payables Payment Period
- Initially increases significantly, implying longer payment durations, then gradually decreases, suggesting adjustment towards shorter payment cycles.
- Overall Insight
- These inverse but related movements reflect adaptive accounts payable management, balancing cash flow needs and supplier relationships over time.
Cash Conversion Cycle
Cummins Inc., cash conversion cycle calculation (quarterly data)
No. days
| Mar 31, 2024 | Dec 31, 2023 | Sep 30, 2023 | Jun 30, 2023 | Mar 31, 2023 | Dec 31, 2022 | Sep 30, 2022 | Jun 30, 2022 | Mar 31, 2022 | Dec 31, 2021 | Oct 3, 2021 | Jul 4, 2021 | Apr 4, 2021 | Dec 31, 2020 | Sep 27, 2020 | Jun 28, 2020 | Mar 29, 2020 | |||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Selected Financial Data | |||||||||||||||||||||||
| Average inventory processing period | 82 | 80 | 85 | 90 | 94 | 96 | 101 | 93 | 90 | 87 | 86 | 85 | 87 | 84 | 86 | 88 | 78 | ||||||
| Average receivable collection period | 59 | 60 | 62 | 66 | 71 | 68 | 67 | 61 | 66 | 61 | 63 | 65 | 74 | 70 | 68 | 62 | 57 | ||||||
| Average payables payment period | 63 | 60 | 62 | 64 | 74 | 73 | 73 | 66 | 69 | 60 | 64 | 66 | 76 | 69 | 64 | 55 | 57 | ||||||
| Short-term Activity Ratio | |||||||||||||||||||||||
| Cash conversion cycle1 | 78 | 80 | 85 | 92 | 91 | 91 | 95 | 88 | 87 | 88 | 85 | 84 | 85 | 85 | 90 | 95 | 78 | ||||||
| Benchmarks | |||||||||||||||||||||||
| Cash Conversion Cycle, Competitors2 | |||||||||||||||||||||||
| Boeing Co. | 395 | 365 | 375 | 373 | 396 | 407 | 427 | 453 | 453 | 444 | 429 | 426 | 437 | — | — | — | — | ||||||
| Caterpillar Inc. | 132 | 127 | 135 | 135 | 133 | 124 | 134 | 135 | 133 | 124 | 132 | 132 | 139 | — | — | — | — | ||||||
| Eaton Corp. plc | 84 | 79 | 83 | 85 | 85 | 81 | 82 | 83 | 80 | 66 | 69 | 69 | 69 | — | — | — | — | ||||||
| GE Aerospace | 112 | 95 | 88 | 87 | 81 | 80 | 89 | 87 | 84 | 77 | 81 | 79 | 82 | — | — | — | — | ||||||
| Honeywell International Inc. | 72 | 64 | 72 | 72 | 70 | 64 | 67 | 71 | 63 | 51 | 58 | 53 | 55 | — | — | — | — | ||||||
| Lockheed Martin Corp. | 11 | 17 | 9 | 19 | 15 | 21 | 17 | 27 | 17 | 25 | 20 | 24 | 21 | — | — | — | — | ||||||
| RTX Corp. | 65 | 64 | 66 | 63 | 63 | 55 | 61 | 61 | 62 | 58 | 60 | 62 | 64 | — | — | — | — | ||||||
Based on: 10-Q (reporting date: 2024-03-31), 10-K (reporting date: 2023-12-31), 10-Q (reporting date: 2023-09-30), 10-Q (reporting date: 2023-06-30), 10-Q (reporting date: 2023-03-31), 10-K (reporting date: 2022-12-31), 10-Q (reporting date: 2022-09-30), 10-Q (reporting date: 2022-06-30), 10-Q (reporting date: 2022-03-31), 10-K (reporting date: 2021-12-31), 10-Q (reporting date: 2021-10-03), 10-Q (reporting date: 2021-07-04), 10-Q (reporting date: 2021-04-04), 10-K (reporting date: 2020-12-31), 10-Q (reporting date: 2020-09-27), 10-Q (reporting date: 2020-06-28), 10-Q (reporting date: 2020-03-29).
1 Q1 2024 Calculation
Cash conversion cycle = Average inventory processing period + Average receivable collection period – Average payables payment period
= 82 + 59 – 63 = 78
2 Click competitor name to see calculations.
The financial data reveals notable trends in the company's working capital management, reflected through key metrics such as the average inventory processing period, receivable collection period, payables payment period, and the overall cash conversion cycle.
- Average Inventory Processing Period
- This metric shows an initial increase from 78 days to 88 days in the earlier quarters of 2020, indicating slower inventory turnover. Subsequently, it stabilized around the mid to high 80s before experiencing a gradual increase through 2022 to a peak at 101 days in the third quarter of 2022. From that point on, a downward trend is evident, declining to 80 days by the first quarter of 2024, suggesting improved inventory management and faster processing.
- Average Receivable Collection Period
- The collection period initially lengthened significantly from 57 to 74 days between early 2020 and the first quarter of 2021, implying slower receivables turnover. Following this peak, a gradual reduction occurred, dropping to 59 days by the first quarter of 2024. This pattern reflects an improvement in the company's efficiency in collecting receivables over the most recent periods.
- Average Payables Payment Period
- The payable period demonstrates fluctuations, rising from 57 days in early 2020 to a high of approximately 76 days in early 2021, followed by a decline towards 60 days by mid-2023. This suggests an initial extension in payment terms, potentially to conserve cash, with later tightening of payment periods. The most recent data point shows a slight increase back to 63 days.
- Cash Conversion Cycle
- This key indicator reflects the net time span between cash outflows and inflows. It increased from 78 days to a peak of 95 days in mid-2020, then fluctuated around the high 80s to mid-90s before demonstrating a downward trajectory starting late 2022. By the first quarter of 2024, the cycle had decreased to 78 days, mirroring the improvements in inventory and receivables management. The reduction in the cash conversion cycle suggests enhanced liquidity and operational efficiency.
Overall, the data indicates that the company experienced a temporary slowdown in working capital efficiency, primarily during the earlier phases of 2020 and mid-2022, with extended inventory holding and receivable collection periods. However, there has been a sustained recovery trend over the last several quarters, marked by shortened inventory and receivables periods and a declining cash conversion cycle. This points to more effective management of cash flows and operating assets, potentially strengthening the company’s financial flexibility.