Fastenal earnings and cash-flow scenarios
Built the workbook. The Base case reaches $1.82 EPS and $1.79bn of annual free cash flow in FY2030. But cash does not grow in step with earnings: receivables, inventory and reinvestment absorb part of the operating improvement.
The three scenarios
| FY2030 output | Bear | Base | Bull |
| Revenue | $11.06bn | $13.07bn | $14.57bn |
| Operating margin | 19.4% | 21.3% | 22.9% |
| Diluted EPS | $1.41 | $1.82 | $2.19 |
| Free cash flow | $1.36bn | $1.79bn | $2.14bn |
| Cumulative FCF, FY2026–30 | $5.78bn | $7.18bn | $8.09bn |
These are illustrative analyst scenarios, not company guidance. Reported FY2025 figures anchor the model; H1 2026 results expose what the FY2026 forecast requires in the second half.
What you are underwriting
- Bear: revenue compounds at 6.2% through FY2030. Gross margin falls to 43.5%, SG&A remains 24.1% of sales, and slower collections and inventory turns weigh on cash.
- Base: 9.8% revenue growth compounds with modest expense leverage. Gross margin settles at 44.4%; SG&A falls to 23.1% of sales. Improving inventory turns release part of the cash needed to grow.
- Bull: 12.2% revenue growth combines with a 45.1% gross margin and stronger SG&A leverage. Better collections, inventory turns and supplier terms support cash conversion.
The cash cost of growth
In FY2030, five extra receivable days cost the Base case $179m of cash. Ten extra inventory days cost $199m. Neither change reduces EPS. By comparison, a 100-bp gross-margin improvement adds $135m of FCF, including its effect on inventory and payables.
The sensitivity sheet varies FY2030 growth and operating margin while holding FY2029 fixed. Faster growth can reduce that year’s cash flow because the incremental working-capital requirement arrives immediately; the earnings benefit and the cash benefit are different questions.
All three cases recalculate from editable annual assumptions. The six sheets include the operating build, cash-flow bridge, sensitivity matrices, reported source inputs and reconciliation checks. FCF is operating cash flow less gross capex plus disposal proceeds, before dividends, buybacks and debt flows.
The model is ready to inspect:
Fastenal Scenario Model.xlsx