Stock Analysis on Net

Palo Alto Networks Inc. (NASDAQ:PANW)

Common-Size Balance Sheet: Assets 
Quarterly Data

Palo Alto Networks Inc., common-size consolidated balance sheet: assets (quarterly data)

Microsoft Excel
Apr 30, 2025 Jan 31, 2025 Oct 31, 2024 Jul 31, 2024 Apr 30, 2024 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
Cash and cash equivalents 10.83 10.63 11.20 7.68 7.66 9.74 16.82 7.83 14.06 10.23 16.48 17.29 21.80 18.49 21.80 18.30 19.72 22.27 24.55 32.63 22.84 27.84 18.52 14.58 21.00 19.76 30.76
Short-term investments 4.17 4.80 5.44 5.22 8.46 8.68 9.47 8.65 13.87 15.20 13.84 12.37 13.11 13.63 11.40 10.03 11.08 11.15 12.33 8.71 8.52 15.78 23.41 27.94 27.68 29.82 24.47
Accounts receivable, net of allowance for credit losses 8.86 7.14 5.56 13.10 9.57 10.37 9.54 16.99 10.19 9.71 9.87 17.48 11.18 9.16 7.79 12.11 8.02 7.05 7.74 11.44 10.29 7.52 7.31 8.83 6.51 7.27 6.59
Short-term financing receivables, net 3.35 3.60 3.95 3.63 3.19 2.44 3.01 2.68 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00
Short-term deferred contract costs 1.76 1.80 1.80 1.85 1.88 1.79 2.22 2.34 2.24 2.38 2.48 2.59 2.58 2.67 2.62 2.70 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00
Prepaid expenses and other current assets 2.38 2.29 2.68 2.79 2.25 2.22 2.68 3.22 4.90 3.55 3.04 2.61 2.66 2.87 2.81 2.24 4.48 4.59 4.67 3.80 4.71 4.23 4.24 4.24 4.18 4.25 3.95
Current assets 31.36% 30.26% 30.64% 34.26% 33.01% 35.24% 43.74% 41.71% 45.26% 41.07% 45.71% 52.35% 51.33% 46.81% 46.41% 45.38% 43.31% 45.06% 49.29% 56.58% 46.36% 55.38% 53.48% 55.59% 59.37% 61.10% 65.76%
Property and equipment, net 1.67 1.71 1.77 1.81 1.95 1.93 2.38 2.44 2.41 2.62 2.82 2.92 3.20 3.49 3.11 3.11 3.37 3.49 3.87 3.84 5.49 4.33 4.64 4.49 4.39 4.79 4.77
Operating lease right-of-use assets 1.62 1.78 1.91 1.93 2.06 1.95 1.85 1.82 1.75 1.91 2.08 1.97 2.16 2.30 2.42 2.57 2.71 2.66 2.88 2.85 4.06 3.76 4.14 0.00 0.00 0.00 0.00
Long-term investments 23.42 21.76 20.22 20.88 19.54 19.79 20.18 21.02 19.12 21.43 16.70 8.58 6.44 8.18 8.62 8.67 9.26 9.03 10.01 6.12 2.33 4.43 6.85 8.73 10.70 14.17 9.75
Long-term financing receivables, net 4.86 5.55 5.36 5.91 4.92 3.50 4.32 4.51 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00
Long-term deferred contract costs 2.40 2.50 2.61 2.81 2.85 2.76 3.48 3.77 3.55 3.88 4.15 4.49 4.33 4.54 4.57 4.83 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00
Goodwill 18.41 19.33 19.88 16.76 18.81 18.44 19.76 20.18 20.65 22.12 21.90 22.42 24.61 26.26 26.21 26.46 28.37 27.23 22.56 20.00 27.88 21.04 20.52 20.51 16.41 11.15 10.97
Intangible assets, net 3.32 3.68 3.97 1.88 2.27 2.41 1.96 2.18 2.40 2.75 2.83 3.14 3.71 4.27 4.52 4.87 5.55 5.70 4.46 3.95 5.85 4.04 4.16 4.26 3.74 3.01 3.21
Deferred tax assets 11.14 11.68 11.77 12.00 12.78 12.21 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00
Other assets 1.80 1.74 1.87 1.77 1.79 1.78 2.31 2.38 4.84 4.22 3.81 4.12 4.22 4.15 4.15 4.11 7.44 6.83 6.94 6.66 8.03 7.03 6.21 6.42 5.40 5.78 5.55
Long-term assets 68.64% 69.74% 69.36% 65.74% 66.99% 64.76% 56.26% 58.29% 54.74% 58.93% 54.29% 47.65% 48.67% 53.19% 53.59% 54.62% 56.69% 54.94% 50.71% 43.42% 53.64% 44.62% 46.52% 44.41% 40.63% 38.90% 34.24%
Total assets 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% 100.00%

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


