Cash flow Palo Alto Networks, Inc.

Equities

PANW

US6974351057

Software

Market Closed - Nasdaq Other stock markets 21:00:00 10/09/2024 BST			5-day change	1st Jan Change
347.58 ^USD	+1.03%		-2.11%	+17.87%

09-10	Rubrik shares fall as Microsoft-backed firm nears IPO lockup expiry	RE
09-09	Transcript : Palo Alto Networks, Inc. Presents at Goldman Sachs Communacopia + Technology Conference 2024, Sep-09-2024 10:10 AM

e27e3b7f662576a4.r_UuyalZnz5NKIOAh_IZ9IJhNXj2V_FQ66isAdVeiPk.mZQZiPs77wYqS8rB7rdVoeovfU2HB5kDhcvzR74X-Mr5pUb50Az3TRQc7A

Published financial data: PALO ALTO NETWORKS, INC.

Annual

Quarterly

Halfyear

YTD

LTM

Fiscal Period: July	2020	2021	2022	2023	2024
Revenues	3.41B	4.26B	5.5B	6.89B	8.03B
Total Revenues	3.41B	4.26B	5.5B	6.89B	8.03B
Cost of Goods Sold, Total	1B	1.27B	1.72B	1.91B	2.06B
Gross Profit	2.41B	2.98B	3.78B	4.98B	5.97B
Selling General & Admin Expenses, Total	1.81B	2.11B	2.55B	2.99B	3.29B
R&D Expenses	768M	1.14B	1.42B	1.6B	1.81B
Other Operating Expenses, Total	2.58B	3.25B	3.97B	4.6B	5.1B
Operating Income	-173M	-272M	-189M	387M	868M
Interest Expense, Total	-88.7M	-163M	-27.4M	-27.2M	-8.3M
Interest And Investment Income	41.4M	8.5M	15.6M	224M	318M
Net Interest Expenses	-47.3M	-155M	-11.8M	197M	310M
Currency Exchange Gains (Loss)	-6.7M	-5.4M	1.8M	-7.9M	200K
Other Non Operating Income (Expenses)	1.2M	-700K	-8.4M	-10.3M	-5.4M
EBT, Excl. Unusual Items	-226M	-433M	-207M	566M	1.17B
Restructuring Charges	-	-	-	-	-
Merger & Related Restructuring Charges	-6M	-32.4M	-	-	-
Legal Settlements	-	-	-	-	-184M
Other Unusual Items	-	-	-	-	-
EBT, Incl. Unusual Items	-232M	-465M	-207M	566M	988M
Income Tax Expense	35.2M	33.9M	59.8M	127M	-1.59B
Earnings From Continuing Operations	-267M	-499M	-267M	440M	2.58B
Net Income to Company	-267M	-499M	-267M	440M	2.58B
Net Income - (IS)	-267M	-499M	-267M	440M	2.58B
Net Income to Common Incl Extra Items	-267M	-499M	-267M	440M	2.58B
Net Income to Common Excl. Extra Items	-267M	-499M	-267M	440M	2.58B
Per Share Items
Net EPS - Basic	-0.92	-1.73	-0.9	1.45	8.08
Basic EPS - Continuing Operations	-0.92	-1.73	-0.9	1.45	8.08
Basic Weighted Average Shares Outstanding	291M	289M	296M	303M	319M
Net EPS - Diluted	-0.92	-1.73	-0.9	1.28	7.28
Diluted EPS - Continuing Operations	-0.92	-1.73	-0.9	1.28	7.28
Diluted Weighted Average Shares Outstanding	291M	289M	296M	342M	354M
Normalized Basic EPS	-0.49	-0.93	-0.44	1.17	2.3
Normalized Diluted EPS	-0.49	-0.93	-0.44	1.03	2.07
American Depositary Receipts Ratio (ADR)	0.02	0.02	0.02	0.02	0.02
Supplemental Items
EBITDA	1.8M	-59.1M	31.4M	590M	1.07B
EBITA	-95.7M	-154M	-61.9M	492M	989M
EBIT	-173M	-272M	-189M	387M	868M
EBITDAR	82.2M	16.1M	121M	681M	1.18B
Total Revenues (As Reported)	3.41B	4.26B	5.5B	6.89B	8.03B
Effective Tax Rate - (Ratio)	-15.19	-7.29	-28.86	22.36	-160.81
Current Domestic Taxes	5.1M	5M	4.1M	70.1M	315M
Current Foreign Taxes	39.2M	41.3M	58.8M	44M	130M
Total Current Taxes	44.3M	46.3M	62.9M	114M	444M
Deferred Domestic Taxes	-1.2M	-5.8M	-200K	19.7M	139M
Deferred Foreign Taxes	-7.9M	-6.6M	-2.9M	-7.2M	-2.17B
Total Deferred Taxes	-9.1M	-12.4M	-3.1M	12.5M	-2.03B
Normalized Net Income	-141M	-270M	-130M	354M	733M
Interest on Long-Term Debt	87.7M	163M	27.4M	25.8M	8.3M
Supplemental Operating Expense Items
Advertising Expense	-	-	-	-	-
Selling and Marketing Expenses	1.52B	1.75B	2.15B	2.54B	2.79B
General and Administrative Expenses	294M	359M	405M	448M	496M
Research And Development Expense From Footnotes	768M	1.14B	1.42B	1.6B	1.81B
Net Rental Expense, Total	80.4M	75.2M	89.7M	91.3M	105M
Imputed Operating Lease Interest Expense	23.25M	27.97M	5.2M	6.32M	3.78M
Imputed Operating Lease Depreciation	57.15M	47.23M	84.5M	84.98M	101M
Stock-Based Comp., COGS (Total)	83.4M	99.2M	120M	133M	128M
Stock-Based Comp., R&D Exp. (Total)	275M	429M	471M	488M	526M
Stock-Based Comp., S&M Exp. (Total)	214M	270M	305M	335M	301M
Stock-Based Comp., G&A Exp. (Total)	92M	129M	118M	130M	124M
Total Stock-Based Compensation	664M	927M	1.01B	1.09B	1.08B

