Stock Analysis on Net

Lowe’s Cos. Inc. (NYSE:LOW)

듀폰 분석: ROE, ROA, 당기순이익비율 의 분리 
분기별 데이터

Microsoft Excel

ROE 분리를 두 구성 요소로 분리

Lowe’s Cos. Inc., ROE 분해 (분기별 데이터)

Microsoft Excel
ROE = ROA × 재무 레버리지 비율
2022. 7. 29. = 18.04% ×
2022. 4. 29. = 17.00% ×
2022. 1. 28. = 18.91% ×
2021. 10. 29. = 16.63% ×
2021. 7. 30. = 14.19% ×
2021. 4. 30. 1,532.36% = 13.32% × 115.06
2021. 1. 29. 406.05% = 12.49% × 32.52
2020. 10. 30. 131.77% = 10.55% × 12.49
2020. 7. 31. 131.40% = 11.06% × 11.88
2020. 5. 1. 266.43% = 9.98% × 26.71
2020. 1. 31. 217.09% = 10.85% × 20.02
2019. 11. 1. 119.93% = 7.41% × 16.18
2019. 8. 2. 95.76% = 6.21% × 15.41
2019. 5. 3. 73.30% = 5.49% × 13.36
2019. 2. 1. 63.50% = 6.71% × 9.47
2018. 11. 2. 68.43% = 10.05% × 6.81
2018. 8. 3. 68.05% = 10.60% × 6.42
2018. 5. 4. 66.72% = 10.02% × 6.66
2018. 2. 2. 58.69% = 9.77% × 6.01
2017. 11. 3. 61.93% = 9.67% × 6.41
2017. 8. 4. 55.33% = 8.35% × 6.62
2017. 5. 5. 50.82% = 7.47% × 6.80
2017. 2. 3. 48.07% = 8.99% × 5.35
2016. 10. 28. = × 5.36
2016. 7. 29. = × 5.28
2016. 4. 29. = × 5.15

보고서 기반: 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), 10-K (보고 날짜: 2019-02-01), 10-Q (보고 날짜: 2018-11-02), 10-Q (보고 날짜: 2018-08-03), 10-Q (보고 날짜: 2018-05-04), 10-K (보고 날짜: 2018-02-02), 10-Q (보고 날짜: 2017-11-03), 10-Q (보고 날짜: 2017-08-04), 10-Q (보고 날짜: 2017-05-05), 10-K (보고 날짜: 2017-02-03), 10-Q (보고 날짜: 2016-10-28), 10-Q (보고 날짜: 2016-07-29), 10-Q (보고 날짜: 2016-04-29).


ROE 분리하여 세 가지 구성 요소로 분리

Lowe’s Cos. Inc., ROE 분해 (분기별 데이터)

Microsoft Excel
ROE = 순이익률 × 자산 회전율 × 재무 레버리지 비율
2022. 7. 29. = 8.84% × 2.04 ×
2022. 4. 29. = 8.85% × 1.92 ×
2022. 1. 28. = 8.77% × 2.16 ×
2021. 10. 29. = 8.63% × 1.93 ×
2021. 7. 30. = 7.41% × 1.92 ×
2021. 4. 30. 1,532.36% = 7.23% × 1.84 × 115.06
2021. 1. 29. 406.05% = 6.51% × 1.92 × 32.52
2020. 10. 30. 131.77% = 6.29% × 1.68 × 12.49
2020. 7. 31. 131.40% = 7.12% × 1.55 × 11.88
2020. 5. 1. 266.43% = 6.17% × 1.62 × 26.71
2020. 1. 31. 217.09% = 5.93% × 1.83 × 20.02
2019. 11. 1. 119.93% = 4.11% × 1.80 × 16.18
2019. 8. 2. 95.76% = 3.52% × 1.76 × 15.41
2019. 5. 3. 73.30% = 3.31% × 1.66 × 13.36
2019. 2. 1. 63.50% = 3.25% × 2.07 × 9.47
2018. 11. 2. 68.43% = 5.19% × 1.94 × 6.81
2018. 8. 3. 68.05% = 5.58% × 1.90 × 6.42
2018. 5. 4. 66.72% = 5.55% × 1.81 × 6.66
2018. 2. 2. 58.69% = 5.02% × 1.94 × 6.01
2017. 11. 3. 61.93% = 5.16% × 1.87 × 6.41
2017. 8. 4. 55.33% = 4.51% × 1.85 × 6.62
2017. 5. 5. 50.82% = 4.22% × 1.77 × 6.80
2017. 2. 3. 48.07% = 4.76% × 1.89 × 5.35
2016. 10. 28. = × × 5.36
2016. 7. 29. = × × 5.28
2016. 4. 29. = × × 5.15

