Hortonworks (HDP) Trailing 12-Month Cash Flow Statement

Cash Flow Summary

Hortonworks (HDP) trailing twelve month cash flow statement covering six trailing twelve month periods to September 30, 2018, as reported to the SEC.

Purchases of property and equipment were $3.42M in the twelve months ended September 30, 2018, down 44.1% from $6.12M.
Net loss was $163.05M, a smaller loss than the $213.33M a year earlier.
Proceeds from issuance of common stock were $24.79M, up 58.6% from $15.63M.

A cash flow statement shows the cash that actually came in and went out, split between running the business, investing and financing.

Figures in USD thousands

						Sep'18	Jun'18	Mar'18	Dec'17	Sep'17	Jun'17
CASH FLOWS FROM OPERATING ACTIVITIES:
Net loss
-163,054	-176,848	-191,727	-204,507	-213,332	-232,650	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx
Net loss						-163,054	-176,848	-191,727	-204,507	-213,332	-232,650	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx
Adjustments to reconcile net loss to net cash used in operating activities:
Depreciation
8,650	8,820	8,863	8,786	8,531	8,191	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx
Depreciation						8,650	8,820	8,863	8,786	8,531	8,191	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx
Amortization of deferred costs
-	-	-	-	-	-	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx
Amortization of deferred costs						-	-	-	-	-	-	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx
Amortization of premiums from investments
-	-	223	-	-	-	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx
Amortization of premiums from investments						-	-	223	-	-	-	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx
Amortization of intangible assets
879	879	879	879	878	879	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx
Amortization of intangible assets						879	879	879	879	878	879	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx
Stock-based compensation expense
-	-	-	-	-	-	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx
Stock-based compensation expense						-	-	-	-	-	-	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx
Loss on early exit of lease
-	-	-	-349	-	-	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx
Loss on early exit of lease						-	-	-	-349	-	-	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx
Impairment of promissory note and related interest receivable
-	-	-	-	-	-	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx
Impairment of promissory note and related interest receivable						-	-	-	-	-	-	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx
Contra-revenue adjustment related to share purchase agreement
-	-	-	-	-	-	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx
Contra-revenue adjustment related to share purchase agreement						-	-	-	-	-	-	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx
Loss on disposal of assets
-	-	-	-	-	-	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx
Loss on disposal of assets						-	-	-	-	-	-	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx
Effects of exchange rate changes on monetary assets and liabilities denominated in foreign currencies
292	-454	-2,259	-1,802	-876	-596	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx
Effects of exchange rate changes on monetary assets and liabilities denominated in foreign currencies						292	-454	-2,259	-1,802	-876	-596	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx
Provision for losses on accounts receivable
-	-	-	-	-	-	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx
Provision for losses on accounts receivable						-	-	-	-	-	-	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx
Other
-495	-440	-473	-333	-254	-156	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx
Other						-495	-440	-473	-333	-254	-156	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx
Changes in operating assets and liabilities:
Accounts receivable
-1,398	13,560	1,037	26,885	914	13,768	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx
Accounts receivable						-1,398	13,560	1,037	26,885	914	13,768	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx
Contract assets
-	-	-	-	-	-	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx
Contract assets						-	-	-	-	-	-	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx
Prepaid expenses and other current assets
2,474	4,342	5,642	5,294	3,027	1,349	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx
Prepaid expenses and other current assets						2,474	4,342	5,642	5,294	3,027	1,349	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx
Deferred costs
-	-	-	-	-	-	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx
Deferred costs						-	-	-	-	-	-	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx
Other assets
475	276	-114	1,035	2,725	917	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx
Other assets						475	276	-114	1,035	2,725	917	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx
Other non-current assets
-	-	-	-	-	-	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx
Other non-current assets						-	-	-	-	-	-	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx
Accounts payable
590	-2,808	-1,261	-767	-3,685	-3,521	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx
Accounts payable						590	-2,808	-1,261	-767	-3,685	-3,521	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx
Accrued expenses and other current liabilities
1,907	-442	-4,497	-1,151	-1,384	2,072	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx
Accrued expenses and other current liabilities						1,907	-442	-4,497	-1,151	-1,384	2,072	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx
Accrued liabilities and other long-term liabilities
-	-	-	-	-	-	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx
Accrued liabilities and other long-term liabilities						-	-	-	-	-	-	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx
Accrued compensation and benefits
-1,228	924	-1,634	3,978	1,994	3,250	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx
Accrued compensation and benefits						-1,228	924	-1,634	3,978	1,994	3,250	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx
Deferred revenue
56,654	67,936	67,876	84,564	70,193	83,096	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx
Deferred revenue						56,654	67,936	67,876	84,564	70,193	83,096	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx
Other contract liabilities
-	-	-	-	-	-	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx
Other contract liabilities						-	-	-	-	-	-	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx
Other long-term liabilities
-460	-791	-917	-992	-672	-492	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx
Other long-term liabilities						-460	-791	-917	-992	-672	-492	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx
Net cash provided by (used in) operating activities
-	-	-12,792	-	-	-	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx
Net cash provided by (used in) operating activities						-	-	-12,792	-	-	-	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx
CASH FLOWS FROM INVESTING ACTIVITIES:
Purchases of investments
-	-	-	-	-	-	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx
Purchases of investments						-	-	-	-	-	-	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx
Proceeds from sales of investments
-	-	-	-	-	-	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx
Proceeds from sales of investments						-	-	-	-	-	-	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx
Proceeds from maturities of investments
24,615	24,245	23,565	32,865	43,493	67,569	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx
Proceeds from maturities of investments						24,615	24,245	23,565	32,865	43,493	67,569	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx
Purchases of property and equipment
3,418	4,685	5,034	5,223	6,117	7,709	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx
Purchases of property and equipment						3,418	4,685	5,034	5,223	6,117	7,709	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx
Issuance of promissory note receivable
-	-	-	-	-	-	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx
Issuance of promissory note receivable						-	-	-	-	-	-	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx
Change in restricted cash
-	-	-	-	-	-	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx
Change in restricted cash						-	-	-	-	-	-	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx
Net cash (used in) provided by investing activities
-	-	-7,000	-	-	-	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx
Net cash (used in) provided by investing activities						-	-	-7,000	-	-	-	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx
CASH FLOWS FROM FINANCING ACTIVITIES:
Proceeds from issuance of common stock
24,789	24,567	24,778	19,464	15,630	9,202	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx
Proceeds from issuance of common stock						24,789	24,567	24,778	19,464	15,630	9,202	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx
Proceeds from exercise of warrants
-	-	-	-	-	-	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx
Proceeds from exercise of warrants						-	-	-	-	-	-	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx
Tax withholding shares
-	-	-	-	-	-	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx
Tax withholding shares						-	-	-	-	-	-	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx
Payment of contingent consideration related to an acquisition
-	-	-	-	-	-	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx
Payment of contingent consideration related to an acquisition						-	-	-	-	-	-	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx
Payments of capital lease liability
-	-	392	-	-	-	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx
Payments of capital lease liability						-	-	392	-	-	-	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx
Payment of fees for line of credit
408	329	79	79	-	-	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx
Payment of fees for line of credit						408	329	79	79	-	-	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx
Proceeds from sale of preferred stock, net of issuance costs
-	-	-	-	-	-	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx
Proceeds from sale of preferred stock, net of issuance costs						-	-	-	-	-	-	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx
Proceeds from follow-on public offering, net of issuance costs
-	-	-	-	-	-	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx
Proceeds from follow-on public offering, net of issuance costs						-	-	-	-	-	-	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx
Net cash provided by financing activities
-	-	21,230	-	-	-	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx
Net cash provided by financing activities						-	-	21,230	-	-	-	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx
Effect of exchange rate changes on cash, cash equivalents and restricted cash
-	-	1,525	-	-	-	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx
Effect of exchange rate changes on cash, cash equivalents and restricted cash						-	-	1,525	-	-	-	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx
Net increase in cash, cash equivalents and restricted cash
-	-	2,963	-	-	-	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx
Net increase in cash, cash equivalents and restricted cash						-	-	2,963	-	-	-	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx
SUPPLEMENTAL DISCLOSURES OF NON-CASH INVESTING AND FINANCING INFORMATION:
Purchases of property and equipment included in accounts payable and accrued expenses and other current liabilities
-	-	-	-	-	-	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx
Purchases of property and equipment included in accounts payable and accrued expenses and other current liabilities						-	-	-	-	-	-	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx