Stock Analysis on Net

Amgen Inc. (NASDAQ:AMGN)

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

Microsoft Excel

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

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

Microsoft Excel
ROE = ROA × 財務レバレッジ比率
2023/12/31 107.78% = 6.91% × 15.59
2023/09/30 98.82% = 8.36% × 11.83
2023/06/30 117.67% = 8.84% × 13.31
2023/03/31 148.04% = 8.92% × 16.59
2022/12/31 178.97% = 10.06% × 17.79
2022/09/30 187.11% = 10.73% × 17.44
2022/06/30 271.85% = 11.09% × 24.51
2022/03/31 624.78% = 9.67% × 64.62
2021/12/31 87.96% = 9.63% × 9.13
2021/09/30 68.26% = 8.63% × 7.91
2021/06/30 69.67% = 9.61% × 7.25
2021/03/31 75.91% = 11.33% × 6.70
2020/12/31 77.20% = 11.54% × 6.69
2020/09/30 67.09% = 11.37% × 5.90
2020/06/30 68.48% = 11.23% × 6.10
2020/03/31 80.92% = 12.45% × 6.50
2019/12/31 81.07% = 13.13% × 6.17
2019/09/30 = × 5.45
2019/06/30 = × 5.50
2019/03/31 = × 5.91

レポートに基づく: 10-K (報告日: 2023-12-31), 10-Q (報告日: 2023-09-30), 10-Q (報告日: 2023-06-30), 10-Q (報告日: 2023-03-31), 10-K (報告日: 2022-12-31), 10-Q (報告日: 2022-09-30), 10-Q (報告日: 2022-06-30), 10-Q (報告日: 2022-03-31), 10-K (報告日: 2021-12-31), 10-Q (報告日: 2021-09-30), 10-Q (報告日: 2021-06-30), 10-Q (報告日: 2021-03-31), 10-K (報告日: 2020-12-31), 10-Q (報告日: 2020-09-30), 10-Q (報告日: 2020-06-30), 10-Q (報告日: 2020-03-31), 10-K (報告日: 2019-12-31), 10-Q (報告日: 2019-09-30), 10-Q (報告日: 2019-06-30), 10-Q (報告日: 2019-03-31).

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


ROEを3つの要素に分解

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

Microsoft Excel
ROE = 純利益率 × 資産回転率 × 財務レバレッジ比率
2023/12/31 107.78% = 24.96% × 0.28 × 15.59
2023/09/30 98.82% = 29.52% × 0.28 × 11.83
2023/06/30 117.67% = 31.52% × 0.28 × 13.31
2023/03/31 148.04% = 31.77% × 0.28 × 16.59
2022/12/31 178.97% = 26.42% × 0.38 × 17.79
2022/09/30 187.11% = 27.88% × 0.38 × 17.44
2022/06/30 271.85% = 26.73% × 0.41 × 24.51
2022/03/31 624.78% = 23.42% × 0.41 × 64.62
2021/12/31 87.96% = 24.25% × 0.40 × 9.13
2021/09/30 68.26% = 23.03% × 0.37 × 7.91
2021/06/30 69.67% = 23.80% × 0.40 × 7.25
2021/03/31 75.91% = 29.60% × 0.38 × 6.70
2020/12/31 77.20% = 29.97% × 0.39 × 6.69
2020/09/30 67.09% = 30.91% × 0.37 × 5.90
2020/06/30 68.48% = 31.53% × 0.36 × 6.10
2020/03/31 80.92% = 33.64% × 0.37 × 6.50
2019/12/31 81.07% = 35.32% × 0.37 × 6.17
2019/09/30 = × × 5.45
2019/06/30 = × × 5.50
2019/03/31 = × × 5.91

レポートに基づく: 10-K (報告日: 2023-12-31), 10-Q (報告日: 2023-09-30), 10-Q (報告日: 2023-06-30), 10-Q (報告日: 2023-03-31), 10-K (報告日: 2022-12-31), 10-Q (報告日: 2022-09-30), 10-Q (報告日: 2022-06-30), 10-Q (報告日: 2022-03-31), 10-K (報告日: 2021-12-31), 10-Q (報告日: 2021-09-30), 10-Q (報告日: 2021-06-30), 10-Q (報告日: 2021-03-31), 10-K (報告日: 2020-12-31), 10-Q (報告日: 2020-09-30), 10-Q (報告日: 2020-06-30), 10-Q (報告日: 2020-03-31), 10-K (報告日: 2019-12-31), 10-Q (報告日: 2019-09-30), 10-Q (報告日: 2019-06-30), 10-Q (報告日: 2019-03-31).

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


ROEを5つの要素に分解

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

