| Jul'19 | Jul'18 | Jul'17 | Jul'16 | Jul'15 | Jul'14 | Jul'13 | Jul'12 | Jul'11 |
|---|---|---|---|---|---|---|---|---|
Cash flows from operating activities | ||||||||
Net loss | ||||||||
-81,900 | -122,200 | -203,000 | -192,700 | -131,300 | -226,500 | -29,246 | 737 | -12,528 |
Adjustments to reconcile net loss to net cash provided by operating activities: | ||||||||
Share-based compensation for equity-based awards | ||||||||
567,700 | 496,700 | 474,500 | 392,800 | 221,300 | 99,800 | 43,704 | 13,837 | 4,733 |
Issuance of common stock for legal settlement | ||||||||
- | - | - | - | - | 46,200 | 0 | 0 | - |
Depreciation and amortization | ||||||||
153,800 | 96,400 | 59,800 | 42,800 | 28,900 | 19,400 | 9,892 | 6,134 | 2,189 |
Cease-use loss and asset impairment related to facility exit | ||||||||
7,000 | 41,100 | 20,900 | 0 | - | - | - | - | - |
Amortization of deferred contract costs | ||||||||
223,800 | 149,800 | 107,400 | - | - | - | - | - | - |
Amortization of debt discount and debt issuance costs | ||||||||
70,200 | 28,800 | 24,500 | 23,400 | 22,300 | 1,800 | 0 | 0 | - |
Asset impairment related to facility exit | ||||||||
- | - | - | - | 0 | - | - | - | - |
Amortization of investment premiums, net of accretion of purchase discounts | ||||||||
17,500 | -500 | -2,700 | -3,000 | -3,200 | -1,500 | -1,943 | 0 | 0 |
Loss on conversions of convertible senior notes | ||||||||
-2,600 | 0 | 0 | - | - | - | - | - | - |
Repayments of convertible senior notes attributable to debt discount | ||||||||
97,600 | 0 | 0 | - | - | - | - | - | - |
Change in fair value of common stock warrant | ||||||||
- | - | - | - | - | 5,900 | 0 | 0 | - |
Excess tax benefit from share-based compensation arrangements | ||||||||
- | - | - | - | - | 1,000 | 6,762 | 215 | 0 |
Loss on facility sublease | ||||||||
- | - | - | - | - | - | -262 | 0 | 0 |
Change in fair value of preferred stock warrants | ||||||||
- | - | - | - | - | - | - | 958 | 1,577 |
Changes in opeating assets and liabilities, net of effects of acquisition: | ||||||||
Accounts receivable, net | ||||||||
108,700 | 33,700 | 42,100 | 136,400 | 76,800 | 47,900 | 41,819 | 15,965 | 15,436 |
Prepaid expenses and other assets | ||||||||
332,500 | 299,100 | 175,300 | 31,200 | 69,000 | 10,300 | 8,865 | 11,063 | 5,114 |
Accounts payable | ||||||||
32,300 | 3,700 | 5,900 | 15,100 | -3,500 | -1,100 | 5,830 | 3,779 | 2,734 |
Accrued compensation | ||||||||
66,800 | 44,200 | 42,800 | -6,300 | 31,100 | 26,300 | 10,697 | 2,066 | - |
Accrued and other liabilities | ||||||||
-20,600 | 49,300 | 54,100 | 21,000 | 35,600 | 1,100 | 15,461 | 7,846 | 6,340 |
Deferred revenue | ||||||||
590,200 | 582,600 | 496,600 | 527,100 | 291,000 | 173,200 | 113,422 | 68,553 | 43,134 |
Reimbursement of cost of leasehold improvements | ||||||||
- | - | - | - | - | - | - | 701 | 4,473 |
Net cash provided by operating activities | ||||||||
1,055,600 | 1,038,100 | 868,800 | 658,600 | 352,800 | 88,400 | 114,519 | 77,368 | 32,102 |
Cash flows from investing activities | ||||||||
Purchases of investments | ||||||||
2,984,600 | 725,700 | 995,900 | 1,037,000 | 987,600 | 506,600 | 345,324 | 0 | 0 |
Proceeds from sales of investments | ||||||||
6,500 | 0 | 0 | 141,900 | 18,500 | 74,600 | 13,491 | 0 | 0 |
Proceeds from maturities of investments | ||||||||
2,057,100 | 691,800 | 777,400 | 628,700 | 339,000 | 233,500 | 202,710 | 0 | 0 |
Business acquisitions, net of cash acquired | ||||||||
773,700 | 374,100 | 90,700 | 0 | 15,100 | 85,700 | 0 | 0 | - |
Purchases of property, equipment, and other assets | ||||||||
131,200 | 112,000 | 163,400 | 72,500 | 33,800 | 36,100 | 22,442 | 14,565 | 13,000 |
Net cash provided by (used in) investing activities | ||||||||
-1,825,900 | -520,000 | -472,600 | -338,900 | -679,000 | -320,300 | -151,565 | -14,565 | -13,000 |
Cash flows from financing activities | ||||||||
Repayments of convertible senior notes attributable to principal and equity component | ||||||||
477,400 | 0 | 0 | - | - | - | - | - | - |
Payments for debt issuance costs | ||||||||
3,700 | 0 | 0 | - | - | - | - | - | - |
Proceeds from borrowings on convertible senior notes, net | ||||||||
0 | 1,682,400 | 0 | 0 | - | 560,400 | 0 | 0 | - |
Proceeds from issuance of warrants | ||||||||
0 | 145,400 | 0 | 0 | - | 78,300 | 0 | 0 | - |
Purchase of note hedges | ||||||||
0 | 332,000 | 0 | 0 | - | - | - | - | - |
Proceeds from settlement of note receivable | ||||||||
- | - | - | - | - | - | - | 637 | 895 |
Payments of initial public offering costs | ||||||||
- | - | - | - | - | - | 2,698 | 0 | 0 |
Proceeds from initial public offering, net of offering costs | ||||||||
- | - | - | - | - | - | - | 215,375 | 0 |
Change in restricted cash | ||||||||
- | - | - | - | - | - | - | 1,221 | 0 |
Repurchases of common stock | ||||||||
330,000 | 259,100 | 411,000 | 0 | 0 | - | 78 | 82 | 90 |
Purchase of convertible note hedges | ||||||||
- | - | - | - | - | 111,000 | 0 | 0 | - |
Proceeds from sales of shares through employee equity incentive plans | ||||||||
71,700 | 52,600 | 46,400 | 45,300 | 48,200 | 46,400 | 21,032 | - | - |
Payments for taxes related to net settlement of equity awards | ||||||||
33,200 | 43,700 | 21,400 | 0 | 0 | - | - | - | - |
Proceeds from exercises of stock options | ||||||||
- | - | - | - | - | - | - | 1,956 | 1,775 |
Proceeds from employee stock purchase plan | ||||||||
- | - | - | - | - | - | - | 0 | 0 |
Excess tax benefit from share-based compensation arrangements | ||||||||
- | - | - | - | - | 1,000 | 6,762 | 215 | 0 |
Net cash used in financing activities | ||||||||
-773,900 | 1,245,600 | -386,000 | 38,900 | 48,200 | 575,100 | 25,018 | 219,322 | 2,580 |
Payment of deferred consideration related to prior year business acquisition | ||||||||
1,300 | 0 | 0 | 6,400 | 0 | 0 | - | - | - |
Net increase (decrease) in cash, cash equivalents, and restricted cash | ||||||||
-1,544,200 | 1,763,700 | 10,200 | 358,600 | -278,000 | 343,200 | -12,028 | 282,125 | 21,682 |
Non-cash investing and financing activities | ||||||||
Issuance of common stock in connection with acquisition | ||||||||
- | - | - | - | - | 87,500 | 0 | 0 | - |
Conversion of preferred stock into common stock | ||||||||
- | - | - | - | - | - | - | 67,517 | 0 |
Business Combination, Consideration Transferred, Equity Interests Issued and Issuable | ||||||||
229,500 | 0 | 0 | - | - | - | - | - | - |
Property and equipment acquired through lease incentives | ||||||||
0 | 37,800 | 0 | 11,500 | - | - | - | - | - |
Issuance of preferred stock upon exercise of warrant | ||||||||
- | - | - | - | - | - | - | 3,026 | 0 |
Supplemental disclosures of cash flow information | ||||||||
Cash paid for interest | ||||||||
- | - | - | - | - | 0 | 58 | 23 | 25 |
Cash paid for income taxes | ||||||||
22,000 | 11,200 | 9,000 | 7,100 | 17,500 | 1,500 | 304 | 1,355 | 32 |
Cash paid for contractual interest | ||||||||
13,500 | 800 | 0 | - | - | - | - | - | - |