Stock Analysis on Net
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.

DuPont Analysis: Disaggregation of ROE, ROA, and Net Profit Margin

Microsoft Excel

Two-Component Disaggregation of ROE

Celgene Corp., decomposition of ROE

Microsoft Excel
ROE = ROA × Financial Leverage
Dec 31, 2018 65.67% = 11.40% × 5.76
Dec 31, 2017 42.48% = 9.75% × 4.36
Dec 31, 2016 30.29% = 7.12% × 4.26
Dec 31, 2015 27.07% = 5.92% × 4.57
Dec 31, 2014 30.65% = 11.53% × 2.66

Based on: 10-K (reporting date: 2018-12-31), 10-K (reporting date: 2017-12-31), 10-K (reporting date: 2016-12-31), 10-K (reporting date: 2015-12-31), 10-K (reporting date: 2014-12-31).


The financial performance between 2014 and 2018 demonstrates a substantial expansion in Return on Equity (ROE), which increased from 30.65% to 65.67%. This growth is the result of a dual-driver effect involving a recovery in asset productivity and a strategic increase in financial leverage.

Return on Assets (ROA)
Asset productivity experienced a significant decline in 2015, falling from 11.53% to 5.92%. Following this trough, a consistent recovery trend was observed, with ROA climbing steadily to reach 11.40% by December 31, 2018. This indicates that the operational efficiency in generating earnings from assets returned to 2014 levels by the end of the analyzed period.
Financial Leverage
The leverage ratio trended upward over the five-year period, rising from 2.66 in 2014 to 5.76 in 2018. A notable increase occurred between 2014 and 2015, where the ratio jumped to 4.57, followed by a period of relative stability before a final acceleration in 2018. This pattern reflects an increasing reliance on debt to finance assets, thereby amplifying the potential returns to shareholders.
Return on Equity (ROE) Dynamics
The trajectory of ROE was initially constrained in 2015, as the sharp decrease in ROA offset the benefits of increased leverage, leading to a dip to 27.07%. However, from 2016 through 2018, the simultaneous improvement in asset returns and the expansion of the leverage ratio created a compounding effect. The peak ROE of 65.67% in 2018 was driven more aggressively by the surge in financial leverage than by the recovery of ROA, which merely returned to its baseline productivity.

AI Ask an analyst for more

Hi, I’m an AI-powered financial analyst at Stock Analysis on Net.

How can I help you?


Three-Component Disaggregation of ROE

Celgene Corp., decomposition of ROE

Microsoft Excel
ROE = Net Profit Margin × Asset Turnover × Financial Leverage
Dec 31, 2018 65.67% = 26.51% × 0.43 × 5.76
Dec 31, 2017 42.48% = 22.66% × 0.43 × 4.36
Dec 31, 2016 30.29% = 17.87% × 0.40 × 4.26
Dec 31, 2015 27.07% = 17.49% × 0.34 × 4.57
Dec 31, 2014 30.65% = 26.44% × 0.44 × 2.66

Based on: 10-K (reporting date: 2018-12-31), 10-K (reporting date: 2017-12-31), 10-K (reporting date: 2016-12-31), 10-K (reporting date: 2015-12-31), 10-K (reporting date: 2014-12-31).


The Return on Equity (ROE) exhibited a significant upward trajectory over the five-year period, increasing from 30.65% in 2014 to 65.67% by 2018. While a slight contraction occurred in 2015, the subsequent growth was aggressive, particularly between 2016 and 2018, indicating a substantial increase in the returns generated for shareholders.

Net Profit Margin
Profitability experienced a notable dip between 2014 and 2015, falling from 26.44% to 17.49%. This margin remained relatively stagnant in 2016 before entering a recovery phase. By 2018, the net profit margin returned to its baseline, reaching 26.51%, suggesting an improvement in cost management or pricing power toward the end of the period.
Asset Turnover
Asset utilization showed a decline in 2015, dropping to 0.34, but recovered steadily to 0.43 by 2017 and remained constant through 2018. The stability of this ratio in the final two years indicates that the growth in ROE was not primarily driven by increased operational efficiency or higher sales volume relative to the asset base.
Financial Leverage
Financial leverage emerged as a primary driver of ROE growth. There was a sharp increase in the leverage ratio from 2.66 in 2014 to 4.57 in 2015, which remained relatively stable until 2018, when it spiked to 5.76. This suggests a strategic increase in the use of debt or a reduction in equity, which amplified the returns on equity.

The overall analysis indicates that the expansion of ROE was achieved through a combination of recovering profitability and increased financial gearing. The most substantial surge in ROE between 2017 and 2018 coincides with the simultaneous increase in both net profit margins and financial leverage, while asset turnover remained neutral.

AI Ask an analyst for more

Hi, I’m an AI-powered financial analyst at Stock Analysis on Net.

How can I help you?


Five-Component Disaggregation of ROE

