Adjusted Financial Ratios (Summary)
Adjusted Total Asset Turnover
Adjusted Current Ratio
Adjusted Debt to Equity
Adjusted Debt to Capital
Adjusted Financial Leverage
Adjusted Net Profit Margin
Adjusted Return on Equity (ROE)
Adjusted Return on Assets (ROA)

Palo Alto Networks Inc., adjusted financial ratios

	Jul 31, 2023	Jul 31, 2022	Jul 31, 2021	Jul 31, 2020	Jul 31, 2019	Jul 31, 2018
Activity Ratio
Total Asset Turnover
Reported	0.48	0.45	0.42	0.38	0.44	0.39
Adjusted	0.63	0.61	0.53	0.48	0.50	0.46
Liquidity Ratio
Current Ratio
Reported	0.78	0.77	0.91	1.91	1.78	1.93
Adjusted	1.98	1.38	1.96	7.99	7.78	4.75
Solvency Ratios
Debt to Equity
Reported	1.14	17.51	5.08	2.80	0.90	1.99
Adjusted	0.21	0.56	0.64	0.71	0.41	0.71
Debt to Capital
Reported	0.53	0.95	0.84	0.74	0.47	0.67
Adjusted	0.17	0.36	0.39	0.41	0.29	0.41
Financial Leverage
Reported	8.29	58.35	16.14	8.23	4.16	6.03
Adjusted	1.31	1.70	1.81	1.85	1.56	1.88
Profitability Ratios
Net Profit Margin
Reported	6.38%	-4.85%	-11.72%	-7.83%	-2.82%	-6.51%
Adjusted	30.08%	22.11%	12.63%	15.27%	14.87%	14.82%
Return on Equity (ROE)
Reported	25.15%	-127.14%	-78.63%	-24.23%	-5.16%	-15.30%
Adjusted	25.01%	22.94%	12.21%	13.48%	11.68%	12.77%
Return on Assets (ROA)
Reported	3.03%	-2.18%	-4.87%	-2.95%	-1.24%	-2.54%
Adjusted	19.06%	13.48%	6.75%	7.30%	7.48%	6.80%

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

Financial ratio	Description	The company
Adjusted total asset turnover	An activity ratio calculated as total revenue divided by adjusted total assets.	Palo Alto Networks Inc. adjusted total asset turnover ratio improved from 2021 to 2022 and from 2022 to 2023.
Adjusted current ratio	A liquidity ratio calculated as adjusted current assets divided by adjusted current liabilities.	Palo Alto Networks Inc. adjusted current ratio deteriorated from 2021 to 2022 but then improved from 2022 to 2023 exceeding 2021 level.
Adjusted debt-to-equity ratio	A solvency ratio calculated as adjusted total debt divided by adjusted total equity.	Palo Alto Networks Inc. adjusted debt-to-equity ratio improved from 2021 to 2022 and from 2022 to 2023.
Adjusted debt-to-capital ratio	A solvency ratio calculated as adjusted total debt divided by adjusted total debt plus adjusted total equity.	Palo Alto Networks Inc. adjusted debt-to-capital ratio improved from 2021 to 2022 and from 2022 to 2023.
Adjusted financial leverage	A measure of financial leverage calculated as adjusted total assets divided by adjusted total equity. Financial leverage is the extent to which a company can effect, through the use of debt, a proportional change in the return on common equity that is greater than a given proportional change in operating income.	Palo Alto Networks Inc. adjusted financial leverage ratio decreased from 2021 to 2022 and from 2022 to 2023.
Adjusted net profit margin	An indicator of profitability, calculated as adjusted net income divided by total revenue.	Palo Alto Networks Inc. adjusted net profit margin ratio improved from 2021 to 2022 and from 2022 to 2023.
Adjusted ROE	A profitability ratio calculated as adjusted net income divided by adjusted total equity.	Palo Alto Networks Inc. adjusted ROE improved from 2021 to 2022 and from 2022 to 2023.
Adjusted ROA	A profitability ratio calculated as adjusted net income divided by adjusted total assets.	Palo Alto Networks Inc. adjusted ROA improved from 2021 to 2022 and from 2022 to 2023.

Palo Alto Networks Inc., Financial Ratios: Reported vs. Adjusted

Download chart

	Jul 31, 2023	Jul 31, 2022	Jul 31, 2021	Jul 31, 2020	Jul 31, 2019	Jul 31, 2018