Cash and Cash Equivalents
The proportion of cash and cash equivalents as a percentage of total assets demonstrated a generally declining trend from 30.76% in October 2018 to a low of approximately 7.66%-7.68% in mid-2024, with some fluctuations in between. A notable drop occurred after January 2022, reaching the lowest levels toward late 2023 and early 2024, followed by a minor recovery in the latest periods.
Short-term Investments
Short-term investments as a percentage of total assets fluctuated over time, starting at 24.47% in October 2018, peaking near 29.82% in early 2019, and then generally decreasing to below 5% by the first quarter of 2025. The data indicates a significant decline after early 2020, with persistent lower levels through subsequent periods.
Accounts Receivable, Net
The accounts receivable metric showed variability without a clear, consistent trend. Initially around 6.59%-7.31% in 2018 and early 2019, it increased notably in late 2021 and into 2022, reaching peaks above 17%, before experiencing fluctuations around 9% to 13% in subsequent quarters. This suggests fluctuations in receivables possibly associated with business cycles or sales activities.
Short-term Financing Receivables
This category appears only in later periods, beginning near 2.68% in late 2022 and fluctuating modestly between approximately 2.44% and 3.95% through 2024. Its emergence indicates an increasing use of short-term financing assets in recent years.
Short-term Deferred Contract Costs
From available data starting in 2020, these costs remained relatively stable, showing a slow decline from about 2.7% to approximately 1.76% of total assets by early 2025, indicating conservative or stable contract-related deferred expenses.
Prepaid Expenses and Other Current Assets
This category was around 3.95%-4.24% initially, with some variability, dropping notably in mid to late 2021 to as low as 2.24%, but then oscillating slightly between 2.22% and 4.9%. The data indicates moderate fluctuation with no strong upward or downward trend overall.
Current Assets
Current assets as a percentage of total assets showed a decreasing trend over the analyzed period, starting at 65.76% in late 2018 and declining to the 30%-35% range by early 2025. This reflects a considerable shift away from current assets towards long-term asset composition over time.
Property and Equipment, Net
Property and equipment as a percentage of total assets declined steadily, from close to 4.77% in 2018 to about 1.67% in 2025. This downward trend may reflect asset disposals, reduced capital expenditures, or reclassification influences.
Operating Lease Right-of-use Assets
These assets appeared starting in 2019 at around 4.14% and declined steadily to approximately 1.62% by 2025, indicating decreasing reliance or recognition of lease-related right-of-use assets over the period.
Long-term Investments
Long-term investments displayed a fluctuating pattern with an initial rise from about 9.75% in 2018 to peaks above 21% in 2023-2024, followed by a slight increase toward 23.42% in 2025. This suggests an increased emphasis on long-term investment holdings in more recent years.
Long-term Financing Receivables, Net
Appearing in the data only after 2022, long-term financing receivables varied between roughly 3.5% and 5.91%, indicating growing but variable participation in long-term financing activities during this timeframe.
Long-term Deferred Contract Costs
Available from 2020 onwards, these costs decreased gradually from around 4.83% to roughly 2.4% by early 2025, suggesting diminishing deferred costs associated with long-term contracts.
Goodwill
Goodwill accounted for a significant portion of total assets. It increased substantially from 10.97% in late 2018 to a peak above 28% around early 2021, then declined moderately and stabilized around 18%-20% through early 2025. This pattern might reflect acquisitions followed by impairment or amortization adjustments.
Intangible Assets, Net
These assets rose from 3.21% in 2018 to about 5.7% in early 2021 but subsequently declined steadily to below 3.5% by 2025, possibly reflecting amortization or reduced capitalized intangible asset additions.
Deferred Tax Assets
Data available starting in early 2023 shows deferred tax assets consistently representing about 11%-12.8% of total assets, indicating a stable level of deferred tax asset recognition in recent periods.
Other Assets
Other assets were relatively stable in the range of about 5.55% to 8.03% up to 2020, then declined steadily to around 1.74%-1.8% by 2025, indicative of asset reclassification or disposal.
Long-term Assets
Long-term assets as a percentage of total assets increased considerably from 34.24% in late 2018 to a peak near 69% in 2024-2025, reflecting a strategic shift toward greater asset longevity and potential capital investment or acquisition activity.