← Filings of FAST

Tables in the 10-Q of FASTENAL CO

39 tables with numbers, filed Jul 18, 2023. 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
PART I	FINANCIAL INFORMATION
ITEM 1.	FINANCIAL STATEMENTS
	Condensed Consolidated Balance Sheets	1
	Condensed Consolidated Statements of Earnings	2
	Condensed Consolidated Statements of Comprehensive Income	3
	Condensed Consolidated Statements of Stockholders' Equity	4
	Condensed Consolidated Statements of Cash Flows	5

	(Unaudited)
Assets	June 30, 2023	December 31, 2022
Current assets:
Cash and cash equivalents	$243.6		230.1
Trade accounts receivable, net of allowance for credit losses of $6.5 and $8.3, respectively	1,171.6		1,013.2
Inventories	1,565.4		1,708.0
Prepaid income taxes	14.7		8.1
Other current assets	141.7		165.4

	(Unaudited)	(Unaudited)
	Six Months Ended June 30,	Three Months Ended June 30,
	2023	2022		2023	2022
Net sales	$3,742.2		3,482.6		$1,883.1	1,778.6
Cost of sales	2,034.7		1,861.7		1,025.6	951.0
Gross profit	1,707.5		1,620.9		857.5	827.6
Operating and administrative expenses	919.4		879.5		462.6	444.2
Operating income	788.1		741.4		394.9	383.4

	Six-month Period	Three-month Period
	2023	2022		2023	2022
United States	$3,130.4		2,928.4		$1,571.7	1,496.7
% of revenues	83.6%		84.1%		83.5%	84.2%
Canada and Mexico	498.8		438.4		254.9	225.0
% of revenues	13.3%		12.6%		13.5%	12.7%
North America	3,629.2		3,366.8		1,826.6	1,721.7
% of revenues	96.9%		96.7%		97.0%	96.9%

		Six-month Period	Three-month Period
Type	Introduced	2023	2022		2023	2022
Fasteners (1)	1967	33.1%		34.4%		32.6%	34.6%
Tools	1993	8.5%		8.2%		8.5%	8.2%
Cutting tools	1996	5.4%		5.0%		5.5%	5.0%
Hydraulics & pneumatics	1996	6.7%		6.6%		6.8%	6.7%
Material handling	1996	5.6%		5.7%		5.6%	5.7%
Janitorial supplies	1996	8.2%		7.9%		8.3%	8.0%

	2023	2022
First quarter	$0.35		$0.31
Second quarter	0.35		0.31
Third quarter	0.35		0.31
Fourth quarter		0.31
Total	$1.05		$1.24

	Options Granted	Option Exercise Price		Closing Stock Price on Date of Grant		June 30, 2023
Date of Grant			Options Outstanding		Options Exercisable
January 3, 2023	1,071,943		$48.00			$47.400	1,046,851	70,562
January 3, 2022	713,438		$62.00			$61.980	656,520	53,355
January 4, 2021	741,510		$48.00			$47.650	637,416	234,203
January 2, 2020	902,263		$38.00			$37.230	727,427	370,152
January 2, 2019	1,316,924		$26.00			$25.705	862,003	534,009
January 2, 2018	1,087,936		$27.50			$27.270	636,123	506,029

Date of Grant	Risk-free Interest Rate	Expected Life of Option in Years		Expected Dividend Yield		Expected Stock Volatility	Estimated Fair Value of Stock Option
January 3, 2023	4.0%		5.00		2.6%		29.58%	$11.62
January 3, 2022	1.3%		5.00		1.7%		28.52%	$13.68
January 4, 2021	0.4%		5.00		2.0%		29.17%	$9.57
January 2, 2020	1.7%		5.00		2.4%		25.70%	$6.81
January 2, 2019	2.5%		5.00		2.9%		23.96%	$4.40
January 2, 2018	2.2%		5.00		2.3%		23.45%	$5.02
January 3, 2017	1.9%		5.00		2.6%		24.49%	$4.20

	Six-month Period	Three-month Period
Reconciliation	2023	2022		2023	2022
Basic weighted average shares outstanding	571,033,444		575,510,253		571,138,039	575,462,097
Weighted shares assumed upon exercise of stock options	1,724,032		1,998,786		1,752,121	1,940,124
Diluted weighted average shares outstanding	572,757,476		577,509,039		572,890,160	577,402,221

	Six-month Period	Three-month Period
Summary of Anti-dilutive Options Excluded	2023	2022		2023	2022
Options to purchase shares of common stock	2,244,555		1,350,936		1,866,320	1,354,464
Weighted average exercise prices of options	$52.17		55.20		$52.96	55.22

	(Unaudited)	(Unaudited)
	Six Months Ended June 30,	Three Months Ended June 30,
	2023	2022		2023	2022
