tickdelta
tickdelta
Sign in

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

← Filings of FAST

Tables in the 10-Q of FASTENAL CO

25 tables with numbers, filed Oct 16, 2020. 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 ↗

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)
AssetsSeptember 30, 2020December 31, 2019
Current assets:
Cash and cash equivalents$331.8174.9
Trade accounts receivable, net of allowance for credit losses of $11.8 and $10.9, respectively834.5741.8
Inventories1,342.61,366.4
Prepaid income taxes14.616.7
Other current assets123.2157.4

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

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

(Unaudited)(Unaudited)
Nine Months Ended September 30,Three Months Ended September 30,
2020201920202019
Net sales$4,289.34,056.8$1,413.31,379.1
Cost of sales2,340.32,139.8772.7728.0
Gross profit1,949.01,917.0640.6651.1
Operating and administrative expenses1,072.71,099.5351.5369.2
Gain on sale of property and equipment(1.1)(0.8)(1.0)—

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

Table 4 after “(Amounts in millions)”

(Unaudited)(Unaudited)
Nine Months Ended September 30,Three Months Ended September 30,
2020201920202019
Net earnings$663.0612.2$221.5213.5
Other comprehensive (loss) income, net of tax:
Foreign currency translation adjustments (net of tax of $0.0 in 2020 and 2019)(3.4)(4.2)11.1(9.6)
Comprehensive income$659.6608.0$232.6203.9

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

(Unaudited)(Unaudited)
Nine Months Ended September 30,Three Months Ended September 30,
2020201920202019
Common stock
Balance at beginning of period$2.92.9$2.92.9
Balance at end of period2.92.92.92.9
Additional paid-in capital
Balance at beginning of period67.23.044.446.0

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

Table 6 after “(Amounts in millions)”

(Unaudited)
Nine Months Ended September 30,
20202019
Cash flows from operating activities:
Net earnings$663.0612.2
Adjustments to reconcile net earnings to net cash provided by operating activities, net of acquisition:
Depreciation of property and equipment114.0107.8
Gain on sale of property and equipment(1.1)(0.8)

First 8 of 42 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 September 30:”

Nine-month PeriodThree-month Period
2020201920202019
United States$3,681.63,479.7$1,205.81,182.0
Canada and Mexico462.3458.4160.5157.2
North America4,143.93,938.11,366.31,339.2
All other foreign countries145.4118.747.039.9
Total revenues$4,289.34,056.8$1,413.31,379.1

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

Nine-month PeriodThree-month Period
2020201920202019
Manufacturing61.7%67.5%62.7%67.5%
Non-residential construction11.4%12.9%11.2%13.0%
Other26.9%19.6%26.1%19.5%
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 September 30:”

Nine-month PeriodThree-month Period
TypeIntroduced2020201920202019
Fasteners(1)196729.7%34.3%30.5%33.7%
Tools19938.1%10.0%8.5%10.2%
Cutting tools19964.6%5.8%4.7%5.7%
Hydraulics & pneumatics19965.9%6.9%6.1%6.8%
Material handling19965.1%5.9%5.1%5.9%
Janitorial supplies19969.9%7.7%10.7%8.0%

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

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

20202019
First quarter$0.2500.215
Second quarter0.2500.215
Third quarter0.2500.220
Fourth quarter0.2500.220
Total$1.0000.870

Table 11 after “The following tables summarize the details of options granted under our stock option plans that were outstanding as of September 30, 2020, a”

Options GrantedOption Exercise (Strike) PriceClosing Stock Price on Date of GrantSeptember 30, 2020
Date of GrantOptions OutstandingOptions Exercisable
January 2, 2020902,263$38.00$37.230878,19024,964
January 2, 20191,316,924$26.00$25.7051,222,78425,010
January 2, 20181,087,936$27.50$27.270898,184281,144
January 3, 20171,529,578$23.50$23.475996,285385,821
April 19, 20161,690,880$23.00$22.870957,561460,857
April 21, 20151,786,440$21.00$20.630607,209360,577

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 September 30, 2020, a”

Date of GrantRisk-free Interest RateExpected Life of Option in YearsExpected Dividend YieldExpected Stock VolatilityEstimated Fair Value of Stock Option
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
April 21, 20151.3%5.002.7%26.84%$3.68
April 22, 20141.8%5.002.0%28.55%$4.79

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”

Nine-month PeriodThree-month Period
Reconciliation2020201920202019
Basic weighted average shares outstanding573,673,031572,934,475573,913,929573,452,002
Weighted shares assumed upon exercise of stock options1,797,2011,042,8302,203,402914,771
Diluted weighted average shares outstanding575,470,232573,977,305576,117,331574,366,773

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”

Nine-month PeriodThree-month Period
Summary of Anti-dilutive Options Excluded2020201920202019
Options to purchase shares of common stock852,728460,824—553,366
Weighted average exercise prices of options$38.0027.55$—27.59

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

