Stock Analysis on Net
Stock Analysis on Net

Alphabet Inc. (NASDAQ:GOOG)

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

Microsoft Excel

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

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

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

Microsoft Excel
ROE = ROA × 財務レバレッジ比率
2024/12/31 30.80% = 22.24% × 1.39
2024/09/30 30.01% = 21.91% × 1.37
2024/06/30 29.15% = 21.13% × 1.38
2024/03/31 28.14% = 20.23% × 1.39
2023/12/31 26.04% = 18.34% × 1.42
2023/09/30 24.43% = 16.82% × 1.45
2023/06/30 22.82% = 15.91% × 1.43
2023/03/31 22.46% = 15.86% × 1.42
2022/12/31 23.41% = 16.42% × 1.43
2022/09/30 26.41% = 18.70% × 1.41
2022/06/30 28.20% = 20.28% × 1.39
2022/03/31 29.35% = 20.87% × 1.41
2021/12/31 30.22% = 21.16% × 1.43
2021/09/30 28.87% = 20.33% × 1.42
2021/06/30 26.49% = 18.76% × 1.41
2021/03/31 22.33% = 15.70% × 1.42
2020/12/31 18.09% = 12.60% × 1.44
2020/09/30 — = — × 1.41
2020/06/30 — = — × 1.34
2020/03/31 — = — × 1.34

レポートに基づく: 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).

2024年第4 四半期の株主資本利益率(ROE)が上昇した主な理由は、総資産利益率(ROA)で測定される収益性の向上です。

ROEを3つの要素に分解

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

Microsoft Excel
ROE = 純利益率 × 資産回転率 × 財務レバレッジ比率
2024/12/31 30.80% = 28.60% × 0.78 × 1.39
2024/09/30 30.01% = 27.74% × 0.79 × 1.37
2024/06/30 29.15% = 26.70% × 0.79 × 1.38
2024/03/31 28.14% = 25.90% × 0.78 × 1.39
2023/12/31 26.04% = 24.01% × 0.76 × 1.42
2023/09/30 24.43% = 22.46% × 0.75 × 1.45
2023/06/30 22.82% = 21.05% × 0.76 × 1.43
2023/03/31 22.46% = 20.58% × 0.77 × 1.42
2022/12/31 23.41% = 21.20% × 0.77 × 1.43
2022/09/30 26.41% = 23.75% × 0.79 × 1.41
2022/06/30 28.20% = 25.89% × 0.78 × 1.39
2022/03/31 29.35% = 27.57% × 0.76 × 1.41
2021/12/31 30.22% = 29.51% × 0.72 × 1.43
2021/09/30 28.87% = 29.52% × 0.69 × 1.42
2021/06/30 26.49% = 28.57% × 0.66 × 1.41
2021/03/31 22.33% = 26.11% × 0.60 × 1.42
2020/12/31 18.09% = 22.06% × 0.57 × 1.44
2020/09/30 — = — × — × 1.41
2020/06/30 — = — × — × 1.34
2020/03/31 — = — × — × 1.34

レポートに基づく: 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).

2024年第4 四半期の株主資本利益率(ROE)が上昇した主な理由は、純利益率で測定される収益性の向上です。

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

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

Microsoft Excel
ROA = 純利益率 × 資産回転率
2024/12/31 22.24% = 28.60% × 0.78
2024/09/30 21.91% = 27.74% × 0.79
2024/06/30 21.13% = 26.70% × 0.79
2024/03/31 20.23% = 25.90% × 0.78
2023/12/31 18.34% = 24.01% × 0.76
2023/09/30 16.82% = 22.46% × 0.75
2023/06/30 15.91% = 21.05% × 0.76
2023/03/31 15.86% = 20.58% × 0.77
2022/12/31 16.42% = 21.20% × 0.77
2022/09/30 18.70% = 23.75% × 0.79
2022/06/30 20.28% = 25.89% × 0.78
2022/03/31 20.87% = 27.57% × 0.76
2021/12/31 21.16% = 29.51% × 0.72
2021/09/30 20.33% = 29.52% × 0.69
2021/06/30 18.76% = 28.57% × 0.66
2021/03/31 15.70% = 26.11% × 0.60
2020/12/31 12.60% = 22.06% × 0.57
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).

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