Fiscal Period: July	2020	2021	2022	2023	2024
Assets
Cash And Equivalents	2.96B	1.87B	2.12B	1.14B	1.54B
Short Term Investments	790M	1.03B	1.52B	1.25B	1.04B
Total Cash And Short Term Investments	3.75B	2.9B	3.63B	2.39B	2.58B
Accounts Receivable, Total	1.04B	1.24B	2.14B	2.46B	2.62B
Other Receivables	-	79M	111M	389M	726M
Total Receivables	1.04B	1.32B	2.25B	2.85B	3.34B
Prepaid Expenses	122M	141M	200M	441M	542M
Restricted Cash	2.8M	5.4M	6.3M	6.9M	11.6M
Other Current Assets, Total	220M	281M	320M	358M	373M
Total Current Assets	5.13B	4.65B	6.41B	6.05B	6.85B
Gross Property Plant And Equipment	975M	980M	1.07B	1.15B	1.31B
Accumulated Depreciation	-368M	-399M	-470M	-528M	-559M
Net Property Plant And Equipment	607M	581M	600M	618M	747M
Long-term Investments	554M	888M	1.05B	3.05B	4.17B
Goodwill	1.81B	2.71B	2.75B	2.93B	3.35B
Other Intangibles, Total	448M	613M	515M	448M	504M
Deferred Tax Assets Long-Term	-	-	-	-	2.4B
Deferred Charges Long-Term	422M	495M	550M	547M	562M
Other Long-Term Assets, Total	91.5M	307M	374M	866M	1.41B
Total Assets	9.07B	10.24B	12.25B	14.5B	19.99B
Liabilities
Accounts Payable, Total	63.6M	56.9M	128M	132M	116M
Accrued Expenses, Total	521M	688M	766M	860M	980M
Current Portion of Long-Term Debt	-	1.56B	3.68B	1.99B	964M
Current Portion of Leases	57.9M	65.8M	62.3M	60.2M	65.9M
Unearned Revenue Current, Total	2.05B	2.74B	3.64B	4.67B	5.54B
Other Current Liabilities	-	6.4M	32.4M	18.7M	15.3M
Total Current Liabilities	2.69B	5.12B	8.31B	7.74B	7.68B
Long-Term Debt	3.08B	1.67B	-	-	-
Long-Term Leases	337M	313M	276M	279M	380M
Unearned Revenue Non Current	1.76B	2.28B	3.35B	4.62B	5.94B
Deferred Tax Liability Non Current	-	-	-	-	388M
Other Non Current Liabilities	90.1M	227M	108M	114M	431M
Total Liabilities	7.96B	9.61B	12.04B	12.75B	14.82B
Common Stock, Total	2.26B	2.31B	1.93B	3.02B	3.82B
Additional Paid In Capital	-	-	-	-	-
Retained Earnings	-1.17B	-1.67B	-1.67B	-1.23B	1.35B
Comprehensive Income and Other	10.5M	-9.9M	-55.6M	-43.2M	-1.6M
Total Common Equity	1.1B	634M	210M	1.75B	5.17B
Total Equity	1.1B	634M	210M	1.75B	5.17B
Total Liabilities And Equity	9.07B	10.24B	12.25B	14.5B	19.99B
Supplemental Items
ECS Total Shares Outstanding on Filing Date	289M	292M	299M	309M	326M
ECS Total Common Shares Outstanding	289M	292M	299M	308M	325M
Book Value / Share	3.81	2.17	0.7	5.67	15.9
Tangible Book Value	-1.16B	-2.69B	-3.05B	-1.63B	1.32B
Tangible Book Value Per Share	-4.01	-9.21	-10.22	-5.27	4.05
Total Debt	3.48B	3.61B	4.02B	2.33B	1.41B
Net Debt	-269M	704M	381M	-59.1M	-1.17B
Debt Equivalent Oper. Leases	643M	602M	718M	730M	838M
Account Code - Inventory Valuation	3	3	3	3	3
Land - (BS)	49.6M	49.6M	87.2M	87.2M	87.2M
Machinery, Total	347M	392M	449M	480M	515M
Full Time Employees	8.01K	10.47K	12.56K	13.95K	15.29K
Accumulated Allowance for Doubtful Accounts (Supple)	2.3M	11.2M	8.9M	7.8M	7.5M

