Stock Analysis on Net
Stock Analysis on Net

Palo Alto Networks Inc. (NASDAQ:PANW)

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

Microsoft Excel

분해 ROE 는 순이익을 주주 자본으로 나눈 값을 구성 요소 비율의 곱으로 표현하는 것을 포함합니다.

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

Palo Alto Networks Inc., ROE 분해 (분기별 데이터)

Microsoft Excel
ROE = ROA × 재무 레버리지 비율
2024. 1. 31. 52.25% = 12.45% × 4.20
2023. 10. 31. 28.28% = 4.15% × 6.82
2023. 7. 31. 25.15% = 3.03% × 8.29
2023. 4. 30. 17.47% = 1.52% × 11.50
2023. 1. 31. 4.71% = 0.26% × 18.06
2022. 10. 31. -28.23% = -1.14% × 24.69
2022. 7. 31. -127.14% = -2.18% × 58.35
2022. 4. 30. -115.40% = -3.51% × 32.88
2022. 1. 31. -391.77% = -4.44% × 88.29
2021. 10. 31. -98.34% = -4.89% × 20.09
2021. 7. 31. -78.63% = -4.87% × 16.14
2021. 4. 30. -43.97% = -4.59% × 9.59
2021. 1. 31. -35.50% = -3.88% × 9.15
2020. 10. 31. -40.11% = -3.43% × 11.68
2020. 7. 31. -24.23% = -2.95% × 8.23
2020. 4. 30. -30.74% = -3.52% × 8.73
2020. 1. 31. -10.84% = -2.43% × 4.47
2019. 10. 31. -6.81% = -1.51% × 4.50
2019. 7. 31. -5.16% = -1.24% × 4.16
2019. 4. 30. -4.36% = -1.01% × 4.31
2019. 1. 31. -8.39% = -1.58% × 5.33
2018. 10. 31. -9.75% = -2.11% × 4.63
2018. 7. 31. -15.30% = -2.54% × 6.03
2018. 4. 30. — = — × 5.41
2018. 1. 31. — = — × 5.73
2017. 10. 31. — = — × 5.24

보고서 기준: 10-Q (보고 날짜: 2024-01-31), 10-Q (보고 날짜: 2023-10-31), 10-K (보고 날짜: 2023-07-31), 10-Q (보고 날짜: 2023-04-30), 10-Q (보고 날짜: 2023-01-31), 10-Q (보고 날짜: 2022-10-31), 10-K (보고 날짜: 2022-07-31), 10-Q (보고 날짜: 2022-04-30), 10-Q (보고 날짜: 2022-01-31), 10-Q (보고 날짜: 2021-10-31), 10-K (보고 날짜: 2021-07-31), 10-Q (보고 날짜: 2021-04-30), 10-Q (보고 날짜: 2021-01-31), 10-Q (보고 날짜: 2020-10-31), 10-K (보고 날짜: 2020-07-31), 10-Q (보고 날짜: 2020-04-30), 10-Q (보고 날짜: 2020-01-31), 10-Q (보고 날짜: 2019-10-31), 10-K (보고 날짜: 2019-07-31), 10-Q (보고 날짜: 2019-04-30), 10-Q (보고 날짜: 2019-01-31), 10-Q (보고 날짜: 2018-10-31), 10-K (보고 날짜: 2018-07-31), 10-Q (보고 날짜: 2018-04-30), 10-Q (보고 날짜: 2018-01-31), 10-Q (보고 날짜: 2017-10-31).

2024년 2 분기에 주주자본수익률(ROE)이 증가한 주된 이유는 자산수익률(ROA)로 측정한 수익성이 증가했기 때문입니다.

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

Palo Alto Networks Inc., ROE 분해 (분기별 데이터)

