tickdelta
Sign in
Tables

Tables in the 10-Q of FASTENAL CO

33 tables with numbers, filed Jul 18, 2022. 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 Earnings2
Condensed Consolidated Statements of Comprehensive Income3
Condensed Consolidated Statements of Stockholders' Equity4
Condensed Consolidated Statements of Cash Flows5

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

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

(Unaudited)
AssetsJune 30, 2022December 31, 2021
Current assets:
Cash and cash equivalents$247.9236.2
Trade accounts receivable, net of allowance for credit losses of $11.1 and $12.0, respectively1,103.9900.2
Inventories1,665.21,523.6
Prepaid income taxes6.58.5
Other current assets129.2188.1

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

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

(Unaudited)(Unaudited)
Six Months Ended June 30,Three Months Ended June 30,
2022202120222021
Net sales$3,482.62,924.7$1,778.61,507.7
Cost of sales1,861.71,580.6951.0807.0
Gross profit1,620.91,344.1827.6700.7
Operating and administrative expenses879.5746.0444.2382.9
Operating income741.4598.1383.4317.8

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,
2022202120222021
Net earnings$556.7450.3$287.1239.7
Other comprehensive (loss) income, net of tax:
Foreign currency translation adjustments (net of tax of $0.0 in 2022 and 2021)(23.7)2.4(26.0)6.8
Comprehensive income$533.0452.7$261.1246.5

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

(Unaudited)(Unaudited)
Six Months Ended June 30,Three Months Ended June 30,
2022202120222021
Common stock
Balance at beginning of period$5.85.7$5.85.7
Balance at end of period5.85.75.85.7
Additional paid-in capital
Balance at beginning of period96.259.1101.667.2

First 8 of 24 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,
2022202120222021
Cash flows from operating activities:
Net earnings$556.7450.3$287.1239.7
Adjustments to reconcile net earnings to net cash provided by operating activities:
Depreciation of property and equipment82.478.941.239.6
Loss (gain) on sale of property and equipment2.3(1.3)(1.2)(0.7)

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

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

Six-month PeriodThree-month Period
2022202120222021
United States$2,928.42,446.1$1,496.71,258.2
Canada and Mexico438.4368.9225.0192.0
North America3,366.82,815.01,721.71,450.2
All other foreign countries115.8109.756.957.5
Total revenues$3,482.62,924.7$1,778.61,507.7

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
2022202120222021
Manufacturing71.5%68.5%71.8%68.9%
Non-residential construction10.5%11.1%10.7%11.4%
Other18.0%20.4%17.5%19.7%
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
TypeIntroduced2022202120222021
Fasteners (1)196734.4%33.1%34.6%33.6%
Tools19938.2%8.6%8.2%8.6%
Cutting tools19965.0%5.0%5.0%5.1%
Hydraulics & pneumatics19966.6%6.4%6.7%6.4%
Material handling19965.7%5.5%5.7%5.6%
Janitorial supplies19967.9%8.2%8.0%7.9%

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”

20222021
First quarter$0.31$0.28
Second quarter$0.31$0.28
Third quarter$0.31$0.28
Fourth quarter$0.28
Total$0.93$1.12

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

Options GrantedOption Exercise (Strike) PriceClosing Stock Price on Date of GrantJune 30, 2022
Date of GrantOptions OutstandingOptions Exercisable
January 3, 2022713,438$62.00$61.980695,86453,355
January 4, 2021741,510$48.00$47.650682,76326,643
January 2, 2020902,263$38.00$37.230790,286269,666
January 2, 20191,316,924$26.00$25.705949,422415,262
January 2, 20181,087,936$27.50$27.270705,640430,316
January 3, 20171,529,578$23.50$23.475695,072534,092

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

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

Date of GrantRisk-free Interest RateExpected Life of Option in YearsExpected Dividend YieldExpected Stock VolatilityEstimated Fair Value of Stock Option
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
April 19, 20161.3%5.002.6%26.34%$4.09

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 earnings per share and a summ”

Six-month PeriodThree-month Period
Reconciliation2022202120222021
Basic weighted average shares outstanding575,510,253574,465,377575,462,097574,592,653
Weighted shares assumed upon exercise of stock options1,998,7862,289,3561,940,1242,359,005
Diluted weighted average shares outstanding577,509,039576,754,733577,402,221576,951,658

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”

Six-month PeriodThree-month Period
Summary of Anti-dilutive Options Excluded2022202120222021
Options to purchase shares of common stock1,350,936688,0581,354,464696,951
Weighted average exercise prices of options$55.2048.00$55.2248.00

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, 2022Debt Outstanding
Maturity DateJune 30, 2022December 31, 2021
Unsecured revolving credit facility2.74%November 30, 2023$140.025.0
Senior unsecured promissory notes payable, Series B2.45%July 20, 202235.035.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, 202370.070.0

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

Table 16 after “devices at the end of the periods presented and the percentage change compared to the end of the prior periods.”

Change Since:Change Since:Change Since:
Q2 2022Q1 2022Q1 2022Q4 2021Q4 2021Q2 2021Q2 2021
In-market locations - absolute employee headcount13,13412,8552.2%12,4645.4%12,4465.5%
In-market locations - FTE employee headcount12,03911,6443.4%11,3376.2%11,3905.7%
Total absolute employee headcount21,62921,1672.2%20,5075.5%20,3176.5%
Total FTE employee headcount19,52318,9583.0%18,3706.3%18,2537.0%
Number of branch locations1,7371,760-1.3%1,793-3.1%1,921-9.6%
Number of active Onsite locations1,5011,4404.2%1,4166.0%1,32313.5%

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

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

