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 Profitability Ratios
Quarterly Data

Microsoft Excel

Profitability Ratios (Summary)

Celgene Corp., profitability 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
Return on Sales
Gross profit margin 96.31% 96.23% 96.24% 96.15% 96.35% 96.47% 96.44% 96.45% 96.35% 96.34% 96.18% 96.08% 96.00% 95.72% 95.60% 95.41% 95.18% 95.12% 94.90% 94.90%
Operating profit margin 46.49% 44.70% 42.41% 34.01% 31.15% 28.27% 28.13% 36.28% 35.59% 30.97% 28.16% 28.31% 29.19% 27.80% 24.97% 24.61% 24.27% 32.12% 38.12% 33.30%
Net profit margin 34.64% 32.24% 30.11% 26.51% 19.66% 19.84% 21.06% 22.66% 27.66% 21.66% 18.30% 17.87% 19.83% 19.08% 17.54% 17.49% 19.07% 26.41% 30.83% 26.44%
Return on Investment
Return on equity (ROE) 48.65% 52.44% 58.11% 65.67% 59.51% 81.57% 55.18% 42.48% 35.02% 31.18% 27.87% 30.29% 37.72% 34.71% 33.18% 27.07% 30.79% 34.76% 36.06% 30.65%
Return on assets (ROA) 14.22% 13.45% 12.61% 11.40% 8.45% 8.37% 8.26% 9.75% 10.87% 8.69% 7.39% 7.12% 7.97% 7.25% 6.49% 5.92% 6.05% 12.38% 13.95% 11.53%

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

Profitability ratio Description The company
Gross profit margin Gross profit margin indicates the percentage of revenue available to cover operating and other expenditures. Celgene Corp. gross profit margin ratio deteriorated from Q1 2019 to Q2 2019 but then improved from Q2 2019 to Q3 2019 exceeding Q1 2019 level.
Operating profit margin A profitability ratio calculated as operating income divided by revenue. Celgene Corp. operating profit margin ratio improved from Q1 2019 to Q2 2019 and from Q2 2019 to Q3 2019.
Net profit margin An indicator of profitability, calculated as net income divided by revenue. Celgene Corp. net profit margin ratio improved from Q1 2019 to Q2 2019 and from Q2 2019 to Q3 2019.

Profitability ratio Description The company
ROE A profitability ratio calculated as net income divided by shareholders’ equity. Celgene Corp. ROE deteriorated from Q1 2019 to Q2 2019 and from Q2 2019 to Q3 2019.
ROA A profitability ratio calculated as net income divided by total assets. Celgene Corp. ROA improved from Q1 2019 to Q2 2019 and from Q2 2019 to Q3 2019.

Gross Profit Margin

Celgene Corp., gross profit margin 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)
Gross profit 4,351 4,248 3,884 3,867 3,733 3,682 3,396 3,360 3,165 3,148 2,839 2,863 2,861 2,634 2,389 2,434 2,203 2,153 1,951 1,952 1,859 1,746 1,621
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
Profitability Ratio
Gross profit margin1 96.31% 96.23% 96.24% 96.15% 96.35% 96.47% 96.44% 96.45% 96.35% 96.34% 96.18% 96.08% 96.00% 95.72% 95.60% 95.41% 95.18% 95.12% 94.90% 94.90%
Benchmarks
Gross Profit Margin, Competitors2
AbbVie Inc.
Amgen Inc.
Bristol-Myers Squibb Co.
Danaher Corp.
Eli Lilly & Co.
Gilead Sciences Inc.
Johnson & Johnson
Merck & Co. Inc.
Moderna 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
Gross profit margin = 100 × (Gross profitQ3 2019 + Gross profitQ2 2019 + Gross profitQ1 2019 + Gross profitQ4 2018) ÷ (Net product salesQ3 2019 + Net product salesQ2 2019 + Net product salesQ1 2019 + Net product salesQ4 2018)
= 100 × (4,351 + 4,248 + 3,884 + 3,867) ÷ (4,518 + 4,399 + 4,024 + 4,036) = 96.31%

2 Click competitor name to see calculations.

Profitability ratio Description The company
Gross profit margin Gross profit margin indicates the percentage of revenue available to cover operating and other expenditures. Celgene Corp. gross profit margin ratio deteriorated from Q1 2019 to Q2 2019 but then improved from Q2 2019 to Q3 2019 exceeding Q1 2019 level.

Operating Profit Margin

Celgene Corp., operating profit margin 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)
Operating income 2,264 2,111 1,710 1,807 1,680 1,486 218 1,198 1,085 1,311 1,113 930 412 824 1,002 900 80 416 859 752 647 759 362
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
Profitability Ratio
Operating profit margin1 46.49% 44.70% 42.41% 34.01% 31.15% 28.27% 28.13% 36.28% 35.59% 30.97% 28.16% 28.31% 29.19% 27.80% 24.97% 24.61% 24.27% 32.12% 38.12% 33.30%
Benchmarks
Operating Profit Margin, Competitors2
AbbVie Inc.
Amgen Inc.
Bristol-Myers Squibb Co.
Danaher Corp.
Eli Lilly & Co.
Gilead Sciences Inc.
Johnson & Johnson
Merck & Co. Inc.
Moderna 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 profit margin = 100 × (Operating incomeQ3 2019 + Operating incomeQ2 2019 + Operating incomeQ1 2019 + Operating incomeQ4 2018) ÷ (Net product salesQ3 2019 + Net product salesQ2 2019 + Net product salesQ1 2019 + Net product salesQ4 2018)
= 100 × (2,264 + 2,111 + 1,710 + 1,807) ÷ (4,518 + 4,399 + 4,024 + 4,036) = 46.49%