Microsoft Excel
ROE = 순이익률 × 자산 회전율 × 재무 레버리지 비율
2024. 1. 31. 52.25% = 30.24% × 0.41 × 4.20
2023. 10. 31. 28.28% = 8.52% × 0.49 × 6.82
2023. 7. 31. 25.15% = 6.38% × 0.48 × 8.29
2023. 4. 30. 17.47% = 3.32% × 0.46 × 11.50
2023. 1. 31. 4.71% = 0.56% × 0.47 × 18.06
2022. 10. 31. -28.23% = -2.46% × 0.46 × 24.69
2022. 7. 31. -127.14% = -4.85% × 0.45 × 58.35
2022. 4. 30. -115.40% = -7.54% × 0.47 × 32.88
2022. 1. 31. -391.77% = -9.50% × 0.47 × 88.29
2021. 10. 31. -98.34% = -11.20% × 0.44 × 20.09
2021. 7. 31. -78.63% = -11.72% × 0.42 × 16.14
2021. 4. 30. -43.97% = -11.00% × 0.42 × 9.59
2021. 1. 31. -35.50% = -9.73% × 0.40 × 9.15
2020. 10. 31. -40.11% = -8.36% × 0.41 × 11.68
2020. 7. 31. -24.23% = -7.83% × 0.38 × 8.23
2020. 4. 30. -30.74% = -7.01% × 0.50 × 8.73
2020. 1. 31. -10.84% = -5.58% × 0.43 × 4.47
2019. 10. 31. -6.81% = -3.42% × 0.44 × 4.50
2019. 7. 31. -5.16% = -2.82% × 0.44 × 4.16
2019. 4. 30. -4.36% = -2.30% × 0.44 × 4.31
2019. 1. 31. -8.39% = -3.47% × 0.45 × 5.33
2018. 10. 31. -9.75% = -5.04% × 0.42 × 4.63
2018. 7. 31. -15.30% = -6.51% × 0.39 × 6.03
2018. 4. 30. — = — × — × 5.41
2018. 1. 31. — = — × — × 5.73
2017. 10. 31. — = — × — × 5.24

보고서 기준: 10-Q (보고 날짜: 2024-01-31), 10-Q (보고 날짜: 2023-10-31), 10-K (보고 날짜: 2023-07-31), 10-Q (보고 날짜: 2023-04-30), 10-Q (보고 날짜: 2023-01-31), 10-Q (보고 날짜: 2022-10-31), 10-K (보고 날짜: 2022-07-31), 10-Q (보고 날짜: 2022-04-30), 10-Q (보고 날짜: 2022-01-31), 10-Q (보고 날짜: 2021-10-31), 10-K (보고 날짜: 2021-07-31), 10-Q (보고 날짜: 2021-04-30), 10-Q (보고 날짜: 2021-01-31), 10-Q (보고 날짜: 2020-10-31), 10-K (보고 날짜: 2020-07-31), 10-Q (보고 날짜: 2020-04-30), 10-Q (보고 날짜: 2020-01-31), 10-Q (보고 날짜: 2019-10-31), 10-K (보고 날짜: 2019-07-31), 10-Q (보고 날짜: 2019-04-30), 10-Q (보고 날짜: 2019-01-31), 10-Q (보고 날짜: 2018-10-31), 10-K (보고 날짜: 2018-07-31), 10-Q (보고 날짜: 2018-04-30), 10-Q (보고 날짜: 2018-01-31), 10-Q (보고 날짜: 2017-10-31).

2024년 2 분기 동안 주주자본이익률(ROE)이 증가한 주된 이유는 순이익률로 측정한 수익성 증가입니다.

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

Palo Alto Networks Inc., ROE 분해 (분기별 데이터)

Microsoft Excel
ROE = 세금 부담 × 이자 부담 × EBIT 마진 × 자산 회전율 × 재무 레버리지 비율
2024. 1. 31. 52.25% = 2.63 × 0.98 × 11.75% × 0.41 × 4.20
2023. 10. 31. 28.28% = 0.75 × 0.97 × 11.62% × 0.49 × 6.82
2023. 7. 31. 25.15% = 0.78 × 0.95 × 8.61% × 0.48 × 8.29
2023. 4. 30. 17.47% = 0.81 × 0.90 × 4.55% × 0.46 × 11.50
2023. 1. 31. 4.71% = 0.41 × 0.75 × 1.80% × 0.47 × 18.06
2022. 10. 31. -28.23% = — × — × -0.93% × 0.46 × 24.69
2022. 7. 31. -127.14% = — × — × -3.27% × 0.45 × 58.35
2022. 4. 30. -115.40% = — × — × -5.12% × 0.47 × 32.88
2022. 1. 31. -391.77% = — × — × -6.76% × 0.47 × 88.29
2021. 10. 31. -98.34% = — × — × -7.55% × 0.44 × 20.09
2021. 7. 31. -78.63% = — × — × -7.09% × 0.42 × 16.14
2021. 4. 30. -43.97% = — × — × -6.47% × 0.42 × 9.59
2021. 1. 31. -35.50% = — × — × -5.20% × 0.40 × 9.15
2020. 10. 31. -40.11% = — × — × -4.18% × 0.41 × 11.68
2020. 7. 31. -24.23% = — × — × -4.20% × 0.38 × 8.23
2020. 4. 30. -30.74% = — × — × -3.67% × 0.50 × 8.73
2020. 1. 31. -10.84% = — × — × -2.30% × 0.43 × 4.47
2019. 10. 31. -6.81% = — × — × -0.24% × 0.44 × 4.50
2019. 7. 31. -5.16% = — × -8.02 × 0.32% × 0.44 × 4.16
2019. 4. 30. -4.36% = — × -2.41 × 0.79% × 0.44 × 4.31
2019. 1. 31. -8.39% = — × — × -0.80% × 0.45 × 5.33
2018. 10. 31. -9.75% = — × — × -2.90% × 0.42 × 4.63
2018. 7. 31. -15.30% = — × — × -4.43% × 0.39 × 6.03
2018. 4. 30. — = — × — × — × — × 5.41
2018. 1. 31. — = — × — × — × — × 5.73
2017. 10. 31. — = — × — × — × — × 5.24

