Stock Analysis on Net

Palo Alto Networks Inc. (NASDAQ:PANW)

Common-Size Income Statement 
Quarterly Data

Palo Alto Networks Inc., common-size consolidated income statement (quarterly data)

Microsoft Excel
3 months ended: Jan 31, 2024 Oct 31, 2023 Jul 31, 2023 Apr 30, 2023 Jan 31, 2023 Oct 31, 2022 Jul 31, 2022 Apr 30, 2022 Jan 31, 2022 Oct 31, 2021 Jul 31, 2021 Apr 30, 2021 Jan 31, 2021 Oct 31, 2020 Jul 31, 2020 Apr 30, 2020 Jan 31, 2020 Oct 31, 2019 Jul 31, 2019 Apr 30, 2019 Jan 31, 2019 Oct 31, 2018 Jul 31, 2018 Apr 30, 2018 Jan 31, 2018 Oct 31, 2017
Product 19.78 18.16 25.98 22.55 21.32 21.11 26.32 25.35 23.39 23.69 27.84 26.90 25.05 25.08 32.15 32.31 30.18 29.95 37.94 38.32 38.19 36.66 40.66 37.95 37.28 36.89
Subscription and support 80.22 81.84 74.02 77.45 78.68 78.89 73.68 74.65 76.61 76.31 72.16 73.10 74.95 74.92 67.85 67.69 69.82 70.05 62.06 61.68 61.81 63.34 59.34 62.05 62.72 63.11
Revenue 100.00% 100.00% 100.00% 100.00% 100.00% 100.00% 100.00% 100.00% 100.00% 100.00% 100.00% 100.00% 100.00% 100.00% 100.00% 100.00% 100.00% 100.00% 100.00% 100.00% 100.00% 100.00% 100.00% 100.00% 100.00% 100.00%
Product -4.47 -4.12 -5.34 -5.43 -6.07 -7.68 -9.21 -9.09 -7.43 -7.13 -7.28 -7.63 -7.43 -6.58 -9.19 -8.43 -8.41 -8.43 -10.20 -10.73 -11.60 -11.16 -12.46 -12.15 -11.78 -11.39
Subscription and support -20.80 -21.05 -20.61 -22.16 -22.10 -21.86 -22.54 -22.68 -23.35 -23.38 -22.15 -23.16 -22.81 -22.79 -21.37 -21.28 -20.13 -19.77 -16.78 -17.46 -16.89 -16.81 -15.61 -16.05 -17.59 -16.58
Cost of revenue -25.27% -25.17% -25.95% -27.59% -28.17% -29.54% -31.75% -31.77% -30.78% -30.51% -29.43% -30.78% -30.25% -29.37% -30.56% -29.71% -28.54% -28.20% -26.98% -28.20% -28.49% -27.97% -28.07% -28.20% -29.37% -27.97%
Gross profit 74.73% 74.83% 74.05% 72.41% 71.83% 70.46% 68.25% 68.23% 69.22% 69.49% 70.57% 69.22% 69.75% 70.63% 69.44% 70.29% 71.46% 71.80% 73.02% 71.80% 71.51% 72.03% 71.93% 71.80% 70.63% 72.03%
Research and development -22.68 -21.80 -21.22 -24.04 -24.42 -23.78 -23.46 -25.63 -27.26 -27.22 -26.68 -28.96 -26.23 -25.10 -22.72 -22.58 -22.70 -22.09 -19.69 -19.14 -18.04 -17.29 -16.76 -17.56 -17.81 -18.64
Sales and marketing -34.07 -35.17 -33.99 -37.16 -37.79 -39.34 -36.80 -39.20 -40.15 -40.56 -40.17 -41.72 -42.03 -41.08 -41.16 -44.67 -45.90 -47.38 -45.97 -46.66 -44.99 -47.96 -45.25 -48.86 -48.86 -51.14
General and administrative -15.27 -6.39 -5.87 -6.64 -7.21 -6.36 -6.99 -6.84 -7.42 -8.35 -8.67 -8.82 -10.23 -9.16 -7.44 -9.54 -9.33 -9.04 -8.59 -8.57 -7.55 -11.68 -8.62 -14.48 -9.83 -13.00
Operating expenses -72.02% -63.37% -61.08% -67.84% -69.42% -69.48% -67.26% -71.67% -74.83% -76.12% -75.52% -79.50% -78.48% -75.34% -71.32% -76.79% -77.94% -78.51% -74.25% -74.37% -70.58% -76.92% -70.63% -80.90% -76.49% -82.77%
Operating income (loss) 2.71% 11.46% 12.98% 4.57% 2.41% 0.97% 0.99% -3.43% -5.61% -6.63% -4.95% -10.28% -8.73% -4.70% -1.87% -6.50% -6.48% -6.71% -1.23% -2.57% 0.93% -4.89% 1.31% -9.10% -5.86% -10.74%
Interest expense -0.14 -0.15 -0.29 -0.45 -0.42 -0.43 -0.45 -0.49 -0.52 -0.55 -3.40 -3.82 -4.00 -4.25 -3.30 -2.23 -2.33 -2.45 -2.48 -2.84 -2.90 -3.46 -1.58 -1.15 -1.18 -1.25
Other income (expense), net 4.29 3.74 3.52 3.49 3.11 1.66 0.57 0.14 -0.01 -0.13 -0.04 0.09 -0.05 0.25 0.08 0.93 1.32 2.10 2.01 2.50 2.25 1.98 1.55 1.52 0.90 0.95
Income (loss) before income taxes 6.86% 15.05% 16.20% 7.61% 5.10% 2.20% 1.12% -3.79% -6.14% -7.31% -8.39% -14.01% -12.78% -8.70% -5.09% -7.80% -7.48% -7.06% -1.70% -2.90% 0.28% -6.37% 1.28% -8.73% -6.14% -11.04%
(Provision for) benefit from income taxes 81.59 -4.71 -4.55 -1.35 -0.01 -0.92 -0.90 -1.49 -0.96 -0.99 -1.39 0.49 -1.21 -1.05 -1.10 -0.81 -1.54 -0.66 -0.88 0.12 -0.65 0.53 -1.63 0.49 -0.29 -1.62
Net income (loss) 88.45% 10.34% 11.66% 6.26% 5.09% 1.28% 0.21% -5.28% -7.10% -8.31% -9.78% -13.51% -13.99% -9.75% -6.20% -8.60% -9.02% -7.72% -2.58% -2.78% -0.37% -5.84% -0.35% -8.23% -6.43% -12.66%

