tickdelta
Sign in

Tickdelta is free for now. Sign up and get Pro free

← Filings of FAST

Tables in the 10-K of FASTENAL CO

94 tables with numbers, filed Feb 6, 2024. 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 ↗

Table 1 after “TABLE OF CONTENTS”

Download CSV
Page
PART I
Item 1.Business2
Item 1A.Risk Factors15
Item 1B.Unresolved Staff Comments22
Item 1C.Cybersecurity23
Item 2.Properties25
Item 3.Legal Proceedings26

First 8 of 29 rows. The CSV has all of them.

Table 2 after “The following table shows, as of the end of each of the last 10 fiscal years, our consolidated net sales; the number of branch, Onsite, and ”

Download CSV
2023202220212020201920182017201620152014
Net sales$7,346.76,980.66,010.95,647.35,333.74,965.14,390.53,962.03,869.23,733.5
Branch locations1,5971,6831,7932,0032,1142,2272,3832,5032,6222,637
Branch revenue (1)$4,073.64,161.63,726.23,587.13,660.13,625.83,399.63,198.13,281.83,225.3
Average monthly sales per branch location (2)$207.0199.5163.6145.2140.5131.1116.0104.0104.0101.0
Onsite locations1,8221,6231,4161,2651,114894605401264214
Onsite revenue (1)$2,926.72,465.51,898.01,485.61,391.71,081.7770.2569.2454.3387.7
Average monthly sales per Onsite location (2)$141.6135.2118.0104.1115.5120.3127.6142.7158.4157.6

First 8 of 10 rows. The CSV has all of them.

Table 3 after “The following table shows, as of the end of each of the last 10 fiscal years, our consolidated net sales; the number of branch, Onsite, and ”

Download CSV
(1)Revenues attributable to our traditional and international branch locations (both of which are defined below), and our Onsite locations, respectively.
(2)Average sales per month considers the average active base of branches and Onsites, respectively, in the given year, factoring in the beginning and ending location count, divided by total revenues attributable to our branch and Onsite locations, respectively, further divided by 12 months. This information is presented in thousands.
(3)This portion of revenue is generated outside our traditional in-market locations, examples of which include revenues arising from our custom in-house manufacturing, industrial services, and other non-traditional sources of revenue. In 2020, this included the effects of COVID-19, one response to which was substantial sales of pandemic-related products that were direct-shipped (versus sold through in-market locations) as a means of delivering critical supplies more quickly.
(4)'In-market locations' is defined as the sum of the total number of branch locations and the total number of Onsite locations.

Table 4 after “The following table provides a summary of the branches and Onsite locations we operated at the end of each year, as well as the openings, cl”

Download CSV
North AmericaOutside North America
United States (1)CanadaMexicoSubtotalCentral & South America (2)Asia (3)Europe (4)SubtotalTotal
In-Market Locations - 12/31/21 (5)2,6682621523,0822037701273,209
Starting Branches1,484173631,72052048731,793
Opened Branches—145—25712
Closed/Converted Branches (6)(115)(5)(1)(121)——(1)(1)(122)
Ending Branches1,369169661,60452252791,683
Starting Onsites1,18489891,362151722541,416

First 8 of 21 rows. The CSV has all of them.

Table 5 after “The following table provides a summary of the branches and Onsite locations we operated at the end of each year, as well as the openings, cl”

Download CSV
(1)Includes the United States, the Dominican Republic, Guam, and Puerto Rico.
(2)Includes Panama, Brazil, and Chile.
(3)Includes Singapore, China, Malaysia, and Thailand.
(4)Includes the Netherlands, Hungary, the United Kingdom, Germany, the Czech Republic, Italy, Romania, Sweden, Poland, Austria, Switzerland, Ireland, Spain, France, and Belgium.
(5)Beginning in 2022, the United States includes the Dominican Republic, Guam, and Puerto Rico which were previously grouped with other geographical regions. Prior period figures in the above table may differ slightly from those previously disclosed due to this minor change in reporting.
(6)The net impact of non-in-market locations or Onsite locations converted to branches, branches converted to Onsite locations or non-in-market locations, and closures of branches or Onsite locations.

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

Download CSV
Twelve-month Period
20232022Change
Weighted FASTBin/FASTVend signings (MEUs)24,12620,73516.4%
Signings per day9582
Weighted FASTBin/FASTVend installations (MEUs; end of period)113,138102,15110.8%
FASTStock sales$927.6832.011.5%
% of sales12.5%11.8%
FASTBin/FASTVend sales$2,070.21,755.317.9%

First 8 of 12 rows. The CSV has all of them.

Table 7 after “their selling focus to 'key accounts', which is defined as any customer account with purchase activity of at least $2,000 per month. Key acc”

Download CSV
2023202220212020201920182017
Active Accounts105,448119,583130,020137,380152,491156,069156,464
Key Accounts39,26639,15136,19033,79434,62132,89530,040

Table 8 after “At the end of 2023, we employed 23,201 full- and part-time employees. Of these, approximately 71% held a selling role. We characterize these”

Download CSV
2023% of Total2022% of Total
Selling personnel (1)16,51271.2%15,89871.0%
Distribution/Transportation personnel4,04217.4%3,97417.8%
Manufacturing personnel7333.2%7333.3%
Organizational support personnel (2)1,9148.2%1,7818.0%
Total personnel23,201100.0%22,386100.0%

Table 9 after “At the end of 2023, we employed 23,201 full- and part-time employees. Of these, approximately 71% held a selling role. We characterize these”

