Stock Analysis on Net

UnitedHealth Group Inc. (NYSE:UNH)

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

Microsoft Excel

Short-term Activity Ratios (Summary)

UnitedHealth Group Inc., 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
Receivables turnover 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
Payables turnover 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
Working capital turnover
Average No. Days
Average receivable collection period 21 21 19 25 20 20 22 23 18 19 20 22 18 18 19 22 18
Average payables payment period 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).

Short-term activity ratio Description The company
Receivables turnover An activity ratio equal to revenue divided by receivables. UnitedHealth Group Inc. receivables turnover ratio deteriorated from Q2 2023 to Q3 2023 but then slightly improved from Q3 2023 to Q4 2023.
Payables turnover An activity ratio calculated as cost of goods sold divided by payables. UnitedHealth Group Inc. payables turnover ratio increased from Q2 2023 to Q3 2023 and from Q3 2023 to Q4 2023.

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

Receivables Turnover

UnitedHealth Group Inc., receivables 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)
Revenues, customers 93,248 91,364 91,788 91,133 81,932 80,381 80,037 79,782 72,930 71,834 70,765 69,744 65,022 64,764 61,797 64,056 60,468 59,885 60,013 59,903
Accounts receivable, net 21,276 20,673 17,952 22,414 17,681 17,047 18,718 18,871 14,216 14,152 14,587 15,980 12,870 12,171 12,546 14,613 11,822 10,964 9,741 12,826
Short-term Activity Ratio
Receivables turnover1 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
Benchmarks
Receivables Turnover, Competitors2
Abbott Laboratories 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
CVS Health Corp. 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
Elevance Health Inc. 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. 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.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.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 5.22 5.29 5.28
Shockwave Medical Inc. 6.37 6.79 6.39 6.61 6.86 6.69 6.08 6.25 6.33 5.86 5.21 4.31 5.80 5.54 8.03 6.51 5.82

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
Receivables turnover = (Revenues, customersQ4 2023 + Revenues, customersQ3 2023 + Revenues, customersQ2 2023 + Revenues, customersQ1 2023) ÷ Accounts receivable, net
= (93,248 + 91,364 + 91,788 + 91,133) ÷ 21,276 = 17.27

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. UnitedHealth Group Inc. receivables turnover ratio deteriorated from Q2 2023 to Q3 2023 but then slightly improved from Q3 2023 to Q4 2023.

Payables Turnover

UnitedHealth Group Inc., 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)
Medical costs 62,231 59,550 60,268 59,845 53,591 52,635 52,093 52,523 48,159 47,302 46,546 44,904 42,082 41,636 34,678 41,000 39,276 39,041 39,184 38,939
Medical costs payable 32,395 32,792 31,947 31,809 29,056 29,064 28,978 28,676 24,483 25,918 25,131 24,833 21,872 21,167 19,200 22,772 21,690 20,939 20,907 21,139
Short-term Activity Ratio
Payables turnover1 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
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
Cigna Group 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
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

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 = (Medical costsQ4 2023 + Medical costsQ3 2023 + Medical costsQ2 2023 + Medical costsQ1 2023) ÷ Medical costs payable
= (62,231 + 59,550 + 60,268 + 59,845) ÷ 32,395 = 7.47

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

Working Capital Turnover

UnitedHealth Group Inc., 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 78,437 91,905 89,869 93,895 69,069 82,937 68,356 69,029 61,758 61,610 58,916 59,508 53,718 54,821 58,918 58,807 42,634 43,541 42,038 42,815
Less: Current liabilities 99,054 114,179 112,981 116,482 89,237 100,935 88,698 88,170 78,292 79,575 76,557 80,641 72,420 66,597 69,883 78,606 61,782 62,641 62,328 58,933
Working capital (20,617) (22,274) (23,112) (22,587) (20,168) (17,998) (20,342) (19,141) (16,534) (17,965) (17,641) (21,133) (18,702) (11,776) (10,965) (19,799) (19,148) (19,100) (20,290) (16,118)
 
Revenues, customers 93,248 91,364 91,788 91,133 81,932 80,381 80,037 79,782 72,930 71,834 70,765 69,744 65,022 64,764 61,797 64,056 60,468 59,885 60,013 59,903
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
Cigna Group
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

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 = (Revenues, customersQ4 2023 + Revenues, customersQ3 2023 + Revenues, customersQ2 2023 + Revenues, customersQ1 2023) ÷ Working capital
= (93,248 + 91,364 + 91,788 + 91,133) ÷ -20,617 =

2 Click competitor name to see calculations.


Average Receivable Collection Period

UnitedHealth Group Inc., average receivable collection 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
Receivables turnover 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
Short-term Activity Ratio (no. days)
Average receivable collection period1 21 21 19 25 20 20 22 23 18 19 20 22 18 18 19 22 18
Benchmarks (no. days)
Average Receivable Collection Period, Competitors2
Abbott Laboratories 60 59 56 53 52 52 58 59 55 55 55 60 68 64 60 60 62
CVS Health Corp. 36 35 32 31 31 31 32 32 31 32 32 32 30 33 31 32 28
Elevance Health Inc. 20 20 19 22 19 19 19 22 18 19 19 21 19 19 20 22 20
Humana Inc. 7 7 5 12 7 6 14 13 8 9 11 10 5 6 12 11 6
Intuitive Surgical Inc. 58 51 50 53 55 51 51 56 50 46 49 52 54 50 43 42 53
Medtronic PLC 70 70 67 62 64 63 63 63 66 68 70 64 59 73 72 70 74 70 69 69
Shockwave Medical Inc. 57 54 57 55 53 55 60 58 58 62 70 85 63 66 45 56 63

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 receivable collection period = 365 ÷ Receivables turnover
= 365 ÷ 17.27 = 21

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.

Average Payables Payment Period

UnitedHealth Group Inc., 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 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
Short-term Activity Ratio (no. days)
Average payables payment period1 49 51 52 53 50 52 53 54 48 52 52 56 50 49 46 52 51
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
Cigna Group 54 54 53 51 50 49 49 46 48 47 48 47 47 46 44 40 39
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

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 ÷ 7.47 = 49

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