Square, Inc. SQ Cash Flow

Square, inc. (SQ)

CashFlow / TTM

Mar'20	Dec'19	Sep'19	Jun'19	Mar'19	Dec'18	Sep'18	Jun'18	Mar'18	Dec'17	Sep'17	Jun'17	Mar'17	Dec'16	Sep'16	Jun'16	Mar'16	Dec'15	Sep'15	Jun'15	Mar'15
Cash flows from operating activities:
Net loss
307,706	375,446	-43,698	-53,452	-52,618	-38,453	-25,912	-61,653	-71,709	-62,813	-62,317	-78,542	-89,925	-171,590	-204,712	-226,319	-228,594	-179,817	0	0	0
Adjustments to reconcile net loss to net cash provided by operating activities:
Depreciation and amortization
76,688	75,598	79,517	76,227	69,772	60,961	47,955	41,205	38,002	37,279	37,575	38,171	38,064	37,745	36,917	33,806	31,198	27,626	0	0	0
Non-cash interest and other
38,734	34,547	33,189	36,204	34,634	31,257	28,006	20,596	17,734	14,421	10,008	5,500	1,485	-49	0	0	0	-	-	-	-
Loss on extinguishment of long-term debt
0	-	-	-	0	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
Share-based compensation
314,078	297,863	277,005	258,492	231,145	216,881	202,381	183,516	170,990	155,836	145,198	141,929	139,258	138,786	0	0	0	-	-	0	0
Loss on revaluation of equity investment
1,761	-12,326	-33,066	1,442	6,255	20,342	0	0	0	-	-	-	-	-	-	-	-	-	-	-	-
Non-cash lease expense
0	-	-	-	0	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
Recovery of common stock in connection with indemnification settlement agreement
280	1,069	789	789	3,534	2,745	0	0	0	-	-	-	-	-	-	-	-	-	-	-	-
Transaction and loan losses
0	-	-	-	0	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
Loss Contingency Accrual, Provision
-	-	-	-	-	-	0	0	73,158	-	63,219	56,211	55,944	51,235	59,243	57,759	47,434	54,009	0	0	0
Provision for uncollectible receivables related to merchant cash advances
-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	0	0	0
Change in deferred income taxes
-1,606	-1,376	-1,137	-2,187	-746	-646	-2,081	-2,172	-2,138	-1,385	295	94	79	58	129	296	311	26	0	0	0
Gain on sale of property and equipment
-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	8	-	0	0	0
Changes in operating assets and liabilities:
Settlements receivable
-839,449	248,271	-609,970	710,594	700,225	-245,795	614,365	506,752	441,869	305,831	356,690	104,542	76,573	177,662	83,288	39,670	44,283	31,810	0	0	0
Customer funds
304,970	204,208	177,560	150,233	190,824	131,004	173,731	135,259	95,134	59,468	57,027	67,383	49,843	34,128	0	0	0	-	-	-	-
Purchase of loans held for sale
2,332,485	2,266,738	2,066,863	1,910,860	1,772,390	1,609,611	1,449,274	1,348,062	1,277,436	1,184,630	1,122,231	1,027,068	893,319	668,976	0	0	0	-	-	-	-
Sales and principal payments of loans held for sale
-2,256,748	-2,168,682	-1,996,614	-1,838,707	-1,710,260	-1,579,834	-1,423,505	-1,302,055	-1,239,975	-1,145,314	-1,086,593	-1,004,088	-852,504	-627,627	0	0	0	-	-	-	-
Merchant cash advance receivable
-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	0	0	0
Other current assets
-	-	-	-	-	-	-	-	45,668	-	14,831	-5,930	-43,424	-16,116	-3,301	13,121	50,254	25,841	0	0	0
Other non-current assets
-	-	-	-	-	-	-	-	4,671	-	1,213	-898	-417	-631	-263	334	-754	-1,220	0	0	0
Accounts payable
-	-	-	-	-	-	-	-	-	-	0	0	-6,182	-	4,916	6,961	5,724	7,831	0	0	0
Customers payable
-176,025	523,795	-46,810	800,718	780,369	15,597	587,902	535,375	460,887	301,778	362,875	155,897	135,004	206,574	0	0	0	-	-	-	-
Settlements payable
-176,971	41,697	-121,677	150,036	149,219	-60,651	121,860	98,782	81,129	63,637	53,899	39,308	19,465	38,046	0	0	0	-	-	-	-
Customer funds obligation
-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-33,931	-	0	0	0
Charge-offs to accrued transaction losses
78,295	78,325	74,324	68,212	62,793	58,192	53,421	49,935	47,812	46,148	48,389	45,699	50,170	47,931	41,863	44,956	38,196	34,655	0	0	0
Other assets and liabilities
80,136	47,478	0	0	0	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
Accrued expenses
-	-	-	-	-	-	-	-	10,980	-	19,833	30,375	-52,289	-409	7,586	3,832	82,703	21,450	0	0	0
Other current liabilities
-	-	-	-	-	-	-	-	13,721	-	1,939	-15,789	2,177	3,909	5,976	30,690	9,742	6,655	0	0	0
Other non-current liabilities
-	-	-	-	-	-	-	-	14,168	-	9,387	9,276	7,411	3,149	4,686	3,292	4,880	11,111	0	0	0
Net cash provided by operating activities
554,551	465,699	581,003	389,884	275,471	295,080	116,054	108,153	135,766	127,711	130,213	146,259	80,878	23,131	41,228	-916	18,324	21,123	0	0	0
Cash flows from investing activities:
Purchase of marketable debt securities
1,162,784	992,583	900,255	1,190,230	1,143,798	1,000,346	918,486	395,879	413,280	544,910	511,147	376,576	273,531	164,766	139,103	102,245	73,086	0	0	0	0
Proceeds from maturities of marketable debt securities
417,529	430,888	394,533	338,410	263,509	197,454	190,748	195,433	198,105	168,224	123,011	78,496	58,769	43,200	0	0	0	-	-	-	-
Proceeds from sale of marketable debt securities
750,836	548,619	392,881	232,255	216,802	171,992	0	0	0	-	-	-	-	-	-	-	-	-	-	-	-
Purchase of marketable debt securities from customer funds
421,380	311,499	385,736	236,160	182,709	148,096	0	0	0	-	-	-	-	-	-	-	-	-	-	-	-
Proceeds from maturities of marketable debt securities from customer funds
190,055	158,055	115,200	63,000	33,000	0	0	0	0	-	-	-	-	-	-	-	-	-	-	-	-
Proceeds from sale of marketable debt securities from customer funds
0	-	-	-	0	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
Proceeds from sale of marketable debt securities from customer funds
0	-	-	-	0	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
Proceeds from sale of marketable securities
-	-	-	-	-	-	-	-	-	-	-	0	38,218	-	0	0	0	-	-	-	-
Purchase of property and equipment
70,467	62,498	69,856	68,222	71,288	61,203	43,645	35,357	27,672	26,097	25,384	23,476	24,414	25,433	26,382	32,512	34,540	37,432	0	0	0
Payments for other investments
13,250	15,250	2,000	2,000	2,000	0	0	0	0	-	-	-	-	-	-	-	-	-	-	-	-
Purchase of intangible assets
-	-	-	-	-	1,584	1,584	1,584	1,584	0	0	0	0	400	1,576	1,576	1,586	1,286	0	0	0
Increases in restricted cash
-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	0	0	0
Business combinations, net of cash acquired
21,866	20,372	20,372	20,943	122,592	112,399	112,714	112,143	1,370	1,915	2,960	2,960	2,960	1,360	0	750	750	4,500	0	0	0
Net cash used in investing activities
50,963	95,193	-427,271	-835,556	-960,742	-905,848	-755,357	-250,914	-185,710	-340,611	-362,803	-273,232	-203,622	-114,241	-119,579	-115,351	-109,962	-43,218	0	0	0
Cash flows from financing activities:
Proceeds from issuance of convertible senior notes, net
986,241	0	0	0	0	-	-	-	-	428,250	428,250	428,250	428,250	0	0	0	0	-	-	-	-
Purchase of convertible senior note hedges
149,200	0	0	0	0	-	-	-	-	92,136	92,136	92,136	92,136	0	0	0	0	-	-	-	-
Proceeds from issuance of warrants
99,500	0	0	0	0	-	-	-	-	57,244	57,244	57,244	57,244	0	0	0	0	-	-	-	-
Payment of deferred purchase consideration
-	-	-	-	-	-	-	0	0	-	-	-	-	-	-	-	-	-	-	-	-
Principal payments on finance lease obligation
-	-	-	-	-	-	-	0	1,857	-	1,188	802	415	168	0	0	0	-	-	-	-
Payment for termination of Starbucks warrant
-	-	-	-	-	-	-	-	-	54,808	54,808	54,808	54,808	0	0	0	0	-	-	-	-
Payments of offering costs related to initial public offering
-	-	-	-	-	-	-	-	-	-	-	-	-	5,530	5,530	5,530	5,406	0	0	0	0
Payments for tax withholding related to vesting of restricted stock units
210,235	212,264	227,269	227,212	212,274	189,124	152,283	113,257	72,333	44,682	0	0	0	-	-	-	-	-	-	-	-
Proceeds from the exercise of stock options, net
0	-	0	0	0	-	0	0	0	-	0	0	0	-	0	0	0	-	0	0	0
Other financing activities
0	-	-	-	0	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
Net cash provided by (used in) financing activities
846,098	-98,874	-261,192	-318,461	485,865	515,755	714,550	818,965	80,388	454,933	479,088	508,554	473,174	90,741	325,328	266,096	258,164	264,763	0	0	0
Effect of foreign exchange rate on cash and cash equivalents
-11,024	3,841	-3,740	-1,376	-7,341	-7,221	-3,687	-1,533	4,642	4,303	862	-779	-938	-438	1,731	1,771	643	-1,775	0	0	0
Net increase (decrease) in cash, cash equivalents and restricted cash
1,440,588	465,859	-111,200	-765,509	-206,747	-102,234	71,560	674,671	35,086	246,336	247,360	380,802	349,492	-807	248,708	151,600	167,169	240,893	0	0	0