Stock Analysis on Net

Palo Alto Networks Inc. (NASDAQ:PANW)

Analysis of Geographic Areas

Microsoft Excel

Area Asset Turnover

Palo Alto Networks Inc., asset turnover by geographic area

Microsoft Excel
Jul 31, 2024 Jul 31, 2023 Jul 31, 2022 Jul 31, 2021 Jul 31, 2020 Jul 31, 2019
United States 11.70 11.05 7.98 5.96 4.32 7.61
Other countries 9.39 11.35 12.63 12.55 11.86 19.27

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

Area activity ratio Geographic area The company
Area asset turnover United States United States area asset turnover ratio improved from 2022 to 2023 and from 2023 to 2024.
Other countries Other countries area asset turnover ratio deteriorated from 2022 to 2023 and from 2023 to 2024.

Area Asset Turnover: United States

Palo Alto Networks Inc.; United States; area asset turnover calculation

Microsoft Excel
Jul 31, 2024 Jul 31, 2023 Jul 31, 2022 Jul 31, 2021 Jul 31, 2020 Jul 31, 2019
Selected Financial Data (US$ in thousands)
Revenue 5,134,000 4,424,200 3,560,300 2,747,800 2,168,600 1,830,300
Long-lived assets 438,900 400,400 446,100 461,100 502,300 240,500
Area Activity Ratio
Area asset turnover1 11.70 11.05 7.98 5.96 4.32 7.61

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
Area asset turnover = Revenue ÷ Long-lived assets
= 5,134,000 ÷ 438,900 = 11.70

Area activity ratio Geographic area The company
Area asset turnover United States United States area asset turnover ratio improved from 2022 to 2023 and from 2023 to 2024.

Area Asset Turnover: Other countries

Palo Alto Networks Inc.; Other countries; area asset turnover calculation

Microsoft Excel
Jul 31, 2024 Jul 31, 2023 Jul 31, 2022 Jul 31, 2021 Jul 31, 2020 Jul 31, 2019
Selected Financial Data (US$ in thousands)
Revenue 2,893,500 2,468,500 1,941,200 1,508,300 1,239,800 1,069,300
Long-lived assets 308,100 217,400 153,700 120,200 104,500 55,500
Area Activity Ratio
Area asset turnover1 9.39 11.35 12.63 12.55 11.86 19.27

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
Area asset turnover = Revenue ÷ Long-lived assets
= 2,893,500 ÷ 308,100 = 9.39

Area activity ratio Geographic area The company
Area asset turnover Other countries Other countries area asset turnover ratio deteriorated from 2022 to 2023 and from 2023 to 2024.

Revenue

Palo Alto Networks Inc., revenue by geographic area

US$ in thousands

Microsoft Excel
Jul 31, 2024 Jul 31, 2023 Jul 31, 2022 Jul 31, 2021 Jul 31, 2020 Jul 31, 2019
United States 5,134,000 4,424,200 3,560,300 2,747,800 2,168,600 1,830,300
Other countries 2,893,500 2,468,500 1,941,200 1,508,300 1,239,800 1,069,300
Total 8,027,500 6,892,700 5,501,500 4,256,100 3,408,400 2,899,600

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


Long-lived assets

Palo Alto Networks Inc., long-lived assets by geographic area

US$ in thousands

Microsoft Excel
Jul 31, 2024 Jul 31, 2023 Jul 31, 2022 Jul 31, 2021 Jul 31, 2020 Jul 31, 2019
United States 438,900 400,400 446,100 461,100 502,300 240,500
Other countries 308,100 217,400 153,700 120,200 104,500 55,500
Total 747,000 617,800 599,800 581,300 606,800 296,000

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