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-Q (reporting date: 2024-03-31), 10-Q (reporting date: 2023-12-31), 10-K (reporting date: 2023-09-30), 10-Q (reporting date: 2023-06-30), 10-Q (reporting date: 2023-03-31), 10-Q (reporting date: 2022-12-31), 10-K (reporting date: 2022-09-30), 10-Q (reporting date: 2022-06-30), 10-Q (reporting date: 2022-03-31), 10-Q (reporting date: 2021-12-31), 10-K (reporting date: 2021-09-30), 10-Q (reporting date: 2021-06-30), 10-Q (reporting date: 2021-03-31), 10-Q (reporting date: 2020-12-31), 10-K (reporting date: 2020-09-30), 10-Q (reporting date: 2020-06-30), 10-Q (reporting date: 2020-03-31), 10-Q (reporting date: 2019-12-31), 10-K (reporting date: 2019-09-30), 10-Q (reporting date: 2019-06-30), 10-Q (reporting date: 2019-03-31), 10-Q (reporting date: 2018-12-31), 10-K (reporting date: 2018-09-30), 10-Q (reporting date: 2018-06-30), 10-Q (reporting date: 2018-03-31), 10-Q (reporting date: 2017-12-31).
Short-term activity ratio | Description | The company |
---|---|---|
Inventory turnover | An activity ratio calculated as cost of goods sold divided by inventory. | Johnson Controls International plc inventory turnover ratio deteriorated from Q4 2023 to Q1 2024 but then slightly improved from Q1 2024 to Q2 2024. |
Receivables turnover | An activity ratio equal to revenue divided by receivables. | Johnson Controls International plc receivables turnover ratio deteriorated from Q4 2023 to Q1 2024 and from Q1 2024 to Q2 2024. |
Payables turnover | An activity ratio calculated as cost of goods sold divided by payables. | Johnson Controls International plc payables turnover ratio increased from Q4 2023 to Q1 2024 but then slightly decreased from Q1 2024 to Q2 2024. |
Short-term activity ratio | Description | The company |
---|---|---|
Average inventory processing period | An activity ratio equal to the number of days in the period divided by inventory turnover over the period. | |
Average receivable collection period | An activity ratio equal to the number of days in the period divided by receivables turnover. | |
Operating cycle | Equal to average inventory processing period plus average receivables collection period. | Johnson Controls International plc operating cycle deteriorated from Q4 2023 to Q1 2024 and from Q1 2024 to Q2 2024. |
Average payables payment period | An estimate of the average number of days it takes a company to pay its suppliers; equal to the number of days in the period divided by payables turnover ratio for the period. | |
Cash conversion cycle | A financial metric that measures the length of time required for a company to convert cash invested in its operations to cash received as a result of its operations; equal to average inventory processing period plus average receivables collection period minus average payables payment period. | Johnson Controls International plc cash conversion cycle deteriorated from Q4 2023 to Q1 2024 and from Q1 2024 to Q2 2024. |
Inventory Turnover
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 | Sep 30, 2021 | Jun 30, 2021 | Mar 31, 2021 | Dec 31, 2020 | Sep 30, 2020 | Jun 30, 2020 | Mar 31, 2020 | Dec 31, 2019 | Sep 30, 2019 | Jun 30, 2019 | Mar 31, 2019 | Dec 31, 2018 | Sep 30, 2018 | Jun 30, 2018 | Mar 31, 2018 | Dec 31, 2017 | |||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
Selected Financial Data (US$ in millions) | ||||||||||||||||||||||||||||||||||
Cost of sales | 4,518) | 4,102) | 4,698) | 4,702) | 4,445) | 3,977) | 4,430) | 4,414) | 4,141) | 3,971) | 4,201) | 4,144) | 3,651) | 3,613) | 3,979) | 3,511) | 3,643) | 3,773) | 4,294) | 4,307) | 3,935) | 3,739) | 5,851) | 5,648) | 5,255) | 5,266) | ||||||||
Inventories | 2,991) | 3,006) | 2,776) | 3,092) | 3,048) | 2,895) | 2,510) | 2,574) | 2,515) | 2,425) | 2,057) | 2,064) | 1,994) | 1,913) | 1,773) | 1,996) | 2,030) | 1,953) | 1,814) | 2,050) | 2,124) | 2,027) | 3,224) | 3,509) | 3,565) | 3,459) | ||||||||
Short-term Activity Ratio | ||||||||||||||||||||||||||||||||||
Inventory turnover1 | 6.02 | 5.97 | 6.42 | 5.68 | 5.66 | 5.86 | 6.76 | 6.50 | 6.54 | 6.58 | 7.59 | 7.45 | 7.40 | 7.71 | 8.41 | 7.63 | 7.89 | 8.35 | 8.97 | 8.70 | 9.03 | 10.11 | 6.83 | — | — | — | ||||||||
Benchmarks | ||||||||||||||||||||||||||||||||||
Inventory Turnover, Competitors2 | ||||||||||||||||||||||||||||||||||
Boeing Co. | 0.78 | 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 | 0.78 | — | — | — | — | — | — | — | — | — | — | — | ||||||||
Caterpillar Inc. | 2.42 | 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 | 2.55 | — | — | — | — | — | — | — | — | — | — | — | ||||||||
Eaton Corp. plc | 3.81 | 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 | 5.88 | — | — | — | — | — | — | — | — | — | — | — | ||||||||
GE Aerospace | 4.08 | 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 | 3.80 | — | — | — | — | — | — | — | — | — | — | — | ||||||||
Honeywell International Inc. | 3.69 | 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 | 4.94 | — | — | — | — | — | — | — | — | — | — | — | ||||||||
Lockheed Martin Corp. | 20.21 | 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 | 16.01 | — | — | — | — | — | — | — | — | — | — | — | ||||||||
RTX Corp. | 4.64 | 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 | 5.11 | — | — | — | — | — | — | — | — | — | — | — |
Based on: 10-Q (reporting date: 2024-03-31), 10-Q (reporting date: 2023-12-31), 10-K (reporting date: 2023-09-30), 10-Q (reporting date: 2023-06-30), 10-Q (reporting date: 2023-03-31), 10-Q (reporting date: 2022-12-31), 10-K (reporting date: 2022-09-30), 10-Q (reporting date: 2022-06-30), 10-Q (reporting date: 2022-03-31), 10-Q (reporting date: 2021-12-31), 10-K (reporting date: 2021-09-30), 10-Q (reporting date: 2021-06-30), 10-Q (reporting date: 2021-03-31), 10-Q (reporting date: 2020-12-31), 10-K (reporting date: 2020-09-30), 10-Q (reporting date: 2020-06-30), 10-Q (reporting date: 2020-03-31), 10-Q (reporting date: 2019-12-31), 10-K (reporting date: 2019-09-30), 10-Q (reporting date: 2019-06-30), 10-Q (reporting date: 2019-03-31), 10-Q (reporting date: 2018-12-31), 10-K (reporting date: 2018-09-30), 10-Q (reporting date: 2018-06-30), 10-Q (reporting date: 2018-03-31), 10-Q (reporting date: 2017-12-31).
1 Q2 2024 Calculation
Inventory turnover
= (Cost of salesQ2 2024
+ Cost of salesQ1 2024
+ Cost of salesQ4 2023
+ Cost of salesQ3 2023)
÷ Inventories
= (4,518 + 4,102 + 4,698 + 4,702)
÷ 2,991 = 6.02
2 Click competitor name to see calculations.
Short-term activity ratio | Description | The company |
---|---|---|
Inventory turnover | An activity ratio calculated as cost of goods sold divided by inventory. | Johnson Controls International plc inventory turnover ratio deteriorated from Q4 2023 to Q1 2024 but then slightly improved from Q1 2024 to Q2 2024. |
Receivables Turnover
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 | Sep 30, 2021 | Jun 30, 2021 | Mar 31, 2021 | Dec 31, 2020 | Sep 30, 2020 | Jun 30, 2020 | Mar 31, 2020 | Dec 31, 2019 | Sep 30, 2019 | Jun 30, 2019 | Mar 31, 2019 | Dec 31, 2018 | Sep 30, 2018 | Jun 30, 2018 | Mar 31, 2018 | Dec 31, 2017 | |||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
Selected Financial Data (US$ in millions) | ||||||||||||||||||||||||||||||||||
Net sales | 6,699) | 6,094) | 6,906) | 7,133) | 6,686) | 6,068) | 6,725) | 6,614) | 6,098) | 5,862) | 6,392) | 6,341) | 5,594) | 5,341) | 5,954) | 5,343) | 5,444) | 5,576) | 6,274) | 6,451) | 5,779) | 5,464) | 8,370) | 8,120) | 7,475) | 7,435) | ||||||||
Accounts receivable, less allowance for expected credit losses | 6,688) | 6,045) | 6,006) | 6,540) | 6,002) | 5,722) | 5,528) | 5,850) | 5,689) | 5,671) | 5,613) | 5,668) | 5,167) | 5,177) | 5,294) | 5,344) | 5,492) | 5,612) | 5,770) | 6,033) | 5,707) | 5,442) | 7,065) | 6,895) | 6,679) | 6,731) | ||||||||
Short-term Activity Ratio | ||||||||||||||||||||||||||||||||||
Receivables turnover1 | 4.01 | 4.44 | 4.46 | 4.07 | 4.35 | 4.46 | 4.58 | 4.27 | 4.34 | 4.27 | 4.22 | 4.10 | 4.30 | 4.27 | 4.22 | 4.24 | 4.32 | 4.29 | 4.15 | 4.32 | 4.86 | 5.41 | 4.44 | — | — | — | ||||||||
Benchmarks | ||||||||||||||||||||||||||||||||||
Receivables Turnover, Competitors2 | ||||||||||||||||||||||||||||||||||
Boeing Co. | 23.31 | 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 | 29.75 | — | — | — | — | — | — | — | — | — | — | — | ||||||||
Caterpillar Inc. | 6.69 | 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 | 5.33 | — | — | — | — | — | — | — | — | — | — | — | ||||||||
Eaton Corp. plc | 4.97 | 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 | 6.15 | — | — | — | — | — | — | — | — | — | — | — | ||||||||
GE Aerospace | 6.13 | 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 | 4.37 | — | — | — | — | — | — | — | — | — | — | — | ||||||||
Honeywell International Inc. | 4.81 | 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 | 4.78 | — | — | — | — | — | — | — | — | — | — | — | ||||||||
Lockheed Martin Corp. | 24.26 | 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 | 33.06 | — | — | — | — | — | — | — | — | — | — | — | ||||||||
RTX Corp. | 7.06 | 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 | 6.11 | — | — | — | — | — | — | — | — | — | — | — |
Based on: 10-Q (reporting date: 2024-03-31), 10-Q (reporting date: 2023-12-31), 10-K (reporting date: 2023-09-30), 10-Q (reporting date: 2023-06-30), 10-Q (reporting date: 2023-03-31), 10-Q (reporting date: 2022-12-31), 10-K (reporting date: 2022-09-30), 10-Q (reporting date: 2022-06-30), 10-Q (reporting date: 2022-03-31), 10-Q (reporting date: 2021-12-31), 10-K (reporting date: 2021-09-30), 10-Q (reporting date: 2021-06-30), 10-Q (reporting date: 2021-03-31), 10-Q (reporting date: 2020-12-31), 10-K (reporting date: 2020-09-30), 10-Q (reporting date: 2020-06-30), 10-Q (reporting date: 2020-03-31), 10-Q (reporting date: 2019-12-31), 10-K (reporting date: 2019-09-30), 10-Q (reporting date: 2019-06-30), 10-Q (reporting date: 2019-03-31), 10-Q (reporting date: 2018-12-31), 10-K (reporting date: 2018-09-30), 10-Q (reporting date: 2018-06-30), 10-Q (reporting date: 2018-03-31), 10-Q (reporting date: 2017-12-31).
1 Q2 2024 Calculation
Receivables turnover
= (Net salesQ2 2024
+ Net salesQ1 2024
+ Net salesQ4 2023
+ Net salesQ3 2023)
÷ Accounts receivable, less allowance for expected credit losses
= (6,699 + 6,094 + 6,906 + 7,133)
÷ 6,688 = 4.01
2 Click competitor name to see calculations.
Short-term activity ratio | Description | The company |
---|---|---|
Receivables turnover | An activity ratio equal to revenue divided by receivables. | Johnson Controls International plc receivables turnover ratio deteriorated from Q4 2023 to Q1 2024 and from Q1 2024 to Q2 2024. |
Payables Turnover
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 | Sep 30, 2021 | Jun 30, 2021 | Mar 31, 2021 | Dec 31, 2020 | Sep 30, 2020 | Jun 30, 2020 | Mar 31, 2020 | Dec 31, 2019 | Sep 30, 2019 | Jun 30, 2019 | Mar 31, 2019 | Dec 31, 2018 | Sep 30, 2018 | Jun 30, 2018 | Mar 31, 2018 | Dec 31, 2017 | |||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
Selected Financial Data (US$ in millions) | ||||||||||||||||||||||||||||||||||
Cost of sales | 4,518) | 4,102) | 4,698) | 4,702) | 4,445) | 3,977) | 4,430) | 4,414) | 4,141) | 3,971) | 4,201) | 4,144) | 3,651) | 3,613) | 3,979) | 3,511) | 3,643) | 3,773) | 4,294) | 4,307) | 3,935) | 3,739) | 5,851) | 5,648) | 5,255) | 5,266) | ||||||||
Accounts payable | 4,019) | 3,976) | 4,268) | 4,296) | 4,348) | 4,138) | 4,241) | 4,125) | 4,101) | 4,083) | 3,746) | 3,719) | 3,417) | 3,210) | 3,120) | 3,057) | 3,119) | 3,336) | 3,582) | 3,671) | 3,482) | 3,273) | 4,644) | 4,410) | 4,250) | 4,020) | ||||||||
Short-term Activity Ratio | ||||||||||||||||||||||||||||||||||
Payables turnover1 | 4.48 | 4.51 | 4.18 | 4.09 | 3.97 | 4.10 | 4.00 | 4.06 | 4.01 | 3.91 | 4.17 | 4.14 | 4.32 | 4.59 | 4.78 | 4.98 | 5.14 | 4.89 | 4.54 | 4.86 | 5.51 | 6.26 | 4.74 | — | — | — | ||||||||
Benchmarks | ||||||||||||||||||||||||||||||||||
Payables Turnover, Competitors2 | ||||||||||||||||||||||||||||||||||
Boeing Co. | 5.61 | 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 | 4.94 | — | — | — | — | — | — | — | — | — | — | — | ||||||||
Caterpillar Inc. | 5.47 | 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 | 4.75 | — | — | — | — | — | — | — | — | — | — | — | ||||||||
Eaton Corp. plc | 4.31 | 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 | 6.24 | — | — | — | — | — | — | — | — | — | — | — | ||||||||
GE Aerospace | 5.01 | 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 | 3.67 | — | — | — | — | — | — | — | — | — | — | — | ||||||||
Honeywell International Inc. | 3.60 | 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 | 3.86 | — | — | — | — | — | — | — | — | — | — | — | ||||||||
Lockheed Martin Corp. | 19.07 | 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 | 64.48 | — | — | — | — | — | — | — | — | — | — | — | ||||||||
RTX Corp. | 5.54 | 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 | 5.56 | — | — | — | — | — | — | — | — | — | — | — |
Based on: 10-Q (reporting date: 2024-03-31), 10-Q (reporting date: 2023-12-31), 10-K (reporting date: 2023-09-30), 10-Q (reporting date: 2023-06-30), 10-Q (reporting date: 2023-03-31), 10-Q (reporting date: 2022-12-31), 10-K (reporting date: 2022-09-30), 10-Q (reporting date: 2022-06-30), 10-Q (reporting date: 2022-03-31), 10-Q (reporting date: 2021-12-31), 10-K (reporting date: 2021-09-30), 10-Q (reporting date: 2021-06-30), 10-Q (reporting date: 2021-03-31), 10-Q (reporting date: 2020-12-31), 10-K (reporting date: 2020-09-30), 10-Q (reporting date: 2020-06-30), 10-Q (reporting date: 2020-03-31), 10-Q (reporting date: 2019-12-31), 10-K (reporting date: 2019-09-30), 10-Q (reporting date: 2019-06-30), 10-Q (reporting date: 2019-03-31), 10-Q (reporting date: 2018-12-31), 10-K (reporting date: 2018-09-30), 10-Q (reporting date: 2018-06-30), 10-Q (reporting date: 2018-03-31), 10-Q (reporting date: 2017-12-31).
1 Q2 2024 Calculation
Payables turnover
= (Cost of salesQ2 2024
+ Cost of salesQ1 2024
+ Cost of salesQ4 2023
+ Cost of salesQ3 2023)
÷ Accounts payable
= (4,518 + 4,102 + 4,698 + 4,702)
÷ 4,019 = 4.48
2 Click competitor name to see calculations.
Short-term activity ratio | Description | The company |
---|---|---|
Payables turnover | An activity ratio calculated as cost of goods sold divided by payables. | Johnson Controls International plc payables turnover ratio increased from Q4 2023 to Q1 2024 but then slightly decreased from Q1 2024 to Q2 2024. |
Working Capital Turnover
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 | Sep 30, 2021 | Jun 30, 2021 | Mar 31, 2021 | Dec 31, 2020 | Sep 30, 2020 | Jun 30, 2020 | Mar 31, 2020 | Dec 31, 2019 | Sep 30, 2019 | Jun 30, 2019 | Mar 31, 2019 | Dec 31, 2018 | Sep 30, 2018 | Jun 30, 2018 | Mar 31, 2018 | Dec 31, 2017 | |||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
Selected Financial Data (US$ in millions) | ||||||||||||||||||||||||||||||||||
Current assets | 11,877) | 12,054) | 10,737) | 12,006) | 12,756) | 11,837) | 11,685) | 11,559) | 11,612) | 10,353) | 9,998) | 10,310) | 10,204) | 10,034) | 10,053) | 11,140) | 9,955) | 11,320) | 12,393) | 13,042) | 12,836) | 11,955) | 11,823) | 12,465) | 12,271) | 12,429) | ||||||||
Less: Current liabilities | 13,599) | 12,409) | 11,084) | 11,128) | 12,403) | 11,563) | 11,239) | 11,883) | 11,654) | 9,987) | 9,098) | 9,285) | 8,740) | 8,486) | 8,248) | 10,304) | 9,509) | 9,692) | 9,070) | 9,242) | 13,441) | 11,653) | 11,250) | 11,301) | 10,992) | 11,246) | ||||||||
Working capital | (1,722) | (355) | (347) | 878) | 353) | 274) | 446) | (324) | (42) | 366) | 900) | 1,025) | 1,464) | 1,548) | 1,805) | 836) | 446) | 1,628) | 3,323) | 3,800) | (605) | 302) | 573) | 1,164) | 1,279) | 1,183) | ||||||||
Net sales | 6,699) | 6,094) | 6,906) | 7,133) | 6,686) | 6,068) | 6,725) | 6,614) | 6,098) | 5,862) | 6,392) | 6,341) | 5,594) | 5,341) | 5,954) | 5,343) | 5,444) | 5,576) | 6,274) | 6,451) | 5,779) | 5,464) | 8,370) | 8,120) | 7,475) | 7,435) | ||||||||
Short-term Activity Ratio | ||||||||||||||||||||||||||||||||||
Working capital turnover1 | — | — | — | 30.31 | 73.92 | 93.08 | 56.72 | — | — | 66.09 | 26.30 | 22.66 | 15.19 | 14.26 | 12.36 | 27.08 | 53.24 | 14.79 | 7.21 | 6.86 | — | 97.45 | 54.80 | — | — | — | ||||||||
Benchmarks | ||||||||||||||||||||||||||||||||||
Working Capital Turnover, Competitors2 | ||||||||||||||||||||||||||||||||||
Boeing Co. | 4.13 | 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 | 1.69 | — | — | — | — | — | — | — | — | — | — | — | ||||||||
Caterpillar Inc. | 6.61 | 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 | 2.84 | — | — | — | — | — | — | — | — | — | — | — | ||||||||
Eaton Corp. plc | 5.33 | 5.58 | 5.91 | 6.61 | 6.16 | 7.01 | 8.70 | 10.69 | — | — | 65.65 | 12.41 | 21.65 | 5.34 | 5.42 | — | — | — | — | — | — | — | — | — | — | — | ||||||||
GE Aerospace | 11.15 | 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 | 2.26 | — | — | — | — | — | — | — | — | — | — | — | ||||||||
Honeywell International Inc. | 8.63 | 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 | 3.64 | — | — | — | — | — | — | — | — | — | — | — | ||||||||
Lockheed Martin Corp. | 15.88 | 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 | 12.01 | — | — | — | — | — | — | — | — | — | — | — | ||||||||
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 | 7.52 | — | — | — | — | — | — | — | — | — | — | — |
Based on: 10-Q (reporting date: 2024-03-31), 10-Q (reporting date: 2023-12-31), 10-K (reporting date: 2023-09-30), 10-Q (reporting date: 2023-06-30), 10-Q (reporting date: 2023-03-31), 10-Q (reporting date: 2022-12-31), 10-K (reporting date: 2022-09-30), 10-Q (reporting date: 2022-06-30), 10-Q (reporting date: 2022-03-31), 10-Q (reporting date: 2021-12-31), 10-K (reporting date: 2021-09-30), 10-Q (reporting date: 2021-06-30), 10-Q (reporting date: 2021-03-31), 10-Q (reporting date: 2020-12-31), 10-K (reporting date: 2020-09-30), 10-Q (reporting date: 2020-06-30), 10-Q (reporting date: 2020-03-31), 10-Q (reporting date: 2019-12-31), 10-K (reporting date: 2019-09-30), 10-Q (reporting date: 2019-06-30), 10-Q (reporting date: 2019-03-31), 10-Q (reporting date: 2018-12-31), 10-K (reporting date: 2018-09-30), 10-Q (reporting date: 2018-06-30), 10-Q (reporting date: 2018-03-31), 10-Q (reporting date: 2017-12-31).
1 Q2 2024 Calculation
Working capital turnover
= (Net salesQ2 2024
+ Net salesQ1 2024
+ Net salesQ4 2023
+ Net salesQ3 2023)
÷ Working capital
= (6,699 + 6,094 + 6,906 + 7,133)
÷ -1,722 = —
2 Click competitor name to see calculations.
Average Inventory Processing Period
Johnson Controls International plc, 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 | Sep 30, 2021 | Jun 30, 2021 | Mar 31, 2021 | Dec 31, 2020 | Sep 30, 2020 | Jun 30, 2020 | Mar 31, 2020 | Dec 31, 2019 | Sep 30, 2019 | Jun 30, 2019 | Mar 31, 2019 | Dec 31, 2018 | Sep 30, 2018 | Jun 30, 2018 | Mar 31, 2018 | Dec 31, 2017 | |||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
Selected Financial Data | ||||||||||||||||||||||||||||||||||
Inventory turnover | 6.02 | 5.97 | 6.42 | 5.68 | 5.66 | 5.86 | 6.76 | 6.50 | 6.54 | 6.58 | 7.59 | 7.45 | 7.40 | 7.71 | 8.41 | 7.63 | 7.89 | 8.35 | 8.97 | 8.70 | 9.03 | 10.11 | 6.83 | — | — | — | ||||||||
Short-term Activity Ratio (no. days) | ||||||||||||||||||||||||||||||||||
Average inventory processing period1 | 61 | 61 | 57 | 64 | 64 | 62 | 54 | 56 | 56 | 55 | 48 | 49 | 49 | 47 | 43 | 48 | 46 | 44 | 41 | 42 | 40 | 36 | 53 | — | — | — | ||||||||
Benchmarks (no. days) | ||||||||||||||||||||||||||||||||||
Average Inventory Processing Period, Competitors2 | ||||||||||||||||||||||||||||||||||
Boeing Co. | 470 | 443 | 415 | 419 | 416 | 438 | 452 | 468 | 494 | 493 | 486 | 475 | 478 | 496 | 467 | — | — | — | — | — | — | — | — | — | — | — | ||||||||
Caterpillar Inc. | 151 | 146 | 141 | 148 | 151 | 154 | 144 | 155 | 152 | 148 | 144 | 150 | 146 | 149 | 143 | — | — | — | — | — | — | — | — | — | — | — | ||||||||
Eaton Corp. plc | 96 | 95 | 92 | 93 | 93 | 93 | 90 | 92 | 94 | 90 | 82 | 77 | 75 | 71 | 62 | — | — | — | — | — | — | — | — | — | — | — | ||||||||
GE Aerospace | 89 | 141 | 120 | 121 | 116 | 110 | 114 | 118 | 120 | 112 | 107 | 114 | 111 | 105 | 96 | — | — | — | — | — | — | — | — | — | — | — | ||||||||
Honeywell International Inc. | 99 | 100 | 98 | 97 | 96 | 94 | 90 | 89 | 90 | 87 | 80 | 77 | 75 | 75 | 74 | — | — | — | — | — | — | — | — | — | — | — | ||||||||
Lockheed Martin Corp. | 18 | 20 | 19 | 20 | 22 | 22 | 20 | 20 | 23 | 20 | 19 | 18 | 20 | 21 | 23 | — | — | — | — | — | — | — | — | — | — | — | ||||||||
RTX Corp. | 79 | 77 | 76 | 79 | 78 | 76 | 73 | 73 | 71 | 69 | 65 | 65 | 66 | 67 | 71 | — | — | — | — | — | — | — | — | — | — | — |
Based on: 10-Q (reporting date: 2024-03-31), 10-Q (reporting date: 2023-12-31), 10-K (reporting date: 2023-09-30), 10-Q (reporting date: 2023-06-30), 10-Q (reporting date: 2023-03-31), 10-Q (reporting date: 2022-12-31), 10-K (reporting date: 2022-09-30), 10-Q (reporting date: 2022-06-30), 10-Q (reporting date: 2022-03-31), 10-Q (reporting date: 2021-12-31), 10-K (reporting date: 2021-09-30), 10-Q (reporting date: 2021-06-30), 10-Q (reporting date: 2021-03-31), 10-Q (reporting date: 2020-12-31), 10-K (reporting date: 2020-09-30), 10-Q (reporting date: 2020-06-30), 10-Q (reporting date: 2020-03-31), 10-Q (reporting date: 2019-12-31), 10-K (reporting date: 2019-09-30), 10-Q (reporting date: 2019-06-30), 10-Q (reporting date: 2019-03-31), 10-Q (reporting date: 2018-12-31), 10-K (reporting date: 2018-09-30), 10-Q (reporting date: 2018-06-30), 10-Q (reporting date: 2018-03-31), 10-Q (reporting date: 2017-12-31).
1 Q2 2024 Calculation
Average inventory processing period = 365 ÷ Inventory turnover
= 365 ÷ 6.02 = 61
2 Click competitor name to see calculations.
Short-term activity ratio | Description | The company |
---|---|---|
Average inventory processing period | An activity ratio equal to the number of days in the period divided by inventory turnover over the period. |
Average Receivable Collection Period
Johnson Controls International plc, 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 | Sep 30, 2021 | Jun 30, 2021 | Mar 31, 2021 | Dec 31, 2020 | Sep 30, 2020 | Jun 30, 2020 | Mar 31, 2020 | Dec 31, 2019 | Sep 30, 2019 | Jun 30, 2019 | Mar 31, 2019 | Dec 31, 2018 | Sep 30, 2018 | Jun 30, 2018 | Mar 31, 2018 | Dec 31, 2017 | |||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
Selected Financial Data | ||||||||||||||||||||||||||||||||||
Receivables turnover | 4.01 | 4.44 | 4.46 | 4.07 | 4.35 | 4.46 | 4.58 | 4.27 | 4.34 | 4.27 | 4.22 | 4.10 | 4.30 | 4.27 | 4.22 | 4.24 | 4.32 | 4.29 | 4.15 | 4.32 | 4.86 | 5.41 | 4.44 | — | — | — | ||||||||
Short-term Activity Ratio (no. days) | ||||||||||||||||||||||||||||||||||
Average receivable collection period1 | 91 | 82 | 82 | 90 | 84 | 82 | 80 | 86 | 84 | 86 | 87 | 89 | 85 | 86 | 87 | 86 | 84 | 85 | 88 | 84 | 75 | 67 | 82 | — | — | — | ||||||||
Benchmarks (no. days) | ||||||||||||||||||||||||||||||||||
Average Receivable Collection Period, Competitors2 | ||||||||||||||||||||||||||||||||||
Boeing Co. | 16 | 14 | 12 | 15 | 15 | 15 | 14 | 16 | 18 | 14 | 15 | 13 | 15 | 15 | 12 | — | — | — | — | — | — | — | — | — | — | — | ||||||||
Caterpillar Inc. | 55 | 53 | 53 | 53 | 56 | 57 | 57 | 55 | 60 | 67 | 64 | 61 | 66 | 72 | 68 | — | — | — | — | — | — | — | — | — | — | — | ||||||||
Eaton Corp. plc | 73 | 72 | 70 | 72 | 73 | 72 | 72 | 69 | 71 | 68 | 61 | 63 | 64 | 63 | 59 | — | — | — | — | — | — | — | — | — | — | — | ||||||||
GE Aerospace | 60 | 93 | 87 | 79 | 78 | 73 | 89 | 87 | 83 | 82 | 80 | 76 | 77 | 80 | 83 | — | — | — | — | — | — | — | — | — | — | — | ||||||||
Honeywell International Inc. | 76 | 74 | 75 | 79 | 81 | 80 | 77 | 77 | 82 | 76 | 72 | 76 | 75 | 75 | 76 | — | — | — | — | — | — | — | — | — | — | — | ||||||||
Lockheed Martin Corp. | 15 | 12 | 12 | 13 | 19 | 14 | 14 | 14 | 19 | 14 | 11 | 12 | 14 | 12 | 11 | — | — | — | — | — | — | — | — | — | — | — | ||||||||
RTX Corp. | 52 | 53 | 57 | 55 | 51 | 54 | 50 | 51 | 58 | 51 | 55 | 55 | 52 | 61 | 60 | — | — | — | — | — | — | — | — | — | — | — |
Based on: 10-Q (reporting date: 2024-03-31), 10-Q (reporting date: 2023-12-31), 10-K (reporting date: 2023-09-30), 10-Q (reporting date: 2023-06-30), 10-Q (reporting date: 2023-03-31), 10-Q (reporting date: 2022-12-31), 10-K (reporting date: 2022-09-30), 10-Q (reporting date: 2022-06-30), 10-Q (reporting date: 2022-03-31), 10-Q (reporting date: 2021-12-31), 10-K (reporting date: 2021-09-30), 10-Q (reporting date: 2021-06-30), 10-Q (reporting date: 2021-03-31), 10-Q (reporting date: 2020-12-31), 10-K (reporting date: 2020-09-30), 10-Q (reporting date: 2020-06-30), 10-Q (reporting date: 2020-03-31), 10-Q (reporting date: 2019-12-31), 10-K (reporting date: 2019-09-30), 10-Q (reporting date: 2019-06-30), 10-Q (reporting date: 2019-03-31), 10-Q (reporting date: 2018-12-31), 10-K (reporting date: 2018-09-30), 10-Q (reporting date: 2018-06-30), 10-Q (reporting date: 2018-03-31), 10-Q (reporting date: 2017-12-31).
1 Q2 2024 Calculation
Average receivable collection period = 365 ÷ Receivables turnover
= 365 ÷ 4.01 = 91
2 Click competitor name to see calculations.
Short-term activity ratio | Description | The company |
---|---|---|
Average receivable collection period | An activity ratio equal to the number of days in the period divided by receivables turnover. |
Operating Cycle
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 | Sep 30, 2021 | Jun 30, 2021 | Mar 31, 2021 | Dec 31, 2020 | Sep 30, 2020 | Jun 30, 2020 | Mar 31, 2020 | Dec 31, 2019 | Sep 30, 2019 | Jun 30, 2019 | Mar 31, 2019 | Dec 31, 2018 | Sep 30, 2018 | Jun 30, 2018 | Mar 31, 2018 | Dec 31, 2017 | |||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
Selected Financial Data | ||||||||||||||||||||||||||||||||||
Average inventory processing period | 61 | 61 | 57 | 64 | 64 | 62 | 54 | 56 | 56 | 55 | 48 | 49 | 49 | 47 | 43 | 48 | 46 | 44 | 41 | 42 | 40 | 36 | 53 | — | — | — | ||||||||
Average receivable collection period | 91 | 82 | 82 | 90 | 84 | 82 | 80 | 86 | 84 | 86 | 87 | 89 | 85 | 86 | 87 | 86 | 84 | 85 | 88 | 84 | 75 | 67 | 82 | — | — | — | ||||||||
Short-term Activity Ratio | ||||||||||||||||||||||||||||||||||
Operating cycle1 | 152 | 143 | 139 | 154 | 148 | 144 | 134 | 142 | 140 | 141 | 135 | 138 | 134 | 133 | 130 | 134 | 130 | 129 | 129 | 126 | 115 | 103 | 135 | — | — | — | ||||||||
Benchmarks | ||||||||||||||||||||||||||||||||||
Operating Cycle, Competitors2 | ||||||||||||||||||||||||||||||||||
Boeing Co. | 486 | 457 | 427 | 434 | 431 | 453 | 466 | 484 | 512 | 507 | 501 | 488 | 493 | 511 | 479 | — | — | — | — | — | — | — | — | — | — | — | ||||||||
Caterpillar Inc. | 206 | 199 | 194 | 201 | 207 | 211 | 201 | 210 | 212 | 215 | 208 | 211 | 212 | 221 | 211 | — | — | — | — | — | — | — | — | — | — | — | ||||||||
Eaton Corp. plc | 169 | 167 | 162 | 165 | 166 | 165 | 162 | 161 | 165 | 158 | 143 | 140 | 139 | 134 | 121 | — | — | — | — | — | — | — | — | — | — | — | ||||||||
GE Aerospace | 149 | 234 | 207 | 200 | 194 | 183 | 203 | 205 | 203 | 194 | 187 | 190 | 188 | 185 | 179 | — | — | — | — | — | — | — | — | — | — | — | ||||||||
Honeywell International Inc. | 175 | 174 | 173 | 176 | 177 | 174 | 167 | 166 | 172 | 163 | 152 | 153 | 150 | 150 | 150 | — | — | — | — | — | — | — | — | — | — | — | ||||||||
Lockheed Martin Corp. | 33 | 32 | 31 | 33 | 41 | 36 | 34 | 34 | 42 | 34 | 30 | 30 | 34 | 33 | 34 | — | — | — | — | — | — | — | — | — | — | — | ||||||||
RTX Corp. | 131 | 130 | 133 | 134 | 129 | 130 | 123 | 124 | 129 | 120 | 120 | 120 | 118 | 128 | 131 | — | — | — | — | — | — | — | — | — | — | — |
Based on: 10-Q (reporting date: 2024-03-31), 10-Q (reporting date: 2023-12-31), 10-K (reporting date: 2023-09-30), 10-Q (reporting date: 2023-06-30), 10-Q (reporting date: 2023-03-31), 10-Q (reporting date: 2022-12-31), 10-K (reporting date: 2022-09-30), 10-Q (reporting date: 2022-06-30), 10-Q (reporting date: 2022-03-31), 10-Q (reporting date: 2021-12-31), 10-K (reporting date: 2021-09-30), 10-Q (reporting date: 2021-06-30), 10-Q (reporting date: 2021-03-31), 10-Q (reporting date: 2020-12-31), 10-K (reporting date: 2020-09-30), 10-Q (reporting date: 2020-06-30), 10-Q (reporting date: 2020-03-31), 10-Q (reporting date: 2019-12-31), 10-K (reporting date: 2019-09-30), 10-Q (reporting date: 2019-06-30), 10-Q (reporting date: 2019-03-31), 10-Q (reporting date: 2018-12-31), 10-K (reporting date: 2018-09-30), 10-Q (reporting date: 2018-06-30), 10-Q (reporting date: 2018-03-31), 10-Q (reporting date: 2017-12-31).
1 Q2 2024 Calculation
Operating cycle = Average inventory processing period + Average receivable collection period
= 61 + 91 = 152
2 Click competitor name to see calculations.
Short-term activity ratio | Description | The company |
---|---|---|
Operating cycle | Equal to average inventory processing period plus average receivables collection period. | Johnson Controls International plc operating cycle deteriorated from Q4 2023 to Q1 2024 and from Q1 2024 to Q2 2024. |
Average Payables Payment Period
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 | Sep 30, 2021 | Jun 30, 2021 | Mar 31, 2021 | Dec 31, 2020 | Sep 30, 2020 | Jun 30, 2020 | Mar 31, 2020 | Dec 31, 2019 | Sep 30, 2019 | Jun 30, 2019 | Mar 31, 2019 | Dec 31, 2018 | Sep 30, 2018 | Jun 30, 2018 | Mar 31, 2018 | Dec 31, 2017 | |||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
Selected Financial Data | ||||||||||||||||||||||||||||||||||
Payables turnover | 4.48 | 4.51 | 4.18 | 4.09 | 3.97 | 4.10 | 4.00 | 4.06 | 4.01 | 3.91 | 4.17 | 4.14 | 4.32 | 4.59 | 4.78 | 4.98 | 5.14 | 4.89 | 4.54 | 4.86 | 5.51 | 6.26 | 4.74 | — | — | — | ||||||||
Short-term Activity Ratio (no. days) | ||||||||||||||||||||||||||||||||||
Average payables payment period1 | 81 | 81 | 87 | 89 | 92 | 89 | 91 | 90 | 91 | 93 | 88 | 88 | 85 | 79 | 76 | 73 | 71 | 75 | 80 | 75 | 66 | 58 | 77 | — | — | — | ||||||||
Benchmarks (no. days) | ||||||||||||||||||||||||||||||||||
Average Payables Payment Period, Competitors2 | ||||||||||||||||||||||||||||||||||
Boeing Co. | 65 | 62 | 62 | 59 | 58 | 57 | 59 | 57 | 59 | 54 | 57 | 59 | 67 | 74 | 74 | — | — | — | — | — | — | — | — | — | — | — | ||||||||
Caterpillar Inc. | 67 | 67 | 67 | 66 | 72 | 78 | 77 | 76 | 77 | 82 | 84 | 79 | 80 | 82 | 77 | — | — | — | — | — | — | — | — | — | — | — | ||||||||
Eaton Corp. plc | 85 | 83 | 83 | 82 | 81 | 80 | 81 | 79 | 82 | 78 | 77 | 71 | 70 | 65 | 58 | — | — | — | — | — | — | — | — | — | — | — | ||||||||
GE Aerospace | 73 | 122 | 112 | 112 | 107 | 102 | 123 | 116 | 116 | 110 | 110 | 109 | 109 | 103 | 100 | — | — | — | — | — | — | — | — | — | — | — | ||||||||
Honeywell International Inc. | 101 | 102 | 109 | 104 | 105 | 104 | 103 | 99 | 101 | 100 | 101 | 95 | 97 | 95 | 95 | — | — | — | — | — | — | — | — | — | — | — | ||||||||
Lockheed Martin Corp. | 19 | 21 | 14 | 24 | 22 | 21 | 13 | 17 | 15 | 17 | 5 | 10 | 10 | 12 | 6 | — | — | — | — | — | — | — | — | — | — | — | ||||||||
RTX Corp. | 66 | 65 | 69 | 68 | 66 | 67 | 68 | 63 | 68 | 58 | 62 | 60 | 56 | 64 | 66 | — | — | — | — | — | — | — | — | — | — | — |
Based on: 10-Q (reporting date: 2024-03-31), 10-Q (reporting date: 2023-12-31), 10-K (reporting date: 2023-09-30), 10-Q (reporting date: 2023-06-30), 10-Q (reporting date: 2023-03-31), 10-Q (reporting date: 2022-12-31), 10-K (reporting date: 2022-09-30), 10-Q (reporting date: 2022-06-30), 10-Q (reporting date: 2022-03-31), 10-Q (reporting date: 2021-12-31), 10-K (reporting date: 2021-09-30), 10-Q (reporting date: 2021-06-30), 10-Q (reporting date: 2021-03-31), 10-Q (reporting date: 2020-12-31), 10-K (reporting date: 2020-09-30), 10-Q (reporting date: 2020-06-30), 10-Q (reporting date: 2020-03-31), 10-Q (reporting date: 2019-12-31), 10-K (reporting date: 2019-09-30), 10-Q (reporting date: 2019-06-30), 10-Q (reporting date: 2019-03-31), 10-Q (reporting date: 2018-12-31), 10-K (reporting date: 2018-09-30), 10-Q (reporting date: 2018-06-30), 10-Q (reporting date: 2018-03-31), 10-Q (reporting date: 2017-12-31).
1 Q2 2024 Calculation
Average payables payment period = 365 ÷ Payables turnover
= 365 ÷ 4.48 = 81
2 Click competitor name to see calculations.
Short-term activity ratio | Description | The company |
---|---|---|
Average payables payment period | An estimate of the average number of days it takes a company to pay its suppliers; equal to the number of days in the period divided by payables turnover ratio for the period. |
Cash Conversion Cycle
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 | Sep 30, 2021 | Jun 30, 2021 | Mar 31, 2021 | Dec 31, 2020 | Sep 30, 2020 | Jun 30, 2020 | Mar 31, 2020 | Dec 31, 2019 | Sep 30, 2019 | Jun 30, 2019 | Mar 31, 2019 | Dec 31, 2018 | Sep 30, 2018 | Jun 30, 2018 | Mar 31, 2018 | Dec 31, 2017 | |||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
Selected Financial Data | ||||||||||||||||||||||||||||||||||
Average inventory processing period | 61 | 61 | 57 | 64 | 64 | 62 | 54 | 56 | 56 | 55 | 48 | 49 | 49 | 47 | 43 | 48 | 46 | 44 | 41 | 42 | 40 | 36 | 53 | — | — | — | ||||||||
Average receivable collection period | 91 | 82 | 82 | 90 | 84 | 82 | 80 | 86 | 84 | 86 | 87 | 89 | 85 | 86 | 87 | 86 | 84 | 85 | 88 | 84 | 75 | 67 | 82 | — | — | — | ||||||||
Average payables payment period | 81 | 81 | 87 | 89 | 92 | 89 | 91 | 90 | 91 | 93 | 88 | 88 | 85 | 79 | 76 | 73 | 71 | 75 | 80 | 75 | 66 | 58 | 77 | — | — | — | ||||||||
Short-term Activity Ratio | ||||||||||||||||||||||||||||||||||
Cash conversion cycle1 | 71 | 62 | 52 | 65 | 56 | 55 | 43 | 52 | 49 | 48 | 47 | 50 | 49 | 54 | 54 | 61 | 59 | 54 | 49 | 51 | 49 | 45 | 58 | — | — | — | ||||||||
Benchmarks | ||||||||||||||||||||||||||||||||||
Cash Conversion Cycle, Competitors2 | ||||||||||||||||||||||||||||||||||
Boeing Co. | 421 | 395 | 365 | 375 | 373 | 396 | 407 | 427 | 453 | 453 | 444 | 429 | 426 | 437 | 405 | — | — | — | — | — | — | — | — | — | — | — | ||||||||
Caterpillar Inc. | 139 | 132 | 127 | 135 | 135 | 133 | 124 | 134 | 135 | 133 | 124 | 132 | 132 | 139 | 134 | — | — | — | — | — | — | — | — | — | — | — | ||||||||
Eaton Corp. plc | 84 | 84 | 79 | 83 | 85 | 85 | 81 | 82 | 83 | 80 | 66 | 69 | 69 | 69 | 63 | — | — | — | — | — | — | — | — | — | — | — | ||||||||
GE Aerospace | 76 | 112 | 95 | 88 | 87 | 81 | 80 | 89 | 87 | 84 | 77 | 81 | 79 | 82 | 79 | — | — | — | — | — | — | — | — | — | — | — | ||||||||
Honeywell International Inc. | 74 | 72 | 64 | 72 | 72 | 70 | 64 | 67 | 71 | 63 | 51 | 58 | 53 | 55 | 55 | — | — | — | — | — | — | — | — | — | — | — | ||||||||
Lockheed Martin Corp. | 14 | 11 | 17 | 9 | 19 | 15 | 21 | 17 | 27 | 17 | 25 | 20 | 24 | 21 | 28 | — | — | — | — | — | — | — | — | — | — | — | ||||||||
RTX Corp. | 65 | 65 | 64 | 66 | 63 | 63 | 55 | 61 | 61 | 62 | 58 | 60 | 62 | 64 | 65 | — | — | — | — | — | — | — | — | — | — | — |
Based on: 10-Q (reporting date: 2024-03-31), 10-Q (reporting date: 2023-12-31), 10-K (reporting date: 2023-09-30), 10-Q (reporting date: 2023-06-30), 10-Q (reporting date: 2023-03-31), 10-Q (reporting date: 2022-12-31), 10-K (reporting date: 2022-09-30), 10-Q (reporting date: 2022-06-30), 10-Q (reporting date: 2022-03-31), 10-Q (reporting date: 2021-12-31), 10-K (reporting date: 2021-09-30), 10-Q (reporting date: 2021-06-30), 10-Q (reporting date: 2021-03-31), 10-Q (reporting date: 2020-12-31), 10-K (reporting date: 2020-09-30), 10-Q (reporting date: 2020-06-30), 10-Q (reporting date: 2020-03-31), 10-Q (reporting date: 2019-12-31), 10-K (reporting date: 2019-09-30), 10-Q (reporting date: 2019-06-30), 10-Q (reporting date: 2019-03-31), 10-Q (reporting date: 2018-12-31), 10-K (reporting date: 2018-09-30), 10-Q (reporting date: 2018-06-30), 10-Q (reporting date: 2018-03-31), 10-Q (reporting date: 2017-12-31).
1 Q2 2024 Calculation
Cash conversion cycle = Average inventory processing period + Average receivable collection period – Average payables payment period
= 61 + 91 – 81 = 71
2 Click competitor name to see calculations.
Short-term activity ratio | Description | The company |
---|---|---|
Cash conversion cycle | A financial metric that measures the length of time required for a company to convert cash invested in its operations to cash received as a result of its operations; equal to average inventory processing period plus average receivables collection period minus average payables payment period. | Johnson Controls International plc cash conversion cycle deteriorated from Q4 2023 to Q1 2024 and from Q1 2024 to Q2 2024. |