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 Short-term (Operating) Activity Ratios
Quarterly Data

Microsoft Excel

Short-term Activity Ratios (Summary)

Celgene Corp., short-term (operating) activity 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
Turnover Ratios
Inventory turnover 1.39 1.33 1.34 1.28 1.05 0.90 0.90 0.85 0.85 0.84 0.87 0.88 0.85 0.88 0.90 0.95 0.99 0.98 1.04 0.98
Receivables turnover 7.15 6.67 6.77 7.39 6.94 6.83 6.81 6.75 6.87 7.03 7.21 6.90 6.77 6.66 6.76 6.45 6.82 6.53 6.71 6.48
Payables turnover 1.49 1.89 1.74 1.40 1.84 1.69 1.51 1.51 1.73 1.64 1.85 1.77 1.83 1.88 1.92 1.74 2.21 1.98 1.98 1.95
Working capital turnover 1.80 1.82 2.24 3.05 3.55 6.00 2.85 1.09 1.16 1.23 1.30 1.41 1.55 1.41 1.47 1.23 1.24 1.20 1.05 1.00
Average No. Days
Average inventory processing period 263 274 273 285 347 407 405 428 430 437 417 415 431 414 407 385 368 373 350 372
Add: Average receivable collection period 51 55 54 49 53 53 54 54 53 52 51 53 54 55 54 57 54 56 54 56
Operating cycle 314 329 327 334 400 460 459 482 483 489 468 468 485 469 461 442 422 429 404 428
Less: Average payables payment period 245 193 210 260 198 215 242 241 211 223 197 206 200 194 190 209 165 184 184 187
Cash conversion cycle 69 136 117 74 202 245 217 241 272 266 271 262 285 275 271 233 257 245 220 241

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).

Short-term activity ratio Description The company
Inventory turnover An activity ratio calculated as cost of goods sold divided by inventory. Celgene Corp. inventory turnover ratio deteriorated from Q1 2019 to Q2 2019 but then improved from Q2 2019 to Q3 2019 exceeding Q1 2019 level.
Receivables turnover An activity ratio equal to revenue divided by receivables. Celgene Corp. receivables turnover ratio deteriorated from Q1 2019 to Q2 2019 but then improved from Q2 2019 to Q3 2019 exceeding Q1 2019 level.
Payables turnover An activity ratio calculated as cost of goods sold divided by payables. Celgene Corp. payables turnover ratio increased from Q1 2019 to Q2 2019 but then decreased significantly from Q2 2019 to Q3 2019.
Working capital turnover An activity ratio calculated as revenue divided by working capital. Celgene Corp. working capital turnover ratio deteriorated from Q1 2019 to Q2 2019 and from Q2 2019 to Q3 2019.

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. Celgene Corp. number of days of inventory outstanding deteriorated from Q1 2019 to Q2 2019 but then improved from Q2 2019 to Q3 2019 exceeding Q1 2019 level.
Average receivable collection period An activity ratio equal to the number of days in the period divided by receivables turnover. Celgene Corp. number of days of receivables outstanding deteriorated from Q1 2019 to Q2 2019 but then improved from Q2 2019 to Q3 2019 exceeding Q1 2019 level.
Operating cycle Equal to average inventory processing period plus average receivables collection period. Celgene Corp. operating cycle deteriorated from Q1 2019 to Q2 2019 but then improved from Q2 2019 to Q3 2019 exceeding Q1 2019 level.
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. Celgene Corp. number of days of payables outstanding decreased from Q1 2019 to Q2 2019 but then increased from Q2 2019 to Q3 2019 exceeding Q1 2019 level.
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. Celgene Corp. cash conversion cycle deteriorated from Q1 2019 to Q2 2019 but then improved from Q2 2019 to Q3 2019 exceeding Q1 2019 level.

Inventory Turnover

