Stock Analysis on Net
Stock Analysis on Net

Oracle Corp. (NYSE:ORCL)

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

Microsoft Excel

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

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

Oracle Corp.、 ROE の分解(四半期データ)

Microsoft Excel
ROE = ROA × 財務レバレッジ比率
2024/02/29 189.26% = 7.76% × 24.38
2023/11/30 262.21% = 7.55% × 34.74
2023/08/31 395.57% = 6.86% × 57.66
2023/05/31 792.45% = 6.33% × 125.24
2023/02/28 — = 6.36% × —
2022/11/30 — = 6.85% × —
2022/08/31 — = 4.46% × —
2022/05/31 — = 6.15% × —
2022/02/28 — = 6.96% × —
2021/11/30 — = 9.60% × —
2021/08/31 — = 11.35% × —
2021/05/31 262.43% = 10.48% × 25.03
2021/02/28 144.16% = 10.86% × 13.27
2020/11/30 131.11% = 9.44% × 13.90
2020/08/31 107.99% = 9.03% × 11.96
2020/05/31 83.94% = 8.78% × 9.56
2020/02/29 75.58% = 11.13% × 6.79
2019/11/30 70.25% = 11.11% × 6.33
2019/08/31 59.43% = 10.31% × 5.76
2019/05/31 50.87% = 10.20% × 4.99
2019/02/28 45.33% = 9.82% × 4.61
2018/11/30 13.02% = 3.36% × 3.87
2018/08/31 10.19% = 3.02% × 3.37
2018/05/31 8.37% = 2.79% × 3.00
2018/02/28 — = — × 2.89
2017/11/30 — = — × 2.48
2017/08/31 — = — × 2.39

レポートに基づく: 10-Q (報告日: 2024-02-29), 10-Q (報告日: 2023-11-30), 10-Q (報告日: 2023-08-31), 10-K (報告日: 2023-05-31), 10-Q (報告日: 2023-02-28), 10-Q (報告日: 2022-11-30), 10-Q (報告日: 2022-08-31), 10-K (報告日: 2022-05-31), 10-Q (報告日: 2022-02-28), 10-Q (報告日: 2021-11-30), 10-Q (報告日: 2021-08-31), 10-K (報告日: 2021-05-31), 10-Q (報告日: 2021-02-28), 10-Q (報告日: 2020-11-30), 10-Q (報告日: 2020-08-31), 10-K (報告日: 2020-05-31), 10-Q (報告日: 2020-02-29), 10-Q (報告日: 2019-11-30), 10-Q (報告日: 2019-08-31), 10-K (報告日: 2019-05-31), 10-Q (報告日: 2019-02-28), 10-Q (報告日: 2018-11-30), 10-Q (報告日: 2018-08-31), 10-K (報告日: 2018-05-31), 10-Q (報告日: 2018-02-28), 10-Q (報告日: 2017-11-30), 10-Q (報告日: 2017-08-31).

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

ROEを3つの要素に分解

Oracle Corp.、 ROE の分解(四半期データ)

Microsoft Excel
ROE = 純利益率 × 資産回転率 × 財務レバレッジ比率
2024/02/29 189.26% = 20.27% × 0.38 × 24.38
2023/11/30 262.21% = 19.63% × 0.38 × 34.74
2023/08/31 395.57% = 18.40% × 0.37 × 57.66
2023/05/31 792.45% = 17.02% × 0.37 × 125.24
2023/02/28 — = 17.46% × 0.36 × —
2022/11/30 — = 19.09% × 0.36 × —
2022/08/31 — = 13.15% × 0.34 × —
2022/05/31 — = 15.83% × 0.39 × —
2022/02/28 — = 18.08% × 0.39 × —
2021/11/30 — = 24.79% × 0.39 × —
2021/08/31 — = 34.16% × 0.33 × —
2021/05/31 262.43% = 33.96% × 0.31 × 25.03
2021/02/28 144.16% = 32.32% × 0.34 × 13.27
2020/11/30 131.11% = 26.34% × 0.36 × 13.90
2020/08/31 107.99% = 26.13% × 0.35 × 11.96
2020/05/31 83.94% = 25.94% × 0.34 × 9.56
2020/02/29 75.58% = 27.06% × 0.41 × 6.79
2019/11/30 70.25% = 27.62% × 0.40 × 6.33
2019/08/31 59.43% = 27.71% × 0.37 × 5.76
2019/05/31 50.87% = 28.05% × 0.36 × 4.99
2019/02/28 45.33% = 27.13% × 0.36 × 4.61
2018/11/30 13.02% = 10.01% × 0.34 × 3.87
2018/08/31 10.19% = 9.74% × 0.31 × 3.37
2018/05/31 8.37% = 9.60% × 0.29 × 3.00
2018/02/28 — = — × — × 2.89
2017/11/30 — = — × — × 2.48
2017/08/31 — = — × — × 2.39

