Stock Analysis on Net
Stock Analysis on Net

Home Depot Inc. (NYSE:HD)

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

Microsoft Excel

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

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

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

Microsoft Excel
ROE = ROA × 財務レバレッジ比率
2025/02/02 222.98% = 15.40% × 14.48
2024/10/27 252.51% = 15.02% × 16.81
2024/07/28 334.21% = 15.25% × 21.91
2024/04/28 817.03% = 18.77% × 43.53
2024/01/28 1,450.48% = 19.79% × 73.30
2023/10/29 1,098.18% = 20.78% × 52.85
2023/07/30 1,215.96% = 21.25% × 57.22
2023/04/30 4,626.24% = 21.92% × 211.01
2023/01/29 1,095.07% = 22.38% × 48.94
2022/10/30 1,317.03% = 22.24% × 59.22
2022/07/31 7,124.47% = 22.27% × 319.94
2022/05/01 — = 21.57% × —
2022/01/30 — = 22.86% × —
2021/10/31 1,539.90% = 21.82% × 70.56
2021/08/01 736.64% = 21.54% × 34.20
2021/05/02 844.74% = 20.35% × 41.51
2021/01/31 390.00% = 18.23% × 21.39
2020/11/01 813.68% = 18.66% × 43.60
2020/08/02 — = 18.67% × —
2020/05/03 — = 18.68% × —
2020/02/02 — = 21.94% × —
2019/11/03 — = — × —
2019/08/04 — = — × —
2019/05/05 — = — × —

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

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

ROEを3つの要素に分解

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

Microsoft Excel
ROE = 純利益率 × 資産回転率 × 財務レバレッジ比率
2025/02/02 222.98% = 9.28% × 1.66 × 14.48
2024/10/27 252.51% = 9.45% × 1.59 × 16.81
2024/07/28 334.21% = 9.71% × 1.57 × 21.91
2024/04/28 817.03% = 9.79% × 1.92 × 43.53
2024/01/28 1,450.48% = 9.92% × 1.99 × 73.30
2023/10/29 1,098.18% = 10.22% × 2.03 × 52.85
2023/07/30 1,215.96% = 10.48% × 2.03 × 57.22
2023/04/30 4,626.24% = 10.75% × 2.04 × 211.01
2023/01/29 1,095.07% = 10.87% × 2.06 × 48.94
2022/10/30 1,317.03% = 10.87% × 2.05 × 59.22
2022/07/31 7,124.47% = 10.88% × 2.05 × 319.94
2022/05/01 — = 10.83% × 1.99 × —
2022/01/30 — = 10.87% × 2.10 × —
2021/10/31 1,539.90% = 10.79% × 2.02 × 70.56
2021/08/01 736.64% = 10.55% × 2.04 × 34.20
2021/05/02 844.74% = 10.45% × 1.95 × 41.51
2021/01/31 390.00% = 9.74% × 1.87 × 21.39
2020/11/01 813.68% = 9.94% × 1.88 × 43.60
2020/08/02 — = 9.91% × 1.88 × —
2020/05/03 — = 9.79% × 1.91 × —
2020/02/02 — = 10.20% × 2.15 × —
2019/11/03 — = — × — × —
2019/08/04 — = — × — × —
2019/05/05 — = — × — × —

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

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

ROEを5つの要素に分解

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

Microsoft Excel
ROE = 税負担 × 利息負担 × EBITマージン × 資産回転率 × 財務レバレッジ比率
2025/02/02 222.98% = 0.76 × 0.89 × 13.62% × 1.66 × 14.48
2024/10/27 252.51% = 0.76 × 0.90 × 13.84% × 1.59 × 16.81
2024/07/28 334.21% = 0.76 × 0.90 × 14.08% × 1.57 × 21.91
2024/04/28 817.03% = 0.76 × 0.91 × 14.11% × 1.92 × 43.53
2024/01/28 1,450.48% = 0.76 × 0.91 × 14.32% × 1.99 × 73.30
2023/10/29 1,098.18% = 0.76 × 0.92 × 14.61% × 2.03 × 52.85
2023/07/30 1,215.96% = 0.76 × 0.92 × 14.96% × 2.03 × 57.22
2023/04/30 4,626.24% = 0.76 × 0.93 × 15.25% × 2.04 × 211.01
2023/01/29 1,095.07% = 0.76 × 0.93 × 15.31% × 2.06 × 48.94
2022/10/30 1,317.03% = 0.76 × 0.94 × 15.35% × 2.05 × 59.22
2022/07/31 7,124.47% = 0.76 × 0.94 × 15.33% × 2.05 × 319.94
2022/05/01 — = 0.76 × 0.94 × 15.23% × 1.99 × —
2022/01/30 — = 0.76 × 0.94 × 15.27% × 2.10 × —
2021/10/31 1,539.90% = 0.76 × 0.94 × 15.12% × 2.02 × 70.56
2021/08/01 736.64% = 0.76 × 0.94 × 14.81% × 2.04 × 34.20
2021/05/02 844.74% = 0.76 × 0.93 × 14.73% × 1.95 × 41.51
2021/01/31 390.00% = 0.76 × 0.93 × 13.87% × 1.87 × 21.39
2020/11/01 813.68% = 0.76 × 0.93 × 14.05% × 1.88 × 43.60
2020/08/02 — = 0.76 × 0.92 × 14.04% × 1.88 × —
2020/05/03 — = 0.76 × 0.92 × 13.91% × 1.91 × —
2020/02/02 — = 0.76 × 0.92 × 14.44% × 2.15 × —
2019/11/03 — = — × — × — × — × —
2019/08/04 — = — × — × — × — × —
2019/05/05 — = — × — × — × — × —

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

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

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

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

