PALO ALTO NETWORKS, INC PANW Cash Flow

Palo alto networks, inc (PANW)

CashFlow / TTM

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
-228,900	-174,300	-103,200	-81,900	-54,100	-74,300	-97,300	-122,200	-153,800	-174,300	-209,300	-203,000	-209,800	-213,000	-209,700	-192,700	-173,600	-155,400	-141,100	-131,300	-151,106	-251,793	-248,739	-226,500	-210,230	-70,925	-33,592	-29,246	-18,009	-9,931	-6,894	737	0	0	0
Adjustments to reconcile net loss to net cash provided by operating activities:
Share-based compensation for equity-based awards
634,400	606,800	580,700	567,700	541,100	519,500	507,900	496,700	490,800	490,400	486,900	474,500	466,400	458,600	433,200	392,800	349,000	300,800	255,800	221,300	188,615	156,371	123,817	99,800	80,781	65,403	49,803	43,704	36,095	27,368	20,672	13,837	0	0	0
Depreciation and amortization
187,800	174,900	165,300	153,800	140,000	124,300	107,600	96,400	84,700	75,200	67,500	59,800	55,200	51,300	47,200	42,800	39,300	35,500	32,000	28,900	28,062	25,218	22,354	19,400	14,309	12,506	10,985	9,892	9,162	8,128	7,037	6,134	0	0	0
Cease-use loss and asset impairment related to facility exit
-	-	-	-	-	-	-	41,100	62,000	37,600	36,300	20,900	0	0	0	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
Amortization of deferred contract costs
247,600	244,300	235,800	223,800	195,500	182,900	165,300	149,800	0	0	0	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
Amortization of debt discount and debt issuance costs
63,600	64,900	66,300	70,200	63,200	52,600	41,900	28,800	25,400	25,100	24,800	24,500	24,300	24,000	23,700	23,400	23,100	22,800	22,500	22,300	18,400	12,800	7,300	1,800	0	0	0	-	-	-	-	-	-	-	-
Amortization of operating lease right-of-use assets
0	0	0	-	0	0	0	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
Amortization of investment premiums, net of accretion of purchase discounts
10,700	14,400	18,300	17,500	13,100	7,800	2,400	-500	-1,200	-1,900	-2,500	-2,700	-2,700	-2,800	-2,900	-3,000	-3,300	-3,300	-3,300	-3,200	-2,620	-2,253	-1,814	-1,500	-1,678	-1,868	-2,013	-1,943	-1,445	-822	-316	0	0	0	0
Loss on conversions of convertible senior notes
0	0	-400	-2,600	-2,600	-2,600	-2,200	0	0	0	0	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
Repayments of convertible senior notes attributable to debt discount
30,500	30,500	45,300	97,600	67,100	67,100	52,300	0	0	0	0	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
Excess tax benefit from share-based compensation arrangements
-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	2,400	-	742	1,626	1,244	1,000	7,343	7,330	6,818	6,762	0	0	0	-	-	-	-
Change in fair value of preferred stock warrants
-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	958	0	0	0
Changes in opeating assets and liabilities, net of effects of acquisition:
Accounts receivable, net
239,700	119,500	111,400	108,700	41,700	47,800	27,400	33,700	-44,600	-63,200	-36,000	42,100	96,000	131,700	150,200	136,400	117,100	119,100	80,100	76,800	35,680	48,971	24,622	47,900	23,192	17,504	35,070	41,819	52,693	44,513	21,090	15,965	0	0	0
Prepaid expenses and other assets
376,100	383,400	366,600	332,500	286,400	283,900	285,200	299,100	340,600	277,300	224,400	175,300	25,200	22,100	28,400	31,200	55,900	49,500	65,100	69,000	33,274	36,493	5,193	10,300	10,800	7,782	6,742	8,865	7,803	13,259	12,232	11,063	0	0	0
Accounts payable
-13,700	26,200	30,600	32,300	31,500	-1,100	-1,300	3,700	-1,500	-700	8,300	5,900	6,200	1,700	11,700	15,100	12,100	12,000	6,200	-3,500	-13,965	1,387	-5,395	-1,100	11,448	-273	4,549	5,830	2,047	6,660	4,119	3,779	0	0	0
Accrued compensation
17,900	26,700	21,900	66,800	45,900	27,500	22,200	44,200	16,700	33,200	14,300	42,800	18,800	7,600	6,200	-6,300	2,900	18,100	16,900	31,100	24,308	22,991	11,886	26,300	0	0	0	-	-	-	-	-	-	-	-
Accrued and other liabilities
-57,000	-40,800	-58,300	-20,600	-3,300	-9,800	18,000	49,300	56,800	70,600	89,500	54,100	32,000	26,400	23,500	21,000	36,300	39,400	40,500	35,600	-102,443	14,547	-1,333	1,100	133,407	6,174	14,075	15,461	17,109	19,829	10,569	7,846	0	0	0
Deferred revenue
704,800	654,100	613,200	590,200	543,500	605,200	591,500	582,600	504,700	460,000	471,400	496,600	541,700	569,800	555,100	527,100	465,200	392,800	333,600	291,000	235,949	211,139	191,674	173,200	148,477	136,408	118,548	113,422	102,652	90,275	74,249	68,553	0	0	0
Net cash provided by operating activities
933,500	1,060,000	1,028,500	1,055,600	1,101,700	1,047,200	1,016,400	1,038,100	1,000,300	969,600	939,300	868,800	816,300	775,400	715,400	658,600	585,100	502,000	424,600	352,800	212,844	159,923	124,419	88,400	156,286	137,213	130,324	114,519	91,679	87,248	79,852	77,368	0	0	0
Cash flows from investing activities
Purchases of investments
853,500	1,236,000	2,517,900	2,984,600	2,764,400	2,385,100	1,239,900	725,700	656,900	805,700	937,000	995,900	933,800	989,500	810,200	1,037,000	1,151,200	1,010,600	1,252,200	987,600	856,189	843,997	632,262	506,600	351,552	342,494	299,087	345,324	310,683	252,633	168,475	0	0	0	0
Proceeds from sales of investments
313,800	4,100	4,000	6,500	3,500	3,500	2,500	0	0	0	0	-	-	-	-	141,900	148,900	150,900	140,900	18,500	74,970	69,970	76,600	74,600	0	0	0	-	-	-	-	-	-	-	-
Proceeds from maturities of investments
2,256,700	2,308,000	2,475,000	2,057,100	1,667,600	1,354,200	699,700	691,800	787,700	735,200	748,600	777,400	739,800	784,700	720,000	628,700	547,800	457,100	432,400	339,000	236,220	214,304	240,241	233,500	283,640	274,656	246,669	202,710	0	0	0	-	-	-	-
Business acquisitions, net of cash acquired
974,400	814,500	685,300	773,700	386,800	529,000	528,900	374,100	0	0	0	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
Purchases of property, equipment, and other assets
235,700	169,700	144,100	131,200	103,500	112,000	114,100	112,000	135,800	155,600	174,700	163,400	130,500	101,200	73,900	72,500	68,100	58,600	47,400	33,800	26,621	22,717	26,320	36,100	37,226	37,689	34,107	22,442	19,879	17,738	15,848	14,565	0	0	0
Net cash provided by (used in) investing activities
506,900	91,900	-868,300	-1,825,900	-1,583,600	-1,668,400	-1,180,700	-520,000	-375,100	-316,800	-453,800	-472,600	-410,700	-298,500	-146,600	-338,900	-537,700	-476,300	-741,400	-679,000	-571,594	-658,038	-427,441	-320,300	-184,234	-108,999	-73,034	-151,565	-199,921	-199,730	-184,323	-14,565	0	0	0
Cash flows from financing activities
Repayments of convertible senior notes attributable to principal and equity component
128,900	128,900	202,400	477,400	348,500	348,500	275,000	0	0	0	0	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
Payments for debt issuance costs
0	0	100	3,700	3,700	3,700	3,600	0	0	0	0	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
Payments of initial public offering costs
-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	2,698	1,995	2,698	265	0	0	0	0
Change in restricted cash
-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	1,221	0	0	0
Repurchases of common stock
1,198,100	198,100	528,100	330,000	330,000	330,000	125,000	259,100	375,000	500,000	495,100	411,000	295,100	170,100	50,000	0	0	0	0	-	-	-	-	-	139	152	62	78	90	54	47	82	0	0	0
Proceeds from sales of shares through employee equity incentive plans
85,100	75,000	77,300	71,700	70,300	62,800	61,200	52,600	53,200	46,200	45,800	46,400	48,900	47,800	51,400	45,300	49,000	45,800	49,000	48,200	0	0	0	-	-	-	-	-	-	-	-	-	-	-	-
Payments for taxes related to net settlement of equity awards
25,400	24,200	24,600	33,200	34,000	41,800	46,200	43,700	44,700	44,300	32,800	21,400	0	0	0	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
Proceeds from exercises of stock options
-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	0	0	0	-	11,674	4,041	3,203	1,956	0	0	0
Proceeds from employee stock purchase plan
-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	0	0	0	-	0	0	0	-	-	-	-
Excess tax benefit from share-based compensation arrangements
-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	2,400	-	742	1,626	1,244	1,000	7,343	7,330	6,818	6,762	0	0	0	-	-	-	-
Net cash used in financing activities
-1,268,600	-277,500	-679,200	-773,900	848,600	834,600	1,107,200	1,245,600	-366,500	-498,100	-482,100	-386,000	-263,600	-128,700	-5,200	38,900	48,500	44,500	48,900	48,200	578,074	579,262	580,554	575,100	49,074	45,729	34,419	25,018	231,623	217,584	219,118	219,322	0	0	0
Net increase (decrease) in cash, cash equivalents, and restricted cash
171,800	874,400	-519,000	-1,544,200	366,700	213,400	942,900	1,763,700	258,700	154,700	3,400	10,200	142,000	348,200	563,600	358,600	95,900	70,200	-267,900	-278,000	219,324	81,147	277,532	343,200	21,126	73,943	91,709	-12,028	123,381	105,102	114,647	282,125	0	0	0
Non-cash investing and financing activities
Property and equipment acquired through lease incentives
-	-	-	-	-	-	-	37,800	37,800	37,800	37,800	0	0	0	0	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
Supplemental disclosures of cash flow information
Cash paid for interest
-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	0	0
Cash paid for income taxes
-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	0	0
Purchase of property, equipment, and other assets not yet paid
-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	0	-	-	-	-
Change in liability for early exercise of stock options, net of vested portion
-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	0	0