Stock Analysis on Net

Celgene Corp. (NASDAQ:CELG)

This company has been moved to the archive! The financial data has not been updated since October 31, 2019.

Analysis of Liquidity Ratios 
Quarterly Data

Microsoft Excel

Liquidity Ratios (Summary)

Celgene Corp., liquidity ratios (quarterly data)

Microsoft Excel
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 Sep 30, 2016 Jun 30, 2016 Mar 31, 2016 Dec 31, 2015 Sep 30, 2015 Jun 30, 2015 Mar 31, 2015 Dec 31, 2014 Sep 30, 2014 Jun 30, 2014 Mar 31, 2014
Current ratio 2.89 3.44 2.78 2.23 2.13 1.52 2.53 4.99 3.65 4.05 4.42 3.67 3.61 4.61 4.57 4.77 3.23 3.34 4.61 4.60 6.32 5.44 2.86
Quick ratio 2.65 3.20 2.53 2.00 1.76 1.22 2.16 4.67 3.35 3.66 3.98 3.24 3.19 3.99 3.89 4.05 2.79 2.96 4.05 4.13 5.67 4.92 2.55
Cash ratio 2.18 2.53 1.94 1.49 1.19 0.76 1.52 4.03 2.90 3.13 3.37 2.69 2.59 3.22 3.11 3.33 2.39 2.53 3.49 3.57 4.91 4.17 2.11

Based on: 10-Q (reporting date: 2019-09-30), 10-Q (reporting date: 2019-06-30), 10-Q (reporting date: 2019-03-31), 10-K (reporting date: 2018-12-31), 10-Q (reporting date: 2018-09-30), 10-Q (reporting date: 2018-06-30), 10-Q (reporting date: 2018-03-31), 10-K (reporting date: 2017-12-31), 10-Q (reporting date: 2017-09-30), 10-Q (reporting date: 2017-06-30), 10-Q (reporting date: 2017-03-31), 10-K (reporting date: 2016-12-31), 10-Q (reporting date: 2016-09-30), 10-Q (reporting date: 2016-06-30), 10-Q (reporting date: 2016-03-31), 10-K (reporting date: 2015-12-31), 10-Q (reporting date: 2015-09-30), 10-Q (reporting date: 2015-06-30), 10-Q (reporting date: 2015-03-31), 10-K (reporting date: 2014-12-31), 10-Q (reporting date: 2014-09-30), 10-Q (reporting date: 2014-06-30), 10-Q (reporting date: 2014-03-31).


Current Ratio
The current ratio exhibits considerable variability over the analyzed quarters. It peaked at 6.32 at the end of the third quarter of 2014, indicating a strong short-term liquidity position at that time. Subsequently, it declined, fluctuating mostly between 3 and 5 until the end of 2017. From early 2018 onward, the ratio trended downward, hitting a low of 1.52 in the second quarter of 2018. After this trough, there was a moderate recovery, with the ratio rising again to levels around 2.5 to 3.5 by the third quarter of 2019. This pattern suggests periods of both ample liquidity and tighter working capital management.
Quick Ratio
Similar to the current ratio, the quick ratio follows a decreasing trend after reaching a high point in 2014. It began above 5 in the third quarter of 2014 and then generally declined, oscillating mostly between 3 and 4 during 2015 through 2017. The sharpest decline is observed in 2018, with the ratio falling to 1.22 in the second quarter of that year, implying a reduction in liquid assets excluding inventories. By late 2019, there was a partial rebound with the quick ratio increasing to around 2.6 to 3.2, signaling some restoration of more liquid current assets.
Cash Ratio
The cash ratio shows the most pronounced volatility among the three liquidity measures. It reached peak values above 4.9 in late 2014 but then demonstrated a downward trend, falling below 2.0 for the first time in the latter half of 2018 and reaching a low of 0.76 in the second quarter of 2018. This indicates reduced levels of readily available cash relative to current liabilities during that period. The cash ratio then recovered somewhat, reaching above 2.0 again by the third quarter of 2019. This recovery, however, does not fully restore the previous high liquidity levels seen in early years.
General Observations
Across all three liquidity ratios, there is a clear pattern of peak liquidity in 2014 followed by a gradual decline through 2018. The decline in these ratios indicates tightening liquidity and potentially more aggressive management of working capital or changes in current liabilities. The low points in mid-2018 reflect the most constrained liquidity conditions during the period under review. The partial rebound seen in the final quarters suggests improved liquidity management or changes in the balance sheet structure but not a return to the robust liquidity levels observed in 2014.

