PALO ALTO NETWORKS, INC PANW Cash Flow

Palo alto networks, inc (PANW)

CashFlow / Quarterly

Apr'20	Jan'20	Oct'19	Jul'19	Apr'19	Jan'19	Oct'18	Jul'18	Apr'18	Jan'18	Oct'17	Jul'17	Apr'17	Jan'17	Oct'16	Jul'16	Apr'16	Jan'16	Oct'15	Jul'15	Apr'15	Jan'15	Oct'14	Jul'14	Apr'14	Jan'14	Oct'13	Jul'13	Apr'13	Jan'13	Oct'12	Jul'12	Apr'12	Jan'12	Oct'11
Cash flows from operating activities
Net loss
-74,800	-73,700	-59,600	-20,800	-20,200	-2,600	-38,300	7,000	-40,400	-25,600	-63,200	-24,600	-60,900	-60,600	-56,900	-31,400	-64,100	-57,300	-39,900	-12,300	-45,900	-43,000	-30,100	-32,106	-146,587	-39,946	-7,861	-15,836	-7,282	-2,613	-3,515	-4,599	796	424	4,116
Adjustments to reconcile net loss to net cash provided by operating activities:
Share-based compensation for equity-based awards
165,800	168,500	149,900	150,200	138,200	142,400	136,900	123,600	116,600	130,800	125,700	117,700	116,200	127,300	113,300	109,600	108,400	101,900	72,900	65,800	60,200	56,900	38,400	33,115	27,956	24,346	14,383	14,096	12,578	8,746	8,284	6,487	3,851	2,050	1,449
Depreciation and amortization
53,200	48,400	44,000	42,200	40,300	38,800	32,500	28,400	24,600	22,100	21,300	16,700	15,100	14,400	13,600	12,100	11,200	10,300	9,200	8,600	7,400	6,800	6,100	7,762	4,556	3,936	3,146	2,671	2,753	2,415	2,053	1,941	1,719	1,324	1,150
Cease-use loss and asset impairment related to facility exit
-	-	-	-	-	-	-	0	24,400	1,300	15,400	20,900	0	0	0	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
Amortization of deferred contract costs
60,500	55,300	55,600	76,200	57,200	46,800	43,600	47,900	44,600	29,200	28,100	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
Amortization of debt discount and debt issuance costs
15,800	15,700	15,500	16,600	17,100	17,100	19,400	9,600	6,500	6,400	6,300	6,200	6,200	6,100	6,000	6,000	5,900	5,800	5,700	5,700	5,600	5,500	5,500	1,800	0	0	0	-	-	-	-	-	-	-	-
Amortization of operating lease right-of-use assets
13,100	10,700	10,400	-	0	0	0	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
Amortization of investment premiums, net of accretion of purchase discounts
1,600	1,400	3,200	4,500	5,300	5,300	2,400	100	0	-100	-500	-600	-700	-700	-700	-600	-800	-800	-800	-900	-800	-800	-700	-320	-433	-361	-386	-498	-623	-506	-316	0	0	0	0
Loss on conversions of convertible senior notes
0	0	0	0	0	-400	-2,200	0	0	0	0	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
Repayments of convertible senior notes attributable to debt discount
0	0	0	30,500	0	14,800	52,300	0	0	0	0	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
Excess tax benefit from share-based compensation arrangements
-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	200	-	-800	1,000	300	242	84	618	56	6,585	71	106	0	-	-	-	-
Change in fair value of preferred stock warrants
-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	0	0	554	404
Changes in opeating assets and liabilities, net of effects of acquisition:
Accounts receivable, net
110,300	40,800	-83,900	172,500	-9,900	32,700	-86,600	105,500	-3,800	12,300	-80,300	27,200	-22,400	39,500	-2,200	81,100	13,300	58,000	-16,000	61,800	15,300	19,000	-19,300	20,680	28,591	-5,349	3,978	-4,028	22,903	12,217	10,727	6,846	14,723	-11,206	5,602
Prepaid expenses and other assets
66,500	82,300	59,200	168,100	73,800	65,500	25,100	122,000	71,300	66,800	39,000	163,500	8,000	13,900	-10,100	13,400	4,900	20,200	-7,300	38,100	-1,500	35,800	-3,400	2,374	1,719	4,500	1,707	2,874	-1,299	3,460	3,830	1,812	4,157	2,433	2,661
Accounts payable
-5,500	-14,800	-2,500	9,100	34,400	-10,400	-800	8,300	1,800	-10,600	4,200	3,100	2,600	-1,600	1,800	3,400	-1,900	8,400	5,200	400	-2,000	2,600	-4,500	-10,065	13,352	-4,182	-205	2,483	1,631	640	1,076	-1,300	6,244	-1,901	736
Accrued compensation
-10,500	48,800	-109,900	89,500	-1,700	44,000	-65,000	68,600	-20,100	38,700	-43,000	41,100	-3,600	19,800	-14,500	17,100	-14,800	18,400	-27,000	26,300	400	17,200	-12,800	19,508	-917	6,095	1,614	-	-	-	-	-	-	-	-
Accrued and other liabilities
-15,300	-6,600	-25,200	-9,900	900	-24,100	12,500	7,400	-5,600	3,700	43,800	14,900	8,200	22,600	8,400	-7,200	2,600	19,700	5,900	8,100	5,700	20,800	1,000	-129,943	122,690	4,920	3,433	2,364	-4,543	12,821	4,819	4,012	-1,823	3,561	2,096
Deferred revenue
146,000	182,200	125,500	251,100	95,300	141,300	102,500	204,400	157,000	127,600	93,600	126,500	112,300	139,000	118,800	171,600	140,400	124,300	90,800	109,700	68,000	65,100	48,200	54,649	43,190	45,635	29,726	29,926	31,121	27,775	24,600	19,156	18,744	11,749	18,904
Net cash provided by operating activities
169,900	306,900	225,200	231,500	296,400	275,400	252,300	277,600	241,900	244,600	274,000	239,800	211,200	214,300	203,500	187,300	170,300	154,300	146,700	113,800	87,200	76,900	74,900	-26,156	34,279	41,396	38,881	41,730	15,206	34,507	23,076	18,890	10,775	27,111	20,592
Cash flows from investing activities
Purchases of investments
12,200	9,000	274,300	558,000	394,700	1,290,900	741,000	337,800	15,400	145,700	226,800	269,000	164,200	277,000	285,700	206,900	219,900	97,700	512,500	321,100	79,300	339,300	247,900	189,689	67,108	127,565	122,238	34,641	58,050	84,158	168,475	0	0	0	0
Proceeds from sales of investments
309,700	1,100	0	3,000	0	1,000	2,500	0	0	0	0	-	-	-	-	4,500	3,000	10,000	124,400	11,500	5,000	0	2,000	67,970	0	6,630	0	-	-	-	-	-	-	-	-
Proceeds from maturities of investments
451,300	622,700	632,400	550,300	502,600	789,700	214,500	160,800	189,200	135,200	206,600	256,700	136,700	148,600	235,400	219,100	181,600	83,900	144,100	138,200	90,900	59,200	50,700	35,420	68,984	85,137	43,959	85,560	60,000	57,150	0	-	-	-	-
Business acquisitions, net of cash acquired
387,800	129,300	66,400	390,900	227,900	100	154,800	4,000	370,100	0	0	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
Purchases of property, equipment, and other assets
86,300	49,100	47,200	53,100	20,300	23,500	34,300	25,400	28,800	25,600	32,200	49,200	48,600	44,700	20,900	16,300	19,300	17,400	19,500	11,900	9,800	6,200	5,900	4,721	5,896	9,803	15,680	5,847	6,359	6,221	4,015	3,284	4,218	4,331	2,732
Net cash provided by (used in) investing activities
274,700	436,400	244,500	-448,700	-140,300	-523,800	-713,100	-206,400	-225,100	-36,100	-52,400	-61,500	-166,800	-173,100	-71,200	400	-54,600	-21,200	-263,500	-198,400	6,800	-286,300	-201,100	-90,994	-79,644	-55,703	-93,959	45,072	-4,409	-19,738	-172,490	-3,284	-4,218	-4,331	-2,732
Cash flows from financing activities
Repayments of convertible senior notes attributable to principal and equity component
0	0	0	128,900	0	73,500	275,000	0	0	0	0	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
Payments for debt issuance costs
0	0	0	0	0	100	3,600	0	0	0	0	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
Payments of initial public offering costs
-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	0	0	2,433	265	-703	703	0	0
Change in restricted cash
-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	0	0	0	1,221
Repurchases of common stock
1,000,000	0	198,100	0	0	330,000	0	0	0	125,000	134,100	115,900	125,000	120,100	50,000	0	0	0	0	-	-	-	-	-	23	101	8	7	36	11	24	19	0	4	59
Proceeds from sales of shares through employee equity incentive plans
46,800	600	36,300	1,400	36,700	2,900	30,700	0	29,200	1,300	22,100	600	22,200	900	22,700	3,100	21,100	4,500	16,600	6,800	17,900	7,700	15,800	-	-	-	-	-	-	-	-	-	-	-	-
Payments for taxes related to net settlement of equity awards
4,800	6,700	5,300	8,600	3,600	7,100	13,900	9,400	11,400	11,500	11,400	10,400	11,000	0	0	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
Proceeds from exercises of stock options
-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	11,346	9,475	4,610	-	8,641	1,020	1,534	479	1,008	182	287
Proceeds from employee stock purchase plan
-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	6,881	0	5,988	-	6,267	0	0	-	-	-	-
Excess tax benefit from share-based compensation arrangements
-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	200	-	-800	1,000	300	242	84	618	56	6,585	71	106	0	-	-	-	-
Net cash used in financing activities
-959,300	-6,100	-167,100	-136,100	31,800	-407,800	-261,800	1,486,400	17,800	-135,200	-123,400	-125,700	-113,800	-119,200	-27,300	-3,300	21,100	4,300	16,800	6,300	17,100	8,700	16,100	536,174	18,288	9,992	10,646	10,148	14,943	-1,318	1,245	216,753	904	216	1,449
Net increase (decrease) in cash, cash equivalents, and restricted cash
-514,700	737,200	302,600	-353,300	187,900	-656,200	-722,600	1,557,600	34,600	73,300	98,200	52,600	-69,400	-78,000	105,000	184,400	136,800	137,400	-100,000	-78,300	111,100	-200,700	-110,100	419,024	-27,077	-4,315	-44,432	96,950	25,740	13,451	-148,169	232,359	7,461	22,996	19,309
Non-cash investing and financing activities
Property and equipment acquired through lease incentives
-	-	-	-	-	-	-	0	0	0	37,800	0	0	0	0	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
Supplemental disclosures of cash flow information
Cash paid for interest
-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	5	4
Cash paid for income taxes
-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	451	97
Purchase of property, equipment, and other assets not yet paid
-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	0	-	-	-	-
Change in liability for early exercise of stock options, net of vested portion
-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-250	-165