Download CSV
(1)Of our Selling Personnel, 80%-85% are attached to a specific in-market location.
(2)Organizational support personnel consists of: (1) Sales & Growth Driver Support personnel (approximately 35% of category), which includes sourcing, purchasing, supply chain, product development, etc.; (2) Information Technology personnel (35% to 40% of category); and (3) Administrative Support personnel (25% to 30% of category), which includes human resources, Fastenal School of Business, accounting and finance, senior management, etc.

Table 10 after “We own, and in some cases, lease, the following facilities, excluding selling locations:”

Download CSV
LocationPurposeLeasedTote Locations (ASRS)(1)Approximate Square Feet
Winona, MinnesotaDistribution center and home office246,000331,000
Indianapolis, IndianaDistribution center547,000(2)1,078,000
Akron, OhioDistribution center103,000188,000
Scranton, PennsylvaniaDistribution center104,000187,000
Denton, TexasDistribution center(3)41,000(4)263,000
Atlanta, GeorgiaDistribution center77,000252,000
Seattle, WashingtonDistribution center140,000238,000

First 8 of 19 rows. The CSV has all of them.

Table 11 after “We own, and in some cases, lease, the following facilities, excluding selling locations:”

Download CSV
(1)Total number of tote locations for small parts storage included in facilities with an ASRS.
(2)This property contains an ASRS with capacity of 52,000 pallet locations, in addition to the 547,000 tote locations for small parts.
(3)As of May 2023, we no longer lease space for distribution-related activities. In 2024, an additional ASRS will go live at this property.
(4)This facility contains an ASRS with capacity of 14,000 pallet locations, in addition to the 41,000 tote locations for small parts.
(5)During 2021, we acquired land for future expansion of our distribution center in Magna, Utah, and, as of November 2023, earthwork is underway. This building is expected to be complete in June of 2025 and will be approximately 290,000 square feet.
(6)In December 2018, we purchased an additional distribution center in High Point, North Carolina with approximately 750,000 total square feet. Approximately 395,000 square feet will be leased by the building's previous owner until December 2024. We currently utilize approximately 355,000 square feet for distribution activities.

Table 12 after “We also own, and in some cases, lease, the following support facilities, excluding selling locations:”

Download CSV
LocationPurposeLeasedApproximate Square Feet
Winona, MinnesotaManufacturing facility121,000
Indianapolis, IndianaManufacturing facility198,000
Houston, TexasManufacturing facility122,000
Wallingford, ConnecticutManufacturing facility177,000
Rockford, IllinoisManufacturing facility101,000
Johor, MalaysiaManufacturing facility30,000
Brno-Lisen, Czech RepublicManufacturing facilityX20,000

First 8 of 11 rows. The CSV has all of them.

Table 13 after “The table below sets forth information regarding purchases of our common stock during each of the last three months of 2023:”

Download CSV
(a)(b)(c)(d)
PeriodTotal Number of Shares PurchasedAverage Price Paid per ShareTotal Number ofShares Purchasedas Part of PubliclyAnnounced Plansor Programs (1)Maximum Number (orApproximate DollarValue) of Shares that May Yet Be Purchased Under the Plans or Programs (1)
October 1-31, 20230$0.0006,200,000
November 1-30, 20230$0.0006,200,000
December 1-31, 20230$0.0006,200,000
Total0$0.0006,200,000

Table 14 after “Comparison of Five-Year Cumulative Total Return Among Fastenal Company, the S&P 500 Index, and the Dow Jones US Industrial Suppliers Index”

Download CSV
201820192020202120222023
Fastenal Company$100.00145.04198.08265.50200.88283.77
S&P 500 Index100.00131.49155.68200.37164.08207.21
Dow Jones US Industrial Suppliers Index100.00132.23167.18223.37193.89287.68

Table 15 after “The following table presents a performance summary of our results of operations for the periods ended December 31:”

Download CSV
20232022YOY Change2021YOY Change
Net sales$7,346.76,980.65.2%$6,010.916.1%
Business days253254253
Daily sales$29.027.55.7%$23.815.7%
Gross profit$3,354.53,215.84.3%$2,777.215.8%
% of net sales45.7%46.1%46.2%
Operating and administrative expenses$1,825.81,762.23.6%$1,559.813.0%
% of net sales24.9%25.2%26.0%

First 8 of 15 rows. The CSV has all of them.

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

Download CSV
Q4 2023Q4 2022Twelve-month % Change
Selling personnel - absolute employee headcount16,51215,8983.9%
Selling personnel - FTE employee headcount15,07014,4764.1%
Total personnel - absolute employee headcount23,20122,3863.6%
Total personnel - FTE employee headcount20,72119,8544.4%
Number of branch locations1,5971,683-5.1%
Number of active Onsite locations1,8221,62312.3%
Number of in-market locations3,4193,3063.4%

First 8 of 9 rows. The CSV has all of them.

Table 17 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”

Download CSV
Twelve-month Period
20232022
Branch openings1012
Branch closures, net of conversions(96)(122)
Onsite activations329306
Onsite closures, net of conversions(130)(99)

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

Download CSV
20232022
Net sales100.0%100.0%
Gross profit45.7%46.1%
Operating and administrative expenses24.9%25.2%
Operating income20.8%20.8%
Net interest expense-0.1%-0.2%
Earnings before income taxes20.7%20.6%
Note – Amounts may not foot due to rounding difference.

Table 19 after “The table below sets forth net sales and daily sales for the periods ended December 31, and changes in such sales from the prior period to t”

Download CSV
20232022
Net sales$7,346.76,980.6
Percentage change5.2%16.1%
Business days253254
Daily sales$29.027.5
Percentage change5.7%15.7%
Daily sales impact of currency fluctuations-0.3%-0.5%

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

