Stock Analysis on Net
Stock Analysis on Net

Bristol-Myers Squibb Co. (NYSE:BMY)

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

Microsoft Excel

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

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

Bristol-Myers Squibb Co.、 ROE の分解(四半期データ)

Microsoft Excel
ROE = ROA × 財務レバレッジ比率
2024/12/31 -54.78% = -9.66% × 5.67
2024/09/30 -42.34% = -7.75% × 5.46
2024/06/30 -38.44% = -6.91% × 5.56
2024/03/31 -37.28% = -6.21% × 6.01
2023/12/31 27.27% = 8.43% × 3.23
2023/09/30 28.57% = 9.08% × 3.15
2023/06/30 24.91% = 8.52% × 2.92
2023/03/31 22.97% = 7.75% × 2.96
2022/12/31 20.37% = 6.53% × 3.12
2022/09/30 20.44% = 6.80% × 3.01
2022/06/30 20.30% = 6.59% × 3.08
2022/03/31 19.79% = 6.07% × 3.26
2021/12/31 19.46% = 6.40% × 3.04
2021/09/30 -14.52% = -4.87% × 2.98
2021/06/30 -13.80% = -4.58% × 3.01
2021/03/31 -16.54% = -5.53% × 2.99
2020/12/31 -23.84% = -7.61% × 3.13
2020/09/30 — = — × 2.50
2020/06/30 — = — × 2.61
2020/03/31 — = — × 2.59

レポートに基づく: 10-K (報告日: 2024-12-31), 10-Q (報告日: 2024-09-30), 10-Q (報告日: 2024-06-30), 10-Q (報告日: 2024-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).

ROEを3つの要素に分解

Bristol-Myers Squibb Co.、 ROE の分解(四半期データ)

Microsoft Excel
ROE = 純利益率 × 資産回転率 × 財務レバレッジ比率
2024/12/31 -54.78% = -18.53% × 0.52 × 5.67
2024/09/30 -42.34% = -15.30% × 0.51 × 5.46
2024/06/30 -38.44% = -14.06% × 0.49 × 5.56
2024/03/31 -37.28% = -13.50% × 0.46 × 6.01
2023/12/31 27.27% = 17.83% × 0.47 × 3.23
2023/09/30 28.57% = 18.44% × 0.49 × 3.15
2023/06/30 24.91% = 17.62% × 0.48 × 2.92
2023/03/31 22.97% = 15.95% × 0.49 × 2.96
2022/12/31 20.37% = 13.71% × 0.48 × 3.12
2022/09/30 20.44% = 14.29% × 0.48 × 3.01
2022/06/30 20.30% = 14.04% × 0.47 × 3.08
2022/03/31 19.79% = 13.31% × 0.46 × 3.26
2021/12/31 19.46% = 15.08% × 0.42 × 3.04
2021/09/30 -14.52% = -11.89% × 0.41 × 2.98
2021/06/30 -13.80% = -11.44% × 0.40 × 3.01
2021/03/31 -16.54% = -14.53% × 0.38 × 2.99
2020/12/31 -23.84% = -21.20% × 0.36 × 3.13
2020/09/30 — = — × — × 2.50
2020/06/30 — = — × — × 2.61
2020/03/31 — = — × — × 2.59

レポートに基づく: 10-K (報告日: 2024-12-31), 10-Q (報告日: 2024-09-30), 10-Q (報告日: 2024-06-30), 10-Q (報告日: 2024-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).

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

Bristol-Myers Squibb Co.、 ROA の分解(四半期データ)

Microsoft Excel
ROA = 純利益率 × 資産回転率
2024/12/31 -9.66% = -18.53% × 0.52
2024/09/30 -7.75% = -15.30% × 0.51
2024/06/30 -6.91% = -14.06% × 0.49
2024/03/31 -6.21% = -13.50% × 0.46
2023/12/31 8.43% = 17.83% × 0.47
2023/09/30 9.08% = 18.44% × 0.49
2023/06/30 8.52% = 17.62% × 0.48
2023/03/31 7.75% = 15.95% × 0.49
2022/12/31 6.53% = 13.71% × 0.48
2022/09/30 6.80% = 14.29% × 0.48
2022/06/30 6.59% = 14.04% × 0.47
2022/03/31 6.07% = 13.31% × 0.46
2021/12/31 6.40% = 15.08% × 0.42
2021/09/30 -4.87% = -11.89% × 0.41
2021/06/30 -4.58% = -11.44% × 0.40
2021/03/31 -5.53% = -14.53% × 0.38
2020/12/31 -7.61% = -21.20% × 0.36
2020/09/30 — = — × —
2020/06/30 — = — × —
2020/03/31 — = — × —

レポートに基づく: 10-K (報告日: 2024-12-31), 10-Q (報告日: 2024-09-30), 10-Q (報告日: 2024-06-30), 10-Q (報告日: 2024-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).