BlackLine, Inc. BL Cash Flow

Blackline, inc. (BL)

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
Cash flows from operating activities
Net loss attributable to BlackLine, Inc.
-36,597	-32,535	-31,692	-26,910	-30,340	-28,714	-24,595	-32,209	-32,878	-33,408	-31,727	-26,272	-24,687	-26,337	0	0	0
Net loss and adjustment attributable to redeemable non-controlling interest (Note 3)
2,512	389	0	0	0	-	-	-	-	-	-	-	-	-	-	-	-
Net loss
-34,085	-32,146	-31,839	-27,387	-30,652	-28,776	0	0	0	-	-	-	-	-	-	-	-
Adjustments to reconcile net loss to net cash provided by operating activities:
Depreciation and amortization
20,155	21,274	22,372	22,881	22,631	22,336	21,952	21,203	20,574	19,971	19,520	18,789	18,104	17,424	0	0	0
Change in fair value of common stock warrant liability
-	-	-	-	-	-	-	-	-	3,490	0	0	0	-	-	-	-
Change in fair value of contingent consideration
200	46	476	444	329	450	548	629	647	628	460	417	402	371	0	0	0
Amortization of debt discount and issuance costs
0	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
Stock-based compensation
37,056	34,052	30,793	25,992	23,373	20,895	17,800	21,575	18,169	16,044	14,943	7,188	6,750	6,526	0	0	0
Noncash lease expense
4,998	5,013	0	0	0	-	-	-	-	-	-	-	-	-	-	-	-
Accretion amortization of purchase discounts on marketable securities, net
2,275	2,161	1,199	1,397	1,270	928	665	400	93	-37	0	0	0	-	-	-	-
Net foreign currency losses
-763	-65	-224	-18	-607	-420	0	0	0	-	-	-	-	-	-	-	-
Deferred income taxes
1,007	1,314	691	502	775	213	62	-51	78	85	-5,067	-6,738	-8,300	-9,467	0	0	0
Provision for doubtful accounts receivable
201	157	92	32	-8	-84	0	0	0	-	-	-	-	-	-	-	-
Accretion of debt discount and accrual of paid-in-kind interest
-	-	-	-	-	-	-	-	-	-	-	-	-	4,557	0	0	0
Changes in operating assets and liabilities:
Accounts receivable
18,148	27,962	18,927	18,130	15,932	13,207	18,383	18,306	13,536	20,189	9,149	15,364	15,637	15,541	0	0	0
Deferred sales commissions
-	-	-	-	-	-	-	-	-	-	-	-	-	-	0	0	0
Prepaid expenses and other current assets
2,064	-1,224	-5,072	-4,776	-3,231	449	3,103	3,781	2,649	2,035	5,602	5,029	5,474	5,214	0	0	0
Other assets
15,097	16,429	14,105	13,657	10,689	9,475	7,570	8,138	7,027	7,176	11,907	9,956	8,111	7,434	0	0	0
Accounts payable
3,671	3,244	-1,198	-164	-2,253	-4,008	-241	-2,448	2,299	-25	-3,891	-1,018	-1,130	3,544	0	0	0
Accrued expenses and other current liabilities
2,137	5,789	5,696	1,271	5,764	4,191	2,003	3,071	-3,346	2,120	2,037	4,517	3,426	3,864	0	0	0
Deferred revenue
28,197	33,364	25,745	26,672	22,010	24,699	26,004	30,568	24,640	26,504	21,516	25,961	29,248	24,626	0	0	0
Operating lease liabilities
5,443	5,530	0	0	0	-	-	-	-	-	-	-	-	-	-	-	-
Other long-term liabilities
-	-	-	-	-	-137	-23	122	128	-187	-727	-837	-812	-1,189	0	0	0
Net cash provided by operating activities
35,215	29,724	26,323	21,283	17,344	16,140	14,067	12,760	9,951	6,424	-2,183	-1,551	-1,862	-4,808	0	0	0
Cash flows from investing activities
Purchases of marketable securities
652,100	565,675	112,165	125,138	122,330	122,530	0	0	0	-	-	-	-	-	-	-	-
Proceeds from maturities of marketable securities
406,992	149,638	114,692	123,933	114,709	111,394	120,484	116,034	101,485	78,205	0	0	0	-	-	-	-
Proceeds from sales of marketable securities
0	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
Capitalized software development costs
6,117	5,060	4,786	5,161	5,254	5,675	5,919	5,754	5,194	4,624	4,289	3,781	3,546	3,270	0	0	0
Purchases of property and equipment
4,681	4,632	5,157	4,577	5,753	6,284	4,861	6,580	5,148	4,002	4,145	1,940	1,803	1,724	0	0	0
Net cash provided by (used in) investing activities
-226,627	-408,450	9,863	-3,825	-11,510	-15,977	-11,765	-14,425	-15,642	-7,031	-93,712	-121,180	-114,829	-119,674	0	0	0
Cash flows from financing activities
Proceeds from exercises of stock options
12,463	10,571	8,855	12,504	13,315	14,004	15,100	10,556	13,640	10,252	9,336	8,319	2,790	2,860	0	0	0
Acquisition of common stock for tax withholding obligations
5,773	3,940	3,403	2,731	5,069	3,356	0	0	0	-	-	-	-	-	-	-	-
Payments of initial public offering costs
-	-	-	-	-	-	-	-	-	110	3,320	3,370	3,757	4,372	0	0	0
Principal payments on capital lease obligations
-	-	-	-	-	443	443	443	443	549	549	549	549	124	0	0	0
Financed purchases of property and equipment
0	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
Cash flows from financing activities
Proceeds from term loan, net of issuance costs
-	-	-	-	-	-	-	-	-	-	-	-	-	34,300	0	0	0
Net cash provided by financing activities
452,402	452,512	453,020	16,497	12,563	14,522	11,332	6,900	13,181	9,593	100,954	132,591	126,675	131,395	0	0	0
Effect of foreign currency exchange rate changes on cash, cash equivalents, and restricted cash
-	261	0	0	0	-	-	-	-	-	-	-	-	-	-	-	-
Net increase in cash, cash equivalents, and restricted cash
261,307	74,047	489,780	34,385	18,607	14,951	13,634	5,235	7,490	8,986	5,059	9,860	9,984	6,913	0	0	0
Non-cash financing and investing activities
Stock-based compensation capitalized for software development
608	491	386	403	410	417	369	266	175	135	125	118	110	102	0	0	0
Capitalized software development costs included in accounts payable and accrued expenses and other current liabilities at end of period
808	560	213	208	300	359	508	499	485	331	197	167	163	153	0	0	0
Purchases of property and equipment included in accounts payable and accrued expenses and other current liabilities at end of period
1,453	863	473	1,322	581	168	306	-47	231	293	-44	452	272	63	0	0	0
Purchases of prepaid expenses and other current assets included in accounts payable at end of period
0	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
Leased assets obtained in exchange for new operating lease liabilities
2,792	2,699	0	0	0	-	-	-	-	-	-	-	-	-	-	-	-
Deferred offering costs included in accounts payable and accrued expenses and other current liabilities at end of period
-	-	-	-	-	-	-	-	-	-	-	-	-	110	0	0	0
Term loan issuance costs included in accounts payable and accrued expenses and other current liabilities at end of period
-	-	-	-	-	-	-	-	-	-	-	-	-	-	0	0	0