レポートに基づく: 10-Q (報告日: 2024-02-29), 10-Q (報告日: 2023-11-30), 10-Q (報告日: 2023-08-31), 10-K (報告日: 2023-05-31), 10-Q (報告日: 2023-02-28), 10-Q (報告日: 2022-11-30), 10-Q (報告日: 2022-08-31), 10-K (報告日: 2022-05-31), 10-Q (報告日: 2022-02-28), 10-Q (報告日: 2021-11-30), 10-Q (報告日: 2021-08-31), 10-K (報告日: 2021-05-31), 10-Q (報告日: 2021-02-28), 10-Q (報告日: 2020-11-30), 10-Q (報告日: 2020-08-31), 10-K (報告日: 2020-05-31), 10-Q (報告日: 2020-02-29), 10-Q (報告日: 2019-11-30), 10-Q (報告日: 2019-08-31), 10-K (報告日: 2019-05-31), 10-Q (報告日: 2019-02-28), 10-Q (報告日: 2018-11-30), 10-Q (報告日: 2018-08-31), 10-K (報告日: 2018-05-31), 10-Q (報告日: 2018-02-28), 10-Q (報告日: 2017-11-30), 10-Q (報告日: 2017-08-31).

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

ROEを5つの要素に分解

Oracle Corp.、 ROE の分解(四半期データ)

Microsoft Excel
ROE = 税負担 × 利息負担 × EBITマージン × 資産回転率 × 財務レバレッジ比率
2024/02/29 189.26% = 0.96 × 0.76 × 27.91% × 0.38 × 24.38
2023/11/30 262.21% = 0.97 × 0.74 × 27.20% × 0.38 × 34.74
2023/08/31 395.57% = 0.95 × 0.73 × 26.36% × 0.37 × 57.66
2023/05/31 792.45% = 0.93 × 0.72 × 25.29% × 0.37 × 125.24
2023/02/28 — = 0.87 × 0.75 × 26.89% × 0.36 × —
2022/11/30 — = 0.86 × 0.77 × 28.82% × 0.36 × —
2022/08/31 — = 0.88 × 0.70 × 21.43% × 0.34 × —
2022/05/31 — = 0.88 × 0.74 × 24.51% × 0.39 × —
2022/02/28 — = 0.92 × 0.75 × 26.13% × 0.39 × —
2021/11/30 — = 1.19 × 0.76 × 27.25% × 0.39 × —
2021/08/31 — = 1.07 × 0.83 × 38.37% × 0.33 × —
2021/05/31 262.43% = 1.06 × 0.84 × 38.28% × 0.31 × 25.03
2021/02/28 144.16% = 1.02 × 0.84 × 37.58% × 0.34 × 13.27
2020/11/30 131.11% = 0.84 × 0.85 × 37.02% × 0.36 × 13.90
2020/08/31 107.99% = 0.84 × 0.85 × 36.44% × 0.35 × 11.96
2020/05/31 83.94% = 0.84 × 0.86 × 35.98% × 0.34 × 9.56
2020/02/29 75.58% = 0.88 × 0.86 × 35.64% × 0.41 × 6.79
2019/11/30 70.25% = 0.89 × 0.86 × 35.97% × 0.40 × 6.33
2019/08/31 59.43% = 0.90 × 0.86 × 36.07% × 0.37 × 5.76
2019/05/31 50.87% = 0.90 × 0.85 × 36.32% × 0.36 × 4.99
2019/02/28 45.33% = 0.86 × 0.86 × 36.97% × 0.36 × 4.61
2018/11/30 13.02% = 0.31 × 0.86 × 37.41% × 0.34 × 3.87
2018/08/31 10.19% = 0.30 × 0.86 × 37.48% × 0.31 × 3.37
2018/05/31 8.37% = 0.30 × 0.86 × 37.45% × 0.29 × 3.00
2018/02/28 — = — × — × — × — × 2.89
2017/11/30 — = — × — × — × — × 2.48
2017/08/31 — = — × — × — × — × 2.39

