U.S. AUTO PARTS NETWORK, INC. PRTS Cash Flow

U.s. auto parts network, inc. (PRTS)

CashFlow / TTM

Mar'20	Dec'19	Sep'19	Jun'19	Mar'19	Dec'18	Sep'18	Sep'18	Jun'18	Mar'18	Dec'17	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	Dec'13	Sep'13	Jun'13	Mar'13	Dec'12	Sep'12	Jun'12	Mar'12	Dec'11	Sep'11	Jun'11	Mar'11
Operating activities
Net loss
-28,945	-31,548	-10,941	-9,698	-9,038	-4,889	-	-4,488	-3,389	24,326	-	24,015	26,180	24,901	-1,336	-603	0	0	0	-	-	-	-	-	-	-	-	-	0	0	0	-	-12,214	-14,811	-15,680	-15,137	0	0	0
Net loss including noncontrolling interests
-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-4,239	-6,445	-7,603	-7,086	0	0	0	-	-	-	-	-	-	-	-	-	-	-	-
Adjustments to reconcile net income to net cash provided by operating activities:
Depreciation and amortization expense
-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	12,175	13,407	14,720	15,095	15,204	15,026	14,368	13,439	12,695	0	0	0
Depreciation and amortization expense
6,621	6,252	5,962	5,849	5,827	5,802	-	5,919	6,120	6,268	-	6,397	6,799	7,076	7,292	7,510	7,493	7,458	7,427	7,510	0	0	0	-	0	0	0	-	-	-	-	-	-	-	-	-	-	-	-
Amortization of intangible assets
100	100	120	141	163	185	-	0	0	0	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
Amortization of intangible assets
100	100	120	141	163	185	-	188	189	254	-	319	392	465	474	482	0	0	0	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
Amortization of intangible assets
-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	451	442	453	422	398	378	359	381	476	721	955	1,189	1,357	1,364	2,386	3,673	0	0	0
Deferred income taxes
21,593	21,287	-1,811	-1,202	-1,116	-446	-	4,594	4,602	-21,134	-	-21,476	-26,420	-26,462	-660	-838	-531	-711	-1,017	-906	-660	-429	-6	74	10	20	41	59	-1,140	-1,038	-970	-875	-1,350	-1,503	-1,436	-1,537	0	0	0
Share-based compensation expense
5,769	3,656	3,846	3,621	3,169	3,595	-	2,348	2,346	2,729	-	2,842	2,854	3,096	3,418	3,131	3,168	2,981	2,711	2,419	2,406	2,472	2,505	2,371	1,889	1,518	1,230	1,263	1,330	1,465	1,498	1,673	2,069	2,241	2,510	2,607	0	0	0
Stock awards issued for non-employee director service
21	19	16	14	14	14	-	13	11	11	-	9	10	10	9	9	6	6	4	2	0	0	0	-	-	-	-	31	0	0	0	-	-	-	-	-	-	-	-
Amortization of deferred financing costs
5	1	3	4	4	4	-	4	4	11	-	32	40	59	72	70	82	82	82	82	81	81	81	81	81	81	81	81	86	84	75	94	121	137	156	147	0	0	0
Loss from disposition of assets
-	-	-	-	-	-	-	-	-	-	-	8	8	8	8	0	0	0	0	13	88	111	109	96	0	0	0	-	-	-	-	-14	0	0	0	-	-	-	-
Changes in operating assets and liabilities:
Accounts receivable
-715	-1,058	1,317	1,407	2,389	1,257	-	102	-65	196	-	-796	-61	-273	-300	30	-552	-147	-748	-568	-295	-493	-553	-1,105	-938	-1,614	-2,159	-2,403	-3,688	-4,144	-2,149	-491	-222	2,159	2,396	2,583	0	0	0
Inventory
5,654	2,874	-3,830	-432	-6,174	-4,605	-	-2,190	789	694	-	3,327	4,248	7,774	10,249	-312	3,286	-799	-1,410	2,854	1,405	10,078	11,771	11,412	4,640	998	-1,020	-5,740	-8,482	-15,048	-8,476	-9,520	2,940	3,423	3,428	4,145	0	0	0
Other current assets
1,438	1,527	224	1,573	1,686	1,326	-	1,764	1,476	573	-	292	-135	-697	-214	255	-217	634	-138	-262	341	-168	317	-471	-585	-1,438	-369	-954	-738	354	-220	618	42	-334	-1,153	-734	0	0	0
Other non-current assets
-39	-166	-949	-173	-60	-150	-	202	125	75	-	-40	-253	-288	-289	-203	-300	-266	-281	-225	-63	78	109	39	364	278	173	213	0	0	0	-	-	-	-	-	-	-	0
Accounts payable and accrued expenses
17,222	9,953	-876	4,655	1,156	742	-	3,270	24	2,402	-	2,725	5,028	13,859	16,076	7,906	8,404	2,685	114	119	3,663	1,959	6,697	6,992	1,339	2,725	-2,798	-11,833	-13,077	-17,698	-11,852	-14,912	-8,645	-1,302	-554	6,218	0	0	0
Other current liabilities
-181	-99	-218	139	157	-1,135	-	-1,788	-877	-1,047	-	-712	1,363	692	1,107	1,775	117	-4	172	475	120	-2	-1,100	-302	37	215	683	-1,054	-169	-1,305	-2,981	-2,964	-3,397	110	1,633	2,202	0	0	0
Right-of-Use Obligation - Operating Leases - Current
615	1,364	0	0	0	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
Right-of-Use Obligation - Operating Leases - Long-term
-374	-1,121	0	0	0	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
Other non-current liabilities
193	190	24	76	-5	136	-	281	300	354	-	274	780	733	750	769	178	130	25	-184	-175	-210	-112	-261	-234	-179	-178	472	272	399	424	203	541	414	418	378	0	0	0
Net cash provided by operating activities
16,301	6,877	-395	1,290	2,496	6,181	-	0	0	0	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	1,159	-400	-3,719	1,292	3,373	10,378	0	0	0
Net cash provided by operating activities
-	-	-	-	-	-	-	-	-	-	-	-	-	19,035	18,878	21,571	17,693	14,265	11,446	5,745	0	0	0	-	0	0	0	-	-	-	-	-	-	-	-	-	-	-	-
Investing activities
Additions to property and equipment
6,623	6,160	6,047	6,180	5,786	5,689	-	5,552	5,342	5,124	-	4,896	5,455	5,960	6,339	6,353	6,550	6,835	6,905	7,780	7,064	6,352	6,149	5,556	5,938	6,546	7,260	8,325	8,981	9,596	10,407	10,155	11,016	12,456	12,986	14,303	0	0	0
Proceeds from sale of property and equipment
-	-	-	-	-	-	-	-	-	-	-	39	39	39	39	0	0	0	0	13	13	34	40	27	0	0	0	-	-	-	-	14	0	0	0	-	-	-	-
Cash paid for intangibles
-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	125	125	125	40	25	125	225	310	200	0	0	0	-	-	-	-	34	0	0	0	-	-	-	-
Proceeds from sale of marketable securities and investments
-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	3,171	0	0	0	-	-	-	-
Purchases of marketable securities and investments
-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	8	525	566	573	572	0	0	0
Changes in restricted cash
-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-319	0	0	0
Purchases of company-owned life insurance
-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	106	0	0	0	-	-	-	-	281	0	0	0
Net cash used in investing activities
-6,623	-6,160	-6,047	-6,179	-5,785	-5,688	-	0	0	0	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-8,598	-7,178	-8,049	-7,845	-9,177	-11,524	0	0	0
Net cash used in investing activities
-	-	-	-	-	-	-	-	-	-	-	-	-	-5,920	-6,299	-6,477	-6,675	-6,960	-6,945	-7,792	0	0	0	-	0	0	0	-	-	-	-	-	-	-	-	-	-	-	-
Financing activities
Borrowings from revolving loan payable
11,700	14,626	11,584	7,768	4,306	3,316	-	3,331	3,379	3,365	-	3,835	5,501	8,075	11,364	13,727	18,643	17,920	17,262	15,637	14,243	24,411	21,994	19,506	17,127	11,483	15,484	19,561	0	0	0	-	-	-	-	-	-	-	-
Payments made on revolving loan payable
11,700	14,626	11,584	7,768	4,306	3,316	-	3,331	3,379	3,365	-	3,835	5,500	8,074	14,363	25,485	26,935	25,906	23,748	14,900	16,820	16,425	13,258	15,258	14,556	14,751	26,858	29,008	0	0	0	-	-	-	-	-	-	-	-
Minority shareholder redemption
-	-	-	-	-	-	-	-	-	-	-	2,486	0	0	0	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
Payments of debt financing costs
-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	0	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
Payment of notes payable
0	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	6,125	0	0	0
Payments on capital leases
0	-	0	0	0	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
Payments of debt financing costs
-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	407	0	0	0	-	-	-	-
Proceeds from issuance of Series A convertible preferred stock
-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	6,017	0	0	0	-	-	-	-	-	-	-	-
Payment of issuance costs from common stock
-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	244	0	0	0	-	-	-	-	-	-	-	-
Payments on capital leases
-	-	-	-	-	598	-	588	576	569	-	561	556	552	582	587	590	620	513	438	359	235	235	232	242	264	225	198	159	131	140	137	126	138	157	144	0	0	0
Treasury stock repurchase
-	-	-	-	-	-	-	-	-	-	-	-	0	0	0	-	0	0	0	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
Statutory tax withholding payment for share-based compensation
99	302	290	289	322	430	-	430	430	1,351	-	1,644	1,644	1,644	687	969	969	969	970	438	438	438	438	0	0	0	0	-	-	-	-	-	-	-	-	-	-	-	-
Proceeds from exercise of stock options
0	-	-	-	-	-	-	-	-	-	-	258	432	610	814	908	766	630	248	134	132	117	234	295	426	379	234	183	0	0	0	-	-	-	-	-	-	-	-
Payment of liabilities related to financing activities
-	-	-	-	-	-100	-	-100	-100	-100	-	-100	-100	-100	-100	-100	-100	-100	-200	-100	0	0	0	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
Preferred stock dividends paid
-	80	121	161	161	161	-	160	120	130	-	209	169	230	181	61	0	0	0	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
Proceeds from exercise of stock options
-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	0	0	-	0	0	0
Other
-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-141	0	0	0
Net cash used in financing activities
-356	-465	-750	-1,048	-1,080	-1,283	-	0	0	0	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-72	-1,736	-2,326	-8,281	-4,263	-6,100	0	0	0
Net cash used in financing activities
-	-	-	-	-	-	-	-	-	-	-	-	-	-8,059	-9,879	-13,954	-9,246	-9,045	-7,921	-105	0	0	0	-	0	0	0	-	-	-	-	-	-	-	-	-	-	-	-
Effect of exchange rate changes on cash
-9	-10	0	-4	-18	-29	-	-6	-9	-11	-	-5	-35	-41	-44	-34	57	45	45	36	-42	-19	-3	11	48	41	47	41	-15	3	-26	9	19	-10	17	-14	0	0	0
Net change in cash and cash equivalents
9,313	242	0	0	0	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
Net change in cash and cash equivalents
-	-	-	-	-	-	-	-	-	2,024	-	-3,793	-832	5,015	2,656	1,106	1,829	-1,695	-3,375	-2,116	4,421	4,933	6,525	6,835	156	824	95	-212	23	-554	-7,537	-9,305	-14,075	-14,844	-10,050	-7,260	0	0	0
Supplemental disclosure of non-cash investing and financing activities:
Right-of-use operating asset acquired
0	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
Right-of-use financed asset acquired
0	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
Accrued asset purchases
478	720	1,464	1,153	1,146	1,008	-	913	799	903	-	831	356	721	589	744	856	652	857	708	1,333	1,505	1,273	1,232	689	208	101	736	487	1,233	1,380	1,803	2,259	1,330	1,307	1,286	0	0	0
Property acquired under capital lease
-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	211	211	1,431	1,699	1,588	0	0	0	-	-	-	-	-	-	-	-	-	-	-	-	49	0	0	0
Unrealized loss on investments
-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	26	32	62	65	60	0	0	0
Accrued intangible asset
-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	0	-	-	-	0	-	-	-	-	-	-	-	-	-	-	-	-
Supplemental disclosure of cash flow information:
Cash paid during the period for income taxes
-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	0	-17	0	6	9	0	0	0
Cash paid during the period for income taxes
-	-	-	-	-	-	-	-	-	-	-	-	0	0	0	-	0	0	0	-	0	0	0	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
Cash paid during the period for interest
1,899	1,896	1,762	1,571	1,594	1,606	-	0	0	0	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
Cash received during the period for income taxes
-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	0	-	-	-	-	-	-	-	-	-	-	-	-
Cash paid during the period for interest
-	-	-	-	-	-	-	-	-	-	-	-	-	1,224	1,099	1,077	1,084	1,119	1,157	1,145	1,171	1,151	1,077	1,029	1,000	985	1,027	884	830	569	389	495	539	781	748	1,099	0	0	0