Stock Analysis on Net

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

Microsoft Excel

Short-term Activity Ratios (Summary)

Cigna Group, short-term (operating) activity ratios (quarterly data)

Microsoft Excel
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 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
Payables turnover 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
Working capital turnover
Average No. Days
Average inventory processing period 15 12 13 12 14 12 11 11 12 10 10 10 11 10 10 10 10
Less: Average payables payment period 54 54 53 51 50 49 49 46 48 47 48 47 47 46 44 40 39

Based on: 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. Cigna Group inventory turnover ratio improved from Q2 2023 to Q3 2023 but then deteriorated significantly from Q3 2023 to Q4 2023.
Payables turnover An activity ratio calculated as cost of goods sold divided by payables. Cigna Group payables turnover ratio decreased from Q2 2023 to Q3 2023 and from Q3 2023 to Q4 2023.

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. Cigna Group number of days of inventory outstanding improved from Q2 2023 to Q3 2023 but then deteriorated significantly from Q3 2023 to Q4 2023.
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.

Inventory Turnover

Cigna Group, inventory turnover calculation (quarterly data)

Microsoft Excel
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)
Pharmacy and other service costs 35,261 33,639 33,442 31,459 32,094 31,777 31,150 29,813 31,247 30,070 29,001 27,235 27,059 26,624 25,611 24,190 24,103 24,552 24,963 24,050
Inventories 5,645 4,416 4,514 4,211 4,777 4,017 3,781 3,500 3,722 3,020 3,042 2,919 3,165 2,657 2,712 2,565 2,661 2,160 2,298 2,382
Short-term Activity Ratio
Inventory turnover1 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
Benchmarks
Inventory Turnover, Competitors2
Abbott Laboratories 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
CVS Health Corp. 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
Intuitive Surgical Inc. 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 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 2.35 2.39 2.42
Shockwave Medical Inc. 0.89 0.90 0.88 0.88 0.87 0.87 0.89 0.87 0.96 0.91 0.82 0.69 0.70 0.70 0.82 1.24 1.42

Based on: 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 Q4 2023 Calculation
Inventory turnover = (Pharmacy and other service costsQ4 2023 + Pharmacy and other service costsQ3 2023 + Pharmacy and other service costsQ2 2023 + Pharmacy and other service costsQ1 2023) ÷ Inventories
= (35,261 + 33,639 + 33,442 + 31,459) ÷ 5,645 = 23.70

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. Cigna Group inventory turnover ratio improved from Q2 2023 to Q3 2023 but then deteriorated significantly from Q3 2023 to Q4 2023.

Payables Turnover

Cigna Group, payables turnover calculation (quarterly data)

Microsoft Excel
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)
Pharmacy and other service costs 35,261 33,639 33,442 31,459 32,094 31,777 31,150 29,813 31,247 30,070 29,001 27,235 27,059 26,624 25,611 24,190 24,103 24,552 24,963 24,050
Pharmacy and other service costs payable 19,815 19,320 18,617 17,609 17,070 16,676 16,432 15,235 15,309 14,705 14,470 13,762 13,347 12,539 11,856 10,797 10,454 10,857 11,397 11,145
Short-term Activity Ratio
Payables turnover1 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
Benchmarks
Payables Turnover, Competitors2
Abbott Laboratories 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
CVS Health Corp. 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
Elevance Health Inc. 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.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.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 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 5.31 5.16 4.98
Shockwave Medical Inc. 10.76 12.75 6.29 6.62 9.67 17.34 10.11 5.48 11.77 9.70 11.23 6.23 14.32 10.18 7.49 9.18 6.15
UnitedHealth Group Inc. 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-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 Q4 2023 Calculation
Payables turnover = (Pharmacy and other service costsQ4 2023 + Pharmacy and other service costsQ3 2023 + Pharmacy and other service costsQ2 2023 + Pharmacy and other service costsQ1 2023) ÷ Pharmacy and other service costs payable
= (35,261 + 33,639 + 33,442 + 31,459) ÷ 19,815 = 6.75

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. Cigna Group payables turnover ratio decreased from Q2 2023 to Q3 2023 and from Q3 2023 to Q4 2023.

Working Capital Turnover

Cigna Group, working capital turnover calculation (quarterly data)

