Stock Analysis on Net
Stock Analysis on Net

Merck & Co. Inc. (NYSE:MRK)

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

Microsoft Excel

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

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

Merck & Co. Inc.、 ROE の分解(四半期データ)

Microsoft Excel
ROE = ROA × 財務レバレッジ比率
2025/09/30 36.71% = 14.69% × 2.50
2025/06/30 33.49% = 13.96% × 2.40
2025/03/31 36.07% = 15.14% × 2.38
2024/12/31 36.96% = 14.62% × 2.53
2024/09/30 27.30% = 10.34% × 2.64
2024/06/30 31.52% = 12.20% × 2.58
2024/03/31 5.71% = 2.18% × 2.62
2023/12/31 0.97% = 0.34% × 2.84
2023/09/30 11.17% = 4.32% × 2.59
2023/06/30 8.04% = 2.98% × 2.70
2023/03/31 27.82% = 12.09% × 2.30
2022/12/31 31.57% = 13.30% × 2.37
2022/09/30 34.32% = 14.25% × 2.41
2022/06/30 38.34% = 15.48% × 2.48
2022/03/31 34.68% = 13.29% × 2.61
2021/12/31 34.17% = 12.35% × 2.77
2021/09/30 20.10% = 7.70% × 2.61
2021/06/30 16.73% = 6.14% × 2.72
2021/03/31 26.08% = 7.73% × 3.37

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

ROEを3つの要素に分解

Merck & Co. Inc.、 ROE の分解(四半期データ)

Microsoft Excel
ROE = 純利益率 × 資産回転率 × 財務レバレッジ比率
2025/09/30 36.71% = 29.63% × 0.50 × 2.50
2025/06/30 33.49% = 25.79% × 0.54 × 2.40
2025/03/31 36.07% = 27.27% × 0.56 × 2.38
2024/12/31 36.96% = 26.68% × 0.55 × 2.53
2024/09/30 27.30% = 19.23% × 0.54 × 2.64
2024/06/30 31.52% = 21.98% × 0.55 × 2.58
2024/03/31 5.71% = 3.76% × 0.58 × 2.62
2023/12/31 0.97% = 0.61% × 0.56 × 2.84
2023/09/30 11.17% = 7.77% × 0.56 × 2.59
2023/06/30 8.04% = 5.34% × 0.56 × 2.70
2023/03/31 27.82% = 22.52% × 0.54 × 2.30
2022/12/31 31.57% = 24.49% × 0.54 × 2.37
2022/09/30 34.32% = 25.88% × 0.55 × 2.41
2022/06/30 38.34% = 29.00% × 0.53 × 2.48
2022/03/31 34.68% = 26.27% × 0.51 × 2.61
2021/12/31 34.17% = 26.79% × 0.46 × 2.77
2021/09/30 20.10% = 15.09% × 0.51 × 2.61
2021/06/30 16.73% = 11.83% × 0.52 × 2.72
2021/03/31 26.08% = 15.09% × 0.51 × 3.37

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

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

Merck & Co. Inc.、 ROA の分解(四半期データ)

Microsoft Excel
ROA = 純利益率 × 資産回転率
2025/09/30 14.69% = 29.63% × 0.50
2025/06/30 13.96% = 25.79% × 0.54
2025/03/31 15.14% = 27.27% × 0.56
2024/12/31 14.62% = 26.68% × 0.55
2024/09/30 10.34% = 19.23% × 0.54
2024/06/30 12.20% = 21.98% × 0.55
2024/03/31 2.18% = 3.76% × 0.58
2023/12/31 0.34% = 0.61% × 0.56
2023/09/30 4.32% = 7.77% × 0.56
2023/06/30 2.98% = 5.34% × 0.56
2023/03/31 12.09% = 22.52% × 0.54
2022/12/31 13.30% = 24.49% × 0.54
2022/09/30 14.25% = 25.88% × 0.55
2022/06/30 15.48% = 29.00% × 0.53
2022/03/31 13.29% = 26.27% × 0.51
2021/12/31 12.35% = 26.79% × 0.46
2021/09/30 7.70% = 15.09% × 0.51
2021/06/30 6.14% = 11.83% × 0.52
2021/03/31 7.73% = 15.09% × 0.51

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