보고서 기준: 10-Q (보고 날짜: 2024-01-31), 10-Q (보고 날짜: 2023-10-31), 10-K (보고 날짜: 2023-07-31), 10-Q (보고 날짜: 2023-04-30), 10-Q (보고 날짜: 2023-01-31), 10-Q (보고 날짜: 2022-10-31), 10-K (보고 날짜: 2022-07-31), 10-Q (보고 날짜: 2022-04-30), 10-Q (보고 날짜: 2022-01-31), 10-Q (보고 날짜: 2021-10-31), 10-K (보고 날짜: 2021-07-31), 10-Q (보고 날짜: 2021-04-30), 10-Q (보고 날짜: 2021-01-31), 10-Q (보고 날짜: 2020-10-31), 10-K (보고 날짜: 2020-07-31), 10-Q (보고 날짜: 2020-04-30), 10-Q (보고 날짜: 2020-01-31), 10-Q (보고 날짜: 2019-10-31), 10-K (보고 날짜: 2019-07-31), 10-Q (보고 날짜: 2019-04-30), 10-Q (보고 날짜: 2019-01-31), 10-Q (보고 날짜: 2018-10-31), 10-K (보고 날짜: 2018-07-31), 10-Q (보고 날짜: 2018-04-30), 10-Q (보고 날짜: 2018-01-31), 10-Q (보고 날짜: 2017-10-31).

2024년 2 분기 대비 주주자본비율(ROE)이 증가한 가장 큰 이유는 조세부담률로 측정되는 세금의 효과가 증가했기 때문이다.

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

Palo Alto Networks Inc., ROA 분해 (분기별 데이터)

Microsoft Excel
ROA = 순이익률 × 자산 회전율
2024. 1. 31. 12.45% = 30.24% × 0.41
2023. 10. 31. 4.15% = 8.52% × 0.49
2023. 7. 31. 3.03% = 6.38% × 0.48
2023. 4. 30. 1.52% = 3.32% × 0.46
2023. 1. 31. 0.26% = 0.56% × 0.47
2022. 10. 31. -1.14% = -2.46% × 0.46
2022. 7. 31. -2.18% = -4.85% × 0.45
2022. 4. 30. -3.51% = -7.54% × 0.47
2022. 1. 31. -4.44% = -9.50% × 0.47
2021. 10. 31. -4.89% = -11.20% × 0.44
2021. 7. 31. -4.87% = -11.72% × 0.42
2021. 4. 30. -4.59% = -11.00% × 0.42
2021. 1. 31. -3.88% = -9.73% × 0.40
2020. 10. 31. -3.43% = -8.36% × 0.41
2020. 7. 31. -2.95% = -7.83% × 0.38
2020. 4. 30. -3.52% = -7.01% × 0.50
2020. 1. 31. -2.43% = -5.58% × 0.43
2019. 10. 31. -1.51% = -3.42% × 0.44
2019. 7. 31. -1.24% = -2.82% × 0.44
2019. 4. 30. -1.01% = -2.30% × 0.44
2019. 1. 31. -1.58% = -3.47% × 0.45
2018. 10. 31. -2.11% = -5.04% × 0.42
2018. 7. 31. -2.54% = -6.51% × 0.39
2018. 4. 30. — = — × —
2018. 1. 31. — = — × —
2017. 10. 31. — = — × —