2 Click competitor name to see calculations.

Profitability ratio Description The company
Operating profit margin A profitability ratio calculated as operating income divided by revenue. Celgene Corp. operating profit margin ratio improved from Q1 2019 to Q2 2019 and from Q2 2019 to Q3 2019.

Net Profit Margin

Celgene Corp., net profit margin 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 income (loss) 1,691 1,571 1,545 1,073 1,082 1,045 846 (81) 988 1,101 932 429 171 598 801 561 (34) 356 719 614 509 598 280
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
Profitability Ratio
Net profit margin1 34.64% 32.24% 30.11% 26.51% 19.66% 19.84% 21.06% 22.66% 27.66% 21.66% 18.30% 17.87% 19.83% 19.08% 17.54% 17.49% 19.07% 26.41% 30.83% 26.44%
Benchmarks
Net Profit Margin, Competitors2
AbbVie Inc.
Amgen Inc.
Bristol-Myers Squibb Co.
Danaher Corp.
Eli Lilly & Co.
Gilead Sciences Inc.
Johnson & Johnson
Merck & Co. Inc.
Moderna 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
Net profit margin = 100 × (Net income (loss)Q3 2019 + Net income (loss)Q2 2019 + Net income (loss)Q1 2019 + Net income (loss)Q4 2018) ÷ (Net product salesQ3 2019 + Net product salesQ2 2019 + Net product salesQ1 2019 + Net product salesQ4 2018)
= 100 × (1,691 + 1,571 + 1,545 + 1,073) ÷ (4,518 + 4,399 + 4,024 + 4,036) = 34.64%

2 Click competitor name to see calculations.

Profitability ratio Description The company
Net profit margin An indicator of profitability, calculated as net income divided by revenue. Celgene Corp. net profit margin ratio improved from Q1 2019 to Q2 2019 and from Q2 2019 to Q3 2019.

Return on Equity (ROE)

Celgene Corp., ROE 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 income (loss) 1,691 1,571 1,545 1,073 1,082 1,045 846 (81) 988 1,101 932 429 171 598 801 561 (34) 356 719 614 509 598 280
Stockholders’ equity 12,087 10,051 8,165 6,161 4,860 3,430 5,172 6,921 9,850 8,445 7,644 6,599 5,650 5,549 5,075 5,919 5,376 6,322 6,765 6,525 5,768 4,851 4,485
Profitability Ratio
ROE1 48.65% 52.44% 58.11% 65.67% 59.51% 81.57% 55.18% 42.48% 35.02% 31.18% 27.87% 30.29% 37.72% 34.71% 33.18% 27.07% 30.79% 34.76% 36.06% 30.65%
Benchmarks
ROE, Competitors2
AbbVie Inc.
Amgen Inc.
Bristol-Myers Squibb Co.
Danaher Corp.
Eli Lilly & Co.
Gilead Sciences Inc.
Johnson & Johnson
Merck & Co. Inc.
Moderna 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
ROE = 100 × (Net income (loss)Q3 2019 + Net income (loss)Q2 2019 + Net income (loss)Q1 2019 + Net income (loss)Q4 2018) ÷ Stockholders’ equity
= 100 × (1,691 + 1,571 + 1,545 + 1,073) ÷ 12,087 = 48.65%

2 Click competitor name to see calculations.

Profitability ratio Description The company
ROE A profitability ratio calculated as net income divided by shareholders’ equity. Celgene Corp. ROE deteriorated from Q1 2019 to Q2 2019 and from Q2 2019 to Q3 2019.

Return on Assets (ROA)

Celgene Corp., ROA 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 income (loss) 1,691 1,571 1,545 1,073 1,082 1,045 846 (81) 988 1,101 932 429 171 598 801 561 (34) 356 719 614 509 598 280
Total assets 41,363 39,183 37,639 35,480 34,215 33,444 34,556 30,141 31,736 30,306 28,820 28,086 26,754 26,562 25,964 27,053 27,369 17,746 17,481 17,340 16,403 15,602 12,705
Profitability Ratio
ROA1 14.22% 13.45% 12.61% 11.40% 8.45% 8.37% 8.26% 9.75% 10.87% 8.69% 7.39% 7.12% 7.97% 7.25% 6.49% 5.92% 6.05% 12.38% 13.95% 11.53%
Benchmarks
ROA, Competitors2
AbbVie Inc.
Amgen Inc.
Bristol-Myers Squibb Co.
Danaher Corp.
Eli Lilly & Co.
Gilead Sciences Inc.
Johnson & Johnson
Merck & Co. Inc.
Moderna 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
ROA = 100 × (Net income (loss)Q3 2019 + Net income (loss)Q2 2019 + Net income (loss)Q1 2019 + Net income (loss)Q4 2018) ÷ Total assets
= 100 × (1,691 + 1,571 + 1,545 + 1,073) ÷ 41,363 = 14.22%

2 Click competitor name to see calculations.

Profitability ratio Description The company
ROA A profitability ratio calculated as net income divided by total assets. Celgene Corp. ROA improved from Q1 2019 to Q2 2019 and from Q2 2019 to Q3 2019.