TRUPANION, INC. TRUP Cash Flow

Trupanion, inc. (TRUP)

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	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,133	636	782	-1,931	-1,296	-275	1,205	-377	-1,480	-838	406	411	-1,482	-1,723	-1,637	-964	-2,572	-3,001	-4,643	-4,625	-4,936	-4,276	-8,509	-3,479	-4,913
Net Loss
1,133	-	-	-	1,296	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
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
1,381	1,274	1,181	1,564	1,613	1,485	1,136	964	927	1,024	1,095	1,077	1,036	1,229	1,093	739	785	742	671	563	566	440	505	420	309
Stock-based compensation expense
1,653	1,771	1,845	1,873	1,357	1,222	1,299	1,286	968	855	895	888	781	731	776	743	696	653	749	897	703	890	2,001	626	567
Amortization of Financing Costs and Discounts
-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	0	4,563	243	227
Gain on sale of equity method investment
-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	0	-2,054	-739	1,219
Other, Net
-73	38	-240	94	3	3	199	15	23	140	187	-41	97	-114	179	30	9	18	27	3	-116	113	-4	-7	-45
Increase (Decrease) in Operating Assets [Abstract]
Accounts and other receivables
11,697	4,190	30,522	-17,834	5,894	-344	19,760	-4,242	-3,926	20,383	-17,132	3,596	3,372	-193	1,029	760	234	-176	-419	998	-75	-702	508	178	142
Prepaid expenses and other assets
195	707	-1,264	1,314	-325	2,079	4,617	-3,939	-129	476	-480	-36	219	169	246	-310	-153	37	488	228	152	-87	335	-57	178
Accounts Payable, Accrued Liabilities, and Other Liabilities
1,322	1,304	1,363	187	1,256	682	1,282	1,657	910	897	1,209	1,208	-295	1,789	578	-1,003	-200	-154	223	-165	-387	298	76	-445	520
Accrued liabilities
-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-1,267	-	670	119	-736	949	30	1,126	-1,554
Claims Reserve
1,825	1,872	1,042	1,067	1,078	1,956	191	550	743	1,510	380	166	1,093	1,183	799	723	521	114	413	638	76	-	-	-562	-657
Deferred revenue
9,695	2,610	5,841	5,444	5,523	332	2,472	3,620	4,041	92	2,146	2,711	4,218	319	795	608	676	469	561	420	329	54	520	95	208
Other payables
-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	135	-	526	-612	-330	58	-576	347	396
Net cash provided by operating activities
2,924	4,532	4,744	2,922	3,959	3,664	7,405	-466	2,077	2,977	3,008	1,824	1,857	3,438	1,308	1,558	-1,298	-657	-872	-3,988	-4,908	-1,101	-3,265	-2,482	-3,953
Net Cash Provided by Investing Activities [Abstract]
Payments to Acquire Investments
11,579	-	13,270	14,872	17,350	-	9,181	13,246	7,140	-	5,809	9,723	5,172	-	-	-	-	-	-	-	-	-	-	-	-
Purchases of investment securities
-	-	-	-	-	-	-	-	-	-	-	-	-	15,624	4,769	7,264	3,959	8,718	5,016	7,860	3,206	-	-	-	2,677
Maturities of Investment Securities
5,100	21,538	6,329	11,690	10,205	8,008	12,390	9,715	5,300	7,494	4,166	7,841	3,871	14,670	3,239	5,638	3,700	6,600	3,314	6,021	4,245	-	-	-	3,809
Payments for (Proceeds from) Investments
-	-	-	-	-	-	-	-	-	-	-	43	2,710	-130	61	35	34	409	0	0	0	-	-	-	-
Purchases of property and equipment
1,496	1,787	1,806	902	878	1,080	53,486	1,378	992	884	983	802	462	395	456	437	653	1,078	1,172	1,054	1,590	1,620	1,745	1,252	1,016
Payments for (Proceeds from) Other Investing Activities
-9	954	463	-5	1,479	255	965	-113	0	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
Net cash used in investing activities
-7,966	-5,217	-9,210	-4,079	-9,502	-16,622	-57,201	-4,796	-2,832	-4,623	-2,635	-1,325	-4,473	-1,417	-2,047	-2,098	-946	-3,305	-3,174	-2,893	-551	-4,697	-6,972	-373	116
Net Cash Provided by Financing Activities [Abstract]
Proceeds from exercise of stock options
559	727	629	965	661	729	1,216	1,175	481	463	435	610	1,037	1,009	951	1,299	486	421	113	434	367	50	115	26	20
Payments Related to Tax Withholding for Share-based Compensation
321	57	1,363	50	197	0	1,839	0	0	-	-	-	-	-	-	-	-	0	259	0	384	0	0	0	0
Proceeds from debt financing, net of financing fees
-	-	-	-	-	-	-	-	-	-	-	1,459	0	1,000	3,002	-1	987	0	0	0	-14,900	17,103	-31,803	-300	0
Proceeds from Debt, Net of Issuance Costs
3,744	-	3,000	967	5,200	-	-61	3,750	5,500	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
Proceeds from (Payments for) Other Financing Activities
-78	0	-23	-144	-271	900	-479	160	-216	-282	-209	-61	-142	-	-	-	-	-	-	-	-	-	-	-	-
Payments on Financing Obligation
-	-	-	-	-	-	-	-	-	-	-	-	-	-	37	73	0	-	-	-	-	-	-	-	-
Payments of Financing Costs
-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	472	619
Net cash provided by financing activities
3,904	4,670	2,243	1,738	5,393	5,552	-11,059	70,971	5,765	2,161	17	2,008	895	1,720	3,254	1,225	1,473	421	-146	434	-14,917	-3,141	60,049	1,554	-599
Effect of foreign exchange rate changes on cash, cash equivalents, and restricted cash, net
-809	156	-129	176	220	-719	108	-271	70	-58	255	160	21	-130	-96	-4	341	-191	-277	110	-228	-32	-31	-4	90
Cash, Cash Equivalents, Restricted Cash and Restricted Cash Equivalents, Period Increase (Decrease), Including Exchange Rate Effect
-1,947	-	-	-	70	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
Net Increase in Cash, Cash Equivalents, and Restricted Cash
-	-	-	-	-	-	-	65,438	5,080	-	645	2,667	-1,700	3,611	2,419	681	-430	-3,732	-4,469	-6,337	-20,604	-8,971	49,781	-1,305	-4,346
Supplemental Cash Flow Information [Abstract]
Income taxes paid
-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	22	0	19	98	0	0	16	-7
Interest paid
-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	0	-104	10	249	122	915	684	-227
Redemption of Warrants Non-Cash; Common Stock
0	0	0	0	4,500	0	0	0	3,000	0	0	0	0	-	-	-	-	-	-	-	-	-	-	-	-
Purchases of property and equipment included in accounts payable and accrued liabilities
355	271	-423	496	141	-59	12	-527	680	-141	179	259	93	23	6	17	58	-212	-39	-18	367	423	-30	940	-422
Capital Lease Obligations Incurred
-	-	-	-	-	-	-	-	-	0	623	21	45	-56	289	326	0	-	-	-	-	-	-	-	-
Increase in payables for deferred financing costs
-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-1,351	2,299	-812