Stock Analysis on Net
Stock Analysis on Net

Celgene Corp. (NASDAQ:CELG)

この会社は アーカイブに移されました! 財務データは2019年10月31日以降更新されていません。

デュポン分析: ROE、ROA、純利益率の内訳 
四半期データ

Microsoft Excel

ROE分解では、純利益を株主資本で割ったものを構成比率の積として表します。

ROEを2つのコンポーネントに分解

Celgene Corp.、 ROE の分解(四半期データ)

Microsoft Excel
ROE = ROA × 財務レバレッジ比率
2019/09/30 48.65% = 14.22% × 3.42
2019/06/30 52.44% = 13.45% × 3.90
2019/03/31 58.11% = 12.61% × 4.61
2018/12/31 65.67% = 11.40% × 5.76
2018/09/30 59.51% = 8.45% × 7.04
2018/06/30 81.57% = 8.37% × 9.75
2018/03/31 55.18% = 8.26% × 6.68
2017/12/31 42.48% = 9.75% × 4.36
2017/09/30 35.02% = 10.87% × 3.22
2017/06/30 31.18% = 8.69% × 3.59
2017/03/31 27.87% = 7.39% × 3.77
2016/12/31 30.29% = 7.12% × 4.26
2016/09/30 37.72% = 7.97% × 4.73
2016/06/30 34.71% = 7.25% × 4.79
2016/03/31 33.18% = 6.49% × 5.12
2015/12/31 27.07% = 5.92% × 4.57
2015/09/30 30.79% = 6.05% × 5.09
2015/06/30 34.76% = 12.38% × 2.81
2015/03/31 36.06% = 13.95% × 2.58
2014/12/31 30.65% = 11.53% × 2.66
2014/09/30 — = — × 2.84
2014/06/30 — = — × 3.22
2014/03/31 — = — × 2.83

レポートに基づく: 10-Q (報告日: 2019-09-30), 10-Q (報告日: 2019-06-30), 10-Q (報告日: 2019-03-31), 10-K (報告日: 2018-12-31), 10-Q (報告日: 2018-09-30), 10-Q (報告日: 2018-06-30), 10-Q (報告日: 2018-03-31), 10-K (報告日: 2017-12-31), 10-Q (報告日: 2017-09-30), 10-Q (報告日: 2017-06-30), 10-Q (報告日: 2017-03-31), 10-K (報告日: 2016-12-31), 10-Q (報告日: 2016-09-30), 10-Q (報告日: 2016-06-30), 10-Q (報告日: 2016-03-31), 10-K (報告日: 2015-12-31), 10-Q (報告日: 2015-09-30), 10-Q (報告日: 2015-06-30), 10-Q (報告日: 2015-03-31), 10-K (報告日: 2014-12-31), 10-Q (報告日: 2014-09-30), 10-Q (報告日: 2014-06-30), 10-Q (報告日: 2014-03-31).

2019年第3 四半期の株主資本利益率(ROE)が低下した主な理由は、財務レバレッジ比率の低下です。

ROEを3つの要素に分解

Celgene Corp.、 ROE の分解(四半期データ)

Microsoft Excel
ROE = 純利益率 × 資産回転率 × 財務レバレッジ比率
2019/09/30 48.65% = 34.64% × 0.41 × 3.42
2019/06/30 52.44% = 32.24% × 0.42 × 3.90
2019/03/31 58.11% = 30.11% × 0.42 × 4.61
2018/12/31 65.67% = 26.51% × 0.43 × 5.76
2018/09/30 59.51% = 19.66% × 0.43 × 7.04
2018/06/30 81.57% = 19.84% × 0.42 × 9.75
2018/03/31 55.18% = 21.06% × 0.39 × 6.68
2017/12/31 42.48% = 22.66% × 0.43 × 4.36
2017/09/30 35.02% = 27.66% × 0.39 × 3.22
2017/06/30 31.18% = 21.66% × 0.40 × 3.59
2017/03/31 27.87% = 18.30% × 0.40 × 3.77
2016/12/31 30.29% = 17.87% × 0.40 × 4.26
2016/09/30 37.72% = 19.83% × 0.40 × 4.73
2016/06/30 34.71% = 19.08% × 0.38 × 4.79
2016/03/31 33.18% = 17.54% × 0.37 × 5.12
2015/12/31 27.07% = 17.49% × 0.34 × 4.57
2015/09/30 30.79% = 19.07% × 0.32 × 5.09
2015/06/30 34.76% = 26.41% × 0.47 × 2.81
2015/03/31 36.06% = 30.83% × 0.45 × 2.58
2014/12/31 30.65% = 26.44% × 0.44 × 2.66
2014/09/30 — = — × — × 2.84
2014/06/30 — = — × — × 3.22
2014/03/31 — = — × — × 2.83