レポートに基づく: 10-Q (報告日: 2024-02-29), 10-Q (報告日: 2023-11-30), 10-Q (報告日: 2023-08-31), 10-K (報告日: 2023-05-31), 10-Q (報告日: 2023-02-28), 10-Q (報告日: 2022-11-30), 10-Q (報告日: 2022-08-31), 10-K (報告日: 2022-05-31), 10-Q (報告日: 2022-02-28), 10-Q (報告日: 2021-11-30), 10-Q (報告日: 2021-08-31), 10-K (報告日: 2021-05-31), 10-Q (報告日: 2021-02-28), 10-Q (報告日: 2020-11-30), 10-Q (報告日: 2020-08-31), 10-K (報告日: 2020-05-31), 10-Q (報告日: 2020-02-29), 10-Q (報告日: 2019-11-30), 10-Q (報告日: 2019-08-31), 10-K (報告日: 2019-05-31), 10-Q (報告日: 2019-02-28), 10-Q (報告日: 2018-11-30), 10-Q (報告日: 2018-08-31), 10-K (報告日: 2018-05-31), 10-Q (報告日: 2018-02-28), 10-Q (報告日: 2017-11-30), 10-Q (報告日: 2017-08-31).

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

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

Oracle Corp.、 ROA の分解(四半期データ)

Microsoft Excel
ROA = 純利益率 × 資産回転率
2024/02/29 7.76% = 20.27% × 0.38
2023/11/30 7.55% = 19.63% × 0.38
2023/08/31 6.86% = 18.40% × 0.37
2023/05/31 6.33% = 17.02% × 0.37
2023/02/28 6.36% = 17.46% × 0.36
2022/11/30 6.85% = 19.09% × 0.36
2022/08/31 4.46% = 13.15% × 0.34
2022/05/31 6.15% = 15.83% × 0.39
2022/02/28 6.96% = 18.08% × 0.39
2021/11/30 9.60% = 24.79% × 0.39
2021/08/31 11.35% = 34.16% × 0.33
2021/05/31 10.48% = 33.96% × 0.31
2021/02/28 10.86% = 32.32% × 0.34
2020/11/30 9.44% = 26.34% × 0.36
2020/08/31 9.03% = 26.13% × 0.35
2020/05/31 8.78% = 25.94% × 0.34
2020/02/29 11.13% = 27.06% × 0.41
2019/11/30 11.11% = 27.62% × 0.40
2019/08/31 10.31% = 27.71% × 0.37
2019/05/31 10.20% = 28.05% × 0.36
2019/02/28 9.82% = 27.13% × 0.36
2018/11/30 3.36% = 10.01% × 0.34
2018/08/31 3.02% = 9.74% × 0.31
2018/05/31 2.79% = 9.60% × 0.29
2018/02/28 — = — × —
2017/11/30 — = — × —
2017/08/31 — = — × —

