Stock Analysis on Net

Palo Alto Networks Inc. (NASDAQ:PANW)

Common-Size Income Statement 

Palo Alto Networks Inc., common-size consolidated income statement

Microsoft Excel
12 months ended: Jul 31, 2025 Jul 31, 2024 Jul 31, 2023 Jul 31, 2022 Jul 31, 2021 Jul 31, 2020
Product 19.54 19.97 22.90 24.78 26.32 31.22
Subscription and support 80.46 80.03 77.10 75.22 73.68 68.78
Revenue 100.00% 100.00% 100.00% 100.00% 100.00% 100.00%
Product -4.48 -4.34 -6.07 -8.28 -7.25 -8.64
Subscription and support -22.10 -21.31 -21.64 -22.96 -22.71 -20.69
Cost of revenue -26.59% -25.65% -27.71% -31.24% -29.95% -29.32%
Gross profit 73.41% 74.35% 72.29% 68.76% 70.05% 70.68%
Research and development -21.52 -22.54 -23.27 -25.77 -26.79 -22.54
Sales and marketing -33.62 -34.81 -36.91 -39.06 -41.21 -44.60
General and administrative -4.80 -8.48 -6.50 -7.36 -9.19 -8.79
Operating expenses -59.94% -65.83% -66.67% -72.19% -77.19% -75.93%
Operating income (loss) 13.48% 8.52% 5.62% -3.43% -7.15% -5.25%
Interest expense -0.03 -0.10 -0.39 -0.50 -3.84 -2.60
Interest income 3.94 3.96 3.26 0.28 0.20 1.21
Foreign currency exchange gains (losses), net -0.36 0.00 -0.11 0.03 -0.13 -0.20
Other, net 0.27 -0.07 -0.15 -0.15 -0.02 0.04
Other income, net 3.86% 3.90% 2.99% 0.16% 0.06% 1.05%
Income (loss) before income taxes 17.30% 12.31% 8.22% -3.77% -10.93% -6.80%
(Provision for) benefit from income taxes -5.01 19.80 -1.84 -1.09 -0.80 -1.03
Net income (loss) 12.30% 32.11% 6.38% -4.85% -11.72% -7.83%

Based on: 10-K (reporting date: 2025-07-31), 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).


The common-size income statement reveals significant shifts in the company’s financial performance over the six-year period. Revenue consistently represents 100% of itself, as expected. A notable trend is the increasing proportion of revenue derived from subscription and support services, while product revenue declines. Simultaneously, the cost of revenue as a percentage of revenue demonstrates a decrease, improving gross profitability.

Revenue Composition
Product revenue decreased from 31.22% in 2020 to 19.54% in 2025, indicating a strategic shift or changing market dynamics. Conversely, subscription and support revenue increased substantially, rising from 68.78% in 2020 to 80.46% in 2025. This suggests a growing emphasis on recurring revenue models.
Profitability
Gross profit as a percentage of revenue initially declined from 70.68% to 68.76% before recovering to 73.41% in 2025. This improvement is likely linked to the decreasing cost of revenue percentage. Operating income experienced a dramatic turnaround, moving from an operating loss of -5.25% in 2020 to a substantial gain of 13.48% in 2025. This is driven by both revenue mix and expense management.
Expense Management
Operating expenses as a percentage of revenue decreased consistently from 75.93% in 2020 to 59.94% in 2025. This reduction is observed across all major expense categories: research and development, sales and marketing, and general and administrative expenses all show decreasing percentages of revenue. The most significant reduction is in sales and marketing expenses. General and administrative expenses show a particularly sharp decline in the later years.
Non-Operating Items
Interest expense decreased significantly over the period, while interest income increased. Other income, net, also shows a positive trend. These factors contribute to the overall improvement in income before income taxes. The provision for (benefit from) income taxes fluctuates considerably, moving from a provision in earlier years to a benefit in 2024 and back to a provision in 2025.
Net Income
Net income as a percentage of revenue demonstrates the most striking improvement, transitioning from a loss of -7.83% in 2020 to a gain of 32.11% in 2024, before decreasing to 12.30% in 2025. This substantial increase reflects the combined effects of improved gross margin, reduced operating expenses, and favorable non-operating items.

In summary, the company has undergone a significant transformation, shifting towards a subscription-based revenue model, improving operational efficiency, and achieving substantial profitability growth. While net income decreased slightly in the final year of the period, the overall trend indicates a positive trajectory.

AI Ask an analyst for more