보고서 기준: 10-Q (보고 날짜: 2024-01-31), 10-Q (보고 날짜: 2023-10-31), 10-K (보고 날짜: 2023-07-31), 10-Q (보고 날짜: 2023-04-30), 10-Q (보고 날짜: 2023-01-31), 10-Q (보고 날짜: 2022-10-31), 10-K (보고 날짜: 2022-07-31), 10-Q (보고 날짜: 2022-04-30), 10-Q (보고 날짜: 2022-01-31), 10-Q (보고 날짜: 2021-10-31), 10-K (보고 날짜: 2021-07-31), 10-Q (보고 날짜: 2021-04-30), 10-Q (보고 날짜: 2021-01-31), 10-Q (보고 날짜: 2020-10-31), 10-K (보고 날짜: 2020-07-31), 10-Q (보고 날짜: 2020-04-30), 10-Q (보고 날짜: 2020-01-31), 10-Q (보고 날짜: 2019-10-31), 10-K (보고 날짜: 2019-07-31), 10-Q (보고 날짜: 2019-04-30), 10-Q (보고 날짜: 2019-01-31), 10-Q (보고 날짜: 2018-10-31), 10-K (보고 날짜: 2018-07-31), 10-Q (보고 날짜: 2018-04-30), 10-Q (보고 날짜: 2018-01-31), 10-Q (보고 날짜: 2017-10-31).

2024년 2 분기에 비해 자산수익률(ROA)이 증가한 주된 이유는 순이익률로 측정한 수익성 증가입니다.

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

Palo Alto Networks Inc., ROA 분해 (분기별 데이터)

Microsoft Excel
ROA = 세금 부담 × 이자 부담 × EBIT 마진 × 자산 회전율
2024. 1. 31. 12.45% = 2.63 × 0.98 × 11.75% × 0.41
2023. 10. 31. 4.15% = 0.75 × 0.97 × 11.62% × 0.49
2023. 7. 31. 3.03% = 0.78 × 0.95 × 8.61% × 0.48
2023. 4. 30. 1.52% = 0.81 × 0.90 × 4.55% × 0.46
2023. 1. 31. 0.26% = 0.41 × 0.75 × 1.80% × 0.47
2022. 10. 31. -1.14% = — × — × -0.93% × 0.46
2022. 7. 31. -2.18% = — × — × -3.27% × 0.45
2022. 4. 30. -3.51% = — × — × -5.12% × 0.47
2022. 1. 31. -4.44% = — × — × -6.76% × 0.47
2021. 10. 31. -4.89% = — × — × -7.55% × 0.44
2021. 7. 31. -4.87% = — × — × -7.09% × 0.42
2021. 4. 30. -4.59% = — × — × -6.47% × 0.42
2021. 1. 31. -3.88% = — × — × -5.20% × 0.40
2020. 10. 31. -3.43% = — × — × -4.18% × 0.41
2020. 7. 31. -2.95% = — × — × -4.20% × 0.38
2020. 4. 30. -3.52% = — × — × -3.67% × 0.50
2020. 1. 31. -2.43% = — × — × -2.30% × 0.43
2019. 10. 31. -1.51% = — × — × -0.24% × 0.44
2019. 7. 31. -1.24% = — × -8.02 × 0.32% × 0.44
2019. 4. 30. -1.01% = — × -2.41 × 0.79% × 0.44
2019. 1. 31. -1.58% = — × — × -0.80% × 0.45
2018. 10. 31. -2.11% = — × — × -2.90% × 0.42
2018. 7. 31. -2.54% = — × — × -4.43% × 0.39
2018. 4. 30. — = — × — × — × —
2018. 1. 31. — = — × — × — × —
2017. 10. 31. — = — × — × — × —