Celgene Corp., inventory turnover 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)
Cost of goods sold, excluding amortization of acquired intangible assets 167 151 140 169 157 126 135 119 118 111 113 114 108 111 106 105 110 101 104 103 98 99 86
Inventory 451 464 442 458 510 555 536 541 537 533 509 498 508 490 471 443 421 414 387 393 372 360 348
Short-term Activity Ratio
Inventory turnover1 1.39 1.33 1.34 1.28 1.05 0.90 0.90 0.85 0.85 0.84 0.87 0.88 0.85 0.88 0.90 0.95 0.99 0.98 1.04 0.98
Benchmarks
Inventory Turnover, Competitors2
AbbVie Inc.
Amgen Inc.
Bristol-Myers Squibb Co.
Eli Lilly & Co.
Gilead Sciences Inc.
Johnson & Johnson
Merck & Co. Inc.
Pfizer Inc.
Regeneron Pharmaceuticals Inc.
Thermo Fisher Scientific 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
Inventory turnover = (Cost of goods sold, excluding amortization of acquired intangible assetsQ3 2019 + Cost of goods sold, excluding amortization of acquired intangible assetsQ2 2019 + Cost of goods sold, excluding amortization of acquired intangible assetsQ1 2019 + Cost of goods sold, excluding amortization of acquired intangible assetsQ4 2018) ÷ Inventory
= (167 + 151 + 140 + 169) ÷ 451 = 1.39

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. Celgene Corp. inventory turnover ratio deteriorated from Q1 2019 to Q2 2019 but then improved from Q2 2019 to Q3 2019 exceeding Q1 2019 level.

Receivables Turnover

Celgene Corp., receivables turnover 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)
Net product sales 4,518 4,399 4,024 4,036 3,890 3,808 3,531 3,479 3,283 3,259 2,952 2,977 2,969 2,745 2,495 2,539 2,313 2,254 2,055 2,055 1,957 1,845 1,708
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
Short-term Activity Ratio
Receivables turnover1 7.15 6.67 6.77 7.39 6.94 6.83 6.81 6.75 6.87 7.03 7.21 6.90 6.77 6.66 6.76 6.45 6.82 6.53 6.71 6.48
Benchmarks
Receivables Turnover, Competitors2
AbbVie Inc.
Amgen Inc.
Eli Lilly & Co.
Gilead Sciences Inc.
Johnson & Johnson
Merck & Co. Inc.
Pfizer Inc.
Regeneron Pharmaceuticals Inc.
Thermo Fisher Scientific 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
Receivables turnover = (Net product salesQ3 2019 + Net product salesQ2 2019 + Net product salesQ1 2019 + Net product salesQ4 2018) ÷ Accounts receivable, net of allowances
= (4,518 + 4,399 + 4,024 + 4,036) ÷ 2,374 = 7.15

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. Celgene Corp. receivables turnover ratio deteriorated from Q1 2019 to Q2 2019 but then improved from Q2 2019 to Q3 2019 exceeding Q1 2019 level.

Payables Turnover

Celgene Corp., payables turnover 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)
Cost of goods sold, excluding amortization of acquired intangible assets 167 151 140 169 157 126 135 119 118 111 113 114 108 111 106 105 110 101 104 103 98 99 86
Accounts payable 421 327 340 418 292 294 320 305 263 272 240 247 235 230 220 241 189 205 204 198 197 185 149
Short-term Activity Ratio
Payables turnover1 1.49 1.89 1.74 1.40 1.84 1.69 1.51 1.51 1.73 1.64 1.85 1.77 1.83 1.88 1.92 1.74 2.21 1.98 1.98 1.95
Benchmarks
Payables Turnover, Competitors2
Amgen Inc.
Bristol-Myers Squibb Co.
Eli Lilly & Co.
Gilead Sciences Inc.
Johnson & Johnson
Merck & Co. Inc.
Pfizer Inc.
Regeneron Pharmaceuticals Inc.
Thermo Fisher Scientific 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
Payables turnover = (Cost of goods sold, excluding amortization of acquired intangible assetsQ3 2019 + Cost of goods sold, excluding amortization of acquired intangible assetsQ2 2019 + Cost of goods sold, excluding amortization of acquired intangible assetsQ1 2019 + Cost of goods sold, excluding amortization of acquired intangible assetsQ4 2018) ÷ Accounts payable
= (167 + 151 + 140 + 169) ÷ 421 = 1.49

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. Celgene Corp. payables turnover ratio increased from Q1 2019 to Q2 2019 but then decreased significantly from Q2 2019 to Q3 2019.

