Stock Analysis on Net

Illumina Inc. (NASDAQ:ILMN)

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

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

Microsoft Excel

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

Illumina Inc.、 ROE の分解(四半期データ)

Microsoft Excel
ROE = ROA × 財務レバレッジ比率
2021/10/03 8.55% = 6.01% × 1.42
2021/07/04 14.83% = 8.85% × 1.67
2021/04/04 12.80% = 7.20% × 1.78
2020/12/31 13.98% = 8.65% × 1.62
2020/09/27 13.57% = 8.62% × 1.58
2020/06/28 15.19% = 9.56% × 1.59
2020/03/29 20.32% = 12.97% × 1.57
2019/12/29 21.72% = 13.70% × 1.59
2019/09/29 21.92% = 13.73% × 1.60
2019/06/30 21.65% = 13.45% × 1.61
2019/03/31 21.36% = 11.52% × 1.85
2018/12/30 21.98% = 11.87% × 1.85
2018/09/30 19.53% = 10.12% × 1.93
2018/07/01 19.90% = 11.08% × 1.80
2018/04/01 18.85% = 10.23% × 1.84
2017/12/31 26.41% = 13.81% × 1.91
2017/10/01 27.38% = 15.49% × 1.77
2017/07/02 27.54% = 15.39% × 1.79
2017/04/02 29.01% = 16.10% × 1.80
2016/12/31 21.06% = 10.81% × 1.95
2016/10/02 = × 1.89
2016/07/03 = × 1.94
2016/04/03 = × 1.91

レポートに基づく: 10-Q (報告日: 2021-10-03), 10-Q (報告日: 2021-07-04), 10-Q (報告日: 2021-04-04), 10-K (報告日: 2020-12-31), 10-Q (報告日: 2020-09-27), 10-Q (報告日: 2020-06-28), 10-Q (報告日: 2020-03-29), 10-K (報告日: 2019-12-29), 10-Q (報告日: 2019-09-29), 10-Q (報告日: 2019-06-30), 10-Q (報告日: 2019-03-31), 10-K (報告日: 2018-12-30), 10-Q (報告日: 2018-09-30), 10-Q (報告日: 2018-07-01), 10-Q (報告日: 2018-04-01), 10-K (報告日: 2017-12-31), 10-Q (報告日: 2017-10-01), 10-Q (報告日: 2017-07-02), 10-Q (報告日: 2017-04-02), 10-K (報告日: 2016-12-31), 10-Q (報告日: 2016-10-02), 10-Q (報告日: 2016-07-03), 10-Q (報告日: 2016-04-03).

2021年第3 四半期の株主資本利益率(ROE)が低下した主な理由は、総資産利益率(ROA)で測定した収益性の低下です。


ROEを3つの要素に分解

Illumina Inc.、 ROE の分解(四半期データ)

Microsoft Excel
ROE = 純利益率 × 資産回転率 × 財務レバレッジ比率
2021/10/03 8.55% = 21.17% × 0.28 × 1.42
2021/07/04 14.83% = 19.36% × 0.46 × 1.67
2021/04/04 12.80% = 18.14% × 0.40 × 1.78
2020/12/31 13.98% = 20.25% × 0.43 × 1.62
2020/09/27 13.57% = 19.70% × 0.44 × 1.58
2020/06/28 15.19% = 20.68% × 0.46 × 1.59
2020/03/29 20.32% = 26.49% × 0.49 × 1.57
2019/12/29 21.72% = 28.28% × 0.48 × 1.59
2019/09/29 21.92% = 28.13% × 0.49 × 1.60
2019/06/30 21.65% = 27.55% × 0.49 × 1.61
2019/03/31 21.36% = 25.05% × 0.46 × 1.85
2018/12/30 21.98% = 24.78% × 0.48 × 1.85
2018/09/30 19.53% = 21.09% × 0.48 × 1.93
2018/07/01 19.90% = 20.88% × 0.53 × 1.80
2018/04/01 18.85% = 19.31% × 0.53 × 1.84
2017/12/31 26.41% = 26.38% × 0.52 × 1.91
2017/10/01 27.38% = 30.14% × 0.51 × 1.77
2017/07/02 27.54% = 30.07% × 0.51 × 1.79
2017/04/02 29.01% = 30.52% × 0.53 × 1.80
2016/12/31 21.06% = 19.29% × 0.56 × 1.95
2016/10/02 = × × 1.89
2016/07/03 = × × 1.94
2016/04/03 = × × 1.91

