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-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).
The analysis of the quarterly financial ratios reveals significant fluctuations and notable trends in the management of working capital components over the examined periods.
- Receivables Turnover
- The receivables turnover ratio exhibited considerable variability, initially fluctuating moderately between around 4 and 13 from early 2019 through 2020. A sharp spike occurred in mid-2021, peaking at an exceptionally high 643.46 by the end of 2022, followed by a steep decline towards the most recent quarters, declining to 3.13. This volatility indicates substantial changes in the efficiency of credit management, suggesting periods of both rapid collection and potential issues with receivables management.
- Average Receivable Collection Period
- The average collection period inversely reflects the trend seen in receivables turnover. It decreased from a high near 92 days in mid-2019 down to around 11 days by late 2021, indicating improvement in collection efficiency. However, it then surged drastically to 269 days at the end of 2021, before improving briefly and again showing wide fluctuations in later periods, suggesting intermittent challenges in collecting receivables promptly.
- Payables Turnover
- The payables turnover ratio showed a generally declining trajectory from highs above 13 in early 2019 to lows below 1 in the most recent quarters of 2023. Such a decline points to slower payments to suppliers over time, implying extended payment terms or delays in settling obligations, with some periods of temporary recovery.
- Average Payables Payment Period
- Corresponding to the payables turnover, the average payment period extended significantly from around 27 days early in the timeline to extremely long durations exceeding 600 days in the last quarters, indicating a substantial delay in fulfilling payables. This suggests potential liquidity constraints or strategic delays in payments impacting supplier relations and working capital management.
- Working Capital Turnover
- The working capital turnover ratio remained relatively low throughout, generally fluctuating between 0.02 and 0.28, with no sustained upward trend. The low ratio signifies that working capital is generating limited revenue relative to its magnitude, and the occasional dips to very low values reflect inefficiencies or difficulties in converting working capital into sales, consistent with the instability seen in receivables and payables metrics.
Overall, the financial data depict a company experiencing considerable fluctuations in receivables and payables management, with periods of both improved efficiency and significant strain. The extended payment periods and irregular collection cycles suggest challenges in cash flow management, which may be impacting operational performance and necessitating focused attention on credit and supplier payment policies.
Turnover Ratios
Average No. Days
Receivables Turnover
| 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 thousands) | |||||||||||||||||||||||||
| Revenues | 378) | 867) | 4,613) | 1,957) | 2,515) | 88,968) | 1,148) | 55,600) | 5,437) | 2,843) | 6,548) | 6,722) | 41,688) | 3,593) | 3,825) | 5,212) | 6,055) | 7,137) | 8,464) | ||||||
| Accounts receivable | 2,499) | 985) | 1,006) | 147) | 2,294) | 1,973) | 6,056) | 51,819) | 644) | 2,701) | 4,514) | 4,420) | 4,965) | 2,254) | 2,704) | 5,163) | 6,576) | 8,993) | 4,165) | ||||||
| Short-term Activity Ratio | |||||||||||||||||||||||||
| Receivables turnover1 | 3.13 | 10.10 | 97.47 | 643.46 | 64.62 | 76.61 | 10.74 | 1.36 | 33.46 | 21.40 | 12.97 | 12.63 | 10.94 | 8.29 | 8.22 | 5.20 | 4.72 | 3.96 | 8.33 | ||||||
| Benchmarks | |||||||||||||||||||||||||
| Receivables Turnover, Competitors2 | |||||||||||||||||||||||||
| AbbVie Inc. | 4.83 | 4.88 | 4.95 | 5.16 | 5.38 | 5.10 | 5.29 | 5.63 | 5.94 | 5.42 | 5.24 | — | — | — | — | — | — | — | — | ||||||
| Amgen Inc. | 4.17 | 4.34 | 4.34 | 4.46 | 4.60 | 4.62 | 4.81 | 4.96 | 5.11 | 5.39 | 5.41 | — | — | — | — | — | — | — | — | ||||||
| Danaher Corp. | 6.15 | 6.64 | 6.89 | 6.40 | 7.09 | 6.81 | 6.87 | 6.36 | 6.69 | 6.51 | 6.28 | — | — | — | — | — | — | — | — | ||||||
| Eli Lilly & Co. | 3.93 | 3.93 | 3.68 | 4.14 | 4.35 | 4.57 | 4.64 | 4.24 | 4.69 | 4.58 | 4.56 | — | — | — | — | — | — | — | — | ||||||
| Gilead Sciences Inc. | 5.68 | 6.43 | 6.43 | 5.65 | 6.16 | 6.60 | 7.18 | 6.01 | 5.95 | 6.34 | 6.43 | — | — | — | — | — | — | — | — | ||||||
| Johnson & Johnson | 5.91 | 5.36 | 5.65 | 5.88 | 6.04 | 5.92 | 6.08 | 6.14 | 6.13 | 6.00 | 5.64 | — | — | — | — | — | — | — | — | ||||||
| Merck & Co. Inc. | 5.71 | 5.29 | 5.56 | 6.27 | 6.22 | 5.93 | 5.49 | 5.28 | 5.56 | 6.00 | 5.65 | — | — | — | — | — | — | — | — | ||||||
| Pfizer Inc. | 6.25 | 7.66 | 7.57 | 9.16 | 6.21 | 6.68 | 6.99 | 7.08 | 5.81 | 5.23 | 4.70 | — | — | — | — | — | — | — | — | ||||||
| Regeneron Pharmaceuticals Inc. | 2.35 | 2.47 | 2.42 | 2.28 | 2.47 | 2.76 | 3.41 | 2.66 | 2.48 | 1.77 | 2.20 | — | — | — | — | — | — | — | — | ||||||
| Thermo Fisher Scientific Inc. | 5.19 | 5.43 | 5.53 | 5.53 | 5.76 | 5.53 | 5.21 | 4.92 | 7.03 | 6.99 | 6.46 | — | — | — | — | — | — | — | — | ||||||
| Vertex Pharmaceuticals Inc. | 6.27 | 6.11 | 5.95 | 6.19 | 6.28 | 6.26 | 6.15 | 6.66 | 6.48 | 7.19 | 6.56 | — | — | — | — | — | — | — | — | ||||||
Based on: 10-Q (reporting date: 2023-09-30), 10-Q (reporting date: 2023-06-30), 10-Q (reporting date: 2023-03-31), 10-K (reporting date: 2022-12-31), 10-Q (reporting date: 2022-09-30), 10-Q (reporting date: 2022-06-30), 10-Q (reporting date: 2022-03-31), 10-K (reporting date: 2021-12-31), 10-Q (reporting date: 2021-09-30), 10-Q (reporting date: 2021-06-30), 10-Q (reporting date: 2021-03-31), 10-K (reporting date: 2020-12-31), 10-Q (reporting date: 2020-09-30), 10-Q (reporting date: 2020-06-30), 10-Q (reporting date: 2020-03-31), 10-K (reporting date: 2019-12-31), 10-Q (reporting date: 2019-09-30), 10-Q (reporting date: 2019-06-30), 10-Q (reporting date: 2019-03-31).
1 Q3 2023 Calculation
Receivables turnover
= (RevenuesQ3 2023
+ RevenuesQ2 2023
+ RevenuesQ1 2023
+ RevenuesQ4 2022)
÷ Accounts receivable
= (378 + 867 + 4,613 + 1,957)
÷ 2,499 = 3.13
2 Click competitor name to see calculations.
Over the observed periods, the revenue figures exhibit notable volatility without a clear upward or downward trend. Initially, revenues decrease from early 2019 through the first quarter of 2020, reaching a low point. Following this, there is a significant spike in the third quarter of 2020, followed by fluctuations including another sharp increase at the end of 2021. In the most recent quarters of 2023, revenues appear to decline to relatively low levels again, indicating inconsistent revenue generation over time.
Accounts receivable amounts also demonstrate variability across the periods, with some distinct spikes and declines. There is a prominent surge in accounts receivable near the end of 2021 and into early 2022, with a peak that far exceeds earlier levels. Subsequently, the amounts drop sharply but remain higher than in the first few years of data. These fluctuations in receivables suggest irregular collections or timing differences relative to sales.
The receivables turnover ratio, which measures how efficiently the company collects its receivables, generally shows improvement (increase) during the middle periods up until late 2021, reaching very high values. This indicates accelerated collections in that time frame. However, this trend is disrupted by a major dip at the end of 2021 into early 2022, signifying a slowdown in collection efficiency. After this decline, the turnover ratio again rises sharply in 2022 and early 2023, though with high variability and some extreme values suggesting potential outliers or non-recurring effects impacting receivables management. The latest periods show a decrease in this ratio, signaling a return to slower receivables collection.
- Revenue Trend
- Revenues are highly variable with no sustained growth or decline, marked by sudden spikes especially in Q3 2020 and Q4 2021.
- Accounts Receivable Behavior
- Receivables display irregular patterns with significant peaks toward late 2021 and early 2022 followed by sharp declines, implying fluctuating collection timing or credit policies.
- Receivables Turnover Analysis
- The turnover ratio reflects periods of heightened collection efficiency alternating with sharp declines. The extremely high and low values indicate episodic changes in collections possibly due to unusual transactions or adjustments.
- Overall Insights
- Financial patterns indicate inconsistent revenue generation and fluctuating collection management, with episodic spikes that may require further investigation to understand underlying causes. Cash flow predictability from receivables may be a concern due to high variability in turnover ratios.
Payables Turnover
| 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 thousands) | |||||||||||||||||||||||||
| Revenues | 378) | 867) | 4,613) | 1,957) | 2,515) | 88,968) | 1,148) | 55,600) | 5,437) | 2,843) | 6,548) | 6,722) | 41,688) | 3,593) | 3,825) | 5,212) | 6,055) | 7,137) | 8,464) | ||||||
| Accounts payable | 13,796) | 12,561) | 17,357) | 25,611) | 14,429) | 14,078) | 19,836) | 21,087) | 16,222) | 14,928) | 7,766) | 8,050) | 6,738) | 2,920) | 3,527) | 8,160) | 3,412) | 5,194) | 2,547) | ||||||
| Short-term Activity Ratio | |||||||||||||||||||||||||
| Payables turnover1 | 0.57 | 0.79 | 5.65 | 3.69 | 10.27 | 10.74 | 3.28 | 3.34 | 1.33 | 3.87 | 7.54 | 6.94 | 8.06 | 6.40 | 6.30 | 3.29 | 9.10 | 6.86 | 13.62 | ||||||
| Benchmarks | |||||||||||||||||||||||||
| Payables Turnover, Competitors2 | |||||||||||||||||||||||||
| Amgen Inc. | 5.22 | 5.67 | 4.97 | 4.08 | 5.30 | 5.09 | 4.65 | 4.72 | 5.41 | 4.92 | 4.40 | — | — | — | — | — | — | — | — | ||||||
| Bristol-Myers Squibb Co. | 3.75 | 3.38 | 3.20 | 3.33 | 3.82 | 3.41 | 3.25 | 3.37 | 3.89 | 2.97 | 3.69 | — | — | — | — | — | — | — | — | ||||||
| Danaher Corp. | 5.63 | 5.82 | 5.68 | 5.45 | 5.61 | 5.00 | 5.04 | 4.48 | 5.20 | 5.54 | 5.29 | — | — | — | — | — | — | — | — | ||||||
| Eli Lilly & Co. | 2.81 | 2.65 | 3.07 | 3.43 | 4.24 | 4.21 | 5.24 | 4.38 | 4.46 | 4.30 | 3.75 | — | — | — | — | — | — | — | — | ||||||
| Gilead Sciences Inc. | 9.90 | 9.06 | 8.99 | 6.25 | 11.22 | 11.89 | 11.43 | 9.36 | 9.18 | 8.70 | 8.71 | — | — | — | — | — | — | — | — | ||||||
| Johnson & Johnson | 3.29 | 2.75 | 3.05 | 2.66 | 3.08 | 3.15 | 3.26 | 2.70 | 3.32 | 3.38 | 3.34 | — | — | — | — | — | — | — | — | ||||||
| Merck & Co. Inc. | 4.59 | 4.58 | 4.34 | 4.08 | 5.16 | 4.86 | 4.25 | 2.96 | 4.54 | 3.93 | 3.81 | — | — | — | — | — | — | — | — | ||||||
| Pfizer Inc. | 5.07 | 3.92 | 4.78 | 5.04 | 5.49 | 6.17 | 6.66 | 5.53 | 5.11 | 3.72 | 2.68 | — | — | — | — | — | — | — | — | ||||||
| Regeneron Pharmaceuticals Inc. | 3.43 | 3.14 | 2.69 | 2.65 | 3.74 | 4.00 | 5.39 | 4.32 | 4.23 | 3.42 | 2.23 | — | — | — | — | — | — | — | — | ||||||
| Thermo Fisher Scientific Inc. | 10.41 | 10.82 | 9.35 | 7.67 | 9.93 | 8.84 | 7.96 | 6.83 | 8.31 | 8.88 | 8.12 | — | — | — | — | — | — | — | — | ||||||
| Vertex Pharmaceuticals Inc. | 3.13 | 3.16 | 3.41 | 3.55 | 8.23 | 5.01 | 5.52 | 4.64 | 6.73 | 6.35 | 5.99 | — | — | — | — | — | — | — | — | ||||||
Based on: 10-Q (reporting date: 2023-09-30), 10-Q (reporting date: 2023-06-30), 10-Q (reporting date: 2023-03-31), 10-K (reporting date: 2022-12-31), 10-Q (reporting date: 2022-09-30), 10-Q (reporting date: 2022-06-30), 10-Q (reporting date: 2022-03-31), 10-K (reporting date: 2021-12-31), 10-Q (reporting date: 2021-09-30), 10-Q (reporting date: 2021-06-30), 10-Q (reporting date: 2021-03-31), 10-K (reporting date: 2020-12-31), 10-Q (reporting date: 2020-09-30), 10-Q (reporting date: 2020-06-30), 10-Q (reporting date: 2020-03-31), 10-K (reporting date: 2019-12-31), 10-Q (reporting date: 2019-09-30), 10-Q (reporting date: 2019-06-30), 10-Q (reporting date: 2019-03-31).
1 Q3 2023 Calculation
Payables turnover
= (RevenuesQ3 2023
+ RevenuesQ2 2023
+ RevenuesQ1 2023
+ RevenuesQ4 2022)
÷ Accounts payable
= (378 + 867 + 4,613 + 1,957)
÷ 13,796 = 0.57
2 Click competitor name to see calculations.
The financial data reveals considerable fluctuations in the key metrics over the analyzed periods, indicating varying operational activity and changes in the company's payment dynamics.
- Revenues
- Revenues exhibited a volatile trend, with values ranging from a high of 55,600 thousand US dollars in December 2021 to lows below 1,000 thousand US dollars in several quarters of 2022 and 2023. Initial periods show revenue figures in the mid to high single-digit thousands, followed by a remarkable spike in September 2020 and December 2021. However, this was not sustained, as revenues declined sharply in subsequent quarters, reflecting possible issues with consistency in sales or contract recognition.
- Accounts Payable
- The level of accounts payable shows a generally increasing trend over time, rising from 2,547 thousand US dollars in the first quarter of 2019 to peaks around 25,611 thousand US dollars by the fourth quarter of 2022. This rise suggests the company has increased its use of credit from suppliers or delayed payments. Notably, there are multiple substantial jumps possibly reflecting changes in procurement or payment policies.
- Payables Turnover Ratio
- The payables turnover ratio demonstrates significant variability, fluctuating between a low of 0.57 and a high of 13.62. Higher turnover ratios in early periods indicate quicker payments to suppliers, while declining values in later quarters suggest a lengthening of payment cycles. Specifically, ratios below 1 in the recent periods point to very slow payment behavior relative to purchases, which may impact supplier relationships or reflect cash management strategies.
Overall, the trends suggest that the company has faced considerable instability in revenue generation accompanied by a growing and increasingly slow-turning accounts payable balance. This combination may signal operational or market challenges affecting cash flows and supplier credit terms.
Working Capital Turnover
| 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 thousands) | |||||||||||||||||||||||||
| Current assets | 561,416) | 586,575) | 680,629) | 795,186) | 884,275) | 602,250) | 623,526) | 535,672) | 494,941) | 364,229) | 433,117) | 474,221) | 418,412) | 218,954) | 225,938) | 233,752) | 176,535) | 184,951) | 186,400) | ||||||
| Less: Current liabilities | 77,723) | 65,617) | 75,220) | 84,617) | 76,496) | 66,843) | 66,847) | 71,860) | 80,868) | 61,766) | 35,930) | 31,199) | 27,573) | 22,696) | 20,741) | 26,023) | 21,517) | 21,959) | 26,277) | ||||||
| Working capital | 483,693) | 520,958) | 605,409) | 710,569) | 807,779) | 535,407) | 556,679) | 463,812) | 414,073) | 302,463) | 397,187) | 443,022) | 390,839) | 196,258) | 205,197) | 207,729) | 155,018) | 162,992) | 160,123) | ||||||
| Revenues | 378) | 867) | 4,613) | 1,957) | 2,515) | 88,968) | 1,148) | 55,600) | 5,437) | 2,843) | 6,548) | 6,722) | 41,688) | 3,593) | 3,825) | 5,212) | 6,055) | 7,137) | 8,464) | ||||||
| Short-term Activity Ratio | |||||||||||||||||||||||||
| Working capital turnover1 | 0.02 | 0.02 | 0.16 | 0.13 | 0.18 | 0.28 | 0.12 | 0.15 | 0.05 | 0.19 | 0.15 | 0.13 | 0.14 | 0.10 | 0.11 | 0.13 | 0.20 | 0.22 | 0.22 | ||||||
| Benchmarks | |||||||||||||||||||||||||
| Working Capital Turnover, Competitors2 | |||||||||||||||||||||||||
| AbbVie Inc. | — | — | — | — | — | — | — | — | 130.12 | — | — | — | — | — | — | — | — | — | — | ||||||
| Amgen Inc. | 0.81 | 0.84 | 0.82 | 3.82 | 2.52 | 3.67 | 4.34 | 3.37 | 2.55 | 5.35 | 2.84 | — | — | — | — | — | — | — | — | ||||||
| Bristol-Myers Squibb Co. | 10.47 | 5.53 | 5.55 | 8.30 | 5.75 | 4.92 | 6.24 | 3.95 | 4.43 | 4.24 | 4.25 | — | — | — | — | — | — | — | — | ||||||
| Danaher Corp. | 2.18 | 3.08 | 3.81 | 4.20 | 5.00 | 5.43 | 5.91 | 8.40 | 7.98 | 3.12 | 3.45 | — | — | — | — | — | — | — | — | ||||||
| Eli Lilly & Co. | 31.79 | 12.21 | 5.77 | 31.84 | 14.71 | 19.45 | 8.19 | 8.33 | 6.73 | 12.14 | 5.21 | — | — | — | — | — | — | — | — | ||||||
| Gilead Sciences Inc. | 6.74 | 84.15 | 9.14 | 8.42 | 8.56 | 6.87 | 6.68 | 8.54 | 7.25 | 7.09 | 7.06 | — | — | — | — | — | — | — | — | ||||||
| Johnson & Johnson | 9.37 | 14.06 | 23.02 | — | 4.88 | 5.02 | 5.57 | 5.95 | 5.97 | 5.93 | 7.26 | — | — | — | — | — | — | — | — | ||||||
| Merck & Co. Inc. | 6.69 | 8.86 | 5.63 | 5.16 | 5.58 | 6.39 | 6.09 | 7.62 | 6.51 | 6.97 | 84.97 | — | — | — | — | — | — | — | — | ||||||
| Pfizer Inc. | 1.62 | 2.03 | 6.89 | 11.00 | 3.83 | 5.05 | 6.10 | 4.78 | 4.29 | 4.21 | 3.60 | — | — | — | — | — | — | — | — | ||||||
| Regeneron Pharmaceuticals Inc. | 0.87 | 0.92 | 0.90 | 0.96 | 1.09 | 1.14 | 1.46 | 1.59 | 1.35 | 1.29 | 1.35 | — | — | — | — | — | — | — | — | ||||||
| Thermo Fisher Scientific Inc. | 4.86 | 7.40 | 10.13 | 5.46 | 5.40 | 6.03 | 6.13 | 5.87 | 2.30 | 3.10 | 3.36 | — | — | — | — | — | — | — | — | ||||||
| Vertex Pharmaceuticals Inc. | 0.87 | 0.90 | 0.93 | 0.85 | 0.90 | 0.93 | 0.97 | 1.02 | 1.03 | 1.01 | 0.97 | — | — | — | — | — | — | — | — | ||||||
Based on: 10-Q (reporting date: 2023-09-30), 10-Q (reporting date: 2023-06-30), 10-Q (reporting date: 2023-03-31), 10-K (reporting date: 2022-12-31), 10-Q (reporting date: 2022-09-30), 10-Q (reporting date: 2022-06-30), 10-Q (reporting date: 2022-03-31), 10-K (reporting date: 2021-12-31), 10-Q (reporting date: 2021-09-30), 10-Q (reporting date: 2021-06-30), 10-Q (reporting date: 2021-03-31), 10-K (reporting date: 2020-12-31), 10-Q (reporting date: 2020-09-30), 10-Q (reporting date: 2020-06-30), 10-Q (reporting date: 2020-03-31), 10-K (reporting date: 2019-12-31), 10-Q (reporting date: 2019-09-30), 10-Q (reporting date: 2019-06-30), 10-Q (reporting date: 2019-03-31).
1 Q3 2023 Calculation
Working capital turnover
= (RevenuesQ3 2023
+ RevenuesQ2 2023
+ RevenuesQ1 2023
+ RevenuesQ4 2022)
÷ Working capital
= (378 + 867 + 4,613 + 1,957)
÷ 483,693 = 0.02
2 Click competitor name to see calculations.
- Working Capital Trends
- The working capital exhibited fluctuations over the analyzed periods, with a general upward trend from early 2019 through late 2022. Starting at approximately $160 million in March 2019, working capital increased significantly to over $807 million by September 2022. However, following this peak, a decline is observed, with working capital falling to around $484 million by September 2023. This suggests periods of expansion in liquidity or operational resources followed by contraction in recent quarters.
- Revenue Patterns
- Revenue figures demonstrated considerable volatility without a clear upward or downward trajectory. There were quarters with exceptionally high revenues, such as a notable spike to over $55 million in December 2021 and nearly $89 million in June 2022, which contrast sharply with periods of much lower revenues in the low thousands or sub-thousands. This variability indicates episodic or project-based income streams rather than consistent steady revenue generation.
- Working Capital Turnover Ratio
- The working capital turnover ratio largely stayed below 0.3 throughout the periods, indicating relatively low revenue generation per unit of working capital. Notably, the ratio declined to its lowest levels around late 2021 and mid-2023, reaching 0.02 during these periods. This suggests that despite fluctuations in working capital and revenue amounts, the efficiency of working capital utilization to generate revenue remained limited, particularly in recent quarters.
- Overall Insights
- The financial data reflects an entity with significant additions to working capital over the medium term, likely to support operations or growth initiatives, yet this did not consistently translate into proportionate revenue increases. The sporadic nature of revenue spikes implies dependency on large, irregular transactions or milestone payments. Meanwhile, the persistently low working capital turnover ratios highlight challenges in converting resources into sales efficiently, especially noticeable in the most recent periods where turnover reached historical lows.
Average Receivable Collection Period
| 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 | 3.13 | 10.10 | 97.47 | 643.46 | 64.62 | 76.61 | 10.74 | 1.36 | 33.46 | 21.40 | 12.97 | 12.63 | 10.94 | 8.29 | 8.22 | 5.20 | 4.72 | 3.96 | 8.33 | ||||||
| Short-term Activity Ratio (no. days) | |||||||||||||||||||||||||
| Average receivable collection period1 | 117 | 36 | 4 | 1 | 6 | 5 | 34 | 269 | 11 | 17 | 28 | 29 | 33 | 44 | 44 | 70 | 77 | 92 | 44 | ||||||
| Benchmarks (no. days) | |||||||||||||||||||||||||
| Average Receivable Collection Period, Competitors2 | |||||||||||||||||||||||||
| AbbVie Inc. | 76 | 75 | 74 | 71 | 68 | 72 | 69 | 65 | 61 | 67 | 70 | — | — | — | — | — | — | — | — | ||||||
| Amgen Inc. | 88 | 84 | 84 | 82 | 79 | 79 | 76 | 74 | 71 | 68 | 67 | — | — | — | — | — | — | — | — | ||||||
| Danaher Corp. | 59 | 55 | 53 | 57 | 51 | 54 | 53 | 57 | 55 | 56 | 58 | — | — | — | — | — | — | — | — | ||||||
| Eli Lilly & Co. | 93 | 93 | 99 | 88 | 84 | 80 | 79 | 86 | 78 | 80 | 80 | — | — | — | — | — | — | — | — | ||||||
| Gilead Sciences Inc. | 64 | 57 | 57 | 65 | 59 | 55 | 51 | 61 | 61 | 58 | 57 | — | — | — | — | — | — | — | — | ||||||
| Johnson & Johnson | 62 | 68 | 65 | 62 | 60 | 62 | 60 | 59 | 60 | 61 | 65 | — | — | — | — | — | — | — | — | ||||||
| Merck & Co. Inc. | 64 | 69 | 66 | 58 | 59 | 62 | 66 | 69 | 66 | 61 | 65 | — | — | — | — | — | — | — | — | ||||||
| Pfizer Inc. | 58 | 48 | 48 | 40 | 59 | 55 | 52 | 52 | 63 | 70 | 78 | — | — | — | — | — | — | — | — | ||||||
| Regeneron Pharmaceuticals Inc. | 156 | 148 | 151 | 160 | 148 | 132 | 107 | 137 | 147 | 206 | 166 | — | — | — | — | — | — | — | — | ||||||
| Thermo Fisher Scientific Inc. | 70 | 67 | 66 | 66 | 63 | 66 | 70 | 74 | 52 | 52 | 56 | — | — | — | — | — | — | — | — | ||||||
| Vertex Pharmaceuticals Inc. | 58 | 60 | 61 | 59 | 58 | 58 | 59 | 55 | 56 | 51 | 56 | — | — | — | — | — | — | — | — | ||||||
Based on: 10-Q (reporting date: 2023-09-30), 10-Q (reporting date: 2023-06-30), 10-Q (reporting date: 2023-03-31), 10-K (reporting date: 2022-12-31), 10-Q (reporting date: 2022-09-30), 10-Q (reporting date: 2022-06-30), 10-Q (reporting date: 2022-03-31), 10-K (reporting date: 2021-12-31), 10-Q (reporting date: 2021-09-30), 10-Q (reporting date: 2021-06-30), 10-Q (reporting date: 2021-03-31), 10-K (reporting date: 2020-12-31), 10-Q (reporting date: 2020-09-30), 10-Q (reporting date: 2020-06-30), 10-Q (reporting date: 2020-03-31), 10-K (reporting date: 2019-12-31), 10-Q (reporting date: 2019-09-30), 10-Q (reporting date: 2019-06-30), 10-Q (reporting date: 2019-03-31).
1 Q3 2023 Calculation
Average receivable collection period = 365 ÷ Receivables turnover
= 365 ÷ 3.13 = 117
2 Click competitor name to see calculations.
- Receivables Turnover Ratio
- The receivables turnover ratio exhibited significant fluctuation over the observed periods. Initially, the ratio decreased from 8.33 to a low of 3.96, then experienced a gradual increase reaching a peak of 33.46 in September 2021. This was followed by a dramatic spike to an exceptionally high value of 643.46 in December 2022, indicating an extraordinary acceleration in collecting receivables during that quarter. Subsequent quarters saw a sharp decline from the peak, settling closer to earlier values, with the ratio falling to 3.13 by September 2023. Overall, the trend demonstrates periods of both slow and extremely rapid receivables collection efficiency, with significant volatility especially in the later periods.
- Average Receivable Collection Period
- The average receivable collection period inversely mirrored the turnover ratio trends. It started at 44 days, increased to a peak of 92 days early in the period, then decreased steadily to a low of 11 days in September 2021. A notable anomaly occurred in December 2021, with the collection period spiking dramatically to 269 days, indicating delayed collections during that quarter. Following this, the days outstanding dropped sharply to as low as 1 day in December 2022, reflecting extremely efficient collections. However, the period then lengthened again, reaching 117 days by September 2023. These fluctuations suggest inconsistencies in collection practices or changes in customer payment behavior, with occasional extreme deviations from typical collection periods.
- Overall Analysis
- The data reveals notable volatility in both receivables turnover and collection periods across the examined time frame. While periods of improved efficiency are evident, particularly around late 2020 and late 2022, the presence of extraordinary spikes and troughs implies episodic irregularities. Such variability could be attributed to external factors impacting receivables management or significant changes in credit policies. Careful monitoring and investigation into the causes of these sharp fluctuations are advisable to manage credit risk and optimize cash flow.
Average Payables Payment Period
| 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 | 0.57 | 0.79 | 5.65 | 3.69 | 10.27 | 10.74 | 3.28 | 3.34 | 1.33 | 3.87 | 7.54 | 6.94 | 8.06 | 6.40 | 6.30 | 3.29 | 9.10 | 6.86 | 13.62 | ||||||
| Short-term Activity Ratio (no. days) | |||||||||||||||||||||||||
| Average payables payment period1 | 644 | 461 | 65 | 99 | 36 | 34 | 111 | 109 | 275 | 94 | 48 | 53 | 45 | 57 | 58 | 111 | 40 | 53 | 27 | ||||||
| Benchmarks (no. days) | |||||||||||||||||||||||||
| Average Payables Payment Period, Competitors2 | |||||||||||||||||||||||||
| Amgen Inc. | 70 | 64 | 73 | 90 | 69 | 72 | 78 | 77 | 67 | 74 | 83 | — | — | — | — | — | — | — | — | ||||||
| Bristol-Myers Squibb Co. | 97 | 108 | 114 | 109 | 96 | 107 | 112 | 108 | 94 | 123 | 99 | — | — | — | — | — | — | — | — | ||||||
| Danaher Corp. | 65 | 63 | 64 | 67 | 65 | 73 | 72 | 82 | 70 | 66 | 69 | — | — | — | — | — | — | — | — | ||||||
| Eli Lilly & Co. | 130 | 138 | 119 | 106 | 86 | 87 | 70 | 83 | 82 | 85 | 97 | — | — | — | — | — | — | — | — | ||||||
| Gilead Sciences Inc. | 37 | 40 | 41 | 58 | 33 | 31 | 32 | 39 | 40 | 42 | 42 | — | — | — | — | — | — | — | — | ||||||
| Johnson & Johnson | 111 | 133 | 120 | 137 | 118 | 116 | 112 | 135 | 110 | 108 | 109 | — | — | — | — | — | — | — | — | ||||||
| Merck & Co. Inc. | 80 | 80 | 84 | 89 | 71 | 75 | 86 | 123 | 80 | 93 | 96 | — | — | — | — | — | — | — | — | ||||||
| Pfizer Inc. | 72 | 93 | 76 | 72 | 66 | 59 | 55 | 66 | 71 | 98 | 136 | — | — | — | — | — | — | — | — | ||||||
| Regeneron Pharmaceuticals Inc. | 106 | 116 | 136 | 138 | 98 | 91 | 68 | 84 | 86 | 107 | 164 | — | — | — | — | — | — | — | — | ||||||
| Thermo Fisher Scientific Inc. | 35 | 34 | 39 | 48 | 37 | 41 | 46 | 53 | 44 | 41 | 45 | — | — | — | — | — | — | — | — | ||||||
| Vertex Pharmaceuticals Inc. | 117 | 115 | 107 | 103 | 44 | 73 | 66 | 79 | 54 | 57 | 61 | — | — | — | — | — | — | — | — | ||||||
Based on: 10-Q (reporting date: 2023-09-30), 10-Q (reporting date: 2023-06-30), 10-Q (reporting date: 2023-03-31), 10-K (reporting date: 2022-12-31), 10-Q (reporting date: 2022-09-30), 10-Q (reporting date: 2022-06-30), 10-Q (reporting date: 2022-03-31), 10-K (reporting date: 2021-12-31), 10-Q (reporting date: 2021-09-30), 10-Q (reporting date: 2021-06-30), 10-Q (reporting date: 2021-03-31), 10-K (reporting date: 2020-12-31), 10-Q (reporting date: 2020-09-30), 10-Q (reporting date: 2020-06-30), 10-Q (reporting date: 2020-03-31), 10-K (reporting date: 2019-12-31), 10-Q (reporting date: 2019-09-30), 10-Q (reporting date: 2019-06-30), 10-Q (reporting date: 2019-03-31).
1 Q3 2023 Calculation
Average payables payment period = 365 ÷ Payables turnover
= 365 ÷ 0.57 = 644
2 Click competitor name to see calculations.
The analysis of the payables turnover and average payables payment period over the given quarters reveals notable fluctuations and trends in the company's management of its payables.
- Payables Turnover Ratio
- The payables turnover ratio exhibits significant variability across periods. Starting at a relatively high 13.62 in the first quarter of 2019, the ratio declines sharply in the following quarters, reaching a low of 3.29 by the end of 2019. It then partially recovers, fluctuating between approximately 6 and 8 during most of 2020 and early 2021. However, from mid-2021 onwards, the ratio sees a marked decline, hitting very low levels of 0.79 and 0.57 in the third and fourth quarters of 2023. This downward trend indicates a decreasing frequency of payables turnover, implying that the company is taking longer to pay its suppliers as time progresses into 2023.
- Average Payables Payment Period
- The average payables payment period shows an inverse pattern relative to the turnover ratio, as expected. Initially, the payment period fluctuates between 27 and 111 days throughout 2019 and 2020, with several spikes such as 111 days at the end of 2019 and 109 days in the second quarter of 2022. This suggests occasional delays or extensions in payment terms during these periods. From mid-2021, there is a pronounced increase in the average payment period, culminating in extraordinarily long periods of 461 days and 644 days in the third and fourth quarters of 2023, respectively. This prolonged duration indicates a substantial delay in settling payables, which correlates with the steep drop in turnover ratio during the same timeframe.
- Overall Trends and Insights
- Over the timeframe analyzed, the company demonstrates a trend of extending payment periods significantly, particularly in the most recent year. The sharp increase in days payable outstanding may reflect changes in supplier payment policies, liquidity constraints, or strategic efforts to conserve cash. The corresponding decline in the payables turnover ratio supports this interpretation. Early periods showed more dynamic payment activity with shorter cycles, but recent quarters suggest a marked shift to slower payments. This trend could affect supplier relationships and credit terms in the longer term.