Download CSV
20232022
Fasteners32.4%34.0%
Safety supplies21.2%20.8%
Other product lines46.4%45.2%

Table 21 after “During the months noted below, all of our selling locations, when combined, had a DSR change of (compared to the same month in the preceding”

Download CSV
Jan.Feb.Mar.Apr.MayJuneJulyAug.Sept.Oct.Nov.Dec.
202311.2%9.6%6.8%7.8%5.2%4.7%3.7%3.6%5.0%1.9%3.8%5.3%
202214.9%21.3%19.1%20.3%17.6%16.0%18.1%16.1%13.7%13.6%10.2%8.0%

Table 22 after “It is important to note that these benchmarks are historical averages. In a year where demand is strong, our daily sales growth rates will t”

Download CSV
Jan.(1)Feb.Mar.Apr.MayJuneJulyAug.Sept.Oct.Cumulative Change from Jan. to Oct.
Benchmark (2)0.2%1.5%3.8%-0.5%2.7%2.0%-3.1%2.9%3.6%-1.9%11.2%
2023-0.4%1.7%1.0%-0.2%0.7%-0.2%-2.6%1.3%4.0%-3.0%2.3%
23Delta-0.6%0.1%-2.9%0.2%-2.0%-2.1%0.5%-1.6%0.4%-1.1%-8.8%
20221.7%3.1%3.6%-1.2%3.2%0.2%-1.6%1.3%2.7%-0.1%11.7%
22Delta1.5%1.6%-0.2%-0.7%0.6%-1.7%1.5%-1.6%-0.9%1.8%0.5%

Table 23 after “We estimate approximately 70% to 75% of our business is with customers engaged in some type of manufacturing, a significant subset of which ”

Download CSV
DSR change - manufacturing customersQ1Q2Q3Q4Annual
202314.4%10.4%6.2%4.7%8.9%
202223.9%23.1%22.6%16.0%21.3%

Table 24 after “We estimate approximately 25% to 30% of our business is with customers engaged in a wide range of activities, none of which individually con”

Download CSV
DSR change - non-manufacturing customersQ1Q2Q3Q4Annual
2023-3.7%-5.3%-1.3%0.9%-2.4%
20226.9%6.9%1.0%-0.8%3.5%

Table 25 after “end markets):”

Download CSV
DSR change - fastenersQ1Q2Q3Q4Annual
20237.0%0.0%-2.0%-2.3%0.7%
202224.6%21.2%18.2%9.1%18.1%

Table 26 after “end markets):”

Download CSV
DSR change - non-fastenersQ1Q2Q3Q4Annual
202310.3%9.2%7.5%6.6%8.4%
202215.0%16.0%14.4%11.6%14.2%

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

Download CSV
Q1Q2Q3Q4Annual
202345.7%45.5%45.9%45.5%45.7%
202246.6%46.5%45.9%45.3%46.1%

Table 28 after “The percentage change in employee-related, occupancy-related, and all other operating and administrative expenses compared to the same perio”

Download CSV
Approximate Percentage of Total Operating and Administrative ExpensesTwelve-month Period
20232022
Employee-related expenses70% to 75%3.4%14.7%
Occupancy-related expenses15% to 20%4.2%2.6%
All other operating and administrative expenses10% to 15%4.2%18.5%

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

Download CSV
Twelve-month Period
20232022
Selling personnel (1)4.1%7.9%
Distribution/Transportation personnel4.2%8.4%
Manufacturing personnel0.1%12.4%
Organizational support personnel (2)8.6%9.5%
Total personnel4.4%8.3%

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

Download CSV
(1)Of our Selling Personnel, 80%-85% are attached to a specific in-market location.
(2)Organizational support personnel consists of: (1) Sales & Growth Driver Support personnel (approximately 35% of category), which includes sourcing, purchasing, supply chain, product development, etc.; (2) Information Technology personnel (35% to 40% of category); and (3) Administrative Support personnel (25% to 30% of category), which includes human resources, Fastenal School of Business, accounting and finance, senior management, etc.

Table 31 after “Net earnings, net earnings per share (EPS), the percentage change in net earnings, and the percentage change in EPS, were as follows:”

Download CSV
Dollar Amounts20232022
Net earnings$1,155.01,086.9
Basic EPS2.021.89
Diluted EPS2.021.89
Percentage Change20232022
Net earnings6.3%17.5%
Basic EPS6.7%17.7%
Diluted EPS6.7%17.8%

First 8 of 10 rows. The CSV has all of them.

Table 32 after “Net cash provided by operating activities in dollars and as a percentage of net earnings were as follows:”

Download CSV
20232022
Net cash provided$1,432.7941.0
% of net earnings124.0%86.6%

Table 33 after “The following table sets forth the dollar and percentage change in accounts receivable, net, inventories, and accounts payable for the perio”

Download CSV
Twelve-month Dollar ChangeTwelve-month Percentage Change
202320232023
Accounts receivable, net$1,087.674.47.3%
Inventories1,522.7(185.3)-10.8%
Trade working capital$2,610.3(110.9)-4.1%
Accounts payable$264.19.23.6%
Trade working capital, net$2,346.2(120.1)-4.9%
Net sales in last three months$1,758.663.03.7%

Table 34 after “The approximate percentage mix of inventory stocked at our selling locations versus our distribution center and manufacturing locations was ”

Download CSV
20232022
Selling locations64%58%
Distribution center and manufacturing locations36%42%
Total100%100%