보고서 기준: 10-Q (보고 날짜: 2024-01-31), 10-Q (보고 날짜: 2023-10-31), 10-K (보고 날짜: 2023-07-31), 10-Q (보고 날짜: 2023-04-30), 10-Q (보고 날짜: 2023-01-31), 10-Q (보고 날짜: 2022-10-31), 10-K (보고 날짜: 2022-07-31), 10-Q (보고 날짜: 2022-04-30), 10-Q (보고 날짜: 2022-01-31), 10-Q (보고 날짜: 2021-10-31), 10-K (보고 날짜: 2021-07-31), 10-Q (보고 날짜: 2021-04-30), 10-Q (보고 날짜: 2021-01-31), 10-Q (보고 날짜: 2020-10-31), 10-K (보고 날짜: 2020-07-31), 10-Q (보고 날짜: 2020-04-30), 10-Q (보고 날짜: 2020-01-31), 10-Q (보고 날짜: 2019-10-31), 10-K (보고 날짜: 2019-07-31), 10-Q (보고 날짜: 2019-04-30), 10-Q (보고 날짜: 2019-01-31), 10-Q (보고 날짜: 2018-10-31), 10-K (보고 날짜: 2018-07-31), 10-Q (보고 날짜: 2018-04-30), 10-Q (보고 날짜: 2018-01-31), 10-Q (보고 날짜: 2017-10-31).

2024년 2 분기 자산수익률(ROA)이 증가한 가장 큰 이유는 조세부담률로 측정한 조세효과의 증가다.

순이익률 세분화

Palo Alto Networks Inc., 순이익률 분해(분기별 데이터)

Microsoft Excel
순이익률 = 세금 부담 × 이자 부담 × EBIT 마진
2024. 1. 31. 30.24% = 2.63 × 0.98 × 11.75%
2023. 10. 31. 8.52% = 0.75 × 0.97 × 11.62%
2023. 7. 31. 6.38% = 0.78 × 0.95 × 8.61%
2023. 4. 30. 3.32% = 0.81 × 0.90 × 4.55%
2023. 1. 31. 0.56% = 0.41 × 0.75 × 1.80%
2022. 10. 31. -2.46% = — × — × -0.93%
2022. 7. 31. -4.85% = — × — × -3.27%
2022. 4. 30. -7.54% = — × — × -5.12%
2022. 1. 31. -9.50% = — × — × -6.76%
2021. 10. 31. -11.20% = — × — × -7.55%
2021. 7. 31. -11.72% = — × — × -7.09%
2021. 4. 30. -11.00% = — × — × -6.47%
2021. 1. 31. -9.73% = — × — × -5.20%
2020. 10. 31. -8.36% = — × — × -4.18%
2020. 7. 31. -7.83% = — × — × -4.20%
2020. 4. 30. -7.01% = — × — × -3.67%
2020. 1. 31. -5.58% = — × — × -2.30%
2019. 10. 31. -3.42% = — × — × -0.24%
2019. 7. 31. -2.82% = — × -8.02 × 0.32%
2019. 4. 30. -2.30% = — × -2.41 × 0.79%
2019. 1. 31. -3.47% = — × — × -0.80%
2018. 10. 31. -5.04% = — × — × -2.90%
2018. 7. 31. -6.51% = — × — × -4.43%
2018. 4. 30. — = — × — × —
2018. 1. 31. — = — × — × —
2017. 10. 31. — = — × — × —

보고서 기준: 10-Q (보고 날짜: 2024-01-31), 10-Q (보고 날짜: 2023-10-31), 10-K (보고 날짜: 2023-07-31), 10-Q (보고 날짜: 2023-04-30), 10-Q (보고 날짜: 2023-01-31), 10-Q (보고 날짜: 2022-10-31), 10-K (보고 날짜: 2022-07-31), 10-Q (보고 날짜: 2022-04-30), 10-Q (보고 날짜: 2022-01-31), 10-Q (보고 날짜: 2021-10-31), 10-K (보고 날짜: 2021-07-31), 10-Q (보고 날짜: 2021-04-30), 10-Q (보고 날짜: 2021-01-31), 10-Q (보고 날짜: 2020-10-31), 10-K (보고 날짜: 2020-07-31), 10-Q (보고 날짜: 2020-04-30), 10-Q (보고 날짜: 2020-01-31), 10-Q (보고 날짜: 2019-10-31), 10-K (보고 날짜: 2019-07-31), 10-Q (보고 날짜: 2019-04-30), 10-Q (보고 날짜: 2019-01-31), 10-Q (보고 날짜: 2018-10-31), 10-K (보고 날짜: 2018-07-31), 10-Q (보고 날짜: 2018-04-30), 10-Q (보고 날짜: 2018-01-31), 10-Q (보고 날짜: 2017-10-31).

2024년 2 분기 대비 순이익률 증가의 주요 원인은 조세부담률로 측정되는 세금의 효과가 증가했기 때문이다.