Celgene Corp., decomposition of ROE

Microsoft Excel
ROE = Tax Burden × Interest Burden × EBIT Margin × Asset Turnover × Financial Leverage
Dec 31, 2018 65.67% = 0.84 × 0.87 × 36.51% × 0.43 × 5.76
Dec 31, 2017 42.48% = 0.68 × 0.89 × 37.28% × 0.43 × 4.36
Dec 31, 2016 30.29% = 0.84 × 0.83 × 25.68% × 0.40 × 4.26
Dec 31, 2015 27.07% = 0.79 × 0.87 × 25.48% × 0.34 × 4.57
Dec 31, 2014 30.65% = 0.86 × 0.93 × 33.10% × 0.44 × 2.66

Based on: 10-K (reporting date: 2018-12-31), 10-K (reporting date: 2017-12-31), 10-K (reporting date: 2016-12-31), 10-K (reporting date: 2015-12-31), 10-K (reporting date: 2014-12-31).


Return on Equity (ROE) exhibited a strong upward trajectory over the observed five-year period, increasing from 30.65% in 2014 to a peak of 65.67% in 2018. The most substantial growth occurred between 2016 and 2018, reflecting a significant shift in the company's financial structure and operational profitability.

Operating Profitability
The EBIT margin demonstrated volatility, declining from 33.10% in 2014 to a low of 25.48% in 2015, before recovering to 37.28% in 2017 and remaining high at 36.51% in 2018. This recovery indicates improved operational efficiency and enhanced profitability per unit of revenue in the latter half of the period.
Asset Utilization
Asset turnover remained relatively low and stagnant, fluctuating between 0.34 and 0.44. The absence of a sustained upward trend suggests that the growth in ROE was not driven by increased efficiency in utilizing assets to generate revenue.
Financial Leverage
A marked increase in financial leverage is observed, rising from 2.66 in 2014 to 5.76 in 2018. This indicates a strategic shift toward a more aggressive capital structure, utilizing higher leverage to amplify returns to shareholders, which served as a primary catalyst for the expansion of ROE.
Tax and Interest Burdens
The interest burden remained relatively stable, fluctuating within a narrow range between 0.83 and 0.93. The tax burden displayed more variance, reaching a low of 0.68 in 2017 before returning to 0.84 in 2018, reflecting fluctuations in the effective tax rate that periodically influenced net income.

The comprehensive analysis indicates that the dramatic rise in ROE was predominantly fueled by the simultaneous expansion of operating margins and a significant increase in financial leverage, while asset productivity remained a neutral factor.

AI Ask an analyst for more

Hi, I’m an AI-powered financial analyst at Stock Analysis on Net.

How can I help you?


Two-Component Disaggregation of ROA

Celgene Corp., decomposition of ROA

Microsoft Excel
ROA = Net Profit Margin × Asset Turnover
Dec 31, 2018 11.40% = 26.51% × 0.43
Dec 31, 2017 9.75% = 22.66% × 0.43
Dec 31, 2016 7.12% = 17.87% × 0.40
Dec 31, 2015 5.92% = 17.49% × 0.34
Dec 31, 2014 11.53% = 26.44% × 0.44

Based on: 10-K (reporting date: 2018-12-31), 10-K (reporting date: 2017-12-31), 10-K (reporting date: 2016-12-31), 10-K (reporting date: 2015-12-31), 10-K (reporting date: 2014-12-31).


Return on Assets (ROA) exhibited a volatile trajectory between 2014 and 2018, characterized by a sharp contraction in 2015 followed by a consistent recovery. The ROA declined from 11.53% in 2014 to a period low of 5.92% in 2015, before trending upward to reach 11.40% by the end of 2018, nearly returning to its initial baseline.

Net Profit Margin
A significant contraction in profitability is observed in 2015, with the margin falling from 26.44% to 17.49%. Following this trough, a steady recovery trend occurred over the subsequent three years, with margins expanding to 22.66% in 2017 and culminating at 26.51% in 2018. This indicates a full restoration of profit margins to 2014 levels.
Asset Turnover
Asset utilization efficiency mirrored the profitability trend, decreasing from a ratio of 0.44 in 2014 to 0.34 in 2015. Efficiency recovered incrementally to 0.40 in 2016 and stabilized at 0.43 in 2017 and 2018. Although the trend was positive after 2015, asset turnover remained slightly below the 2014 peak.
ROA Disaggregation Insights
The sharp decline in ROA during 2015 was the result of a simultaneous deterioration in both profit margins and asset turnover. The subsequent recovery of the ROA was primarily driven by the robust rebound in Net Profit Margin, which provided a stronger upward impulse than the more modest recovery in Asset Turnover. By 2018, the synergy between restored profitability and stabilized asset efficiency brought the overall return on assets back to its near-original state.

AI Ask an analyst for more

Hi, I’m an AI-powered financial analyst at Stock Analysis on Net.