レポートに基づく: 10-Q (報告日: 2021-10-03), 10-Q (報告日: 2021-07-04), 10-Q (報告日: 2021-04-04), 10-K (報告日: 2020-12-31), 10-Q (報告日: 2020-09-27), 10-Q (報告日: 2020-06-28), 10-Q (報告日: 2020-03-29), 10-K (報告日: 2019-12-29), 10-Q (報告日: 2019-09-29), 10-Q (報告日: 2019-06-30), 10-Q (報告日: 2019-03-31), 10-K (報告日: 2018-12-30), 10-Q (報告日: 2018-09-30), 10-Q (報告日: 2018-07-01), 10-Q (報告日: 2018-04-01), 10-K (報告日: 2017-12-31), 10-Q (報告日: 2017-10-01), 10-Q (報告日: 2017-07-02), 10-Q (報告日: 2017-04-02), 10-K (報告日: 2016-12-31), 10-Q (報告日: 2016-10-02), 10-Q (報告日: 2016-07-03), 10-Q (報告日: 2016-04-03).

2021年第3 四半期の株主資本利益率(ROE)が低下した主な理由は、資産回転率で測定される効率性の低下です。


ROEを5つの要素に分解

Illumina Inc.、 ROE の分解(四半期データ)

Microsoft Excel
ROE = 税負担 × 利息負担 × EBITマージン × 資産回転率 × 財務レバレッジ比率
2021/10/03 8.55% = 0.83 × 0.94 × 27.08% × 0.28 × 1.42
2021/07/04 14.83% = 0.86 × 0.93 × 23.98% × 0.46 × 1.67
2021/04/04 12.80% = 0.74 × 0.94 × 26.03% × 0.40 × 1.78
2020/12/31 13.98% = 0.77 × 0.95 × 27.94% × 0.43 × 1.62
2020/09/27 13.57% = 0.77 × 0.95 × 26.90% × 0.44 × 1.58
2020/06/28 15.19% = 0.79 × 0.95 × 27.63% × 0.46 × 1.59
2020/03/29 20.32% = 0.88 × 0.96 × 31.33% × 0.49 × 1.57
2019/12/29 21.72% = 0.89 × 0.96 × 33.36% × 0.48 × 1.59
2019/09/29 21.92% = 0.90 × 0.95 × 33.07% × 0.49 × 1.60
2019/06/30 21.65% = 0.89 × 0.94 × 32.92% × 0.49 × 1.61
2019/03/31 21.36% = 0.90 × 0.94 × 29.70% × 0.46 × 1.85
2018/12/30 21.98% = 0.88 × 0.94 × 29.85% × 0.48 × 1.85
2018/09/30 19.53% = 0.72 × 0.95 × 30.77% × 0.48 × 1.93
2018/07/01 19.90% = 0.73 × 0.95 × 30.15% × 0.53 × 1.80
2018/04/01 18.85% = 0.71 × 0.95 × 28.64% × 0.53 × 1.84
2017/12/31 26.41% = 0.67 × 0.97 × 40.99% × 0.52 × 1.91
2017/10/01 27.38% = 0.78 × 0.97 × 40.17% × 0.51 × 1.77
2017/07/02 27.54% = 0.76 × 0.97 × 41.03% × 0.51 × 1.79
2017/04/02 29.01% = 0.74 × 0.97 × 42.58% × 0.53 × 1.80
2016/12/31 21.06% = 0.78 × 0.95 × 26.22% × 0.56 × 1.95
2016/10/02 = × × × × 1.89
2016/07/03 = × × × × 1.94
2016/04/03 = × × × × 1.91

レポートに基づく: 10-Q (報告日: 2021-10-03), 10-Q (報告日: 2021-07-04), 10-Q (報告日: 2021-04-04), 10-K (報告日: 2020-12-31), 10-Q (報告日: 2020-09-27), 10-Q (報告日: 2020-06-28), 10-Q (報告日: 2020-03-29), 10-K (報告日: 2019-12-29), 10-Q (報告日: 2019-09-29), 10-Q (報告日: 2019-06-30), 10-Q (報告日: 2019-03-31), 10-K (報告日: 2018-12-30), 10-Q (報告日: 2018-09-30), 10-Q (報告日: 2018-07-01), 10-Q (報告日: 2018-04-01), 10-K (報告日: 2017-12-31), 10-Q (報告日: 2017-10-01), 10-Q (報告日: 2017-07-02), 10-Q (報告日: 2017-04-02), 10-K (報告日: 2016-12-31), 10-Q (報告日: 2016-10-02), 10-Q (報告日: 2016-07-03), 10-Q (報告日: 2016-04-03).

