← Filings of FAST

Tables in the 10-Q of FASTENAL CO

38 tables with numbers, filed Jul 15, 2016. Each one downloads as a CSV for Excel or Google Sheets, with the filing's address in the last row. Only the layout is tidied (a "$" or ")" in a cell of its own is joined to its number); no value is changed. Open the filing on sec.gov ↗

	Page No.
Part I Financial Information:
Condensed Consolidated Balance Sheets as of June 30, 2016 and December 31, 2015	1
Condensed Consolidated Statements of Earnings for the six months and three months ended June 30, 2016 and 2015	2
Condensed Consolidated Statements of Comprehensive Income for the six months and three months ended June 30, 2016 and 2015	3
Condensed Consolidated Statements of Cash Flows for the six months ended June 30, 2016 and 2015	4
Notes to Condensed Consolidated Financial Statements	5
Management’s Discussion and Analysis of Financial Condition and Results of Operations	9

	(Unaudited)
Assets	June 30, 2016	December 31, 2015
Current assets:
Cash and cash equivalents	$155,458		129,019
Trade accounts receivable, net of allowance for doubtful accounts of $11,123 and $11,729, respectively	537,341		468,375
Inventories	985,085		913,263
Prepaid income taxes	—		22,558
Other current assets	113,022		131,561

	(Unaudited)	(Unaudited)
	Six Months Ended June 30,	Three Months Ended June 30,
	2016	2015		2016	2015
Net sales	$2,000,967		1,951,144		$1,014,287	997,827
Cost of sales	1,007,915		965,007		512,695	495,740
Gross profit	993,052		986,137		501,592	502,087
Operating and administrative expenses	582,800		557,031		292,619	276,644
Gain on sale of property and equipment	(130)		(498)		(236)	(390)

	2016	2015
First quarter	$0.30		0.28
Second quarter	0.30		0.28
Third quarter	0.30		0.28
Fourth quarter			0.28
Total	$0.90		1.12

	OptionsGranted	OptionExercise(Strike)Price		ClosingStock Priceon Dateof Grant		June 30, 2016
Date of Grant			OptionsOutstanding		OptionsExercisable
April 19, 2016	845,440		$46.00			$45.74	819,466	—
April 21, 2015	893,220		$42.00			$41.26	775,020	—
April 22, 2014	955,000		$56.00			$50.53	642,500	10,000
April 16, 2013	205,000		$54.00			$49.25	115,000	2,500
April 17, 2012	1,235,000		$54.00			$49.01	1,015,250	617,500
April 19, 2011	410,000		$35.00			$31.78	200,800	163,300

Date of Grant	Risk-free Interest Rate	Expected Life of Option in Years		ExpectedDividendYield		ExpectedStockVolatility	Estimated FairValue of StockOption
April 19, 2016	1.3%		5.00		2.6%		26.34%	$8.18
April 21, 2015	1.3%		5.00		2.7%		26.84%	$7.35
April 22, 2014	1.8%		5.00		2.0%		28.55%	$9.57
April 16, 2013	0.7%		5.00		1.6%		37.42%	$12.66
April 17, 2012	0.9%		5.00		1.4%		39.25%	$13.69
April 19, 2011	2.1%		5.00		1.6%		39.33%	$11.20
April 20, 2010	2.6%		5.00		1.5%		39.10%	$8.14

	Six-month Period	Three-month Period
Reconciliation	2016	2015		2016	2015
Basic weighted average shares outstanding	288,863,482		293,191,566		288,918,945	291,176,985
Weighted shares assumed upon exercise of stock options	268,820		678,586		200,525	653,152
Diluted weighted average shares outstanding	289,132,302		293,870,152		289,119,470	291,830,137

	Six-month Period	Three-month Period
Summary of Anti-dilutive Options Excluded	2016	2015		2016	2015
Options to purchase shares of common stock	2,941,864		2,395,247		3,253,343	2,724,639
Weighted average exercise price of options	$50.39		$52.97		$49.91	$51.56

	June 30,2016	December 31,2015