Net earnings	$593.1		556.7		$298.0	287.1
Other comprehensive income (loss), net of tax:
Foreign currency translation adjustments (net of tax of $0.0 in 2023 and 2022)	7.9		(23.7)		3.6	(26.0)
Comprehensive income	$601.0		533.0		$301.6	261.1

	(Unaudited)	(Unaudited)
	Six Months Ended June 30,	Three Months Ended June 30,
	2023	2022		2023	2022
Common stock
Balance at beginning of period	$5.7		5.8		$5.7	5.8
Balance at end of period	5.7		5.8		5.7	5.8
Additional paid-in capital
Balance at beginning of period	3.6		96.2		11.4	101.6

	(Unaudited)	(Unaudited)
	Six Months Ended June 30,	Three Months Ended June 30,
	2023	2022		2023	2022
Cash flows from operating activities:
Net earnings	$593.1		556.7		$298.0	287.1
Adjustments to reconcile net earnings to net cash provided by operating activities:
Depreciation of property and equipment	84.0		82.4		42.2	41.2
(Gain) loss on sale of property and equipment	(1.2)		2.3		(0.6)	(1.2)

	Six-month Period	Three-month Period
	2023	2022		2023	2022
Manufacturing	74.7%		71.5%		74.8%	71.8%
Non-residential construction	9.2%		10.5%		9.2%	10.7%
Other	16.1%		18.0%		16.0%	17.5%
	100.0%		100.0%		100.0%	100.0%

	Average Interest Rate at June 30, 2023			Debt Outstanding
		Maturity Date	June 30, 2023		December 31, 2022
Unsecured revolving credit facility	6.10%		September 28, 2027		$90.0	225.0
Senior unsecured promissory notes payable, Series C	3.22%		March 1, 2024		60.0	60.0
Senior unsecured promissory notes payable, Series D	2.66%		May 15, 2025		75.0	75.0
Senior unsecured promissory notes payable, Series E	2.72%		May 15, 2027		50.0	50.0
Senior unsecured promissory notes payable, Series F	1.69%		June 24, 2023		—	70.0
Senior unsecured promissory notes payable, Series G	2.13%		June 24, 2026		25.0	25.0

			Change Since:		Change Since:		Change Since:
	Q2 2023	Q1 2023	Q1 2023	Q4 2022	Q4 2022	Q2 2022	Q2 2022
In-market locations - absolute employee headcount	13,668		13,668	0.0%		13,410		1.9%	13,134	4.1%
In-market locations - FTE employee headcount	12,380		12,219	1.3%		12,017		3.0%	12,039	2.8%
Total absolute employee headcount	22,913		22,820	0.4%		22,386		2.4%	21,629	5.9%
Total FTE employee headcount	20,631		20,262	1.8%		19,854		3.9%	19,523	5.7%
Number of branch locations	1,635		1,660	-1.5%		1,683		-2.9%	1,737	-5.9%
Number of active Onsite locations	1,728		1,674	3.2%		1,623		6.5%	1,501	15.1%

	DSR Change Three-month Period		% of Sales Three-month Period
	2023	2022		2023	2022
Fasteners	0.0%	21.2%			32.6%		34.6%
Safety supplies	7.9%		13.8%			20.7%		20.3%
Other	9.8%		17.0%			46.7%		45.1%

	Approximate Percentage of Total Operating and Administrative Expenses	Three-month Period
	2023
Employee-related expenses	70% to 75%	2.5%
Occupancy-related expenses	15% to 20%	9.5%
All other operating and administrative expenses	10% to 15%	7.3%

	June 30	Twelve-month Dollar Change	Twelve-month Percentage Change
	2023		2022		2023	2023
Accounts receivable, net	$1,171.6			1,103.9		$67.7	6.1%
Inventories	1,565.4			1,665.2		(99.8)	-6.0%
Trade working capital	$2,737.0			2,769.1		$(32.1)	-1.2%
Accounts payable	$262.0			291.8		$(29.9)	-10.2%
Trade working capital, net	$2,475.0			2,477.3		$(2.2)	-0.1%
Net sales in last three months	$1,883.1			1,778.6		$104.6	5.9%

	DSR ChangeSix-month Period		% of SalesSix-month Period
	2023	2022		2023	2022
Fasteners	3.4%		22.8%			33.1%	34.4%
Safety supplies	6.8%		14.5%			20.5%	20.7%
Other	11.1%		15.9%			46.4%	44.9%

	(a)	(b)	(c)	(d)
