← Filings of FAST
Tables in the 10-Q of FASTENAL CO
25 tables with numbers, filed Apr 17, 2020. 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 ↗
| | Page |
| PART I | FINANCIAL INFORMATION | |
| ITEM 1. | FINANCIAL STATEMENTS | |
| Condensed Consolidated Balance Sheets | 1 |
| Condensed Consolidated Statements of Earnings | 2 |
| Condensed Consolidated Statements of Comprehensive Income | 3 |
| Condensed Consolidated Statements of Stockholders' Equity | 4 |
| Condensed Consolidated Statements of Cash Flows | 5 |
First 8 of 17 rows. The CSV has all of them.
Table 2 after “(Amounts in millions except share information)”
Download CSV
| (Unaudited) | | |
| Assets | March 31, 2020 | December 31, 2019 | |
| Current assets: | | | |
| Cash and cash equivalents | $160.7 | | 174.9 |
| Trade accounts receivable, net of allowance for doubtful accounts of $11.6 and $10.9, respectively | 833.9 | | 741.8 |
| Inventories | 1,345.5 | | 1,366.4 |
| Prepaid income taxes | — | | 16.7 |
| Other current assets | 124.2 | | 157.4 |
First 8 of 32 rows. The CSV has all of them.
Table 3 after “(Amounts in millions except earnings per share)”
Download CSV
| (Unaudited) | | |
| Three Months Ended March 31, | | |
| 2020 | 2019 | |
| Net sales | $1,367.0 | | 1,309.3 |
| Cost of sales | 730.2 | | 684.6 |
| Gross profit | 636.8 | | 624.7 |
| Operating and administrative expenses | 365.9 | | 363.6 |
| Gain on sale of property and equipment | (0.4) | | (0.3) |
First 8 of 18 rows. The CSV has all of them.
| (Unaudited) | | |
| Three Months Ended March 31, | | |
| 2020 | 2019 | |
| Net earnings | $202.6 | | 194.1 |
| Other comprehensive (loss) income, net of tax: | | | |
| Foreign currency translation adjustments (net of tax of $0.0 in 2020 and 2019) | (25.0) | | 3.7 |
| Comprehensive income | $177.6 | | 197.8 |
Table 5 after “(Amounts in millions except per share information)”
Download CSV
| (Unaudited) | | |
| Three Months EndedMarch 31, | | |
| 2020 | 2019 | |
| Common stock | | | |
| Balance at beginning of period | $2.9 | | 2.9 |
| Balance at end of period | 2.9 | | 2.9 |
| Additional paid-in capital | | | |
| Balance at beginning of period | 67.2 | | 3.0 |
First 8 of 23 rows. The CSV has all of them.
| (Unaudited) | | |
| Three Months Ended March 31, | | |
| 2020 | 2019 | |
| Cash flows from operating activities: | | | |
| Net earnings | $202.6 | | 194.1 |
| Adjustments to reconcile net earnings to net cash provided by operating activities, net of acquisition: | | | |
| Depreciation of property and equipment | 37.6 | | 35.4 |
| Gain on sale of property and equipment | (0.4) | | (0.3) |
First 8 of 42 rows. The CSV has all of them.
| Three-month Period | | |
| 2020 | 2019 | |
| United States | $1,166.7 | | 1,124.8 |
| Canada and Mexico | 158.4 | | 145.9 |
| North America | 1,325.1 | | 1,270.7 |
| All other foreign countries | 41.9 | | 38.6 |
| Total revenues | $1,367.0 | | 1,309.3 |
| Three-month Period | | |
| 2020 | 2019 | |
| Manufacturing | 67.9% | | 67.8% |
| Non-residential construction | 12.3% | | 12.7% |
| Other | 19.8% | | 19.5% |
| 100.0% | | 100.0% |
| | Three-month Period | | |
| Type | Introduced | 2020 | 2019 | |
| Fasteners(1) | 1967 | 32.9% | | 34.8% |
| Tools | 1993 | 9.4% | | 9.9% |
| Cutting tools | 1996 | 5.4% | | 5.9% |
| Hydraulics & pneumatics | 1996 | 6.6% | | 6.9% |
| Material handling | 1996 | 5.7% | | 5.8% |
| Janitorial supplies | 1996 | 8.3% | | 7.5% |
First 8 of 13 rows. The CSV 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”
Download CSV
| 2020 | 2019 | |
| First quarter | $0.250 | | 0.215 |
| Second quarter | 0.250 | | 0.215 |
| Third quarter | | | 0.220 |
| Fourth quarter | | 0.220 | |
| Total | $0.500 | | 0.870 |
Table 11 after “, and the assumptions used to value these grants. All such grants were effective at the close of business on the date of grant.”
Download CSV
| OptionsGranted | Option Exercise(Strike) Price | | Closing Stock Price on Dateof Grant | | March 31, 2020 | | | | |
| Date of Grant | | | OptionsOutstanding | | OptionsExercisable | | | | | |
| January 2, 2020 | 902,263 | | $38.00 | | | $37.230 | | 900,685 | | 24,964 |
| January 2, 2019 | 1,316,924 | | $26.00 | | | $25.705 | | 1,254,462 | | 29,010 |
| January 2, 2018 | 1,087,936 | | $27.50 | | | $27.270 | | 955,006 | | 324,848 |
| January 3, 2017 | 1,529,578 | | $23.50 | | | $23.475 | | 1,140,844 | | 523,176 |
| April 19, 2016 | 1,690,880 | | $23.00 | | | $22.870 | | 1,202,444 | | 435,348 |
| April 21, 2015 | 1,786,440 | | $21.00 | | | $20.630 | | 798,495 | | 411,775 |
First 8 of 13 rows. The CSV has all of them.
Table 12 after “, and the assumptions used to value these grants. All such grants were effective at the close of business on the date of grant.”
Download CSV
| Date of Grant | Risk-free Interest Rate | Expected Life of Option in Years | | ExpectedDividendYield | | ExpectedStockVolatility | Estimated FairValue of StockOption | |
| January 2, 2020 | 1.7% | | 5.00 | | 2.4% | | 25.70% | $6.81 |
| January 2, 2019 | 2.5% | | 5.00 | | 2.9% | | 23.96% | $4.40 |
| January 2, 2018 | 2.2% | | 5.00 | | 2.3% | | 23.45% | $5.02 |
| January 3, 2017 | 1.9% | | 5.00 | | 2.6% | | 24.49% | $4.20 |
| April 19, 2016 | 1.3% | | 5.00 | | 2.6% | | 26.34% | $4.09 |
| April 21, 2015 | 1.3% | | 5.00 | | 2.7% | | 26.84% | $3.68 |
| April 22, 2014 | 1.8% | | 5.00 | | 2.0% | | 28.55% | $4.79 |
First 8 of 11 rows. The CSV 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”
Download CSV
| Three-month Period | | |
| Reconciliation | 2020 | 2019 | |
| Basic weighted average shares outstanding | 573,904,156 | | 572,172,602 |
| Weighted shares assumed upon exercise of stock options | 1,414,674 | | 821,360 |
| Diluted weighted average shares outstanding | 575,318,830 | | 572,993,962 |
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”
Download CSV
| Three-month Period | | |
| Summary of Anti-dilutive Options Excluded | 2020 | 2019 | |
| Options to purchase shares of common stock | 891,290 | | 2,908,710 |
| Weighted average exercise prices of options | $38.00 | | 26.94 |
Table 15 after “Debt obligations and letters of credit outstanding at the end of each period consisted of the following:”
Download CSV
| March 31, 2020 | December 31, 2019 | |
| Outstanding loans under unsecured revolving credit facility | $320.0 | | 210.0 |
| 2.00% Senior unsecured promissory note payable | 40.0 | | 40.0 |
| 2.45% Senior unsecured promissory note payable | 35.0 | | 35.0 |
| 3.22% Senior unsecured promissory note payable | 60.0 | | 60.0 |
| Total debt | 455.0 | | 345.0 |
| Less: Current portion of debt | (4.9) | | (3.0) |
| Long-term debt | $450.1 | | 342.0 |
First 8 of 9 rows. The CSV 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”
Download CSV
| | | ChangeSince: | | ChangeSince: | | | |
| Q1 2020 | Q4 2019 | Q4 2019 | Q1 2019 | Q1 2019 | | | |
| In-market locations - absolute employee headcount | 14,001 | | 13,977 | 0.2% | | | 14,336 | -2.3% |
| Total absolute employee headcount | 22,131 | | 21,948 | 0.8% | | | 22,205 | -0.3% |
| Number of public branch locations | 2,091 | | 2,114 | -1.1% | | | 2,187 | -4.4% |
| Number of active Onsite locations | 1,179 | | 1,114 | 5.8% | | | 945 | 24.8% |
| Number of in-market locations | 3,270 | | 3,228 | 1.3% | | | 3,132 | 4.4% |
| Industrial vending devices (installed count) (1) | 92,124 | | 89,937 | 2.4% | | | 83,410 | 10.4% |
First 8 of 9 rows. The CSV has all of them.
| Three-month Period | | |
| 2020 | 2019 | |
| Net sales | 100.0% | | 100.0% |
| Gross profit | 46.6% | | 47.7% |
| Operating and administrative expenses | 26.8% | | 27.8% |
| Gain on sale of property and equipment | 0.0% | | 0.0% |
| Operating income | 19.9% | | 20.0% |
| Net interest expense | -0.2% | | -0.3% |
First 8 of 10 rows. The CSV has all of them.
Table 18 after “, and changes in such sales from the prior period to the more recent period:”
Download CSV
| Three-month Period | | |
| 2020 | 2019 | |
| Net sales | $1,367.0 | | 1,309.3 |
| Percentage change | 4.4% | | 10.4% |
| Business days | 64 | | 63 |
| Daily sales | $21.4 | | 20.8 |
| Percentage change | 2.8% | | 12.2% |
| Daily sales impact of currency fluctuations | -0.2% | | -0.5% |
First 8 of 10 rows. The CSV has all of them.
| Three-month Period | | |
| 2020 | 2019 | |
| Fasteners | 32.9% | | 34.8% |
| Safety supplies | 19.8% | | 17.2% |
| Other product lines | 47.3% | | 48.0% |
| 100.0% | | 100.0% |
Table 20 after “The growth in employee-related, occupancy-related, and all other operating and administrative expenses (including the gain on sales of prope”
Download CSV
| Approximate Percentage of Total Operating and Administrative Expenses | Three-month Period |
| 2020 | |
| Employee-related expenses | 65% to 70% | 0.2% |
| Occupancy-related expenses | 15% to 20% | 1.8% |
| All other operating and administrative expenses | 15% to 20% | 0.8% |
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 ”
Download CSV
| | | Change Since: | | Change Since: | | |
| Q1 | Q4 | Q4 | Q1 | Q1 | | |
| 2020 | 2019 | 2019 | 2019 | 2019 | | |
| In-market locations | 12,334 | | 12,236 | 0.8% | | 12,482 | -1.2% |
| Total selling (includes in-market locations) | 14,200 | | 14,060 | 1.0% | | 14,227 | -0.2% |
| Distribution | 2,992 | | 2,895 | 3.4% | | 2,923 | 2.4% |
| Manufacturing | 675 | | 674 | 0.1% | | 700 | -3.6% |
| Administrative | 1,368 | | 1,339 | 2.2% | | 1,275 | 7.3% |
First 8 of 9 rows. The CSV has all of them.
| Three-month Period | | |
| 2020 | 2019 | |
| Net cash provided by operating activities | $241.1 | | 204.9 |
| Percentage of net earnings | 119.0% | | 105.6% |
| Net cash used in investing activities | $171.7 | | 52.7 |
| Percentage of net earnings | 84.7% | | 27.2% |
| Net cash used in financing activities | $78.2 | | 134.9 |
| Percentage of net earnings | 38.6% | | 69.5% |
| March 31 | Twelve-month Dollar Change | Twelve-month Percentage Change | | | | |
| 2020 | | 2019 | | 2020 | 2020 | |
| Accounts receivable, net | $833.9 | | | 793.0 | | $40.9 | 5.2% |
| Inventories | 1,345.5 | | | 1,293.9 | | 51.6 | 4.0% |
| Total | $2,179.4 | | | 2,086.9 | | $92.5 | 4.4% |
| Net sales in last two months | $904.1 | | | 862.4 | | $41.7 | 4.8% |
| (a) | (b) | (c) | (d) | | | |
| Period | Total Number ofSharesPurchased | Average PricePaid per Share | Total Number ofShares Purchasedas Part of PubliclyAnnounced Plansor Programs (1) | Maximum Number (orApproximate DollarValue) of Shares thatMay Yet Be PurchasedUnder the Plans orPrograms (1) | | | |
| January 1-31, 2020 | | 0 | | | $0.00 | 0 | 4,800,000 |
| February 1-29, 2020 | | 0 | | | $0.00 | 0 | 4,800,000 |
| March 1-31, 2020 | | 1,600,000 | | | $32.54 | 1,600,000 | 3,200,000 |
| Total | | 1,600,000 | | | $32.54 | 1,600,000 | 3,200,000 |
| Exhibit Number | Description of Document |
| 3.1 | Restated 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.2 | Restated 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)) |
| 31 | Certifications under Section 302 of the Sarbanes-Oxley Act of 2002 |
| 32 | Certification under Section 906 of the Sarbanes-Oxley Act of 2002 |
| 101 | The following financial statements from the Quarterly Report on Form 10-Q for the quarter ended March 31, 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. |
| 104 | The cover page from the Quarterly Report on Form 10-Q for the quarter ended March 31, 2020, formatted in Inline XBRL. |