Stock Analysis on Net

Humana Inc. (NYSE:HUM)

Analysis of Short-term (Operating) Activity Ratios

Microsoft Excel

Short-term Activity Ratios (Summary)

Humana Inc., short-term (operating) activity ratios

Microsoft Excel
Dec 31, 2023 Dec 31, 2022 Dec 31, 2021 Dec 31, 2020 Dec 31, 2019
Turnover Ratios
Receivables turnover 51.75 55.25 45.69 66.78 60.97
Payables turnover 8.63 8.17 8.35 7.57 8.97
Working capital turnover 9.47 10.27 8.67 7.42 7.19
Average No. Days
Average receivable collection period 7 7 8 5 6
Average payables payment period 42 45 44 48 41

Based on: 10-K (reporting date: 2023-12-31), 10-K (reporting date: 2022-12-31), 10-K (reporting date: 2021-12-31), 10-K (reporting date: 2020-12-31), 10-K (reporting date: 2019-12-31).

Short-term activity ratio Description The company
Receivables turnover An activity ratio equal to revenue divided by receivables. Humana Inc. receivables turnover ratio improved from 2021 to 2022 but then slightly deteriorated from 2022 to 2023.
Payables turnover An activity ratio calculated as cost of goods sold divided by payables. Humana Inc. payables turnover ratio decreased from 2021 to 2022 but then increased from 2022 to 2023 exceeding 2021 level.
Working capital turnover An activity ratio calculated as revenue divided by working capital. Humana Inc. working capital turnover ratio improved from 2021 to 2022 but then slightly deteriorated from 2022 to 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. Humana Inc. number of days of payables outstanding increased from 2021 to 2022 but then decreased significantly from 2022 to 2023.

Receivables Turnover

Humana Inc., receivables turnover calculation, comparison to benchmarks

Microsoft Excel
Dec 31, 2023 Dec 31, 2022 Dec 31, 2021 Dec 31, 2020 Dec 31, 2019
Selected Financial Data (US$ in millions)
External revenues 105,305 92,488 82,877 76,001 64,387
Receivables, net of allowances 2,035 1,674 1,814 1,138 1,056
Short-term Activity Ratio
Receivables turnover1 51.75 55.25 45.69 66.78 60.97
Benchmarks
Receivables Turnover, Competitors2
Abbott Laboratories 6.11 7.02 6.64 5.40 5.88
Cigna Group 17.06 18.64 19.35 19.47 20.05
CVS Health Corp. 10.12 11.79 11.91 12.32 13.04
Danaher Corp. 6.09 6.40 6.36 5.51 5.61
Elevance Health Inc. 18.08 18.81 20.66 19.72 18.20
Intuitive Surgical Inc. 6.30 6.60 7.30 6.75 6.94
Medtronic PLC 5.21 5.71 5.51 6.22 4.91
UnitedHealth Group Inc. 17.27 18.22 20.07 19.86 20.32
Receivables Turnover, Sector
Health Care Equipment & Services 13.16 14.20 14.42 14.47 14.45
Receivables Turnover, Industry
Health Care 9.04 9.74 9.53 9.60 9.90

Based on: 10-K (reporting date: 2023-12-31), 10-K (reporting date: 2022-12-31), 10-K (reporting date: 2021-12-31), 10-K (reporting date: 2020-12-31), 10-K (reporting date: 2019-12-31).

1 2023 Calculation
Receivables turnover = External revenues ÷ Receivables, net of allowances
= 105,305 ÷ 2,035 = 51.75

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. Humana Inc. receivables turnover ratio improved from 2021 to 2022 but then slightly deteriorated from 2022 to 2023.

Payables Turnover

Humana Inc., payables turnover calculation, comparison to benchmarks

Microsoft Excel
Dec 31, 2023 Dec 31, 2022 Dec 31, 2021 Dec 31, 2020 Dec 31, 2019
Selected Financial Data (US$ in millions)
Benefits 88,394 75,690 69,199 61,628 53,857
Benefits payable 10,241 9,264 8,289 8,143 6,004
Short-term Activity Ratio
Payables turnover1 8.63 8.17 8.35 7.57 8.97
Benchmarks
Payables Turnover, Competitors2
Abbott Laboratories 4.19 4.15 4.21 3.80 4.07
Cigna Group 6.75 7.31 7.68 7.75 9.34
CVS Health Corp. 20.36 18.07 19.14 19.72 20.13
Danaher Corp. 5.58 5.45 4.48 4.79 5.23
Elevance Health Inc. 7.72 7.47 7.59 7.75 9.25
Intuitive Surgical Inc. 12.69 13.78 14.45 18.35 11.08
Medtronic PLC 4.03 4.46 4.98 4.72 4.69
UnitedHealth Group Inc. 7.47 7.26 7.63 7.29 7.21
Payables Turnover, Sector
Health Care Equipment & Services 9.11 8.83 9.10 9.03 9.84
Payables Turnover, Industry
Health Care 7.85 7.53 7.68 7.52 8.05

Based on: 10-K (reporting date: 2023-12-31), 10-K (reporting date: 2022-12-31), 10-K (reporting date: 2021-12-31), 10-K (reporting date: 2020-12-31), 10-K (reporting date: 2019-12-31).