Table 35 after “Net cash used in investing activities in dollars and as a percentage of net earnings were as follows:”

Download CSV
20232022
Net cash used$161.2163.0
% of net earnings14.0%15.0%

Table 36 after “Set forth below is a recap of our 2023 and 2022 net capital expenditures in dollars and as a percentage of net sales and net earnings:”

Download CSV
20232022
Manufacturing, warehouse and packaging equipment, industrial vending equipment, and facilities$83.997.8
Shelving and related supplies for in-market location openings and for product expansion at existing in-market locations24.021.5
Data processing software and equipment33.430.6
Real estate and improvements to branch locations7.012.4
Vehicles24.511.5
Purchases of property and equipment172.8173.8
Proceeds from sale of property and equipment(12.2)(11.4)

First 8 of 11 rows. The CSV has all of them.

Table 37 after “The increase in net cash used in financing activities reflects higher dividend payments, including a supplemental payment in December of 202”

Download CSV
20232022
Cash dividends paid$1,016.8711.3
% of net earnings88.0%65.4%
Purchases of common stock—237.8
% of net earnings—%21.9%
Total returned to shareholders$1,016.8949.1
% of net earnings88.0%87.3%
Proceeds from the exercise of stock options$(30.1)(9.2)

First 8 of 13 rows. The CSV has all of them.

Table 38 after “Our borrowings under the Credit Facility and Master Note Agreement peaked during each quarter of 2023 as follows:”

Download CSV
Peak borrowings2023
First quarter$565.0
Second quarter470.0
Third quarter350.0
Fourth quarter330.0

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

Download CSV
20222021
Net sales100.0%100.0%
Gross profit46.1%46.2%
Operating and administrative expenses25.2%26.0%
Operating income20.8%20.3%
Net interest expense-0.2%-0.2%
Earnings before income taxes20.6%20.1%
Note – Amounts may not foot due to rounding difference.

Table 40 after “The table below sets forth net sales and daily sales for the periods ended December 31, and changes in such sales from the prior period to t”

Download CSV
20222021
Net sales$6,980.66,010.9
Percentage change16.1%6.4%
Business days254253
Daily sales$27.523.8
Percentage change15.7%7.3%
Daily sales impact of currency fluctuations-0.5%0.6%

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

Download CSV
20222021
Fasteners34.0%33.3%
Safety supplies20.8%21.2%
Other product lines45.2%45.5%

Table 42 after “During the months noted below, all of our selling locations, when combined, had a DSR change of (compared to the same month in the preceding”

Download CSV
Jan.Feb.Mar.Apr.MayJuneJulyAug.Sept.Oct.Nov.Dec.
202214.9%21.3%19.1%20.3%17.6%16.0%18.1%16.1%13.7%13.6%10.2%8.0%
20216.5%1.5%7.5%1.2%-3.2%1.7%9.7%9.0%11.1%14.1%13.2%16.5%

Table 43 after “It is important to note that these benchmarks are historical averages. In a year where demand is strong, our daily sales growth rates will t”

Download CSV
Jan. (1)Feb.Mar.Apr.MayJuneJulyAug.Sept.Oct.Cumulative Change from Jan. to Oct.
Benchmark (2)-0.1%0.8%3.4%0.1%2.2%1.9%-3.3%3.1%3.4%-2.1%9.5%
20221.7%3.1%3.6%-1.2%3.2%0.2%-1.6%1.3%2.7%-0.1%11.7%
22Delta1.7%2.4%0.2%-1.3%1.1%-1.7%1.6%-1.8%-0.7%2.0%2.2%
20210.9%-2.3%5.6%-2.2%5.6%1.6%-3.4%3.1%4.8%0.0%13.0%
21Delta1.0%-3.0%2.2%-2.3%3.4%-0.3%-0.2%0.0%1.5%2.1%3.5%

Table 44 after “The DSR change to our manufacturing customers, when compared to the same period in the prior year, was as follows:”

Download CSV
DSR change - manufacturing customersQ1Q2Q3Q4Annual
202223.9%23.1%22.6%16.0%21.3%
20215.6%24.5%20.8%23.8%18.4%

Table 45 after “The DSR change to these remaining non-manufacturing customers, when compared to the same period in the prior year, was as follows:”

Download CSV
DSR change - non-manufacturing customersQ1Q2Q3Q4Annual
20226.9%6.9%1.0%-0.8%3.5%
20214.9%-30.7%-8.2%-2.3%-11.3%

Table 46 after “end markets):”

Download CSV
DSR change - fastenersQ1Q2Q3Q4Annual
202224.6%21.2%18.2%9.1%18.1%
20214.0%28.4%20.2%24.2%18.8%

Table 47 after “end markets):”

Download CSV
DSR change - non-fastenersQ1Q2Q3Q4Annual
202215.0%16.0%14.4%11.6%14.2%
20216.1%-10.8%5.1%9.6%1.9%

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

Download CSV
Q1Q2Q3Q4Annual
202246.6%46.5%45.9%45.3%46.1%
202145.4%46.5%46.3%46.5%46.2%

Table 49 after “The percentage change in employee-related, occupancy-related, and all other operating and administrative expenses compared to the same perio”

Download CSV
Approximate Percentage of Total Operating and Administrative ExpensesTwelve-month Period
20222021
Employee-related expenses70% to 75%14.7%11.6%
Occupancy-related expenses15% to 20%2.6%3.9%
All other operating and administrative expenses10% to 15%18.5%4.9%

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

