Stock Analysis on Net

Home Depot Inc. (NYSE:HD) 

듀퐁 분석: ROE, ROA및 순이익률의 세분화
분기별 데이터

Microsoft Excel

ROE 두 가지 구성 요소로 세분화

Home Depot Inc., ROE 분해 (분기별 데이터)

Microsoft Excel
ROE = ROA × 재무 레버리지 비율
2024. 10. 27. 252.51% = 15.02% × 16.81
2024. 7. 28. 334.21% = 15.25% × 21.91
2024. 4. 28. 817.03% = 18.77% × 43.53
2024. 1. 28. 1,450.48% = 19.79% × 73.30
2023. 10. 29. 1,098.18% = 20.78% × 52.85
2023. 7. 30. 1,215.96% = 21.25% × 57.22
2023. 4. 30. 4,626.24% = 21.92% × 211.01
2023. 1. 29. 1,095.07% = 22.38% × 48.94
2022. 10. 30. 1,317.03% = 22.24% × 59.22
2022. 7. 31. 7,124.47% = 22.27% × 319.94
2022. 5. 1. = 21.57% ×
2022. 1. 30. = 22.86% ×
2021. 10. 31. 1,539.90% = 21.82% × 70.56
2021. 8. 1. 736.64% = 21.54% × 34.20
2021. 5. 2. 844.74% = 20.35% × 41.51
2021. 1. 31. 390.00% = 18.23% × 21.39
2020. 11. 1. 813.68% = 18.66% × 43.60
2020. 8. 2. = 18.67% ×
2020. 5. 3. = 18.68% ×
2020. 2. 2. = 21.94% ×
2019. 11. 3. = 21.23% ×
2019. 8. 4. = 21.54% ×
2019. 5. 5. = 21.80% ×
2019. 2. 3. = 25.27% ×
2018. 10. 28. = × 34.24
2018. 7. 29. = × 23.01
2018. 4. 29. = × 27.65

보고서 기준: 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), 10-K (보고 날짜: 2019-02-03), 10-Q (보고 날짜: 2018-10-28), 10-Q (보고 날짜: 2018-07-29), 10-Q (보고 날짜: 2018-04-29).

2025년 3 분기 대비 주주자본비율(ROE)이 감소하는 주된 이유는 재무적 레버리지 비율의 감소ROE.


ROE 세 가지 구성 요소로 세분화

Home Depot Inc., ROE 분해 (분기별 데이터)

Microsoft Excel
ROE = 순이익률(Net Profit Margin Ratio) × 자산 회전율 × 재무 레버리지 비율
2024. 10. 27. 252.51% = 9.45% × 1.59 × 16.81
2024. 7. 28. 334.21% = 9.71% × 1.57 × 21.91
2024. 4. 28. 817.03% = 9.79% × 1.92 × 43.53
2024. 1. 28. 1,450.48% = 9.92% × 1.99 × 73.30
2023. 10. 29. 1,098.18% = 10.22% × 2.03 × 52.85
2023. 7. 30. 1,215.96% = 10.48% × 2.03 × 57.22
2023. 4. 30. 4,626.24% = 10.75% × 2.04 × 211.01
2023. 1. 29. 1,095.07% = 10.87% × 2.06 × 48.94
2022. 10. 30. 1,317.03% = 10.87% × 2.05 × 59.22
2022. 7. 31. 7,124.47% = 10.88% × 2.05 × 319.94
2022. 5. 1. = 10.83% × 1.99 ×
2022. 1. 30. = 10.87% × 2.10 ×
2021. 10. 31. 1,539.90% = 10.79% × 2.02 × 70.56
2021. 8. 1. 736.64% = 10.55% × 2.04 × 34.20
2021. 5. 2. 844.74% = 10.45% × 1.95 × 41.51
2021. 1. 31. 390.00% = 9.74% × 1.87 × 21.39
2020. 11. 1. 813.68% = 9.94% × 1.88 × 43.60
2020. 8. 2. = 9.91% × 1.88 ×
2020. 5. 3. = 9.79% × 1.91 ×
2020. 2. 2. = 10.20% × 2.15 ×
2019. 11. 3. = 10.01% × 2.12 ×
2019. 8. 4. = 10.18% × 2.12 ×
2019. 5. 5. = 10.24% × 2.13 ×
2019. 2. 3. = 10.28% × 2.46 ×
2018. 10. 28. = × × 34.24
2018. 7. 29. = × × 23.01
2018. 4. 29. = × × 27.65

보고서 기준: 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), 10-K (보고 날짜: 2019-02-03), 10-Q (보고 날짜: 2018-10-28), 10-Q (보고 날짜: 2018-07-29), 10-Q (보고 날짜: 2018-04-29).

2025년 3 분기 대비 주주자본비율(ROE)이 감소하는 주된 이유는 재무적 레버리지 비율의 감소ROE.


ROE를 5개 구성 요소로 세분화

Home Depot Inc., ROE 분해 (분기별 데이터)