レポートに基づく: 10-Q (報告日: 2024-02-29), 10-Q (報告日: 2023-11-30), 10-Q (報告日: 2023-08-31), 10-K (報告日: 2023-05-31), 10-Q (報告日: 2023-02-28), 10-Q (報告日: 2022-11-30), 10-Q (報告日: 2022-08-31), 10-K (報告日: 2022-05-31), 10-Q (報告日: 2022-02-28), 10-Q (報告日: 2021-11-30), 10-Q (報告日: 2021-08-31), 10-K (報告日: 2021-05-31), 10-Q (報告日: 2021-02-28), 10-Q (報告日: 2020-11-30), 10-Q (報告日: 2020-08-31), 10-K (報告日: 2020-05-31), 10-Q (報告日: 2020-02-29), 10-Q (報告日: 2019-11-30), 10-Q (報告日: 2019-08-31), 10-K (報告日: 2019-05-31), 10-Q (報告日: 2019-02-28), 10-Q (報告日: 2018-11-30), 10-Q (報告日: 2018-08-31), 10-K (報告日: 2018-05-31), 10-Q (報告日: 2018-02-28), 10-Q (報告日: 2017-11-30), 10-Q (報告日: 2017-08-31).

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

ROAを4つの要素に分解

Oracle Corp.、 ROA の分解(四半期データ)

Microsoft Excel
ROA = 税負担 × 利息負担 × EBITマージン × 資産回転率
2024/02/29 7.76% = 0.96 × 0.76 × 27.91% × 0.38
2023/11/30 7.55% = 0.97 × 0.74 × 27.20% × 0.38
2023/08/31 6.86% = 0.95 × 0.73 × 26.36% × 0.37
2023/05/31 6.33% = 0.93 × 0.72 × 25.29% × 0.37
2023/02/28 6.36% = 0.87 × 0.75 × 26.89% × 0.36
2022/11/30 6.85% = 0.86 × 0.77 × 28.82% × 0.36
2022/08/31 4.46% = 0.88 × 0.70 × 21.43% × 0.34
2022/05/31 6.15% = 0.88 × 0.74 × 24.51% × 0.39
2022/02/28 6.96% = 0.92 × 0.75 × 26.13% × 0.39
2021/11/30 9.60% = 1.19 × 0.76 × 27.25% × 0.39
2021/08/31 11.35% = 1.07 × 0.83 × 38.37% × 0.33
2021/05/31 10.48% = 1.06 × 0.84 × 38.28% × 0.31
2021/02/28 10.86% = 1.02 × 0.84 × 37.58% × 0.34
2020/11/30 9.44% = 0.84 × 0.85 × 37.02% × 0.36
2020/08/31 9.03% = 0.84 × 0.85 × 36.44% × 0.35
2020/05/31 8.78% = 0.84 × 0.86 × 35.98% × 0.34
2020/02/29 11.13% = 0.88 × 0.86 × 35.64% × 0.41
2019/11/30 11.11% = 0.89 × 0.86 × 35.97% × 0.40
2019/08/31 10.31% = 0.90 × 0.86 × 36.07% × 0.37
2019/05/31 10.20% = 0.90 × 0.85 × 36.32% × 0.36
2019/02/28 9.82% = 0.86 × 0.86 × 36.97% × 0.36
2018/11/30 3.36% = 0.31 × 0.86 × 37.41% × 0.34
2018/08/31 3.02% = 0.30 × 0.86 × 37.48% × 0.31
2018/05/31 2.79% = 0.30 × 0.86 × 37.45% × 0.29
2018/02/28 — = — × — × — × —
2017/11/30 — = — × — × — × —
2017/08/31 — = — × — × — × —

レポートに基づく: 10-Q (報告日: 2024-02-29), 10-Q (報告日: 2023-11-30), 10-Q (報告日: 2023-08-31), 10-K (報告日: 2023-05-31), 10-Q (報告日: 2023-02-28), 10-Q (報告日: 2022-11-30), 10-Q (報告日: 2022-08-31), 10-K (報告日: 2022-05-31), 10-Q (報告日: 2022-02-28), 10-Q (報告日: 2021-11-30), 10-Q (報告日: 2021-08-31), 10-K (報告日: 2021-05-31), 10-Q (報告日: 2021-02-28), 10-Q (報告日: 2020-11-30), 10-Q (報告日: 2020-08-31), 10-K (報告日: 2020-05-31), 10-Q (報告日: 2020-02-29), 10-Q (報告日: 2019-11-30), 10-Q (報告日: 2019-08-31), 10-K (報告日: 2019-05-31), 10-Q (報告日: 2019-02-28), 10-Q (報告日: 2018-11-30), 10-Q (報告日: 2018-08-31), 10-K (報告日: 2018-05-31), 10-Q (報告日: 2018-02-28), 10-Q (報告日: 2017-11-30), 10-Q (報告日: 2017-08-31).

