Celgene Corp. (CELG)

Long-term Debt and Solvency Analysis
Quarterly Data

Difficulty: Beginner

Annual Data

Quarterly Data

Solvency ratios also known as long-term debt ratios measure a company's ability to meet long-term obligations.

Ratios (Summary)
Debt to Equity
Debt to Capital
Interest Coverage

Ratios (Summary)

Celgene Corp., debt and solvency ratios (quarterly data)

		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
	Debt to equity
	Debt to capital
	Interest coverage

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

Ratio	Description	The company
Debt-to-equity ratio	A solvency ratio calculated as total debt divided by total shareholders' equity.	Celgene Corp.'s debt-to-equity ratio deteriorated from Q4 2017 to Q1 2018 and from Q1 2018 to Q2 2018.
Debt-to-capital ratio	A solvency ratio calculated as total debt divided by total debt plus shareholders' equity.	Celgene Corp.'s debt-to-capital ratio deteriorated from Q4 2017 to Q1 2018 and from Q1 2018 to Q2 2018.
Interest coverage ratio	A solvency ratio calculated as EBIT divided by interest payments.	Celgene Corp.'s interest coverage ratio deteriorated from Q4 2017 to Q1 2018 and from Q1 2018 to Q2 2018.

Debt to Equity

Celgene Corp., debt to equity calculation (quarterly data)

		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)
	Short-term borrowings and current portion of long-term debt
	Long-term debt, net of discount, excluding current portion
	Total debt
	Stockholders' equity
	Ratio
	Debt to equity¹

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

Q2 2018 Calculations

¹ Debt to equity = Total debt ÷ Stockholders' equity
= hidden ÷ hidden = hidden

Ratio	Description	The company
Debt-to-equity ratio	A solvency ratio calculated as total debt divided by total shareholders' equity.	Celgene Corp.'s debt-to-equity ratio deteriorated from Q4 2017 to Q1 2018 and from Q1 2018 to Q2 2018.

Debt to Capital

Celgene Corp., debt to capital calculation (quarterly data)

		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)
	Short-term borrowings and current portion of long-term debt
	Long-term debt, net of discount, excluding current portion
	Total debt
	Stockholders' equity
	Total capital
	Ratio
	Debt to capital¹

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

Q2 2018 Calculations

¹ Debt to capital = Total debt ÷ Total capital
= hidden ÷ hidden = hidden

Ratio	Description	The company
Debt-to-capital ratio	A solvency ratio calculated as total debt divided by total debt plus shareholders' equity.	Celgene Corp.'s debt-to-capital ratio deteriorated from Q4 2017 to Q1 2018 and from Q1 2018 to Q2 2018.

Interest Coverage

Celgene Corp., interest coverage calculation (quarterly data)

		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)
	Add: Income tax expense
	Add: Interest expense
	Earnings before interest and tax (EBIT)
	Ratio
	Interest coverage¹

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

Q2 2018 Calculations

¹ Interest coverage = (EBIT_{Q2 2018} + EBIT_{Q1 2018} + EBIT_{Q4 2017} + EBIT_{Q3 2017}) ÷ (Interest expense_{Q2 2018} + Interest expense_{Q1 2018} + Interest expense_{Q4 2017} + Interest expense_{Q3 2017})
= ( hidden + hidden + hidden + hidden ) ÷ ( hidden + hidden + hidden + hidden ) = hidden

Ratio	Description	The company
Interest coverage ratio	A solvency ratio calculated as EBIT divided by interest payments.	Celgene Corp.'s interest coverage ratio deteriorated from Q4 2017 to Q1 2018 and 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

	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

Celgene Corp. (CELG)

Long-term Debt and Solvency AnalysisQuarterly Data

Ratios (Summary)

Debt to Equity

Debt to Capital

Interest Coverage

Long-term Debt and Solvency Analysis
Quarterly Data