TRUPANION, INC. TRUP Cash Flow

Trupanion, inc. (TRUP)

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	Dec'14	Sep'14	Jun'14	Mar'14
Net Income (Loss) Available to Common Stockholders, Basic
-1,646	-1,809	-2,720	-2,297	-743	-927	-1,490	-2,289	-1,501	-1,503	-2,388	-4,431	-5,806	-6,896	-8,174	-11,180	-14,841	-17,205	-18,480	-22,346	-21,200	-21,177	0	0	0
Net Loss
0	-	-	-	0	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
Net Cash Provided by Operating Activities [Abstract]
Adjustments to Reconcile Net Income (Loss) to Cash Provided by (Used in) Operating Activities [Abstract]
Depreciation and Amortization
5,400	5,632	5,843	5,798	5,198	4,512	4,051	4,010	4,123	4,232	4,437	4,435	4,097	3,846	3,359	2,937	2,761	2,542	2,240	2,074	1,931	1,674	0	0	0
Stock-based compensation expense
7,142	6,846	6,297	5,751	5,164	4,775	4,408	4,004	3,606	3,419	3,295	3,176	3,031	2,946	2,868	2,841	2,995	3,002	3,239	4,491	4,220	4,084	0	0	0
Amortization of Financing Costs and Discounts
-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	5,033	0	0	0
Gain on sale of equity method investment
-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-1,574	0	0	0
Other, Net
-181	-105	-140	299	220	240	377	365	309	383	129	121	192	104	236	84	57	-68	27	-4	-14	57	0	0	0
Increase (Decrease) in Operating Assets [Abstract]
Accounts and other receivables
28,575	22,772	18,238	7,476	21,068	11,248	31,975	-4,917	2,921	10,219	-10,357	7,804	4,968	1,830	1,847	399	637	328	-198	729	-91	126	0	0	0
Prepaid expenses and other assets
952	432	1,804	7,685	2,432	2,628	1,025	-4,072	-169	179	-128	598	324	-48	-180	62	600	905	781	628	343	369	0	0	0
Accounts Payable, Accrued Liabilities, and Other Liabilities
4,176	4,110	3,488	3,407	4,877	4,531	4,746	4,673	4,224	3,019	3,911	3,280	1,069	1,164	-779	-1,134	-296	-483	-31	-178	-458	449	0	0	0
Accrued liabilities
-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-480	-	1,002	362	1,369	551	0	0	0
Claims Reserve
5,806	5,059	5,143	4,292	3,775	3,440	2,994	3,183	2,799	3,149	2,822	3,241	3,798	3,226	2,157	1,771	1,686	1,241	0	0	0	-	-	0	0
Deferred revenue
23,590	19,418	17,140	13,771	11,947	10,465	10,225	9,899	8,990	9,167	9,394	8,043	5,940	2,398	2,548	2,314	2,126	1,779	1,364	1,323	998	877	0	0	0
Other payables
-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	278	-	-358	-1,460	-501	225	0	0	0
Net cash provided by operating activities
15,122	16,157	15,289	17,950	14,562	12,680	11,993	7,596	9,886	9,666	10,127	8,427	8,161	5,006	911	-1,269	-6,815	-10,425	-10,869	-13,262	-11,756	-10,801	0	0	0
Net Cash Provided by Investing Activities [Abstract]
Payments to Acquire Investments
0	-	0	0	0	-	0	0	0	-	0	0	0	-	-	-	-	-	-	-	-	-	-	-	-
Purchases of investment securities
-	-	-	-	-	-	-	-	-	-	-	-	-	31,616	24,710	24,957	25,553	24,800	0	0	0	-	-	-	0
Maturities of Investment Securities
44,657	49,762	36,232	42,293	40,318	35,413	34,899	26,675	24,801	23,372	30,548	29,621	27,418	27,247	19,177	19,252	19,635	20,180	0	0	0	-	-	-	0
Payments for (Proceeds from) Investments
-	-	-	-	-	-	-	-	-	-	-	2,684	2,676	0	539	478	443	409	0	0	0	-	-	-	-
Purchases of property and equipment
5,991	5,373	4,666	56,346	56,822	56,936	56,740	4,237	3,661	3,131	2,642	2,115	1,750	1,941	2,624	3,340	3,957	4,894	5,436	6,009	6,207	5,633	0	0	0
Payments for (Proceeds from) Other Investing Activities
1,403	2,891	2,192	2,694	2,586	1,107	0	0	0	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
Net cash used in investing activities
-26,472	-28,008	-39,413	-87,404	-88,121	-81,451	-69,452	-14,886	-11,415	-13,056	-9,850	-9,262	-10,035	-6,508	-8,396	-9,523	-10,318	-9,923	-11,315	-15,113	-12,593	-11,926	0	0	0
Net Cash Provided by Financing Activities [Abstract]
Proceeds from exercise of stock options
2,880	2,982	2,984	3,571	3,781	3,601	3,335	2,554	1,989	2,545	3,091	3,607	4,296	3,745	3,157	2,319	1,454	1,335	964	966	558	211	0	0	0
Payments Related to Tax Withholding for Share-based Compensation
1,791	1,667	1,610	2,086	2,036	1,839	0	0	0	-	-	-	-	-	-	-	-	643	643	384	384	0	0	0	0
Proceeds from debt financing, net of financing fees
-	-	-	-	-	-	-	-	-	-	-	5,461	4,001	4,988	3,988	986	987	-14,900	2,203	-29,600	-29,900	-15,000	0	0	0
Proceeds from Debt, Net of Issuance Costs
0	-	0	0	0	-	0	0	0	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
Proceeds from (Payments for) Other Financing Activities
-245	-438	462	6	310	365	-817	-547	-768	-694	0	0	0	-	-	-	-	-	-	-	-	-	-	-	-
Payments on Financing Obligation
-	-	-	-	-	-	-	-	-	-	-	-	-	-	0	0	0	-	-	-	-	-	-	-	-
Payments of Financing Costs
-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	0	0
Net cash provided by financing activities
12,555	14,044	14,926	1,624	70,857	71,229	67,838	78,914	9,951	5,081	4,640	7,877	7,094	7,672	6,373	2,973	2,182	-14,208	-17,770	42,425	43,545	57,863	0	0	0
Effect of foreign exchange rate changes on cash, cash equivalents, and restricted cash, net
-606	423	-452	-215	-662	-812	-151	-4	427	378	306	-45	-209	111	50	-131	-17	-586	-427	-181	-295	23	0	0	0
Cash, Cash Equivalents, Restricted Cash and Restricted Cash Equivalents, Period Increase (Decrease), Including Exchange Rate Effect
0	-	-	-	0	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
Net Increase in Cash, Cash Equivalents, and Restricted Cash
-	-	-	-	-	-	-	0	8,849	-	5,223	6,997	5,011	6,281	-1,062	-7,950	-14,968	-35,142	-40,381	13,869	18,901	35,159	0	0	0
Supplemental Cash Flow Information [Abstract]
Income taxes paid
-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	139	117	117	114	9	0	0	0
Interest paid
-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	155	277	1,296	1,970	1,494	0	0	0
Redemption of Warrants Non-Cash; Common Stock
0	4,500	4,500	4,500	4,500	3,000	3,000	3,000	3,000	0	0	0	0	-	-	-	-	-	-	-	-	-	-	-	-
Purchases of property and equipment included in accounts payable and accrued liabilities
699	485	155	590	-433	106	24	191	977	390	554	381	139	104	-131	-176	-211	98	733	742	1,700	911	0	0	0
Capital Lease Obligations Incurred
-	-	-	-	-	-	-	-	-	689	633	299	604	559	0	0	0	-	-	-	-	-	-	-	-
Increase in payables for deferred financing costs
-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	0	0	0