Stock Analysis on Net

Palo Alto Networks Inc. (NASDAQ:PANW)

$24.99

Analysis of Investments

Microsoft Excel

Paying user area

The data is hidden behind: . Unhide it.

This is a one-time payment. There is no automatic renewal.


We accept:

Visa Mastercard American Express Maestro Discover JCB PayPal Google Pay
Visa Secure Mastercard Identity Check American Express SafeKey

Adjustment to Net Income (Loss): Mark to Market Available-for-sale Securities

Palo Alto Networks Inc., adjustment to net income (loss)

US$ in thousands

Microsoft Excel
12 months ended: Jul 31, 2024 Jul 31, 2023 Jul 31, 2022 Jul 31, 2021 Jul 31, 2020 Jul 31, 2019
Net income (loss) (as reported)
Add: Change in unrealized gains (losses) on investments
Net income (loss) (adjusted)

Based on: 10-K (reporting date: 2024-07-31), 10-K (reporting date: 2023-07-31), 10-K (reporting date: 2022-07-31), 10-K (reporting date: 2021-07-31), 10-K (reporting date: 2020-07-31), 10-K (reporting date: 2019-07-31).


Reported Net Income (Loss) Trend
The reported net income exhibited a predominantly negative trend from 2019 through 2022, starting with a loss of $81.9 million in 2019 and significantly worsening to a loss of $498.9 million by 2021. A notable improvement occurred in 2023, with reported net income turning positive at $439.7 million, followed by a further substantial increase to $2.58 billion in 2024. This indicates a substantial turnaround from multi-year losses to strong profitability within two years.
Adjusted Net Income (Loss) Trend
The adjusted net income, which likely accounts for certain non-recurring or non-operational items, follows a similar pattern to reported net income. Initially negative, the adjusted losses escalated from $71.5 million in 2019 to $501.9 million by 2021. In 2022, the adjusted losses deepened slightly to $292.0 million. However, a marked reversal is observed in 2023, with adjusted net income becoming positive at $426.7 million, then soaring to $2.63 billion in 2024. This trend corroborates the reported net income data, confirming a significant recovery and enhanced earnings quality.
Comparative Insights
The magnitude of losses peaked in 2021 for both reported and adjusted net income before reversing course. Adjusted figures consistently reflect slightly less favorable results compared to reported numbers up to 2021, suggesting the adjustments accounted for additional expenses or write-downs. From 2023 onwards, both metrics not only turn positive but exhibit explosive growth, indicating operational turnaround and potentially successful strategic or market developments.
Overall Analysis
The financial data reveals a substantial shift from persistent and deepening losses towards robust profitability and positive earnings adjustments in recent periods. The turnaround beginning in 2023 is particularly pronounced, highlighting significant improvements in the company’s financial performance. This shift may reflect improved operational efficiency, growth in revenue streams, or effective cost management strategies. The consistency between reported and adjusted income trends strengthens the credibility of the improved financial position.

Adjusted Profitability Ratios: Mark to Market Available-for-sale Securities (Summary)

Palo Alto Networks Inc., adjusted profitability ratios

Microsoft Excel
Jul 31, 2024 Jul 31, 2023 Jul 31, 2022 Jul 31, 2021 Jul 31, 2020 Jul 31, 2019
Net Profit Margin
Reported net profit margin
Adjusted net profit margin
Return on Equity (ROE)
Reported ROE
Adjusted ROE
Return on Assets (ROA)
Reported ROA
Adjusted ROA

Based on: 10-K (reporting date: 2024-07-31), 10-K (reporting date: 2023-07-31), 10-K (reporting date: 2022-07-31), 10-K (reporting date: 2021-07-31), 10-K (reporting date: 2020-07-31), 10-K (reporting date: 2019-07-31).


The financial performance exhibits several notable trends over the six-year period analyzed. Both reported and adjusted profitability metrics demonstrate a significant evolution from consistent negative values in the earlier years to strong positive figures in the most recent period.

Net Profit Margin
The reported net profit margin shows a steady decline from -2.82% in 2019 to a low of -11.72% in 2021, indicating increasing losses relative to revenue during those years. However, a recovery trend begins in 2022, with the margin improving to -4.85%, turning positive at 6.38% in 2023, and sharply increasing to 32.11% in 2024. The adjusted net profit margin follows a similar trajectory, starting at -2.47% in 2019, declining to -11.79% in 2021, then improving significantly to 32.71% in 2024. This consistent pattern between reported and adjusted margins suggests that non-recurring items had limited impact on the overall profitability trend.
Return on Equity (ROE)
Reported ROE exhibits volatility and negative performance from -5.16% in 2019 to a drastic decline reaching -127.14% in 2022, implying substantial losses and possibly high leverage or equity erosion during this timeframe. Following this trough, a recovery is observed with ROE returning to positive territory at 25.15% in 2023 and further improving to 49.86% in 2024. Adjusted ROE aligns closely with these figures, mirroring the deep negative trough and subsequent recovery, which confirms the consistency of core operating returns excluding investment adjustments or other extraordinary factors.
Return on Assets (ROA)
The reported ROA reflects a negative performance trend from -1.24% in 2019 down to -4.87% in 2021, improving to -2.18% in 2022, and turning positive with 3.03% in 2023 followed by a substantial increase to 12.89% in 2024. Adjusted ROA also shows a similar trend, closely paralleling the reported metrics with a low of -4.90% in 2021 and a marked improvement to 13.13% in 2024. This indicates improving asset utilization and profitability in the later years.

