Stock Analysis on Net

Palo Alto Networks Inc. (NASDAQ:PANW)

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

Microsoft Excel

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

Palo Alto Networks Inc.、 ROE の分解(四半期データ)

Microsoft Excel
ROE = ROA × 財務レバレッジ比率
2024/07/31 49.86% = 12.89% × 3.87
2024/04/30 54.78% = 13.65% × 4.01
2024/01/31 52.25% = 12.45% × 4.20
2023/10/31 28.28% = 4.15% × 6.82
2023/07/31 25.15% = 3.03% × 8.29
2023/04/30 17.47% = 1.52% × 11.50
2023/01/31 4.71% = 0.26% × 18.06
2022/10/31 -28.23% = -1.14% × 24.69
2022/07/31 -127.14% = -2.18% × 58.35
2022/04/30 -115.40% = -3.51% × 32.88
2022/01/31 -391.77% = -4.44% × 88.29
2021/10/31 -98.34% = -4.89% × 20.09
2021/07/31 -78.63% = -4.87% × 16.14
2021/04/30 -43.97% = -4.59% × 9.59
2021/01/31 -35.50% = -3.88% × 9.15
2020/10/31 -40.11% = -3.43% × 11.68
2020/07/31 -24.23% = -2.95% × 8.23
2020/04/30 -30.74% = -3.52% × 8.73
2020/01/31 -10.84% = -2.43% × 4.47
2019/10/31 -6.81% = -1.51% × 4.50
2019/07/31 -5.16% = -1.24% × 4.16
2019/04/30 = × 4.31
2019/01/31 = × 5.33
2018/10/31 = × 4.63

レポートに基づく: 10-K (報告日: 2024-07-31), 10-Q (報告日: 2024-04-30), 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).

2024年第4 四半期の株主資本利益率(ROE)が低下した主な理由は、総資産利益率(ROA)で測定した収益性の低下です。


ROEを3つの要素に分解

Palo Alto Networks Inc.、 ROE の分解(四半期データ)

Microsoft Excel
ROE = 純利益率 × 資産回転率 × 財務レバレッジ比率
2024/07/31 49.86% = 32.11% × 0.40 × 3.87
2024/04/30 54.78% = 31.41% × 0.43 × 4.01
2024/01/31 52.25% = 30.24% × 0.41 × 4.20
2023/10/31 28.28% = 8.52% × 0.49 × 6.82
2023/07/31 25.15% = 6.38% × 0.48 × 8.29
2023/04/30 17.47% = 3.32% × 0.46 × 11.50
2023/01/31 4.71% = 0.56% × 0.47 × 18.06
2022/10/31 -28.23% = -2.46% × 0.46 × 24.69
2022/07/31 -127.14% = -4.85% × 0.45 × 58.35
2022/04/30 -115.40% = -7.54% × 0.47 × 32.88
2022/01/31 -391.77% = -9.50% × 0.47 × 88.29
2021/10/31 -98.34% = -11.20% × 0.44 × 20.09
2021/07/31 -78.63% = -11.72% × 0.42 × 16.14
2021/04/30 -43.97% = -11.00% × 0.42 × 9.59
2021/01/31 -35.50% = -9.73% × 0.40 × 9.15
2020/10/31 -40.11% = -8.36% × 0.41 × 11.68
2020/07/31 -24.23% = -7.83% × 0.38 × 8.23
2020/04/30 -30.74% = -7.01% × 0.50 × 8.73
2020/01/31 -10.84% = -5.58% × 0.43 × 4.47
2019/10/31 -6.81% = -3.42% × 0.44 × 4.50
2019/07/31 -5.16% = -2.82% × 0.44 × 4.16
2019/04/30 = × × 4.31
2019/01/31 = × × 5.33
2018/10/31 = × × 4.63

レポートに基づく: 10-K (報告日: 2024-07-31), 10-Q (報告日: 2024-04-30), 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).

2024年第4 四半期に株主資本利益率(ROE)が低下した主な理由は、資産回転率で測定される効率の低下です。


ROEを5つの要素に分解

Palo Alto Networks Inc.、 ROE の分解(四半期データ)

Microsoft Excel
ROE = 税負担 × 利息負担 × EBITマージン × 資産回転率 × 財務レバレッジ比率
2024/07/31 49.86% = 2.61 × 0.99 × 12.41% × 0.40 × 3.87
2024/04/30 54.78% = 2.48 × 0.99 × 12.83% × 0.43 × 4.01
2024/01/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/07/31 25.15% = 0.78 × 0.95 × 8.61% × 0.48 × 8.29
2023/04/30 17.47% = 0.81 × 0.90 × 4.55% × 0.46 × 11.50
2023/01/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/07/31 -127.14% = × × -3.27% × 0.45 × 58.35
2022/04/30 -115.40% = × × -5.12% × 0.47 × 32.88
2022/01/31 -391.77% = × × -6.76% × 0.47 × 88.29
2021/10/31 -98.34% = × × -7.55% × 0.44 × 20.09
2021/07/31 -78.63% = × × -7.09% × 0.42 × 16.14
2021/04/30 -43.97% = × × -6.47% × 0.42 × 9.59
2021/01/31 -35.50% = × × -5.20% × 0.40 × 9.15
2020/10/31 -40.11% = × × -4.18% × 0.41 × 11.68
2020/07/31 -24.23% = × × -4.20% × 0.38 × 8.23
2020/04/30 -30.74% = × × -3.67% × 0.50 × 8.73
2020/01/31 -10.84% = × × -2.30% × 0.43 × 4.47
2019/10/31 -6.81% = × × -0.24% × 0.44 × 4.50
2019/07/31 -5.16% = × -8.02 × 0.32% × 0.44 × 4.16
2019/04/30 = × × × × 4.31
2019/01/31 = × × × × 5.33
2018/10/31 = × × × × 4.63