2024年第3 四半期の総資産利益率(ROA)が上昇した主な理由は、EBITマージン率で測定した営業利益率の増加です。

純利益率の分解

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

Microsoft Excel
純利益率 = 税負担 × 利息負担 × EBITマージン
2024/02/29 20.27% = 0.96 × 0.76 × 27.91%
2023/11/30 19.63% = 0.97 × 0.74 × 27.20%
2023/08/31 18.40% = 0.95 × 0.73 × 26.36%
2023/05/31 17.02% = 0.93 × 0.72 × 25.29%
2023/02/28 17.46% = 0.87 × 0.75 × 26.89%
2022/11/30 19.09% = 0.86 × 0.77 × 28.82%
2022/08/31 13.15% = 0.88 × 0.70 × 21.43%
2022/05/31 15.83% = 0.88 × 0.74 × 24.51%
2022/02/28 18.08% = 0.92 × 0.75 × 26.13%
2021/11/30 24.79% = 1.19 × 0.76 × 27.25%
2021/08/31 34.16% = 1.07 × 0.83 × 38.37%
2021/05/31 33.96% = 1.06 × 0.84 × 38.28%
2021/02/28 32.32% = 1.02 × 0.84 × 37.58%
2020/11/30 26.34% = 0.84 × 0.85 × 37.02%
2020/08/31 26.13% = 0.84 × 0.85 × 36.44%
2020/05/31 25.94% = 0.84 × 0.86 × 35.98%
2020/02/29 27.06% = 0.88 × 0.86 × 35.64%
2019/11/30 27.62% = 0.89 × 0.86 × 35.97%
2019/08/31 27.71% = 0.90 × 0.86 × 36.07%
2019/05/31 28.05% = 0.90 × 0.85 × 36.32%
2019/02/28 27.13% = 0.86 × 0.86 × 36.97%
2018/11/30 10.01% = 0.31 × 0.86 × 37.41%
2018/08/31 9.74% = 0.30 × 0.86 × 37.48%
2018/05/31 9.60% = 0.30 × 0.86 × 37.45%
2018/02/28 — = — × — × —
2017/11/30 — = — × — × —
2017/08/31 — = — × — × —

レポートに基づく: 10-Q (報告日: 2024-02-29), 10-Q (報告日: 2023-11-30), 10-Q (報告日: 2023-08-31), 10-K (報告日: 2023-05-31), 10-Q (報告日: 2023-02-28), 10-Q (報告日: 2022-11-30), 10-Q (報告日: 2022-08-31), 10-K (報告日: 2022-05-31), 10-Q (報告日: 2022-02-28), 10-Q (報告日: 2021-11-30), 10-Q (報告日: 2021-08-31), 10-K (報告日: 2021-05-31), 10-Q (報告日: 2021-02-28), 10-Q (報告日: 2020-11-30), 10-Q (報告日: 2020-08-31), 10-K (報告日: 2020-05-31), 10-Q (報告日: 2020-02-29), 10-Q (報告日: 2019-11-30), 10-Q (報告日: 2019-08-31), 10-K (報告日: 2019-05-31), 10-Q (報告日: 2019-02-28), 10-Q (報告日: 2018-11-30), 10-Q (報告日: 2018-08-31), 10-K (報告日: 2018-05-31), 10-Q (報告日: 2018-02-28), 10-Q (報告日: 2017-11-30), 10-Q (報告日: 2017-08-31).

2024年第3 四半期の純利益率が上昇した主な理由は、EBITマージン率で測定した営業利益率の増加です。