Three-month Period
20222021
Net sales100.0%100.0%
Gross profit46.5%46.5%
Operating and administrative expenses25.0%25.4%
Operating income21.6%21.1%
Net interest expense-0.2%-0.2%
Earnings before income taxes21.4%20.9%

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

Table 18 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
20222021
Net sales$1,778.61,507.7
Percentage change18.0%-0.1%
Business days6464
Daily sales$27.823.6
Percentage change18.0%-0.1%
Daily sales impact of currency fluctuations-0.5%1.2%

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

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

Three-month Period
20222021Change
Weighted FASTBin/FASTVend signings (MEUs)5,4905,843-6.0%
Signings per day8691
Weighted FASTBin/FASTVend installations (MEUs; end of period)96,87287,56710.6%
FASTStock sales$207.3140.547.6%
% of sales11.5%9.2%
FASTBin/FASTVend sales$433.3327.732.2%

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

Table 20 after “The approximate mix of sales from fasteners, safety supplies, and all other product lines was as follows for the periods ended June 30:”

Three-month Period
20222021
Fasteners34.6%33.6%
Safety supplies20.3%21.0%
Other product lines45.1%45.4%
100.0%100.0%

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

Approximate Percentage of Total Operating and Administrative ExpensesThree-month Period
2022
Employee-related expenses70% to 75%16.8%
Occupancy-related expenses15% to 20%1.4%
All other operating and administrative expenses10% to 15%34.2%

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

Change Since:Change Since:
Q2 2022Q1 2022Q1 2022Q2 2021Q2 2021
In-market locations (branches & Onsites)12,03911,6443.4%11,3905.7%
Non-in-market selling2,2992,1974.6%2,02113.8%
Selling subtotal14,33813,8413.6%13,4116.9%
Distribution/Transportation2,8722,8560.6%2,6916.7%
Manufacturing6726562.4%6188.7%
Organizational support personnel (1)1,6411,6052.2%1,5337.0%

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

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

Three-month Period
20222021
Net cash provided by operating activities151.2171.5
Percentage of net earnings52.7%71.6%
Net cash used in investing activities43.931.5
Percentage of net earnings15.3%13.1%
Net cash used in financing activities85.9153.8
Percentage of net earnings29.9%64.2%

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

June 30Twelve-month Dollar ChangeTwelve-month Percentage Change
2022202120222022
Accounts receivable, net$1,103.9908.9$195.021.5%
Inventories1,665.21,327.9337.325.4%
Trade working capital$2,769.12,236.8$532.323.8%
Accounts payable$291.8236.1$55.823.6%
Trade working capital, net$2,477.32,000.7$476.623.8%
Net sales in last two months$1,207.81,010.6$197.219.5%

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

Six-month Period
20222021
Net sales100.0%100.0%
Gross profit46.5%46.0%
Operating and administrative expenses25.3%25.5%
Operating income21.3%20.5%
Net interest expense-0.1%-0.2%
Earnings before income taxes21.2%20.3%

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

Table 26 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
20222021
Net sales$3,482.62,924.7
Percentage change19.1%1.7%
Business days128127
Daily sales$27.223.0
Percentage change18.1%2.5%
Daily sales impact of currency fluctuations-0.3%0.9%

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

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

Six-month Period
20222021Change
Weighted FASTBin/FASTVend signings (MEUs)10,81810,5262.8%
Signings per day8583
Weighted FASTBin/FASTVend installations (MEUs; end of period)96,87287,56710.6%
FASTStock sales$405.8251.061.7%
% of sales11.5%8.5%
FASTBin/FASTVend sales$845.3628.734.5%

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

Table 28 after “The approximate mix of sales from fasteners, safety supplies, and all other product lines was as follows for the periods ended June 30:”

Six-month Period
20222021
Fasteners34.4%33.1%
Safety supplies20.7%21.3%
Other product lines44.9%45.6%
100.0%100.0%

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

Approximate Percentage of Total Operating and Administrative ExpensesSix-month Period
2022
Employee-related expenses70% to 75%19.8%
Occupancy-related expenses15% to 20%3.3%
All other operating and administrative expenses10% to 15%30.0%

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

Change Since:
Q2 2022Q4 2021Q4 2021
In-market locations (branches & Onsites)12,03911,3376.2%
Non-in-market selling2,2992,07610.7%
Selling subtotal14,33813,4136.9%
Distribution/Transportation2,8722,7404.8%
Manufacturing6726198.6%
Organizational support personnel (1)1,6411,5982.7%

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

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

Six-month Period
20222021
Net cash provided by operating activities$381.2446.3
Percentage of net earnings68.5%99.1%
Net cash used in investing activities$77.161.4
Percentage of net earnings13.8%13.6%
Net cash used in financing activities$285.4308.0
Percentage of net earnings51.3%68.4%

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

(a)(b)(c)(d)
PeriodTotal Number of Shares PurchasedAverage Price Paid per ShareTotal Number of Shares Purchased as Part of Publicly Announced Plans or Programs (1)Maximum Number (or Approximate Dollar Value) of Shares that May Yet Be Purchased Under the Plans or Programs (1)
April 1-30, 20220$0.0003,200,000
May 1-31, 20220$0.0003,200,000
June 1-30, 20221,000,000$49.291,000,0002,200,000
Total1,000,000$49.291,000,0002,200,000

Table 33 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 22, 2019)
3.2Restated 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)
31Certifications under Section 302 of the Sarbanes-Oxley Act of 2002
32Certification under Section 906 of the Sarbanes-Oxley Act of 2002
101The following financial statements from the Quarterly Report on Form 10-Q for the quarter ended June 30, 2022, 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.
104The cover page from the Quarterly Report on Form 10-Q for the quarter ended June 30, 2022, formatted in Inline XBRL.