TRIMBLE INC. TRMB Cash Flow

Trimble inc. (TRMB)

CashFlow / Quarterly

Apr'20	Jan'20	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	Jan'16	Sep'15	Jun'15	Mar'15	Jan'15	Sep'14	Jun'14	Mar'14	Jan'14	Sep'13	Jun'13	Mar'13	Dec'12	Sep'12	Jun'12	Mar'12	Dec'11	Sep'11	Jun'11	Mar'11	Dec'10	Sep'10	Jun'10	Mar'10
Cash flow from operating activities:
Net income
61,900	279,400	78,100	94,600	62,400	86,800	73,700	64,100	58,700	-35,800	57,200	47,300	49,800	37,700	39,200	35,600	19,700	23,900	37,000	25,800	34,000	55,900	11,800	78,100	68,100	59,695	54,620	54,953	48,932	32,679	53,800	53,165	50,072	28,663	27,196	54,178	38,872	35,848	32,842	6,771	28,152
Adjustments to reconcile net income to net cash provided by operating activities:
Depreciation expense
9,800	9,700	9,400	10,100	10,200	9,400	9,000	8,700	8,500	8,200	8,700	8,800	8,900	9,100	9,100	9,700	9,100	9,700	9,100	9,200	8,700	9,000	8,500	8,100	7,500	7,070	6,776	6,661	6,193	6,781	5,610	5,738	5,562	5,826	5,508	4,572	4,603	4,888	4,574	4,285	4,451
Amortization expense
40,400	39,200	40,800	43,500	44,300	46,700	49,800	42,600	40,500	39,700	40,000	35,800	33,300	33,600	37,300	39,600	40,300	40,200	40,700	40,800	40,700	40,700	39,400	37,800	40,600	42,087	41,618	39,763	39,332	36,392	31,440	29,078	28,797	29,155	24,106	16,576	16,065	15,474	14,432	13,916	13,817
Provision for doubtful accounts
-	-	-	-	-	-	-	-	-	-	-	-	-	500	100	1,800	600	200	500	200	1,000	900	2,000	400	500	696	943	196	65	602	-58	899	587	959	314	281	359	-702	426	1,558	1,038
Deferred income taxes
4,800	-224,600	-300	3,600	1,100	-20,200	-10,400	-6,200	-10,800	-	-	-	-	-800	700	600	-100	1,400	300	500	-1,300	-500	500	-200	-1,500	-1,480	212	-1,923	-11,809	-2,015	265	235	146	-16,130	-6,036	-2,746	-1,393	-11,091	634	-4,564	103
Stock-based compensation
10,700	22,900	18,600	17,200	16,300	23,800	18,800	16,900	17,400	19,800	16,100	15,200	13,700	12,600	13,300	13,000	13,700	12,800	12,800	12,000	12,500	11,300	11,000	11,000	10,100	10,342	8,905	8,435	8,818	9,032	7,684	8,155	7,789	7,418	7,106	7,129	6,798	6,960	5,540	4,984	5,641
Income from equity method investments, net of dividends
5,600	-1,700	-2,000	6,700	4,800	-2,100	-1,300	1,400	100	1,500	900	6,300	2,700	3,700	5,200	5,800	2,900	3,800	4,700	6,400	3,000	900	2,800	5,200	3,500	4,792	4,494	7,157	4,257	5,019	6,453	7,063	6,192	4,348	4,820	3,418	2,763	2,770	14,646	-3,147	-2,474
Gain on an equity sale
-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	0	0	0	15,100	0	0	0	0	-	-	-	-	-	-	-	-	-	-	-	-
Divestitures gain, net
-	-	-	-	-	-	-	-	-	-	-	-	-	3,600	-2,800	-400	3,100	-1,900	200	-200	5,800	3,100	-1,700	-2,600	-1,700	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
Excess tax benefit for stock-based compensation
-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	500	200	700	0	600	3,300	10,200	4,697	1,187	2,832	4,784	8,672	1,419	7,674	7,580	3,064	748	2,593	8,357	7,668	559	930	482
Provision for excess and obsolete inventories
-	-	-	-	-	-	-	-	-	-	-	-	-	3,800	3,200	4,700	4,100	7,200	3,100	1,200	800	1,300	1,800	600	1,100	1,649	982	-15	584	-138	1,379	1,882	3,111	1,495	2,184	2,242	2,489	1,179	400	1,271	1,902
Other, net
-14,900	-1,200	-4,600	2,100	-1,800	-6,900	-6,200	-19,300	11,100	-11,800	-3,200	-200	9,700	600	-900	-2,300	-700	-1,000	1,000	1,000	-11,000	-5,300	-5,600	3,900	2,300	1,438	-1,232	598	-104	1,202	1,168	874	977	331	-707	-2,608	577	5,063	-296	-1,574	-1,760
(Increase) decrease in assets:
Accounts receivable, net
-47,900	112,800	-24,500	-6,100	13,800	35,200	9,800	-23,400	29,400	8,800	4,000	-4,100	34,000	-11,100	-8,300	4,100	14,100	12,000	-11,000	-30,200	28,900	-1,800	-29,900	-19,300	61,900	-24,366	4,395	-37,885	61,956	-15,108	907	-7,836	46,425	-11,243	12,467	-9,974	40,624	-9,654	1,632	-16,148	31,546
Other receivables
-	-	-	-	-	-	-	-	-	-	-	-	-	-4,100	1,200	-700	2,200	-2,000	-2,800	1,200	-4,900	-2,400	1,000	2,000	1,700	1,747	-5,605	6,585	-5,027	-2,979	1,358	8,849	-2,211	-16,670	-7,483	-212	-5,776	-2,327	7,456	413	-8,060
Inventories
20,400	23,000	5,700	-14,200	6,800	16,000	7,200	100	21,700	19,000	16,300	-400	2,400	1,700	-14,500	-8,100	-3,100	-3,500	-5,400	5,400	6,400	4,600	5,900	7,900	13,400	14,045	-17,370	-5,493	20,218	3,752	5,244	5,334	-5,928	18,795	-4,756	7,383	8,717	13,000	12,802	10,306	9,441
Other current and non-current assets
-16,800	-600	-8,900	4,600	-6,100	13,500	-1,200	4,200	1,100	-1,100	7,000	5,000	4,700	-9,900	3,300	2,900	4,900	-1,900	1,200	300	8,000	-5,800	4,900	5,800	2,200	-10,965	10,600	1,298	10,867	5,101	-6,060	932	7,972	-3,514	-5,527	3,449	-4,927	-1,891	637	-3,106	2,103
Increase (decrease) in liabilities:
Accounts payable
-12,800	900	9,800	400	3,400	-11,200	-400	-1,500	11,100	-2,000	5,800	18,400	3,500	8,200	-3,700	-5,500	11,900	500	-13,000	-5,100	11,200	-400	-7,300	-10,000	10,500	6,667	-3,531	-12,855	-6,081	18,157	3,680	-57	4,205	-6,349	-6,737	-7,601	16,377	-2,219	-1,519	-10,004	27,319
Accrued compensation and benefits
-12,600	5,900	-23,800	28,500	-57,000	32,400	-7,200	35,000	-41,600	26,300	-6,400	28,900	-14,800	13,400	-15,000	15,700	-13,500	15,300	-14,600	14,200	-15,000	9,800	-14,900	17,100	-11,500	6,838	4,428	4,871	-12,037	1,514	4,105	4,165	-1,895	4,390	3,532	4,788	-10,241	148	7,638	3,401	4,741
Deferred revenue
15,600	114,800	-31,500	-12,200	77,100	22,500	-17,300	1,500	69,600	-8,400	-26,800	1,200	53,300	-6,700	-21,000	-300	54,100	-10,500	-10,900	100	49,400	4,000	-7,100	1,900	47,100	-17,491	-9,103	4,030	51,964	4,170	-19,727	2,548	29,569	11,137	-950	9,807	-1,219	-3,159	1,306	-4,792	5,468
Accrued warranty expense
-	-	-	-	-	-	-	-	-	-	-	-	-	-600	200	0	-700	-600	0	100	-1,500	400	1,600	700	400	353	501	-593	439	971	-677	-1,086	-728	242	489	-47	-40	-	-	-	-
Other current and non-current liabilities
-15,700	6,300	1,900	-14,700	7,300	-32,600	9,300	-13,200	-7,100	91,800	-400	400	9,800	16,400	11,200	-32,400	-1,400	15,000	-4,200	-18,100	3,600	-42,500	26,600	-8,100	19,100	9,754	-3,517	6,224	7,939	1,577	11,788	5,604	1,450	8,377	-6,045	-1,187	4,438	1,493	-2,429	-24,297	2,617
Net cash provided by operating activities
155,700	122,200	137,300	177,900	147,600	101,900	117,000	184,900	82,900	107,100	69,200	149,400	104,000	126,600	91,400	81,200	114,400	80,600	72,400	96,800	107,200	96,600	95,900	131,200	83,400	136,192	106,365	134,655	37,388	96,806	88,800	87,436	67,658	79,808	51,105	82,789	27,927	36,998	-8,277	39,806	55,503
Cash flow from investing activities:
Acquisitions of businesses, net of cash acquired
198,000	-	-	-	-	22,100	1,208,500	14,200	518,700	1,200	154,100	46,400	78,500	16,500	2,300	4,200	15,800	54,600	42,600	22,200	36,900	137,000	145,800	14,100	11,000	58,399	21,448	113,761	65,192	372,630	17,808	236,284	101,392	1,494	666,794	52,470	38,979	45,662	57,152	12,034	21,571
Proceeds from Previous Acquisition
-	-	-	-300	4,900	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
Acquisitions of property and equipment
16,700	14,400	16,100	24,000	14,500	14,500	17,100	17,800	18,200	17,300	10,800	9,900	5,700	6,300	7,500	7,300	4,900	8,200	9,200	15,900	10,600	12,300	6,600	14,800	13,600	13,254	18,215	24,504	14,927	19,945	12,818	13,664	7,644	7,276	6,680	5,286	4,036	5,971	6,132	5,731	5,299
Purchases of equity method investments
-	-	-	-	-	-	-	-	-	-	-	-	-	0	0	1,100	400	1,900	800	1,500	1,300	0	8,300	2,600	0	-	-	-	-	-	-	-	0	-	-	-	-	2,500	2,000	942	2,750
Purchases of short-term investments
-	-	-	-	-	-	0	0	24,000	-	82,400	78,600	59,000	-	62,100	0	0	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
Proceeds from maturities of short-term investments
-	-	-	-	-	0	0	0	6,200	37,500	27,800	32,400	24,400	2,400	0	0	0	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
Proceeds from sales of short-term investments
-	-	-	-	-	0	0	0	196,800	5,600	1,500	86,700	3,900	0	0	0	0	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
Acquisitions of intangible assets
-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	755	-	1,100	316	250	1,438	328	0	297
Dividends received from equity method investments
-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	11,038	1,919	40	181	-	-	-	-	-	-	-	-
Net proceeds from sales of businesses
-	-	-	-	-	-	-	-	-	-	-	-	-	-	0	2,600	8,100	-	-500	0	12,600	-	0	0	0	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
Dividends received from equity method investments
-	-	-	-	-	-	-	-	-	-	-	-	-	-	5,800	5,700	5,000	-	7,600	7,700	0	-	3,400	10,100	12,400	-	5,146	1,242	1,284	-	-	-	-	-	-	-	-	-	-	-	-
Other, net
-300	0	-400	-14,100	0	200	2,400	-700	-4,400	-400	-200	-700	-19,600	-700	-400	0	300	-900	100	400	-800	-2,000	4,400	-1,900	2,000	3,339	2,391	1,700	-2,430	-6,383	-214	776	-70	2,780	-456	668	-44	-6	-32	-66	-1
Net cash used in investing activities
-214,400	-206,600	-48,900	-10,200	-9,600	-36,800	-1,228,000	-31,300	-353,500	-43,000	-217,800	-15,100	-95,300	-65,800	-66,000	-4,300	-8,300	-59,000	-45,700	-32,300	-35,400	-141,600	-168,700	-19,500	-14,200	-68,392	-41,280	-138,723	-76,405	-376,324	-28,493	-249,929	-109,540	-1,719	-677,385	-51,240	-43,221	-47,237	-48,429	-30,792	-29,916
Cash flow from financing activities:
Issuance of common stock, net of tax withholdings
12,700	700	15,000	-12,200	25,600	-12,100	30,600	-3,600	25,300	800	23,200	10,200	39,600	17,500	25,000	8,900	16,100	600	13,100	1,300	14,700	2,500	14,300	6,800	32,500	10,033	13,713	9,517	14,437	22,045	9,980	480	26,682	5,687	9,519	2,878	27,785	12,663	14,018	9,218	8,649
Repurchases of common stock
50,000	0	120,800	19,000	40,000	40,000	0	0	53,000	173,800	91,100	6,200	14,200	17,300	13,900	76,100	12,200	0	161,400	60,400	12,600	32,800	65,000	0	0	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
Excess tax benefit for stock-based compensation
-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	500	200	700	0	600	3,300	10,200	4,697	1,187	2,832	4,784	8,672	1,419	7,674	7,580	722,527	748	2,593	8,357	7,668	559	930	482
Proceeds from debt and revolving credit lines
657,500	377,400	287,800	263,300	266,900	281,600	1,167,000	936,800	591,000	269,000	177,000	88,000	252,000	64,000	89,000	110,000	92,000	97,000	238,000	90,000	130,000	834,200	25,000	0	17,000	75,679	92,408	126,613	113,000	720,796	42,056	255,000	181,500	-	-	-	-	-	-	-	-
Payments on debt and revolving credit lines
520,200	289,300	277,000	416,900	339,700	322,900	445,100	774,100	383,000	51,100	94,200	124,000	226,100	114,000	144,300	60,000	147,000	124,100	119,000	114,100	198,000	746,800	33,800	8,700	110,800	126,414	188,106	148,799	103,981	456,415	97,049	181,163	122,850	104,747	48,111	177,159	672	31	373	40	54
Other, net
-400	-4,200	-2,900	-200	-7,100	-200	-7,100	-1,800	0	-5,300	-2,700	-4,300	-300	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
Net cash provided by (used in) financing activities
99,600	84,600	-97,900	-185,000	-94,300	-93,600	745,400	157,300	180,300	39,600	12,200	-36,300	51,000	-49,800	-44,200	-17,200	-51,100	-27,900	-28,800	-83,000	-65,200	57,100	-58,900	1,400	-51,100	-36,005	-80,798	-9,837	28,240	295,098	-43,594	81,991	92,912	-63,996	520,156	-27,463	35,470	20,300	861	-50,402	9,077
Effect of exchange rate changes on cash and cash equivalents
-13,300	4,400	-5,500	200	500	-4,400	0	-14,400	6,300	-200	6,500	6,100	5,000	-8,400	400	-2,500	3,700	-1,300	-3,300	1,800	-8,900	-3,600	-7,700	600	-100	119	1,898	-575	-3,442	351	3,190	-6,707	3,495	2,273	-5,432	1,383	3,378	-329	5,241	-4,025	-1,439
Net increase in cash and cash equivalents
27,600	4,600	-15,000	-17,100	44,200	-32,900	-365,600	296,500	-84,000	103,500	-129,900	104,100	64,700	2,600	-18,400	57,200	58,700	-7,600	-5,400	-16,700	-2,300	8,500	-139,400	113,700	18,000	31,914	-13,815	-14,480	-14,219	15,931	19,903	-87,209	54,525	16,366	-111,556	5,469	23,554	9,732	-50,604	-45,413	33,225
Consolidated operating income
-	-	-	-	-	-	-	-	-	-	-	-	54,700	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-