tickdelta
Sign in
Tables

Tables in the 10-Q of FASTENAL CO

26 tables with numbers, filed Apr 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)
AssetsMarch 31, 2022December 31, 2021
Current assets:
Cash and cash equivalents$234.2236.2
Trade accounts receivable, net of allowance for credit losses of $10.9 and $12.0, respectively1,071.6900.2
Inventories1,600.81,523.6
Prepaid income taxes—8.5
Other current assets127.4188.1

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

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

(Unaudited)
Three Months Ended March 31,
20222021
Net sales$1,704.11,417.0
Cost of sales910.8773.6
Gross profit793.3643.4
Operating and administrative expenses435.3363.1
Operating income358.0280.3

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

Table 4 after “(Amounts in millions)”

(Unaudited)
Three Months Ended March 31,
20222021
Net earnings$269.6210.6
Other comprehensive income (loss), net of tax:
Foreign currency translation adjustments (net of tax of $0.0 in 2022 and 2021)2.3(4.4)
Comprehensive income$271.9206.2

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

(Unaudited)
Three Months Ended March 31,
20222021
Common stock
Balance at beginning of period$5.85.7
Balance at end of period5.85.7
Additional paid-in capital
Balance at beginning of period96.259.1

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

Table 6 after “(Amounts in millions)”

(Unaudited)
Three Months Ended March 31,
20222021
Cash flows from operating activities:
Net earnings$269.6210.6
Adjustments to reconcile net earnings to net cash provided by operating activities:
Depreciation of property and equipment41.239.3
Loss (gain) on sale of property and equipment3.5(0.6)

First 8 of 40 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 March 31:”

Three-month Period
20222021
United States$1,431.71,187.8
Canada and Mexico213.4176.8
North America1,645.11,364.6
All other foreign countries59.052.4
Total revenues$1,704.11,417.0

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

Three-month Period
20222021
Manufacturing71.2%68.0%
Non-residential construction10.4%10.8%
Other18.4%21.2%
100.0%100.0%

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

Three-month Period
TypeIntroduced20222021
Fasteners (1)196734.3%32.5%
Tools19938.2%8.6%
Cutting tools19965.0%5.0%
Hydraulics & pneumatics19966.5%6.3%
Material handling19965.6%5.5%
Janitorial supplies19967.9%8.5%

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.28
Fourth quarter$0.28
Total$0.62$1.12

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

Options GrantedOption Exercise (Strike) PriceClosing Stock Price on Date of GrantMarch 31, 2022
Date of GrantOptions OutstandingOptions Exercisable
January 3, 2022713,438$62.00$61.980701,82953,355
January 4, 2021741,510$48.00$47.650691,09626,643
January 2, 2020902,263$38.00$37.230796,263272,843
January 2, 20191,316,924$26.00$25.705958,946421,462
January 2, 20181,087,936$27.50$27.270712,852435,272
January 3, 20171,529,578$23.50$23.475706,446542,046

First 8 of 13 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 March 31, 2022, and t”

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 11 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”

Three-month Period
Reconciliation20222021
Basic weighted average shares outstanding575,559,161574,336,112
Weighted shares assumed upon exercise of stock options2,059,6452,210,857
Diluted weighted average shares outstanding577,618,806576,546,969

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”

Three-month Period
Summary of Anti-dilutive Options Excluded20222021
Options to purchase shares of common stock930,401711,977
Weighted average exercise prices of options$58.4048.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 March 31, 2022Debt Outstanding
Maturity DateMarch 31, 2022December 31, 2021
Unsecured revolving credit facility1.40%November 30, 2023$—25.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:
Q1 2022Q4 2021Q4 2021Q1 2021Q1 2021
In-market locations - absolute employee headcount12,85512,4643.1%12,6831.4%
In-market locations - FTE employee headcount11,64411,3372.7%11,3232.8%
Total absolute employee headcount21,16720,5073.2%20,5323.1%
Total FTE employee headcount18,95818,3703.2%18,0944.8%
Number of branch locations1,7601,793-1.8%1,959-10.2%
Number of active Onsite locations1,4401,4161.7%1,28512.1%

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

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

Three-month Period
20222021
Net sales100.0%100.0%
Gross profit46.6%45.4%
Operating and administrative expenses25.5%25.6%
Operating income21.0%19.8%
Net interest expense-0.1%-0.2%
Earnings before income taxes20.9%19.6%

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 March 31, and changes in such sales from the prior period to the ”

Three-month Period
20222021
Net sales$1,704.11,417.0
Percentage change20.3%3.7%
Business days6463
Daily sales$26.622.5
Percentage change18.4%5.3%
Daily sales impact of currency fluctuations-0.1%0.6%

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,3294,68313.8%
Signings per day8374
Weighted FASTBin/FASTVend installations (MEUs; end of period)94,42585,15710.9%
FASTStock sales$198.5$110.579.5%
% of sales11.5%7.7%
FASTBin/FASTVend sales$412.0$301.036.9%

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 March 31:”

Three-month Period
20222021
Fasteners34.3%32.5%
Safety supplies21.0%21.5%
Other product lines44.7%46.0%
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%22.9%
Occupancy-related expenses15% to 20%5.2%
All other operating and administrative expenses10% to 15%25.6%

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

Change Since:Change Since:
Q1 2022Q4 2021Q4 2021Q1 2021Q1 2021
In-market locations (branches & Onsites)11,64411,3372.7%11,3232.8%
Non-in-market selling2,1972,0765.8%1,97711.1%
Selling subtotal13,84113,4133.2%13,3004.1%
Distribution/Transportation2,8562,7404.2%2,6956.0%
Manufacturing6566196.0%6137.0%
Organizational support personel (1)1,6051,5980.4%1,4868.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 March 31:”

Three-month Period
20222021
Net cash provided by operating activities$230.0274.8
Percentage of net earnings85.3%130.5%
Net cash used in investing activities$33.229.9
Percentage of net earnings12.3%14.2%
Net cash used in financing activities$199.5154.2
Percentage of net earnings74.0%73.2%

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

March 31Twelve-month Dollar ChangeTwelve-month Percentage Change
2022202120222022
Accounts receivable, net$1,071.6851.0$220.625.9%
Inventories1,600.81,305.3295.522.6%
Trade working capital$2,672.42,156.3$516.123.9%
Accounts payable$289.9215.1$74.934.8%
Trade working capital, net$2,382.51,941.3$441.322.7%
Net sales in last two months$1,163.6969.1$194.520.1%

Table 25 after “The table below sets forth information regarding purchases of our common stock during the first 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)
January 1-31, 20220$0.0003,200,000
February 1-28, 20220$0.0003,200,000
March 1-31, 20220$0.0003,200,000
Total0$0.0003,200,000

Table 26 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 March 31, 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 March 31, 2022, 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.