Outstanding loans under unsecured revolving credit facility	$415,000		350,000
Note payable	15,000		15,000
Total debt	430,000		365,000
Less: Current portion of debt	(67,610)		(62,050)
Long-term debt	$362,390		302,950
Undrawn letters of credit under unsecured revolving credit facility - face amount	$36,267		36,266

					Change Since:
	Q2 2015	Q4 2015		Q2 2016	Q2 2015	Q4 2015
End of period total store employee count	13,203		13,961		13,499		2.2%	-3.3%
Change in total store employee count					296		-462
End of period total employee count	19,527		20,746		20,324		4.1%	-2.0%
Change in total employee count					797		-422
Industrial vending machines (installed device count)	50,620		55,510		58,346	(1)	15.3%	5.1%
Number of store locations	2,616		2,622		2,605		-0.4%	-0.6%

					Change Since:
	Q2 2015	Q4 2015		Q2 2016	Q2 2015	Q4 2015
Average full-time equivalent store employee count	10,887		11,436		11,545		6.0%	1.0%
Average full-time equivalent total employee count	16,107		16,901		17,241		7.0%	2.0%
Note – Full-time equivalent is based on 40 hours per week.

	Six-month Period	Three-month Period
	2016	2015		2016	2015
Net sales	$2,000,967		$1,951,144		$1,014,287	997,827
Percentage change	2.6%		6.8%		1.6%	5.0%
Business days	128		127		64	64
Daily sales	$15,633		15,363		$15,848	15,591
Percentage change	1.8%		6.8%		1.6%	5.0%
Impact of currency fluctuations (primarily Canada)	-0.6%		-1.0%		-0.4%	-1.0%

	Six-month Period	Three-month Period
	2016	2015		2016	2015
Store Age
Opened greater than 10 years	0.5%		6.0%		0.0%	4.6%
Opened greater than 5 years	0.2%		6.0%		0.0%	4.5%
Opened greater than 2 years	0.5%		6.1%		0.4%	4.4%

	Six-month period	Three-month Period
	2016	2015		2016	2015
Fastener product line	37.3%		38.8%		37.1%	38.7%
Other product lines	62.7%		61.2%		62.9%	61.3%
	100.0%		100.0%		100.0%	100.0%

	Jan.	Feb.		Mar.	Apr.	May		June	July	Aug.		Sept.	Oct.	Nov.		Dec.
2016	3.3%		2.6%		0.0%		3.8%		1.1%		0.0%
2015	12.0%		8.6%		5.6%		6.1%		5.3%		3.7%		3.2%		1.6%		-0.3%	-0.8%	-1.1%	-3.8%
2014	6.7%		7.7%		11.6%		10.0%		13.5%		12.7%		14.7%		15.0%		12.9%	14.6%	15.3%	17.4%

														Cumulative
														Change from
														Jan. to
	Jan. (1)	Feb.		Mar.	Apr.	May		June	July	Aug.		Sept.	Oct.	June		Oct.
Benchmark	0.8%		2.2%		3.8%		0.4%		3.1%		2.7%		-2.1%		2.5%		3.7%	-1.2%	12.6%	15.9%
2016	0.4%		-0.8%		1.5%		1.7%		0.6%		-0.2%							2.9%
16Delta	-0.4%		-3.0%		-2.3%		1.3%		-2.5%		-2.9%							-9.7%
2015	-3.6%		-0.1%		4.2%		-2.1%		3.4%		0.9%		-4.3%		4.1%		-0.9%	-2.0%	6.3%	2.9%

	Q1	Q2		Q3	Q4	Annual
2016	0.9%		0.7%
2015	6.9%		3.8%		1.1%		-2.2%	2.3%
2014	9.0%		11.2%		13.7%		13.8%	12.0%

	Q1	Q2		Q3	Q4	Annual
2016	-1.7%		-2.4%
2015	5.5%		0.0%		-4.4%		-6.2%	-1.4%
2014	1.6%		5.5%		9.9%		11.4%	6.9%

	Q1	Q2		Q3	Q4	Annual
2016	4.7%		4.7%
2015	11.7%		9.0%		5.9%		1.2%	6.8%
2014	14.2%		17.1%		17.6%		19.0%	17.2%

		Q1	Q2		Q3	Q4	Annual