レポートに基づく: 10-Q (報告日: 2019-09-30), 10-Q (報告日: 2019-06-30), 10-Q (報告日: 2019-03-31), 10-K (報告日: 2018-12-31), 10-Q (報告日: 2018-09-30), 10-Q (報告日: 2018-06-30), 10-Q (報告日: 2018-03-31), 10-K (報告日: 2017-12-31), 10-Q (報告日: 2017-09-30), 10-Q (報告日: 2017-06-30), 10-Q (報告日: 2017-03-31), 10-K (報告日: 2016-12-31), 10-Q (報告日: 2016-09-30), 10-Q (報告日: 2016-06-30), 10-Q (報告日: 2016-03-31), 10-K (報告日: 2015-12-31), 10-Q (報告日: 2015-09-30), 10-Q (報告日: 2015-06-30), 10-Q (報告日: 2015-03-31), 10-K (報告日: 2014-12-31), 10-Q (報告日: 2014-09-30), 10-Q (報告日: 2014-06-30), 10-Q (報告日: 2014-03-31).

2019年第3 四半期の株主資本利益率(ROE)が低下した主な理由は、財務レバレッジ比率の低下です。

ROEを5つの要素に分解

Celgene Corp.、 ROE の分解(四半期データ)

Microsoft Excel
ROE = 税負担 × 利息負担 × EBITマージン × 資産回転率 × 財務レバレッジ比率
2019/09/30 48.65% = 0.88 × 0.90 × 43.78% × 0.41 × 3.42
2019/06/30 52.44% = 0.86 × 0.89 × 42.19% × 0.42 × 3.90
2019/03/31 58.11% = 0.84 × 0.88 × 40.51% × 0.42 × 4.61
2018/12/31 65.67% = 0.84 × 0.87 × 36.51% × 0.43 × 5.76
2018/09/30 59.51% = 0.60 × 0.87 × 37.66% × 0.43 × 7.04
2018/06/30 81.57% = 0.63 × 0.88 × 36.07% × 0.42 × 9.75
2018/03/31 55.18% = 0.66 × 0.89 × 36.09% × 0.39 × 6.68
2017/12/31 42.48% = 0.68 × 0.89 × 37.28% × 0.43 × 4.36
2017/09/30 35.02% = 0.94 × 0.88 × 33.59% × 0.39 × 3.22
2017/06/30 31.18% = 0.89 × 0.85 × 28.43% × 0.40 × 3.59
2017/03/31 27.87% = 0.86 × 0.83 × 25.51% × 0.40 × 3.77
2016/12/31 30.29% = 0.84 × 0.83 × 25.68% × 0.40 × 4.26
2016/09/30 37.72% = 0.81 × 0.84 × 29.00% × 0.40 × 4.73
2016/06/30 34.71% = 0.82 × 0.84 × 27.75% × 0.38 × 4.79
2016/03/31 33.18% = 0.79 × 0.85 × 26.05% × 0.37 × 5.12
2015/12/31 27.07% = 0.79 × 0.87 × 25.48% × 0.34 × 4.57
2015/09/30 30.79% = 0.83 × 0.89 × 25.66% × 0.32 × 5.09
2015/06/30 34.76% = 0.85 × 0.93 × 33.52% × 0.47 × 2.81
2015/03/31 36.06% = 0.86 × 0.94 × 38.15% × 0.45 × 2.58
2014/12/31 30.65% = 0.86 × 0.93 × 33.10% × 0.44 × 2.66
2014/09/30 — = — × — × — × — × 2.84
2014/06/30 — = — × — × — × — × 3.22
2014/03/31 — = — × — × — × — × 2.83

レポートに基づく: 10-Q (報告日: 2019-09-30), 10-Q (報告日: 2019-06-30), 10-Q (報告日: 2019-03-31), 10-K (報告日: 2018-12-31), 10-Q (報告日: 2018-09-30), 10-Q (報告日: 2018-06-30), 10-Q (報告日: 2018-03-31), 10-K (報告日: 2017-12-31), 10-Q (報告日: 2017-09-30), 10-Q (報告日: 2017-06-30), 10-Q (報告日: 2017-03-31), 10-K (報告日: 2016-12-31), 10-Q (報告日: 2016-09-30), 10-Q (報告日: 2016-06-30), 10-Q (報告日: 2016-03-31), 10-K (報告日: 2015-12-31), 10-Q (報告日: 2015-09-30), 10-Q (報告日: 2015-06-30), 10-Q (報告日: 2015-03-31), 10-K (報告日: 2014-12-31), 10-Q (報告日: 2014-09-30), 10-Q (報告日: 2014-06-30), 10-Q (報告日: 2014-03-31).