Current Ratio

Celgene Corp., current ratio calculation (quarterly data)

Microsoft Excel
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 Sep 30, 2016 Jun 30, 2016 Mar 31, 2016 Dec 31, 2015 Sep 30, 2015 Jun 30, 2015 Mar 31, 2015 Dec 31, 2014 Sep 30, 2014 Jun 30, 2014 Mar 31, 2014
Selected Financial Data (US$ in millions)
Current assets 14,454 12,683 10,981 9,067 7,827 6,853 7,872 14,892 14,783 13,136 11,617 10,868 9,576 9,169 8,386 9,401 10,152 9,884 9,665 9,713 8,836 8,107 6,942
Current liabilities 5,009 3,685 3,955 4,057 3,683 4,502 3,115 2,987 4,049 3,240 2,629 2,959 2,649 1,987 1,834 1,969 3,144 2,960 2,097 2,112 1,398 1,492 2,425
Liquidity Ratio
Current ratio1 2.89 3.44 2.78 2.23 2.13 1.52 2.53 4.99 3.65 4.05 4.42 3.67 3.61 4.61 4.57 4.77 3.23 3.34 4.61 4.60 6.32 5.44 2.86
Benchmarks
Current Ratio, Competitors2
AbbVie Inc.
Amgen Inc.
Bristol-Myers Squibb Co.
Danaher Corp.
Eli Lilly & Co.
Gilead Sciences Inc.
Johnson & Johnson
Merck & Co. Inc.
Pfizer Inc.
Regeneron Pharmaceuticals Inc.
Thermo Fisher Scientific Inc.
Vertex Pharmaceuticals Inc.

Based on: 10-Q (reporting date: 2019-09-30), 10-Q (reporting date: 2019-06-30), 10-Q (reporting date: 2019-03-31), 10-K (reporting date: 2018-12-31), 10-Q (reporting date: 2018-09-30), 10-Q (reporting date: 2018-06-30), 10-Q (reporting date: 2018-03-31), 10-K (reporting date: 2017-12-31), 10-Q (reporting date: 2017-09-30), 10-Q (reporting date: 2017-06-30), 10-Q (reporting date: 2017-03-31), 10-K (reporting date: 2016-12-31), 10-Q (reporting date: 2016-09-30), 10-Q (reporting date: 2016-06-30), 10-Q (reporting date: 2016-03-31), 10-K (reporting date: 2015-12-31), 10-Q (reporting date: 2015-09-30), 10-Q (reporting date: 2015-06-30), 10-Q (reporting date: 2015-03-31), 10-K (reporting date: 2014-12-31), 10-Q (reporting date: 2014-09-30), 10-Q (reporting date: 2014-06-30), 10-Q (reporting date: 2014-03-31).

1 Q3 2019 Calculation
Current ratio = Current assets ÷ Current liabilities
= 14,454 ÷ 5,009 = 2.89

2 Click competitor name to see calculations.


The analysis of the quarterly data reveals notable variations in the liquidity position over the examined periods. Current assets exhibit an overall fluctuating pattern with periods of growth followed by declines at certain intervals. From the start of the data period, current assets increased steadily, reaching a peak near the end of 2017 before experiencing a significant decrease in early 2018. A recovery trend is then observed through to the third quarter of 2019.

Current liabilities demonstrate a more volatile behavior compared to current assets. There are sharp fluctuations throughout the timeline, with several notable peaks and troughs. The liabilities show an increase in the middle of the timeline around 2015 and again a marked increase near the end of 2019, which suggests periods of increased short-term obligations.