Device count signed during the period	2016	4,647		4,869
	2015	3,962		5,144		4,689		4,016	17,811
	2014	4,025		4,137		4,072		4,108	16,342
'Machine equivalent' count signed during the period	2016	3,696		3,941
	2015	2,916		3,931		3,769		3,319	13,935
	2014	2,974		3,179		3,189		3,243	12,585

		Q1	Q2		Q3		Q4
Device count installed at the end of the period	2016	56,889		58,346		(1)
	2015	48,545		50,620			53,547	55,510
	2014	42,153		43,761			45,596	46,855
'Machine equivalent' count installed at the end of the	2016	43,329		44,707
period	2015	35,997		37,714			40,067	41,905
	2014	30,326		31,713			33,296	34,529

		Q1	Q2		Q3	Q4
Percent of total net sales to customers with	2016	44.5%		44.6%
industrial vending(1)	2015	40.5%		40.9%		42.1%	43.9%
	2014	37.8%		37.0%		37.8%	39.3%
Daily sales growth to customers with	2016	3.6%		2.7%
industrial vending(2)	2015	12.3%		8.6%		4.8%	0.7%
	2014	19.7%		20.9%		21.9%	20.0%

STATEMENT OF EARNINGS INFORMATION (percentage of net sales) for the periods ended June 30:
	Six-month Period	Three-month Period
	2016	2015		2016	2015
Net sales	100.0%		100.0%		100.0%	100.0%
Gross profit	49.6%		50.5%		49.5%	50.3%
Operating and administrative expenses	29.1%		28.6%		28.8%	27.7%
Gain on sale of property and equipment	0.0%		0.0%		0.0%	0.0%
Operating income	20.5%		22.0%		20.6%	22.6%

	Q1	Q2		Q3	Q4
2016	49.8%		49.5%
2015	50.8%		50.3%		50.5%	49.9%
2014	51.2%		50.8%		50.8%	50.5%

Tables in the 10-Q of FASTENAL CO

Table 1 after “INDEX”

Table 2 after “(Amounts in thousands except share and per share information)”

Table 3 after “(Amounts in thousands except earnings per share)”

Table 4 after “(Amounts in thousands)”

Table 5 after “(Amounts in thousands)”

Table 6 after “The following table presents the dividends either paid previously or declared by our board of directors for future payment on a per share ba”

Table 7 after “The following tables summarize the details of grants made under our stock option plan that are still outstanding, and the assumptions used t”

Table 8 after “(Unaudited)”

Table 9 after “The following tables present a reconciliation of the denominators used in the computation of basic and diluted earnings per share and a summ”

Table 10 after “The following tables present a reconciliation of the denominators used in the computation of basic and diluted earnings per share and a summ”

Table 11 after “Debt obligations and undrawn letters of credit outstanding at the end of each period were as follows:”

Table 12 after “The table below summarizes our store employee count and our total employee count at the end of the periods presented. This is intended to de”

