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
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 Dec 31, 2019 Sep 30, 2019 Jun 30, 2019 Mar 31, 2019
Turnover Ratios
Inventory turnover 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 37.84 36.30 38.13 36.70
Payables turnover 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 8.02 8.30 9.06 9.34
Working capital turnover
Average No. Days
Average inventory processing period 11 12 12 15 12 13 12 14 12 11 11 12 10 10 10 11 10 10 10 10
Less: Average payables payment period 62 65 62 54 54 53 51 50 49 49 46 48 47 48 47 47 46 44 40 39

Based on: 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), 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 deteriorated from Q1 2024 to Q2 2024 but then improved from Q2 2024 to Q3 2024 exceeding Q1 2024 level.
Payables turnover An activity ratio calculated as cost of goods sold divided by payables. Cigna Group payables turnover ratio decreased from Q1 2024 to Q2 2024 but then increased from Q2 2024 to Q3 2024 not reaching Q1 2024 level.

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 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
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 Dec 31, 2019 Sep 30, 2019 Jun 30, 2019 Mar 31, 2019
Selected Financial Data (US$ in millions)
Pharmacy and other service costs 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 24,103 24,552 24,963 24,050
Inventories 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 2,661 2,160 2,298 2,382
Short-term Activity Ratio
Inventory turnover1 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 37.84 36.30 38.13 36.70
Benchmarks
Inventory Turnover, Competitors2
Abbott Laboratories 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 2.71 2.56 2.92 3.07
CVS Health Corp. 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 12.43 13.03 12.68 12.06
Intuitive Surgical Inc. 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 2.18 2.22 2.30 2.30
Medtronic PLC 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 2.44

Based on: 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), 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 Q3 2024 Calculation
Inventory turnover = (Pharmacy and other service costsQ3 2024 + Pharmacy and other service costsQ2 2024 + Pharmacy and other service costsQ1 2024 + Pharmacy and other service costsQ4 2023) ÷ Inventories
= (47,565 + 44,492 + 41,431 + 35,261) ÷ 5,083 = 33.20

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 deteriorated from Q1 2024 to Q2 2024 but then improved from Q2 2024 to Q3 2024 exceeding Q1 2024 level.

Payables Turnover

Cigna Group, payables turnover calculation (quarterly data)

Microsoft Excel
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 Dec 31, 2019 Sep 30, 2019 Jun 30, 2019 Mar 31, 2019
Selected Financial Data (US$ in millions)
Pharmacy and other service costs 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 24,103 24,552 24,963 24,050
Pharmacy and other service costs payable 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 10,454 10,857 11,397 11,145
Short-term Activity Ratio
Payables turnover1 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 8.02 8.30 9.06 9.34
Benchmarks
Payables Turnover, Competitors2
Abbott Laboratories 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 4.37 4.00 4.20 4.07
CVS Health Corp. 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 18.61 21.70 21.06 20.13
Elevance Health Inc. 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 8.32 8.42 8.48 9.25
Humana Inc. 8.81 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. 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 12.46 13.18 10.69 11.08
Medtronic PLC 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 4.69
UnitedHealth Group Inc. 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 7.40 8.02 6.96 7.21

Based on: 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), 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 Q3 2024 Calculation
Payables turnover = (Pharmacy and other service costsQ3 2024 + Pharmacy and other service costsQ2 2024 + Pharmacy and other service costsQ1 2024 + Pharmacy and other service costsQ4 2023) ÷ Pharmacy and other service costs payable
= (47,565 + 44,492 + 41,431 + 35,261) ÷ 28,801 = 5.86

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 Q1 2024 to Q2 2024 but then increased from Q2 2024 to Q3 2024 not reaching Q1 2024 level.

Working Capital Turnover

Cigna Group, working capital turnover calculation (quarterly data)

Microsoft Excel
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 Dec 31, 2019 Sep 30, 2019 Jun 30, 2019 Mar 31, 2019
Selected Financial Data (US$ in millions)
Current assets 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 29,845 21,168 20,709 21,136
Less: Current liabilities 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 40,138 34,447 31,867 32,969
Working capital (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) (10,293) (13,279) (11,158) (11,833)
 
Pharmacy revenues 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 25,645 25,987 26,288 25,179
Short-term Activity Ratio
Working capital turnover1
Benchmarks
Working Capital Turnover, Competitors2
Abbott Laboratories 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 4.52 5.02 6.84 6.64
CVS Health Corp.
Elevance Health Inc. 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 5.98 5.40 6.81 6.11
Humana Inc. 8.01 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.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 0.80 0.88 1.23 1.23
Medtronic PLC 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 2.26
UnitedHealth Group Inc.

Based on: 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), 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 Q3 2024 Calculation
Working capital turnover = (Pharmacy revenuesQ3 2024 + Pharmacy revenuesQ2 2024 + Pharmacy revenuesQ1 2024 + Pharmacy revenuesQ4 2023) ÷ Working capital
= (48,284 + 45,101 + 42,036 + 36,604) ÷ -7,838 =

2 Click competitor name to see calculations.


Average Inventory Processing Period

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

Microsoft Excel
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 Dec 31, 2019 Sep 30, 2019 Jun 30, 2019 Mar 31, 2019
Selected Financial Data
Inventory turnover 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 37.84 36.30 38.13 36.70
Short-term Activity Ratio (no. days)
Average inventory processing period1 11 12 12 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 136 136 138 133 135 139 132 118 108 113 109 102 105 111 122 122 135 142 125 119
CVS Health Corp. 20 19 19 22 22 22 24 26 25 25 27 27 27 27 29 31 29 28 29 30
Intuitive Surgical Inc. 208 201 193 186 183 166 162 161 155 139 130 122 126 129 138 147 167 164 159 159
Medtronic PLC 187 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-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), 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 Q3 2024 Calculation
Average inventory processing period = 365 ÷ Inventory turnover
= 365 ÷ 33.20 = 11

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 Payables Payment Period

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

Microsoft Excel
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 Dec 31, 2019 Sep 30, 2019 Jun 30, 2019 Mar 31, 2019
Selected Financial Data
Payables turnover 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 8.02 8.30 9.06 9.34
Short-term Activity Ratio (no. days)
Average payables payment period1 62 65 62 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 80 83 84 87 80 85 82 88 78 86 91 87 80 82 92 96 83 91 87 90
CVS Health Corp. 18 17 16 18 19 17 17 20 19 19 19 19 20 18 18 19 20 17 17 18
Elevance Health Inc. 45 45 48 47 48 48 48 49 49 50 50 48 50 50 50 47 44 43 43 39
Humana Inc. 41 44 47 42 44 47 47 45 45 48 48 44 47 47 50 48 51 51 46 41
Intuitive Surgical Inc. 31 28 29 29 31 33 28 26 30 29 25 25 26 27 25 20 29 28 34 33
Medtronic PLC 65 72 75 91 78 79 79 82 71 67 64 73 66 70 66 77 74 75 75 78
UnitedHealth Group Inc. 48 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-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), 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 Q3 2024 Calculation
Average payables payment period = 365 ÷ Payables turnover
= 365 ÷ 5.86 = 62

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.