Reported
Selected Financial Data (US$ in thousands)
Revenue	6,892,700)	5,501,500)	4,256,100)	3,408,400)	2,899,600)	2,273,100)
Total assets	14,501,100)	12,253,600)	10,241,600)	9,065,400)	6,592,200)	5,823,000)
Activity Ratio
Total asset turnover¹	0.48	0.45	0.42	0.38	0.44	0.39
Adjusted
Selected Financial Data (US$ in thousands)
Adjusted revenue²	9,195,100)	7,471,500)	5,469,900)	4,329,900)	3,509,000)	2,864,500)
Adjusted total assets³	14,508,900)	12,251,300)	10,243,700)	9,058,700)	6,980,223)	6,245,332)
Activity Ratio
Adjusted total asset turnover⁴	0.63	0.61	0.53	0.48	0.50	0.46

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

¹ 2023 Calculation
Total asset turnover = Revenue ÷ Total assets
= 6,892,700 ÷ 14,501,100 = 0.48

² Adjusted revenue. See details »

³ Adjusted total assets. See details »

⁴ 2023 Calculation
Adjusted total asset turnover = Adjusted revenue ÷ Adjusted total assets
= 9,195,100 ÷ 14,508,900 = 0.63

Download chart

Activity ratio	Description	The company
Adjusted total asset turnover	An activity ratio calculated as total revenue divided by adjusted total assets.	Palo Alto Networks Inc. adjusted total asset turnover ratio improved from 2021 to 2022 and from 2022 to 2023.

	Jul 31, 2023	Jul 31, 2022	Jul 31, 2021	Jul 31, 2020	Jul 31, 2019	Jul 31, 2018
Reported
Selected Financial Data (US$ in thousands)
Current assets	6,048,000)	6,414,900)	4,647,300)	5,129,200)	3,664,800)	4,132,000)
Current liabilities	7,737,500)	8,306,300)	5,116,700)	2,691,700)	2,053,300)	2,139,400)
Liquidity Ratio
Current ratio¹	0.78	0.77	0.91	1.91	1.78	1.93
Adjusted
Selected Financial Data (US$ in thousands)
Adjusted current assets²	6,055,800)	6,423,800)	4,658,500)	5,131,500)	3,665,600)	4,133,200)
Adjusted current liabilities³	3,062,900)	4,665,100)	2,374,800)	642,600)	471,200)	870,500)
Liquidity Ratio
Adjusted current ratio⁴	1.98	1.38	1.96	7.99	7.78	4.75

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

¹ 2023 Calculation
Current ratio = Current assets ÷ Current liabilities
= 6,048,000 ÷ 7,737,500 = 0.78

² Adjusted current assets. See details »

³ Adjusted current liabilities. See details »

⁴ 2023 Calculation
Adjusted current ratio = Adjusted current assets ÷ Adjusted current liabilities
= 6,055,800 ÷ 3,062,900 = 1.98

Download chart

Liquidity ratio	Description	The company
Adjusted current ratio	A liquidity ratio calculated as adjusted current assets divided by adjusted current liabilities.	Palo Alto Networks Inc. adjusted current ratio deteriorated from 2021 to 2022 but then improved from 2022 to 2023 exceeding 2021 level.

	Jul 31, 2023	Jul 31, 2022	Jul 31, 2021	Jul 31, 2020	Jul 31, 2019	Jul 31, 2018
Reported
Selected Financial Data (US$ in thousands)
Total debt	1,991,500)	3,676,800)	3,226,000)	3,084,100)	1,430,000)	1,920,100)
Stockholders’ equity	1,748,400)	210,000)	634,500)	1,101,800)	1,586,300)	966,400)
Solvency Ratio
Debt to equity¹	1.14	17.51	5.08	2.80	0.90	1.99
Adjusted
Selected Financial Data (US$ in thousands)
Adjusted total debt²	2,330,900)	4,015,200)	3,605,200)	3,478,600)	1,824,223)	2,349,732)
Adjusted stockholders’ equity³	11,058,000)	7,201,700)	5,660,600)	4,905,300)	4,468,800)	3,324,000)
Solvency Ratio
Adjusted debt to equity⁴	0.21	0.56	0.64	0.71	0.41	0.71

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

¹ 2023 Calculation
Debt to equity = Total debt ÷ Stockholders’ equity
= 1,991,500 ÷ 1,748,400 = 1.14

² Adjusted total debt. See details »

³ Adjusted stockholders’ equity. See details »

⁴ 2023 Calculation
Adjusted debt to equity = Adjusted total debt ÷ Adjusted stockholders’ equity
= 2,330,900 ÷ 11,058,000 = 0.21

Download chart

Solvency ratio	Description	The company
Adjusted debt-to-equity ratio	A solvency ratio calculated as adjusted total debt divided by adjusted total equity.	Palo Alto Networks Inc. adjusted debt-to-equity ratio improved from 2021 to 2022 and from 2022 to 2023.

	Jul 31, 2023	Jul 31, 2022	Jul 31, 2021	Jul 31, 2020	Jul 31, 2019	Jul 31, 2018