Fiscal Period: July	2020	2021	2022	2023	2024
Net Income	-267M	-499M	-267M	440M	2.58B
Depreciation & Amortization - CF	145M	139M	148M	97.8M	85.2M
Amortization of Goodwill and Intangible Assets - (CF)	77.3M	118M	127M	105M	121M
Depreciation & Amortization, Total	222M	257M	275M	203M	206M
Amortization of Deferred Charges, Total - (CF)	360M	489M	432M	500M	527M
(Gain) Loss on Sale of Investments - (CF)	-6.2M	13.1M	13.5M	-52.2M	-60.1M
Asset Writedown & Restructuring Costs	-3.1M	-	-	-	-
Stock-Based Compensation (CF)	658M	894M	1.01B	1.07B	1.08B
Tax Benefit from Stock Options	-	-	-	-	-
Other Operating Activities, Total	-	-100K	-	49.9M	-1.98B
Change In Accounts Receivable	-436M	-172M	-902M	-320M	-154M
Change In Accounts Payable	-12.8M	-11.8M	69.3M	1M	-15M
Change in Unearned Revenues	893M	1.2B	1.97B	2.3B	2.18B
Change in Other Net Operating Assets	-373M	-663M	-616M	-1.42B	-1.1B
Cash from Operations	1.04B	1.5B	1.98B	2.78B	3.26B
Capital Expenditure	-214M	-116M	-193M	-146M	-157M
Cash Acquisitions	-584M	-777M	-37M	-204M	-611M
Investment in Marketable and Equity Securities, Total	1.09B	-587M	-704M	-1.68B	-742M
Cash from Investing	288M	-1.48B	-933M	-2.03B	-1.51B
Long-Term Debt Issued, Total	1.98B	-	-	-	-
Total Debt Issued	1.98B	-	-	-	-
Long-Term Debt Repaid, Total	-	-900K	-600K	-1.69B	-1.03B
Total Debt Repaid	-	-900K	-600K	-1.69B	-1.03B
Issuance of Common Stock	84M	104M	137M	259M	284M
Repurchase of Common Stock	-1.22B	-1.21B	-943M	-293M	-593M
Other Financing Activities, Total	-169M	-200K	-	-	-
Cash from Financing	673M	-1.1B	-807M	-1.73B	-1.34B
Net Change in Cash	2B	-1.08B	245M	-983M	405M
Supplemental Items
Cash Interest Paid	13.5M	20M	20.2M	20.2M	5.6M
Cash Income Tax Paid (Refund)	17.2M	24.9M	34.6M	147M	342M
Levered Free Cash Flow	929M	1.72B	1.37B	2.05B	2.49B
Unlevered Free Cash Flow	911M	1.68B	1.38B	2.06B	2.49B
Change In Net Working Capital	-60.8M	-436M	25.8M	-179M	-294M
Net Debt Issued / Repaid	1.98B	-900K	-600K	-1.69B	-1.03B