Microsoft Excel
ROE = 税負担 × 利息負担 × EBITマージン × 資産回転率 × 財務レバレッジ比率
2023/12/31 107.78% = 0.86 × 0.73 × 39.87% × 0.28 × 15.59
2023/09/30 98.82% = 0.86 × 0.78 × 43.78% × 0.28 × 11.83
2023/06/30 117.67% = 0.87 × 0.82 × 44.53% × 0.28 × 13.31
2023/03/31 148.04% = 0.87 × 0.85 × 43.21% × 0.28 × 16.59
2022/12/31 178.97% = 0.89 × 0.84 × 35.29% × 0.38 × 17.79
2022/09/30 187.11% = 0.88 × 0.85 × 36.93% × 0.38 × 17.44
2022/06/30 271.85% = 0.88 × 0.86 × 35.55% × 0.41 × 24.51
2022/03/31 624.78% = 0.88 × 0.84 × 31.62% × 0.41 × 64.62
2021/12/31 87.96% = 0.88 × 0.85 × 32.51% × 0.40 × 9.13
2021/09/30 68.26% = 0.87 × 0.85 × 31.31% × 0.37 × 7.91
2021/06/30 69.67% = 0.88 × 0.85 × 31.83% × 0.40 × 7.25
2021/03/31 75.91% = 0.89 × 0.87 × 38.31% × 0.38 × 6.70
2020/12/31 77.20% = 0.89 × 0.87 × 38.76% × 0.39 × 6.69
2020/09/30 67.09% = 0.89 × 0.87 × 39.87% × 0.37 × 5.90
2020/06/30 68.48% = 0.88 × 0.87 × 41.33% × 0.36 × 6.10
2020/03/31 80.92% = 0.87 × 0.87 × 44.43% × 0.37 × 6.50
2019/12/31 81.07% = 0.86 × 0.88 × 46.96% × 0.37 × 6.17
2019/09/30 = × × × × 5.45
2019/06/30 = × × × × 5.50
2019/03/31 = × × × × 5.91

レポートに基づく: 10-K (報告日: 2023-12-31), 10-Q (報告日: 2023-09-30), 10-Q (報告日: 2023-06-30), 10-Q (報告日: 2023-03-31), 10-K (報告日: 2022-12-31), 10-Q (報告日: 2022-09-30), 10-Q (報告日: 2022-06-30), 10-Q (報告日: 2022-03-31), 10-K (報告日: 2021-12-31), 10-Q (報告日: 2021-09-30), 10-Q (報告日: 2021-06-30), 10-Q (報告日: 2021-03-31), 10-K (報告日: 2020-12-31), 10-Q (報告日: 2020-09-30), 10-Q (報告日: 2020-06-30), 10-Q (報告日: 2020-03-31), 10-K (報告日: 2019-12-31), 10-Q (報告日: 2019-09-30), 10-Q (報告日: 2019-06-30), 10-Q (報告日: 2019-03-31).

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


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

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

Microsoft Excel
ROA = 純利益率 × 資産回転率
2023/12/31 6.91% = 24.96% × 0.28
2023/09/30 8.36% = 29.52% × 0.28
2023/06/30 8.84% = 31.52% × 0.28
2023/03/31 8.92% = 31.77% × 0.28
2022/12/31 10.06% = 26.42% × 0.38
2022/09/30 10.73% = 27.88% × 0.38
2022/06/30 11.09% = 26.73% × 0.41
2022/03/31 9.67% = 23.42% × 0.41
2021/12/31 9.63% = 24.25% × 0.40
2021/09/30 8.63% = 23.03% × 0.37
2021/06/30 9.61% = 23.80% × 0.40
2021/03/31 11.33% = 29.60% × 0.38
2020/12/31 11.54% = 29.97% × 0.39
2020/09/30 11.37% = 30.91% × 0.37
2020/06/30 11.23% = 31.53% × 0.36
2020/03/31 12.45% = 33.64% × 0.37
2019/12/31 13.13% = 35.32% × 0.37
2019/09/30 = ×
2019/06/30 = ×
2019/03/31 = ×

レポートに基づく: 10-K (報告日: 2023-12-31), 10-Q (報告日: 2023-09-30), 10-Q (報告日: 2023-06-30), 10-Q (報告日: 2023-03-31), 10-K (報告日: 2022-12-31), 10-Q (報告日: 2022-09-30), 10-Q (報告日: 2022-06-30), 10-Q (報告日: 2022-03-31), 10-K (報告日: 2021-12-31), 10-Q (報告日: 2021-09-30), 10-Q (報告日: 2021-06-30), 10-Q (報告日: 2021-03-31), 10-K (報告日: 2020-12-31), 10-Q (報告日: 2020-09-30), 10-Q (報告日: 2020-06-30), 10-Q (報告日: 2020-03-31), 10-K (報告日: 2019-12-31), 10-Q (報告日: 2019-09-30), 10-Q (報告日: 2019-06-30), 10-Q (報告日: 2019-03-31).

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


ROAを4つの要素に分解

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