Reported
Selected Financial Data (US$ in thousands)
Total debt	1,991,500)	3,676,800)	3,226,000)	3,084,100)	1,430,000)	1,920,100)
Total capital	3,739,900)	3,886,800)	3,860,500)	4,185,900)	3,016,300)	2,886,500)
Solvency Ratio
Debt to capital¹	0.53	0.95	0.84	0.74	0.47	0.67
Adjusted
Selected Financial Data (US$ in thousands)
Adjusted total debt²	2,330,900)	4,015,200)	3,605,200)	3,478,600)	1,824,223)	2,349,732)
Adjusted total capital³	13,388,900)	11,216,900)	9,265,800)	8,383,900)	6,293,023)	5,673,732)
Solvency Ratio
Adjusted debt to capital⁴	0.17	0.36	0.39	0.41	0.29	0.41

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

¹ 2023 Calculation
Debt to capital = Total debt ÷ Total capital
= 1,991,500 ÷ 3,739,900 = 0.53

² Adjusted total debt. See details »

³ Adjusted total capital. See details »

⁴ 2023 Calculation
Adjusted debt to capital = Adjusted total debt ÷ Adjusted total capital
= 2,330,900 ÷ 13,388,900 = 0.17

Download chart

Solvency ratio	Description	The company
Adjusted debt-to-capital ratio	A solvency ratio calculated as adjusted total debt divided by adjusted total debt plus adjusted total equity.	Palo Alto Networks Inc. adjusted debt-to-capital ratio improved from 2021 to 2022 and from 2022 to 2023.

	Jul 31, 2023	Jul 31, 2022	Jul 31, 2021	Jul 31, 2020	Jul 31, 2019	Jul 31, 2018
Reported
Selected Financial Data (US$ in thousands)
Total assets	14,501,100)	12,253,600)	10,241,600)	9,065,400)	6,592,200)	5,823,000)
Stockholders’ equity	1,748,400)	210,000)	634,500)	1,101,800)	1,586,300)	966,400)
Solvency Ratio
Financial leverage¹	8.29	58.35	16.14	8.23	4.16	6.03
Adjusted
Selected Financial Data (US$ in thousands)
Adjusted total assets²	14,508,900)	12,251,300)	10,243,700)	9,058,700)	6,980,223)	6,245,332)
Adjusted stockholders’ equity³	11,058,000)	7,201,700)	5,660,600)	4,905,300)	4,468,800)	3,324,000)
Solvency Ratio
Adjusted financial leverage⁴	1.31	1.70	1.81	1.85	1.56	1.88

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

¹ 2023 Calculation
Financial leverage = Total assets ÷ Stockholders’ equity
= 14,501,100 ÷ 1,748,400 = 8.29

² Adjusted total assets. See details »

³ Adjusted stockholders’ equity. See details »

⁴ 2023 Calculation
Adjusted financial leverage = Adjusted total assets ÷ Adjusted stockholders’ equity
= 14,508,900 ÷ 11,058,000 = 1.31

Download chart

Solvency ratio	Description	The company
Adjusted financial leverage	A measure of financial leverage calculated as adjusted total assets divided by adjusted total equity. Financial leverage is the extent to which a company can effect, through the use of debt, a proportional change in the return on common equity that is greater than a given proportional change in operating income.	Palo Alto Networks Inc. adjusted financial leverage ratio decreased from 2021 to 2022 and from 2022 to 2023.

	Jul 31, 2023	Jul 31, 2022	Jul 31, 2021	Jul 31, 2020	Jul 31, 2019	Jul 31, 2018
Reported
Selected Financial Data (US$ in thousands)
Net income (loss)	439,700)	(267,000)	(498,900)	(267,000)	(81,900)	(147,900)
Revenue	6,892,700)	5,501,500)	4,256,100)	3,408,400)	2,899,600)	2,273,100)
Profitability Ratio
Net profit margin¹	6.38%	-4.85%	-11.72%	-7.83%	-2.82%	-6.51%
Adjusted
Selected Financial Data (US$ in thousands)
Adjusted net income (loss)²	2,765,900)	1,651,900)	691,000)	661,100)	521,800)	424,400)
Adjusted revenue³	9,195,100)	7,471,500)	5,469,900)	4,329,900)	3,509,000)	2,864,500)
Profitability Ratio
Adjusted net profit margin⁴	30.08%	22.11%	12.63%	15.27%	14.87%	14.82%

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

