Sign in

Paying users zone. Data is covered by hidden .

Get to Celgene Corp. for $13.99, or
get to whole website for at least 3 months from $49.99.

Microsoft Excel

LibreOffice Calc

Celgene Corp. (CELG)

Profitability Analysis
Quarterly Data

Difficulty: Beginner

Annual Data

Quarterly Data

Profitability ratios measure the company's ability to generate profitable sales from its resources (assets).

Ratios (Summary)
Gross Profit Margin
Operating Profit Margin
Net Profit Margin
Return on Equity (ROE)
Return on Assets (ROA)

Ratios (Summary)

Celgene Corp., profitability ratios (quarterly data)

Microsoft Excel

LibreOffice Calc

		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	Dec 31, 2013	Sep 30, 2013	Jun 30, 2013	Mar 31, 2013
	Return on Sales
	Gross profit margin
	Operating profit margin
	Net profit margin
	Return on Investment
	Return on equity (ROE)
	Return on assets (ROA)

Source: Based on data from Celgene Corp. Quarterly and Annual Reports

Ratio	Description	The company
Gross profit margin	Gross profit margin indicates the percentage of revenue available to cover operating and other expenditures.	Celgene Corp.'s gross profit margin deteriorated from Q4 2017 to Q1 2018 but then improved from Q1 2018 to Q2 2018 exceeding Q4 2017 level.
Operating profit margin	A profitability ratio calculated as operating income divided by revenue.	Celgene Corp.'s operating profit margin deteriorated from Q4 2017 to Q1 2018 but then slightly improved from Q1 2018 to Q2 2018.
Net profit margin	An indicator of profitability, calculated as net income divided by revenue.	Celgene Corp.'s net profit margin deteriorated from Q4 2017 to Q1 2018 and from Q1 2018 to Q2 2018.
ROE	A profitability ratio calculated as net income divided by shareholders' equity.	Celgene Corp.'s ROE improved from Q4 2017 to Q1 2018 and from Q1 2018 to Q2 2018.
ROA	A profitability ratio calculated as net income divided by total assets.	Celgene Corp.'s ROA deteriorated from Q4 2017 to Q1 2018 but then slightly improved from Q1 2018 to Q2 2018.

Gross Profit Margin

Celgene Corp., gross profit margin calculation (quarterly data)

Microsoft Excel

LibreOffice Calc

		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	Dec 31, 2013	Sep 30, 2013	Jun 30, 2013	Mar 31, 2013
	Selected Financial Data (USD $ in millions)
	Gross profit
	Net product sales
	Ratio
	Gross profit margin¹

Source: Based on data from Celgene Corp. Quarterly and Annual Reports

Q2 2018 Calculations

¹ Gross profit margin = 100 × (Gross profit_{Q2 2018} + Gross profit_{Q1 2018} + Gross profit_{Q4 2017} + Gross profit_{Q3 2017}) ÷ (Net product sales_{Q2 2018} + Net product sales_{Q1 2018} + Net product sales_{Q4 2017} + Net product sales_{Q3 2017})
= 100 × ( hidden + hidden + hidden + hidden ) ÷ ( hidden + hidden + hidden + hidden ) = hidden

Ratio	Description	The company
Gross profit margin	Gross profit margin indicates the percentage of revenue available to cover operating and other expenditures.	Celgene Corp.'s gross profit margin deteriorated from Q4 2017 to Q1 2018 but then improved from Q1 2018 to Q2 2018 exceeding Q4 2017 level.

Operating Profit Margin

Celgene Corp., operating profit margin calculation (quarterly data)

Microsoft Excel

LibreOffice Calc

		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	Dec 31, 2013	Sep 30, 2013	Jun 30, 2013	Mar 31, 2013
	Selected Financial Data (USD $ in millions)
	Operating income
	Net product sales
	Ratio
	Operating profit margin¹

Source: Based on data from Celgene Corp. Quarterly and Annual Reports

Q2 2018 Calculations

¹ Operating profit margin = 100 × (Operating income_{Q2 2018} + Operating income_{Q1 2018} + Operating income_{Q4 2017} + Operating income_{Q3 2017}) ÷ (Net product sales_{Q2 2018} + Net product sales_{Q1 2018} + Net product sales_{Q4 2017} + Net product sales_{Q3 2017})
= 100 × ( hidden + hidden + hidden + hidden ) ÷ ( hidden + hidden + hidden + hidden ) = hidden

