# Fastenal (FAST) Financial Model Free Excel 3-statement financial model and company analysis for Fastenal. - Canonical: https://finamodel.com/companies/fastenal - Industry: Industrial Equipment - Downloadable model: Yes - Excel download: https://finamodel.com/company-models/FAST.xlsx ## Model Purpose This model forecasts Fastenal’s cash flow generation and intrinsic equity value to help an equity research analyst determine if the company's premium valuation multiple is justified by its Onsite expansion and digital footprint growth. ## Company Overview Fastenal Company is a leading North American wholesale distributor of industrial and construction supplies, operating through a dense network of branches and customer-specific Onsite locations. The company provides supply chain solutions, inventory management, and a captive logistics fleet to ensure product availability for manufacturing and construction clients. - **Business Segments:** Fasteners (30.5%), Safety Supplies (22.2%), Other Products (47.3%). - **Key Geographies:** Primarily North America (United States, Canada, Mexico), with a growing but small presence in Europe and Asia. - **Business Model:** Asset-heavy in working capital (high inventory levels to guarantee availability) but highly efficient in capital return, leveraging Fastenal Managed Inventory (FMI) technology like FASTVend and FASTBin. - **Competitive Position:** A market leader in a highly fragmented industrial distribution industry, competing primarily with W.W. Grainger, MSC Industrial Direct, and local distributors. - **Recent Major Events:** The company has aggressively shifted its growth strategy from opening traditional public branches to embedding dedicated "Onsite" locations directly within customer facilities, driving a structural shift in customer mix and margin profile. ## Revenue Deep Dive Fastenal evaluates revenue growth using a Daily Sales Rate (DSR) to normalise for the exact number of business days in a given period. ### Fasteners - **Segment Name:** Fasteners - **Revenue Driver Formula:** (Prior Year Fasteners Daily Sales Rate x (1 + DSR Growth)) x Business Days in Period - **Historical Growth Rate:** 2% to 6% CAGR. - **Key Growth Levers and Headwinds:** Highly correlated with the Purchasing Managers' Index (PMI) and heavy manufacturing activity. Pricing power is a key lever during inflationary periods. - **Pricing Dynamics:** Spot pricing for smaller accounts; contractual pricing with periodic adjustments for large national accounts. - **Revenue Recognition:** Recognised upon delivery or transfer of control at the branch or Onsite location. - **Seasonality:** Q4 is typically the weakest quarter due to holiday-related plant shutdowns and fewer business days. ### Safety Supplies - **Segment Name:** Safety Supplies - **Revenue Driver Formula:** (Prior Year Safety Daily Sales Rate x (1 + DSR Growth)) x Business Days in Period - **Historical Growth Rate:** 7% to 10% CAGR. - **Key Growth Levers and Headwinds:** Driven by industrial headcount, safety regulations, and the rollout of FASTVend machines which heavily dispense personal protective equipment (PPE). - **Pricing Dynamics:** Highly competitive, though vending solutions create sticky customer relationships that reduce price sensitivity. - **Revenue Recognition:** Point of sale or upon dispensing from an FMI device. - **Seasonality:** Mirrors broader industrial production, with slight upticks during severe weather events. ### Other Products - **Segment Name:** Other (includes tools, janitorial supplies, cutting tools, hydraulics) - **Revenue Driver Formula:** (Prior Year Other Daily Sales Rate x (1 + DSR Growth)) x Business Days in Period - **Historical Growth Rate:** 8% to 12% CAGR. - **Key Growth Levers and Headwinds:** Cross-selling to existing fastener customers and expanding the indirect materials offering at Onsite locations. - **Pricing Dynamics:** Varies widely by product category; generally lower margin than proprietary fasteners. - **Revenue Recognition:** Point of sale. - **Seasonality:** Broadly tracks the overall business cycle. ## Cost Structure ### Variable Costs / COGS - **Line-by-line breakdown:** Product purchase costs, inbound freight, import duties, and purchasing department costs. - **Gross margin range:** 44.5% to 46.0% over the last 5 years. - **Key input costs:** Steel prices, global shipping rates, and tariffs. - **How COGS scales:** Scales linearly with volume, but mix shifts heavily influence the consolidated margin. Onsite and non-fastener sales carry lower gross margins than traditional branch fastener sales. ### Operating Expenses - **R&D:** Not material; Fastenal does not capitalise significant R&D. - **SG&A:** Consists of branch and Onsite employee payroll, occupancy costs (rent and utilities for branches), IT expenses, and costs to operate the captive logistics fleet. SG&A typically runs at 24.5% to 26.0% of sales. - **Depreciation & Amortisation:** Approximately 1.5% to 2.0% of revenue, primarily related to FMI equipment, hub automation, and fleet vehicles. - **Stock-Based Compensation:** Minimal compared to tech peers, historically less than 0.5% of revenue. - **Restructuring:** Rare. The company prefers to close underperforming branches organically at lease expiration rather than taking large one-time charges. ### Margin Profile - **Gross margin:** 44.5% to 46.0%. Currently facing slight compression due to the mix shift toward larger national accounts. - **Operating margin:** 19.5% to 21.0%. - **Net margin:** 14.5% to 15.5%. - **Margin trend:** Gross margins are slightly compressing due to customer mix, but operating margins remain stable as the company leverages SG&A over higher volumes. ## Balance Sheet Structure - **Total assets:** Approximately $4.5 billion to $5.0 billion. - **Key asset categories:** Inventory is the largest asset, followed by property and equipment, and accounts receivable. - **Goodwill & intangibles:** Negligible (less than 2% of assets), as Fastenal is an organic grower. - **Working capital profile:** - **DSO:** 40 to 45 days. - **DIO:** 150 to 165 days. Fastenal intentionally holds massive inventory to guarantee product availability. - **DPO:** 25 to 35 days. - **Net working capital as % of revenue:** 25% to 30%. - **Working capital dynamic:** Positive working capital. Growth consumes cash because the company must forward-deploy inventory into new Onsite locations and regional hubs. - **PP&E:** Consists of regional distribution centres (hubs), captive truck fleet, branch build-outs, and capitalised FMI vending devices. - **Right-of-use assets:** Material, representing operating leases for over 1,500 branch locations and distribution centres. ## Capital Expenditure & Investment - **Capex as % of revenue:** 2.5% to 3.5% (typically $210 million to $285 million annually). - **Maintenance vs. growth split:** Approximately 40% maintenance (fleet replacement, facility upkeep) and 60% growth (new FMI devices, hub automation, IT upgrades). - **Major capex programmes:** The continued rollout of FASTBin and FASTVend devices, and the expansion of automated picking technology in regional distribution centres. - **Capitalised software:** Minor, mostly related to customer master data management systems. - **M&A pattern:** Strictly organic grower. Acquisitions are extremely rare and immaterial. ## Debt & Capital Structure - **Total debt:** Very low, typically fluctuating between $200 million and $500 million depending on working capital timing and special dividends. - **Debt/EBITDA ratio:** Consistently below 0.5x. - **Credit rating:** Unrated by major agencies due to lack of public bond issuance. - **Key debt instruments:** Unsecured revolving credit facility. - **Maturity profile:** Short-term, as the revolver is drawn and repaid frequently. - **Interest rate profile:** Floating rate based on SOFR plus a spread. - **Covenants:** Standard leverage and interest coverage ratios, which the company clears with massive headroom. - **Share repurchase programme:** Authorised but rarely used aggressively; the company prefers dividends. - **Dividend policy:** Highly consistent payer. Targets a payout ratio of 70% to 80% of net income. The company frequently pays supplemental or special dividends when cash balances build up. ## Cash Flow Characteristics - **Operating cash flow conversion:** 100% to 125% of Net Income. - **Free cash flow margin:** 11% to 14% of revenue. - **Major non-cash items:** Depreciation of FMI equipment and logistics fleet. - **Working capital cash flow impact:** Significant use of cash during periods of high growth or supply chain disruption (as seen in 2022/2023), but normalises to a steady state as supply chains heal. - **Capex intensity:** Low to moderate, allowing for high free cash flow conversion. - **Cash tax rate:** Closely tracks the GAAP effective tax rate of approximately 24.5%. ## Sheet Structure 1. **Assumptions**: Hardcoded drivers for DSR growth, business days, margins, working capital days, and capex. 2. **Revenue_and_Gross_Margin**: Calculates daily sales rates, multiplies by business days, and projects revenue and gross profit for Fasteners, Safety Supplies, and Other. 3. **Operating_Expenses**: Forecasts SG&A components (employee costs, occupancy, IT) and depreciation. 4. **Income_Statement**: Consolidated P&L from Net Sales down to Net Income and EPS. 5. **Balance_Sheet**: Assets, Liabilities, and Shareholders' Equity, driven by working capital schedules. 6. **Cash_Flow_Statement**: Indirect method starting from Net Income, adjusting for working capital changes and capex. 7. **Debt_Schedule**: Revolver mechanics, interest expense calculations, and debt balances. 8. **Working_Capital_and_Capex**: Detailed schedules for Accounts Receivable, Inventory, Accounts Payable, and PP&E roll-forwards. 9. **DCF_Valuation**: Unlevered free cash flow calculation, WACC assumptions, terminal value, and implied share price. ## Key Financial Relationships 1. Total Business Days = Q1 Days + Q2 Days + Q3 Days + Q4 Days (typically 253 to 255 annually). 2. Fasteners Daily Sales Rate (DSR) = Fasteners Revenue / Business Days in Period. 3. Fasteners Revenue = Forecasted Fasteners DSR x Business Days in Period. 4. Consolidated Net Sales = Fasteners Revenue + Safety Supplies Revenue + Other Revenue. 5. Consolidated Gross Profit = (Fasteners Revenue x Fasteners GM%) + (Safety Revenue x Safety GM%) + (Other Revenue x Other GM%). 6. SG&A Expense = Fixed SG&A + (Variable SG&A % x Consolidated Net Sales). 7. Operating Income = Consolidated Gross Profit - SG&A Expense - Depreciation. 8. Ending Inventory = (Consolidated COGS / 365) x Days Inventory Outstanding. 9. Ending Accounts Receivable = (Consolidated Net Sales / 365) x Days Sales Outstanding. 10. FMI Capex = Forecasted New Device Signings x Average Capital Cost per Device. 11. Revolver Draw/(Paydown) = Minimum Cash Balance - Cash Available Before Debt Repayment. 12. Dividends Paid = Prior Year Net Income x Target Payout Ratio. ## Cross-Sheet Dependencies The **Assumptions** sheet dictates the DSR growth rates and business days, which feed directly into the **Revenue_and_Gross_Margin** sheet. The revenue outputs drive the **Income_Statement** and dictate the Accounts Receivable and Inventory balances on the **Working_Capital_and_Capex** sheet. The resulting working capital changes flow into the **Cash_Flow_Statement**. The cash flow before financing determines the revolver draw on the **Debt_Schedule**, which calculates interest expense. Interest expense flows back to the **Income_Statement**, creating a circular reference that must be managed with an iterative calculation toggle. ## Sign Convention - Revenues, expenses, assets, and liabilities are entered and displayed as positive numbers. - On the Income Statement, expenses are subtracted from revenues mathematically (e.g., Gross Profit = Revenue - COGS). - On the Cash Flow Statement, cash inflows are positive and cash outflows (increases in assets, decreases in liabilities, capex, dividends) are negative. ## Things Most Likely to Go Wrong - **Ignoring Business Days:** Fastenal's quarterly revenue fluctuates based on the exact number of selling days. Modelling straight quarter-over-quarter growth without adjusting for business days will result in inaccurate forecasts. - **Misunderstanding Inventory Strategy:** Fastenal deliberately runs a high DIO (150+ days). Assuming inventory will normalise to the 60-day average of broader retail/distribution peers will artificially inflate forecasted free cash flow. - **Gross Margin Mix Shift:** Failing to model the gross margin compression caused by the strategic shift toward Onsite locations and National Accounts. These accounts drive high ROIC but carry lower gross margins than traditional branch walk-in traffic. - **FMI Capitalisation:** Vending machines (FASTVend/FASTBin) remain on Fastenal's balance sheet. The model must capture the capex required to deploy these devices and the subsequent depreciation. - **Freight and Tariff Volatility:** COGS is highly sensitive to inbound freight costs and import duties. The model should allow for gross margin flex if global shipping rates spike. - **Special Dividends:** Fastenal frequently pays special dividends when leverage drops near zero. The model needs a sweep mechanism to distribute excess cash rather than letting it build up infinitely on the balance sheet. - **SG&A Deleverage:** In low-growth environments, Fastenal struggles to cut SG&A quickly because it refuses to lay off branch staff, leading to sharp operating margin contraction during industrial recessions. - **Tax Rate Assumptions:** The company benefits from specific stock option exercise tax benefits. The ongoing baseline tax rate should be hardcoded at 24.5%, not the statutory 21.0%. ## Validation Checks - "Gross margin must remain between 44.0% and 46.0%; flag if outside this band." - "Operating margin should be between 19.0% and 21.5%." - "Days Inventory Outstanding (DIO) must remain above 145 days to reflect the company's availability strategy." - "Operating Cash Flow / Net Income must be > 1.0x on an annual basis." - "Debt / EBITDA must remain below 1.0x; flag if the model forecasts excessive borrowing." - "Total Assets must exactly equal Total Liabilities + Shareholders' Equity in all periods." - "Dividend payout ratio should be between 70% and 85% of Net Income." - "Capex as a percentage of revenue should run between 2.5% and 4.0%." ## Key Assumptions (Default Values) | Assumption | Default Value | Unit | Rationale | |---|---|---|---| | Fasteners DSR Growth | 4.5 | % | Reflects moderate industrial production growth and pricing stability. | | Safety Supplies DSR Growth | 8.0 | % | Driven by continued FASTVend deployment and market share gains. | | Other Products DSR Growth | 9.5 | % | Reflects success in cross-selling indirect materials at Onsite locations. | | Consolidated Gross Margin | 45.0 | % | 2025 actual reported gross margin; reflects mix shift headwinds. | | SG&A as % of Revenue | 24.8 | % | Aligns with recent operating margin performance of ~20.2%. | | Days Sales Outstanding (DSO) | 43 | Days | Based on historical receivables collection patterns. | | Days Inventory Outstanding (DIO) | 155 | Days | Reflects strategy to maintain high stock levels for customer availability. | | Days Payable Outstanding (DPO) | 30 | Days | Standard payment terms with suppliers. | | Capex as % of Revenue | 3.3 | % | Aligns with 2025 guidance of $265M - $285M on ~$8.2B revenue. | | Effective Tax Rate | 24.5 | % | Management's stated ongoing tax rate absent discrete items. | | Dividend Payout Ratio | 79.8 | % | Matches the 2025 actual payout ratio. | | Revolver Interest Rate | 5.5 | % | Estimated SOFR plus standard corporate spread. | | WACC | 8.5 | % | Standard discount rate for a stable, low-beta industrial distributor. | | Terminal Growth Rate | 2.5 | % | Long-term GDP and industrial production growth proxy. | ## Data Sources & Benchmarks - **Filings:** SEC EDGAR (10-K, 10-Q, 8-K) and the Fastenal Investor Relations website. - **Key Peers:** W.W. Grainger (GWW), MSC Industrial Direct (MSM), Wesco International (WCC), Applied Industrial Technologies (AIT). - **Industry Data:** Institute for Supply Management (ISM) Purchasing Managers' Index (PMI), U.S. Industrial Production Index. - **Consensus Estimates:** Bloomberg, FactSet, or Quartr for forward-looking analyst estimates. ## Sources - Fastenal Company Q4 2024 and Full Year 2024 Earnings Release (January 2025). - Fastenal Company Q4 2025 and Full Year 2025 Earnings Release and 10-K Financial Highlights (January/February 2026). - Fastenal Investor Relations Presentations and Earnings Call Transcripts (2024 - 2026). - Quartr Earnings Summaries for Fastenal (FAST). - Industrial Supply Trends industry reports. --- ## Frequently asked questions ### What does Fastenal Company do? Fastenal Company is a leading North American wholesale distributor of industrial and construction supplies. It operates through a dense network of branches and customer-specific Onsite locations, providing supply chain solutions and inventory management to its clients. ### How does Fastenal generate its revenue? Fastenal generates revenue primarily through the distribution of fasteners, safety supplies, and other industrial and construction products. The company evaluates its revenue growth using a Daily Sales Rate (DSR) to normalize for business days. ### What is the assumed revenue growth rate in the Fastenal financial model? The financial model for Fastenal assumes a revenue growth rate of approximately 8.33% per year. This growth is expected to be driven by the company's aggressive shift towards Onsite expansions and digital footprint growth. ### What is the main objective of the Fastenal financial model? The primary objective of the Fastenal financial model is to forecast the company's cash flow generation and intrinsic equity value. This analysis helps determine if Fastenal's current premium valuation multiple is justified by its strategic initiatives like Onsite expansion. ### Is an Excel financial model available for Fastenal? Yes, an Excel financial model for Fastenal is available for download. This model provides forecasts for the company's financials from FY2026 through FY2030, incorporating key assumptions such as revenue growth and capital expenditure. ### What is Fastenal's approach to inventory management? Fastenal maintains intentionally high inventory levels, reflected in a Days Inventory Outstanding (DIO) of 150 to 165 days, to guarantee product availability for its customers. This strategy makes the business model asset-heavy in working capital, consuming cash as the company grows and deploys inventory into new locations. [Interactive forecast calculator](https://finamodel.com/companies/fastenal/forecast)