Microsoft Excel
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 37,351 34,518 34,711 32,027 30,120 30,170 37,422 35,393 36,134 25,487 25,011 25,554 27,799 34,557 34,880 30,877 29,845 21,168 20,709 21,136
Less: Current liabilities 48,716 47,059 47,345 44,727 41,229 41,115 45,218 43,662 43,572 36,340 34,711 33,470 36,022 43,886 42,179 40,380 40,138 34,447 31,867 32,969
Working capital (11,365) (12,541) (12,634) (12,700) (11,109) (10,945) (7,796) (8,269) (7,438) (10,853) (9,700) (7,916) (8,223) (9,329) (7,299) (9,503) (10,293) (13,279) (11,158) (11,833)
 
Pharmacy revenues 36,604 34,531 33,964 32,144 33,135 32,762 31,972 30,697 32,328 31,013 30,047 28,025 28,305 27,802 26,564 25,098 25,645 25,987 26,288 25,179
Short-term Activity Ratio
Working capital turnover1
Benchmarks
Working Capital Turnover, Competitors2
Abbott Laboratories 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
CVS Health Corp.
Elevance Health Inc. 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. 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.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.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 2.54 2.30 2.24
Shockwave Medical Inc. 0.65 0.64 1.64 1.24 1.24 1.26 1.27 1.15 1.01 0.81 0.64 0.42 0.31 0.25 0.21 0.28 0.22
UnitedHealth Group Inc.

Based on: 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 Q4 2023 Calculation
Working capital turnover = (Pharmacy revenuesQ4 2023 + Pharmacy revenuesQ3 2023 + Pharmacy revenuesQ2 2023 + Pharmacy revenuesQ1 2023) ÷ Working capital
= (36,604 + 34,531 + 33,964 + 32,144) ÷ -11,365 =

2 Click competitor name to see calculations.


Average Inventory Processing Period

Cigna Group, average inventory processing period calculation (quarterly data)

Microsoft Excel
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 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
Short-term Activity Ratio (no. days)
Average inventory processing period1 15 12 13 12 14 12 11 11 12 10 10 10 11 10 10 10 10
Benchmarks (no. days)
Average Inventory Processing Period, Competitors2
Abbott Laboratories 133 135 139 132 118 108 113 109 102 105 111 122 122 135 142 125 119
CVS Health Corp. 22 22 22 24 26 25 25 27 27 27 27 29 31 29 28 29 30
Intuitive Surgical Inc. 186 183 166 162 161 155 139 130 122 126 129 138 147 167 164 159 159
Medtronic PLC 180 190 183 174 166 161 153 148 150 163 166 174 164 156 155 154 150 156 153 151
Shockwave Medical Inc. 412 405 415 415 422 418 412 419 379 401 446 527 519 525 445 294 257

Based on: 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 Q4 2023 Calculation
Average inventory processing period = 365 ÷ Inventory turnover
= 365 ÷ 23.70 = 15

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. Cigna Group number of days of inventory outstanding improved from Q2 2023 to Q3 2023 but then deteriorated significantly from Q3 2023 to Q4 2023.

Average Payables Payment Period

Cigna Group, average payables payment period calculation (quarterly data)

Microsoft Excel
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 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
Short-term Activity Ratio (no. days)
Average payables payment period1 54 54 53 51 50 49 49 46 48 47 48 47 47 46 44 40 39
Benchmarks (no. days)
Average Payables Payment Period, Competitors2
Abbott Laboratories 87 80 85 82 88 78 86 91 87 80 82 92 96 83 91 87 90
CVS Health Corp. 18 19 17 17 20 19 19 19 19 20 18 18 19 20 17 17 18
Elevance Health Inc. 47 48 48 48 49 49 50 50 48 50 50 50 47 44 43 43 39
Humana Inc. 42 44 47 47 45 45 48 48 44 47 47 50 48 51 51 46 41
Intuitive Surgical Inc. 29 31 33 28 26 30 29 25 25 26 27 25 20 29 28 34 33
Medtronic PLC 91 78 79 79 82 71 67 64 73 66 70 66 77 74 75 75 78 69 71 73
Shockwave Medical Inc. 34 29 58 55 38 21 36 67 31 38 32 59 25 36 49 40 59
UnitedHealth Group Inc. 49 51 52 53 50 52 53 54 48 52 52 56 50 49 46 52 51

Based on: 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 Q4 2023 Calculation
Average payables payment period = 365 ÷ Payables turnover
= 365 ÷ 6.75 = 54

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.