| Jul'19 | Jul'18 | Jul'17 | Jul'16 | Jul'15 | Jul'14 | Jul'13 | Jul'12 | Jul'11 | Jul'10 |
|---|---|---|---|---|---|---|---|---|---|
CASH FLOWS FROM OPERATING ACTIVITIES: | |||||||||
Net income (loss) | |||||||||
20,732 | -26,743 | 18,072 | 14,976 | 9,885 | 14,721 | 24,658 | 18,664 | 35,558 | 15,519 |
Adjustments to reconcile net income (loss) to net cash provided by (used in) operating activities: | |||||||||
Depreciation and amortization | |||||||||
39,953 | 35,611 | 18,725 | 8,842 | 7,480 | 6,751 | 4,821 | 2,917 | 2,226 | 1,376 |
Amortization of debt discount and issuance costs | |||||||||
12,194 | 4,512 | 0 | 0 | - | - | - | - | - | - |
Stock-based compensation | |||||||||
91,516 | 89,614 | 71,794 | 66,131 | 51,375 | 42,538 | 25,505 | 12,923 | 6,680 | 3,354 |
Excess tax benefit from stock-based compensation | |||||||||
0 | 0 | 7,468 | 7,102 | 3,538 | 7,067 | 2,586 | 486 | 0 | - |
Charges to bad debt and revenue reserves | |||||||||
670 | 1,062 | 0 | 0 | - | - | - | - | - | -427 |
Deferred income tax | |||||||||
-13,998 | 14,150 | -1,227 | -4,568 | 295 | -2,718 | -265 | 7,235 | -28,117 | - |
Accretion of discount on available-for-sale securities, net | |||||||||
7,568 | 1,418 | -1,462 | -2,516 | -4,839 | -3,490 | -520 | - | - | - |
Other non-cash items affecting net income (loss) | |||||||||
- | - | - | - | -1 | -99 | - | 0 | 0 | - |
Loss on disposals of property and equipment | |||||||||
- | - | - | - | - | - | -34 | - | - | - |
Changes in operating assets and liabilities: | |||||||||
Accounts receivable | |||||||||
15,057 | 40,832 | 9,750 | 75 | 12,999 | 9,276 | 8,478 | 9,325 | 6,284 | -4,957 |
Unbilled accounts receivable | |||||||||
17,341 | 0 | 0 | - | - | - | - | - | - | - |
Prepaid expenses and other assets | |||||||||
16,251 | 2,737 | 9,463 | 7,668 | 3,178 | 1,372 | 2,690 | 2,442 | 2,674 | 215 |
Accounts payable | |||||||||
-5,521 | 16,794 | 1,311 | 603 | 2,266 | 393 | 355 | 1,059 | 577 | 442 |
Accrued employee compensation | |||||||||
13,825 | 9,230 | 7,138 | 4,114 | 3,261 | 8,463 | 147 | 8,244 | 413 | 3,460 |
Deferred revenue | |||||||||
-9,628 | 32,358 | 41,553 | 16,138 | -2,263 | 14,181 | -14,048 | -17,788 | 11,770 | -19,268 |
Other liabilities | |||||||||
22,600 | 8,858 | 6,612 | 5,993 | 6,253 | 5,288 | 4,574 | -3,907 | 7,537 | 336 |
Net cash provided by (used in) operating activities | |||||||||
116,126 | 140,459 | 138,759 | 99,900 | 63,677 | 75,491 | 32,547 | 17,094 | 27,686 | 9,534 |
CASH FLOWS FROM INVESTING ACTIVITIES: | |||||||||
Purchases of available-for-sale securities | |||||||||
1,209,312 | 859,657 | 462,035 | 652,017 | 491,626 | 687,419 | 212,035 | 0 | 0 | - |
Sales and maturities of available-for-sale securities | |||||||||
956,736 | 464,143 | 547,630 | 597,405 | 520,997 | 312,149 | 83,567 | 0 | 0 | - |
Purchases of property and equipment | |||||||||
44,921 | 9,398 | 5,886 | 7,111 | 6,301 | 4,993 | 9,228 | 5,619 | 2,776 | 2,238 |
Capitalized software development costs | |||||||||
3,936 | 2,613 | 784 | 0 | 0 | - | - | - | - | - |
Strategic investment | |||||||||
0 | 0 | 4,677 | 0 | 0 | - | - | - | - | - |
Acquisitions of business, net of acquired cash | |||||||||
0 | 130,059 | 187,590 | 39,530 | 0 | 157 | 14,749 | 0 | 0 | - |
Decrease in restricted cash | |||||||||
- | - | - | - | - | - | -3,532 | -2,323 | 5,534 | -1,198 |
Net cash provided by (used in) investing activities | |||||||||
-301,433 | -537,584 | -113,342 | -101,253 | 23,070 | -380,420 | -148,913 | -3,296 | -8,310 | -1,040 |
CASH FLOWS FROM FINANCING ACTIVITIES: | |||||||||
Proceeds from issuance of convertible senior notes, net of issuance costs | |||||||||
0 | 387,239 | 0 | 0 | - | - | - | - | - | - |
Proceeds from issuance of common stock, net of issuance costs | |||||||||
0 | 220,948 | 0 | 0 | - | 389,949 | 0 | 143,386 | 0 | - |
Purchase of capped calls | |||||||||
0 | 37,200 | 0 | 0 | - | - | - | - | - | - |
Proceeds from issuance of common stock upon exercise of stock options | |||||||||
3,954 | 2,013 | 5,563 | 7,840 | 6,294 | 8,755 | 9,123 | 5,067 | 931 | 785 |
Taxes remitted on restricted stock units vested | |||||||||
- | - | - | 1,488 | 27,183 | 32,799 | 20,330 | 12,430 | 0 | - |
Costs paid in connection with stock offerings | |||||||||
- | - | - | - | - | 408 | 0 | 3,502 | 0 | - |
Excess tax benefit from exercise of stock options and vesting of restricted stock units | |||||||||
0 | 0 | 7,468 | 7,102 | 3,538 | 7,067 | 2,586 | 486 | 0 | - |
Net cash provided by (used in) financing activities | |||||||||
3,954 | 573,000 | 13,031 | 13,454 | -17,351 | 372,564 | -8,621 | 133,007 | 931 | 785 |
Effect of foreign exchange rate changes on cash and cash equivalents | |||||||||
-1,686 | -1,911 | 1,146 | -881 | -5,135 | 699 | -964 | -712 | 1,907 | 547 |
NET INCREASE (DECREASE) IN CASH AND CASH EQUIVALENTS | |||||||||
-183,039 | 173,964 | 39,594 | 11,220 | 64,261 | 68,334 | -125,951 | 146,093 | 22,214 | 9,826 |
SUPPLEMENTAL DISCLOSURES OF CASH FLOW INFORMATION: | |||||||||
Cash paid for interest | |||||||||
5,036 | 0 | 0 | - | - | 4 | 0 | 7 | 53 | 14 |
Cash paid for income taxes, net of tax refunds | |||||||||
4,557 | 4,744 | 3,700 | 3,907 | 1,899 | 2,141 | 2,266 | 2,058 | 2,207 | 1,036 |
Conversion of convertible preferred stock and warrants into common stock upon initial public offering | |||||||||
- | - | - | - | - | - | - | 36,506 | 0 | - |
Accruals for purchases of property and equipment | |||||||||
10,763 | 1,508 | 1,376 | 882 | 496 | 768 | 693 | 4,387 | 0 | - |
Accruals for purchase of property and equipment | |||||||||
298 | 189 | 171 | 0 | 0 | - | - | - | - | - |