tickdelta
Sign in
Tables

Tables in the 10-Q of FASTENAL CO

41 tables with numbers, filed Jul 17, 2024. Each one downloads as an Excel file or a CSV (numbers are stored as numbers), 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 ↗

← Filings of FAST

Table 1 after “INDEX”

Page
PART IFINANCIAL INFORMATION
ITEM 1.FINANCIAL STATEMENTS
Condensed Consolidated Balance Sheets1
Condensed Consolidated Statements of Income2
Condensed Consolidated Statements of Comprehensive Income3
Condensed Consolidated Statements of Stockholders' Equity4
Condensed Consolidated Statements of Cash Flows5

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

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

(Unaudited)
AssetsJune 30, 2024December 31, 2023
Current assets:
Cash and cash equivalents$255.5221.3
Trade accounts receivable, net of allowance for credit losses of $4.2 and $6.4, respectively1,204.81,087.6
Inventories1,504.61,522.7
Prepaid income taxes16.517.5
Other current assets165.3171.8

First 8 of 32 rows. The download has all of them.

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

(Unaudited)(Unaudited)
Six Months Ended June 30,Three Months Ended June 30,
2024202320242023
Net sales$3,811.33,742.2$1,916.21,883.1
Cost of sales2,086.22,034.71,052.71,025.6
Gross profit1,725.11,707.5863.5857.5
Selling, general, and administrative expenses948.0919.4476.6462.6
Operating income777.1788.1386.9394.9

First 8 of 17 rows. The download has all of them.

Table 4 after “(Amounts in millions)”

(Unaudited)(Unaudited)
Six Months Ended June 30,Three Months Ended June 30,
2024202320242023
Net income$590.4593.1$292.7298.0
Other comprehensive (loss) income, net of tax:
Foreign currency translation adjustments (net of tax of $0.0 in 2024 and 2023)(19.7)7.9(7.8)3.6
Comprehensive income$570.7601.0$284.9301.6

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

(Unaudited)(Unaudited)
Six Months Ended June 30,Three Months Ended June 30,
2024202320242023
Common stock
Balance at beginning of period$5.75.7$5.75.7
Balance at end of period5.75.75.75.7
Additional paid-in capital
Balance at beginning of period41.03.658.811.4

First 8 of 22 rows. The download has all of them.

Table 6 after “(Amounts in millions)”

(Unaudited)(Unaudited)
Six Months Ended June 30,Three Months Ended June 30,
2024202320242023
Cash flows from operating activities:
Net income$590.4593.1$292.7298.0
Adjustments to reconcile net income to net cash provided by operating activities:
Depreciation of property and equipment81.284.041.042.2
Gain on sale of property and equipment(1.7)(1.2)(1.1)(0.6)

First 8 of 40 rows. The download has all of them.

Table 7 after “Revenues are attributable to countries based on the selling location from which the sale occurred. Our revenues related to the following geo”

Six-month PeriodThree-month Period
2024202320242023
United States$3,173.03,130.4$1,594.11,571.7
% of revenues83.3%83.6%83.2%83.5%
Canada and Mexico519.6498.8263.9254.9
% of revenues13.6%13.3%13.8%13.5%
North America3,692.63,629.21,858.01,826.6
% of revenues96.9%96.9%97.0%97.0%

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

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

Six-month PeriodThree-month Period
2024202320242023
Manufacturing75.3%74.7%75.5%74.8%
Non-residential construction8.5%9.2%8.5%9.2%
Other16.2%16.1%16.0%16.0%
100.0%100.0%100.0%100.0%

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

Six-month PeriodThree-month Period
TypeIntroduced2024202320242023
Fasteners (1)196731.3%33.1%31.0%32.6%
Tools19938.5%8.5%8.4%8.5%
Cutting tools19965.3%5.4%5.3%5.5%
Hydraulics & pneumatics19966.8%6.7%6.8%6.8%
Material handling19965.6%5.6%5.6%5.6%
Janitorial supplies19968.6%8.2%8.8%8.3%

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

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”

20242023
First quarter$0.39$0.35
Second quarter0.390.35
Third quarter0.390.35
Fourth quarter0.35
Fourth quarter (special)0.38
Total$1.17$1.78

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

