Stock Analysis on Net

Palo Alto Networks Inc. (NASDAQ:PANW)

Financial Reporting Quality: Aggregate Accruals

Microsoft Excel

Balance-Sheet-Based Accruals Ratio

Palo Alto Networks Inc., balance sheet computation of aggregate accruals

US$ in thousands

Microsoft Excel
Jul 31, 2024 Jul 31, 2023 Jul 31, 2022 Jul 31, 2021 Jul 31, 2020 Jul 31, 2019
Operating Assets
Total assets 19,990,900 14,501,100 12,253,600 10,241,600 9,065,400 6,592,200
Less: Cash and cash equivalents 1,535,200 1,135,300 2,118,500 1,874,200 2,958,000 961,400
Less: Short-term investments 1,043,600 1,254,700 1,516,000 1,026,900 789,800 1,841,700
Operating assets 17,412,100 12,111,100 8,619,100 7,340,500 5,317,600 3,789,100
Operating Liabilities
Total liabilities 14,821,200 12,752,700 12,043,600 9,478,000 7,963,600 5,005,900
Less: Current portion of convertible senior notes, net 963,900 1,991,500 3,676,800 1,557,900
Less: Convertible senior notes, net, excluding current portion 1,668,100 3,084,100 1,430,000
Operating liabilities 13,857,300 10,761,200 8,366,800 6,252,000 4,879,500 3,575,900
 
Net operating assets1 3,554,800 1,349,900 252,300 1,088,500 438,100 213,200
Balance-sheet-based aggregate accruals2 2,204,900 1,097,600 (836,200) 650,400 224,900
Financial Ratio
Balance-sheet-based accruals ratio3 89.91% 137.01% -124.73% 85.21% 69.06%
Benchmarks
Balance-Sheet-Based Accruals Ratio, Competitors4
Accenture PLC 35.69% 16.32% 21.70% 27.93% 3.73%
Adobe Inc. -3.83% 1.85% -8.24% 14.14% 8.20%
Cadence Design Systems Inc. 11.17% 26.65% 4.43% 9.21%
CrowdStrike Holdings Inc.
International Business Machines Corp. 2.42% 1.55% -7.39% -9.64%
Intuit Inc. 3.35% -1.74% 85.68% 139.73% -1.39%
Microsoft Corp. 52.18% 22.96% 42.27% 40.52% 14.41%
Oracle Corp. 4.30% 51.77% 9.90% 5.62% 1.35%
Palantir Technologies Inc.
Salesforce Inc. -2.46% -2.30% 57.74% 10.87% 65.87%
ServiceNow Inc. 61.79% 12.89% 34.89% 19.95%
Synopsys Inc. 7.85% 13.85% 5.01% 0.36% 8.40%
Balance-Sheet-Based Accruals Ratio, Sector
Software & Services 0.00% 18.69% 29.34% 16.98% 8.01%
Balance-Sheet-Based Accruals Ratio, Industry
Information Technology 0.00% 9.02% 18.05% 19.29% 3.04%

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).

1 2024 Calculation
Net operating assets = Operating assets – Operating liabilities
= 17,412,10013,857,300 = 3,554,800

2 2024 Calculation
Balance-sheet-based aggregate accruals = Net operating assets2024 – Net operating assets2023
= 3,554,8001,349,900 = 2,204,900

3 2024 Calculation
Balance-sheet-based accruals ratio = 100 × Balance-sheet-based aggregate accruals ÷ Avg. net operating assets
= 100 × 2,204,900 ÷ [(3,554,800 + 1,349,900) ÷ 2] = 89.91%

4 Click competitor name to see calculations.

Financial ratio Description The company
Balance-sheet-based accruals ratio Ratio is found by dividing balance-sheet-based aggregate accruals by average net operating assets. Using the balance-sheet-based accruals ratio, Palo Alto Networks Inc. improved earnings quality from 2023 to 2024.

Cash-Flow-Statement-Based Accruals Ratio

Palo Alto Networks Inc., cash flow statement computation of aggregate accruals

US$ in thousands

Microsoft Excel
Jul 31, 2024 Jul 31, 2023 Jul 31, 2022 Jul 31, 2021 Jul 31, 2020 Jul 31, 2019
Net income (loss) 2,577,600 439,700 (267,000) (498,900) (267,000) (81,900)
Less: Net cash provided by operating activities 3,257,600 2,777,500 1,984,700 1,503,000 1,035,700 1,055,600
Less: Net cash (used in) provided by investing activities (1,509,900) (2,033,800) (933,400) (1,480,600) 288,000 (1,825,900)
Cash-flow-statement-based aggregate accruals 829,900 (304,000) (1,318,300) (521,300) (1,590,700) 688,400
Financial Ratio
Cash-flow-statement-based accruals ratio1 33.84% -37.95% -196.64% -68.30% -488.47%
Benchmarks
Cash-Flow-Statement-Based Accruals Ratio, Competitors2
Accenture PLC 24.31% -0.19% 11.87% 11.80% -13.65%
Adobe Inc. -21.90% -21.73% -19.93% 9.21% -0.48%
Cadence Design Systems Inc. 3.78% 15.03% -5.75% -1.21%
CrowdStrike Holdings Inc.
International Business Machines Corp. 0.99% -7.22% -1.64% -13.41%
Intuit Inc. -8.44% -8.74% 25.60% 58.72% -34.22%
Microsoft Corp. 30.89% 5.22% 13.42% 17.68% -8.19%
Oracle Corp. -1.01% 42.79% -30.58% 25.81% -31.35%
Palantir Technologies Inc.
Salesforce Inc. -8.44% -8.49% 21.96% 10.57% -5.62%
ServiceNow Inc. 15.44% 8.80% -21.14% -12.82%
Synopsys Inc. -7.64% 0.20% -4.64% -4.88% 0.92%
Cash-Flow-Statement-Based Accruals Ratio, Sector
Software & Services 0.00% 7.32% 2.04% 11.47% -14.91%
Cash-Flow-Statement-Based Accruals Ratio, Industry
Information Technology 0.00% 1.41% 2.96% 8.76% -7.84%

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).

1 2024 Calculation
Cash-flow-statement-based accruals ratio = 100 × Cash-flow-statement-based aggregate accruals ÷ Avg. net operating assets
= 100 × 829,900 ÷ [(3,554,800 + 1,349,900) ÷ 2] = 33.84%

2 Click competitor name to see calculations.

Financial ratio Description The company
Cash-flow-statement-based accruals ratio Ratio is found by dividing cash-flow-statement-based aggregate accruals by average net operating assets. Using the cash-flow-statement-based accruals ratio, Palo Alto Networks Inc. improved earnings quality from 2023 to 2024.