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-06-30), 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-09-30), 10-Q (reporting date: 2021-06-30), 10-Q (reporting date: 2021-03-31), 10-K (reporting date: 2020-12-31), 10-Q (reporting date: 2020-09-30), 10-Q (reporting date: 2020-06-30), 10-Q (reporting date: 2020-03-31), 10-K (reporting date: 2019-12-31), 10-Q (reporting date: 2019-09-30), 10-Q (reporting date: 2019-06-30), 10-Q (reporting date: 2019-03-31).
Short-term activity ratio | Description | The company |
---|---|---|
Inventory turnover | An activity ratio calculated as cost of goods sold divided by inventory. | CVS Health Corp. inventory turnover ratio improved from Q4 2023 to Q1 2024 and from Q1 2024 to Q2 2024. |
Receivables turnover | An activity ratio equal to revenue divided by receivables. | CVS Health Corp. receivables turnover ratio improved 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. | CVS Health Corp. 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. | |
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. | CVS Health Corp. cash conversion cycle improved from Q4 2023 to Q1 2024 and from Q1 2024 to Q2 2024. |
Inventory Turnover
Jun 30, 2024 | 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 | ||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
Selected Financial Data (US$ in millions) | |||||||||||||||||||||||||||||
Cost of revenues | 77,851) | 75,876) | 79,937) | 76,187) | 75,318) | 71,903) | 70,033) | 67,784) | 66,896) | 63,460) | 62,952) | 61,092) | 59,421) | 56,598) | 57,597) | 55,336) | 51,993) | 54,734) | 55,198) | 53,287) | 52,057) | 50,706) | |||||||
Inventories | 16,068) | 16,346) | 18,025) | 17,954) | 17,291) | 18,263) | 19,090) | 18,058) | 17,375) | 18,160) | 17,760) | 17,399) | 16,979) | 17,618) | 18,496) | 17,478) | 16,519) | 16,976) | 17,516) | 16,028) | 15,511) | 15,448) | |||||||
Short-term Activity Ratio | |||||||||||||||||||||||||||||
Inventory turnover1 | 19.28 | 18.80 | 16.83 | 16.34 | 16.48 | 15.15 | 14.05 | 14.46 | 14.64 | 13.60 | 13.52 | 13.49 | 13.48 | 12.57 | 11.88 | 12.43 | 13.03 | 12.68 | 12.06 | — | — | — | |||||||
Benchmarks | |||||||||||||||||||||||||||||
Inventory Turnover, Competitors2 | |||||||||||||||||||||||||||||
Abbott Laboratories | 2.67 | 2.65 | 2.74 | 2.71 | 2.62 | 2.77 | 3.10 | 3.37 | 3.24 | 3.36 | 3.59 | 3.47 | 3.27 | 2.99 | 2.99 | 2.71 | 2.56 | 2.92 | 3.07 | — | — | — | |||||||
Cigna Group | 29.93 | 31.05 | 23.70 | 29.58 | 28.53 | 30.04 | 26.13 | 30.87 | 32.34 | 34.32 | 31.58 | 37.54 | 36.13 | 36.50 | 32.70 | 37.84 | 36.30 | 38.13 | 36.70 | — | — | — | |||||||
Intuitive Surgical Inc. | 1.81 | 1.89 | 1.96 | 1.99 | 2.21 | 2.25 | 2.27 | 2.36 | 2.62 | 2.82 | 2.98 | 2.90 | 2.84 | 2.64 | 2.49 | 2.18 | 2.22 | 2.30 | 2.30 | — | — | — | |||||||
Medtronic PLC | 1.92 | 1.91 | 2.03 | 1.92 | 2.00 | 2.09 | 2.20 | 2.26 | 2.38 | 2.47 | 2.43 | 2.24 | 2.20 | 2.10 | 2.23 | 2.34 | 2.35 | 2.37 | 2.44 | — | — | — |
Based on: 10-Q (reporting date: 2024-06-30), 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-09-30), 10-Q (reporting date: 2021-06-30), 10-Q (reporting date: 2021-03-31), 10-K (reporting date: 2020-12-31), 10-Q (reporting date: 2020-09-30), 10-Q (reporting date: 2020-06-30), 10-Q (reporting date: 2020-03-31), 10-K (reporting date: 2019-12-31), 10-Q (reporting date: 2019-09-30), 10-Q (reporting date: 2019-06-30), 10-Q (reporting date: 2019-03-31).
1 Q2 2024 Calculation
Inventory turnover
= (Cost of revenuesQ2 2024
+ Cost of revenuesQ1 2024
+ Cost of revenuesQ4 2023
+ Cost of revenuesQ3 2023)
÷ Inventories
= (77,851 + 75,876 + 79,937 + 76,187)
÷ 16,068 = 19.28
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. | CVS Health Corp. inventory turnover ratio improved from Q4 2023 to Q1 2024 and from Q1 2024 to Q2 2024. |
Receivables Turnover
Jun 30, 2024 | 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 | ||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
Selected Financial Data (US$ in millions) | |||||||||||||||||||||||||||||
Revenues from customers | 90,840) | 87,983) | 93,545) | 89,487) | 88,647) | 84,944) | 83,523) | 80,958) | 80,490) | 76,658) | 76,237) | 73,548) | 72,327) | 68,800) | 69,306) | 66,852) | 65,157) | 66,593) | 66,683) | 64,547) | 63,138) | 61,397) | |||||||
Accounts receivable, net | 32,385) | 32,217) | 35,227) | 32,927) | 29,546) | 28,331) | 27,276) | 26,317) | 27,233) | 26,451) | 24,431) | 25,283) | 24,164) | 23,855) | 21,742) | 23,816) | 22,520) | 23,037) | 19,617) | 19,789) | 18,174) | 19,509) | |||||||
Short-term Activity Ratio | |||||||||||||||||||||||||||||
Receivables turnover1 | 11.17 | 11.16 | 10.12 | 10.53 | 11.44 | 11.65 | 11.79 | 11.94 | 11.27 | 11.30 | 11.91 | 11.23 | 11.48 | 11.32 | 12.32 | 11.14 | 11.68 | 11.33 | 13.04 | — | — | — | |||||||
Benchmarks | |||||||||||||||||||||||||||||
Receivables Turnover, Competitors2 | |||||||||||||||||||||||||||||
Abbott Laboratories | 5.94 | 6.11 | 6.11 | 6.15 | 6.52 | 6.89 | 7.02 | 7.03 | 6.33 | 6.20 | 6.64 | 6.61 | 6.58 | 6.13 | 5.40 | 5.70 | 6.12 | 6.06 | 5.88 | — | — | — | |||||||
Elevance Health Inc. | 17.60 | 15.98 | 18.08 | 17.93 | 18.82 | 16.53 | 18.81 | 19.51 | 18.80 | 16.67 | 20.66 | 18.93 | 18.81 | 17.39 | 19.72 | 18.91 | 18.04 | 16.74 | 18.20 | — | — | — | |||||||
Humana Inc. | 27.10 | 27.54 | 51.75 | 55.60 | 68.53 | 30.60 | 55.25 | 56.74 | 26.54 | 27.18 | 45.69 | 42.91 | 32.51 | 35.43 | 66.78 | 64.58 | 31.30 | 33.43 | 60.97 | — | — | — | |||||||
Intuitive Surgical Inc. | 6.83 | 6.49 | 6.30 | 7.12 | 7.37 | 6.95 | 6.60 | 7.20 | 7.11 | 6.52 | 7.30 | 7.90 | 7.38 | 6.96 | 6.75 | 7.32 | 8.56 | 8.73 | 6.94 | — | — | — | |||||||
Medtronic PLC | 5.39 | 5.44 | 5.21 | 5.23 | 5.48 | 5.85 | 5.71 | 5.84 | 5.79 | 5.82 | 5.51 | 5.35 | 5.21 | 5.73 | 6.22 | 4.97 | 5.05 | 5.20 | 4.91 | — | — | — | |||||||
UnitedHealth Group Inc. | 16.49 | 13.80 | 17.27 | 17.23 | 19.23 | 14.88 | 18.22 | 18.37 | 16.27 | 15.65 | 20.07 | 19.60 | 18.53 | 16.35 | 19.86 | 20.63 | 19.62 | 16.73 | 20.32 | — | — | — |
Based on: 10-Q (reporting date: 2024-06-30), 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-09-30), 10-Q (reporting date: 2021-06-30), 10-Q (reporting date: 2021-03-31), 10-K (reporting date: 2020-12-31), 10-Q (reporting date: 2020-09-30), 10-Q (reporting date: 2020-06-30), 10-Q (reporting date: 2020-03-31), 10-K (reporting date: 2019-12-31), 10-Q (reporting date: 2019-09-30), 10-Q (reporting date: 2019-06-30), 10-Q (reporting date: 2019-03-31).
1 Q2 2024 Calculation
Receivables turnover
= (Revenues from customersQ2 2024
+ Revenues from customersQ1 2024
+ Revenues from customersQ4 2023
+ Revenues from customersQ3 2023)
÷ Accounts receivable, net
= (90,840 + 87,983 + 93,545 + 89,487)
÷ 32,385 = 11.17
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. | CVS Health Corp. receivables turnover ratio improved from Q4 2023 to Q1 2024 and from Q1 2024 to Q2 2024. |
Payables Turnover
Jun 30, 2024 | 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 | ||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
Selected Financial Data (US$ in millions) | |||||||||||||||||||||||||||||
Cost of revenues | 77,851) | 75,876) | 79,937) | 76,187) | 75,318) | 71,903) | 70,033) | 67,784) | 66,896) | 63,460) | 62,952) | 61,092) | 59,421) | 56,598) | 57,597) | 55,336) | 51,993) | 54,734) | 55,198) | 53,287) | 52,057) | 50,706) | |||||||
Accounts payable | 14,416) | 13,717) | 14,897) | 14,874) | 13,367) | 12,527) | 14,838) | 13,925) | 13,238) | 12,738) | 12,544) | 12,696) | 11,052) | 10,804) | 11,138) | 11,677) | 9,919) | 10,223) | 10,492) | 9,442) | 9,160) | 8,290) | |||||||
Short-term Activity Ratio | |||||||||||||||||||||||||||||
Payables turnover1 | 21.49 | 22.40 | 20.36 | 19.73 | 21.32 | 22.08 | 18.07 | 18.75 | 19.22 | 19.38 | 19.14 | 18.49 | 20.72 | 20.50 | 19.72 | 18.61 | 21.70 | 21.06 | 20.13 | — | — | — | |||||||
Benchmarks | |||||||||||||||||||||||||||||
Payables Turnover, Competitors2 | |||||||||||||||||||||||||||||
Abbott Laboratories | 4.42 | 4.33 | 4.19 | 4.55 | 4.28 | 4.44 | 4.15 | 4.67 | 4.25 | 4.02 | 4.21 | 4.55 | 4.43 | 3.97 | 3.80 | 4.37 | 4.00 | 4.20 | 4.07 | — | — | — | |||||||
Cigna Group | 5.63 | 5.92 | 6.75 | 6.76 | 6.92 | 7.18 | 7.31 | 7.44 | 7.44 | 7.89 | 7.68 | 7.71 | 7.60 | 7.74 | 7.75 | 8.02 | 8.30 | 9.06 | 9.34 | — | — | — | |||||||
Elevance Health Inc. | 8.09 | 7.54 | 7.72 | 7.61 | 7.54 | 7.57 | 7.47 | 7.48 | 7.35 | 7.28 | 7.59 | 7.31 | 7.30 | 7.31 | 7.75 | 8.32 | 8.42 | 8.48 | 9.25 | — | — | — | |||||||
Humana Inc. | 8.27 | 7.81 | 8.63 | 8.26 | 7.84 | 7.78 | 8.17 | 8.07 | 7.61 | 7.63 | 8.35 | 7.76 | 7.81 | 7.32 | 7.57 | 7.20 | 7.12 | 7.90 | 8.97 | — | — | — | |||||||
Intuitive Surgical Inc. | 12.91 | 12.64 | 12.69 | 11.66 | 11.10 | 12.99 | 13.78 | 12.01 | 12.68 | 14.36 | 14.45 | 14.13 | 13.71 | 14.80 | 18.35 | 12.46 | 13.18 | 10.69 | 11.08 | — | — | — | |||||||
Medtronic PLC | 5.09 | 4.84 | 4.03 | 4.68 | 4.60 | 4.62 | 4.46 | 5.14 | 5.41 | 5.67 | 4.98 | 5.56 | 5.19 | 5.56 | 4.72 | 4.96 | 4.84 | 4.89 | 4.69 | — | — | — | |||||||
UnitedHealth Group Inc. | 7.77 | 7.28 | 7.47 | 7.11 | 7.08 | 6.86 | 7.26 | 7.07 | 6.90 | 6.78 | 7.63 | 6.98 | 6.97 | 6.58 | 7.29 | 7.40 | 8.02 | 6.96 | 7.21 | — | — | — |
Based on: 10-Q (reporting date: 2024-06-30), 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-09-30), 10-Q (reporting date: 2021-06-30), 10-Q (reporting date: 2021-03-31), 10-K (reporting date: 2020-12-31), 10-Q (reporting date: 2020-09-30), 10-Q (reporting date: 2020-06-30), 10-Q (reporting date: 2020-03-31), 10-K (reporting date: 2019-12-31), 10-Q (reporting date: 2019-09-30), 10-Q (reporting date: 2019-06-30), 10-Q (reporting date: 2019-03-31).
1 Q2 2024 Calculation
Payables turnover
= (Cost of revenuesQ2 2024
+ Cost of revenuesQ1 2024
+ Cost of revenuesQ4 2023
+ Cost of revenuesQ3 2023)
÷ Accounts payable
= (77,851 + 75,876 + 79,937 + 76,187)
÷ 14,416 = 21.49
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. | CVS Health Corp. payables turnover ratio increased from Q4 2023 to Q1 2024 but then slightly decreased from Q1 2024 to Q2 2024. |
Working Capital Turnover
Jun 30, 2024 | 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 | ||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
Selected Financial Data (US$ in millions) | |||||||||||||||||||||||||||||
Current assets | 69,952) | 67,473) | 67,858) | 70,143) | 67,756) | 68,706) | 65,682) | 68,341) | 62,142) | 61,483) | 60,008) | 60,842) | 56,559) | 55,719) | 56,369) | 59,211) | 62,506) | 58,958) | 50,302) | 48,185) | 46,901) | 47,857) | |||||||
Less: Current liabilities | 81,386) | 83,319) | 79,189) | 81,553) | 79,206) | 75,054) | 69,736) | 72,409) | 68,457) | 69,780) | 67,807) | 64,709) | 59,311) | 60,104) | 62,017) | 62,044) | 63,694) | 59,560) | 53,303) | 52,544) | 49,376) | 50,631) | |||||||
Working capital | (11,434) | (15,846) | (11,331) | (11,410) | (11,450) | (6,348) | (4,054) | (4,068) | (6,315) | (8,297) | (7,799) | (3,867) | (2,752) | (4,385) | (5,648) | (2,833) | (1,188) | (602) | (3,001) | (4,359) | (2,475) | (2,774) | |||||||
Revenues from customers | 90,840) | 87,983) | 93,545) | 89,487) | 88,647) | 84,944) | 83,523) | 80,958) | 80,490) | 76,658) | 76,237) | 73,548) | 72,327) | 68,800) | 69,306) | 66,852) | 65,157) | 66,593) | 66,683) | 64,547) | 63,138) | 61,397) | |||||||
Short-term Activity Ratio | |||||||||||||||||||||||||||||
Working capital turnover1 | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | |||||||
Benchmarks | |||||||||||||||||||||||||||||
Working Capital Turnover, Competitors2 | |||||||||||||||||||||||||||||
Abbott Laboratories | 4.35 | 4.83 | 4.54 | 4.15 | 4.39 | 4.21 | 4.48 | 3.92 | 3.63 | 4.13 | 3.87 | 3.98 | 4.02 | 3.99 | 4.06 | 4.52 | 5.02 | 6.84 | 6.64 | — | — | — | |||||||
Cigna Group | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | |||||||
Elevance Health Inc. | 6.92 | 8.59 | 7.83 | 7.92 | 7.69 | 7.60 | 8.37 | 9.11 | 8.85 | 8.65 | 7.23 | 6.79 | 6.67 | 5.38 | 6.39 | 5.98 | 5.40 | 6.81 | 6.11 | — | — | — | |||||||
Humana Inc. | 8.48 | 8.25 | 9.47 | 9.72 | 9.34 | 8.98 | 10.27 | 10.54 | 9.53 | 9.27 | 8.67 | 7.47 | 7.38 | 7.61 | 7.42 | 6.04 | 6.14 | 6.91 | 7.19 | — | — | — | |||||||
Intuitive Surgical Inc. | 1.23 | 1.17 | 1.14 | 0.95 | 1.03 | 1.15 | 1.29 | 1.21 | 1.17 | 1.26 | 1.22 | 1.17 | 1.03 | 0.88 | 0.77 | 0.80 | 0.88 | 1.23 | 1.23 | — | — | — | |||||||
Medtronic PLC | 2.57 | 2.46 | 2.47 | 2.81 | 2.82 | 3.84 | 2.97 | 2.21 | 2.13 | 2.15 | 2.15 | 2.02 | 2.00 | 2.44 | 2.48 | 2.03 | 2.13 | 2.16 | 2.26 | — | — | — | |||||||
UnitedHealth Group Inc. | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — |
Based on: 10-Q (reporting date: 2024-06-30), 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-09-30), 10-Q (reporting date: 2021-06-30), 10-Q (reporting date: 2021-03-31), 10-K (reporting date: 2020-12-31), 10-Q (reporting date: 2020-09-30), 10-Q (reporting date: 2020-06-30), 10-Q (reporting date: 2020-03-31), 10-K (reporting date: 2019-12-31), 10-Q (reporting date: 2019-09-30), 10-Q (reporting date: 2019-06-30), 10-Q (reporting date: 2019-03-31).
1 Q2 2024 Calculation
Working capital turnover
= (Revenues from customersQ2 2024
+ Revenues from customersQ1 2024
+ Revenues from customersQ4 2023
+ Revenues from customersQ3 2023)
÷ Working capital
= (90,840 + 87,983 + 93,545 + 89,487)
÷ -11,434 = —
2 Click competitor name to see calculations.
Average Inventory Processing Period
Jun 30, 2024 | 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 | ||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
Selected Financial Data | |||||||||||||||||||||||||||||
Inventory turnover | 19.28 | 18.80 | 16.83 | 16.34 | 16.48 | 15.15 | 14.05 | 14.46 | 14.64 | 13.60 | 13.52 | 13.49 | 13.48 | 12.57 | 11.88 | 12.43 | 13.03 | 12.68 | 12.06 | — | — | — | |||||||
Short-term Activity Ratio (no. days) | |||||||||||||||||||||||||||||
Average inventory processing period1 | 19 | 19 | 22 | 22 | 22 | 24 | 26 | 25 | 25 | 27 | 27 | 27 | 27 | 29 | 31 | 29 | 28 | 29 | 30 | — | — | — | |||||||
Benchmarks (no. days) | |||||||||||||||||||||||||||||
Average Inventory Processing Period, Competitors2 | |||||||||||||||||||||||||||||
Abbott Laboratories | 136 | 138 | 133 | 135 | 139 | 132 | 118 | 108 | 113 | 109 | 102 | 105 | 111 | 122 | 122 | 135 | 142 | 125 | 119 | — | — | — | |||||||
Cigna Group | 12 | 12 | 15 | 12 | 13 | 12 | 14 | 12 | 11 | 11 | 12 | 10 | 10 | 10 | 11 | 10 | 10 | 10 | 10 | — | — | — | |||||||
Intuitive Surgical Inc. | 201 | 193 | 186 | 183 | 166 | 162 | 161 | 155 | 139 | 130 | 122 | 126 | 129 | 138 | 147 | 167 | 164 | 159 | 159 | — | — | — | |||||||
Medtronic PLC | 190 | 191 | 180 | 190 | 183 | 174 | 166 | 161 | 153 | 148 | 150 | 163 | 166 | 174 | 164 | 156 | 155 | 154 | 150 | — | — | — |
Based on: 10-Q (reporting date: 2024-06-30), 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-09-30), 10-Q (reporting date: 2021-06-30), 10-Q (reporting date: 2021-03-31), 10-K (reporting date: 2020-12-31), 10-Q (reporting date: 2020-09-30), 10-Q (reporting date: 2020-06-30), 10-Q (reporting date: 2020-03-31), 10-K (reporting date: 2019-12-31), 10-Q (reporting date: 2019-09-30), 10-Q (reporting date: 2019-06-30), 10-Q (reporting date: 2019-03-31).
1 Q2 2024 Calculation
Average inventory processing period = 365 ÷ Inventory turnover
= 365 ÷ 19.28 = 19
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
Jun 30, 2024 | 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 | ||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
Selected Financial Data | |||||||||||||||||||||||||||||
Receivables turnover | 11.17 | 11.16 | 10.12 | 10.53 | 11.44 | 11.65 | 11.79 | 11.94 | 11.27 | 11.30 | 11.91 | 11.23 | 11.48 | 11.32 | 12.32 | 11.14 | 11.68 | 11.33 | 13.04 | — | — | — | |||||||
Short-term Activity Ratio (no. days) | |||||||||||||||||||||||||||||
Average receivable collection period1 | 33 | 33 | 36 | 35 | 32 | 31 | 31 | 31 | 32 | 32 | 31 | 32 | 32 | 32 | 30 | 33 | 31 | 32 | 28 | — | — | — | |||||||
Benchmarks (no. days) | |||||||||||||||||||||||||||||
Average Receivable Collection Period, Competitors2 | |||||||||||||||||||||||||||||
Abbott Laboratories | 61 | 60 | 60 | 59 | 56 | 53 | 52 | 52 | 58 | 59 | 55 | 55 | 55 | 60 | 68 | 64 | 60 | 60 | 62 | — | — | — | |||||||
Elevance Health Inc. | 21 | 23 | 20 | 20 | 19 | 22 | 19 | 19 | 19 | 22 | 18 | 19 | 19 | 21 | 19 | 19 | 20 | 22 | 20 | — | — | — | |||||||
Humana Inc. | 13 | 13 | 7 | 7 | 5 | 12 | 7 | 6 | 14 | 13 | 8 | 9 | 11 | 10 | 5 | 6 | 12 | 11 | 6 | — | — | — | |||||||
Intuitive Surgical Inc. | 53 | 56 | 58 | 51 | 50 | 53 | 55 | 51 | 51 | 56 | 50 | 46 | 49 | 52 | 54 | 50 | 43 | 42 | 53 | — | — | — | |||||||
Medtronic PLC | 68 | 67 | 70 | 70 | 67 | 62 | 64 | 63 | 63 | 63 | 66 | 68 | 70 | 64 | 59 | 73 | 72 | 70 | 74 | — | — | — | |||||||
UnitedHealth Group Inc. | 22 | 26 | 21 | 21 | 19 | 25 | 20 | 20 | 22 | 23 | 18 | 19 | 20 | 22 | 18 | 18 | 19 | 22 | 18 | — | — | — |
Based on: 10-Q (reporting date: 2024-06-30), 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-09-30), 10-Q (reporting date: 2021-06-30), 10-Q (reporting date: 2021-03-31), 10-K (reporting date: 2020-12-31), 10-Q (reporting date: 2020-09-30), 10-Q (reporting date: 2020-06-30), 10-Q (reporting date: 2020-03-31), 10-K (reporting date: 2019-12-31), 10-Q (reporting date: 2019-09-30), 10-Q (reporting date: 2019-06-30), 10-Q (reporting date: 2019-03-31).
1 Q2 2024 Calculation
Average receivable collection period = 365 ÷ Receivables turnover
= 365 ÷ 11.17 = 33
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
Jun 30, 2024 | 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 | ||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
Selected Financial Data | |||||||||||||||||||||||||||||
Average inventory processing period | 19 | 19 | 22 | 22 | 22 | 24 | 26 | 25 | 25 | 27 | 27 | 27 | 27 | 29 | 31 | 29 | 28 | 29 | 30 | — | — | — | |||||||
Average receivable collection period | 33 | 33 | 36 | 35 | 32 | 31 | 31 | 31 | 32 | 32 | 31 | 32 | 32 | 32 | 30 | 33 | 31 | 32 | 28 | — | — | — | |||||||
Short-term Activity Ratio | |||||||||||||||||||||||||||||
Operating cycle1 | 52 | 52 | 58 | 57 | 54 | 55 | 57 | 56 | 57 | 59 | 58 | 59 | 59 | 61 | 61 | 62 | 59 | 61 | 58 | — | — | — | |||||||
Benchmarks | |||||||||||||||||||||||||||||
Operating Cycle, Competitors2 | |||||||||||||||||||||||||||||
Abbott Laboratories | 197 | 198 | 193 | 194 | 195 | 185 | 170 | 160 | 171 | 168 | 157 | 160 | 166 | 182 | 190 | 199 | 202 | 185 | 181 | — | — | — | |||||||
Intuitive Surgical Inc. | 254 | 249 | 244 | 234 | 216 | 215 | 216 | 206 | 190 | 186 | 172 | 172 | 178 | 190 | 201 | 217 | 207 | 201 | 212 | — | — | — | |||||||
Medtronic PLC | 258 | 258 | 250 | 260 | 250 | 236 | 230 | 224 | 216 | 211 | 216 | 231 | 236 | 238 | 223 | 229 | 227 | 224 | 224 | — | — | — |
Based on: 10-Q (reporting date: 2024-06-30), 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-09-30), 10-Q (reporting date: 2021-06-30), 10-Q (reporting date: 2021-03-31), 10-K (reporting date: 2020-12-31), 10-Q (reporting date: 2020-09-30), 10-Q (reporting date: 2020-06-30), 10-Q (reporting date: 2020-03-31), 10-K (reporting date: 2019-12-31), 10-Q (reporting date: 2019-09-30), 10-Q (reporting date: 2019-06-30), 10-Q (reporting date: 2019-03-31).
1 Q2 2024 Calculation
Operating cycle = Average inventory processing period + Average receivable collection period
= 19 + 33 = 52
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. |
Average Payables Payment Period
Jun 30, 2024 | 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 | ||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
Selected Financial Data | |||||||||||||||||||||||||||||
Payables turnover | 21.49 | 22.40 | 20.36 | 19.73 | 21.32 | 22.08 | 18.07 | 18.75 | 19.22 | 19.38 | 19.14 | 18.49 | 20.72 | 20.50 | 19.72 | 18.61 | 21.70 | 21.06 | 20.13 | — | — | — | |||||||
Short-term Activity Ratio (no. days) | |||||||||||||||||||||||||||||
Average payables payment period1 | 17 | 16 | 18 | 19 | 17 | 17 | 20 | 19 | 19 | 19 | 19 | 20 | 18 | 18 | 19 | 20 | 17 | 17 | 18 | — | — | — | |||||||
Benchmarks (no. days) | |||||||||||||||||||||||||||||
Average Payables Payment Period, Competitors2 | |||||||||||||||||||||||||||||
Abbott Laboratories | 83 | 84 | 87 | 80 | 85 | 82 | 88 | 78 | 86 | 91 | 87 | 80 | 82 | 92 | 96 | 83 | 91 | 87 | 90 | — | — | — | |||||||
Cigna Group | 65 | 62 | 54 | 54 | 53 | 51 | 50 | 49 | 49 | 46 | 48 | 47 | 48 | 47 | 47 | 46 | 44 | 40 | 39 | — | — | — | |||||||
Elevance Health Inc. | 45 | 48 | 47 | 48 | 48 | 48 | 49 | 49 | 50 | 50 | 48 | 50 | 50 | 50 | 47 | 44 | 43 | 43 | 39 | — | — | — | |||||||
Humana Inc. | 44 | 47 | 42 | 44 | 47 | 47 | 45 | 45 | 48 | 48 | 44 | 47 | 47 | 50 | 48 | 51 | 51 | 46 | 41 | — | — | — | |||||||
Intuitive Surgical Inc. | 28 | 29 | 29 | 31 | 33 | 28 | 26 | 30 | 29 | 25 | 25 | 26 | 27 | 25 | 20 | 29 | 28 | 34 | 33 | — | — | — | |||||||
Medtronic PLC | 72 | 75 | 91 | 78 | 79 | 79 | 82 | 71 | 67 | 64 | 73 | 66 | 70 | 66 | 77 | 74 | 75 | 75 | 78 | — | — | — | |||||||
UnitedHealth Group Inc. | 47 | 50 | 49 | 51 | 52 | 53 | 50 | 52 | 53 | 54 | 48 | 52 | 52 | 56 | 50 | 49 | 46 | 52 | 51 | — | — | — |
Based on: 10-Q (reporting date: 2024-06-30), 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-09-30), 10-Q (reporting date: 2021-06-30), 10-Q (reporting date: 2021-03-31), 10-K (reporting date: 2020-12-31), 10-Q (reporting date: 2020-09-30), 10-Q (reporting date: 2020-06-30), 10-Q (reporting date: 2020-03-31), 10-K (reporting date: 2019-12-31), 10-Q (reporting date: 2019-09-30), 10-Q (reporting date: 2019-06-30), 10-Q (reporting date: 2019-03-31).
1 Q2 2024 Calculation
Average payables payment period = 365 ÷ Payables turnover
= 365 ÷ 21.49 = 17
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
Jun 30, 2024 | 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 | ||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
Selected Financial Data | |||||||||||||||||||||||||||||
Average inventory processing period | 19 | 19 | 22 | 22 | 22 | 24 | 26 | 25 | 25 | 27 | 27 | 27 | 27 | 29 | 31 | 29 | 28 | 29 | 30 | — | — | — | |||||||
Average receivable collection period | 33 | 33 | 36 | 35 | 32 | 31 | 31 | 31 | 32 | 32 | 31 | 32 | 32 | 32 | 30 | 33 | 31 | 32 | 28 | — | — | — | |||||||
Average payables payment period | 17 | 16 | 18 | 19 | 17 | 17 | 20 | 19 | 19 | 19 | 19 | 20 | 18 | 18 | 19 | 20 | 17 | 17 | 18 | — | — | — | |||||||
Short-term Activity Ratio | |||||||||||||||||||||||||||||
Cash conversion cycle1 | 35 | 36 | 40 | 38 | 37 | 38 | 37 | 37 | 38 | 40 | 39 | 39 | 41 | 43 | 42 | 42 | 42 | 44 | 40 | — | — | — | |||||||
Benchmarks | |||||||||||||||||||||||||||||
Cash Conversion Cycle, Competitors2 | |||||||||||||||||||||||||||||
Abbott Laboratories | 114 | 114 | 106 | 114 | 110 | 103 | 82 | 82 | 85 | 77 | 70 | 80 | 84 | 90 | 94 | 116 | 111 | 98 | 91 | — | — | — | |||||||
Intuitive Surgical Inc. | 226 | 220 | 215 | 203 | 183 | 187 | 190 | 176 | 161 | 161 | 147 | 146 | 151 | 165 | 181 | 188 | 179 | 167 | 179 | — | — | — | |||||||
Medtronic PLC | 186 | 183 | 159 | 182 | 171 | 157 | 148 | 153 | 149 | 147 | 143 | 165 | 166 | 172 | 146 | 155 | 152 | 149 | 146 | — | — | — |
Based on: 10-Q (reporting date: 2024-06-30), 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-09-30), 10-Q (reporting date: 2021-06-30), 10-Q (reporting date: 2021-03-31), 10-K (reporting date: 2020-12-31), 10-Q (reporting date: 2020-09-30), 10-Q (reporting date: 2020-06-30), 10-Q (reporting date: 2020-03-31), 10-K (reporting date: 2019-12-31), 10-Q (reporting date: 2019-09-30), 10-Q (reporting date: 2019-06-30), 10-Q (reporting date: 2019-03-31).
1 Q2 2024 Calculation
Cash conversion cycle = Average inventory processing period + Average receivable collection period – Average payables payment period
= 19 + 33 – 17 = 35
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. | CVS Health Corp. cash conversion cycle improved from Q4 2023 to Q1 2024 and from Q1 2024 to Q2 2024. |