Options GrantedOption Exercise PriceClosing Stock Price on Date of GrantJune 30, 2024
Date of GrantOptions OutstandingOptions Exercisable
January 2, 2024814,912$64.00$63.550791,48250,717
January 3, 20231,071,943$48.00$47.400928,955201,513
January 3, 2022713,438$62.00$61.980575,395223,661
January 4, 2021741,510$48.00$47.650538,824271,200
January 2, 2020902,263$38.00$37.230597,803387,378
January 2, 20191,316,924$26.00$25.705619,843483,463

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

Table 12 after “(Unaudited)”

Date of GrantRisk-free Interest RateExpected Life of Option in YearsExpected Dividend YieldExpected Stock VolatilityEstimated Fair Value of Stock Option
January 2, 20243.8%5.002.2%28.44%$15.87
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

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

Table 13 after “The following tables present a reconciliation of the denominators used in the computation of basic and diluted income per share and a summar”

Six-month PeriodThree-month Period
Reconciliation2024202320242023
Basic weighted average shares outstanding572,457,897571,033,444572,576,300571,138,039
Weighted shares assumed upon exercise of stock options1,645,5491,724,0321,537,3081,752,121
Diluted weighted average shares outstanding574,103,446572,757,476574,113,608572,890,160

Table 14 after “The following tables present a reconciliation of the denominators used in the computation of basic and diluted income per share and a summar”

Six-month PeriodThree-month Period
Summary of Anti-dilutive Options Excluded2024202320242023
Options to purchase shares of common stock1,262,9472,244,5551,261,8701,866,320
Weighted average exercise prices of options$63.1752.17$63.1752.96

Table 15 after “Debt obligations and letters of credit outstanding at the end of each period consisted of the following:”

Average Interest Rate at June 30, 2024Debt Outstanding
Maturity DateJune 30, 2024December 31, 2023
Unsecured revolving credit facility6.36%September 28, 2027$35.0—
Senior unsecured promissory notes payable, Series C3.22%March 1, 2024—60.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 G2.13%June 24, 202625.025.0
Senior unsecured promissory notes payable, Series H2.50%June 24, 203050.050.0

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

Table 16 after “.”

Six-month PeriodThree-month Period
20242023Change20242023Change
Net sales$3,811.33,742.21.8%$1,916.21,883.11.8%
Business days1281286464
Daily sales$29.829.21.8%$29.929.41.8%
Gross profit$1,725.11,707.51.0%$863.5857.50.7%
% of net sales45.3%45.6%45.1%45.5%
Selling, general, and administrative expenses$948.0919.43.1%$476.6462.63.0%

First 8 of 16 rows. The download has all of them.

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”

Change Since:Change Since:Change Since:
Q2 2024Q1 2024Q1 2024Q4 2023Q4 2023Q2 2023Q2 2023
Selling personnel - absolute employee headcount16,77416,7640.1%16,5121.6%16,3022.9%
Selling personnel - FTE employee headcount15,38615,1021.9%15,0702.1%14,9932.6%
Total personnel - absolute employee headcount23,62923,695-0.3%23,2011.8%22,9133.1%
Total personnel - FTE employee headcount21,24920,9351.5%20,7212.5%20,6313.0%
Number of branch locations1,5991,5920.4%1,5970.1%1,635-2.2%
Number of active Onsite locations1,9341,8723.3%1,8226.1%1,72811.9%

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

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”

Six-month PeriodThree-month Period
2024202320242023
Branch openings3533
Branch closures, net of conversions(1)(53)4(28)
Onsite activations1751739689
Onsite closures, net of conversions(63)(68)(34)(35)

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

Three-month Period
20242023
Net sales100.0%100.0%
Gross profit45.1%45.5%
Selling, general, and administrative expenses24.9%24.6%
Operating income20.2%21.0%
Net interest expense0.0%-0.1%
Income before income taxes20.2%20.9%

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

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”

Three-month Period
20242023
Net sales$1,916.21,883.1
Percentage change1.8%5.9%
Business days6464
Daily sales$29.929.4
Percentage change1.8%5.9%
Daily sales impact of currency fluctuations-0.2%-0.4%