1 2023 Calculation
Payables turnover = Benefits ÷ Benefits payable
= 88,394 ÷ 10,241 = 8.63

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. Humana Inc. payables turnover ratio decreased from 2021 to 2022 but then increased from 2022 to 2023 exceeding 2021 level.

Working Capital Turnover

Humana Inc., working capital turnover calculation, comparison to benchmarks

Microsoft Excel
Dec 31, 2023 Dec 31, 2022 Dec 31, 2021 Dec 31, 2020 Dec 31, 2019
Selected Financial Data (US$ in millions)
Current assets 29,986 26,183 24,893 23,641 19,888
Less: Current liabilities 18,872 17,178 15,331 13,394 10,929
Working capital 11,114 9,005 9,562 10,247 8,959
 
External revenues 105,305 92,488 82,877 76,001 64,387
Short-term Activity Ratio
Working capital turnover1 9.47 10.27 8.67 7.42 7.19
Benchmarks
Working Capital Turnover, Competitors2
Abbott Laboratories 4.54 4.48 3.87 4.06 6.64
Cigna Group
CVS Health Corp.
Danaher Corp. 4.22 4.20 8.40 3.48 0.87
Elevance Health Inc. 7.83 8.37 7.23 6.39 6.11
Intuitive Surgical Inc. 1.14 1.29 1.22 0.77 1.23
Medtronic PLC 2.47 2.97 2.15 2.48 2.26
UnitedHealth Group Inc.
Working Capital Turnover, Sector
Health Care Equipment & Services 62.52 49.78 36.72 34.37 24.40
Working Capital Turnover, Industry
Health Care 22.08 20.51 14.48 14.33 9.16

Based on: 10-K (reporting date: 2023-12-31), 10-K (reporting date: 2022-12-31), 10-K (reporting date: 2021-12-31), 10-K (reporting date: 2020-12-31), 10-K (reporting date: 2019-12-31).

1 2023 Calculation
Working capital turnover = External revenues ÷ Working capital
= 105,305 ÷ 11,114 = 9.47

2 Click competitor name to see calculations.

Short-term activity ratio Description The company
Working capital turnover An activity ratio calculated as revenue divided by working capital. Humana Inc. working capital turnover ratio improved from 2021 to 2022 but then slightly deteriorated from 2022 to 2023.

Average Receivable Collection Period

Humana Inc., average receivable collection period calculation, comparison to benchmarks

Microsoft Excel
Dec 31, 2023 Dec 31, 2022 Dec 31, 2021 Dec 31, 2020 Dec 31, 2019
Selected Financial Data
Receivables turnover 51.75 55.25 45.69 66.78 60.97
Short-term Activity Ratio (no. days)
Average receivable collection period1 7 7 8 5 6
Benchmarks (no. days)
Average Receivable Collection Period, Competitors2
Abbott Laboratories 60 52 55 68 62
Cigna Group 21 20 19 19 18
CVS Health Corp. 36 31 31 30 28
Danaher Corp. 60 57 57 66 65
Elevance Health Inc. 20 19 18 19 20
Intuitive Surgical Inc. 58 55 50 54 53
Medtronic PLC 70 64 66 59 74
UnitedHealth Group Inc. 21 20 18 18 18
Average Receivable Collection Period, Sector
Health Care Equipment & Services 28 26 25 25 25
Average Receivable Collection Period, Industry
Health Care 40 37 38 38 37

Based on: 10-K (reporting date: 2023-12-31), 10-K (reporting date: 2022-12-31), 10-K (reporting date: 2021-12-31), 10-K (reporting date: 2020-12-31), 10-K (reporting date: 2019-12-31).

1 2023 Calculation
Average receivable collection period = 365 ÷ Receivables turnover
= 365 ÷ 51.75 = 7

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

Humana Inc., average payables payment period calculation, comparison to benchmarks

Microsoft Excel
Dec 31, 2023 Dec 31, 2022 Dec 31, 2021 Dec 31, 2020 Dec 31, 2019
Selected Financial Data
Payables turnover 8.63 8.17 8.35 7.57 8.97
Short-term Activity Ratio (no. days)
Average payables payment period1 42 45 44 48 41
Benchmarks (no. days)
Average Payables Payment Period, Competitors2
Abbott Laboratories 87 88 87 96 90
Cigna Group 54 50 48 47 39
CVS Health Corp. 18 20 19 19 18
Danaher Corp. 65 67 82 76 70
Elevance Health Inc. 47 49 48 47 39
Intuitive Surgical Inc. 29 26 25 20 33
Medtronic PLC 91 82 73 77 78
UnitedHealth Group Inc. 49 50 48 50 51
Average Payables Payment Period, Sector
Health Care Equipment & Services 40 41 40 40 37
Average Payables Payment Period, Industry
Health Care 47 48 48 49 45

Based on: 10-K (reporting date: 2023-12-31), 10-K (reporting date: 2022-12-31), 10-K (reporting date: 2021-12-31), 10-K (reporting date: 2020-12-31), 10-K (reporting date: 2019-12-31).

1 2023 Calculation
Average payables payment period = 365 ÷ Payables turnover
= 365 ÷ 8.63 = 42

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. Humana Inc. number of days of payables outstanding increased from 2021 to 2022 but then decreased significantly from 2022 to 2023.