Stock Analysis on Net
Stock Analysis on Net

Dell Technologies Inc. (NYSE:DELL)

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

Microsoft Excel

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

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

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

Microsoft Excel
ROE = ROA × 財務レバレッジ比率
2025/01/31 — = 5.76% × —
2024/11/01 — = 5.00% × —
2024/08/02 — = 4.80% × —
2024/05/03 — = 4.47% × —
2024/02/02 — = 3.91% × —
2023/11/03 — = 3.20% × —
2023/08/04 — = 2.22% × —
2023/05/05 — = 2.32% × —
2023/02/03 — = 2.73% × —
2022/10/28 — = 2.15% × —
2022/07/29 — = 6.11% × —
2022/04/29 — = 6.50% × —
2022/01/28 — = 6.00% × —
2021/10/29 75.81% = 5.00% × 15.15
2021/07/30 78.28% = 3.08% × 25.43
2021/04/30 114.54% = 3.28% × 34.92
2021/01/29 131.10% = 2.63% × 49.78
2020/10/30 275.31% = 2.04% × 134.71
2020/07/31 — = 1.73% × —
2020/05/01 — = 3.71% × —
2020/01/31 — = 3.88% × —
2019/11/01 — = — × —
2019/08/02 — = — × —
2019/05/03 — = — × —

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

ROEを3つの要素に分解

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

Microsoft Excel
ROE = 純利益率 × 資産回転率 × 財務レバレッジ比率
2025/01/31 — = 4.81% × 1.20 × —
2024/11/01 — = 4.36% × 1.15 × —
2024/08/02 — = 4.32% × 1.11 × —
2024/05/03 — = 4.00% × 1.12 × —
2024/02/02 — = 3.63% × 1.08 × —
2023/11/03 — = 2.92% × 1.09 × —
2023/08/04 — = 2.03% × 1.09 × —
2023/05/05 — = 2.01% × 1.15 × —
2023/02/03 — = 2.39% × 1.14 × —
2022/10/28 — = 1.74% × 1.24 × —
2022/07/29 — = 5.07% × 1.20 × —
2022/04/29 — = 5.49% × 1.18 × —
2022/01/28 — = 5.50% × 1.09 × —
2021/10/29 75.81% = 6.83% × 0.73 × 15.15
2021/07/30 78.28% = 3.92% × 0.79 × 25.43
2021/04/30 114.54% = 4.21% × 0.78 × 34.92
2021/01/29 131.10% = 3.45% × 0.76 × 49.78
2020/10/30 275.31% = 2.64% × 0.77 × 134.71
2020/07/31 — = 2.29% × 0.75 × —
2020/05/01 — = 4.85% × 0.77 × —
2020/01/31 — = 5.01% × 0.78 × —
2019/11/01 — = — × — × —
2019/08/02 — = — × — × —
2019/05/03 — = — × — × —

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

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

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

Microsoft Excel
ROA = 純利益率 × 資産回転率
2025/01/31 5.76% = 4.81% × 1.20
2024/11/01 5.00% = 4.36% × 1.15
2024/08/02 4.80% = 4.32% × 1.11
2024/05/03 4.47% = 4.00% × 1.12
2024/02/02 3.91% = 3.63% × 1.08
2023/11/03 3.20% = 2.92% × 1.09
2023/08/04 2.22% = 2.03% × 1.09
2023/05/05 2.32% = 2.01% × 1.15
2023/02/03 2.73% = 2.39% × 1.14
2022/10/28 2.15% = 1.74% × 1.24
2022/07/29 6.11% = 5.07% × 1.20
2022/04/29 6.50% = 5.49% × 1.18
2022/01/28 6.00% = 5.50% × 1.09
2021/10/29 5.00% = 6.83% × 0.73
2021/07/30 3.08% = 3.92% × 0.79
2021/04/30 3.28% = 4.21% × 0.78
2021/01/29 2.63% = 3.45% × 0.76
2020/10/30 2.04% = 2.64% × 0.77
2020/07/31 1.73% = 2.29% × 0.75
2020/05/01 3.71% = 4.85% × 0.77
2020/01/31 3.88% = 5.01% × 0.78
2019/11/01 — = — × —
2019/08/02 — = — × —
2019/05/03 — = — × —

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

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