Table 21 after “From a product standpoint, we have three categories: fasteners [including fasteners used in original equipment manufacturing (OEM) and maint”

DSR Change Three-month Period% of Sales Three-month Period
2024202320242023
OEM fasteners-2.3%4.1%19.5%20.4%
MRO fasteners-4.3%-6.2%11.5%12.2%
Total fasteners-3.0%0.0%31.0%32.6%
Safety supplies7.1%7.9%21.8%20.7%
Other product lines3.0%9.8%47.2%46.7%
Total non-fasteners4.2%9.2%69.0%67.4%

Table 22 after “From an end market standpoint, we have five categories: heavy manufacturing, other manufacturing, non-residential construction, reseller, an”

DSR Change Three-month Period% of Sales Three-month Period
2024202320242023
Heavy manufacturing1.8%13.0%43.3%43.4%
Other manufacturing4.0%7.0%32.2%31.4%
Total manufacturing2.7%10.4%75.5%74.8%
Non-residential construction-5.5%-8.8%8.5%9.2%
Reseller-6.4%-8.7%5.3%5.7%
Other end markets6.0%0.2%10.7%10.3%

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

Table 23 after “We report our customers in two categories: national accounts, which are customers with significant revenue potential and a national, multi-s”

DSR Change Three-month Period% of Sales Three-month Period
2024202320242023
National accounts5.8%10.3%62.4%59.3%
Non-national accounts-4.3%0.2%37.6%40.7%

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

Three-month Period
20242023Change
Weighted FASTBin/FASTVend signings (MEUs)7,1886,7945.8%
Signings per day112106
Weighted FASTBin/FASTVend installations (MEUs; end of period)119,306107,11511.4%
FASTStock sales$244.4237.72.8%
% of sales12.6%12.5%
FASTBin/FASTVend sales$567.0520.68.9%

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

Table 25 after “related, occupancy-related, and all other SG&A expenses compared to the same periods in the preceding year, is outlined in the table below.”

Approximate Percentage of Total SG&A ExpensesThree-month Period
2024
Employee-related expenses70% to 75%2.4%
Occupancy-related expenses15% to 20%0.1%
All other SG&A expenses10% to 15%10.1%

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

Change Since:Change Since:
Q2 2024Q1 2024Q1 2024Q2 2023Q2 2023
Selling personnel (1)15,38615,1021.9%14,9932.6%
Distribution/Transportation personnel3,1723,187-0.5%3,0533.9%
Manufacturing personnel7217150.8%723-0.3%
Organizational support personnel (2)1,9701,9312.0%1,8625.8%
Total personnel21,24920,9351.5%20,6313.0%

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

(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 (35% to 40% 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 (20% to 25% of category), which includes human resources, Fastenal School of Business, accounting and finance, senior management, etc.

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

Three-month Period
20242023Change
Net cash provided by operating activities$258.0302.1-14.6%
Percentage of net income88.1%101.4%
Net cash used in investing activities$52.754.2-2.8%
Percentage of net income18.0%18.2%
Net cash used in financing activities$185.5243.3-23.8%

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

June 30Twelve-month Dollar ChangeTwelve-month Percentage Change
2024202320242024
Accounts receivable, net$1,204.81,171.6$33.22.8%
Inventories1,504.61,565.4(60.8)-3.9%
Trade working capital$2,709.42,737.0$(27.6)-1.0%
Accounts payable$292.6262.0$30.611.7%
Trade working capital, net$2,416.82,475.0$(58.2)-2.4%
Net sales in last three months$1,916.21,883.1$33.11.8%

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

Six-month Period
20242023
Net sales100.0%100.0%
Gross profit45.3%45.6%
Selling, general, and administrative expenses24.9%24.6%
Operating income20.4%21.1%
Net interest expense0.0%-0.2%
Income before income taxes20.4%20.9%

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

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

Six-month Period
20242023
Net sales$3,811.33,742.2
Percentage change1.8%7.5%
Business days128128
Daily sales$29.829.2
Percentage Change1.8%7.5%
Daily sales impact of currency fluctuations-0.1%-0.5%

Table 32 after “From a product standpoint, we have three categories: fasteners [including fasteners used in original equipment manufacturing (OEM) and maint”

DSR ChangeSix-month Period% of SalesSix-month Period
2024202320242023
OEM fasteners-3.2%8.2%19.6%20.6%
MRO fasteners-4.7%-3.7%11.7%12.5%
Total fasteners-3.7%3.4%31.3%33.1%
Safety supplies7.7%6.8%21.7%20.5%
Other product lines3.4%11.1%47.0%46.4%
Total non-fasteners4.7%9.7%68.7%66.9%

Table 33 after “From an end market standpoint, we have five categories: heavy manufacturing, other manufacturing, non-residential construction, reseller, an”

DSR ChangeSix-month Period% of SalesSix-month Period
2024202320242023
Heavy manufacturing2.2%15.3%43.4%43.2%
Other manufacturing3.3%8.6%31.9%31.5%
Total manufacturing2.7%12.3%75.3%74.7%
Non-residential construction-6.1%-5.7%8.5%9.2%
Reseller-4.4%-7.2%5.5%5.9%
Other end markets6.8%-1.7%10.7%10.2%

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

Table 34 after “We report our customers in two categories: national accounts, which are customers with significant revenue potential and a national, multi-s”

DSR ChangeSix-month Period% of SalesSix-month Period
2024202320242023
National accounts6.1%12.0%62.2%59.3%
Non-national accounts-4.4%1.8%37.8%40.7%

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

Six-month Period
20242023Change
Weighted FASTBin/FASTVend signings (MEUs)13,91412,6959.6%
Signings per day10999
Weighted FASTBin/FASTVend installations (MEUs; end of period)119,306107,11511.4%
FASTStock sales$484.2474.42.1%
% of sales12.5%12.5%
FASTBin/FASTVend sales$1,123.91,024.39.7%

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

Table 36 after “related, occupancy-related, and all other SG&A expenses compared to the same periods in the preceding year, is outlined in the table below.”

Approximate Percentage of Total SG&A ExpensesSix-month Period
2024
Employee-related expenses70% to 75%3.2%
Occupancy-related expenses15% to 20%0.0%
All other SG&A expenses10% to 15%6.9%

Table 37 after “the percentage change compared to the end of the prior period:”

Change Since:
Q2 2024Q4 2023Q4 2023
Selling personnel (1)15,38615,0702.1%
Distribution/Transportation personnel3,1723,0952.5%
Manufacturing personnel7216973.4%
Organizational support personnel (2)1,9701,8596.0%
Total personnel21,24920,7212.5%

Table 38 after “the percentage change compared to the end of the prior period:”

(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 (35% to 40% 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 (20% to 25% of category), which includes human resources, Fastenal School of Business, accounting and finance, senior management, etc.

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

Six-month Period
20242023Change
Net cash provided by operating activities$593.6690.6-14.0%
Percentage of net income100.5%116.4%
Net cash used in investing activities$101.185.218.7%
Percentage of net income17.1%14.4%
Net cash used in financing activities$452.9592.2-23.5%

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

(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 thatMay Yet Be PurchasedUnder the Plans orPrograms (1)
April 1-30, 20240$0.0006,200,000
May 1-31, 20240$0.0006,200,000
June 1-30, 20240$0.0006,200,000
Total0$0.0006,200,000

Table 41 after “INDEX TO EXHIBITS”

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 25, 2024)
3.2Restated By-Laws of Fastenal Company dated as of February 2, 2024 (incorporated by reference to Exhibit 3.2 to Fastenal Company's 10-K for fiscal year ended December 31, 2023)
31Certifications under Section 302 of the Sarbanes-Oxley Act of 2002 (filed herewith)
32Certification under Section 906 of the Sarbanes-Oxley Act of 2002 (filed herewith)
101The following financial statements from the quarterly report on Form 10-Q for the quarter ended June 30, 2024, formatted in Inline XBRL: (i) Condensed Consolidated Balance Sheets, (ii) Condensed Consolidated Statements of Income, (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.
104The cover page from the quarterly report on Form 10-Q for the quarter ended June 30, 2024, formatted in Inline XBRL.
Esc

Type a ticker such as AAPL, a name, an investor such as Buffett, or a topic such as tariffs. ↑ ↓ to move, Enter to open.