2019年第3 四半期の株主資本利益率(ROE)が低下した主な理由は、財務レバレッジ比率の低下です。

ROAを2つのコンポーネントに分解

Celgene Corp.、 ROA の分解(四半期データ)

Microsoft Excel
ROA = 純利益率 × 資産回転率
2019/09/30 14.22% = 34.64% × 0.41
2019/06/30 13.45% = 32.24% × 0.42
2019/03/31 12.61% = 30.11% × 0.42
2018/12/31 11.40% = 26.51% × 0.43
2018/09/30 8.45% = 19.66% × 0.43
2018/06/30 8.37% = 19.84% × 0.42
2018/03/31 8.26% = 21.06% × 0.39
2017/12/31 9.75% = 22.66% × 0.43
2017/09/30 10.87% = 27.66% × 0.39
2017/06/30 8.69% = 21.66% × 0.40
2017/03/31 7.39% = 18.30% × 0.40
2016/12/31 7.12% = 17.87% × 0.40
2016/09/30 7.97% = 19.83% × 0.40
2016/06/30 7.25% = 19.08% × 0.38
2016/03/31 6.49% = 17.54% × 0.37
2015/12/31 5.92% = 17.49% × 0.34
2015/09/30 6.05% = 19.07% × 0.32
2015/06/30 12.38% = 26.41% × 0.47
2015/03/31 13.95% = 30.83% × 0.45
2014/12/31 11.53% = 26.44% × 0.44
2014/09/30 — = — × —
2014/06/30 — = — × —
2014/03/31 — = — × —

レポートに基づく: 10-Q (報告日: 2019-09-30), 10-Q (報告日: 2019-06-30), 10-Q (報告日: 2019-03-31), 10-K (報告日: 2018-12-31), 10-Q (報告日: 2018-09-30), 10-Q (報告日: 2018-06-30), 10-Q (報告日: 2018-03-31), 10-K (報告日: 2017-12-31), 10-Q (報告日: 2017-09-30), 10-Q (報告日: 2017-06-30), 10-Q (報告日: 2017-03-31), 10-K (報告日: 2016-12-31), 10-Q (報告日: 2016-09-30), 10-Q (報告日: 2016-06-30), 10-Q (報告日: 2016-03-31), 10-K (報告日: 2015-12-31), 10-Q (報告日: 2015-09-30), 10-Q (報告日: 2015-06-30), 10-Q (報告日: 2015-03-31), 10-K (報告日: 2014-12-31), 10-Q (報告日: 2014-09-30), 10-Q (報告日: 2014-06-30), 10-Q (報告日: 2014-03-31).

2019年第3 四半期の総資産利益率(ROA)が上昇した主な理由は、純利益率で測定される収益性の向上です。

ROAを4つの要素に分解

Celgene Corp.、 ROA の分解(四半期データ)

Microsoft Excel
ROA = 税負担 × 利息負担 × EBITマージン × 資産回転率
2019/09/30 14.22% = 0.88 × 0.90 × 43.78% × 0.41
2019/06/30 13.45% = 0.86 × 0.89 × 42.19% × 0.42
2019/03/31 12.61% = 0.84 × 0.88 × 40.51% × 0.42
2018/12/31 11.40% = 0.84 × 0.87 × 36.51% × 0.43
2018/09/30 8.45% = 0.60 × 0.87 × 37.66% × 0.43
2018/06/30 8.37% = 0.63 × 0.88 × 36.07% × 0.42
2018/03/31 8.26% = 0.66 × 0.89 × 36.09% × 0.39
2017/12/31 9.75% = 0.68 × 0.89 × 37.28% × 0.43
2017/09/30 10.87% = 0.94 × 0.88 × 33.59% × 0.39
2017/06/30 8.69% = 0.89 × 0.85 × 28.43% × 0.40
2017/03/31 7.39% = 0.86 × 0.83 × 25.51% × 0.40
2016/12/31 7.12% = 0.84 × 0.83 × 25.68% × 0.40
2016/09/30 7.97% = 0.81 × 0.84 × 29.00% × 0.40
2016/06/30 7.25% = 0.82 × 0.84 × 27.75% × 0.38
2016/03/31 6.49% = 0.79 × 0.85 × 26.05% × 0.37
2015/12/31 5.92% = 0.79 × 0.87 × 25.48% × 0.34
2015/09/30 6.05% = 0.83 × 0.89 × 25.66% × 0.32
2015/06/30 12.38% = 0.85 × 0.93 × 33.52% × 0.47
2015/03/31 13.95% = 0.86 × 0.94 × 38.15% × 0.45
2014/12/31 11.53% = 0.86 × 0.93 × 33.10% × 0.44
2014/09/30 — = — × — × — × —
2014/06/30 — = — × — × — × —
2014/03/31 — = — × — × — × —

