Stock Analysis on Net

Palo Alto Networks Inc. (NASDAQ:PANW)

Cash Flow Statement
Quarterly Data

The cash flow statement provides information about a company cash receipts and cash payments during an accounting period, showing how these cash flows link the ending cash balance to the beginning balance shown on the company balance sheet.

The cash flow statement consists of three parts: cash flows provided by (used in) operating activities, cash flows provided by (used in) investing activities, and cash flows provided by (used in) financing activities.

Palo Alto Networks Inc., consolidated cash flow statement (quarterly data)

US$ in thousands

Microsoft Excel
3 months ended: Jan 31, 2024 Oct 31, 2023 Jul 31, 2023 Apr 30, 2023 Jan 31, 2023 Oct 31, 2022 Jul 31, 2022 Apr 30, 2022 Jan 31, 2022 Oct 31, 2021 Jul 31, 2021 Apr 30, 2021 Jan 31, 2021 Oct 31, 2020 Jul 31, 2020 Apr 30, 2020 Jan 31, 2020 Oct 31, 2019 Jul 31, 2019 Apr 30, 2019 Jan 31, 2019 Oct 31, 2018 Jul 31, 2018 Apr 30, 2018 Jan 31, 2018 Oct 31, 2017
Net income (loss) 1,746,900 194,200 227,700 107,800 84,200 20,000 3,300 (73,200) (93,500) (103,600) (119,300) (145,100) (142,300) (92,200) (58,900) (74,800) (73,700) (59,600) (20,800) (20,200) (2,600) (38,300) (2,300) (46,700) (34,900) (64,000)
Share-based compensation for equity-based awards 272,000 271,000 254,200 271,000 283,300 266,000 239,600 247,300 265,100 259,100 230,000 233,100 225,600 205,800 174,200 165,800 168,500 149,900 150,200 138,200 142,400 136,900 123,600 116,600 130,800 125,700
Deferred income taxes (1,691,300)
Depreciation and amortization 68,600 64,300 69,300 72,300 69,900 70,700 72,500 71,400 69,700 69,000 68,800 68,700 64,900 58,000 60,500 53,200 48,400 44,000 42,200 40,300 38,800 32,500 28,400 24,600 22,100 21,300
(Gain) loss related to facility exit (3,100) 2,900 4,100 24,400 1,300 15,400
Amortization of deferred contract costs 108,900 105,500 116,000 101,400 99,000 97,000 101,000 89,100 86,100 85,900 89,700 73,900 68,600 65,800 83,000 60,500 55,300 55,600 76,200 64,600 41,900 41,100
Amortization of debt issuance costs 1,100 1,000 1,400 1,800 1,700 1,800 1,800 1,800 1,800 1,800 36,400 35,900 35,500 35,100 26,900 15,800 15,700 15,500 16,600 17,100 17,100 19,400 9,600 6,500 6,400 6,300
Reduction of operating lease right-of-use assets 13,700 12,400 13,200 12,100 12,500 12,100 16,900 12,400 12,400 12,700 11,900 11,900 10,700 10,000 13,200 13,100 10,700 10,400
Amortization of investment premiums, net of accretion of purchase discounts (16,200) (14,700) (17,800) (20,100) (16,000) 1,700 3,000 3,200 3,700 3,600 3,900 3,300 3,200 2,700 (1,600) (1,400) (3,200) (4,500) (5,300) (5,300) (2,400) (100) 100 500
Loss on conversions of convertible senior notes 400 2,200
Repayments of convertible senior notes attributable to debt discount (100) (30,500) (14,800) (52,300)
Accounts receivable, net (482,200) 1,050,200 (1,019,600) (165,300) (39,800) 904,400 (901,900) (288,400) (140,100) 428,400 (473,700) (97,400) 16,400 382,300 (368,400) (110,300) (40,800) 83,900 (172,500) 9,900 (32,700) 86,600 (105,500) 5,500 (14,300) 81,300
Financing receivables, net 300 (43,600) (738,700)
Deferred contract costs (96,000) (63,300) (181,400) (97,600) (92,800) (60,100) (201,700) (105,900) (87,400) (63,800) (205,700) (94,100) (81,700) (59,300)
Prepaid expenses and other assets (8,100) 54,000 231,000 (336,700) (118,500) (41,100) (42,100) (26,000) (100) (72,800) (163,600) (36,100) (61,800) (37,600) (201,000) (66,500) (82,300) (59,200) (168,100) (81,200) (60,600) (22,600) (65,200) (21,300) (32,600) (6,400)
Accounts payable 47,700 (400) 37,300 (37,000) 1,700 (1,000) 17,700 (8,200) 22,200 37,600 (15,200) 27,000 (5,900) (17,700) 10,000 (5,500) (14,800) (2,500) 9,100 34,400 (10,400) (800) 8,300 1,800 (10,600) 4,200
Accrued compensation 118,600 (216,900) 203,600 (50,900) 124,000 (192,300) 95,800 35,400 79,000 (179,800) 177,800 (8,500) 70,600 (134,800) 147,300 (10,500) 48,800 (109,900) 89,500 (1,700) 44,000 (65,000) 68,600 (20,100) 38,700 (43,000)
Accrued and other liabilities 233,900 (34,100) 11,100 38,000 (88,600) (28,100) (16,800) 20,400 (27,300) (23,400) 35,900 (7,300) (37,100) (20,000) 7,300 (15,300) (6,600) (25,200) (9,900) 900 (24,100) 12,500 2,500 (3,900) 4,500 41,800
Deferred revenue 372,100 146,400 1,206,800 535,300 374,000 185,600 1,134,600 410,200 291,000 134,200 649,000 212,500 197,800 136,800 439,600 146,000 182,200 125,500 251,100 95,300 141,300 102,500 210,000 153,900 132,200 91,000
Changes in operating assets and liabilities, net of effects of acquisitions 186,300 892,300 (249,900) (114,200) 160,000 767,400 85,600 37,500 137,300 260,400 4,500 (3,900) 98,300 249,700 34,800 (62,100) 86,500 12,600 (800) 57,600 57,500 113,200 118,700 115,900 117,900 168,900
Adjustments to reconcile net income (loss) to net cash provided by operating activities (1,056,900) 1,331,800 186,400 324,300 610,400 1,216,700 520,400 462,700 576,100 692,500 445,100 422,900 506,800 627,100 392,600 244,700 380,600 284,800 252,300 316,600 278,000 290,600 280,200 288,000 278,600 338,100
Net cash provided by operating activities 690,000 1,526,000 414,100 432,100 694,600 1,236,700 523,700 389,500 482,600 588,900 325,800 277,800 364,500 534,900 333,700 169,900 306,900 225,200 231,500 296,400 275,400 252,300 277,900 241,300 243,700 274,100
Purchases of investments (1,156,700) (854,700) (999,000) (742,100) (1,606,500) (2,112,800) (975,300) (241,100) (616,200) (439,100) (464,800) (381,600) (282,800) (829,700) (885,300) (12,200) (9,000) (274,300) (558,000) (394,700) (1,290,900) (741,000) (337,800) (15,400) (145,700) (226,800)
Proceeds from sales of investments 126,600 304,600 90,900 375,400 14,600 485,000 160,000 7,000 246,100 36,100 94,400 36,700 3,200 309,700 1,100 3,000 1,000 2,500
Proceeds from maturities of investments 350,400 457,900 1,307,900 504,700 651,300 347,600 402,000 315,300 176,500 225,100 395,400 311,000 335,900 198,200 246,300 451,300 622,700 632,400 550,300 502,600 789,700 214,500 160,800 189,200 135,200 206,600
Business acquisitions, net of cash and restricted cash acquired (610,600) (18,900) (185,600) (19,600) (17,400) (146,800) (405,400) (225,100) (387,800) (129,300) (66,400) (390,900) (227,900) (100) (154,800) (4,000) (370,100)
Purchases of property, equipment, and other assets (35,200) (36,800) (37,200) (31,200) (38,300) (39,600) (39,200) (38,300) (80,700) (34,600) (27,400) (26,900) (32,100) (29,600) (31,800) (86,300) (49,100) (47,200) (53,100) (20,300) (23,500) (34,300) (25,400) (28,800) (25,600) (32,200)
Net cash (used in) provided by investing activities (1,325,500) (129,000) 362,600 87,900 (1,164,500) (1,319,800) (472,100) 42,900 (274,300) (229,900) (2,400) (207,600) (384,400) (886,200) (667,600) 274,700 436,400 244,500 (448,700) (140,300) (523,800) (713,100) (206,400) (225,100) (36,100) (52,400)
Repayments of convertible senior notes (126,300) (46,000) (1,692,000) (600) (900) (128,900) (73,500) (275,000)
Payments for debt issuance costs (200) (100) (3,600)
Proceeds from borrowings on convertible senior notes, net 1,979,100 1,682,400
Proceeds from issuance of warrants 202,800 145,400
Purchase of note hedges (370,800) (332,000)
Repurchases of common stock (66,700) (250,000) (22,700) (342,300) (550,000) (328,100) (350,000) (500,000) (1,000,000) (198,100) (330,000) (125,000) (134,100)
Proceeds from sales of shares through employee equity incentive plans 57,500 86,400 60,100 130,300 700 67,700 300 77,500 100 58,700 300 58,000 300 45,400 300 46,800 600 36,300 1,400 36,700 2,900 30,700 29,200 1,300 22,100
Payments for taxes related to net share settlement of equity awards (3,800) (15,500) (2,900) (2,100) (1,500) (13,900) (10,500) (11,200) (8,600) (20,000) (6,900) (6,500) (5,700) (9,700) (5,900) (4,800) (6,700) (5,300) (8,600) (3,600) (7,100) (13,900) (9,400) (11,400) (11,500) (11,400)
Payment of deferred consideration related to prior year business acquisition (1,300) (1,300)
Net cash provided by (used in) financing activities (72,600) (41,800) (1,634,800) 128,200 (250,800) 31,100 (353,100) 66,300 (558,500) 38,700 (335,600) (298,500) (5,400) (464,500) 1,805,500 (959,300) (6,100) (167,100) (136,100) 31,800 (407,800) (261,800) 1,486,400 17,800 (135,200) (123,400)
Net increase (decrease) in cash, cash equivalents, and restricted cash (708,100) 1,355,200 (858,100) 648,200 (720,700) (52,000) (301,500) 498,700 (350,200) 397,700 (12,200) (228,300) (25,300) (815,800) 1,471,600 (514,700) 737,200 302,600 (353,300) 187,900 (656,200) (722,600) 1,557,900 34,000 72,400 98,300