The current ratio, which measures liquidity by comparing current assets to current liabilities, mirrors the volatility exhibited in both current assets and current liabilities. High current ratio values are seen in the mid-2014 period and intermittently up until the end of 2017, indicating relatively strong liquidity during those times. Conversely, the ratio declines sharply in 2018, reaching its lowest points in the second and third quarters of that year. This suggests a tightening of liquidity and a comparatively weaker ability to cover short-term obligations during this period. An improvement in the current ratio is visible again towards the later quarters of 2018 through to mid-2019, albeit with some fluctuation.

Summary of Key Trends
- Current assets showed growth through 2014 to 2017 with a peak at the end of 2017, followed by a downturn in 2018 and recovery afterwards.
- Current liabilities fluctuated considerably with sharp increases around mid-2015 and late 2019.
- The current ratio indicated robust liquidity ratios during 2014 to 2017 but demonstrated weakening liquidity in 2018 before partial recovery in 2019.
- The liquidity position is characterized by cyclical changes, reflecting a dynamic balance between assets and liabilities over the periods analyzed.

Quick Ratio

Celgene Corp., quick ratio calculation (quarterly data)

Microsoft Excel
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 Sep 30, 2016 Jun 30, 2016 Mar 31, 2016 Dec 31, 2015 Sep 30, 2015 Jun 30, 2015 Mar 31, 2015 Dec 31, 2014 Sep 30, 2014 Jun 30, 2014 Mar 31, 2014
Selected Financial Data (US$ in millions)
Cash and cash equivalents 9,604 7,214 5,433 4,234 2,480 1,503 2,819 7,013 5,511 6,660 5,273 6,170 5,523 5,064 4,446 4,880 6,017 4,531 4,368 4,122 3,743 3,220 2,397
Debt securities available-for-sale 14 613 664 496 66 79 68 3,219
Equity investments with readily determinable fair values 1,279 1,496 1,594 1,312 1,832 1,828 1,853 1,810
Marketable securities available-for-sale 6,248 3,480 3,588 1,800 1,346 1,340 1,262 1,672 1,489 2,961 2,946 3,425 3,118 2,994 2,714
Accounts receivable, net of allowances 2,374 2,451 2,327 2,066 2,120 2,064 1,991 1,921 1,816 1,729 1,614 1,621 1,586 1,515 1,420 1,421 1,272 1,273 1,179 1,167 1,068 1,124 1,073
Total quick assets 13,271 11,774 10,018 8,108 6,498 5,474 6,731 13,963 13,575 11,869 10,475 9,590 8,455 7,919 7,128 7,973 8,778 8,766 8,493 8,713 7,929 7,337 6,183
 
Current liabilities 5,009 3,685 3,955 4,057 3,683 4,502 3,115 2,987 4,049 3,240 2,629 2,959 2,649 1,987 1,834 1,969 3,144 2,960 2,097 2,112 1,398 1,492 2,425
Liquidity Ratio
Quick ratio1 2.65 3.20 2.53 2.00 1.76 1.22 2.16 4.67 3.35 3.66 3.98 3.24 3.19 3.99 3.89 4.05 2.79 2.96 4.05 4.13 5.67 4.92 2.55
Benchmarks
Quick Ratio, Competitors2
AbbVie Inc.
Amgen Inc.
Bristol-Myers Squibb Co.
Danaher Corp.
Eli Lilly & Co.
Gilead Sciences Inc.
Johnson & Johnson
Merck & Co. Inc.
Pfizer Inc.
Regeneron Pharmaceuticals Inc.
Thermo Fisher Scientific Inc.
Vertex Pharmaceuticals Inc.

Based on: 10-Q (reporting date: 2019-09-30), 10-Q (reporting date: 2019-06-30), 10-Q (reporting date: 2019-03-31), 10-K (reporting date: 2018-12-31), 10-Q (reporting date: 2018-09-30), 10-Q (reporting date: 2018-06-30), 10-Q (reporting date: 2018-03-31), 10-K (reporting date: 2017-12-31), 10-Q (reporting date: 2017-09-30), 10-Q (reporting date: 2017-06-30), 10-Q (reporting date: 2017-03-31), 10-K (reporting date: 2016-12-31), 10-Q (reporting date: 2016-09-30), 10-Q (reporting date: 2016-06-30), 10-Q (reporting date: 2016-03-31), 10-K (reporting date: 2015-12-31), 10-Q (reporting date: 2015-09-30), 10-Q (reporting date: 2015-06-30), 10-Q (reporting date: 2015-03-31), 10-K (reporting date: 2014-12-31), 10-Q (reporting date: 2014-09-30), 10-Q (reporting date: 2014-06-30), 10-Q (reporting date: 2014-03-31).