Download CSV
Twelve-month Period
20222021
Selling personnel (1)7.9%1.7%
Distribution/Transportation personnel8.4%5.8%
Manufacturing personnel12.4%2.0%
Organizational support personnel (2)9.5%7.4%
Total personnel8.3%2.8%

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

Download CSV
(1)Of our Selling Personnel, 80%-85% are attached to a specific in-market location.
(2)Organizational support personnel consists of: (1) Sales & Growth Driver Support personnel (approximately 35% of category), which includes sourcing, purchasing, supply chain, product development, etc.; (2) Information Technology personnel (35% to 40% of category); and (3) Administrative Support personnel (25% to 30% of category), which includes human resources, Fastenal School of Business, accounting and finance, senior management, etc.

Table 52 after “Net earnings, net earnings per share (EPS), the percentage change in net earnings, and the percentage change in EPS, were as follows:”

Download CSV
Dollar Amounts20222021
Net earnings$1,086.9925.0
Basic EPS1.891.61
Diluted EPS1.891.60
Percentage Change20222021
Net earnings17.5%7.7%
Basic EPS17.7%7.5%
Diluted EPS17.8%7.4%

First 8 of 10 rows. The CSV has all of them.

Table 53 after “Net cash provided by operating activities in dollars and as a percentage of net earnings were as follows:”

Download CSV
20222021
Net cash provided$941.0770.1
% of net earnings86.6%83.3%

Table 54 after “The following table sets forth the dollar and percentage change in accounts receivable, net, inventories, and accounts payable for the perio”

Download CSV
Twelve-month Dollar ChangeTwelve-month Percentage Change
202220222022
Accounts receivable, net$1,013.2113.012.6%
Inventories1,708.0184.412.1%
Trade working capital$2,721.2297.412.3%
Accounts payable$255.021.99.4%
Trade working capital, net$2,466.2275.512.6%
Net sales in last three months$1,695.6969.816.1%

Table 55 after “The approximate percentage mix of inventory stocked at our selling locations versus our distribution center and manufacturing locations was ”

Download CSV
20222021
Selling locations58%57%
Distribution center and manufacturing locations42%43%
Total100%100%

Table 56 after “Net cash used in investing activities in dollars and as a percentage of net earnings were as follows:”

Download CSV
20222021
Net cash used$163.0148.5
% of net earnings15.0%16.1%

Table 57 after “Set forth below is a recap of our 2022 and 2021 net capital expenditures in dollars and as a percentage of net sales and net earnings:”

Download CSV
20222021
Manufacturing, warehouse and packaging equipment, industrial vending equipment, and facilities$97.870.3
Shelving and related supplies for in-market location openings and for product expansion at existing in-market locations21.511.0
Data processing software and equipment30.628.0
Real estate and improvements to branch locations12.437.9
Vehicles11.59.4
Purchases of property and equipment173.8156.6
Proceeds from sale of property and equipment(11.4)(8.4)

First 8 of 11 rows. The CSV has all of them.

Table 58 after “The fluctuations in net cash used in financing activities were due to changes in the level of our dividend payments and in the level of comm”

Download CSV
20222021
Cash dividends paid$711.3643.7
% of net earnings65.4%69.6%
Purchases of common stock237.8—
% of net earnings21.9%—%
Total returned to shareholders$949.1643.7
% of net earnings87.3%69.6%
Proceeds from the exercise of stock options$(9.2)(31.6)

First 8 of 13 rows. The CSV has all of them.

Table 59 after “Our borrowings under the Credit Facility and Master Note Agreement peaked during each quarter of 2022 as follows:”

Download CSV
Peak borrowings2022
First quarter$525.0
Second quarter595.0
Third quarter650.0
Fourth quarter710.0

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

Download CSV
December 31
20232022
Assets
Current assets:
Cash and cash equivalents$221.3230.1
Trade accounts receivable, net of allowance for credit losses of $6.4 and $8.3, respectively1,087.61,013.2
Inventories1,522.71,708.0
Prepaid income taxes17.58.1

First 8 of 34 rows. The CSV has all of them.

Table 61 after “For the year ended December 31”

Download CSV
202320222021
Net sales$7,346.76,980.66,010.9
Cost of sales3,992.23,764.83,233.7
Gross profit3,354.53,215.82,777.2
Operating and administrative expenses1,825.81,762.21,559.8
Operating income1,528.71,453.61,217.4
Interest income4.10.70.1
Interest expense(10.8)(14.3)(9.7)

First 8 of 15 rows. The CSV has all of them.

Table 62 after “For the year ended December 31”

Download CSV
202320222021
Net earnings$1,155.01,086.9925.0
Other comprehensive income (loss), net of tax:
Foreign currency translation adjustments (net of tax of $0.0 in 2023, 2022, and 2021)10.0(34.1)(9.5)
Comprehensive income$1,165.01,052.8915.5

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

Download CSV
202320222021
Common stock
Balance at beginning of year$5.75.85.7
Stock options exercised0.0(0.1)0.1
Balance at end of year5.75.75.8
Additional paid-in capital
Balance at beginning of year3.696.259.1
Stock options exercised30.19.331.5

First 8 of 24 rows. The CSV has all of them.

Table 64 after “For the year ended December 31”

Download CSV
202320222021
Cash flows from operating activities:
Net earnings$1,155.01,086.9925.0
Adjustments to reconcile net earnings to net cash provided by operating activities:
Depreciation of property and equipment166.6165.9159.9
(Gain) loss on sale of property and equipment(4.3)1.1(1.1)
Bad debt expense (recoveries)2.2(1.8)2.5
Deferred income taxes(10.7)(4.9)(13.7)

First 8 of 38 rows. The CSV has all of them.

