Stock Analysis on Net

CVS Health Corp. (NYSE:CVS)

Analysis of Short-term (Operating) Activity Ratios 
Quarterly Data

Microsoft Excel

Short-term Activity Ratios (Summary)

CVS Health Corp., short-term (operating) activity ratios (quarterly data)

Microsoft Excel
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
Turnover Ratios
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
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
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
Working capital turnover
Average No. Days
Average inventory processing period 19 19 22 22 22 24 26 25 25 27 27 27 27 29 31 29 28 29 30
Add: Average receivable collection period 33 33 36 35 32 31 31 31 32 32 31 32 32 32 30 33 31 32 28
Operating cycle 52 52 58 57 54 55 57 56 57 59 58 59 59 61 61 62 59 61 58
Less: Average payables payment period 17 16 18 19 17 17 20 19 19 19 19 20 18 18 19 20 17 17 18
Cash conversion cycle 35 36 40 38 37 38 37 37 38 40 39 39 41 43 42 42 42 44 40

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

CVS Health Corp., inventory turnover calculation (quarterly data)

Microsoft Excel
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

CVS Health Corp., receivables turnover calculation (quarterly data)

Microsoft Excel
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

CVS Health Corp., payables turnover calculation (quarterly data)

Microsoft Excel
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

CVS Health Corp., working capital turnover calculation (quarterly data)

Microsoft Excel
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

CVS Health Corp., average inventory processing period calculation (quarterly data)

Microsoft Excel
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

CVS Health Corp., average receivable collection period calculation (quarterly data)

Microsoft Excel
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

CVS Health Corp., operating cycle calculation (quarterly data)

No. days

Microsoft Excel
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

CVS Health Corp., average payables payment period calculation (quarterly data)

Microsoft Excel
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

CVS Health Corp., cash conversion cycle calculation (quarterly data)

No. days

Microsoft Excel
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 + 3317 = 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.