Overall, the data highlights a period of financial difficulty through 2019 to 2021, characterized by negative profitability and returns. Beginning in 2022, there is a marked reversal in performance, culminating in robust profitability and returns by 2024. The alignment of reported and adjusted figures throughout the period suggests that the improvements are grounded in operational enhancements rather than accounting adjustments or extraordinary items. The strong growth in net profit margin, ROE, and ROA in the latest years points to an effective strategic or operational transformation resulting in significantly increased financial efficiency and profitability.


Palo Alto Networks Inc., Profitability Ratios: Reported vs. Adjusted


Adjusted Net Profit Margin

Microsoft Excel
Jul 31, 2024 Jul 31, 2023 Jul 31, 2022 Jul 31, 2021 Jul 31, 2020 Jul 31, 2019
As Reported
Selected Financial Data (US$ in thousands)
Net income (loss)
Revenue
Profitability Ratio
Net profit margin1
Adjusted: Mark to Market Available-for-sale Securities
Selected Financial Data (US$ in thousands)
Adjusted net income (loss)
Revenue
Profitability Ratio
Adjusted net profit margin2

Based on: 10-K (reporting date: 2024-07-31), 10-K (reporting date: 2023-07-31), 10-K (reporting date: 2022-07-31), 10-K (reporting date: 2021-07-31), 10-K (reporting date: 2020-07-31), 10-K (reporting date: 2019-07-31).

2024 Calculations

1 Net profit margin = 100 × Net income (loss) ÷ Revenue
= 100 × ÷ =

2 Adjusted net profit margin = 100 × Adjusted net income (loss) ÷ Revenue
= 100 × ÷ =


The financial data reveals significant volatility and a substantial turnaround in income performance over the analyzed periods.

Net Income (Loss)
Both reported and adjusted net income figures exhibit a pronounced negative trend initially, with increasing losses from 2019 through 2021. The reported net income deteriorated from a loss of $81.9 million in 2019 to a loss of nearly $499 million in 2021. Adjusted net income mirrored this pattern, moving from a loss of $71.5 million to a loss of approximately $502 million within the same period. In 2022, losses narrowed somewhat but remained substantial, around $267 million reported and $292 million adjusted. Notably, 2023 marked a sharp reversal with reported net income turning positive at $439.7 million and adjusted net income at $426.7 million. This positive trend accelerated dramatically in 2024, with reported income reaching approximately $2.58 billion and adjusted income approximately $2.63 billion, indicating a strong recovery and growth phase.
Net Profit Margin
The profitability margins trend closely aligns with net income movements. Reported net profit margin was negative throughout 2019 to 2022, declining from -2.82% to a low of -11.72% in 2021, indicating increasing inefficiency or high expenses relative to revenue. There was a slight improvement in 2022, but margins remained negative. In 2023, margins transitioned into positive territory with a 6.38% reported margin, further improving significantly to 32.11% in 2024. Adjusted net profit margins demonstrate a similar pattern, consistently tracking reported margins but reflecting slightly different magnitude, culminating in a strong positive margin of 32.71% in 2024.

Overall, the data indicates a period of substantial losses and negative profitability up to 2022, followed by a remarkable recovery beginning in 2023 that culminated in strong profitability and net income growth by 2024. This suggests either a major operational turnaround, improved revenue generation, cost management, or recognition of one-time items in adjusted metrics contributing to sustained profitability improvement.


Adjusted Return on Equity (ROE)

Microsoft Excel
Jul 31, 2024 Jul 31, 2023 Jul 31, 2022 Jul 31, 2021 Jul 31, 2020 Jul 31, 2019
As Reported
Selected Financial Data (US$ in thousands)
Net income (loss)
Stockholders’ equity
Profitability Ratio
ROE1
Adjusted: Mark to Market Available-for-sale Securities
Selected Financial Data (US$ in thousands)
Adjusted net income (loss)
Stockholders’ equity
Profitability Ratio
Adjusted ROE2

Based on: 10-K (reporting date: 2024-07-31), 10-K (reporting date: 2023-07-31), 10-K (reporting date: 2022-07-31), 10-K (reporting date: 2021-07-31), 10-K (reporting date: 2020-07-31), 10-K (reporting date: 2019-07-31).

2024 Calculations