¹ 2023 Calculation
Net profit margin = 100 × Net income (loss) ÷ Revenue
= 100 × 439,700 ÷ 6,892,700 = 6.38%

² Adjusted net income (loss). See details »

³ Adjusted revenue. See details »

⁴ 2023 Calculation
Adjusted net profit margin = 100 × Adjusted net income (loss) ÷ Adjusted revenue
= 100 × 2,765,900 ÷ 9,195,100 = 30.08%

Download chart

Profitability ratio	Description	The company
Adjusted net profit margin	An indicator of profitability, calculated as adjusted net income divided by total revenue.	Palo Alto Networks Inc. adjusted net profit margin ratio improved from 2021 to 2022 and from 2022 to 2023.

	Jul 31, 2023	Jul 31, 2022	Jul 31, 2021	Jul 31, 2020	Jul 31, 2019	Jul 31, 2018
Reported
Selected Financial Data (US$ in thousands)
Net income (loss)	439,700)	(267,000)	(498,900)	(267,000)	(81,900)	(147,900)
Stockholders’ equity	1,748,400)	210,000)	634,500)	1,101,800)	1,586,300)	966,400)
Profitability Ratio
ROE¹	25.15%	-127.14%	-78.63%	-24.23%	-5.16%	-15.30%
Adjusted
Selected Financial Data (US$ in thousands)
Adjusted net income (loss)²	2,765,900)	1,651,900)	691,000)	661,100)	521,800)	424,400)
Adjusted stockholders’ equity³	11,058,000)	7,201,700)	5,660,600)	4,905,300)	4,468,800)	3,324,000)
Profitability Ratio
Adjusted ROE⁴	25.01%	22.94%	12.21%	13.48%	11.68%	12.77%

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

¹ 2023 Calculation
ROE = 100 × Net income (loss) ÷ Stockholders’ equity
= 100 × 439,700 ÷ 1,748,400 = 25.15%

² Adjusted net income (loss). See details »

³ Adjusted stockholders’ equity. See details »

⁴ 2023 Calculation
Adjusted ROE = 100 × Adjusted net income (loss) ÷ Adjusted stockholders’ equity
= 100 × 2,765,900 ÷ 11,058,000 = 25.01%

Download chart

Profitability ratio	Description	The company
Adjusted ROE	A profitability ratio calculated as adjusted net income divided by adjusted total equity.	Palo Alto Networks Inc. adjusted ROE improved from 2021 to 2022 and from 2022 to 2023.

	Jul 31, 2023	Jul 31, 2022	Jul 31, 2021	Jul 31, 2020	Jul 31, 2019	Jul 31, 2018
Reported
Selected Financial Data (US$ in thousands)
Net income (loss)	439,700)	(267,000)	(498,900)	(267,000)	(81,900)	(147,900)
Total assets	14,501,100)	12,253,600)	10,241,600)	9,065,400)	6,592,200)	5,823,000)
Profitability Ratio
ROA¹	3.03%	-2.18%	-4.87%	-2.95%	-1.24%	-2.54%
Adjusted
Selected Financial Data (US$ in thousands)
Adjusted net income (loss)²	2,765,900)	1,651,900)	691,000)	661,100)	521,800)	424,400)
Adjusted total assets³	14,508,900)	12,251,300)	10,243,700)	9,058,700)	6,980,223)	6,245,332)
Profitability Ratio
Adjusted ROA⁴	19.06%	13.48%	6.75%	7.30%	7.48%	6.80%

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

¹ 2023 Calculation
ROA = 100 × Net income (loss) ÷ Total assets
= 100 × 439,700 ÷ 14,501,100 = 3.03%

² Adjusted net income (loss). See details »

³ Adjusted total assets. See details »

⁴ 2023 Calculation
Adjusted ROA = 100 × Adjusted net income (loss) ÷ Adjusted total assets
= 100 × 2,765,900 ÷ 14,508,900 = 19.06%

Download chart

Profitability ratio	Description	The company
Adjusted ROA	A profitability ratio calculated as adjusted net income divided by adjusted total assets.	Palo Alto Networks Inc. adjusted ROA improved from 2021 to 2022 and from 2022 to 2023.

Palo Alto Networks Inc. (NASDAQ:PANW)

Adjusted Financial Ratios

Adjusted Financial Ratios (Summary)

Palo Alto Networks Inc., Financial Ratios: Reported vs. Adjusted

Adjusted Total Asset Turnover

Adjusted Current Ratio

Adjusted Debt to Equity

Adjusted Debt to Capital

Adjusted Financial Leverage

Adjusted Net Profit Margin

Adjusted Return on Equity (ROE)

Adjusted Return on Assets (ROA)