レポートに基づく: 10-K (報告日: 2024-07-31), 10-Q (報告日: 2024-04-30), 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).

2024年第4 四半期に株主資本利益率(ROE)が低下した主な理由は、資産回転率で測定される効率の低下です。


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

Palo Alto Networks Inc.、 ROA の分解(四半期データ)

Microsoft Excel
ROA = 純利益率 × 資産回転率
2024/07/31 12.89% = 32.11% × 0.40
2024/04/30 13.65% = 31.41% × 0.43
2024/01/31 12.45% = 30.24% × 0.41
2023/10/31 4.15% = 8.52% × 0.49
2023/07/31 3.03% = 6.38% × 0.48
2023/04/30 1.52% = 3.32% × 0.46
2023/01/31 0.26% = 0.56% × 0.47
2022/10/31 -1.14% = -2.46% × 0.46
2022/07/31 -2.18% = -4.85% × 0.45
2022/04/30 -3.51% = -7.54% × 0.47
2022/01/31 -4.44% = -9.50% × 0.47
2021/10/31 -4.89% = -11.20% × 0.44
2021/07/31 -4.87% = -11.72% × 0.42
2021/04/30 -4.59% = -11.00% × 0.42
2021/01/31 -3.88% = -9.73% × 0.40
2020/10/31 -3.43% = -8.36% × 0.41
2020/07/31 -2.95% = -7.83% × 0.38
2020/04/30 -3.52% = -7.01% × 0.50
2020/01/31 -2.43% = -5.58% × 0.43
2019/10/31 -1.51% = -3.42% × 0.44
2019/07/31 -1.24% = -2.82% × 0.44
2019/04/30 = ×
2019/01/31 = ×
2018/10/31 = ×

レポートに基づく: 10-K (報告日: 2024-07-31), 10-Q (報告日: 2024-04-30), 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).

2024年第4 四半期に総資産利益率(ROA)が低下した主な理由は、資産回転率の低下です。


ROAを4つの要素に分解

Palo Alto Networks Inc.、 ROA の分解(四半期データ)

Microsoft Excel
ROA = 税負担 × 利息負担 × EBITマージン × 資産回転率
2024/07/31 12.89% = 2.61 × 0.99 × 12.41% × 0.40
2024/04/30 13.65% = 2.48 × 0.99 × 12.83% × 0.43
2024/01/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/07/31 3.03% = 0.78 × 0.95 × 8.61% × 0.48
2023/04/30 1.52% = 0.81 × 0.90 × 4.55% × 0.46
2023/01/31 0.26% = 0.41 × 0.75 × 1.80% × 0.47
2022/10/31 -1.14% = × × -0.93% × 0.46
2022/07/31 -2.18% = × × -3.27% × 0.45
2022/04/30 -3.51% = × × -5.12% × 0.47
2022/01/31 -4.44% = × × -6.76% × 0.47
2021/10/31 -4.89% = × × -7.55% × 0.44
2021/07/31 -4.87% = × × -7.09% × 0.42
2021/04/30 -4.59% = × × -6.47% × 0.42
2021/01/31 -3.88% = × × -5.20% × 0.40
2020/10/31 -3.43% = × × -4.18% × 0.41
2020/07/31 -2.95% = × × -4.20% × 0.38
2020/04/30 -3.52% = × × -3.67% × 0.50
2020/01/31 -2.43% = × × -2.30% × 0.43
2019/10/31 -1.51% = × × -0.24% × 0.44
2019/07/31 -1.24% = × -8.02 × 0.32% × 0.44
2019/04/30 = × × ×
2019/01/31 = × × ×
2018/10/31 = × × ×

レポートに基づく: 10-K (報告日: 2024-07-31), 10-Q (報告日: 2024-04-30), 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).

2024年第4 四半期に総資産利益率(ROA)が低下した主な理由は、資産回転率で測定した効率性の低下です。


当期純利益率の分解

Palo Alto Networks Inc.、純利益率の分解(四半期データ)

Microsoft Excel
純利益率 = 税負担 × 利息負担 × EBITマージン
2024/07/31 32.11% = 2.61 × 0.99 × 12.41%
2024/04/30 31.41% = 2.48 × 0.99 × 12.83%
2024/01/31 30.24% = 2.63 × 0.98 × 11.75%
2023/10/31 8.52% = 0.75 × 0.97 × 11.62%
2023/07/31 6.38% = 0.78 × 0.95 × 8.61%
2023/04/30 3.32% = 0.81 × 0.90 × 4.55%
2023/01/31 0.56% = 0.41 × 0.75 × 1.80%
2022/10/31 -2.46% = × × -0.93%
2022/07/31 -4.85% = × × -3.27%
2022/04/30 -7.54% = × × -5.12%
2022/01/31 -9.50% = × × -6.76%
2021/10/31 -11.20% = × × -7.55%
2021/07/31 -11.72% = × × -7.09%
2021/04/30 -11.00% = × × -6.47%
2021/01/31 -9.73% = × × -5.20%
2020/10/31 -8.36% = × × -4.18%
2020/07/31 -7.83% = × × -4.20%
2020/04/30 -7.01% = × × -3.67%
2020/01/31 -5.58% = × × -2.30%
2019/10/31 -3.42% = × × -0.24%
2019/07/31 -2.82% = × -8.02 × 0.32%
2019/04/30 = × ×
2019/01/31 = × ×
2018/10/31 = × ×

レポートに基づく: 10-K (報告日: 2024-07-31), 10-Q (報告日: 2024-04-30), 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).

2024年Q4 期から当期純利益率が上昇した主な要因は、税負担率で測定した税効果の増加です。