Stock Analysis on Net

Palo Alto Networks Inc. (NASDAQ:PANW)

Financial Reporting Quality: Aggregate Accruals

Microsoft Excel

Earnings can be decomposed into cash and accrual components. The accrual component (aggregate accruals) has been found to have less persistence than the cash component, and therefore (1) earnings with higher accrual component are less persistent than earnings with smaller accrual component, all else equal; and (2) the cash component of earnings should receive a higher weighting evaluating company performance.


Balance-Sheet-Based Accruals Ratio

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

US$ in thousands

Microsoft Excel
Jul 31, 2023 Jul 31, 2022 Jul 31, 2021 Jul 31, 2020 Jul 31, 2019 Jul 31, 2018
Operating Assets
Total assets 14,501,100 12,253,600 10,241,600 9,065,400 6,592,200 5,823,000
Less: Cash and cash equivalents 1,135,300 2,118,500 1,874,200 2,958,000 961,400 2,506,900
Less: Short-term investments 1,254,700 1,516,000 1,026,900 789,800 1,841,700 896,500
Operating assets 12,111,100 8,619,100 7,340,500 5,317,600 3,789,100 2,419,600
Operating Liabilities
Total liabilities 12,752,700 12,043,600 9,478,000 7,963,600 5,005,900 4,834,700
Less: Current portion of convertible senior notes, net 1,991,500 3,676,800 1,557,900 550,400
Less: Convertible senior notes, net, excluding current portion 1,668,100 3,084,100 1,430,000 1,369,700
Operating liabilities 10,761,200 8,366,800 6,252,000 4,879,500 3,575,900 2,914,600
 
Net operating assets1 1,349,900 252,300 1,088,500 438,100 213,200 (495,000)
Balance-sheet-based aggregate accruals2 1,097,600 (836,200) 650,400 224,900 708,200
Financial Ratio
Balance-sheet-based accruals ratio3 137.01% -124.73% 85.21% 69.06%
Benchmarks
Balance-Sheet-Based Accruals Ratio, Competitors4
Accenture PLC 16.32% 21.70% 27.93% 3.73% 42.14%
Adobe Inc. 1.85% -8.24% 14.14% 8.20% 2.25%
International Business Machines Corp. 2.42% 1.55% -7.39% -9.64%
Intuit Inc. -1.74% 85.68% 139.73% -1.39% 29.27%
Microsoft Corp. 22.96% 42.27% 40.52% 14.41% 46.31%
Oracle Corp. 51.77% 9.90% 5.62% 1.35% 2.79%
Salesforce Inc. -2.30% 57.74% 10.87% 65.87%
ServiceNow Inc. 61.79% 12.89% 34.89% 19.95%
Synopsys Inc. 13.85% 5.01% 0.36% 8.40% 7.93%
Balance-Sheet-Based Accruals Ratio, Sector
Software & Services 18.82% 29.21% 17.08% 8.21% 200.00%
Balance-Sheet-Based Accruals Ratio, Industry
Information Technology 9.17% 21.79% 21.33% 2.87% 200.00%

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

1 2023 Calculation
Net operating assets = Operating assets – Operating liabilities
= 12,111,10010,761,200 = 1,349,900

2 2023 Calculation
Balance-sheet-based aggregate accruals = Net operating assets2023 – Net operating assets2022
= 1,349,900252,300 = 1,097,600

3 2023 Calculation
Balance-sheet-based accruals ratio = 100 × Balance-sheet-based aggregate accruals ÷ Avg. net operating assets
= 100 × 1,097,600 ÷ [(1,349,900 + 252,300) ÷ 2] = 137.01%

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. deteriorated earnings quality from 2022 to 2023.

Cash-Flow-Statement-Based Accruals Ratio

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

US$ in thousands

Microsoft Excel
Jul 31, 2023 Jul 31, 2022 Jul 31, 2021 Jul 31, 2020 Jul 31, 2019 Jul 31, 2018
Net income (loss) 439,700 (267,000) (498,900) (267,000) (81,900) (147,900)
Less: Net cash provided by operating activities 2,777,500 1,984,700 1,503,000 1,035,700 1,055,600 1,037,000
Less: Net cash (used in) provided by investing activities (2,033,800) (933,400) (1,480,600) 288,000 (1,825,900) (520,000)
Cash-flow-statement-based aggregate accruals (304,000) (1,318,300) (521,300) (1,590,700) 688,400 (664,900)
Financial Ratio
Cash-flow-statement-based accruals ratio1 -37.95% -196.64% -68.30% -488.47%
Benchmarks
Cash-Flow-Statement-Based Accruals Ratio, Competitors2
Accenture PLC -0.19% 11.87% 11.80% -13.65% -1.28%
Adobe Inc. -21.73% -19.93% 9.21% -0.48% -9.78%
International Business Machines Corp. 0.99% -7.22% -1.64% -13.41%
Intuit Inc. -8.74% 25.60% 58.72% -34.22% -15.95%
Microsoft Corp. 5.22% 13.42% 17.68% -8.19% 7.37%
Oracle Corp. 42.79% -30.58% 25.81% -31.35% -74.80%
Salesforce Inc. -8.49% 21.96% 10.57% -5.62%
ServiceNow Inc. 15.44% 8.80% -21.14% -12.82%
Synopsys Inc. 0.20% -4.64% -4.88% 0.92% -0.96%
Cash-Flow-Statement-Based Accruals Ratio, Sector
Software & Services 6.92% 2.20% 12.17% -14.79% -3.07%
Cash-Flow-Statement-Based Accruals Ratio, Industry
Information Technology 1.25% 3.82% 10.69% -8.36% -22.15%

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

1 2023 Calculation
Cash-flow-statement-based accruals ratio = 100 × Cash-flow-statement-based aggregate accruals ÷ Avg. net operating assets
= 100 × -304,000 ÷ [(1,349,900 + 252,300) ÷ 2] = -37.95%

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 2022 to 2023.