Working Capital Turnover

Celgene Corp., working capital turnover 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
Less: 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
Working capital 9,445 8,998 7,026 5,010 4,144 2,351 4,757 11,905 10,734 9,896 8,988 7,908 6,926 7,182 6,552 7,432 7,009 6,924 7,568 7,600 7,439 6,615 4,517
 
Net product sales 4,518 4,399 4,024 4,036 3,890 3,808 3,531 3,479 3,283 3,259 2,952 2,977 2,969 2,745 2,495 2,539 2,313 2,254 2,055 2,055 1,957 1,845 1,708
Short-term Activity Ratio
Working capital turnover1 1.80 1.82 2.24 3.05 3.55 6.00 2.85 1.09 1.16 1.23 1.30 1.41 1.55 1.41 1.47 1.23 1.24 1.20 1.05 1.00
Benchmarks
Working Capital Turnover, Competitors2
AbbVie Inc.
Amgen Inc.
Bristol-Myers Squibb Co.
Eli Lilly & Co.
Gilead Sciences Inc.
Johnson & Johnson
Merck & Co. Inc.
Pfizer Inc.
Regeneron Pharmaceuticals Inc.
Thermo Fisher Scientific 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
Working capital turnover = (Net product salesQ3 2019 + Net product salesQ2 2019 + Net product salesQ1 2019 + Net product salesQ4 2018) ÷ Working capital
= (4,518 + 4,399 + 4,024 + 4,036) ÷ 9,445 = 1.80

2 Click competitor name to see calculations.

Short-term activity ratio Description The company
Working capital turnover An activity ratio calculated as revenue divided by working capital. Celgene Corp. working capital turnover ratio deteriorated from Q1 2019 to Q2 2019 and from Q2 2019 to Q3 2019.

Average Inventory Processing Period

Celgene Corp., average inventory processing period 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
Inventory turnover 1.39 1.33 1.34 1.28 1.05 0.90 0.90 0.85 0.85 0.84 0.87 0.88 0.85 0.88 0.90 0.95 0.99 0.98 1.04 0.98
Short-term Activity Ratio (no. days)
Average inventory processing period1 263 274 273 285 347 407 405 428 430 437 417 415 431 414 407 385 368 373 350 372
Benchmarks (no. days)
Average Inventory Processing Period, Competitors2
AbbVie Inc.
Amgen Inc.
Bristol-Myers Squibb Co.
Eli Lilly & Co.
Gilead Sciences Inc.
Johnson & Johnson
Merck & Co. Inc.
Pfizer Inc.
Regeneron Pharmaceuticals Inc.
Thermo Fisher Scientific 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
Average inventory processing period = 365 ÷ Inventory turnover
= 365 ÷ 1.39 = 263

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. Celgene Corp. number of days of inventory outstanding deteriorated from Q1 2019 to Q2 2019 but then improved from Q2 2019 to Q3 2019 exceeding Q1 2019 level.

Average Receivable Collection Period

