Stock Analysis on Net

AmerisourceBergen Corp. (NYSE:ABC)

This company has been moved to the archive! The financial data has not been updated since August 2, 2023.

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

Microsoft Excel

Short-term Activity Ratios (Summary)

AmerisourceBergen Corp., short-term (operating) activity ratios (quarterly data)

Microsoft Excel
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
Turnover Ratios
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
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
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
Working capital turnover 79.38
Average No. Days
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
Add: 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
Operating cycle 55 55 54 53 54 55 56 58 60 51 53 52 49 50 49 48 49 49 51 52 54 56 53 53
Less: 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
Cash conversion cycle -10 -10 -11 -11 -9 -8 -10 -9 -7 -9 -12 -11 -10 -12 -11 -11 -10 -11 -11 -8 -7 -6 -8 -9

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

AmerisourceBergen Corp., inventory turnover calculation (quarterly data)

Microsoft Excel
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

AmerisourceBergen Corp., receivables turnover calculation (quarterly data)

Microsoft Excel
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

AmerisourceBergen Corp., payables turnover calculation (quarterly data)

Microsoft Excel
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

AmerisourceBergen Corp., working capital turnover calculation (quarterly data)

Microsoft Excel
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

AmerisourceBergen Corp., average inventory processing period calculation (quarterly data)

Microsoft Excel
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

AmerisourceBergen Corp., average receivable collection period calculation (quarterly data)

Microsoft Excel
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

AmerisourceBergen Corp., operating cycle calculation (quarterly data)

No. days

Microsoft Excel
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

AmerisourceBergen Corp., average payables payment period calculation (quarterly data)

Microsoft Excel
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

AmerisourceBergen Corp., cash conversion cycle calculation (quarterly data)

No. days

Microsoft Excel
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 + 3065 = -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.