FASTENAL CO FAST Cash Flow

Fastenal co (FAST)

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	Dec'10	Sep'10	Jun'10	Mar'10	Dec'09	Sep'09	Jun'09	Mar'09
Cash flows from operating activities:
Net Income (Loss) Attributable to Parent
202,600	178,700	213,500	204,600	194,100	168,800	197,600	211,200	174,300	152,400	143,100	148,900	134,200	114,800	126,900	131,500	126,200	111,943	136,494	140,357	127,606	118,391	133,314	130,514	111,931	99,229	119,350	121,009	109,048	98,716	109,320	112,306	100,194	87,471	96,799	94,112	79,547	65,161	74,994	69,167	56,034	44,536	47,589	43,538	48,694
Adjustments to reconcile net earnings to net cash provided by operating activities, net of acquisition:
Depreciation of property and equipment
37,600	36,800	36,300	36,100	35,400	34,800	33,800	33,100	32,400	31,300	31,500	30,900	29,900	29,000	26,600	24,600	23,300	25,600	21,205	19,883	19,412	18,669	18,286	17,909	17,281	16,558	16,243	15,817	15,152	14,306	13,441	13,297	12,415	11,672	11,078	10,882	10,481	10,256	10,028	10,117	10,287	9,873	9,784	10,063	10,300
Gain on sale of property and equipment
400	400	0	500	300	0	300	600	-400	-100	100	600	400	200	200	200	-100	741	161	390	108	242	310	196	216	75	112	243	213	137	158	282	-174	-11	101	-259	-25	68	3	-39	-67	-60	-38	-424	-328
Bad debt expense
1,900	600	1,800	1,100	2,000	3,000	2,400	1,400	1,300	2,000	2,200	1,800	2,200	2,000	2,700	1,800	2,100	2,032	1,962	1,923	2,883	3,051	3,008	2,625	2,796	2,334	2,751	2,291	2,045	2,486	2,449	2,462	2,329	2,626	2,333	1,991	2,267	2,654	2,634	1,746	1,624	2,109	2,611	2,122	2,567
Deferred income taxes
500	12,800	-100	1,700	600	9,700	4,700	7,300	12,100	-32,300	1,500	400	400	22,900	400	500	1,800	5,478	295	2,111	416	346	314	744	356	7,610	739	-599	379	10,625	663	2,291	1,863	14,613	930	260	-56	3,580	47	-2,031	6	9,203	-40	-3,064	0
Share-based Payment Arrangement, Noncash Expense
1,600	1,400	1,400	1,300	1,600	1,300	1,300	1,100	1,400	1,200	1,200	1,600	1,200	1,200	1,200	700	1,000	1,159	1,200	1,821	1,620	2,419	1,620	1,620	1,380	1,350	1,350	1,350	1,350	1,350	1,350	1,050	1,050	1,125	1,125	900	900	1,015	1,015	1,000	1,000	1,000	950	1,000	900
Excess tax benefits from stock-based compensation
-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	482	823	451	169	437	938	550	105	589	1,139	954	1,192	854	8,103	0	-	-	-	-	-	-	-	-	-	-	-	-
Amortization of intangible assets
1,000	1,100	1,000	1,000	1,000	1,100	1,000	1,000	1,000	1,000	1,000	1,000	800	100	100	200	100	105	132	131	132	132	132	131	132	131	132	132	26	148	148	149	148	148	148	149	148	17	16	17	17	17	16	17	17
Changes in operating assets and liabilities, net of acquisition:
Trade accounts receivable
101,400	-77,600	1,600	26,900	79,500	-51,700	40,000	49,600	82,400	-22,500	18,200	38,000	70,000	-39,900	9,800	6,200	64,400	-67,820	4,868	17,487	66,065	-52,945	22,943	31,774	61,646	-36,987	19,951	20,010	48,619	-36,388	13,489	15,573	50,617	-19,855	6,213	33,501	57,819	-28,934	23,532	20,106	49,918	-19,679	-13,677	13,709	-1,715
Inventories
-10,600	7,500	12,600	50,800	13,500	88,400	29,900	33,800	41,200	45,100	-900	33,500	-1,400	29,900	-17,100	21,000	47,100	23,177	12,008	7,464	5,151	35,311	17,608	24,784	9,919	28,083	30,878	24,623	-14,899	39,555	13,139	14,803	1,734	28,003	9,492	32,206	19,082	11,306	23,849	14,971	-1,162	-126,566	21,013	54,092	-8,964
Other current assets
-33,200	20,200	13,400	6,900	-30,100	20,600	18,300	8,400	-18,400	400	17,700	5,700	-8,200	-17,500	6,900	-5,000	-13,500	13,816	10,480	9,644	-18,140	-11,836	16,325	10,052	-7,031	-12,759	14,871	21,993	-13,478	-2,773	11,543	14,294	-15,536	5,446	11,489	11,116	-8,757	13,436	7,270	6,526	-2,655	-34,685	1,445	34,093	-18,600
Accounts payable
19,300	-22,400	11,400	19,900	-9,700	7,600	13,900	24,000	600	400	5,900	12,400	17,600	-9,000	-40,900	200	32,500	-7,470	-1,493	1,238	28,325	-8,825	3,091	11,791	6,444	-13,878	15,378	14,426	-2,692	-6,863	3,639	5,130	2,334	-13,060	3,719	14,601	8,045	-13,131	2,170	5,657	12,288	-10,247	8,774	249	-12,948
Accrued expenses
-24,000	10,200	15,300	-6,800	-8,000	13,200	23,200	4,700	5,700	-4,700	18,300	16,900	7,100	-32,400	12,300	-2,700	-5,800	-9,689	12,394	13,454	-5,059	-8,301	15,518	18,056	-10	-3,868	13,157	13,199	-64	2,976	3,900	6,183	1,134	3,394	8,140	7,950	-3,934	1,187	9,437	11,060	8,709	-6,198	682	-2,012	-9,998
Income taxes
56,200	-16,300	3,600	-45,700	50,700	-6,800	-4,200	-40,100	35,600	-100	-5,300	-53,600	78,400	-24,300	3,500	-47,600	83,900	-18,075	-3,489	-64,231	59,195	-570	3,268	-40,972	72,679	-26,758	-4,514	-43,443	60,001	-14,131	-1,188	-28,918	44,941	-21,385	2,616	-27,673	43,220	-3,014	-628	-12,862	33,460	-16,832	3,223	-24,941	26,394
Other
-2,400	0	-700	0	-400	-2,600	600	-600	-100	-1,000	1,700	-400	600	-1,400	-400	-200	700	-5,390	-130	-170	790	-12,079	10,915	-4,957	4,391	3,344	-3,223	2,553	3,592	694	-4,126	2,652	-2,421	-1,287	6,689	-385	-1,785	-2,346	-1,365	-1,808	1,637	-10,249	3,224	-712	1,999
Net cash provided by operating activities
241,100	252,400	257,300	128,100	204,900	178,000	184,600	151,900	159,700	129,300	162,600	82,900	210,400	133,000	133,400	87,000	166,500	148,315	140,831	81,049	180,105	166,450	110,013	79,631	143,298	100,847	101,408	53,621	160,244	107,196	98,665	58,243	132,188	74,308	92,904	26,993	74,284	74,195	46,766	40,499	79,028	52,886	85,632	74,018	93,534
Cash flows from investing activities:
Purchases of property and equipment
48,800	62,100	61,200	68,700	54,400	79,200	36,500	29,100	31,500	37,200	25,300	36,200	21,200	27,500	73,300	59,000	29,700	35,738	31,442	44,098	43,922	45,927	45,987	64,996	32,564	60,981	52,998	37,048	55,513	50,083	37,343	22,768	28,212	27,564	36,155	35,118	21,206	30,954	10,432	24,073	8,138	12,410	7,490	13,605	19,033
Proceeds from sale of property and equipment
2,100	1,600	1,500	1,900	1,600	1,200	1,500	4,100	2,700	1,200	1,600	2,500	2,100	1,900	1,600	2,100	900	3,204	2,584	2,449	1,663	1,665	1,434	1,666	1,054	699	1,387	1,637	1,267	3,422	-223	340	985	668	1,251	1,014	621	1,195	1,024	1,555	685	599	578	1,713	1,973
Cash paid for acquisition
125,000	-	-	-	0	-	-	-	-	0	0	800	57,900	0	0	0	0	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
Net decrease in marketable securities
-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	0	-453	0	2	10	4	20	63	-26,874	62	-28	29	962	-40	-4,513	-463	1,412	146	11	-988	23,792	5,125	5	19
Other
0	100	-200	100	-100	-3,000	6,300	0	100	5,100	4,800	100	-1,900	4,900	0	100	100	11,718	62	-3	23	-21	-46	91	-22	66	116	-40	3	11	35	30	57	89	-179	98	-220	10,511	-171	-55	44	83	52	29	-63
Net cash used in investing activities
-171,700	-60,600	-59,500	-66,900	-52,700	-75,000	-45,000	-25,000	-28,900	-41,100	-28,500	-34,600	-75,100	-30,500	-71,700	-57,000	-28,900	-67,752	-28,920	-41,646	-42,282	-49,816	-44,054	-63,421	-31,490	-60,358	-51,731	-35,391	-54,312	-19,798	-37,663	-22,430	-27,313	-27,947	-34,685	-29,689	-19,902	-41,682	-9,383	-22,474	-6,509	-40,718	-12,089	-11,926	-17,016
Cash flows from financing activities:
Proceeds from debt obligations
325,000	165,000	220,000	315,000	210,000	340,000	225,000	235,000	180,000	210,000	255,000	310,000	240,000	190,000	325,000	255,000	180,000	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
Payments against debt obligations
215,000	265,000	275,000	285,000	240,000	230,000	260,000	215,000	190,000	230,000	255,000	230,000	265,000	240,000	310,000	195,000	175,000	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
Borrowings under credit facility
-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	615,000	175,000	-	160,000	240,000	140,000	160,000	70,000	10,000	20,000	0	0	0	0	-	-	-	-	-	-	-	-	-	-	-	-
Payments against credit facility
-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	410,000	140,000	-	125,000	170,000	140,000	160,000	70,000	10,000	20,000	0	0	0	0	-	-	-	-	-	-	-	-	-	-	-	-
Proceeds from exercise of stock options
7,400	15,500	2,900	22,000	18,100	2,100	5,700	1,800	3,800	6,000	200	400	2,900	4,300	2,600	1,900	20,500	9,811	2,378	4,831	2,080	661	1,893	3,502	1,641	267	1,921	4,297	2,821	5,859	3,584	1,916	18,285	1,233	2,353	5,353	0	-	-	-	-	-	-	-	-
Excess tax benefits from stock-based compensation
-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	482	823	451	169	437	938	550	105	589	1,139	954	1,192	854	406	7,697	182	801	0	0	-	-	-	-	-	-	-	-
Purchases of common stock
52,000	0	0	0	0	-	-	-	-	-	-	-	-	0	0	0	59,500	19,410	23,065	168,560	81,865	26,245	17,850	0	8,847	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
Payments of dividends
143,600	126,300	126,200	123,100	123,000	114,400	114,800	106,300	106,400	92,000	92,000	92,500	92,600	86,700	86,700	86,700	86,500	81,117	81,247	81,890	82,846	74,035	74,193	74,160	74,193	74,237	74,219	59,338	29,662	210,496	56,281	50,332	50,197	41,327	38,367	38,332	73,715	61,921	61,921	0	58,972	0	54,957	0	51,986
Net cash used in financing activities
-78,200	-210,800	-178,300	-71,100	-134,900	-64,900	-144,100	-124,900	-112,600	-106,000	-117,700	-68,800	-114,700	-132,400	-69,100	-24,800	-120,500	-57,472	-116,452	-39,796	-127,180	-114,450	-54,713	280	-80,849	-73,865	-80,789	-53,902	-25,887	-203,445	-51,843	-48,010	-24,215	-39,912	-35,213	-32,979	-73,715	-61,921	-61,921	0	-58,972	-41,104	-54,957	0	-51,986
Effect of exchange rate changes on cash and cash equivalents
-5,400	2,700	-3,300	-500	900	-600	-1,300	-3,600	2,000	1,300	1,900	1,300	1,000	-4,400	-1,000	-400	4,500	-5,770	-4,850	769	-4,349	-4,017	-857	429	-444	-308	449	-715	-416	55	528	-765	542	179	-1,367	236	488	536	711	-455	423	44	1,491	1,708	-557
Net (decrease) increase in cash and cash equivalents
-14,200	-16,300	16,200	-10,400	18,200	37,500	-5,800	-1,600	20,200	-16,500	18,300	-19,200	21,600	-34,300	-8,400	4,800	21,600	17,321	-9,391	376	6,294	-1,833	10,389	16,919	30,515	-33,684	-30,663	-36,387	79,629	-115,992	9,687	-12,962	81,202	6,628	21,639	-35,439	-18,845	-28,872	-23,827	17,570	13,970	-28,892	20,077	63,800	23,975
Supplemental information:
Cash paid for interest
2,200	2,600	3,500	3,800	4,000	3,700	3,000	3,200	2,700	2,600	2,600	2,000	1,500	1,800	1,500	1,500	1,400	1,004	941	797	358	324	271	250	70	52	24	3	34	0	0	0	0	-	-	-	-	-	-	-	-	-	-	-	-
Net cash paid for income taxes
10,200	60,100	60,300	110,600	11,700	57,300	61,200	87,200	9,600	80,300	86,700	139,300	-2,200	67,100	70,300	123,100	-12,200	78,527	85,582	146,599	16,292	82,061	76,105	105,564	-6,216	78,207	71,692	114,214	6,502	84,191	70,356	91,982	21,828	60,256	55,775	83,483	6,100	41,417	46,289	57,851	1,169	36,461	26,190	51,805	3,579
Leased assets obtained in exchange for new operating lease liabilities
25,000	-	-	-	21,800	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-