Northwest Pipe Co. NWPX Cash Flow

Northwest pipe co. (NWPX)

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	Dec'13	Sep'13	Jun'13	Mar'13	Dec'12	Sep'12	Jun'12	Mar'12	Dec'11	Sep'11	Jun'11	Mar'11
Cash flows from operating activities:
Net income
564	12,016	10,747	2,974	2,165	148	27,801	-5,686	-1,951	-2,158	-2,069	-2,068	-3,868	5,834	728	-6,242	-9,583	-13,693	-1,515	-12,079	-2,101	-13,996	5,021	3,192	-12,104	-17,006	1,016	5,561	9,506	4,510	3,396	3,604	4,734	1,467	3,284	4,977	2,932
Loss on discontinued operations
-	-	-	-	-	-	-	-	-	-316	-482	-647	-326	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
Income (loss) from continuing operations
-	-	-	-	-	-	-	-	-	-1,842	-1,587	-1,421	-3,542	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
Adjustments to reconcile net income to net cash provided by operating activities:
Depreciation and finance lease amortization
3,031	3,176	3,502	3,044	2,669	3,123	2,476	1,646	1,522	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
Depreciation and capital lease amortization
-	-	-	-	-	-	-	-	-	-	1,713	1,232	1,729	1,956	1,833	2,798	2,181	668	2,013	2,021	2,630	3,508	4,023	2,916	3,159	3,161	2,929	3,317	3,865	-	-	-	-	-	-	-	-
Amortization of intangible assets
399	53	53	108	108	168	150	113	119	121	122	124	128	131	130	131	131	113	130	131	149	131	134	137	138	-	-	-	-	-	-	-	-	0	0	20	30
Amortization of debt issuance costs
-	-	-	-	-	-	-	-	42	-	42	42	42	42	41	42	41	395	67	68	68	72	85	86	134	158	159	159	158	199	183	447	489	510	511	511	510
Equity in earnings of unconsolidated subsidiary
-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	0	0	-281	-113
Provision for doubtful accounts
-	-	-	-	-	-	-	-	87	81	234	62	261	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-48	-404	-	876	-1,274	365
Depreciation and amortization
-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	4,207	4,172	3,287	-	3,656	3,856	3,191
Provision for doubtful accounts
-	-	-	-	-	-	-	-	-	-	-	-	-	-	91	-172	-8	-	-87	-30	-83	364	-70	-12	-212	-34	-373	-707	51	-	-	-	-	-	-	-	-
Deferred income taxes
712	-	-	-	-10	-	-	-	-330	1,541	-112	-850	-238	-1,175	-2,843	-130	-602	-1,145	-3,303	1,440	-552	1,750	293	-2,257	3,108	-11,597	2,838	116	649	-4,692	-38	998	-388	4,867	387	-677	1,331
Loss on sale of business
-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	0	-1,414	0	-12,083	-	-	-	-	-	-	-	-	-	-	-	-
Loss on disposal of property and equipment
-	-	-	-	-	-	-	-	-71	-	-32	82	19	-5	-24	20	-10	-	-	-	-	-	-	-	-	-	-	-	177	-543	-441	118	-132	-217	112	-276	-16
Share-based compensation expense
460	-	-	-	22	-	-	-	81	237	237	455	271	469	527	635	178	403	207	483	650	879	882	831	354	893	875	766	526	849	924	696	579	942	70	231	218
Adjustments to contingent consideration
-	-	-	-	-	-	-	-	-	-	0	0	27	-615	-443	-579	-20	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
Unrealized (gain) loss on foreign currency forward contracts
-	-	-	-	-	-	-	-	32	-	-46	-32	-30	124	136	-15	-415	-468	123	-41	91	-	-	-	-	2	-98	197	94	-	-267	83	-169	-477	1,094	96	-386
Other, net
232	-409	940	-1,067	-30	-	-	-	-	-	-	-	-	-	-	-	-	-	-34	48	-45	0	152	-127	-50	-	-	-	-	-	-	-	-	-	-	-	-
Changes in operating assets and liabilities, net of acquired assets and assumed liabilities:
Trade and other receivables
-5,213	1,871	7,582	2,537	-5,856	3,794	6,375	-8,193	-4,196	4,826	3,504	2,421	-6,678	2,921	7,911	-5,306	-5,606	3,404	7,931	-3,422	-23,630	11,129	545	-9,933	-9,725	2,130	6,290	-8,176	23,968	-28,955	-1,226	7,310	-5,427	-15,755	-7,696	24,565	4,599
Contract assets, net
-8,683	-1,693	9,243	3,746	-5,616	6,667	7,218	688	3,236	-8,099	7,836	-1,957	2,498	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
Insurance settlements
-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	0	0	0	-2,625	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
Costs and estimated earnings in excess of billings on uncompleted contracts, net
-	-	-	-	-	-	-	-	-	-	-	-	-	-	-5,049	9,327	-4,434	4,067	-10,856	-2,230	8,079	-11,450	10,367	17,982	-20,987	-	-	-	-	-	-	-	-	-	-	-	-
Costs and estimated earnings in excess of billings on uncompleted contracts, net
-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-390	-	-3,721	-5,065	-9,565	6,311	4,401	-1,791	-8,411
Inventories
3,068	3,367	-6,153	-7,603	1,740	6,565	5,547	2,126	-610	-1,728	-3,238	5,461	-2,038	-1,535	-225	-3,849	-119	14,012	-2,015	-10,429	-11,502	-4,604	11,861	1,181	-14,477	-4,360	-5,928	6,112	-4,085	-18,496	10,793	21,560	-8,275	15,245	17,621	-16,229	13,157
Refundable income taxes
-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-4,808	1,439	2,858	-774	590	-2,445	-2,927	8,187	-	-	-	-	-	-	-	-	0	0	-11,182	-3,917
Prepaid expenses and other assets
-2,179	53	-1,443	-764	-300	-1,779	-53	-428	-650	1,175	-227	-346	-387	1,147	64	-296	-285	125	-654	-1,270	603	770	-1,240	-286	2	1,395	-662	-653	-387	-1,381	-372	-3,126	-601	6,384	-183	-711	-193
Accounts payable
1,320	7,662	-4,446	-3,627	-4,264	301	8,173	1,163	-3,045	3,723	-3,808	3,927	-1,714	398	135	1,250	-735	-4,070	-3,773	4,939	-5,295	-7,519	5,767	-4,098	577	-1,192	-7,144	-1,018	10,728	-4,872	-5,832	8,561	1,833	-7,587	7,712	-19,598	10,553
Deferred revenue
-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-2,365	5,053	3,977	1,099	-	-	-	-
Accrued and other liabilities
-4,225	778	877	1,304	-395	-1,366	237	-194	-1,050	-1,035	18	-118	-3,657	517	-1,095	-615	-1,263	5,981	-1,980	389	-696	3,695	504	-932	-4,148	-584	-6,401	-6,759	-1,482	-12,416	7,047	15,340	1,421	-3,129	3,447	6,274	787
Net cash provided by (used in) operating activities from continuing operations
-	-	-	-	-	-	-	-	-	7,317	-10,938	-2,095	-77	-1,111	-2,212	341	1,189	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
Net cash used in operating activities from discontinued operations
-	-	-	-	-	-	-	-	-	-637	-358	-527	-205	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
Net cash provided by operating activities
15,036	21,520	4,067	6,942	10,357	-11,170	-7,853	2,889	-2,266	6,680	-11,296	-2,622	-282	-	-	-	-	-	-	17,192	24,573	-	-2,069	-6,904	40,139	-1,296	8,196	9,345	3,844	22,291	-2,227	6,737	17,689	2,773	14,296	-2,439	-2,355
Cash flows from investing activities:
Acquisition of business, net of cash acquired
48,728	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
Purchases of property and equipment
2,936	2,660	3,280	1,023	1,622	710	1,447	896	744	774	861	687	529	502	454	600	736	-873	1,688	2,327	3,689	2,670	2,614	4,041	4,964	6,367	3,686	8,613	9,781	5,512	3,264	3,576	4,437	4,837	2,916	5,025	3,555
Proceeds from sale of business
-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	0	-1,818	0	31,609	-	-	-	-	-	-	-	-	-	-	-	-
Proceeds from sale of property and equipment
-	24	13	0	2	-	-	-	-	0	3	118	25	13	0	20	0	-	-	-	-	-	-	-	-	16	15	11	1,669	18	95	955	4	0	1	24	71
Issuance of notes receivable
-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	0	0	0	1,000	-	-	-	-
Restricted cash
-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	0	-	-	-	-	-	-	-	-
Other investing activities
-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-161	0	0	38	-13	-	-	-	-	-	-	-	-	-	-	-	-
Net cash used in investing activities from continuing operations
-	-	-	-	-	1,992	-32,718	-894	-744	-774	-858	-569	-504	-	-	-580	-736	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
Net cash provided by investing activities from discontinued operations
-	-	-	-	-	3,715	0	0	750	32,505	0	0	0	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
Net cash used in investing activities
-51,664	-1,913	-2,267	-623	-1,620	5,707	-32,718	-894	6	31,731	-858	-569	-504	-	-	-	-	-	-	2,947	-3,528	-	-4,424	-4,032	26,658	-21,916	-6,771	-11,452	-8,112	-8,074	-3,169	-2,621	-5,433	-2,197	-2,682	9,293	-3,484
Cash flows from financing activities:
Borrowings on line of credit
41,377	-	-	-	12,003	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
Repayments on line of credit
41,377	-	-	-	23,467	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
Borrowings on long-term debt
15,879	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
Payments on finance lease obligations
103	109	110	108	107	246	-41	99	94	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
Payments of debt issuance costs
405	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	1,198	0	32	369	-	-	-	-
Payments on long-term debt
-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	0	0	3,571	2,786	1,428	0	1,500	2,786	1,428	0	1,500	2,786	1,428	0	1,500	2,786
Borrowings on line of credit
-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	1,500	21,500	22,250	34,000	46,500	72,500	87,750	23,831	-	-	-	-	-	-	-	-	-	-	-	-
Repayments on line of credit
-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	8,052	22,000	40,020	54,765	47,562	65,775	73,017	86,559	-	-	-	-	-	-	-	-	-	-	-	-
Proceeds from issuance of common stock
-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	1	56	54	36
Tax withholdings related to net share settlements of restricted stock and performance share awards
101	-	-	-	-	0	0	0	1,301	0	0	0	24	-	-	-	31	1	0	0	423	0	0	0	1,283	0	0	0	802	0	67	0	145	29	0	1	50
Borrowings under note payable to financial institution
-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	53,000	48,500	37,471	-	37,500	46,650	25,150	23,000	21,000	38,783	49,267
Payments on note payable to financial institution
-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	53,799	43,986	28,768	-	31,211	48,457	33,343	23,000	31,819	43,418	39,813
Payments on capital lease obligations
-	-	-	-	-	-	-	-	-	-	71	88	100	98	-13	98	96	-857	43	1,797	287	253	235	228	539	2,774	787	832	846	816	823	877	857	839	822	806	789
Payments of contingent consideration
-	-	-	-	-	-	-	-	-	0	0	0	112	0	0	0	1,233	0	0	0	0	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
Other financing activities
-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	0	0	19	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
Net cash provided by (used in) financing activities from continuing operations
-	-	-	-	-	-	-	-	-	-	-	-	-	-98	13	-98	-1,360	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
Change in cash and cash equivalents
-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-337	-907	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
Net cash provided by (used in) financing activities
15,270	-337	-110	-108	-11,571	10,593	231	-99	-1,395	-68	-71	-88	-236	-	-	-	-	-	-	-19,567	-21,456	-	6,490	10,962	-67,336	23,767	-1,586	2,254	4,269	-14,199	5,399	-4,179	-12,350	-466	-11,585	-6,888	5,865
Change in cash and cash equivalents
-21,358	19,270	1,690	6,211	-2,834	5,130	-40,340	1,896	-3,655	38,343	-12,225	-3,279	-1,022	-	-	-	-	9,674	-53	572	-411	455	-3	26	-539	555	-161	147	1	18	3	-63	-94	110	29	-34	26
Noncash investing and financing activities:
Escrow account related to capital lease financing
-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	0	898	-	-	-	-	-	-	-	-
Escrow account related to capital lease financing
-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	897	-	0	0	2,726
Accrued property and equipment purchases
445	204	-622	798	339	192	30	-54	168	98	-113	66	133	-88	29	-13	131	41	-362	239	479	1,021	-718	-187	1,127	423	-320	-3,052	4,605	1,493	-432	680	1,036	-161	806	-1,256	2,284
Right-of-use assets obtained in exchange for operating lease liabilities
-	97	0	732	506	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
Right-of-use assets obtained in exchange for finance lease liabilities
-	-	-	-	-	141	0	0	458	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
Capital lease additions
-	-	-	-	-	-	-	-	-	-	0	0	0	0	0	188	71	838	16	0	0	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-