← Filings of FAST
Tables in the 10-Q of FASTENAL CO
23 tables with numbers, filed Oct 16, 2017. 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 ↗
| Page No. |
| Part I Financial Information: | |
| Condensed Consolidated Balance Sheets as of September 30, 2017 and December 31, 2016 | 1 |
| Condensed Consolidated Statements of Earnings for the nine months and three months ended September 30, 2017 and 2016 | 2 |
| Condensed Consolidated Statements of Comprehensive Income for the nine months and three months ended September 30, 2017 and 2016 | 3 |
| Condensed Consolidated Statements of Cash Flows for the nine months ended September 30, 2017 and 2016 | 4 |
| Notes to Condensed Consolidated Financial Statements | 5 |
| Management's Discussion and Analysis of Financial Condition and Results of Operations | 11 |
First 8 of 15 rows. The download has all of them.
Table 2 after “(Amounts in millions except share and per share information)”
| (Unaudited) | | |
| Assets | September 30, 2017 | December 31, 2016 | |
| Current assets: | | | |
| Cash and cash equivalents | $133.4 | | 112.7 |
| Trade accounts receivable, net of allowance for doubtful accounts of $11.4 and $11.2, respectively | 632.1 | | 499.7 |
| Inventories | 1,047.0 | | 993.0 |
| Prepaid income taxes | — | | 12.9 |
| Other current assets | 117.7 | | 102.5 |
First 8 of 29 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, | | | | |
| 2017 | 2016 | | 2017 | 2016 | |
| Net sales | $3,302.0 | | 3,014.1 | | $1,132.8 | 1,013.1 |
| Cost of sales | 1,669.6 | | 1,521.2 | | 576.9 | 513.3 |
| Gross profit | 1,632.4 | | 1,492.9 | | 555.9 | 499.8 |
| Operating and administrative expenses | 955.0 | | 879.9 | | 327.5 | 297.1 |
| Gain on sale of property and equipment | (1.1) | | (0.3) | | (0.1) | (0.2) |
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, | | | | |
| 2017 | 2016 | | 2017 | 2016 | |
| Net earnings | $426.2 | | 384.6 | | $143.1 | 126.9 |
| Other comprehensive income, net of tax: | | | | | | |
| Foreign currency translation adjustments (net of tax of $0.0 in 2017 and 2016) | 19.2 | | 9.3 | | 8.2 | (2.9) |
| Comprehensive income | $445.4 | | 393.9 | | $151.3 | 124.0 |
Table 5 after “(Amounts in millions)”
| (Unaudited) | | |
| Nine Months Ended September 30, | | |
| 2017 | 2016 | |
| Cash flows from operating activities: | | | |
| Net earnings | $426.2 | | 384.6 |
| Adjustments to reconcile net earnings to net cash provided by operating activities, net of acquisition: | | | |
| Depreciation of property and equipment | 92.3 | | 74.5 |
| Gain on sale of property and equipment | (1.1) | | (0.3) |
First 8 of 41 rows. The download has all of them.
Table 6 after “The fair value of the assets acquired and liabilities assumed is summarized below.”
| Current assets | $21.7 |
| Property and equipment | 0.9 |
| Identifiable intangible assets | 20.1 |
| Current liabilities | (1.8) |
| Total identifiable net assets | 40.9 |
| Goodwill | 18.4 |
| Total fair value of assets acquired and liabilities assumed | $59.3 |
Table 7 after “The amount of net sales and net earnings of the acquired business included in our condensed consolidated statement of earnings for the perio”
| Nine-month Period | Three-month Period | | | | |
| 2017 | 2016 | 2017 | 2016 | | |
| Net sales | $40.4 | | 36.7 | | $13.4 | 12.7 |
| Net earnings | $4.6 | | 3.7 | | $1.4 | 1.2 |
Table 8 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”
| 2017 | 2016 | |
| First quarter | $0.32 | | 0.30 |
| Second quarter | 0.32 | | 0.30 |
| Third quarter | 0.32 | | 0.30 |
| Fourth quarter | 0.32 | | 0.30 |
| Total | $1.28 | | 1.20 |
Table 9 after “, and the assumptions used to value these grants. All such grants were effective at the close of business on the date of grant.”
| OptionsGranted | OptionExercise(Strike)Price | | ClosingStock Priceon Dateof Grant | | September 30, 2017 | | | | |
| Date of Grant | | | OptionsOutstanding | | OptionsExercisable | | | | | |
| January 3, 2017 | 764,789 | | $47.00 | | | $46.95 | | 725,542 | | — |
| April 19, 2016 | 845,440 | | $46.00 | | | $45.74 | | 757,522 | | — |
| April 21, 2015 | 893,220 | | $42.00 | | | $41.26 | | 700,746 | | — |
| April 22, 2014 | 955,000 | | $56.00 | | | $50.53 | | 572,500 | | 116,250 |
| April 16, 2013 | 205,000 | | $54.00 | | | $49.25 | | 104,250 | | 57,250 |
| April 17, 2012 | 1,235,000 | | $54.00 | | | $49.01 | | 957,938 | | 776,103 |
First 8 of 12 rows. The download has all of them.
Table 10 after “(Unaudited)”
| Date of Grant | Risk-free Interest Rate | Expected Life of Option in Years | | ExpectedDividendYield | | ExpectedStockVolatility | Estimated FairValue of StockOption | |
| January 3, 2017 | 1.9% | | 5.00 | | 2.6% | | 24.49% | $8.40 |
| April 19, 2016 | 1.3% | | 5.00 | | 2.6% | | 26.34% | $8.18 |
| April 21, 2015 | 1.3% | | 5.00 | | 2.7% | | 26.84% | $7.35 |
| April 22, 2014 | 1.8% | | 5.00 | | 2.0% | | 28.55% | $9.57 |
| April 16, 2013 | 0.7% | | 5.00 | | 1.6% | | 37.42% | $12.66 |
| April 17, 2012 | 0.9% | | 5.00 | | 1.4% | | 39.25% | $13.69 |
| April 19, 2011 | 2.1% | | 5.00 | | 1.6% | | 39.33% | $11.20 |
First 8 of 10 rows. The download has all of them.
Table 11 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 Period | Three-month Period | | | | |
| Reconciliation | 2017 | 2016 | | 2017 | 2016 | |
| Basic weighted average shares outstanding | 288,451,470 | | 288,907,934 | | 287,456,943 | 288,995,492 |
| Weighted shares assumed upon exercise of stock options | 140,104 | | 227,908 | | 121,100 | 154,114 |
| Diluted weighted average shares outstanding | 288,591,574 | | 289,135,842 | | 287,578,043 | 289,149,606 |
Table 12 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 Period | Three-month Period | | | | |
| Summary of Anti-dilutive Options Excluded | 2017 | 2016 | | 2017 | 2016 | |
| Options to purchase shares of common stock | 3,881,605 | | 3,061,217 | | 3,848,126 | 3,335,439 |
| Weighted average exercise price of options | $49.21 | | 50.17 | | $49.18 | 49.67 |
Table 13 after “Debt obligations and letters of credit outstanding at the end of each period consisted of the following:”
| September 30, 2017 | December 31, 2016 | |
| Outstanding loans under unsecured revolving credit facility | $300.0 | | 305.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 | | — |
| Note payable under asset purchase agreement | 5.0 | | 10.0 |
| Total debt | 440.0 | | 390.0 |
| Less: Current portion of debt | (8.0) | | (10.5) |
First 8 of 10 rows. The download has all of them.
Table 14 after “The table below summarizes our branch and Onsite employee count and our total employee count at the end of the periods presented, and change”
| | | | Change Since: | | Change Since: | | |
| Q3 2017 | Q4 2016 | | Q4 2016 | Q3 2016 | Q3 2016 | | |
| End of period total in-market units (1) employee count | 13,298 | | 12,966 | | 2.6% | | 13,097 | 1.5% |
| End of period total employee count | 20,242 | | 19,624 | | 3.1% | | 19,864 | 1.9% |
| Number of public branch locations | 2,418 | | 2,503 | | -3.4% | | 2,545 | -5.0% |
| Number of active Onsite locations | 555 | | 401 | | 38.4% | | 376 | 47.6% |
| Number of in-market units (1) | 2,973 | | 2,904 | | 2.4% | | 2,921 | 1.8% |
| Industrial vending machines (installed device count) (2) | 69,058 | | 62,822 | | 9.9% | | 60,400 | 14.3% |
First 8 of 9 rows. The download has all of them.
| Nine-month Period | Three-month Period | | | | |
| 2017 | 2016 | | 2017 | 2016 | |
| Net sales | 100.0% | | 100.0% | | 100.0% | 100.0% |
| Gross profit | 49.4% | | 49.5% | | 49.1% | 49.3% |
| Operating and administrative expenses | 28.9% | | 29.2% | | 28.9% | 29.3% |
| Gain on sale of property and equipment | 0.0% | | 0.0% | | 0.0% | 0.0% |
| Operating income | 20.5% | | 20.3% | | 20.2% | 20.0% |
| Net interest expense | -0.2% | | -0.2% | | -0.2% | -0.2% |
First 8 of 10 rows. The download has all of them.
Table 16 after “, and changes in such sales from the prior period to the more recent period:”
| Nine-month Period | Three-month Period | | | | |
| 2017 | 2016 | | 2017 | 2016 | |
| Net sales | 3,302.0 | | 3,014.1 | | 1,132.8 | 1,013.1 |
| Percentage change | 9.6% | | 2.3% | | 11.8% | 1.8% |
| Business days | 191 | | 192 | | 63 | 64 |
| Daily sales | 17.3 | | 15.7 | | 18.0 | 15.8 |
| Percentage change | 10.1% | | 1.8% | | 13.6% | 1.8% |
| Impact of currency fluctuations | 0.0% | | -0.4% | | 0.3% | -0.1% |
First 8 of 9 rows. The download has all of them.
| Nine-month Period | Three-month Period | | | | |
| 2017 | 2016 | | 2017 | 2016 | |
| Fastener product line | 35.8% | | 36.9% | | 35.6% | 36.1% |
| Other product lines | 64.2% | | 63.1% | | 64.4% | 63.9% |
| 100.0% | | 100.0% | | 100.0% | 100.0% |
Table 18 after “The growth in employee-related, occupancy-related, and selling transportation expenses (the three largest components of our operating and ad”
| Approximate Percentage of Total Operating and Administrative Expenses | Nine-month Period | | Three-month Period | |
| 2017 | | 2017 | | |
| Employee-related expenses | 65% to 70% | 8.4% | | | 12.3% |
| Occupancy-related expenses | 15% to 20% | 2.0% | | | 1.5% |
| Selling transportation expenses | 5% | 8.4% | | | 2.7% |
Table 19 after “The table below summarizes our FTE headcount at the end of the periods presented and changes in such headcount from the end of the prior per”
| | | | Change Since: | | Change Since: | | |
| Q3 | Q4 | | Q4 | Q3 | Q3 | | |
| 2017 | 2016 | | 2016 | 2016 | 2016 | | |
| Branch and Onsite based FTE headcount | 11,480 | | 10,797 | | 6.3% | | 11,175 | 2.7% |
| Total selling (includes branch and Onsite) | 13,118 | | 12,325 | | 6.4% | | 12,725 | 3.1% |
| Distribution | 2,502 | | 2,330 | | 7.4% | | 2,449 | 2.2% |
| Manufacturing | 604 | | 571 | | 5.8% | | 573 | 5.4% |
| Administrative | 1,105 | | 1,039 | | 6.4% | | 1,064 | 3.9% |
First 8 of 9 rows. The download has all of them.
| Nine-month Period | | |
| 2017 | 2016 | |
| Net cash provided by operating activities | $455.9 | | 386.9 |
| Percentage of net earnings | 107.0% | | 100.6% |
| Net cash used in investing activities | $138.2 | | 157.6 |
| Net cash used in financing activities | $301.2 | | 214.4 |
Table 21 after “were as follows:”
| September 30: | Twelve-month Dollar Change | Twelve-month Percentage Change | | | | |
| 2017 | | 2016 | | 2017 | 2017 | |
| Accounts receivable, net | $632.1 | | | 543.7 | | $88.3 | 16.2% |
| Inventories | 1,047.0 | | | 966.9 | | 80.1 | 8.3% |
| Total | $1,679.1 | | | 1,510.7 | | $168.4 | 11.1% |
| Net sales in last two months | $782.8 | | | 703.2 | | $79.6 | 11.3% |
| (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) | | | |
| July 1-31, 2017 | | 600,000 | | | $43.03 | 600,000 | 4,400,000 |
| August 1-31, 2017 | | 0 | | | $0.00 | 0 | 4,400,000 |
| September 1-30, 2017 | | 0 | | | $0.00 | 0 | 4,400,000 |
| Total | | 600,000 | | | $43.03 | 600,000 | 4,400,000 |
Table 23 after “INDEX TO EXHIBITS”
| 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 10-Q for the quarter ended March 31, 2012 (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 October 15, 2010 (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 |
| 101.SCH | XBRL Taxonomy Extension Schema Document |
| 101.CAL | XBRL Taxonomy Calculation Linkbase Document |
First 8 of 11 rows. The download has all of them.