Microsoft Excel
ROA = 純利益率 × 資産回転率
2025/02/02 15.40% = 9.28% × 1.66
2024/10/27 15.02% = 9.45% × 1.59
2024/07/28 15.25% = 9.71% × 1.57
2024/04/28 18.77% = 9.79% × 1.92
2024/01/28 19.79% = 9.92% × 1.99
2023/10/29 20.78% = 10.22% × 2.03
2023/07/30 21.25% = 10.48% × 2.03
2023/04/30 21.92% = 10.75% × 2.04
2023/01/29 22.38% = 10.87% × 2.06
2022/10/30 22.24% = 10.87% × 2.05
2022/07/31 22.27% = 10.88% × 2.05
2022/05/01 21.57% = 10.83% × 1.99
2022/01/30 22.86% = 10.87% × 2.10
2021/10/31 21.82% = 10.79% × 2.02
2021/08/01 21.54% = 10.55% × 2.04
2021/05/02 20.35% = 10.45% × 1.95
2021/01/31 18.23% = 9.74% × 1.87
2020/11/01 18.66% = 9.94% × 1.88
2020/08/02 18.67% = 9.91% × 1.88
2020/05/03 18.68% = 9.79% × 1.91
2020/02/02 21.94% = 10.20% × 2.15
2019/11/03 — = — × —
2019/08/04 — = — × —
2019/05/05 — = — × —

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

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

ROAを4つの要素に分解

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

Microsoft Excel
ROA = 税負担 × 利息負担 × EBITマージン × 資産回転率
2025/02/02 15.40% = 0.76 × 0.89 × 13.62% × 1.66
2024/10/27 15.02% = 0.76 × 0.90 × 13.84% × 1.59
2024/07/28 15.25% = 0.76 × 0.90 × 14.08% × 1.57
2024/04/28 18.77% = 0.76 × 0.91 × 14.11% × 1.92
2024/01/28 19.79% = 0.76 × 0.91 × 14.32% × 1.99
2023/10/29 20.78% = 0.76 × 0.92 × 14.61% × 2.03
2023/07/30 21.25% = 0.76 × 0.92 × 14.96% × 2.03
2023/04/30 21.92% = 0.76 × 0.93 × 15.25% × 2.04
2023/01/29 22.38% = 0.76 × 0.93 × 15.31% × 2.06
2022/10/30 22.24% = 0.76 × 0.94 × 15.35% × 2.05
2022/07/31 22.27% = 0.76 × 0.94 × 15.33% × 2.05
2022/05/01 21.57% = 0.76 × 0.94 × 15.23% × 1.99
2022/01/30 22.86% = 0.76 × 0.94 × 15.27% × 2.10
2021/10/31 21.82% = 0.76 × 0.94 × 15.12% × 2.02
2021/08/01 21.54% = 0.76 × 0.94 × 14.81% × 2.04
2021/05/02 20.35% = 0.76 × 0.93 × 14.73% × 1.95
2021/01/31 18.23% = 0.76 × 0.93 × 13.87% × 1.87
2020/11/01 18.66% = 0.76 × 0.93 × 14.05% × 1.88
2020/08/02 18.67% = 0.76 × 0.92 × 14.04% × 1.88
2020/05/03 18.68% = 0.76 × 0.92 × 13.91% × 1.91
2020/02/02 21.94% = 0.76 × 0.92 × 14.44% × 2.15
2019/11/03 — = — × — × — × —
2019/08/04 — = — × — × — × —
2019/05/05 — = — × — × — × —

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

2025年第4 四半期に総資産利益率(ROA)が上昇した主な理由は、資産回転率で測定される効率性の向上です。

当期純利益率の分解

Home Depot Inc.、純利益率の分解(四半期データ)

Microsoft Excel
純利益率 = 税負担 × 利息負担 × EBITマージン
2025/02/02 9.28% = 0.76 × 0.89 × 13.62%
2024/10/27 9.45% = 0.76 × 0.90 × 13.84%
2024/07/28 9.71% = 0.76 × 0.90 × 14.08%
2024/04/28 9.79% = 0.76 × 0.91 × 14.11%
2024/01/28 9.92% = 0.76 × 0.91 × 14.32%
2023/10/29 10.22% = 0.76 × 0.92 × 14.61%
2023/07/30 10.48% = 0.76 × 0.92 × 14.96%
2023/04/30 10.75% = 0.76 × 0.93 × 15.25%
2023/01/29 10.87% = 0.76 × 0.93 × 15.31%
2022/10/30 10.87% = 0.76 × 0.94 × 15.35%
2022/07/31 10.88% = 0.76 × 0.94 × 15.33%
2022/05/01 10.83% = 0.76 × 0.94 × 15.23%
2022/01/30 10.87% = 0.76 × 0.94 × 15.27%
2021/10/31 10.79% = 0.76 × 0.94 × 15.12%
2021/08/01 10.55% = 0.76 × 0.94 × 14.81%
2021/05/02 10.45% = 0.76 × 0.93 × 14.73%
2021/01/31 9.74% = 0.76 × 0.93 × 13.87%
2020/11/01 9.94% = 0.76 × 0.93 × 14.05%
2020/08/02 9.91% = 0.76 × 0.92 × 14.04%
2020/05/03 9.79% = 0.76 × 0.92 × 13.91%
2020/02/02 10.20% = 0.76 × 0.92 × 14.44%
2019/11/03 — = — × — × —
2019/08/04 — = — × — × —
2019/05/05 — = — × — × —

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

2025年第4 四半期から純利益率が低下した主な理由は、EBITマージン率で測定した営業利益率の低下です。