Celgene Corp., average receivable collection period 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
Receivables turnover 7.15 6.67 6.77 7.39 6.94 6.83 6.81 6.75 6.87 7.03 7.21 6.90 6.77 6.66 6.76 6.45 6.82 6.53 6.71 6.48
Short-term Activity Ratio (no. days)
Average receivable collection period1 51 55 54 49 53 53 54 54 53 52 51 53 54 55 54 57 54 56 54 56
Benchmarks (no. days)
Average Receivable Collection Period, Competitors2
AbbVie Inc.
Amgen Inc.
Eli Lilly & Co.
Gilead Sciences Inc.
Johnson & Johnson
Merck & Co. Inc.
Pfizer Inc.
Regeneron Pharmaceuticals Inc.
Thermo Fisher Scientific 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
Average receivable collection period = 365 ÷ Receivables turnover
= 365 ÷ 7.15 = 51

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. Celgene Corp. number of days of receivables outstanding deteriorated from Q1 2019 to Q2 2019 but then improved from Q2 2019 to Q3 2019 exceeding Q1 2019 level.

Operating Cycle

Celgene Corp., operating cycle calculation (quarterly data)

No. days

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
Average inventory processing period 263 274 273 285 347 407 405 428 430 437 417 415 431 414 407 385 368 373 350 372
Average receivable collection period 51 55 54 49 53 53 54 54 53 52 51 53 54 55 54 57 54 56 54 56
Short-term Activity Ratio
Operating cycle1 314 329 327 334 400 460 459 482 483 489 468 468 485 469 461 442 422 429 404 428
Benchmarks
Operating Cycle, Competitors2
AbbVie Inc.
Amgen Inc.
Eli Lilly & Co.
Gilead Sciences Inc.
Johnson & Johnson
Merck & Co. Inc.
Pfizer Inc.
Regeneron Pharmaceuticals Inc.
Thermo Fisher Scientific 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
Operating cycle = Average inventory processing period + Average receivable collection period
= 263 + 51 = 314

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. Celgene Corp. operating cycle deteriorated from Q1 2019 to Q2 2019 but then improved from Q2 2019 to Q3 2019 exceeding Q1 2019 level.

Average Payables Payment Period

Celgene Corp., average payables payment period 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
Payables turnover 1.49 1.89 1.74 1.40 1.84 1.69 1.51 1.51 1.73 1.64 1.85 1.77 1.83 1.88 1.92 1.74 2.21 1.98 1.98 1.95
Short-term Activity Ratio (no. days)
Average payables payment period1 245 193 210 260 198 215 242 241 211 223 197 206 200 194 190 209 165 184 184 187
Benchmarks (no. days)
Average Payables Payment Period, Competitors2
Amgen Inc.
Bristol-Myers Squibb Co.
Eli Lilly & Co.
Gilead Sciences Inc.
Johnson & Johnson
Merck & Co. Inc.
Pfizer Inc.
Regeneron Pharmaceuticals Inc.
Thermo Fisher Scientific 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
Average payables payment period = 365 ÷ Payables turnover
= 365 ÷ 1.49 = 245

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. Celgene Corp. number of days of payables outstanding decreased from Q1 2019 to Q2 2019 but then increased from Q2 2019 to Q3 2019 exceeding Q1 2019 level.

Cash Conversion Cycle

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

No. days

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
Average inventory processing period 263 274 273 285 347 407 405 428 430 437 417 415 431 414 407 385 368 373 350 372
Average receivable collection period 51 55 54 49 53 53 54 54 53 52 51 53 54 55 54 57 54 56 54 56
Average payables payment period 245 193 210 260 198 215 242 241 211 223 197 206 200 194 190 209 165 184 184 187
Short-term Activity Ratio
Cash conversion cycle1 69 136 117 74 202 245 217 241 272 266 271 262 285 275 271 233 257 245 220 241
Benchmarks
Cash Conversion Cycle, Competitors2
Amgen Inc.
Eli Lilly & Co.
Gilead Sciences Inc.
Johnson & Johnson
Merck & Co. Inc.
Pfizer Inc.
Regeneron Pharmaceuticals Inc.
Thermo Fisher Scientific 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 conversion cycle = Average inventory processing period + Average receivable collection period – Average payables payment period
= 263 + 51245 = 69

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. Celgene Corp. cash conversion cycle deteriorated from Q1 2019 to Q2 2019 but then improved from Q2 2019 to Q3 2019 exceeding Q1 2019 level.