Activity ratios measure how efficiently a company performs day-to-day tasks, such us the collection of receivables and management of inventory.
Short-term Activity Ratios (Summary)
Based on: 10-Q (reporting date: 2023-06-30), 10-Q (reporting date: 2023-03-31), 10-Q (reporting date: 2022-12-31), 10-K (reporting date: 2022-09-30), 10-Q (reporting date: 2022-06-30), 10-Q (reporting date: 2022-03-31), 10-Q (reporting date: 2021-12-31), 10-K (reporting date: 2021-09-30), 10-Q (reporting date: 2021-06-30), 10-Q (reporting date: 2021-03-31), 10-Q (reporting date: 2020-12-31), 10-K (reporting date: 2020-09-30), 10-Q (reporting date: 2020-06-30), 10-Q (reporting date: 2020-03-31), 10-Q (reporting date: 2019-12-31), 10-K (reporting date: 2019-09-30), 10-Q (reporting date: 2019-06-30), 10-Q (reporting date: 2019-03-31), 10-Q (reporting date: 2018-12-31), 10-K (reporting date: 2018-09-30), 10-Q (reporting date: 2018-06-30), 10-Q (reporting date: 2018-03-31), 10-Q (reporting date: 2017-12-31), 10-K (reporting date: 2017-09-30), 10-Q (reporting date: 2017-06-30), 10-Q (reporting date: 2017-03-31), 10-Q (reporting date: 2016-12-31).
Short-term activity ratio | Description | The company |
---|---|---|
Inventory turnover | An activity ratio calculated as cost of goods sold divided by inventory. | AmerisourceBergen Corp. inventory turnover ratio improved from Q1 2023 to Q2 2023 and from Q2 2023 to Q3 2023. |
Receivables turnover | An activity ratio equal to revenue divided by receivables. | AmerisourceBergen Corp. receivables turnover ratio deteriorated from Q1 2023 to Q2 2023 and from Q2 2023 to Q3 2023. |
Payables turnover | An activity ratio calculated as cost of goods sold divided by payables. | AmerisourceBergen Corp. payables turnover ratio increased from Q1 2023 to Q2 2023 and from Q2 2023 to Q3 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. | |
Average receivable collection period | An activity ratio equal to the number of days in the period divided by receivables turnover. | AmerisourceBergen Corp. number of days of receivables outstanding deteriorated from Q1 2023 to Q2 2023 and from Q2 2023 to Q3 2023. |
Operating cycle | Equal to average inventory processing period plus average receivables collection 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. | |
Cash conversion cycle | A financial metric that measures the length of time required for a company to convert cash invested in its operations to cash received as a result of its operations; equal to average inventory processing period plus average receivables collection period minus average payables payment period. |
Inventory Turnover
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 | Dec 31, 2018 | Sep 30, 2018 | Jun 30, 2018 | Mar 31, 2018 | Dec 31, 2017 | Sep 30, 2017 | Jun 30, 2017 | Mar 31, 2017 | Dec 31, 2016 | |||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
Selected Financial Data (US$ in thousands) | |||||||||||||||||||||||||||||||||||
Cost of goods sold | 64,682,397) | 61,161,763) | 60,700,879) | 59,188,590) | 58,049,232) | 55,484,366) | 57,568,451) | 56,843,010) | 51,517,489) | 47,620,790) | 51,064,326) | 47,897,921) | 44,141,061) | 46,029,532) | 46,633,528) | 44,453,065) | 44,008,026) | 41,894,846) | 44,094,872) | 42,264,495) | 41,930,968) | 39,778,175) | 39,353,680) | 37,947,995) | 37,627,269) | 35,890,975) | 37,131,585) | ||||||||
Inventories | 16,852,340) | 16,955,245) | 16,779,873) | 15,556,394) | 15,823,360) | 15,514,851) | 16,293,933) | 15,368,352) | 14,996,364) | 12,954,676) | 13,178,958) | 12,589,278) | 11,849,201) | 11,102,566) | 11,686,466) | 11,060,254) | 11,247,776) | 11,373,730) | 11,800,185) | 11,918,508) | 12,074,347) | 12,867,481) | 12,020,660) | 11,461,428) | 11,669,529) | 11,335,816) | 11,414,771) | ||||||||
Short-term Activity Ratio | |||||||||||||||||||||||||||||||||||
Inventory turnover1 | 14.58 | 14.10 | 13.91 | 14.80 | 14.41 | 14.27 | 13.11 | 13.47 | 13.21 | 14.72 | 14.35 | 14.67 | 15.30 | 16.31 | 15.14 | 15.77 | 15.32 | 14.96 | 14.24 | 13.70 | 13.17 | 12.02 | 12.55 | 12.97 | — | — | — | ||||||||
Benchmarks | |||||||||||||||||||||||||||||||||||
Inventory Turnover, Competitors2 | |||||||||||||||||||||||||||||||||||
Abbott Laboratories | 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 | — | — | — | — | — | — | — | — | — | — | — | ||||||||
Cigna Group | 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 | — | — | — | — | — | — | — | — | — | — | — | ||||||||
CVS Health Corp. | 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.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.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: 2023-06-30), 10-Q (reporting date: 2023-03-31), 10-Q (reporting date: 2022-12-31), 10-K (reporting date: 2022-09-30), 10-Q (reporting date: 2022-06-30), 10-Q (reporting date: 2022-03-31), 10-Q (reporting date: 2021-12-31), 10-K (reporting date: 2021-09-30), 10-Q (reporting date: 2021-06-30), 10-Q (reporting date: 2021-03-31), 10-Q (reporting date: 2020-12-31), 10-K (reporting date: 2020-09-30), 10-Q (reporting date: 2020-06-30), 10-Q (reporting date: 2020-03-31), 10-Q (reporting date: 2019-12-31), 10-K (reporting date: 2019-09-30), 10-Q (reporting date: 2019-06-30), 10-Q (reporting date: 2019-03-31), 10-Q (reporting date: 2018-12-31), 10-K (reporting date: 2018-09-30), 10-Q (reporting date: 2018-06-30), 10-Q (reporting date: 2018-03-31), 10-Q (reporting date: 2017-12-31), 10-K (reporting date: 2017-09-30), 10-Q (reporting date: 2017-06-30), 10-Q (reporting date: 2017-03-31), 10-Q (reporting date: 2016-12-31).
1 Q3 2023 Calculation
Inventory turnover
= (Cost of goods soldQ3 2023
+ Cost of goods soldQ2 2023
+ Cost of goods soldQ1 2023
+ Cost of goods soldQ4 2022)
÷ Inventories
= (64,682,397 + 61,161,763 + 60,700,879 + 59,188,590)
÷ 16,852,340 = 14.58
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. | AmerisourceBergen Corp. inventory turnover ratio improved from Q1 2023 to Q2 2023 and from Q2 2023 to Q3 2023. |
Receivables Turnover
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 | Dec 31, 2018 | Sep 30, 2018 | Jun 30, 2018 | Mar 31, 2018 | Dec 31, 2017 | Sep 30, 2017 | Jun 30, 2017 | Mar 31, 2017 | Dec 31, 2016 | |||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
Selected Financial Data (US$ in thousands) | |||||||||||||||||||||||||||||||||||
Revenue | 66,947,043) | 63,457,205) | 62,846,832) | 61,174,149) | 60,064,601) | 57,719,446) | 59,628,810) | 58,912,421) | 53,405,695) | 49,154,171) | 52,516,556) | 49,244,768) | 45,366,777) | 47,417,639) | 47,864,742) | 45,637,802) | 45,239,265) | 43,319,602) | 45,392,452) | 43,297,136) | 43,142,309) | 41,033,858) | 40,466,332) | 39,120,015) | 38,707,144) | 37,147,402) | 38,169,265) | ||||||||
Accounts receivable, less allowances for returns and credit losses | 20,796,648) | 19,491,097) | 18,627,397) | 18,452,675) | 18,624,104) | 18,111,080) | 17,146,056) | 18,167,175) | 17,695,170) | 14,134,326) | 14,886,252) | 13,846,301) | 12,548,399) | 14,210,170) | 12,568,816) | 12,386,879) | 11,989,030) | 12,222,271) | 11,979,382) | 11,314,226) | 11,764,614) | 11,265,014) | 10,127,783) | 10,303,324) | 10,553,258) | 9,583,520) | 9,696,200) | ||||||||
Short-term Activity Ratio | |||||||||||||||||||||||||||||||||||
Receivables turnover1 | 12.23 | 12.70 | 12.98 | 12.93 | 12.69 | 12.68 | 12.90 | 11.78 | 11.55 | 13.89 | 13.07 | 13.71 | 14.85 | 13.10 | 14.49 | 14.50 | 14.78 | 14.33 | 14.43 | 14.84 | 13.92 | 14.14 | 15.35 | 14.86 | — | — | — | ||||||||
Benchmarks | |||||||||||||||||||||||||||||||||||
Receivables Turnover, Competitors2 | |||||||||||||||||||||||||||||||||||
Abbott Laboratories | 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.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. | 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. | 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. | 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.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 | — | — | — | — | — | — | — | — | — | — | — | ||||||||
UnitedHealth Group Inc. | 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 | — | — | — | — | — | — | — | — | — | — | — |
Based on: 10-Q (reporting date: 2023-06-30), 10-Q (reporting date: 2023-03-31), 10-Q (reporting date: 2022-12-31), 10-K (reporting date: 2022-09-30), 10-Q (reporting date: 2022-06-30), 10-Q (reporting date: 2022-03-31), 10-Q (reporting date: 2021-12-31), 10-K (reporting date: 2021-09-30), 10-Q (reporting date: 2021-06-30), 10-Q (reporting date: 2021-03-31), 10-Q (reporting date: 2020-12-31), 10-K (reporting date: 2020-09-30), 10-Q (reporting date: 2020-06-30), 10-Q (reporting date: 2020-03-31), 10-Q (reporting date: 2019-12-31), 10-K (reporting date: 2019-09-30), 10-Q (reporting date: 2019-06-30), 10-Q (reporting date: 2019-03-31), 10-Q (reporting date: 2018-12-31), 10-K (reporting date: 2018-09-30), 10-Q (reporting date: 2018-06-30), 10-Q (reporting date: 2018-03-31), 10-Q (reporting date: 2017-12-31), 10-K (reporting date: 2017-09-30), 10-Q (reporting date: 2017-06-30), 10-Q (reporting date: 2017-03-31), 10-Q (reporting date: 2016-12-31).
1 Q3 2023 Calculation
Receivables turnover
= (RevenueQ3 2023
+ RevenueQ2 2023
+ RevenueQ1 2023
+ RevenueQ4 2022)
÷ Accounts receivable, less allowances for returns and credit losses
= (66,947,043 + 63,457,205 + 62,846,832 + 61,174,149)
÷ 20,796,648 = 12.23
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. | AmerisourceBergen Corp. receivables turnover ratio deteriorated from Q1 2023 to Q2 2023 and from Q2 2023 to Q3 2023. |
Payables Turnover
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 | Dec 31, 2018 | Sep 30, 2018 | Jun 30, 2018 | Mar 31, 2018 | Dec 31, 2017 | Sep 30, 2017 | Jun 30, 2017 | Mar 31, 2017 | Dec 31, 2016 | |||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
Selected Financial Data (US$ in thousands) | |||||||||||||||||||||||||||||||||||
Cost of goods sold | 64,682,397) | 61,161,763) | 60,700,879) | 59,188,590) | 58,049,232) | 55,484,366) | 57,568,451) | 56,843,010) | 51,517,489) | 47,620,790) | 51,064,326) | 47,897,921) | 44,141,061) | 46,029,532) | 46,633,528) | 44,453,065) | 44,008,026) | 41,894,846) | 44,094,872) | 42,264,495) | 41,930,968) | 39,778,175) | 39,353,680) | 37,947,995) | 37,627,269) | 35,890,975) | 37,131,585) | ||||||||
Accounts payable | 43,752,080) | 42,734,822) | 41,757,949) | 40,192,890) | 39,305,668) | 38,210,623) | 38,617,734) | 38,009,954) | 36,502,816) | 31,420,390) | 33,449,690) | 31,705,055) | 29,145,149) | 30,719,987) | 29,181,860) | 28,385,074) | 27,807,403) | 28,189,390) | 28,336,293) | 26,836,873) | 26,449,542) | 26,403,594) | 25,346,694) | 25,404,042) | 24,804,544) | 24,276,019) | 24,172,341) | ||||||||
Short-term Activity Ratio | |||||||||||||||||||||||||||||||||||
Payables turnover1 | 5.62 | 5.59 | 5.59 | 5.73 | 5.80 | 5.79 | 5.53 | 5.45 | 5.43 | 6.07 | 5.65 | 5.83 | 6.22 | 5.90 | 6.07 | 6.15 | 6.19 | 6.04 | 5.93 | 6.09 | 6.01 | 5.86 | 5.95 | 5.85 | — | — | — | ||||||||
Benchmarks | |||||||||||||||||||||||||||||||||||
Payables Turnover, Competitors2 | |||||||||||||||||||||||||||||||||||
Abbott Laboratories | 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.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. | 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.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.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.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.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.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: 2023-06-30), 10-Q (reporting date: 2023-03-31), 10-Q (reporting date: 2022-12-31), 10-K (reporting date: 2022-09-30), 10-Q (reporting date: 2022-06-30), 10-Q (reporting date: 2022-03-31), 10-Q (reporting date: 2021-12-31), 10-K (reporting date: 2021-09-30), 10-Q (reporting date: 2021-06-30), 10-Q (reporting date: 2021-03-31), 10-Q (reporting date: 2020-12-31), 10-K (reporting date: 2020-09-30), 10-Q (reporting date: 2020-06-30), 10-Q (reporting date: 2020-03-31), 10-Q (reporting date: 2019-12-31), 10-K (reporting date: 2019-09-30), 10-Q (reporting date: 2019-06-30), 10-Q (reporting date: 2019-03-31), 10-Q (reporting date: 2018-12-31), 10-K (reporting date: 2018-09-30), 10-Q (reporting date: 2018-06-30), 10-Q (reporting date: 2018-03-31), 10-Q (reporting date: 2017-12-31), 10-K (reporting date: 2017-09-30), 10-Q (reporting date: 2017-06-30), 10-Q (reporting date: 2017-03-31), 10-Q (reporting date: 2016-12-31).
1 Q3 2023 Calculation
Payables turnover
= (Cost of goods soldQ3 2023
+ Cost of goods soldQ2 2023
+ Cost of goods soldQ1 2023
+ Cost of goods soldQ4 2022)
÷ Accounts payable
= (64,682,397 + 61,161,763 + 60,700,879 + 59,188,590)
÷ 43,752,080 = 5.62
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. | AmerisourceBergen Corp. payables turnover ratio increased from Q1 2023 to Q2 2023 and from Q2 2023 to Q3 2023. |
Working Capital Turnover
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 | Dec 31, 2018 | Sep 30, 2018 | Jun 30, 2018 | Mar 31, 2018 | Dec 31, 2017 | Sep 30, 2017 | Jun 30, 2017 | Mar 31, 2017 | Dec 31, 2016 | |||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
Selected Financial Data (US$ in thousands) | |||||||||||||||||||||||||||||||||||
Current assets | 40,986,584) | 39,989,641) | 40,708,125) | 39,589,758) | 39,744,526) | 39,409,740) | 39,378,885) | 38,802,609) | 37,259,766) | 35,469,149) | 34,700,221) | 33,055,702) | 29,918,572) | 31,180,650) | 28,954,816) | 28,132,054) | 27,401,778) | 27,622,183) | 27,476,207) | 25,894,372) | 26,404,401) | 26,397,211) | 25,296,432) | 24,303,299) | 23,677,224) | 23,493,921) | 23,078,756) | ||||||||
Less: Current liabilities | 46,783,211) | 45,071,097) | 44,760,623) | 43,477,955) | 43,154,310) | 42,797,581) | 41,613,605) | 41,358,641) | 39,589,838) | 32,996,446) | 35,044,451) | 33,853,077) | 30,631,571) | 32,111,790) | 30,630,456) | 29,581,294) | 28,788,871) | 29,211,899) | 29,351,737) | 27,869,687) | 28,099,671) | 28,094,404) | 26,740,291) | 26,818,165) | 25,751,076) | 25,531,426) | 25,542,758) | ||||||||
Working capital | (5,796,627) | (5,081,456) | (4,052,498) | (3,888,197) | (3,409,784) | (3,387,841) | (2,234,720) | (2,556,032) | (2,330,072) | 2,472,703) | (344,230) | (797,375) | (712,999) | (931,140) | (1,675,640) | (1,449,240) | (1,387,093) | (1,589,716) | (1,875,530) | (1,975,315) | (1,695,270) | (1,697,193) | (1,443,859) | (2,514,866) | (2,073,852) | (2,037,505) | (2,464,002) | ||||||||
Revenue | 66,947,043) | 63,457,205) | 62,846,832) | 61,174,149) | 60,064,601) | 57,719,446) | 59,628,810) | 58,912,421) | 53,405,695) | 49,154,171) | 52,516,556) | 49,244,768) | 45,366,777) | 47,417,639) | 47,864,742) | 45,637,802) | 45,239,265) | 43,319,602) | 45,392,452) | 43,297,136) | 43,142,309) | 41,033,858) | 40,466,332) | 39,120,015) | 38,707,144) | 37,147,402) | 38,169,265) | ||||||||
Short-term Activity Ratio | |||||||||||||||||||||||||||||||||||
Working capital turnover1 | — | — | — | — | — | — | — | — | — | 79.38 | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | ||||||||
Benchmarks | |||||||||||||||||||||||||||||||||||
Working Capital Turnover, Competitors2 | |||||||||||||||||||||||||||||||||||
Abbott Laboratories | 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.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.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. | 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.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: 2023-06-30), 10-Q (reporting date: 2023-03-31), 10-Q (reporting date: 2022-12-31), 10-K (reporting date: 2022-09-30), 10-Q (reporting date: 2022-06-30), 10-Q (reporting date: 2022-03-31), 10-Q (reporting date: 2021-12-31), 10-K (reporting date: 2021-09-30), 10-Q (reporting date: 2021-06-30), 10-Q (reporting date: 2021-03-31), 10-Q (reporting date: 2020-12-31), 10-K (reporting date: 2020-09-30), 10-Q (reporting date: 2020-06-30), 10-Q (reporting date: 2020-03-31), 10-Q (reporting date: 2019-12-31), 10-K (reporting date: 2019-09-30), 10-Q (reporting date: 2019-06-30), 10-Q (reporting date: 2019-03-31), 10-Q (reporting date: 2018-12-31), 10-K (reporting date: 2018-09-30), 10-Q (reporting date: 2018-06-30), 10-Q (reporting date: 2018-03-31), 10-Q (reporting date: 2017-12-31), 10-K (reporting date: 2017-09-30), 10-Q (reporting date: 2017-06-30), 10-Q (reporting date: 2017-03-31), 10-Q (reporting date: 2016-12-31).
1 Q3 2023 Calculation
Working capital turnover
= (RevenueQ3 2023
+ RevenueQ2 2023
+ RevenueQ1 2023
+ RevenueQ4 2022)
÷ Working capital
= (66,947,043 + 63,457,205 + 62,846,832 + 61,174,149)
÷ -5,796,627 = —
2 Click competitor name to see calculations.
Average Inventory Processing Period
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 | Dec 31, 2018 | Sep 30, 2018 | Jun 30, 2018 | Mar 31, 2018 | Dec 31, 2017 | Sep 30, 2017 | Jun 30, 2017 | Mar 31, 2017 | Dec 31, 2016 | |||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
Selected Financial Data | |||||||||||||||||||||||||||||||||||
Inventory turnover | 14.58 | 14.10 | 13.91 | 14.80 | 14.41 | 14.27 | 13.11 | 13.47 | 13.21 | 14.72 | 14.35 | 14.67 | 15.30 | 16.31 | 15.14 | 15.77 | 15.32 | 14.96 | 14.24 | 13.70 | 13.17 | 12.02 | 12.55 | 12.97 | — | — | — | ||||||||
Short-term Activity Ratio (no. days) | |||||||||||||||||||||||||||||||||||
Average inventory processing period1 | 25 | 26 | 26 | 25 | 25 | 26 | 28 | 27 | 28 | 25 | 25 | 25 | 24 | 22 | 24 | 23 | 24 | 24 | 26 | 27 | 28 | 30 | 29 | 28 | — | — | — | ||||||||
Benchmarks (no. days) | |||||||||||||||||||||||||||||||||||
Average Inventory Processing Period, Competitors2 | |||||||||||||||||||||||||||||||||||
Abbott Laboratories | 135 | 139 | 132 | 118 | 108 | 113 | 109 | 102 | 105 | 111 | 122 | 122 | 135 | 142 | 125 | 119 | — | — | — | — | — | — | — | — | — | — | — | ||||||||
Cigna Group | 12 | 13 | 12 | 14 | 12 | 11 | 11 | 12 | 10 | 10 | 10 | 11 | 10 | 10 | 10 | 10 | — | — | — | — | — | — | — | — | — | — | — | ||||||||
CVS Health Corp. | 22 | 22 | 24 | 26 | 25 | 25 | 27 | 27 | 27 | 27 | 29 | 31 | 29 | 28 | 29 | 30 | — | — | — | — | — | — | — | — | — | — | — | ||||||||
Intuitive Surgical Inc. | 183 | 166 | 162 | 161 | 155 | 139 | 130 | 122 | 126 | 129 | 138 | 147 | 167 | 164 | 159 | 159 | — | — | — | — | — | — | — | — | — | — | — | ||||||||
Medtronic PLC | 190 | 183 | 174 | 166 | 161 | 153 | 148 | 150 | 163 | 166 | 174 | 164 | 156 | 155 | 154 | 150 | — | — | — | — | — | — | — | — | — | — | — |
Based on: 10-Q (reporting date: 2023-06-30), 10-Q (reporting date: 2023-03-31), 10-Q (reporting date: 2022-12-31), 10-K (reporting date: 2022-09-30), 10-Q (reporting date: 2022-06-30), 10-Q (reporting date: 2022-03-31), 10-Q (reporting date: 2021-12-31), 10-K (reporting date: 2021-09-30), 10-Q (reporting date: 2021-06-30), 10-Q (reporting date: 2021-03-31), 10-Q (reporting date: 2020-12-31), 10-K (reporting date: 2020-09-30), 10-Q (reporting date: 2020-06-30), 10-Q (reporting date: 2020-03-31), 10-Q (reporting date: 2019-12-31), 10-K (reporting date: 2019-09-30), 10-Q (reporting date: 2019-06-30), 10-Q (reporting date: 2019-03-31), 10-Q (reporting date: 2018-12-31), 10-K (reporting date: 2018-09-30), 10-Q (reporting date: 2018-06-30), 10-Q (reporting date: 2018-03-31), 10-Q (reporting date: 2017-12-31), 10-K (reporting date: 2017-09-30), 10-Q (reporting date: 2017-06-30), 10-Q (reporting date: 2017-03-31), 10-Q (reporting date: 2016-12-31).
1 Q3 2023 Calculation
Average inventory processing period = 365 ÷ Inventory turnover
= 365 ÷ 14.58 = 25
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 Receivable Collection Period
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 | Dec 31, 2018 | Sep 30, 2018 | Jun 30, 2018 | Mar 31, 2018 | Dec 31, 2017 | Sep 30, 2017 | Jun 30, 2017 | Mar 31, 2017 | Dec 31, 2016 | |||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
Selected Financial Data | |||||||||||||||||||||||||||||||||||
Receivables turnover | 12.23 | 12.70 | 12.98 | 12.93 | 12.69 | 12.68 | 12.90 | 11.78 | 11.55 | 13.89 | 13.07 | 13.71 | 14.85 | 13.10 | 14.49 | 14.50 | 14.78 | 14.33 | 14.43 | 14.84 | 13.92 | 14.14 | 15.35 | 14.86 | — | — | — | ||||||||
Short-term Activity Ratio (no. days) | |||||||||||||||||||||||||||||||||||
Average receivable collection period1 | 30 | 29 | 28 | 28 | 29 | 29 | 28 | 31 | 32 | 26 | 28 | 27 | 25 | 28 | 25 | 25 | 25 | 25 | 25 | 25 | 26 | 26 | 24 | 25 | — | — | — | ||||||||
Benchmarks (no. days) | |||||||||||||||||||||||||||||||||||
Average Receivable Collection Period, Competitors2 | |||||||||||||||||||||||||||||||||||
Abbott Laboratories | 59 | 56 | 53 | 52 | 52 | 58 | 59 | 55 | 55 | 55 | 60 | 68 | 64 | 60 | 60 | 62 | — | — | — | — | — | — | — | — | — | — | — | ||||||||
CVS Health Corp. | 35 | 32 | 31 | 31 | 31 | 32 | 32 | 31 | 32 | 32 | 32 | 30 | 33 | 31 | 32 | 28 | — | — | — | — | — | — | — | — | — | — | — | ||||||||
Elevance Health Inc. | 20 | 19 | 22 | 19 | 19 | 19 | 22 | 18 | 19 | 19 | 21 | 19 | 19 | 20 | 22 | 20 | — | — | — | — | — | — | — | — | — | — | — | ||||||||
Humana Inc. | 7 | 5 | 12 | 7 | 6 | 14 | 13 | 8 | 9 | 11 | 10 | 5 | 6 | 12 | 11 | 6 | — | — | — | — | — | — | — | — | — | — | — | ||||||||
Intuitive Surgical Inc. | 51 | 50 | 53 | 55 | 51 | 51 | 56 | 50 | 46 | 49 | 52 | 54 | 50 | 43 | 42 | 53 | — | — | — | — | — | — | — | — | — | — | — | ||||||||
Medtronic PLC | 70 | 67 | 62 | 64 | 63 | 63 | 63 | 66 | 68 | 70 | 64 | 59 | 73 | 72 | 70 | 74 | — | — | — | — | — | — | — | — | — | — | — | ||||||||
UnitedHealth Group Inc. | 21 | 19 | 25 | 20 | 20 | 22 | 23 | 18 | 19 | 20 | 22 | 18 | 18 | 19 | 22 | 18 | — | — | — | — | — | — | — | — | — | — | — |
Based on: 10-Q (reporting date: 2023-06-30), 10-Q (reporting date: 2023-03-31), 10-Q (reporting date: 2022-12-31), 10-K (reporting date: 2022-09-30), 10-Q (reporting date: 2022-06-30), 10-Q (reporting date: 2022-03-31), 10-Q (reporting date: 2021-12-31), 10-K (reporting date: 2021-09-30), 10-Q (reporting date: 2021-06-30), 10-Q (reporting date: 2021-03-31), 10-Q (reporting date: 2020-12-31), 10-K (reporting date: 2020-09-30), 10-Q (reporting date: 2020-06-30), 10-Q (reporting date: 2020-03-31), 10-Q (reporting date: 2019-12-31), 10-K (reporting date: 2019-09-30), 10-Q (reporting date: 2019-06-30), 10-Q (reporting date: 2019-03-31), 10-Q (reporting date: 2018-12-31), 10-K (reporting date: 2018-09-30), 10-Q (reporting date: 2018-06-30), 10-Q (reporting date: 2018-03-31), 10-Q (reporting date: 2017-12-31), 10-K (reporting date: 2017-09-30), 10-Q (reporting date: 2017-06-30), 10-Q (reporting date: 2017-03-31), 10-Q (reporting date: 2016-12-31).
1 Q3 2023 Calculation
Average receivable collection period = 365 ÷ Receivables turnover
= 365 ÷ 12.23 = 30
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. | AmerisourceBergen Corp. number of days of receivables outstanding deteriorated from Q1 2023 to Q2 2023 and from Q2 2023 to Q3 2023. |
Operating Cycle
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 | Dec 31, 2018 | Sep 30, 2018 | Jun 30, 2018 | Mar 31, 2018 | Dec 31, 2017 | Sep 30, 2017 | Jun 30, 2017 | Mar 31, 2017 | Dec 31, 2016 | |||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
Selected Financial Data | |||||||||||||||||||||||||||||||||||
Average inventory processing period | 25 | 26 | 26 | 25 | 25 | 26 | 28 | 27 | 28 | 25 | 25 | 25 | 24 | 22 | 24 | 23 | 24 | 24 | 26 | 27 | 28 | 30 | 29 | 28 | — | — | — | ||||||||
Average receivable collection period | 30 | 29 | 28 | 28 | 29 | 29 | 28 | 31 | 32 | 26 | 28 | 27 | 25 | 28 | 25 | 25 | 25 | 25 | 25 | 25 | 26 | 26 | 24 | 25 | — | — | — | ||||||||
Short-term Activity Ratio | |||||||||||||||||||||||||||||||||||
Operating cycle1 | 55 | 55 | 54 | 53 | 54 | 55 | 56 | 58 | 60 | 51 | 53 | 52 | 49 | 50 | 49 | 48 | 49 | 49 | 51 | 52 | 54 | 56 | 53 | 53 | — | — | — | ||||||||
Benchmarks | |||||||||||||||||||||||||||||||||||
Operating Cycle, Competitors2 | |||||||||||||||||||||||||||||||||||
Abbott Laboratories | 194 | 195 | 185 | 170 | 160 | 171 | 168 | 157 | 160 | 166 | 182 | 190 | 199 | 202 | 185 | 181 | — | — | — | — | — | — | — | — | — | — | — | ||||||||
CVS Health Corp. | 57 | 54 | 55 | 57 | 56 | 57 | 59 | 58 | 59 | 59 | 61 | 61 | 62 | 59 | 61 | 58 | — | — | — | — | — | — | — | — | — | — | — | ||||||||
Intuitive Surgical Inc. | 234 | 216 | 215 | 216 | 206 | 190 | 186 | 172 | 172 | 178 | 190 | 201 | 217 | 207 | 201 | 212 | — | — | — | — | — | — | — | — | — | — | — | ||||||||
Medtronic PLC | 260 | 250 | 236 | 230 | 224 | 216 | 211 | 216 | 231 | 236 | 238 | 223 | 229 | 227 | 224 | 224 | — | — | — | — | — | — | — | — | — | — | — |
Based on: 10-Q (reporting date: 2023-06-30), 10-Q (reporting date: 2023-03-31), 10-Q (reporting date: 2022-12-31), 10-K (reporting date: 2022-09-30), 10-Q (reporting date: 2022-06-30), 10-Q (reporting date: 2022-03-31), 10-Q (reporting date: 2021-12-31), 10-K (reporting date: 2021-09-30), 10-Q (reporting date: 2021-06-30), 10-Q (reporting date: 2021-03-31), 10-Q (reporting date: 2020-12-31), 10-K (reporting date: 2020-09-30), 10-Q (reporting date: 2020-06-30), 10-Q (reporting date: 2020-03-31), 10-Q (reporting date: 2019-12-31), 10-K (reporting date: 2019-09-30), 10-Q (reporting date: 2019-06-30), 10-Q (reporting date: 2019-03-31), 10-Q (reporting date: 2018-12-31), 10-K (reporting date: 2018-09-30), 10-Q (reporting date: 2018-06-30), 10-Q (reporting date: 2018-03-31), 10-Q (reporting date: 2017-12-31), 10-K (reporting date: 2017-09-30), 10-Q (reporting date: 2017-06-30), 10-Q (reporting date: 2017-03-31), 10-Q (reporting date: 2016-12-31).
1 Q3 2023 Calculation
Operating cycle = Average inventory processing period + Average receivable collection period
= 25 + 30 = 55
2 Click competitor name to see calculations.
Short-term activity ratio | Description | The company |
---|---|---|
Operating cycle | Equal to average inventory processing period plus average receivables collection period. |
Average Payables Payment Period
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 | Dec 31, 2018 | Sep 30, 2018 | Jun 30, 2018 | Mar 31, 2018 | Dec 31, 2017 | Sep 30, 2017 | Jun 30, 2017 | Mar 31, 2017 | Dec 31, 2016 | |||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
Selected Financial Data | |||||||||||||||||||||||||||||||||||
Payables turnover | 5.62 | 5.59 | 5.59 | 5.73 | 5.80 | 5.79 | 5.53 | 5.45 | 5.43 | 6.07 | 5.65 | 5.83 | 6.22 | 5.90 | 6.07 | 6.15 | 6.19 | 6.04 | 5.93 | 6.09 | 6.01 | 5.86 | 5.95 | 5.85 | — | — | — | ||||||||
Short-term Activity Ratio (no. days) | |||||||||||||||||||||||||||||||||||
Average payables payment period1 | 65 | 65 | 65 | 64 | 63 | 63 | 66 | 67 | 67 | 60 | 65 | 63 | 59 | 62 | 60 | 59 | 59 | 60 | 62 | 60 | 61 | 62 | 61 | 62 | — | — | — | ||||||||
Benchmarks (no. days) | |||||||||||||||||||||||||||||||||||
Average Payables Payment Period, Competitors2 | |||||||||||||||||||||||||||||||||||
Abbott Laboratories | 80 | 85 | 82 | 88 | 78 | 86 | 91 | 87 | 80 | 82 | 92 | 96 | 83 | 91 | 87 | 90 | — | — | — | — | — | — | — | — | — | — | — | ||||||||
Cigna Group | 54 | 53 | 51 | 50 | 49 | 49 | 46 | 48 | 47 | 48 | 47 | 47 | 46 | 44 | 40 | 39 | — | — | — | — | — | — | — | — | — | — | — | ||||||||
CVS Health Corp. | 19 | 17 | 17 | 20 | 19 | 19 | 19 | 19 | 20 | 18 | 18 | 19 | 20 | 17 | 17 | 18 | — | — | — | — | — | — | — | — | — | — | — | ||||||||
Elevance Health Inc. | 48 | 48 | 48 | 49 | 49 | 50 | 50 | 48 | 50 | 50 | 50 | 47 | 44 | 43 | 43 | 39 | — | — | — | — | — | — | — | — | — | — | — | ||||||||
Humana Inc. | 44 | 47 | 47 | 45 | 45 | 48 | 48 | 44 | 47 | 47 | 50 | 48 | 51 | 51 | 46 | 41 | — | — | — | — | — | — | — | — | — | — | — | ||||||||
Intuitive Surgical Inc. | 31 | 33 | 28 | 26 | 30 | 29 | 25 | 25 | 26 | 27 | 25 | 20 | 29 | 28 | 34 | 33 | — | — | — | — | — | — | — | — | — | — | — | ||||||||
Medtronic PLC | 78 | 79 | 79 | 82 | 71 | 67 | 64 | 73 | 66 | 70 | 66 | 77 | 74 | 75 | 75 | 78 | — | — | — | — | — | — | — | — | — | — | — | ||||||||
UnitedHealth Group Inc. | 51 | 52 | 53 | 50 | 52 | 53 | 54 | 48 | 52 | 52 | 56 | 50 | 49 | 46 | 52 | 51 | — | — | — | — | — | — | — | — | — | — | — |
Based on: 10-Q (reporting date: 2023-06-30), 10-Q (reporting date: 2023-03-31), 10-Q (reporting date: 2022-12-31), 10-K (reporting date: 2022-09-30), 10-Q (reporting date: 2022-06-30), 10-Q (reporting date: 2022-03-31), 10-Q (reporting date: 2021-12-31), 10-K (reporting date: 2021-09-30), 10-Q (reporting date: 2021-06-30), 10-Q (reporting date: 2021-03-31), 10-Q (reporting date: 2020-12-31), 10-K (reporting date: 2020-09-30), 10-Q (reporting date: 2020-06-30), 10-Q (reporting date: 2020-03-31), 10-Q (reporting date: 2019-12-31), 10-K (reporting date: 2019-09-30), 10-Q (reporting date: 2019-06-30), 10-Q (reporting date: 2019-03-31), 10-Q (reporting date: 2018-12-31), 10-K (reporting date: 2018-09-30), 10-Q (reporting date: 2018-06-30), 10-Q (reporting date: 2018-03-31), 10-Q (reporting date: 2017-12-31), 10-K (reporting date: 2017-09-30), 10-Q (reporting date: 2017-06-30), 10-Q (reporting date: 2017-03-31), 10-Q (reporting date: 2016-12-31).
1 Q3 2023 Calculation
Average payables payment period = 365 ÷ Payables turnover
= 365 ÷ 5.62 = 65
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. |
Cash Conversion Cycle
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 | Dec 31, 2018 | Sep 30, 2018 | Jun 30, 2018 | Mar 31, 2018 | Dec 31, 2017 | Sep 30, 2017 | Jun 30, 2017 | Mar 31, 2017 | Dec 31, 2016 | |||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
Selected Financial Data | |||||||||||||||||||||||||||||||||||
Average inventory processing period | 25 | 26 | 26 | 25 | 25 | 26 | 28 | 27 | 28 | 25 | 25 | 25 | 24 | 22 | 24 | 23 | 24 | 24 | 26 | 27 | 28 | 30 | 29 | 28 | — | — | — | ||||||||
Average receivable collection period | 30 | 29 | 28 | 28 | 29 | 29 | 28 | 31 | 32 | 26 | 28 | 27 | 25 | 28 | 25 | 25 | 25 | 25 | 25 | 25 | 26 | 26 | 24 | 25 | — | — | — | ||||||||
Average payables payment period | 65 | 65 | 65 | 64 | 63 | 63 | 66 | 67 | 67 | 60 | 65 | 63 | 59 | 62 | 60 | 59 | 59 | 60 | 62 | 60 | 61 | 62 | 61 | 62 | — | — | — | ||||||||
Short-term Activity Ratio | |||||||||||||||||||||||||||||||||||
Cash conversion cycle1 | -10 | -10 | -11 | -11 | -9 | -8 | -10 | -9 | -7 | -9 | -12 | -11 | -10 | -12 | -11 | -11 | -10 | -11 | -11 | -8 | -7 | -6 | -8 | -9 | — | — | — | ||||||||
Benchmarks | |||||||||||||||||||||||||||||||||||
Cash Conversion Cycle, Competitors2 | |||||||||||||||||||||||||||||||||||
Abbott Laboratories | 114 | 110 | 103 | 82 | 82 | 85 | 77 | 70 | 80 | 84 | 90 | 94 | 116 | 111 | 98 | 91 | — | — | — | — | — | — | — | — | — | — | — | ||||||||
CVS Health Corp. | 38 | 37 | 38 | 37 | 37 | 38 | 40 | 39 | 39 | 41 | 43 | 42 | 42 | 42 | 44 | 40 | — | — | — | — | — | — | — | — | — | — | — | ||||||||
Intuitive Surgical Inc. | 203 | 183 | 187 | 190 | 176 | 161 | 161 | 147 | 146 | 151 | 165 | 181 | 188 | 179 | 167 | 179 | — | — | — | — | — | — | — | — | — | — | — | ||||||||
Medtronic PLC | 182 | 171 | 157 | 148 | 153 | 149 | 147 | 143 | 165 | 166 | 172 | 146 | 155 | 152 | 149 | 146 | — | — | — | — | — | — | — | — | — | — | — |
Based on: 10-Q (reporting date: 2023-06-30), 10-Q (reporting date: 2023-03-31), 10-Q (reporting date: 2022-12-31), 10-K (reporting date: 2022-09-30), 10-Q (reporting date: 2022-06-30), 10-Q (reporting date: 2022-03-31), 10-Q (reporting date: 2021-12-31), 10-K (reporting date: 2021-09-30), 10-Q (reporting date: 2021-06-30), 10-Q (reporting date: 2021-03-31), 10-Q (reporting date: 2020-12-31), 10-K (reporting date: 2020-09-30), 10-Q (reporting date: 2020-06-30), 10-Q (reporting date: 2020-03-31), 10-Q (reporting date: 2019-12-31), 10-K (reporting date: 2019-09-30), 10-Q (reporting date: 2019-06-30), 10-Q (reporting date: 2019-03-31), 10-Q (reporting date: 2018-12-31), 10-K (reporting date: 2018-09-30), 10-Q (reporting date: 2018-06-30), 10-Q (reporting date: 2018-03-31), 10-Q (reporting date: 2017-12-31), 10-K (reporting date: 2017-09-30), 10-Q (reporting date: 2017-06-30), 10-Q (reporting date: 2017-03-31), 10-Q (reporting date: 2016-12-31).
1 Q3 2023 Calculation
Cash conversion cycle = Average inventory processing period + Average receivable collection period – Average payables payment period
= 25 + 30 – 65 = -10
2 Click competitor name to see calculations.
Short-term activity ratio | Description | The company |
---|---|---|
Cash conversion cycle | A financial metric that measures the length of time required for a company to convert cash invested in its operations to cash received as a result of its operations; equal to average inventory processing period plus average receivables collection period minus average payables payment period. |