1 Q3 2019 Calculation
Quick ratio = Total quick assets ÷ Current liabilities
= 13,271 ÷ 5,009 = 2.65

2 Click competitor name to see calculations.


Trends in Total Quick Assets
Throughout the analyzed period, total quick assets display notable fluctuations with a general pattern of growth interspersed with declines. Initially, from March 2014 to December 2014, the quick assets increased steadily from 6,183 million to 8,713 million US dollars. However, a slight decline occurred in December 2015, where the value decreased to 7,973 million from the previous quarter. Following this, a significant upward trend is observed, peaking at 13,963 million by December 2017. After that peak, the assets sharply declined in early 2018 to 6,731 million, marking the lowest point since 2014. Subsequent quarters saw recovery with gradual increases, reaching 13,271 million by September 2019.
Current Liabilities Movements
Current liabilities exhibit considerable variability. Starting from 2,425 million US dollars in March 2014, liabilities decreased notably to 1,398 million by September 2014. An increase followed, with liabilities reaching a high of 3,240 million in June 2017. From this point, values fluctuated, including another rise to 5,009 million in September 2019, the highest in the dataset. This suggests episodic increases in obligations, particularly notable during 2017 and again in the latter part of 2019.
Behavior of the Quick Ratio
The quick ratio illustrates the relationship between liquid assets and current liabilities, showing variability aligned with the movements of quick assets and liabilities. A very high peak occurs in September 2014 (5.67), coinciding with a period of relatively low liabilities and increasing assets. Following this, the ratio declines slightly but maintains above 2.5 until late 2015. From 2016 through 2017, the ratio largely stabilizes between approximately 3.2 and 4.7, indicating strong liquidity. However, from early 2018 there is a marked reduction, dropping to as low as 1.22 in June 2018, reflective of decreased quick assets and increased liabilities. The quick ratio rebounds thereafter, climbing towards 2.65 by September 2019, suggesting restoration of liquidity.
Overall Financial Insights
The data indicates periods of strong liquidity and asset accumulation alternating with corrections or reductions in quick assets. Notably, the substantial dip in assets in early 2018 coincides with elevated liabilities, resulting in critical compression of liquidity ratios. Recovery in subsequent periods suggests management responses that restored quick assets relative to current liabilities. The fluctuations in current liabilities point to varying short-term obligations that may be influenced by operational cycles or strategic financing decisions. Overall, the company maintains a quick ratio above 1.0 across all periods, indicating that current liabilities are consistently covered by liquid assets, though the degree of coverage varies markedly.

Cash Ratio

Celgene Corp., cash ratio calculation (quarterly data)

Microsoft Excel
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 Sep 30, 2016 Jun 30, 2016 Mar 31, 2016 Dec 31, 2015 Sep 30, 2015 Jun 30, 2015 Mar 31, 2015 Dec 31, 2014 Sep 30, 2014 Jun 30, 2014 Mar 31, 2014
Selected Financial Data (US$ in millions)
Cash and cash equivalents 9,604 7,214 5,433 4,234 2,480 1,503 2,819 7,013 5,511 6,660 5,273 6,170 5,523 5,064 4,446 4,880 6,017 4,531 4,368 4,122 3,743 3,220 2,397
Debt securities available-for-sale 14 613 664 496 66 79 68 3,219
Equity investments with readily determinable fair values 1,279 1,496 1,594 1,312 1,832 1,828 1,853 1,810
Marketable securities available-for-sale 6,248 3,480 3,588 1,800 1,346 1,340 1,262 1,672 1,489 2,961 2,946 3,425 3,118 2,994 2,714
Total cash assets 10,897 9,323 7,691 6,042 4,378 3,410 4,740 12,042 11,759 10,140 8,861 7,970 6,869 6,404 5,707 6,552 7,506 7,492 7,314 7,547 6,861 6,213 5,110
 