Period	Total Number of Shares Purchased	Average Price Paid 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, 2023		0			$0.00	0	6,200,000
May 1-31, 2023		0			$0.00	0	6,200,000
June 1-30, 2023		0			$0.00	0	6,200,000
Total		0			$0.00	0	6,200,000

Exhibit Number	Description of Document
3.1	Restated Articles of Incorporation of Fastenal Company, as amended (incorporated by reference to Exhibit 3.1 to Fastenal Company's Form 8-K dated as of April 22, 2019)
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 January 17, 2019)
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 the Quarterly Report on Form 10-Q for the quarter ended June 30, 2023, formatted in Inline XBRL: (i) Condensed Consolidated Balance Sheets, (ii) Condensed Consolidated Statements of Earnings, (iii) Condensed Consolidated Statements of Comprehensive Income, (iv) Condensed Consolidated Statements of Stockholders’ Equity, (v) Condensed Consolidated Statements of Cash Flows, and (vi) Notes to Condensed Consolidated Financial Statements.
104	The cover page from the Quarterly Report on Form 10-Q for the quarter ended June 30, 2023, formatted in Inline XBRL.

Tables in the 10-Q of FASTENAL CO

Table 1 after “INDEX”

Table 2 after “(Amounts in millions except share information)”

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

Table 4 after “(Amounts in millions)”

Table 5 after “(Amounts in millions except per share information)”

Table 6 after “(Amounts in millions)”

Table 7 after “Our revenues related to the following geographic areas were as follows for the periods ended June 30:”

Table 8 after “The percentages of our sales by end market were as follows for the periods ended June 30:”

Table 9 after “The percentages of our sales by product line were as follows for the periods ended June 30:”

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

Table 11 after “The following tables summarize the details of options granted under our stock option plans that were outstanding as of June 30, 2023, and th”

Table 12 after “The following tables summarize the details of options granted under our stock option plans that were outstanding as of June 30, 2023, and th”

Table 13 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 14 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 15 after “Debt obligations and letters of credit outstanding at the end of each period consisted of the following:”

Table 16 after “.”

Table 17 after “The table below summarizes our absolute and full time equivalent (FTE; based on 40 hours per week) employee headcount, our investments relat”

Table 18 after “The table below summarizes the number of branches opened and closed, net of conversions, as well as the number of Onsites activated and clos”

Table 19 after “The following table sets forth condensed consolidated statement of earnings information (as a percentage of net sales) for the periods ended”

Table 20 after “The table below sets forth net sales and daily sales for the periods ended June 30, and changes in such sales from the prior period to the m”

Table 21 after “From a product standpoint, we have three categories: fasteners, safety supplies, and other product lines, the latter of which includes eight”

Table 22 after “Our end markets consist of manufacturing, non-residential construction, and other, the latter of which includes resellers, government/educat”

Table 23 after “We report our customers in two categories: national accounts, which are customers with a multi-site contract, and non-national accounts, whi”

Table 24 after “The table below summarizes the signings and installations of, and sales through, our FMI devices.”

Table 25 after “related, occupancy-related, and all other operating and administrative expenses compared to the same periods in the preceding year, is outli”

Table 26 after “the percentage change compared to the end of the prior periods:”

Table 27 after “Cash flow activity was as follows for the periods ended June 30:”

Table 28 after “The dollar and percentage change in accounts receivable, net, inventories, and accounts payable as of June 30, 2023 when compared to June 30”

Table 29 after “The following table sets forth condensed consolidated statement of earnings information (as a percentage of net sales) for the periods ended”

Table 30 after “The table below sets forth net sales and daily sales for the periods ended June 30, and changes in such sales from the prior period to the m”

Table 31 after “From a product standpoint, we have three categories: fasteners, safety supplies, and other product lines, the latter of which includes eight”

Table 32 after “Our end markets consist of manufacturing, non-residential construction, and other, the latter of which includes resellers, government/educat”

Table 33 after “We report our customers in two categories: national accounts, which are customers with a multi-site contract, and non-national accounts, whi”

Table 34 after “The table below summarizes the signings and installations of, and sales through, our FMI devices.”

Table 35 after “related, occupancy-related, and all other operating and administrative expenses compared to the same periods in the preceding year, is outli”

Table 36 after “The table below summarizes our FTE headcount at the end of the periods presented and the percentage change compared to the end of the prior ”

Table 37 after “Cash flow activity was as follows for the periods ended June 30:”

Table 38 after “The table below sets forth information regarding purchases of our common stock during the second quarter of 2023:”

Table 39 after “INDEX TO EXHIBITS”