How can I help you?


Four-Component Disaggregation of ROA

Celgene Corp., decomposition of ROA

Microsoft Excel
ROA = Tax Burden × Interest Burden × EBIT Margin × Asset Turnover
Dec 31, 2018 11.40% = 0.84 × 0.87 × 36.51% × 0.43
Dec 31, 2017 9.75% = 0.68 × 0.89 × 37.28% × 0.43
Dec 31, 2016 7.12% = 0.84 × 0.83 × 25.68% × 0.40
Dec 31, 2015 5.92% = 0.79 × 0.87 × 25.48% × 0.34
Dec 31, 2014 11.53% = 0.86 × 0.93 × 33.10% × 0.44

Based on: 10-K (reporting date: 2018-12-31), 10-K (reporting date: 2017-12-31), 10-K (reporting date: 2016-12-31), 10-K (reporting date: 2015-12-31), 10-K (reporting date: 2014-12-31).


The Return on Assets (ROA) experienced a significant contraction followed by a steady recovery over the analyzed five-year period. From a high of 11.53% in 2014, the ROA declined to 5.92% in 2015, before climbing consistently to reach 11.40% by December 31, 2018. This performance trend is the result of shifting dynamics across operating margins, asset efficiency, and tax and interest burdens.

Operating Profitability
The EBIT margin demonstrated a notable U-shaped trend. After declining from 33.10% in 2014 to 25.48% in 2015 and remaining stagnant at 25.68% in 2016, the margin expanded sharply to 37.28% in 2017 and 36.51% in 2018. This recovery in operating efficiency was the primary driver behind the restoration of the ROA.
Asset Utilization
Asset turnover exhibited a dip in 2015, falling to 0.34 from 0.44 in 2014. Subsequently, the ratio improved and stabilized at 0.43 for both 2017 and 2018, indicating a recovery in the ability to generate sales relative to the total asset base.
Interest and Tax Burdens
The interest burden remained relatively consistent, ranging between 0.83 and 0.93, suggesting that interest expenses did not deviate significantly as a proportion of operating income. The tax burden showed more volatility, with a pronounced decrease to 0.68 in 2017, suggesting a higher tax impact during that period, followed by a return to 0.84 in 2018.

AI Ask an analyst for more

Hi, I’m an AI-powered financial analyst at Stock Analysis on Net.

How can I help you?


Disaggregation of Net Profit Margin

Celgene Corp., decomposition of net profit margin ratio

Microsoft Excel
Net Profit Margin = Tax Burden × Interest Burden × EBIT Margin
Dec 31, 2018 26.51% = 0.84 × 0.87 × 36.51%
Dec 31, 2017 22.66% = 0.68 × 0.89 × 37.28%
Dec 31, 2016 17.87% = 0.84 × 0.83 × 25.68%
Dec 31, 2015 17.49% = 0.79 × 0.87 × 25.48%
Dec 31, 2014 26.44% = 0.86 × 0.93 × 33.10%

Based on: 10-K (reporting date: 2018-12-31), 10-K (reporting date: 2017-12-31), 10-K (reporting date: 2016-12-31), 10-K (reporting date: 2015-12-31), 10-K (reporting date: 2014-12-31).


The net profit margin exhibited a U-shaped trajectory between 2014 and 2018, characterized by a significant contraction in the middle years followed by a full recovery. After starting at 26.44% in 2014, the margin declined to a low of 17.49% in 2015 and remained relatively stagnant in 2016 before ascending to 26.51% by the end of 2018.

Operating Performance (EBIT Margin)
The EBIT margin acted as the primary driver of volatility in overall profitability. A sharp decrease was observed from 2014 (33.10%) to 2015 (25.48%), which directly correlated with the drop in net profit margin. A strong recovery occurred in 2017, with the margin peaking at 37.28%, suggesting a significant improvement in operational efficiency or a favorable shift in the product mix, before settling at 36.51% in 2018.
Interest Burden
The interest burden remained relatively stable throughout the period, fluctuating marginally between a high of 0.93 in 2014 and a low of 0.83 in 2016. This stability indicates that interest expenses did not contribute significantly to the volatility of the net profit margin.
Tax Burden
The tax burden displayed inconsistent patterns, most notably a significant dip to 0.68 in 2017. This decline indicates a higher effective tax impact in that year, which partially offset the gains made in the EBIT margin. By 2018, the tax burden returned to 0.84, consistent with the levels seen in 2014 and 2016.

In summary, the disaggregation of the net profit margin reveals that the fluctuations were predominantly caused by changes in operating profitability (EBIT margin) rather than financing costs or tax efficiencies. The recovery in net profit margin by 2018 was fundamentally driven by a strengthened operating margin, which more than compensated for the temporary pressures observed in the tax burden during 2017.

AI Ask an analyst for more

Hi, I’m an AI-powered financial analyst at Stock Analysis on Net.

How can I help you?