← Filings of FAST
Tables in the 10-Q of FASTENAL CO
28 tables with numbers, filed Jul 16, 2019. 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 No. |
| Part I Financial Information: | |
| Condensed Consolidated Balance Sheets as of June 30, 2019 and December 31, 2018 | 1 |
| Condensed Consolidated Statements of Earnings for the six months and three months ended June 30, 2019 and 2018 | 2 |
| Condensed Consolidated Statements of Comprehensive Income for the six months and three months ended June 30, 2019 and 2018 | 3 |
| Condensed Consolidated Statements of Stockholders' Equity for the six months and three months ended June 30, 2019 and 2018 | 4 |
| Condensed Consolidated Statements of Cash Flows for the six months ended June 30, 2019 and 2018 | 5 |
| Notes to Condensed Consolidated Financial Statements | 6 |
First 8 of 16 rows. The CSV has all of them.
Table 2 after “(Amounts in millions except share information)”
Download CSV
| (Unaudited) | | |
| Assets | June 30, 2019 | December 31, 2018 | |
| Current assets: | | | |
| Cash and cash equivalents | $175.0 | | 167.2 |
| Trade accounts receivable, net of allowance for doubtful accounts of $11.4 and $12.8, respectively | 819.8 | | 714.3 |
| Inventories | 1,345.7 | | 1,278.7 |
| Prepaid income taxes | 4.0 | | 9.0 |
| Other current assets | 123.8 | | 147.0 |
First 8 of 31 rows. The CSV has all of them.
Table 3 after “(Amounts in millions except earnings per share)”
Download CSV
| (Unaudited) | (Unaudited) | | | | |
| Six Months Ended June 30, | Three Months Ended June 30, | | | | |
| 2019 | 2018 | | 2019 | 2018 | |
| Net sales | $2,677.7 | | 2,453.7 | | $1,368.4 | 1,267.9 |
| Cost of sales | 1,411.8 | | 1,258.4 | | 727.2 | 650.2 |
| Gross profit | 1,265.9 | | 1,195.3 | | 641.2 | 617.7 |
| Operating and administrative expenses | 730.3 | | 692.0 | | 366.7 | 349.3 |
| Gain on sale of property and equipment | (0.8) | | (0.2) | | (0.5) | (0.6) |
First 8 of 18 rows. The CSV has all of them.
| (Unaudited) | (Unaudited) | | | | |
| Six Months Ended June 30, | Three Months Ended June 30, | | | | |
| 2019 | 2018 | | 2019 | 2018 | |
| Net earnings | $398.7 | | 385.5 | | $204.6 | 211.2 |
| Other comprehensive income (loss), net of tax: | | | | | | |
| Foreign currency translation adjustments (net of tax of $0.0 in 2019 and 2018) | 5.4 | | (10.8) | | 1.7 | (12.8) |
| Comprehensive income | $404.1 | | 374.7 | | $206.3 | 198.4 |
Table 5 after “(Amounts in millions except per share information)”
Download CSV
| (Unaudited) | (Unaudited) | | | | |
| Six Months EndedJune 30, | Three Months EndedJune 30, | | | | |
| 2019 | 2018 | | 2019 | 2018 | |
| Common stock | | | | | | |
| Balance at beginning of period | $2.9 | | 2.9 | | $2.9 | 2.9 |
| Balance at end of period | 2.9 | | 2.9 | | 2.9 | 2.9 |
| Additional paid-in capital | | | | | | |
| Balance at beginning of period | 3.0 | | 8.5 | | 22.7 | 13.7 |
First 8 of 24 rows. The CSV has all of them.
| (Unaudited) | | |
| Six Months Ended June 30, | | |
| 2019 | 2018 | |
| Cash flows from operating activities: | | | |
| Net earnings | $398.7 | | 385.5 |
| Adjustments to reconcile net earnings to net cash provided by operating activities: | | | |
| Depreciation of property and equipment | 71.5 | | 65.5 |
| Gain on sale of property and equipment | (0.8) | | (0.2) |
First 8 of 40 rows. The CSV has all of them.
| Six-month Period | Three-month Period | | | | |
| 2019 | 2018 | | 2019 | 2018 | |
| United States | $2,297.7 | | 2,121.1 | | $1,172.9 | 1,092.6 |
| All foreign countries | 380.0 | | 332.6 | | 195.5 | 175.3 |
| Total revenues | $2,677.7 | | 2,453.7 | | $1,368.4 | 1,267.9 |
| Six-month Period | Three-month Period | | | | |
| 2019 | 2018 | | 2019 | 2018 | |
| Manufacturing | 67.5% | | 66.8% | | 67.3% | 66.6% |
| Non-residential construction | 12.9% | | 12.9% | | 13.2% | 13.2% |
| Other | 19.6% | | 20.3% | | 19.5% | 20.2% |
| 100.0% | | 100.0% | | 100.0% | 100.0% |
| | Six-month Period | Three-month Period | | | | |
| Type | Introduced | 2019 | 2018 | | 2019 | 2018 | |
| Fasteners(1) | 1967 | 34.7% | | 35.2% | | 34.5% | 35.4% |
| Tools | 1993 | 9.9% | | 10.0% | | 9.8% | 9.9% |
| Cutting tools | 1996 | 5.8% | | 5.7% | | 5.8% | 5.6% |
| Hydraulics & pneumatics | 1996 | 6.9% | | 6.9% | | 6.8% | 6.9% |
| Material handling | 1996 | 5.9% | | 5.8% | | 5.9% | 5.9% |
| Janitorial supplies | 1996 | 7.6% | | 7.5% | | 7.7% | 7.6% |
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
| 2019 | 2018 | |
| First quarter | $0.215 | | 0.185 |
| Second quarter | 0.215 | | 0.185 |
| Third quarter | 0.220 | | 0.200 |
| Fourth quarter | | 0.200 | |
| Total | $0.650 | | 0.770 |
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 | | June 30, 2019 | | | | |
| Date of Grant | | | OptionsOutstanding | | OptionsExercisable | | | | | |
| January 2, 2019 | 1,316,924 | | $26.00 | | | $25.705 | | 1,303,670 | | 29,010 |
| January 2, 2018 | 1,087,936 | | $27.50 | | | $27.270 | | 1,033,248 | | 42,370 |
| January 3, 2017 | 1,529,578 | | $23.50 | | | $23.475 | | 1,247,616 | | 371,622 |
| April 19, 2016 | 1,690,880 | | $23.00 | | | $22.870 | | 1,286,260 | | 327,170 |
| April 21, 2015 | 1,786,440 | | $21.00 | | | $20.630 | | 975,939 | | 463,383 |
| April 22, 2014 | 1,910,000 | | $28.00 | | | $25.265 | | 743,716 | | 494,356 |
First 8 of 12 rows. The CSV has all of them.
| Date of Grant | Risk-free Interest Rate | Expected Life of Option in Years | | ExpectedDividendYield | | ExpectedStockVolatility | Estimated FairValue of StockOption | |
| 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 |
| April 16, 2013 | 0.7% | | 5.00 | | 1.6% | | 37.42% | $6.33 |
First 8 of 10 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
| Six-month Period | Three-month Period | | | | |
| Reconciliation | 2019 | 2018 | | 2019 | 2018 | |
| Basic weighted average shares outstanding | 572,669,693 | | 574,783,228 | | 573,159,138 | 574,280,852 |
| Weighted shares assumed upon exercise of stock options | 1,105,366 | | 335,708 | | 1,392,211 | 234,122 |
| Diluted weighted average shares outstanding | 573,775,059 | | 575,118,936 | | 574,551,349 | 574,514,974 |
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
| Six-month Period | Three-month Period | | | | |
| Summary of Anti-dilutive Options Excluded | 2019 | 2018 | | 2019 | 2018 | |
| Options to purchase shares of common stock | 450,960 | | 5,581,260 | | — | 6,113,644 |
| Weighted average exercise prices of options | $27.53 | | 26.43 | | $— | 26.09 |
Table 15 after “The cost components of our operating leases were as follows for the periods ended June 30, 2019:”
Download CSV
| Six-month Period | Three-month Period | | | | | | | | |
| Leased Facilities and Equipment | Leased Vehicles | | Total | Leased Facilities and Equipment | Leased Vehicles | | Total | | |
| Operating lease cost | $51.8 | | 6.6 | | 58.4 | | $26.1 | | 3.5 | 29.6 |
| Variable lease cost | 5.5 | | 1.0 | | 6.5 | | 2.2 | | 0.6 | 2.8 |
| Short-term lease cost | — | | 13.5 | | 13.5 | | — | | 6.2 | 6.2 |
| Total | $57.3 | | 21.1 | | 78.4 | | $28.3 | | 10.3 | 38.6 |
Table 16 after “Maturities of our lease liabilities for all operating leases are as follows as of June 30, 2019:”
Download CSV
| Leased Facilities and Equipment | Leased Vehicles | | Total | |
| 2019 | $42.9 | | 6.2 | | 49.1 |
| 2020 | 77.6 | | 9.2 | | 86.8 |
| 2021 | 52.0 | | 5.0 | | 57.0 |
| 2022 | 29.5 | | 2.6 | | 32.1 |
| 2023 | 15.4 | | 0.9 | | 16.3 |
| 2024 and thereafter | 7.2 | | 0.2 | | 7.4 |
| Total lease payments | $224.6 | | 24.1 | | 248.7 |
First 8 of 10 rows. The CSV has all of them.
Table 17 after “The weighted average remaining lease terms and discount rates for all of our operating leases were as follows as of June 30, 2019:”
Download CSV
| Remaining lease term and discount rate: | June 30, 2019 |
| Weighted average remaining lease term (years) | |
| Leased facilities and equipment | 3.08 |
| Leased vehicles | 2.63 |
| Weighted average discount rate | |
| Lease facilities and equipment | 3.36% |
| Leased vehicles | 3.21% |
Table 18 after “Debt obligations and letters of credit outstanding at the end of each period consisted of the following:”
Download CSV
| June 30, 2019 | December 31, 2018 | |
| Outstanding loans under unsecured revolving credit facility | $365.0 | | 365.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 | 500.0 | | 500.0 |
| Less: Current portion of debt | (3.0) | | (3.0) |
| Long-term debt | $497.0 | | 497.0 |
First 8 of 9 rows. The CSV has all of them.
Table 19 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: | | Change Since: | | | Change Since: | | | | |
| Q2 2019 | Q1 2019 | Q1 2019 | Q4 2018 | Q4 2018 | | Q2 2018 | Q2 2018 | | | | |
| In-market locations - absolute employee headcount | 14,372 | | 14,336 | 0.3% | | | 14,015 | | 2.5% | | 13,688 | 5.0% |
| Total absolute employee headcount (1) | 22,232 | | 22,205 | 0.1% | | | 21,644 | | 2.7% | | 20,855 | 6.6% |
| Number of public branch locations | 2,165 | | 2,187 | -1.0% | | | 2,227 | | -2.8% | | 2,290 | -5.5% |
| Number of active Onsite locations | 1,026 | | 945 | 8.6% | | | 894 | | 14.8% | | 761 | 34.8% |
| Number of in-market locations | 3,191 | | 3,132 | 1.9% | | | 3,121 | | 2.2% | | 3,051 | 4.6% |
| Industrial vending devices (installed count) (2) | 85,871 | | 83,410 | 3.0% | | | 81,137 | | 5.8% | | 76,069 | 12.9% |
First 8 of 9 rows. The CSV has all of them.
| Six-month Period | Three-month Period | | | | |
| 2019 | 2018 | | 2019 | 2018 | |
| Net sales | 100.0% | | 100.0% | | 100.0% | 100.0% |
| Gross profit | 47.3% | | 48.7% | | 46.9% | 48.7% |
| Operating and administrative expenses | 27.3% | | 28.2% | | 26.8% | 27.6% |
| Gain on sale of property and equipment | 0.0% | | 0.0% | | 0.0% | -0.1% |
| Operating income | 20.0% | | 20.5% | | 20.1% | 21.2% |
| Net interest expense | -0.3% | | -0.2% | | -0.3% | -0.2% |
First 8 of 10 rows. The CSV has all of them.
Table 21 after “, and changes in such sales from the prior period to the more recent period:”
Download CSV
| Six-month Period | Three-month Period | | | | |
| 2019 | 2018 | | 2019 | 2018 | |
| Net sales | $2,677.7 | | 2,453.7 | | $1,368.4 | 1,267.9 |
| Percentage change | 9.1% | | 13.1% | | 7.9% | 13.1% |
| Business days | 127 | | 128 | | 64 | 64 |
| Daily sales | $21.1 | | 19.2 | | $21.4 | 19.8 |
| Percentage change | 10.0% | | 13.1% | | 7.9% | 13.1% |
| Daily sales impact of currency fluctuations | -0.5% | | 0.5% | | -0.4% | 0.5% |
First 8 of 10 rows. The CSV has all of them.
| Six-month Period | Three-month Period | | | | |
| 2019 | 2018 | | 2019 | 2018 | |
| Fastener product line | 34.7% | | 35.2% | | 34.5% | 35.4% |
| Other product lines | 65.3% | | 64.8% | | 65.5% | 64.6% |
| 100.0% | | 100.0% | | 100.0% | 100.0% |
Table 23 after “The growth (contraction) in employee-related, occupancy-related, and all other operating and administrative expenses (including the gain on ”
Download CSV
| Approximate Percentage of Total Operating and Administrative Expenses | Six-month Period | | Three-month Period | |
| 2019 | | 2019 | | |
| Employee-related expenses | 65% to 70% | 6.9% | | | 6.8% |
| Occupancy-related expenses | 15% to 20% | 2.4% | | | 2.5% |
| All other operating and administrative expenses | 15% to 20% | 2.1% | | | -0.6% |
Table 24 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: | | Change Since: | | | |
| Q2 | Q1 | Q1 | Q4 | Q4 | Q2 | Q2 | | | |
| 2019 | 2019 | 2019 | 2018(1) | 2018 | 2018 | 2018 | | | |
| In-market locations | 12,903 | | 12,482 | 3.4% | | 12,211 | | 5.7% | 12,214 | 5.6% |
| Total selling (includes in-market locations) | 14,687 | | 14,227 | 3.2% | | 13,943 | | 5.3% | 13,926 | 5.5% |
| Distribution | 2,954 | | 2,923 | 1.1% | | 2,834 | | 4.2% | 2,672 | 10.6% |
| Manufacturing | 704 | | 700 | 0.6% | | 693 | | 1.6% | 652 | 8.0% |
| Administrative | 1,315 | | 1,275 | 3.1% | | 1,234 | | 6.6% | 1,194 | 10.1% |
First 8 of 9 rows. The CSV has all of them.
| Six-month Period | | |
| 2019 | 2018 | |
| Net cash provided by operating activities | $333.0 | | 311.6 |
| Percentage of net earnings | 83.5% | | 80.8% |
| Net cash used in investing activities | $119.6 | | 53.9 |
| Net cash used in financing activities | $206.0 | | 237.5 |
| June 30 | Twelve-month Dollar Change | Twelve-month Percentage Change | | | | |
| 2019 | | 2018 | | 2019 | 2019 | |
| Accounts receivable, net | $819.8 | | | 733.7 | | $86.1 | 11.7% |
| Inventories | 1,345.7 | | | 1,163.4 | | 182.3 | 15.7% |
| Total | $2,165.6 | | | 1,897.1 | | $268.4 | 14.1% |
| Net sales in last two months | $907.7 | | | 858.6 | | $49.1 | 5.7% |
| (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) | | | |
| April 1-30, 2019 | | 0 | | | $0.00 | 0 | 4,800,000 |
| May 1-31, 2019 | | 0 | | | $0.00 | 0 | 4,800,000 |
| June 1-30, 2019 | | 0 | | | $0.00 | 0 | 4,800,000 |
| Total | | 0 | | | $0.00 | 0 | 4,800,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.INS | XBRL Instance Document - the instance document does not appear in the Interactive Data File because its XBRL tags are embedded within the Inline XBRL document. |
| 101.SCH | XBRL Taxonomy Extension Schema Document |
| 101.CAL | XBRL Taxonomy Calculation Linkbase Document |
First 8 of 11 rows. The CSV has all of them.