Average Interest Rate at September 30, 2020Debt Outstanding
Maturity DateSeptember 30, 2020December 31, 2019
Unsecured revolving credit facility1.10%November 30, 2023$—210.0
Senior unsecured promissory notes payable, Series A2.00%July 20, 202140.040.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.0—
Senior unsecured promissory notes payable, Series E2.72%May 15, 202750.0—

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

Table 16 after “The table below summarizes our total employee headcount, our investments in in-market locations (defined as the sum of the total number of p”

Change Since:Change Since:Change Since:
Q3 2020Q2 2020Q2 2020Q4 2019Q4 2019Q3 2019Q3 2019
In-market locations - absolute employee headcount12,70812,982-2.1%13,977-9.1%14,128-10.1%
Total absolute employee headcount20,33620,667-1.6%21,948-7.3%21,938-7.3%
Number of public branch locations2,0332,060-1.3%2,114-3.8%2,146-5.3%
Number of active Onsite locations1,2361,2122.0%1,11411.0%1,07614.9%
Number of in-market locations3,2693,272-0.1%3,2281.3%3,2221.5%
Industrial vending devices (installed count) (1)94,39592,6151.9%89,9375.0%88,3276.9%

First 8 of 9 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 Septe”

Nine-month PeriodThree-month Period
2020201920202019
Net sales100.0%100.0%100.0%100.0%
Gross profit45.4%47.3%45.3%47.2%
Operating and administrative expenses25.0%27.1%24.9%26.8%
Gain on sale of property and equipment0.0%0.0%-0.1%0.0%
Operating income20.5%20.2%20.5%20.4%
Net interest expense-0.2%-0.3%-0.2%-0.3%

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

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

Nine-month PeriodThree-month Period
2020201920202019
Net sales$4,289.34,056.8$1,413.31,379.1
Percentage change5.7%8.7%2.5%7.8%
Business days1921916464
Daily sales$22.321.2$22.121.5
Percentage change5.2%8.7%2.5%6.1%
Daily sales impact of currency fluctuations-0.2%-0.4%0.0%-0.2%

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

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

Nine-month PeriodThree-month Period
2020201920202019
Fasteners29.7%34.3%30.5%33.7%
Safety supplies26.1%17.6%23.8%18.2%
Other product lines44.2%48.1%45.7%48.1%
100.0%100.0%100.0%100.0%

Table 20 after “The growth or contraction in employee-related, occupancy-related, and all other operating and administrative expenses (including the gain on”

Approximate Percentage of Total Operating and Administrative ExpensesNine-month PeriodThree-month Period
20202020
Employee-related expenses65% to 70%-2.9%-4.9%
Occupancy-related expenses15% to 20%0.6%0.7%
All other operating and administrative expenses10% to 15%-4.5%-13.6%

Table 21 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:Change Since:Change Since:
Q3 2020Q2 2020Q2 2020Q4 2019Q4 2019Q3 2019Q3 2019
In-market locations11,30211,310-0.1%12,236-7.6%12,417-9.0%
Total selling (includes in-market locations)13,19713,1860.1%14,060-6.1%14,226-7.2%
Distribution2,6382,6150.9%2,895-8.9%2,821-6.5%
Manufacturing618625-1.1%674-8.3%684-9.6%
Administrative1,4091,3881.5%1,3395.2%1,3296.0%
Total17,86217,8140.3%18,968-5.8%19,060-6.3%

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

Nine-month Period
20202019
Net cash provided by operating activities$780.8590.3
Percentage of net earnings117.8%96.4%
Net cash used in investing activities$238.8179.1
Percentage of net earnings36.0%29.3%
Net cash used in financing activities$383.9384.3
Percentage of net earnings57.9%62.8%

Table 23 after “The dollar and percentage change in accounts receivable, net, inventories, and accounts payable from September 30, 2019 to September 30, 202”

September 30Twelve-month Dollar ChangeTwelve-month Percentage Change
2020201920202020
Accounts receivable, net$834.5817.3$17.32.1%
Inventories1,342.61,354.7(12.1)-0.9%
Trade working capital$2,177.12,172.0$5.20.2%
Accounts payable$210.4215.2$(4.8)-2.2%
Trade working capital, net$1,966.71,956.7$10.00.5%
Net sales in last two months$943.8921.5$22.32.4%

Table 24 after “The table below sets forth information regarding purchases of our common stock during the third quarter of 2020:”

(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)
July 1-31, 20200$0.0003,200,000
August 1-31, 20200$0.0003,200,000
September 1-30, 20200$0.0003,200,000
Total0$0.0003,200,000

Table 25 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 (file no. 000-16125))
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 (file no. 000-16125))
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 September 30, 2020, 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 September 30, 2020, formatted in Inline XBRL.