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, 2023 Jul 31, 2022 Jul 31, 2021 Jul 31, 2020 Jul 31, 2019 Jul 31, 2018
United States 11.05 7.98 5.96 4.32 7.61 6.34
Other countries 11.35 12.63 12.55 11.86 19.27 18.48

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

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

Area Asset Turnover: United States

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

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

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
Area asset turnover = Revenue ÷ Long-lived assets
= 4,424,200 ÷ 400,400 = 11.05

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

Area Asset Turnover: Other countries

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

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

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
Area asset turnover = Revenue ÷ Long-lived assets
= 2,468,500 ÷ 217,400 = 11.35

Area activity ratio Geographic area The company
Area asset turnover Other countries Other countries area asset turnover ratio improved from 2021 to 2022 but then deteriorated significantly from 2022 to 2023.

Revenue

Palo Alto Networks Inc., revenue by geographic area

US$ in thousands

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

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


Long-lived assets

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

US$ in thousands

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

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