Table 65 after “Our revenues related to the following geographic areas were as follows for the periods ended December 31:”

Download CSV
Twelve-month Period
202320222021
United States$6,139.85,867.15,033.3
% of revenues83.6%84.0%83.7%
Canada and Mexico981.9884.4749.0
% of revenues13.4%12.7%12.5%
North America7,121.76,751.55,782.3
% of revenues97.0%96.7%96.2%

First 8 of 11 rows. The CSV has all of them.

Table 66 after “The percentages of our sales by end market were as follows for the periods ended December 31:”

Download CSV
Twelve-month Period
202320222021
Manufacturing74.3%72.2%68.9%
Non-residential construction9.1%10.3%11.1%
Other16.6%17.5%20.0%
100.0%100.0%100.0%

Table 67 after “The percentages of our sales by product line were as follows for the periods ended December 31:”

Download CSV
Twelve-month Period
TypeIntroduced202320222021
Fasteners (1)196732.4%34.0%33.3%
Tools19938.5%8.4%8.5%
Cutting tools19965.3%5.0%5.0%
Hydraulics & pneumatics19966.7%6.5%6.4%
Material handling19965.6%5.7%5.6%
Janitorial supplies19968.4%8.0%8.2%

First 8 of 13 rows. The CSV has all of them.

Table 68 after “Property and equipment at year end consisted of the following:”

Download CSV
Depreciable Life in Years20232022
Land—$67.267.5
Buildings and improvements15 to 40525.1509.2
Automated distribution and warehouse equipment5 to 30271.7269.2
Shelving, industrial vending, and equipment3 to 101,366.51,283.8
Transportation equipment3 to 598.385.7
Construction in progress—107.896.0
2,436.62,311.4

First 8 of 10 rows. The CSV has all of them.

Table 69 after “Our long-lived assets related to the following geographic areas at year end:”

Download CSV
20232022
United States$1,314.21,303.4
Canada and Mexico87.280.4
North America1,401.41,383.8
All other foreign countries40.640.0
Total long-lived assets$1,442.01,423.8

Table 70 after “Accrued expenses at year end consisted of the following:”

Download CSV
20232022
Employee payroll and related taxes$15.212.8
Employee bonuses and commissions32.332.7
Profit sharing contribution23.122.1
Insurance reserves40.140.4
Indirect taxes36.140.3
Customer promotions and marketing63.360.6
Other30.932.2

First 8 of 9 rows. The CSV has all of them.

Table 71 after “The following tables summarize the details of options granted under our stock option plans that were still outstanding as of December 31, 20”

Download CSV
Options GrantedOption Exercise PriceClosing Stock Price on Date of GrantDecember 31, 2023
Date of GrantOptions OutstandingOptions Exercisable
January 3, 20231,071,943$48.00$47.400989,04870,562
January 3, 2022713,438$62.00$61.980611,84853,355
January 4, 2021741,510$48.00$47.650591,206211,323
January 2, 2020902,263$38.00$37.230658,884322,242
January 2, 20191,316,924$26.00$25.705758,611451,061
January 2, 20181,087,936$27.50$27.270541,026419,460

First 8 of 12 rows. The CSV has all of them.

Table 72 after “The following tables summarize the details of options granted under our stock option plans that were still outstanding as of December 31, 20”

Download CSV
Date of GrantRisk-free Interest RateExpected Life of Option in YearsExpected Dividend YieldExpected Stock VolatilityEstimated Fair Value of Stock Option
January 3, 20234.0%5.002.6%29.58%$11.62
January 3, 20221.3%5.001.7%28.52%$13.68
January 4, 20210.4%5.002.0%29.17%$9.57
January 2, 20201.7%5.002.4%25.70%$6.81
January 2, 20192.5%5.002.9%23.96%$4.40
January 2, 20182.2%5.002.3%23.45%$5.02
January 3, 20171.9%5.002.6%24.49%$4.20

First 8 of 10 rows. The CSV has all of them.

Table 73 after “A summary of activities under our stock option plans consisted of the following:”

Download CSV
Options OutstandingExercisePrice (1)RemainingLife (2)
Outstanding as of January 1, 20235,374,736$34.375.66
Granted1,071,943$48.009.00
Exercised(1,170,693)$25.69
Cancelled/forfeited(301,908)$45.00
Outstanding as of December 31, 20234,974,078$38.705.99
Exercisable as of December 31, 20232,197,022$30.884.54

Table 74 after “A summary of activities under our stock option plans consisted of the following:”

Download CSV
Options OutstandingExercise Price (1)RemainingLife (2)
Outstanding as of January 1, 20225,173,270$30.236.08
Granted713,438$62.009.00
Exercised(346,992)$26.78
Cancelled/forfeited(164,980)$40.00
Outstanding as of December 31, 20225,374,736$34.375.66
Exercisable as of December 31, 20222,437,636$27.144.30

Table 75 after “Shares of common stock outstanding were as follows:”

Download CSV
202320222021
Balance at beginning of year570,811,674575,464,682574,159,575
Stock options exercised1,170,693346,9921,305,107
Purchases of common stock—(5,000,000)—
Balance at end of year571,982,367570,811,674575,464,682

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

Download CSV
Reconciliation202320222021
Basic weighted average shares outstanding571,271,846573,777,790574,808,030
Weighted shares assumed upon exercise of stock options1,736,7621,845,3242,309,026
Diluted weighted average shares outstanding573,008,608575,623,114577,117,056

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

Download CSV
Summary of Anti-dilutive Options Excluded202320222021
Options to purchase shares of common stock1,568,4601,335,898678,310
Weighted average exercise prices of options$53.8055.2548.00