Based on: 10-Q (reporting date: 2024-01-31), 10-Q (reporting date: 2023-10-31), 10-K (reporting date: 2023-07-31), 10-Q (reporting date: 2023-04-30), 10-Q (reporting date: 2023-01-31), 10-Q (reporting date: 2022-10-31), 10-K (reporting date: 2022-07-31), 10-Q (reporting date: 2022-04-30), 10-Q (reporting date: 2022-01-31), 10-Q (reporting date: 2021-10-31), 10-K (reporting date: 2021-07-31), 10-Q (reporting date: 2021-04-30), 10-Q (reporting date: 2021-01-31), 10-Q (reporting date: 2020-10-31), 10-K (reporting date: 2020-07-31), 10-Q (reporting date: 2020-04-30), 10-Q (reporting date: 2020-01-31), 10-Q (reporting date: 2019-10-31), 10-K (reporting date: 2019-07-31), 10-Q (reporting date: 2019-04-30), 10-Q (reporting date: 2019-01-31), 10-Q (reporting date: 2018-10-31), 10-K (reporting date: 2018-07-31), 10-Q (reporting date: 2018-04-30), 10-Q (reporting date: 2018-01-31), 10-Q (reporting date: 2017-10-31).

Income statement item Description The company
Operating income (loss) The net result for the period of deducting operating expenses from operating revenues. Palo Alto Networks Inc. operating income (loss) as a percentage of revenue decreased from Q4 2023 to Q1 2024 and from Q1 2024 to Q2 2024.
Income (loss) before income taxes Amount of income (loss) from continuing operations, including income (loss) from equity method investments, before deduction of income tax expense (benefit), and income (loss) attributable to noncontrolling interest. Palo Alto Networks Inc. income (loss) before income taxes as a percentage of revenue decreased from Q4 2023 to Q1 2024 and from Q1 2024 to Q2 2024.
Net income (loss) The portion of profit or loss for the period, net of income taxes, which is attributable to the parent. Palo Alto Networks Inc. net income (loss) as a percentage of revenue decreased from Q4 2023 to Q1 2024 but then increased from Q1 2024 to Q2 2024 exceeding Q4 2023 level.