Current liabilities 5,009 3,685 3,955 4,057 3,683 4,502 3,115 2,987 4,049 3,240 2,629 2,959 2,649 1,987 1,834 1,969 3,144 2,960 2,097 2,112 1,398 1,492 2,425
Liquidity Ratio
Cash ratio1 2.18 2.53 1.94 1.49 1.19 0.76 1.52 4.03 2.90 3.13 3.37 2.69 2.59 3.22 3.11 3.33 2.39 2.53 3.49 3.57 4.91 4.17 2.11
Benchmarks
Cash Ratio, Competitors2
AbbVie Inc.
Amgen Inc.
Bristol-Myers Squibb Co.
Danaher Corp.
Eli Lilly & Co.
Gilead Sciences Inc.
Johnson & Johnson
Merck & Co. Inc.
Pfizer Inc.
Regeneron Pharmaceuticals Inc.
Thermo Fisher Scientific Inc.
Vertex Pharmaceuticals Inc.

Based on: 10-Q (reporting date: 2019-09-30), 10-Q (reporting date: 2019-06-30), 10-Q (reporting date: 2019-03-31), 10-K (reporting date: 2018-12-31), 10-Q (reporting date: 2018-09-30), 10-Q (reporting date: 2018-06-30), 10-Q (reporting date: 2018-03-31), 10-K (reporting date: 2017-12-31), 10-Q (reporting date: 2017-09-30), 10-Q (reporting date: 2017-06-30), 10-Q (reporting date: 2017-03-31), 10-K (reporting date: 2016-12-31), 10-Q (reporting date: 2016-09-30), 10-Q (reporting date: 2016-06-30), 10-Q (reporting date: 2016-03-31), 10-K (reporting date: 2015-12-31), 10-Q (reporting date: 2015-09-30), 10-Q (reporting date: 2015-06-30), 10-Q (reporting date: 2015-03-31), 10-K (reporting date: 2014-12-31), 10-Q (reporting date: 2014-09-30), 10-Q (reporting date: 2014-06-30), 10-Q (reporting date: 2014-03-31).

1 Q3 2019 Calculation
Cash ratio = Total cash assets ÷ Current liabilities
= 10,897 ÷ 5,009 = 2.18

2 Click competitor name to see calculations.


The analysis of the quarterly financial data reveals notable fluctuations and trends in the liquidity position and short-term obligations over the observed periods.

Total cash assets
Total cash assets demonstrated a general upward trajectory from the beginning of the observation period through the end of 2017, peaking at approximately $12.0 billion in December 2017. This was followed by a significant decline in the first half of 2018, reaching a low of about $3.4 billion in June 2018. After this trough, a recovery phase ensued, with cash assets increasing again steadily towards the end of the data series, climbing to nearly $10.9 billion by September 2019.
Current liabilities
Current liabilities exhibited variability throughout the periods without a clear directional trend. Starting at approximately $2.4 billion in March 2014, liabilities decreased in mid-2014 but then experienced several cycles of increase and decrease, peaking at $4.0 billion in September 2017. Following this peak, the liabilities fluctuated around levels between $3.1 billion and $5.0 billion, with the highest value occurring in the last quarter under review (September 2019) at just over $5.0 billion.
Cash ratio
The cash ratio, measuring liquidity by comparing cash assets to current liabilities, reflected periods of both strong and weakening liquidity. The ratio was highest in late 2014 and early 2015, reaching levels near 4.9, indicative of considerable liquid reserves relative to short-term obligations. The ratio declined significantly in 2018, falling below 1 in mid-2018, signaling a tightened liquidity position during that time. Subsequent quarters showed a recovery in the cash ratio, improving to values above 2 by mid-2019, suggesting an enhancement in the company's ability to cover current liabilities using cash and cash equivalents.

In summary, the company experienced fluctuations in its liquidity and short-term obligations, with a strong liquidity position until late 2017, a pronounced dip in cash assets and liquidity in 2018, and a recovery period thereafter through to late 2019. These patterns suggest periods of both cautious cash management and potential operational or investment activities affecting cash reserves and liability levels.