보고서 기반: 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), 10-K (보고 날짜: 2019-02-01), 10-Q (보고 날짜: 2018-11-02), 10-Q (보고 날짜: 2018-08-03), 10-Q (보고 날짜: 2018-05-04), 10-K (보고 날짜: 2018-02-02), 10-Q (보고 날짜: 2017-11-03), 10-Q (보고 날짜: 2017-08-04), 10-Q (보고 날짜: 2017-05-05), 10-K (보고 날짜: 2017-02-03), 10-Q (보고 날짜: 2016-10-28), 10-Q (보고 날짜: 2016-07-29), 10-Q (보고 날짜: 2016-04-29).


ROA 분리를 두 구성 요소로 분리

Lowe’s Cos. Inc., ROA 분해 (분기별 데이터)

Microsoft Excel
ROA = 순이익률 × 자산 회전율
2022. 7. 29. 18.04% = 8.84% × 2.04
2022. 4. 29. 17.00% = 8.85% × 1.92
2022. 1. 28. 18.91% = 8.77% × 2.16
2021. 10. 29. 16.63% = 8.63% × 1.93
2021. 7. 30. 14.19% = 7.41% × 1.92
2021. 4. 30. 13.32% = 7.23% × 1.84
2021. 1. 29. 12.49% = 6.51% × 1.92
2020. 10. 30. 10.55% = 6.29% × 1.68
2020. 7. 31. 11.06% = 7.12% × 1.55
2020. 5. 1. 9.98% = 6.17% × 1.62
2020. 1. 31. 10.85% = 5.93% × 1.83
2019. 11. 1. 7.41% = 4.11% × 1.80
2019. 8. 2. 6.21% = 3.52% × 1.76
2019. 5. 3. 5.49% = 3.31% × 1.66
2019. 2. 1. 6.71% = 3.25% × 2.07
2018. 11. 2. 10.05% = 5.19% × 1.94
2018. 8. 3. 10.60% = 5.58% × 1.90
2018. 5. 4. 10.02% = 5.55% × 1.81
2018. 2. 2. 9.77% = 5.02% × 1.94
2017. 11. 3. 9.67% = 5.16% × 1.87
2017. 8. 4. 8.35% = 4.51% × 1.85
2017. 5. 5. 7.47% = 4.22% × 1.77
2017. 2. 3. 8.99% = 4.76% × 1.89
2016. 10. 28. = ×
2016. 7. 29. = ×
2016. 4. 29. = ×

보고서 기반: 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), 10-K (보고 날짜: 2019-02-01), 10-Q (보고 날짜: 2018-11-02), 10-Q (보고 날짜: 2018-08-03), 10-Q (보고 날짜: 2018-05-04), 10-K (보고 날짜: 2018-02-02), 10-Q (보고 날짜: 2017-11-03), 10-Q (보고 날짜: 2017-08-04), 10-Q (보고 날짜: 2017-05-05), 10-K (보고 날짜: 2017-02-03), 10-Q (보고 날짜: 2016-10-28), 10-Q (보고 날짜: 2016-07-29), 10-Q (보고 날짜: 2016-04-29).

2023년 2 분기 대비 자산수익률(ROA)이 증가한 주된 이유는 자산회전율이 증가했기 때문입니다.