Table 78 after “Earnings before income taxes were derived from the following sources:”

Download CSV
202320222021
Domestic$1,392.71,335.71,100.3
Foreign129.3104.3107.5
Earnings before income taxes$1,522.01,440.01,207.8

Table 79 after “Components of income tax expense (benefit) were as follows:”

Download CSV
202320222021
CurrentDeferredTotalCurrentDeferredTotalCurrentDeferredTotal
Federal$273.3(9.2)264.1267.6(5.0)262.6214.3(11.4)202.9
State59.6(1.3)58.358.0(1.1)56.946.7(1.7)45.0
Foreign44.9(0.3)44.635.0(1.4)33.634.10.834.9
Income tax expense$377.8(10.8)367.0360.6(7.5)353.1295.1(12.3)282.8

Table 80 after “Income tax expense in the accompanying consolidated financial statements differed from the expected expense as follows:”

Download CSV
202320222021
AmountPercentAmountPercentAmountPercent
U.S. federal statutory income tax$319.621.0%$302.421.0%$253.621.0%
State income taxes, net of federal benefit$45.13.0%$45.63.2%$34.92.9%
Other, net$2.30.1%$5.10.3%$(5.7)-0.5%
Effective income tax rate$367.024.1%$353.124.5%$282.823.4%

Table 81 after “The tax effects of temporary differences that give rise to deferred income tax assets and liabilities at year end consisted of the following”

Download CSV
20232022
Deferred income tax assets:
Inventory costing and valuation methods$5.66.7
Insurance reserves8.38.6
Foreign net operating loss and credit carryforwards3.02.6
Stock-based compensation3.83.6
Operating lease liabilities69.562.6
Section 174 capitalization7.43.4

First 8 of 18 rows. The CSV has all of them.

Table 82 after “A reconciliation of the beginning and ending amount of total gross unrecognized tax benefits is as follows:”

Download CSV
20232022
Balance at beginning of year:$10.17.4
Increase related to prior year tax positions5.63.5
Increase related to current year tax positions0.60.6
Decrease related to statute of limitation lapses(6.1)(0.9)
Settlements—(0.5)
Balance at end of year:$10.210.1

Table 83 after “The cost components of our operating leases were as follows for the periods ended December 31:”

Download CSV
202320222021
Leased Facilities and EquipmentLeased VehiclesTotalLeased Facilities and EquipmentLeased VehiclesTotalLeased Facilities and EquipmentLeased VehiclesTotal
Operating lease cost$99.418.2117.696.814.7111.599.713.7113.4
Variable lease cost10.51.612.19.71.511.210.41.311.7
Short-term lease cost—23.723.7—26.626.6—19.219.2
Total$109.943.5153.4106.542.8149.3110.134.2144.3

Table 84 after “Maturities of our lease liabilities for all operating leases were as follows as of December 31, 2023:”

Download CSV
Leased Facilities and EquipmentLeased VehiclesTotal
2024$86.114.2100.3
202565.112.177.2
202643.38.952.2
202726.55.131.6
202814.73.117.8
2029 and thereafter13.01.514.5
Total lease payments$248.744.9293.6

First 8 of 10 rows. The CSV has all of them.

Table 85 after “The weighted average remaining lease terms and discount rates for all of our operating leases were as follows for the periods ended December”

Download CSV
Remaining lease term and discount rate:20232022
Weighted average remaining lease term (years)
Leased facilities and equipment3.763.57
Leased vehicles3.772.66
Weighted average discount rate
Lease facilities and equipment3.07%2.07%
Leased vehicles4.03%2.47%

Table 86 after “Supplemental cash flow information related to our operating leases was as follows for the periods ended December 31:”

Download CSV
202320222021
Cash paid for amounts included in the measurement of lease liabilities:
Operating cash outflow from operating leases$115.7110.9112.4
Leased assets obtained in exchange for new operating lease liabilities116.289.4103.6

Table 87 after “Debt obligations and letters of credit outstanding at year end consisted of the following:”

Download CSV
Average Interest Rate at December 31, 2023Debt Outstanding
Maturity Date20232022
Unsecured revolving credit facility6.36%September 28, 2027$—225.0
Senior unsecured promissory notes payable, Series C3.22%March 1, 202460.060.0
Senior unsecured promissory notes payable, Series D2.66%May 15, 202575.075.0
Senior unsecured promissory notes payable, Series E2.72%May 15, 202750.050.0
Senior unsecured promissory notes payable, Series F1.69%June 24, 2023—70.0
Senior unsecured promissory notes payable, Series G2.13%June 24, 202625.025.0

First 8 of 13 rows. The CSV has all of them.

Table 88 after “Principal payments required on our outstanding indebtedness, based on the maturity dates defined within our long-term debt arrangements, for”

Download CSV
Principal Payments
2024$60.0
202575.0
202625.0
202750.0
2028—
2029 and thereafter50.0
Total$260.0

Table 89 after “As of the date of filing this Form 10-K, the following individuals were executive officers of the Company:”

Download CSV
NameEmployee of Fastenal SinceAgePosition
Daniel L. Florness199660President, Chief Executive Officer, and Director
Anthony P. Broersma200344Executive Vice President – Operations
William J. Drazkowski199552Executive Vice President – Sales
James C. Jansen199253Executive Vice President – Manufacturing
Holden Lewis201654Senior Executive Vice President and Chief Financial Officer
Sheryl A. Lisowski199456Executive Vice President – Chief Accounting Officer and Treasurer
Charles S. Miller199949Senior Executive Vice President – Sales