Fiscal Period: July	2020	2021	2022	2023	2024
Profitability
Return on Assets	-1.38	-1.76	-1.05	1.81	3.15
Return on Total Capital	-2.85	-3.88	-2.81	5.87	10.24
Return On Equity %	-19.87	-57.47	-63.23	44.9	74.52
Return on Common Equity	-19.87	-57.47	-63.23	44.9	74.52
Margin Analysis
Gross Profit Margin %	70.68	70.05	68.76	72.29	74.35
SG&A Margin	53.22	49.63	46.42	43.4	40.99
EBITDA Margin %	0.05	-1.39	0.57	8.56	13.38
EBITA Margin %	-2.81	-3.62	-1.13	7.14	12.32
EBIT Margin %	-5.08	-6.38	-3.43	5.62	10.82
Income From Continuing Operations Margin %	-7.83	-11.72	-4.85	6.38	32.11
Net Income Margin %	-7.83	-11.72	-4.85	6.38	32.11
Net Avail. For Common Margin %	-7.83	-11.72	-4.85	6.38	32.11
Normalized Net Income Margin	-4.14	-6.35	-2.35	5.13	9.13
Levered Free Cash Flow Margin	27.26	40.44	24.83	29.7	30.97
Unlevered Free Cash Flow Margin	26.72	39.48	25.01	29.85	30.99
Asset Turnover
Asset Turnover	0.44	0.44	0.49	0.52	0.47
Fixed Assets Turnover	7.55	7.16	9.32	11.32	11.76
Receivables Turnover (Average Receivables)	4.21	3.74	3.25	2.99	3.16
Short Term Liquidity
Current Ratio	1.91	0.91	0.77	0.78	0.89
Quick Ratio	1.78	0.82	0.71	0.68	0.77
Operating Cash Flow to Current Liabilities	0.38	0.29	0.24	0.36	0.42
Days Sales Outstanding (Average Receivables)	86.95	97.66	112.22	121.95	115.85
Average Days Payable Outstanding	25.07	17.25	19.63	24.88	22.09
Long Term Solvency
Total Debt/Equity	315.72	568.2	1.91K	133.32	27.28
Total Debt / Total Capital	75.95	85.03	95.03	57.14	21.43
LT Debt/Equity	310.46	312.29	131.48	15.97	7.36
Long-Term Debt / Total Capital	74.68	46.74	6.53	6.84	5.78
Total Liabilities / Total Assets	87.85	93.8	98.29	87.94	74.14
EBIT / Interest Expense	-1.95	-1.66	-6.89	14.24	104.61
EBITDA / Interest Expense	0.93	0.1	4.42	25.05	142.06
(EBITDA - Capex) / Interest Expense	-1.49	-0.61	-2.62	19.67	123.17
Total Debt / EBITDA	42.32	223.93	33.16	3.42	1.2
Net Debt / EBITDA