2021年第3 四半期の株主資本利益率(ROE)が低下した主な理由は、資産回転率で測定される効率性の低下です。


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

Illumina Inc.、 ROA の分解(四半期データ)

Microsoft Excel
ROA = 純利益率 × 資産回転率
2021/10/03 6.01% = 21.17% × 0.28
2021/07/04 8.85% = 19.36% × 0.46
2021/04/04 7.20% = 18.14% × 0.40
2020/12/31 8.65% = 20.25% × 0.43
2020/09/27 8.62% = 19.70% × 0.44
2020/06/28 9.56% = 20.68% × 0.46
2020/03/29 12.97% = 26.49% × 0.49
2019/12/29 13.70% = 28.28% × 0.48
2019/09/29 13.73% = 28.13% × 0.49
2019/06/30 13.45% = 27.55% × 0.49
2019/03/31 11.52% = 25.05% × 0.46
2018/12/30 11.87% = 24.78% × 0.48
2018/09/30 10.12% = 21.09% × 0.48
2018/07/01 11.08% = 20.88% × 0.53
2018/04/01 10.23% = 19.31% × 0.53
2017/12/31 13.81% = 26.38% × 0.52
2017/10/01 15.49% = 30.14% × 0.51
2017/07/02 15.39% = 30.07% × 0.51
2017/04/02 16.10% = 30.52% × 0.53
2016/12/31 10.81% = 19.29% × 0.56
2016/10/02 = ×
2016/07/03 = ×
2016/04/03 = ×

レポートに基づく: 10-Q (報告日: 2021-10-03), 10-Q (報告日: 2021-07-04), 10-Q (報告日: 2021-04-04), 10-K (報告日: 2020-12-31), 10-Q (報告日: 2020-09-27), 10-Q (報告日: 2020-06-28), 10-Q (報告日: 2020-03-29), 10-K (報告日: 2019-12-29), 10-Q (報告日: 2019-09-29), 10-Q (報告日: 2019-06-30), 10-Q (報告日: 2019-03-31), 10-K (報告日: 2018-12-30), 10-Q (報告日: 2018-09-30), 10-Q (報告日: 2018-07-01), 10-Q (報告日: 2018-04-01), 10-K (報告日: 2017-12-31), 10-Q (報告日: 2017-10-01), 10-Q (報告日: 2017-07-02), 10-Q (報告日: 2017-04-02), 10-K (報告日: 2016-12-31), 10-Q (報告日: 2016-10-02), 10-Q (報告日: 2016-07-03), 10-Q (報告日: 2016-04-03).

2021年第3 四半期の総資産利益率(ROA)の低下の主な理由は、資産回転率の低下です。


ROAを4つの要素に分解

Illumina Inc.、 ROA の分解(四半期データ)

Microsoft Excel
ROA = 税負担 × 利息負担 × EBITマージン × 資産回転率
2021/10/03 6.01% = 0.83 × 0.94 × 27.08% × 0.28
2021/07/04 8.85% = 0.86 × 0.93 × 23.98% × 0.46
2021/04/04 7.20% = 0.74 × 0.94 × 26.03% × 0.40
2020/12/31 8.65% = 0.77 × 0.95 × 27.94% × 0.43
2020/09/27 8.62% = 0.77 × 0.95 × 26.90% × 0.44
2020/06/28 9.56% = 0.79 × 0.95 × 27.63% × 0.46
2020/03/29 12.97% = 0.88 × 0.96 × 31.33% × 0.49
2019/12/29 13.70% = 0.89 × 0.96 × 33.36% × 0.48
2019/09/29 13.73% = 0.90 × 0.95 × 33.07% × 0.49
2019/06/30 13.45% = 0.89 × 0.94 × 32.92% × 0.49
2019/03/31 11.52% = 0.90 × 0.94 × 29.70% × 0.46
2018/12/30 11.87% = 0.88 × 0.94 × 29.85% × 0.48
2018/09/30 10.12% = 0.72 × 0.95 × 30.77% × 0.48
2018/07/01 11.08% = 0.73 × 0.95 × 30.15% × 0.53
2018/04/01 10.23% = 0.71 × 0.95 × 28.64% × 0.53
2017/12/31 13.81% = 0.67 × 0.97 × 40.99% × 0.52
2017/10/01 15.49% = 0.78 × 0.97 × 40.17% × 0.51
2017/07/02 15.39% = 0.76 × 0.97 × 41.03% × 0.51
2017/04/02 16.10% = 0.74 × 0.97 × 42.58% × 0.53
2016/12/31 10.81% = 0.78 × 0.95 × 26.22% × 0.56
2016/10/02 = × × ×
2016/07/03 = × × ×
2016/04/03 = × × ×

