Apptio (APTI) Trailing 12-Month Cash Flow Statement

Cash Flow Summary

Apptio (APTI) 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 $3M in the twelve months ended September 30, 2018, down 36.4% from $4.72M.
Depreciation and amortization was $5.44M, down 11.6% from $6.16M.
Stock-based compensation was $21.09M, up 38.5% from $15.22M.

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
Net loss
-	-	-26,581	-	-	-	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx
Net loss						-	-	-26,581	-	-	-	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx
Adjustments to reconcile net loss to net cash provided by operating activities
Depreciation and amortization
5,444	5,703	5,947	6,101	6,158	6,085	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx
Depreciation and amortization						5,444	5,703	5,947	6,101	6,158	6,085	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx
(Accretion of discounts)/amortization of premiums on investments
541	256	30	-35	-77	-77	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx
(Accretion of discounts)/amortization of premiums on investments						541	256	30	-35	-77	-77	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx
Amortization of acquisition-related intangible assets
-	-	-	-	-	-	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx
Amortization of acquisition-related intangible assets						-	-	-	-	-	-	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 debt discount and issuance costs
3,362	1,774	185	18	27	82	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx
Amortization of debt discount and issuance costs						3,362	1,774	185	18	27	82	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx
Loss on disposal of property and equipment
2	-47	-50	4	-6	4	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx
Loss on disposal of property and equipment						2	-47	-50	4	-6	4	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx
Stock-based compensation
21,089	19,291	17,397	16,070	15,224	13,354	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx
Stock-based compensation						21,089	19,291	17,397	16,070	15,224	13,354	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx
Impairment of acquired assets
-	-	-	-	-	-	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx
Impairment of acquired assets						-	-	-	-	-	-	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx
Remeasurement of preferred stock warrant liability
-	-	-	-	-	-	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx
Remeasurement of preferred stock warrant liability						-	-	-	-	-	-	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx
Foreign exchange loss (gain)
-981	-553	-85	-25	-	-	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx
Foreign exchange loss (gain)						-981	-553	-85	-25	-	-	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx
Change in operating assets and liabilities, net of impact of business combination
Accounts receivable
14,824	2,606	11,867	10,784	4,041	6,978	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx
Accounts receivable						14,824	2,606	11,867	10,784	4,041	6,978	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx
Prepaid expenses and other assets
515	-1,946	-4,795	-3,338	-314	1,364	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx
Prepaid expenses and other assets						515	-1,946	-4,795	-3,338	-314	1,364	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
Accounts payable
2,711	2,044	2,710	2,242	-735	-160	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx
Accounts payable						2,711	2,044	2,710	2,242	-735	-160	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx
Accrued expenses
4,034	-29	-2,262	-428	2,043	1,841	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx
Accrued expenses						4,034	-29	-2,262	-428	2,043	1,841	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx
Deferred revenue
9,220	12,309	16,020	19,163	16,445	15,129	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx
Deferred revenue						9,220	12,309	16,020	19,163	16,445	15,129	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx
Deferred rent
-797	-847	-823	-799	-39	44	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx
Deferred rent						-797	-847	-823	-799	-39	44	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx
Net cash provided by operating activities
-	-	7,214	-	-	-	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx
Net cash provided by operating activities						-	-	7,214	-	-	-	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx
Business combination, net of cash acquired
-	-	-	-	-	-	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx
Business combination, net of cash acquired						-	-	-	-	-	-	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx
Purchases of property and equipment
3,004	2,763	2,738	3,603	4,721	5,318	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx
Purchases of property and equipment						3,004	2,763	2,738	3,603	4,721	5,318	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx
Proceeds from sales of equipment
-	-	-	24	-	-	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx
Proceeds from sales of equipment						-	-	-	24	-	-	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx
Proceeds from maturities of investments
131,332	112,307	93,057	50,457	-	-	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx
Proceeds from maturities of investments						131,332	112,307	93,057	50,457	-	-	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx
Purchases of investments
104,811	107,542	66,570	69,222	-	-	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx
Purchases of investments						104,811	107,542	66,570	69,222	-	-	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx
Payments for security deposits
-	-	84	-	-	-	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx
Payments for security deposits						-	-	84	-	-	-	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx
Net cash used in investing activities
-	-	-10,889	-	-	-	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx
Net cash used in investing activities						-	-	-10,889	-	-	-	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx
Proceeds from borrowings on convertible notes, net of issuance costs
-	-	-	-	-	-	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx
Proceeds from borrowings on convertible notes, net of issuance costs						-	-	-	-	-	-	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx
Purchase of capped calls
-	-	-	-	-	-	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx
Purchase of capped calls						-	-	-	-	-	-	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx
Proceeds from exercises of common stock options
30,952	30,315	28,825	21,868	9,281	6,317	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx
Proceeds from exercises of common stock options						30,952	30,315	28,825	21,868	9,281	6,317	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx
Payment of initial public offering costs
-	-	-	243	2,031	2,387	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx
Payment of initial public offering costs						-	-	-	243	2,031	2,387	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx
Proceeds from long-term debt
-	-	-	-	-	-	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx
Proceeds from long-term debt						-	-	-	-	-	-	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx
Principal payments on capital lease obligations
31	35	38	43	42	41	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx
Principal payments on capital lease obligations						31	35	38	43	42	41	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx
Net cash provided by financing activities
-	-	155,514	-	-	-	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx
Net cash provided by financing activities						-	-	155,514	-	-	-	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx
Foreign currency effect on cash, cash equivalents and restricted cash
-	-	323	-	-	-	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx
Foreign currency effect on cash, cash equivalents and restricted cash						-	-	323	-	-	-	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx
Net increase (decrease) in cash, cash equivalents and restricted cash
-	-	152,162	-	-	-	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx
Net increase (decrease) in cash, cash equivalents and restricted cash						-	-	152,162	-	-	-	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx
Supplemental non-cash disclosures
Business acquisition working capital adjustment
-	-	-	-	-	-	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx
Business acquisition working capital adjustment						-	-	-	-	-	-	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx
Debt issuance costs in accounts payable and accrued expenses
-	-	-	-	-	-	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx
Debt issuance costs in accounts payable and accrued expenses						-	-	-	-	-	-	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx
Purchases under capital lease obligations
-	-	-	-	-	-	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx
Purchases under capital lease obligations						-	-	-	-	-	-	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx
Property and equipment additions in accounts payable and accrued expenses
1,967	58	284	453	-	-	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx
Property and equipment additions in accounts payable and accrued expenses						1,967	58	284	453	-	-	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx	xxxxx