Microsoft Excel
ROE = 세금 부담 × 이자 부담 × EBIT 마진 × 자산 회전율 × 재무 레버리지 비율
2024. 10. 27. 252.51% = 0.76 × 0.90 × 13.84% × 1.59 × 16.81
2024. 7. 28. 334.21% = 0.76 × 0.90 × 14.08% × 1.57 × 21.91
2024. 4. 28. 817.03% = 0.76 × 0.91 × 14.11% × 1.92 × 43.53
2024. 1. 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. 7. 30. 1,215.96% = 0.76 × 0.92 × 14.96% × 2.03 × 57.22
2023. 4. 30. 4,626.24% = 0.76 × 0.93 × 15.25% × 2.04 × 211.01
2023. 1. 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. 7. 31. 7,124.47% = 0.76 × 0.94 × 15.33% × 2.05 × 319.94
2022. 5. 1. = 0.76 × 0.94 × 15.23% × 1.99 ×
2022. 1. 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. 8. 1. 736.64% = 0.76 × 0.94 × 14.81% × 2.04 × 34.20
2021. 5. 2. 844.74% = 0.76 × 0.93 × 14.73% × 1.95 × 41.51
2021. 1. 31. 390.00% = 0.76 × 0.93 × 13.87% × 1.87 × 21.39
2020. 11. 1. 813.68% = 0.76 × 0.93 × 14.05% × 1.88 × 43.60
2020. 8. 2. = 0.76 × 0.92 × 14.04% × 1.88 ×
2020. 5. 3. = 0.76 × 0.92 × 13.91% × 1.91 ×
2020. 2. 2. = 0.76 × 0.92 × 14.44% × 2.15 ×
2019. 11. 3. = 0.75 × 0.93 × 14.31% × 2.12 ×
2019. 8. 4. = 0.76 × 0.93 × 14.37% × 2.12 ×
2019. 5. 5. = 0.76 × 0.93 × 14.43% × 2.13 ×
2019. 2. 3. = 0.76 × 0.93 × 14.42% × 2.46 ×
2018. 10. 28. = × × × × 34.24
2018. 7. 29. = × × × × 23.01
2018. 4. 29. = × × × × 27.65

보고서 기준: 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), 10-K (보고 날짜: 2019-02-03), 10-Q (보고 날짜: 2018-10-28), 10-Q (보고 날짜: 2018-07-29), 10-Q (보고 날짜: 2018-04-29).

2025년 3 분기 대비 주주자본비율(ROE)이 감소하는 주된 이유는 재무적 레버리지 비율의 감소ROE.


ROA 두 가지 구성 요소로 세분화

Home Depot Inc., ROA 분해 (분기별 데이터)

Microsoft Excel
ROA = 순이익률(Net Profit Margin Ratio) × 자산 회전율
2024. 10. 27. 15.02% = 9.45% × 1.59
2024. 7. 28. 15.25% = 9.71% × 1.57
2024. 4. 28. 18.77% = 9.79% × 1.92
2024. 1. 28. 19.79% = 9.92% × 1.99
2023. 10. 29. 20.78% = 10.22% × 2.03
2023. 7. 30. 21.25% = 10.48% × 2.03
2023. 4. 30. 21.92% = 10.75% × 2.04
2023. 1. 29. 22.38% = 10.87% × 2.06
2022. 10. 30. 22.24% = 10.87% × 2.05
2022. 7. 31. 22.27% = 10.88% × 2.05
2022. 5. 1. 21.57% = 10.83% × 1.99
2022. 1. 30. 22.86% = 10.87% × 2.10
2021. 10. 31. 21.82% = 10.79% × 2.02
2021. 8. 1. 21.54% = 10.55% × 2.04
2021. 5. 2. 20.35% = 10.45% × 1.95
2021. 1. 31. 18.23% = 9.74% × 1.87
2020. 11. 1. 18.66% = 9.94% × 1.88
2020. 8. 2. 18.67% = 9.91% × 1.88
2020. 5. 3. 18.68% = 9.79% × 1.91
2020. 2. 2. 21.94% = 10.20% × 2.15
2019. 11. 3. 21.23% = 10.01% × 2.12
2019. 8. 4. 21.54% = 10.18% × 2.12
2019. 5. 5. 21.80% = 10.24% × 2.13
2019. 2. 3. 25.27% = 10.28% × 2.46
2018. 10. 28. = ×
2018. 7. 29. = ×
2018. 4. 29. = ×

보고서 기준: 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), 10-K (보고 날짜: 2019-02-03), 10-Q (보고 날짜: 2018-10-28), 10-Q (보고 날짜: 2018-07-29), 10-Q (보고 날짜: 2018-04-29).

2025년 3 분기 자산수익률(ROE)이ROA감소하는 주된 이유는 순이익률로 측정되는 수익성이 감소했기 때문입니다.


ROA를 4개의 구성 요소로 세분화

Home Depot Inc., ROA 분해 (분기별 데이터)

Microsoft Excel
ROA = 세금 부담 × 이자 부담 × EBIT 마진 × 자산 회전율
2024. 10. 27. 15.02% = 0.76 × 0.90 × 13.84% × 1.59
2024. 7. 28. 15.25% = 0.76 × 0.90 × 14.08% × 1.57
2024. 4. 28. 18.77% = 0.76 × 0.91 × 14.11% × 1.92
2024. 1. 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. 7. 30. 21.25% = 0.76 × 0.92 × 14.96% × 2.03
2023. 4. 30. 21.92% = 0.76 × 0.93 × 15.25% × 2.04
2023. 1. 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. 7. 31. 22.27% = 0.76 × 0.94 × 15.33% × 2.05
2022. 5. 1. 21.57% = 0.76 × 0.94 × 15.23% × 1.99
2022. 1. 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. 8. 1. 21.54% = 0.76 × 0.94 × 14.81% × 2.04
2021. 5. 2. 20.35% = 0.76 × 0.93 × 14.73% × 1.95
2021. 1. 31. 18.23% = 0.76 × 0.93 × 13.87% × 1.87
2020. 11. 1. 18.66% = 0.76 × 0.93 × 14.05% × 1.88
2020. 8. 2. 18.67% = 0.76 × 0.92 × 14.04% × 1.88
2020. 5. 3. 18.68% = 0.76 × 0.92 × 13.91% × 1.91
2020. 2. 2. 21.94% = 0.76 × 0.92 × 14.44% × 2.15
2019. 11. 3. 21.23% = 0.75 × 0.93 × 14.31% × 2.12
2019. 8. 4. 21.54% = 0.76 × 0.93 × 14.37% × 2.12
2019. 5. 5. 21.80% = 0.76 × 0.93 × 14.43% × 2.13
2019. 2. 3. 25.27% = 0.76 × 0.93 × 14.42% × 2.46
2018. 10. 28. = × × ×
2018. 7. 29. = × × ×
2018. 4. 29. = × × ×

보고서 기준: 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), 10-K (보고 날짜: 2019-02-03), 10-Q (보고 날짜: 2018-10-28), 10-Q (보고 날짜: 2018-07-29), 10-Q (보고 날짜: 2018-04-29).

2025년 3 분기 자산수익률(ROE)이ROA감소하는 주요 이유는 EBIT 마진 비율로 측정되는 영업 수익성이 감소했기 때문입니다.


순이익률(Net Profit Margin Ratio)의 세분화

Home Depot Inc., 순이익률의 분해(분기별 데이터)

Microsoft Excel
순이익률(Net Profit Margin Ratio) = 세금 부담 × 이자 부담 × EBIT 마진
2024. 10. 27. 9.45% = 0.76 × 0.90 × 13.84%
2024. 7. 28. 9.71% = 0.76 × 0.90 × 14.08%
2024. 4. 28. 9.79% = 0.76 × 0.91 × 14.11%
2024. 1. 28. 9.92% = 0.76 × 0.91 × 14.32%
2023. 10. 29. 10.22% = 0.76 × 0.92 × 14.61%
2023. 7. 30. 10.48% = 0.76 × 0.92 × 14.96%
2023. 4. 30. 10.75% = 0.76 × 0.93 × 15.25%
2023. 1. 29. 10.87% = 0.76 × 0.93 × 15.31%
2022. 10. 30. 10.87% = 0.76 × 0.94 × 15.35%
2022. 7. 31. 10.88% = 0.76 × 0.94 × 15.33%
2022. 5. 1. 10.83% = 0.76 × 0.94 × 15.23%
2022. 1. 30. 10.87% = 0.76 × 0.94 × 15.27%
2021. 10. 31. 10.79% = 0.76 × 0.94 × 15.12%
2021. 8. 1. 10.55% = 0.76 × 0.94 × 14.81%
2021. 5. 2. 10.45% = 0.76 × 0.93 × 14.73%
2021. 1. 31. 9.74% = 0.76 × 0.93 × 13.87%
2020. 11. 1. 9.94% = 0.76 × 0.93 × 14.05%
2020. 8. 2. 9.91% = 0.76 × 0.92 × 14.04%
2020. 5. 3. 9.79% = 0.76 × 0.92 × 13.91%
2020. 2. 2. 10.20% = 0.76 × 0.92 × 14.44%
2019. 11. 3. 10.01% = 0.75 × 0.93 × 14.31%
2019. 8. 4. 10.18% = 0.76 × 0.93 × 14.37%
2019. 5. 5. 10.24% = 0.76 × 0.93 × 14.43%
2019. 2. 3. 10.28% = 0.76 × 0.93 × 14.42%
2018. 10. 28. = × ×
2018. 7. 29. = × ×
2018. 4. 29. = × ×

보고서 기준: 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), 10-K (보고 날짜: 2019-02-03), 10-Q (보고 날짜: 2018-10-28), 10-Q (보고 날짜: 2018-07-29), 10-Q (보고 날짜: 2018-04-29).

2025년 3 분기 동안 순이익률(Net Profit margin Ratio)이 감소하는 주요 이유는 EBIT 마진 비율로 측정되는 영업 수익성이 감소했기 때문입니다.