レポートに基づく: 10-Q (報告日: 2019-09-30), 10-Q (報告日: 2019-06-30), 10-Q (報告日: 2019-03-31), 10-K (報告日: 2018-12-31), 10-Q (報告日: 2018-09-30), 10-Q (報告日: 2018-06-30), 10-Q (報告日: 2018-03-31), 10-K (報告日: 2017-12-31), 10-Q (報告日: 2017-09-30), 10-Q (報告日: 2017-06-30), 10-Q (報告日: 2017-03-31), 10-K (報告日: 2016-12-31), 10-Q (報告日: 2016-09-30), 10-Q (報告日: 2016-06-30), 10-Q (報告日: 2016-03-31), 10-K (報告日: 2015-12-31), 10-Q (報告日: 2015-09-30), 10-Q (報告日: 2015-06-30), 10-Q (報告日: 2015-03-31), 10-K (報告日: 2014-12-31), 10-Q (報告日: 2014-09-30), 10-Q (報告日: 2014-06-30), 10-Q (報告日: 2014-03-31).

2019年第3 四半期の総資産利益率(ROA)が上昇した主な理由は、EBITマージン率で測定した営業利益率の増加です。

純利益率の分解

Celgene Corp.、純利益率の分解(四半期データ)

Microsoft Excel
純利益率 = 税負担 × 利息負担 × EBITマージン
2019/09/30 34.64% = 0.88 × 0.90 × 43.78%
2019/06/30 32.24% = 0.86 × 0.89 × 42.19%
2019/03/31 30.11% = 0.84 × 0.88 × 40.51%
2018/12/31 26.51% = 0.84 × 0.87 × 36.51%
2018/09/30 19.66% = 0.60 × 0.87 × 37.66%
2018/06/30 19.84% = 0.63 × 0.88 × 36.07%
2018/03/31 21.06% = 0.66 × 0.89 × 36.09%
2017/12/31 22.66% = 0.68 × 0.89 × 37.28%
2017/09/30 27.66% = 0.94 × 0.88 × 33.59%
2017/06/30 21.66% = 0.89 × 0.85 × 28.43%
2017/03/31 18.30% = 0.86 × 0.83 × 25.51%
2016/12/31 17.87% = 0.84 × 0.83 × 25.68%
2016/09/30 19.83% = 0.81 × 0.84 × 29.00%
2016/06/30 19.08% = 0.82 × 0.84 × 27.75%
2016/03/31 17.54% = 0.79 × 0.85 × 26.05%
2015/12/31 17.49% = 0.79 × 0.87 × 25.48%
2015/09/30 19.07% = 0.83 × 0.89 × 25.66%
2015/06/30 26.41% = 0.85 × 0.93 × 33.52%
2015/03/31 30.83% = 0.86 × 0.94 × 38.15%
2014/12/31 26.44% = 0.86 × 0.93 × 33.10%
2014/09/30 — = — × — × —
2014/06/30 — = — × — × —
2014/03/31 — = — × — × —

レポートに基づく: 10-Q (報告日: 2019-09-30), 10-Q (報告日: 2019-06-30), 10-Q (報告日: 2019-03-31), 10-K (報告日: 2018-12-31), 10-Q (報告日: 2018-09-30), 10-Q (報告日: 2018-06-30), 10-Q (報告日: 2018-03-31), 10-K (報告日: 2017-12-31), 10-Q (報告日: 2017-09-30), 10-Q (報告日: 2017-06-30), 10-Q (報告日: 2017-03-31), 10-K (報告日: 2016-12-31), 10-Q (報告日: 2016-09-30), 10-Q (報告日: 2016-06-30), 10-Q (報告日: 2016-03-31), 10-K (報告日: 2015-12-31), 10-Q (報告日: 2015-09-30), 10-Q (報告日: 2015-06-30), 10-Q (報告日: 2015-03-31), 10-K (報告日: 2014-12-31), 10-Q (報告日: 2014-09-30), 10-Q (報告日: 2014-06-30), 10-Q (報告日: 2014-03-31).

2019年第3 四半期に純利益率が上昇した主な理由は、EBITマージン比率で測定した営業利益率の向上です。