1 ROE = 100 × Net income (loss) ÷ Stockholders’ equity
= 100 × ÷ =

2 Adjusted ROE = 100 × Adjusted net income (loss) ÷ Stockholders’ equity
= 100 × ÷ =


The data reveals significant fluctuations in both reported and adjusted net income over the observed periods. Initially, the company experienced substantial net losses, with reported net income declining from -81.9 million US dollars in 2019 to a peak loss of -498.9 million US dollars in 2021. A similar pattern is observed in the adjusted net income, with losses worsening from -71.5 million to -501.9 million US dollars over the same period. However, from 2022 onwards, a remarkable turnaround is evident, as the company transitions to positive net income, reporting 439.7 million US dollars in 2023 and further increasing to 2.58 billion US dollars in 2024. The adjusted net income mirrors this trend closely.

Return on equity (ROE), both reported and adjusted, follows a parallel trajectory. Negative ROE values dominate the earlier years, indicating that equity holders were facing significant losses relative to their investments, with the lowest points observed in 2022 (-127.14% reported and -139.05% adjusted). This indicates an erosion of shareholder value during that period. The shift to positive ROE in 2023 (25.15% reported and 24.41% adjusted) and a strong improvement in 2024 (49.86% reported and 50.79% adjusted) highlights enhanced profitability and efficient utilization of equity capital.

Trends in Net Income
The company experienced worsening net losses from 2019 through 2021, followed by a significant recovery to positive net income starting in 2023, culminating in exceptional net income levels by 2024.
Return on Equity Evolution
ROE values indicate deep negative returns for shareholders up to 2022, transitioning sharply to robust positive returns in 2023 and continuing this strong performance in 2024, reflecting improved operational efficiency and profitability.
Consistency Between Reported and Adjusted Figures
Reported and adjusted net income and ROE values show a high degree of alignment in trends and magnitudes, suggesting that adjustments made do not materially alter the overall financial performance pattern.

Overall, the data depicts a company undergoing a challenging period with significant losses and negative returns to shareholders, followed by a dramatic turnaround, resulting in substantial profitability and positive shareholder returns in the last two years of the dataset.


Adjusted Return on Assets (ROA)

Microsoft Excel
Jul 31, 2024 Jul 31, 2023 Jul 31, 2022 Jul 31, 2021 Jul 31, 2020 Jul 31, 2019
As Reported
Selected Financial Data (US$ in thousands)
Net income (loss)
Total assets
Profitability Ratio
ROA1
Adjusted: Mark to Market Available-for-sale Securities
Selected Financial Data (US$ in thousands)
Adjusted net income (loss)
Total assets
Profitability Ratio
Adjusted ROA2

Based on: 10-K (reporting date: 2024-07-31), 10-K (reporting date: 2023-07-31), 10-K (reporting date: 2022-07-31), 10-K (reporting date: 2021-07-31), 10-K (reporting date: 2020-07-31), 10-K (reporting date: 2019-07-31).

2024 Calculations

1 ROA = 100 × Net income (loss) ÷ Total assets
= 100 × ÷ =

2 Adjusted ROA = 100 × Adjusted net income (loss) ÷ Total assets
= 100 × ÷ =


The analysis of the financial data reveals significant variations in both reported and adjusted net income over the six-year period, alongside corresponding changes in return on assets (ROA) metrics.

Net Income Trends
Reported net income exhibits a notable negative trend from 2019 through 2022, with losses deepening substantially from -81.9 million USD in 2019 to a peak loss of -498.9 million USD in 2021. This negative trajectory reverses sharply in 2023, crossing into positive territory with a net income of 439.7 million USD, followed by a substantial jump to 2.58 billion USD in 2024.
Adjusted net income follows a similar pattern, starting at a loss of -71.5 million USD in 2019 and worsening to -501.9 million USD in 2021. The adjusted figures then improve markedly post-2022, yielding a positive 426.7 million USD in 2023 and an even higher 2.63 billion USD in 2024.
Return on Assets (ROA) Observations
The reported ROA metric parallels the net income results, decreasing from -1.24% in 2019 to -4.87% in 2021, signifying declining asset efficiency. After 2021, reported ROA improves to -2.18% in 2022 and turns positive at 3.03% in 2023, culminating at a robust 12.89% in 2024.
Adjusted ROA data mirrors this trend with marginal variance. It starts at -1.08% in 2019, drops to -4.90% in 2021, and then recovers significantly from -2.38% in 2022 to 2.94% in 2023 and reaches 13.13% in 2024.
Overall Insights
Both the reported and adjusted figures reveal a period of financial struggle and inefficiency from 2019 through 2021, as indicated by increasing losses and negative ROA. A turning point appears in 2023, with substantial improvements in profitability and asset utilization, which accelerate further in 2024.
The close alignment between reported and adjusted figures suggests consistency in the core financial performance and minimal impact of one-time or non-recurring adjustments during these years.