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, 2024 Sep 30, 2024 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
Turnover Ratios
Inventory turnover 27.27 33.20 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
Payables turnover 6.41 5.86 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
Working capital turnover
Average No. Days
Average inventory processing period 13 11 12 12 15 12 13 12 14 12 11 11 12 10 10 10 11
Less: Average payables payment period 57 62 65 62 54 54 53 51 50 49 49 46 48 47 48 47 47

Based on: 10-K (reporting date: 2024-12-31), 10-Q (reporting date: 2024-09-30), 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).

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

Inventory Turnover

Cigna Group, inventory turnover calculation (quarterly data)

Microsoft Excel
Dec 31, 2024 Sep 30, 2024 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
Selected Financial Data (US$ in millions)
Pharmacy and other service costs 49,021 47,565 44,492 41,431 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
Inventories 6,692 5,083 5,173 4,630 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
Short-term Activity Ratio
Inventory turnover1 27.27 33.20 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
Benchmarks
Inventory Turnover, Competitors2
Abbott Laboratories 3.02 2.69 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
CVS Health Corp. 17.75 17.93 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
Intuitive Surgical Inc. 1.83 1.75 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
Medtronic PLC 2.15 1.95 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

Based on: 10-K (reporting date: 2024-12-31), 10-Q (reporting date: 2024-09-30), 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).

1 Q4 2024 Calculation
Inventory turnover = (Pharmacy and other service costsQ4 2024 + Pharmacy and other service costsQ3 2024 + Pharmacy and other service costsQ2 2024 + Pharmacy and other service costsQ1 2024) ÷ Inventories
= (49,021 + 47,565 + 44,492 + 41,431) ÷ 6,692 = 27.27

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 2024 to Q3 2024 but then deteriorated significantly from Q3 2024 to Q4 2024.

Payables Turnover

Cigna Group, payables turnover calculation (quarterly data)

Microsoft Excel
Dec 31, 2024 Sep 30, 2024 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
Selected Financial Data (US$ in millions)
Pharmacy and other service costs 49,021 47,565 44,492 41,431 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
Pharmacy and other service costs payable 28,465 28,801 27,503 24,284 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
Short-term Activity Ratio
Payables turnover1 6.41 5.86 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
Benchmarks
Payables Turnover, Competitors2
Abbott Laboratories 4.46 4.54 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
CVS Health Corp. 20.22 20.14 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
Elevance Health Inc. 8.10 8.17 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
Intuitive Surgical Inc. 14.05 11.88 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
Medtronic PLC 4.65 5.60 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
UnitedHealth Group Inc. 7.72 7.64 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

Based on: 10-K (reporting date: 2024-12-31), 10-Q (reporting date: 2024-09-30), 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).

1 Q4 2024 Calculation
Payables turnover = (Pharmacy and other service costsQ4 2024 + Pharmacy and other service costsQ3 2024 + Pharmacy and other service costsQ2 2024 + Pharmacy and other service costsQ1 2024) ÷ Pharmacy and other service costs payable
= (49,021 + 47,565 + 44,492 + 41,431) ÷ 28,465 = 6.41

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 increased from Q2 2024 to Q3 2024 and from Q3 2024 to Q4 2024.

Working Capital Turnover

Cigna Group, working capital turnover calculation (quarterly data)

Microsoft Excel
Dec 31, 2024 Sep 30, 2024 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
Selected Financial Data (US$ in millions)
Current assets 48,870 49,222 46,215 43,357 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
Less: Current liabilities 57,979 57,060 55,373 51,977 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
Working capital (9,109) (7,838) (9,158) (8,620) (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)
 
Pharmacy revenues 49,941 48,284 45,101 42,036 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
Short-term Activity Ratio
Working capital turnover1
Benchmarks
Working Capital Turnover, Competitors2
Abbott Laboratories 4.42 4.63 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
CVS Health Corp.
Elevance Health Inc. 7.85 6.87 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
Intuitive Surgical Inc. 1.56 1.42 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
Medtronic PLC 2.90 2.54 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
UnitedHealth Group Inc.

Based on: 10-K (reporting date: 2024-12-31), 10-Q (reporting date: 2024-09-30), 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).

1 Q4 2024 Calculation
Working capital turnover = (Pharmacy revenuesQ4 2024 + Pharmacy revenuesQ3 2024 + Pharmacy revenuesQ2 2024 + Pharmacy revenuesQ1 2024) ÷ Working capital
= (49,941 + 48,284 + 45,101 + 42,036) ÷ -9,109 =

2 Click competitor name to see calculations.


Average Inventory Processing Period

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

Microsoft Excel
Dec 31, 2024 Sep 30, 2024 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
Selected Financial Data
Inventory turnover 27.27 33.20 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
Short-term Activity Ratio (no. days)
Average inventory processing period1 13 11 12 12 15 12 13 12 14 12 11 11 12 10 10 10 11
Benchmarks (no. days)
Average Inventory Processing Period, Competitors2
Abbott Laboratories 121 136 136 138 133 135 139 132 118 108 113 109 102 105 111 122 122
CVS Health Corp. 21 20 19 19 22 22 22 24 26 25 25 27 27 27 27 29 31
Intuitive Surgical Inc. 200 208 201 193 186 183 166 162 161 155 139 130 122 126 129 138 147
Medtronic PLC 170 187 190 191 180 190 183 174 166 161 153 148 150 163 166 174 164 156 155 154

Based on: 10-K (reporting date: 2024-12-31), 10-Q (reporting date: 2024-09-30), 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).

1 Q4 2024 Calculation
Average inventory processing period = 365 ÷ Inventory turnover
= 365 ÷ 27.27 = 13

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 2024 to Q3 2024 but then deteriorated significantly from Q3 2024 to Q4 2024.

Average Payables Payment Period

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

Microsoft Excel
Dec 31, 2024 Sep 30, 2024 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
Selected Financial Data
Payables turnover 6.41 5.86 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
Short-term Activity Ratio (no. days)
Average payables payment period1 57 62 65 62 54 54 53 51 50 49 49 46 48 47 48 47 47
Benchmarks (no. days)
Average Payables Payment Period, Competitors2
Abbott Laboratories 82 80 83 84 87 80 85 82 88 78 86 91 87 80 82 92 96
CVS Health Corp. 18 18 17 16 18 19 17 17 20 19 19 19 19 20 18 18 19
Elevance Health Inc. 45 45 45 48 47 48 48 48 49 49 50 50 48 50 50 50 47
Intuitive Surgical Inc. 26 31 28 29 29 31 33 28 26 30 29 25 25 26 27 25 20
Medtronic PLC 78 65 72 75 91 78 79 79 82 71 67 64 73 66 70 66 77 74 75 75
UnitedHealth Group Inc. 47 48 47 50 49 51 52 53 50 52 53 54 48 52 52 56 50

Based on: 10-K (reporting date: 2024-12-31), 10-Q (reporting date: 2024-09-30), 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).

1 Q4 2024 Calculation
Average payables payment period = 365 ÷ Payables turnover
= 365 ÷ 6.41 = 57

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. Cigna Group number of days of payables outstanding decreased from Q2 2024 to Q3 2024 and from Q3 2024 to Q4 2024.