レポートに基づく: 10-Q (報告日: 2021-10-03), 10-Q (報告日: 2021-07-04), 10-Q (報告日: 2021-04-04), 10-K (報告日: 2020-12-31), 10-Q (報告日: 2020-09-27), 10-Q (報告日: 2020-06-28), 10-Q (報告日: 2020-03-29), 10-K (報告日: 2019-12-29), 10-Q (報告日: 2019-09-29), 10-Q (報告日: 2019-06-30), 10-Q (報告日: 2019-03-31), 10-K (報告日: 2018-12-30), 10-Q (報告日: 2018-09-30), 10-Q (報告日: 2018-07-01), 10-Q (報告日: 2018-04-01), 10-K (報告日: 2017-12-31), 10-Q (報告日: 2017-10-01), 10-Q (報告日: 2017-07-02), 10-Q (報告日: 2017-04-02), 10-K (報告日: 2016-12-31), 10-Q (報告日: 2016-10-02), 10-Q (報告日: 2016-07-03), 10-Q (報告日: 2016-04-03).

2021年第3 四半期の総資産利益率(ROA)の低下の主な理由は、資産回転率で測定される効率性の低下です。


当期純利益率の分解

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

Microsoft Excel
純利益率 = 税負担 × 利息負担 × EBITマージン
2021/10/03 21.17% = 0.83 × 0.94 × 27.08%
2021/07/04 19.36% = 0.86 × 0.93 × 23.98%
2021/04/04 18.14% = 0.74 × 0.94 × 26.03%
2020/12/31 20.25% = 0.77 × 0.95 × 27.94%
2020/09/27 19.70% = 0.77 × 0.95 × 26.90%
2020/06/28 20.68% = 0.79 × 0.95 × 27.63%
2020/03/29 26.49% = 0.88 × 0.96 × 31.33%
2019/12/29 28.28% = 0.89 × 0.96 × 33.36%
2019/09/29 28.13% = 0.90 × 0.95 × 33.07%
2019/06/30 27.55% = 0.89 × 0.94 × 32.92%
2019/03/31 25.05% = 0.90 × 0.94 × 29.70%
2018/12/30 24.78% = 0.88 × 0.94 × 29.85%
2018/09/30 21.09% = 0.72 × 0.95 × 30.77%
2018/07/01 20.88% = 0.73 × 0.95 × 30.15%
2018/04/01 19.31% = 0.71 × 0.95 × 28.64%
2017/12/31 26.38% = 0.67 × 0.97 × 40.99%
2017/10/01 30.14% = 0.78 × 0.97 × 40.17%
2017/07/02 30.07% = 0.76 × 0.97 × 41.03%
2017/04/02 30.52% = 0.74 × 0.97 × 42.58%
2016/12/31 19.29% = 0.78 × 0.95 × 26.22%
2016/10/02 = × ×
2016/07/03 = × ×
2016/04/03 = × ×

レポートに基づく: 10-Q (報告日: 2021-10-03), 10-Q (報告日: 2021-07-04), 10-Q (報告日: 2021-04-04), 10-K (報告日: 2020-12-31), 10-Q (報告日: 2020-09-27), 10-Q (報告日: 2020-06-28), 10-Q (報告日: 2020-03-29), 10-K (報告日: 2019-12-29), 10-Q (報告日: 2019-09-29), 10-Q (報告日: 2019-06-30), 10-Q (報告日: 2019-03-31), 10-K (報告日: 2018-12-30), 10-Q (報告日: 2018-09-30), 10-Q (報告日: 2018-07-01), 10-Q (報告日: 2018-04-01), 10-K (報告日: 2017-12-31), 10-Q (報告日: 2017-10-01), 10-Q (報告日: 2017-07-02), 10-Q (報告日: 2017-04-02), 10-K (報告日: 2016-12-31), 10-Q (報告日: 2016-10-02), 10-Q (報告日: 2016-07-03), 10-Q (報告日: 2016-04-03).

2021年第3 四半期から純利益率が上昇した主な理由は、EBITマージン率で測定した営業利益率の増加です。