Northwest Pipe Co. NWPX Cash Flow

Northwest pipe co. (NWPX)

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	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
26,301	27,902	16,034	33,088	24,428	20,312	18,006	-11,864	-8,246	-10,163	-2,171	626	-3,548	-9,263	-28,790	-31,033	-36,870	-29,388	-29,691	-23,155	-7,884	-17,887	-20,897	-24,902	-22,533	-923	20,593	22,973	21,016	16,244	13,201	13,089	14,462	12,660	0	0	0
Loss on discontinued operations
-	-	-	-	-	-	-	-	-	-1,771	0	0	0	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
Income (loss) from continuing operations
-	-	-	-	-	-	-	-	-	-8,392	0	0	0	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
Adjustments to reconcile net income to net cash provided by operating activities:
Depreciation and finance lease amortization
12,753	12,391	12,338	11,312	9,914	8,767	0	0	0	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
Depreciation and capital lease amortization
-	-	-	-	-	-	-	-	-	-	6,630	6,750	8,316	8,768	7,480	7,660	6,883	7,332	10,172	12,182	13,077	13,606	13,259	12,165	12,566	13,272	0	0	0	-	-	-	-	-	-	-	-
Amortization of intangible assets
613	322	437	534	539	550	503	475	486	495	505	513	520	523	505	505	505	523	541	545	551	540	0	0	0	-	-	-	-	-	-	-	-	50	0	0	0
Amortization of debt issuance costs
-	-	-	-	-	-	-	-	168	-	168	167	167	166	519	545	571	598	275	293	311	377	463	537	610	634	675	699	987	1,318	1,629	1,957	2,021	2,042	0	0	0
Equity in earnings of unconsolidated subsidiary
-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-394	0	0	0
Provision for doubtful accounts
-	-	-	-	-	-	-	-	464	638	0	0	0	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	0	0	-	0	0	0
Depreciation and amortization
-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	0	0	0	-	0	0	0
Provision for doubtful accounts
-	-	-	-	-	-	-	-	-	-	-	-	-	-	0	0	71	-	164	181	199	70	-328	-631	-1,326	-1,063	0	0	0	-	-	-	-	-	-	-	-
Deferred income taxes
0	-	-	-	0	-	-	-	249	341	-2,375	-5,106	-4,386	-4,750	-4,720	-5,180	-3,610	-3,560	-665	2,931	-766	2,894	-10,453	-7,908	-5,535	-7,994	-1,089	-3,965	-3,083	-4,120	5,439	5,864	4,189	5,908	0	0	0
Loss on sale of business
-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-13,497	0	0	0	-	-	-	-	-	-	-	-	-	-	-	-
Loss on disposal of property and equipment
-	-	-	-	-	-	-	-	-39	-	64	72	10	-19	0	0	0	-	-	-	-	-	-	-	-	-	-	-	-689	-998	-672	-119	-513	-397	0	0	0
Share-based compensation expense
0	-	-	-	0	-	-	-	1,010	1,200	1,432	1,722	1,902	1,809	1,743	1,423	1,271	1,743	2,219	2,894	3,242	2,946	2,960	2,953	2,888	3,060	3,016	3,065	2,995	3,048	3,141	2,287	1,822	1,461	0	0	0
Adjustments to contingent consideration
-	-	-	-	-	-	-	-	-	-	-588	-1,031	-1,610	-1,657	0	0	0	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
Unrealized (gain) loss on foreign currency forward contracts
-	-	-	-	-	-	-	-	-28	-	16	198	215	-170	-762	-775	-801	-295	0	0	0	-	-	-	-	195	0	0	0	-	-830	531	544	327	0	0	0
Other, net
-304	-566	0	0	0	-	-	-	-	-	-	-	-	-	-	-	-	-	-31	155	-20	-25	0	0	0	-	-	-	-	-	-	-	-	-	-	-	-
Changes in operating assets and liabilities, net of acquired assets and assumed liabilities:
Trade and other receivables
6,777	6,134	8,057	6,850	-3,880	-2,220	-1,188	-4,059	6,555	4,073	2,168	6,575	-1,152	-80	403	423	2,307	-15,717	-7,992	-15,378	-21,889	-7,984	-16,983	-11,238	-9,481	24,212	-6,873	-14,389	1,097	-28,298	-15,098	-21,568	-4,313	5,713	0	0	0
Contract assets, net
2,613	5,680	14,040	12,015	8,957	17,809	3,043	3,661	1,016	278	0	0	0	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
Insurance settlements
-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-2,625	0	0	0	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
Costs and estimated earnings in excess of billings on uncompleted contracts, net
-	-	-	-	-	-	-	-	-	-	-	-	-	-	3,911	-1,896	-13,453	-940	-16,457	4,766	24,978	-4,088	0	0	0	-	-	-	-	-	-	-	-	-	-	-	-
Costs and estimated earnings in excess of billings on uncompleted contracts, net
-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	0	-	-12,040	-3,918	-644	510	0	0	0
Inventories
-7,321	-8,649	-5,451	6,249	15,978	13,628	5,335	-3,450	-115	-1,543	-1,350	1,663	-7,647	-5,728	9,819	8,029	1,449	-9,934	-28,550	-14,674	-3,064	-6,039	-5,795	-23,584	-18,653	-8,261	-22,397	-5,676	9,772	5,582	39,323	46,151	8,362	29,794	0	0	0
Refundable income taxes
-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-1,285	4,113	229	-5,556	3,405	0	0	0	-	-	-	-	-	-	-	-	-15,099	0	0	0
Prepaid expenses and other assets
-4,333	-2,454	-4,286	-2,896	-2,560	-2,910	44	-130	-48	215	187	478	528	630	-392	-1,110	-2,084	-1,196	-551	-1,137	-153	-754	-129	449	82	-307	-3,083	-2,793	-5,266	-5,480	2,285	2,474	4,889	5,297	0	0	0
Accounts payable
909	-4,675	-12,036	583	5,373	6,592	10,014	-1,967	797	2,128	-1,197	2,746	69	1,048	-3,420	-7,328	-3,639	-8,199	-11,648	-2,108	-11,145	-5,273	1,054	-11,857	-8,777	1,374	-2,306	-994	8,585	-310	-3,025	10,519	-17,640	-8,920	0	0	0
Deferred revenue
-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	7,764	0	0	0	-	-	-	-
Accrued and other liabilities
-1,266	2,564	420	-220	-1,718	-2,373	-2,042	-2,261	-2,185	-4,792	-3,240	-4,353	-4,850	-2,456	3,008	2,123	3,127	3,694	1,408	3,892	2,571	-881	-5,160	-12,065	-17,892	-15,226	-27,058	-13,610	8,489	11,392	20,679	17,079	8,013	7,379	0	0	0
Net cash provided by (used in) operating activities from continuing operations
-	-	-	-	-	-	-	-	-	-5,793	-14,221	-5,495	-3,059	-1,793	0	0	0	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
Net cash used in operating activities from discontinued operations
-	-	-	-	-	-	-	-	-	-1,727	0	0	0	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
Net cash provided by operating activities
47,565	42,886	10,196	-1,724	-5,777	-18,400	-550	-3,993	-9,504	-7,520	0	0	0	-	-	-	-	-	-	0	0	-	29,870	40,135	56,384	20,089	43,676	33,253	30,645	44,490	24,972	41,495	32,319	12,275	0	0	0
Cash flows from investing activities:
Acquisition of business, net of cash acquired
0	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
Purchases of property and equipment
9,899	8,585	6,635	4,802	4,675	3,797	3,861	3,275	3,066	2,851	2,579	2,172	2,085	2,292	917	2,151	3,878	6,831	10,374	11,300	13,014	14,289	17,986	19,058	23,630	28,447	27,592	27,170	22,133	16,789	16,114	15,766	17,215	16,333	0	0	0
Proceeds from sale of business
-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	29,791	0	0	0	-	-	-	-	-	-	-	-	-	-	-	-
Proceeds from sale of property and equipment
-	39	0	0	0	-	-	-	-	146	159	156	58	33	0	0	0	-	-	-	-	-	-	-	-	1,711	1,713	1,793	2,737	1,072	1,054	960	29	96	0	0	0
Issuance of notes receivable
-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	1,000	0	0	0	-	-	-	-
Restricted cash
-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	0	-	-	-	-	-	-	-	-
Other investing activities
-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-123	25	0	0	0	-	-	-	-	-	-	-	-	-	-	-	-
Net cash used in investing activities from continuing operations
-	-	-	-	-	-32,364	-35,130	-3,270	-2,945	-2,705	0	0	0	-	-	0	0	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
Net cash provided by investing activities from discontinued operations
-	-	-	-	-	4,465	33,255	33,255	33,255	32,505	0	0	0	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
Net cash used in investing activities
-56,467	-6,423	1,197	-29,254	-29,525	-27,899	-1,875	29,985	30,310	29,800	0	0	0	-	-	-	-	-	-	0	0	-	-3,714	-6,061	-13,481	-48,251	-34,409	-30,807	-21,976	-19,297	-13,420	-12,933	-1,019	930	0	0	0
Cash flows from financing activities:
Borrowings on line of credit
0	-	-	-	0	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
Repayments on line of credit
0	-	-	-	0	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
Borrowings on long-term debt
0	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
Payments on finance lease obligations
430	434	571	420	411	398	0	0	0	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
Payments of debt issuance costs
0	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	1,599	0	0	0	-	-	-	-
Payments on long-term debt
-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	6,357	7,785	7,785	5,714	5,714	5,714	5,714	5,714	5,714	5,714	5,714	5,714	5,714	0	0	0
Borrowings on line of credit
-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	79,250	124,250	175,250	240,750	230,581	0	0	0	-	-	-	-	-	-	-	-	-	-	-	-
Repayments on line of credit
-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	124,837	164,347	208,122	241,119	272,913	0	0	0	-	-	-	-	-	-	-	-	-	-	-	-
Proceeds from issuance of common stock
-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	147	0	0	0
Tax withholdings related to net share settlements of restricted stock and performance share awards
0	-	-	-	-	1,301	1,301	1,301	1,301	24	0	0	0	-	-	-	32	424	423	423	423	1,283	1,283	1,283	1,283	802	802	869	869	212	241	174	175	80	0	0	0
Borrowings under note payable to financial institution
-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	0	0	0	-	132,300	115,800	107,933	132,050	0	0	0
Payments on note payable to financial institution
-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	0	0	0	-	136,011	136,619	131,580	138,050	0	0	0
Payments on capital lease obligations
-	-	-	-	-	-	-	-	-	-	357	273	283	279	-676	-620	1,079	1,270	2,380	2,572	1,003	1,255	3,776	4,328	4,932	5,239	3,281	3,317	3,362	3,373	3,396	3,395	3,324	3,256	0	0	0
Payments of contingent consideration
-	-	-	-	-	-	-	-	-	112	112	112	112	1,233	1,233	1,233	1,233	0	0	0	0	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
Other financing activities
-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	0	0	0	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
Net cash provided by (used in) financing activities from continuing operations
-	-	-	-	-	-	-	-	-	-	-	-	-	-1,543	0	0	0	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
Change in cash and cash equivalents
-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	0	0	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
Net cash provided by (used in) financing activities
14,715	-12,126	-1,196	-855	-846	9,330	-1,331	-1,633	-1,622	-463	0	0	0	-	-	-	-	-	-	0	0	-	-26,117	-34,193	-42,901	28,704	-9,262	-2,277	-8,710	-25,329	-11,596	-28,580	-31,289	-13,074	0	0	0
Change in cash and cash equivalents
5,813	24,337	10,197	-31,833	-36,148	-36,969	-3,756	24,359	19,184	21,817	0	0	0	-	-	-	-	9,782	563	613	67	-61	39	-119	2	542	5	169	-41	-136	-44	-18	11	131	0	0	0
Noncash investing and financing activities:
Escrow account related to capital lease financing
-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	0	0	-	-	-	-	-	-	-	-
Escrow account related to capital lease financing
-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	0	-	0	0	0
Accrued property and equipment purchases
825	719	707	1,359	507	336	242	99	219	184	-2	140	61	59	188	-203	49	397	1,377	1,021	595	1,243	645	1,043	-1,822	1,656	2,726	2,614	6,346	2,777	1,123	2,361	425	1,673	0	0	0
Right-of-use assets obtained in exchange for operating lease liabilities
-	1,335	0	0	0	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
Right-of-use assets obtained in exchange for finance lease liabilities
-	-	-	-	-	599	0	0	0	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
Capital lease additions
-	-	-	-	-	-	-	-	-	-	0	0	188	259	1,097	1,113	925	854	0	0	0	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-