Based on: 10-Q (reporting date: 2024-01-31), 10-Q (reporting date: 2023-10-31), 10-K (reporting date: 2023-07-31), 10-Q (reporting date: 2023-04-30), 10-Q (reporting date: 2023-01-31), 10-Q (reporting date: 2022-10-31), 10-K (reporting date: 2022-07-31), 10-Q (reporting date: 2022-04-30), 10-Q (reporting date: 2022-01-31), 10-Q (reporting date: 2021-10-31), 10-K (reporting date: 2021-07-31), 10-Q (reporting date: 2021-04-30), 10-Q (reporting date: 2021-01-31), 10-Q (reporting date: 2020-10-31), 10-K (reporting date: 2020-07-31), 10-Q (reporting date: 2020-04-30), 10-Q (reporting date: 2020-01-31), 10-Q (reporting date: 2019-10-31), 10-K (reporting date: 2019-07-31), 10-Q (reporting date: 2019-04-30), 10-Q (reporting date: 2019-01-31), 10-Q (reporting date: 2018-10-31), 10-K (reporting date: 2018-07-31), 10-Q (reporting date: 2018-04-30), 10-Q (reporting date: 2018-01-31), 10-Q (reporting date: 2017-10-31).

Cash flow statement item Description The company
Net cash provided by operating activities Amount of cash inflow (outflow) from operating activities, excluding discontinued operations. Operating activity cash flows include transactions, adjustments, and changes in value not defined as investing or financing activities. Palo Alto Networks Inc. net cash provided by operating activities increased from Q4 2023 to Q1 2024 but then slightly decreased from Q1 2024 to Q2 2024 not reaching Q4 2023 level.
Net cash (used in) provided by investing activities Amount of cash inflow (outflow) of investing activities, excluding discontinued operations. Investing activity cash flows include making and collecting loans and acquiring and disposing of debt or equity instruments and property, plant, and equipment and other productive assets. Palo Alto Networks Inc. net cash (used in) provided by investing activities decreased from Q4 2023 to Q1 2024 and from Q1 2024 to Q2 2024.
Net cash provided by (used in) financing activities Amount of cash inflow (outflow) of financing activities, excluding discontinued operations. Financing activity cash flows include obtaining resources from owners and providing them with a return on, and a return of, their investment; borrowing money and repaying amounts borrowed, or settling the obligation; and obtaining and paying for other resources obtained from creditors on long-term credit. Palo Alto Networks Inc. net cash provided by (used in) financing activities increased from Q4 2023 to Q1 2024 but then slightly decreased from Q1 2024 to Q2 2024.