BlackLine, Inc. BL Cash Flow

Blackline, inc. (BL)

CashFlow / Quarterly

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
Cash flows from operating activities
Net loss attributable to BlackLine, Inc.
-12,843	-9,485	-9,242	-5,027	-8,781	-8,642	-4,460	-8,457	-7,155	-4,523	-12,074	-9,126	-7,685	-2,842	-6,619	-7,541	-9,335
Net loss and adjustment attributable to redeemable non-controlling interest (Note 3)
1,873	474	330	-165	-250	-	-	-	-	-	-	-	-	-	-	-	-
Net loss
-10,970	-9,011	-8,912	-5,192	-9,031	-8,704	-4,460	-8,457	-7,155	-	-	-	-	-	-	-	-
Adjustments to reconcile net loss to net cash provided by operating activities:
Depreciation and amortization
4,570	4,471	5,327	5,787	5,689	5,569	5,836	5,537	5,394	5,185	5,087	4,908	4,791	4,734	4,356	4,223	4,111
Change in fair value of common stock warrant liability
-	-	-	-	-	-	-	-	-	0	0	2,490	1,000	-	-	-	-
Change in fair value of contingent consideration
145	-267	129	193	-9	163	97	78	112	261	178	96	93	93	135	81	62
Amortization of debt discount and issuance costs
5,532	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
Stock-based compensation
9,456	9,447	10,141	8,012	6,452	6,188	5,340	5,393	3,974	3,093	9,115	1,987	1,849	1,992	1,360	1,549	1,625
Noncash lease expense
1,230	1,336	1,217	1,215	1,245	-	-	-	-	-	-	-	-	-	-	-	-
Accretion amortization of purchase discounts on marketable securities, net
523	1,288	100	364	409	326	298	237	67	63	33	-70	-63	-	-	-	-
Net foreign currency losses
-826	73	-137	127	-128	-86	69	-462	59	-	-	-	-	-	-	-	-
Deferred income taxes
13	1,279	53	-338	320	656	-136	-65	-242	505	-249	64	-235	-4,647	-1,920	-1,498	-1,402
Provision for doubtful accounts receivable
69	0	84	48	25	-65	24	8	-51	-	-	-	-	-	-	-	-
Accretion of debt discount and accrual of paid-in-kind interest
-	-	-	-	-	-	-	-	-	-	-	-	-	2,474	871	731	481
Changes in operating assets and liabilities:
Accounts receivable
-12,147	20,507	3,184	6,604	-2,333	11,472	2,387	4,406	-5,058	16,648	2,310	-364	1,595	5,608	8,525	-91	1,499
Deferred sales commissions
-	-	-	-	-	-	-	-	-	-	-	-	-	-	922	303	-242
Prepaid expenses and other current assets
1,499	1,905	-528	-812	-1,789	-1,943	-232	733	1,891	711	446	-399	1,277	4,278	-127	46	1,017
Other assets
1,167	6,782	2,011	5,137	2,499	4,458	1,563	2,169	1,285	2,553	2,131	1,058	1,434	7,284	180	-787	757
Accounts payable
1,253	4,835	-525	-1,892	826	393	509	-3,981	-929	4,160	-1,698	766	-3,253	294	1,175	654	1,421
Accrued expenses and other current liabilities
-10,014	4,342	5,498	2,311	-6,362	4,249	1,073	6,804	-7,935	2,061	2,141	387	-2,469	1,978	4,621	-704	-2,031
Deferred revenue
-1,298	18,393	-152	11,254	3,869	10,774	775	6,592	6,558	12,079	5,339	664	8,422	7,091	9,784	3,951	3,800
Operating lease liabilities
1,253	1,533	1,299	1,358	1,340	-	-	-	-	-	-	-	-	-	-	-	-
Other long-term liabilities
-	-	-	-	-	-173	-159	-145	340	-59	-14	-139	25	-599	-124	-114	-352
Net cash provided by operating activities
8,517	8,224	9,854	8,620	3,026	4,823	4,814	4,681	1,822	2,750	3,507	1,872	-1,705	-5,857	4,139	1,561	-4,651
Cash flows from investing activities
Purchases of marketable securities
116,400	472,416	23,737	39,547	29,975	18,906	36,710	36,739	30,175	-	-	-	-	-	-	-	-
Proceeds from maturities of marketable securities
289,149	54,500	20,150	43,193	31,795	19,554	29,391	33,969	28,480	28,644	24,941	19,420	5,200	-	-	-	-
Proceeds from sales of marketable securities
12,000	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
Capitalized software development costs
2,289	1,309	1,152	1,367	1,232	1,035	1,527	1,460	1,653	1,279	1,362	900	1,083	944	854	665	807
Purchases of property and equipment
1,152	1,171	1,472	886	1,103	1,696	892	2,062	1,634	273	2,611	630	488	416	406	493	409
Net cash provided by (used in) investing activities
181,308	-420,396	11,068	1,393	-515	-2,083	-2,620	-6,292	-4,982	2,129	-5,280	-7,509	3,629	-84,552	-32,748	-1,158	-1,216
Cash flows from financing activities
Proceeds from exercises of stock options
4,656	2,200	3,806	1,801	2,764	484	7,455	2,612	3,453	1,580	2,911	5,696	65	664	1,894	167	135
Acquisition of common stock for tax withholding obligations
3,562	568	784	859	1,729	31	112	3,197	16	-	-	-	-	-	-	-	-
Payments of initial public offering costs
-	-	-	-	-	-	-	-	-	0	0	0	110	3,210	50	387	725
Principal payments on capital lease obligations
-	-	-	-	-	0	0	0	443	0	0	0	549	0	0	0	124
Financed purchases of property and equipment
169	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
Cash flows from financing activities
Proceeds from term loan, net of issuance costs
-	-	-	-	-	-	-	-	-	-	-	-	-	-169	29,629	0	4,840
Net cash provided by financing activities
925	4,262	443,866	3,349	1,035	4,770	7,343	-585	2,994	1,580	2,911	5,696	-594	92,941	34,548	-220	4,126
Effect of foreign currency exchange rate changes on cash, cash equivalents, and restricted cash
-	-47	144	220	-56	-	-	-	-	-	-	-	-	-	-	-	-
Net increase in cash, cash equivalents, and restricted cash
190,750	-407,957	464,932	13,582	3,490	7,776	9,537	-2,196	-166	6,459	1,138	59	1,330	2,532	5,939	183	-1,741
Non-cash financing and investing activities
Stock-based compensation capitalized for software development
180	195	119	114	63	90	136	121	70	42	33	30	30	32	26	22	22
Capitalized software development costs included in accounts payable and accrued expenses and other current liabilities at end of period
388	378	69	-27	140	31	64	65	199	180	55	51	45	46	25	47	35
Purchases of property and equipment included in accounts payable and accrued expenses and other current liabilities at end of period
1,386	503	-919	483	796	113	-70	-258	383	251	-423	20	445	-86	73	-160	236
Purchases of prepaid expenses and other current assets included in accounts payable at end of period
2,333	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
Leased assets obtained in exchange for new operating lease liabilities
130	504	1,139	1,019	37	-	-	-	-	-	-	-	-	-	-	-	-
Deferred offering costs included in accounts payable and accrued expenses and other current liabilities at end of period
-	-	-	-	-	-	-	-	-	-	-	-	-	-2,076	586	-17	1,617
Term loan issuance costs included in accounts payable and accrued expenses and other current liabilities at end of period
-	-	-	-	-	-	-	-	-	-	-	-	-	-	63	0	80