Stock Analysis on Net
Stock Analysis on Net

Eli Lilly & Co. (NYSE:LLY)

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

Microsoft Excel

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

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

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

Microsoft Excel
ROE = ROA × 財務レバレッジ比率
2025/03/31 70.45% = 12.42% × 5.67
2024/12/31 74.62% = 13.45% × 5.55
2024/09/30 58.78% = 11.07% × 5.31
2024/06/30 54.14% = 10.22% × 5.30
2024/03/31 47.91% = 9.60% × 4.99
2023/12/31 48.65% = 8.19% × 5.94
2023/09/30 44.46% = 8.61% × 5.16
2023/06/30 58.73% = 11.85% × 4.95
2023/03/31 50.82% = 10.70% × 4.75
2022/12/31 58.64% = 12.62% × 4.65
2022/09/30 59.91% = 12.71% × 4.71
2022/06/30 66.61% = 12.09% × 5.51
2022/03/31 65.69% = 13.06% × 5.03
2021/12/31 62.16% = 11.44% × 5.44
2021/09/30 76.99% = 12.39% × 6.21
2021/06/30 94.20% = 12.70% × 7.42
2021/03/31 88.31% = 13.01% × 6.79
2020/12/31 109.79% = 13.28% × 8.27
2020/09/30 — = — × 9.10
2020/06/30 — = — × 10.25
2020/03/31 — = — × 13.35

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

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

ROEを3つの要素に分解

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

Microsoft Excel
ROE = 純利益率 × 資産回転率 × 財務レバレッジ比率
2025/03/31 70.45% = 22.66% × 0.55 × 5.67
2024/12/31 74.62% = 23.51% × 0.57 × 5.55
2024/09/30 58.78% = 20.48% × 0.54 × 5.31
2024/06/30 54.14% = 18.86% × 0.54 × 5.30
2024/03/31 47.91% = 17.08% × 0.56 × 4.99
2023/12/31 48.65% = 15.36% × 0.53 × 5.94
2023/09/30 44.46% = 15.55% × 0.55 × 5.16
2023/06/30 58.73% = 22.01% × 0.54 × 4.95
2023/03/31 50.82% = 20.54% × 0.52 × 4.75
2022/12/31 58.64% = 21.88% × 0.58 × 4.65
2022/09/30 59.91% = 20.63% × 0.62 × 4.71
2022/06/30 66.61% = 19.58% × 0.62 × 5.51
2022/03/31 65.69% = 20.90% × 0.62 × 5.03
2021/12/31 62.16% = 19.71% × 0.58 × 5.44
2021/09/30 76.99% = 21.52% × 0.58 × 6.21
2021/06/30 94.20% = 22.71% × 0.56 × 7.42
2021/03/31 88.31% = 23.91% × 0.54 × 6.79
2020/12/31 109.79% = 25.24% × 0.53 × 8.27
2020/09/30 — = — × — × 9.10
2020/06/30 — = — × — × 10.25
2020/03/31 — = — × — × 13.35

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

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

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

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

Microsoft Excel
ROA = 純利益率 × 資産回転率
2025/03/31 12.42% = 22.66% × 0.55
2024/12/31 13.45% = 23.51% × 0.57
2024/09/30 11.07% = 20.48% × 0.54
2024/06/30 10.22% = 18.86% × 0.54
2024/03/31 9.60% = 17.08% × 0.56
2023/12/31 8.19% = 15.36% × 0.53
2023/09/30 8.61% = 15.55% × 0.55
2023/06/30 11.85% = 22.01% × 0.54
2023/03/31 10.70% = 20.54% × 0.52
2022/12/31 12.62% = 21.88% × 0.58
2022/09/30 12.71% = 20.63% × 0.62
2022/06/30 12.09% = 19.58% × 0.62
2022/03/31 13.06% = 20.90% × 0.62
2021/12/31 11.44% = 19.71% × 0.58
2021/09/30 12.39% = 21.52% × 0.58
2021/06/30 12.70% = 22.71% × 0.56
2021/03/31 13.01% = 23.91% × 0.54
2020/12/31 13.28% = 25.24% × 0.53
2020/09/30 — = — × —
2020/06/30 — = — × —
2020/03/31 — = — × —

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

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