Ratio	Description	The company
Operating profit margin	A profitability ratio calculated as operating income divided by revenue.	Celgene Corp.'s operating profit margin deteriorated from Q4 2017 to Q1 2018 but then slightly improved from Q1 2018 to Q2 2018.

Net Profit Margin

Celgene Corp., net profit margin calculation (quarterly data)

Microsoft Excel

LibreOffice Calc

		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	Dec 31, 2013	Sep 30, 2013	Jun 30, 2013	Mar 31, 2013
	Selected Financial Data (USD $ in millions)
	Net income (loss)
	Net product sales
	Ratio
	Net profit margin¹

Source: Based on data from Celgene Corp. Quarterly and Annual Reports

Q2 2018 Calculations

¹ Net profit margin = 100 × (Net income (loss)_{Q2 2018} + Net income (loss)_{Q1 2018} + Net income (loss)_{Q4 2017} + Net income (loss)_{Q3 2017}) ÷ (Net product sales_{Q2 2018} + Net product sales_{Q1 2018} + Net product sales_{Q4 2017} + Net product sales_{Q3 2017})
= 100 × ( hidden + hidden + hidden + hidden ) ÷ ( hidden + hidden + hidden + hidden ) = hidden

Ratio	Description	The company
Net profit margin	An indicator of profitability, calculated as net income divided by revenue.	Celgene Corp.'s net profit margin deteriorated from Q4 2017 to Q1 2018 and from Q1 2018 to Q2 2018.

Return on Equity (ROE)

Celgene Corp., ROE calculation (quarterly data)

Microsoft Excel

LibreOffice Calc

		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	Dec 31, 2013	Sep 30, 2013	Jun 30, 2013	Mar 31, 2013
	Selected Financial Data (USD $ in millions)
	Net income (loss)
	Stockholders' equity
	Ratio
	ROE¹

Source: Based on data from Celgene Corp. Quarterly and Annual Reports

Q2 2018 Calculations

¹ ROE = 100 × (Net income (loss)_{Q2 2018} + Net income (loss)_{Q1 2018} + Net income (loss)_{Q4 2017} + Net income (loss)_{Q3 2017}) ÷ Stockholders' equity
= 100 × ( hidden + hidden + hidden + hidden ) ÷ hidden = hidden

Ratio	Description	The company
ROE	A profitability ratio calculated as net income divided by shareholders' equity.	Celgene Corp.'s ROE improved from Q4 2017 to Q1 2018 and from Q1 2018 to Q2 2018.

Return on Assets (ROA)

Celgene Corp., ROA calculation (quarterly data)

Microsoft Excel

LibreOffice Calc

		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	Dec 31, 2013	Sep 30, 2013	Jun 30, 2013	Mar 31, 2013
	Selected Financial Data (USD $ in millions)
	Net income (loss)
	Total assets
	Ratio
	ROA¹

Source: Based on data from Celgene Corp. Quarterly and Annual Reports

Q2 2018 Calculations

¹ ROA = 100 × (Net income (loss)_{Q2 2018} + Net income (loss)_{Q1 2018} + Net income (loss)_{Q4 2017} + Net income (loss)_{Q3 2017}) ÷ Total assets
= 100 × ( hidden + hidden + hidden + hidden ) ÷ hidden = hidden

Ratio	Description	The company
ROA	A profitability ratio calculated as net income divided by total assets.	Celgene Corp.'s ROA deteriorated from Q4 2017 to Q1 2018 but then slightly improved from Q1 2018 to Q2 2018.

	Celgene Corp.	Other companies (not purchased previously)
Financial Statements
Common-Size Financial Statements
Ratios
Relative Valuation
Discounted Cash Flow (DCF) Valuation
Economic Value Added (EVA)
Long-term Trends
Analysis
Financial Reporting Quality

Price of access to Celgene Corp.^*

1 month

$13.99

* You can pay in USD, CHF, GBP or EUR.

Visa

Mastercard

Maestro

American Express

Discover

JCB

PayPal

	All companies
Financial Statements
Common-Size Financial Statements
Ratios
Relative Valuation
Discounted Cash Flow (DCF) Valuation
Economic Value Added (EVA)
Long-term Trends
Analysis
Financial Reporting Quality

Prices of access whole website^*

3 months

$49.99

6 months

12% off

~~99.98~~

$87.49

9 months

25% off

~~149.97~~

$112.49

12 months

37% off

~~199.96~~

$124.99

* You can pay in USD, CHF, GBP or EUR.

Visa

Mastercard

Maestro

American Express

Discover

JCB

PayPal