Microsoft Excel
ROA = 税負担 × 利息負担 × EBITマージン × 資産回転率
2023/12/31 6.91% = 0.86 × 0.73 × 39.87% × 0.28
2023/09/30 8.36% = 0.86 × 0.78 × 43.78% × 0.28
2023/06/30 8.84% = 0.87 × 0.82 × 44.53% × 0.28
2023/03/31 8.92% = 0.87 × 0.85 × 43.21% × 0.28
2022/12/31 10.06% = 0.89 × 0.84 × 35.29% × 0.38
2022/09/30 10.73% = 0.88 × 0.85 × 36.93% × 0.38
2022/06/30 11.09% = 0.88 × 0.86 × 35.55% × 0.41
2022/03/31 9.67% = 0.88 × 0.84 × 31.62% × 0.41
2021/12/31 9.63% = 0.88 × 0.85 × 32.51% × 0.40
2021/09/30 8.63% = 0.87 × 0.85 × 31.31% × 0.37
2021/06/30 9.61% = 0.88 × 0.85 × 31.83% × 0.40
2021/03/31 11.33% = 0.89 × 0.87 × 38.31% × 0.38
2020/12/31 11.54% = 0.89 × 0.87 × 38.76% × 0.39
2020/09/30 11.37% = 0.89 × 0.87 × 39.87% × 0.37
2020/06/30 11.23% = 0.88 × 0.87 × 41.33% × 0.36
2020/03/31 12.45% = 0.87 × 0.87 × 44.43% × 0.37
2019/12/31 13.13% = 0.86 × 0.88 × 46.96% × 0.37
2019/09/30 = × × ×
2019/06/30 = × × ×
2019/03/31 = × × ×

レポートに基づく: 10-K (報告日: 2023-12-31), 10-Q (報告日: 2023-09-30), 10-Q (報告日: 2023-06-30), 10-Q (報告日: 2023-03-31), 10-K (報告日: 2022-12-31), 10-Q (報告日: 2022-09-30), 10-Q (報告日: 2022-06-30), 10-Q (報告日: 2022-03-31), 10-K (報告日: 2021-12-31), 10-Q (報告日: 2021-09-30), 10-Q (報告日: 2021-06-30), 10-Q (報告日: 2021-03-31), 10-K (報告日: 2020-12-31), 10-Q (報告日: 2020-09-30), 10-Q (報告日: 2020-06-30), 10-Q (報告日: 2020-03-31), 10-K (報告日: 2019-12-31), 10-Q (報告日: 2019-09-30), 10-Q (報告日: 2019-06-30), 10-Q (報告日: 2019-03-31).

2023年第4 四半期の総資産利益率(ROA)が低下した主な理由は、EBITマージン率で測定した営業利益率の低下です。


純利益率の分解

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

Microsoft Excel
純利益率 = 税負担 × 利息負担 × EBITマージン
2023/12/31 24.96% = 0.86 × 0.73 × 39.87%
2023/09/30 29.52% = 0.86 × 0.78 × 43.78%
2023/06/30 31.52% = 0.87 × 0.82 × 44.53%
2023/03/31 31.77% = 0.87 × 0.85 × 43.21%
2022/12/31 26.42% = 0.89 × 0.84 × 35.29%
2022/09/30 27.88% = 0.88 × 0.85 × 36.93%
2022/06/30 26.73% = 0.88 × 0.86 × 35.55%
2022/03/31 23.42% = 0.88 × 0.84 × 31.62%
2021/12/31 24.25% = 0.88 × 0.85 × 32.51%
2021/09/30 23.03% = 0.87 × 0.85 × 31.31%
2021/06/30 23.80% = 0.88 × 0.85 × 31.83%
2021/03/31 29.60% = 0.89 × 0.87 × 38.31%
2020/12/31 29.97% = 0.89 × 0.87 × 38.76%
2020/09/30 30.91% = 0.89 × 0.87 × 39.87%
2020/06/30 31.53% = 0.88 × 0.87 × 41.33%
2020/03/31 33.64% = 0.87 × 0.87 × 44.43%
2019/12/31 35.32% = 0.86 × 0.88 × 46.96%
2019/09/30 = × ×
2019/06/30 = × ×
2019/03/31 = × ×

レポートに基づく: 10-K (報告日: 2023-12-31), 10-Q (報告日: 2023-09-30), 10-Q (報告日: 2023-06-30), 10-Q (報告日: 2023-03-31), 10-K (報告日: 2022-12-31), 10-Q (報告日: 2022-09-30), 10-Q (報告日: 2022-06-30), 10-Q (報告日: 2022-03-31), 10-K (報告日: 2021-12-31), 10-Q (報告日: 2021-09-30), 10-Q (報告日: 2021-06-30), 10-Q (報告日: 2021-03-31), 10-K (報告日: 2020-12-31), 10-Q (報告日: 2020-09-30), 10-Q (報告日: 2020-06-30), 10-Q (報告日: 2020-03-31), 10-K (報告日: 2019-12-31), 10-Q (報告日: 2019-09-30), 10-Q (報告日: 2019-06-30), 10-Q (報告日: 2019-03-31).

2023年第4 四半期の純利益率の低下の主な理由は、EBITマージン率で測定した営業利益率の低下です。