Table 13 after “Regarding operating expenses, we added 797 people to the Fastenal organization in the last twelve months (about 37% of these people were add”

Table 14 after “Net sales and daily sales were as follows for the periods ended June 30:”

Table 15 after “The impact of the economy is best reflected in the growth performance of our stores opened greater than ten years ago (store sites opened as”

Table 16 after “The approximate mix of sales from the fastener product line and from the other product lines was as follows for the periods ended June 30:”

Table 17 after “During the months noted below, all of our selling locations, when combined, had daily sales growth rates of (compared to the same month in t”

Table 18 after “Our stores opened greater than two years (store sites opened as follows: 2016 group – opened 2014 and earlier, 2015 group – opened 2013 and ”

Table 19 after “months of 2016, is more cyclical due to the increased market share they enjoy in their local markets. During the months noted below, the sto”

Table 20 after “The table below shows the pattern to the sequential change in our daily sales. The line labeled 'Benchmark' is an historical average of our ”

Table 21 after “The sequential trends noted above were directly linked to fluctuations in our end markets. To place this in perspective – approximately 50% ”

Table 22 after “end markets):”

Table 23 after “end markets):”

Table 24 after “Our non-residential construction customers have historically represented 20% to 25% of our business. The daily sales growth rates to these c”

Table 25 after “The industrial vending information related to contracts signed during each period was as follows:”

Table 26 after “The industrial vending information related to installed machines at the end of each period was as follows:”

Table 27 after “The following table includes some additional statistics regarding our net sales and daily sales growth:”

Table 28 after “The second component, operating and administrative expenses, does just the opposite, it generally improves as a percentage of net sales. Thi”

Table 29 after “The gross profit percentage during each period was as follows:”

Table 30 after “(compared to the same period in the preceding year):”

Table 31 after “(compared to the same period in the preceding year):”

Table 32 after “The year-over-year comparison and the related dollar and percentage changes related to accounts receivable, net and inventories were as foll”

Table 33 after “Operating cash flow as a percentage of net earnings were as follows in 2016 and 2015:”

Table 34 after “Our dividends (on a per share basis) were as follows in 2016 and 2015:”

Table 35 after “Cash flow activity in dollars and as a percentage of net earnings was as follows for the periods ended June 30:”

Table 36 after “:”

Table 37 after “ITEM 6 — EXHIBITS”

Table 38 after “INDEX TO EXHIBITS”

	June 30:	Twelve-month Dollar Change		Twelve-month Percentage Change
	2016	2015		2014	2016	2015		2016	2015
Accounts receivable, net	$537,341		537,650		502,330		$-309		35,320	-0.1%	7.0%
Inventories	985,085		876,697		818,771		108,388		57,926	12.4%	7.1%
Operational working capital(1)	$1,522,426		1,414,347		1,321,101		$108,079		93,246	7.6%	7.1%
Sales in last two months	$682,741		663,356		634,790		$19,385		28,566	2.9%	4.5%

	(a)	(b)	(c)	(d)
Period	Total Number ofSharesPurchased	Average PricePaid per Share	Total Number ofShares Purchasedas Part of PubliclyAnnounced Plansor Programs (1)	Maximum Number (orApproximate DollarValue) of Shares thatMay Yet Be PurchasedUnder the Plans orPrograms (1)
April 1-30, 2016		0			$0.00	0	1,300,000
May 1-31, 2016		0			$0.00	0	1,300,000
June 1-30, 2016		0			$0.00	0	1,300,000
Total		0			$0.00	0	1,300,000

3.1	Restated Articles of Incorporation of Fastenal Company, as amended (incorporated by reference to Exhibit 3.1 to Fastenal Company’s Form 10-Q for the quarter ended March 31, 2012)
3.2	Restated By-Laws of Fastenal Company (incorporated by reference to Exhibit 3.2 to Fastenal Company’s Form 8-K dated as of October 15, 2010 (file no. 000-16125))
31	Certifications under Section 302 of the Sarbanes-Oxley Act of 2002
32	Certification under Section 906 of the Sarbanes-Oxley Act of 2002
101	The following financial statements from Fastenal Company’s Quarterly Report on Form 10-Q for the quarter ended June 30, 2016, filed on July 15, 2016, formatted in XBRL (Extensible Business Reporting Language): (i) Condensed Consolidated Balance Sheets, (ii) Condensed Consolidated Statements of Earnings, (iii) Condensed Consolidated Statements of Comprehensive Income, (iv) Condensed Consolidated Statements of Cash Flows, and (v) the Notes to Condensed Consolidated Financial Statements.

3.1	Restated Articles of Incorporation of Fastenal Company, as amended	Incorporated by reference
3.2	Restated By-Laws of Fastenal Company	Incorporated by reference
31	Certifications under Section 302 of the Sarbanes-Oxley Act of 2002	Electronically Filed
32	Certification under Section 906 of the Sarbanes-Oxley Act of 2002	Electronically Filed
101.INS	XBRL Instance Document	Electronically Filed
101.SCH	XBRL Taxonomy Extension Schema Document	Electronically Filed
101.CAL	XBRL Taxonomy Calculation Linkbase Document	Electronically Filed
101.DEF	XBRL Taxonomy Definition Linkbase Document	Electronically Filed