First 8 of 11 rows. The CSV has all of them.

Table 90 after “Equity Compensation Plan Information”

Download CSV
Plan CategoryNumber of Securities to be Issued Upon Exercise of Outstanding Options, Warrants, and RightsWeighted-Average Exercise Price of Outstanding Options, Warrants, and RightsNumber of Securities Remaining Available for Future Issuance Under Equity Compensation Plans (Excluding Securities Reflected in Column (a))
(a)(b)(c)
Equity compensation plans approved by security holders (1)4,974,078$38.7010,877,707
Equity compensation plans not approved by security holders———
Total4,974,07810,877,707

Table 91 after “EXHIBITS AND FINANCIAL STATEMENT SCHEDULES”

Download CSV
a)1. Financial Statements:
Consolidated Balance Sheets as of December 31, 2023 and 2022
Consolidated Statements of Earnings for the years ended December 31, 2023, 2022, and 2021
Consolidated Statements of Comprehensive Income for the years ended December 31, 2023, 2022, and 2021
Consolidated Statements of Stockholders' Equity for the years ended December 31, 2023, 2022, and 2021
Consolidated Statements of Cash Flows for the years ended December 31, 2023, 2022, and 2021
Notes to Consolidated Financial Statements
Report of Independent Registered Public Accounting Firm (KPMG LLP, Minneapolis, MN, Auditor Firm ID: 185)

Table 92 after “INDEX TO EXHIBITS”

Download CSV
Exhibit NumberDescription of Document
3.1Restated 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.2Restated By-Laws of Fastenal Company dated as of February 2, 2024 (filed herewith)
4.1Form of Senior Notes due March 1, 2024 (incorporated by reference to Exhibit 4.1 to Fastenal Company's Form 10-Q for the quarter ended March 31, 2017)
4.2Description of Capital Stock (filed herewith)
4.3Form of Senior Notes due May 15, 2025 (incorporated by reference to Exhibit 4.1 to Fastenal Company's Form 10-Q for the quarter ended June 30, 2020)
4.4Form of Senior Notes due May 15, 2027 (incorporated by reference to Exhibit 4.2 to Fastenal Company's Form 10-Q for the quarter ended June 30, 2020)
4.5Form of Senior Notes due June 24, 2026 (incorporated by reference to Exhibit 4.4 to Fastenal Company's Form 10-Q for the quarter ended June 30, 2020)

First 8 of 15 rows. The CSV has all of them.

Table 93 after “Table of Contents”

Download CSV
Exhibit NumberDescription of Document
10.7Master Note Agreement dated as of July 20, 2016 by and among (i) Fastenal Company, (ii) Metropolitan Life Insurance Company, NYL Investors LLC and PGIM, Inc. (formerly known as Prudential Investment Management, Inc.), as investor group representatives (each, an 'Investor Group Representative'), and (iii) Metropolitan Life Insurance Company (in its capacity as a purchaser of notes under such Master Note Agreement) and/or affiliates of any Investor Group Representative who become purchasers of notes under such Master Note Agreement (incorporated by reference to Exhibit 10.1 to Fastenal Company’s Form 8-K dated as of July 20, 2016).
10.8Omnibus First Amendment to Master Note Agreement and Subsidiary Guaranty Agreement dated as of November 30, 2018 by and among Fastenal Company, Fastenal Company Purchasing, and Fastenal IP Company, on one hand, and Metropolitan Life Insurance Company, NYL Investors LLC, PGIM, Inc., and each holder of Notes that are signatory thereto, on the other hand (incorporated by reference to Exhibit 10.2 to Fastenal Company's Form 8-K dated December 3, 2018).
10.9Consent, Waiver and Agreement to Master Note Agreement dated as of June 10, 2020 by and among Fastenal Company, Fastenal Company Purchasing, and Fastenal IP Company, on the one hand, and Metropolitan Life Insurance Company, MetLife Investment Management, LLC, NYL Investors LLC, PGIM, Inc. and each holder of Notes that are signatory thereto, on the other hand (incorporated by reference to Exhibit 10.1 to Fastenal Company's Form 10-Q for the quarter ended June 30, 2020).
10.10Omnibus Second Amendment to Master Note Agreement and Subsidiary Guaranty Agreement dated as of September 28, 2022 by and among Fastenal Company, Fastenal Company Purchasing, and Fastenal IP Company, on one hand, and Metropolitan Life Insurance Company, MetLife Investment Management, LLC, NYL Investors LLC, PGIM, Inc., and each holder of Notes that is a signatory thereto, on the other hand (incorporated by reference to Exhibit 10.2 to Fastenal Company's Form 8-K dated as of September 30, 2022).
21List of Subsidiaries (filed herewith)
23Consent of Independent Registered Public Accounting Firm (filed herewith)
31Certifications under Section 302 of the Sarbanes-Oxley Act of 2002 (filed herewith)

First 8 of 12 rows. The CSV has all of them.

Table 94 after “(Amounts in millions)”

Download CSV
DescriptionBalance at Beginning of Year"Additions/(Reductions)" to Costs and Expenses"Other" Additions (Deductions)"Less" DeductionsBalance at End of Year
Year ended December 31, 2023
Allowance for credit losses$8.32.2—4.16.4
Insurance reserves$40.486.2(1)—86.5(2)40.1
Year ended December 31, 2022
Allowance for credit losses$12.0(1.8)—1.98.3
Insurance reserves$35.778.2(1)—73.5(2)40.4
Year ended December 31, 2021

First 8 of 10 rows. The CSV has all of them.