Projected Income Statement: Fastenal Company

Forecast Balance Sheet: Fastenal Company

Fiscal Period: December 2021 2022 2023 2024 2025 2026 2027 2028
Net Debt 1 154 325 38.7 -55.8 -152 -110 -210 -313
Change - 111.04% -88.09% -244.19% -172.4% 27.54% -90.91% -49.05%
Announcement Date 1/19/22 1/19/23 1/18/24 1/17/25 1/20/26 - - -
1USD in Million
Estimates

Cash Flow Forecast: Fastenal Company

Fiscal Period: December 2021 2022 2023 2024 2025 2026 2027 2028
CAPEX 1 156.6 173.8 172.8 226.5 245.3 289 308 323.4
Change - 10.98% -0.58% 31.08% 8.3% 17.8% 6.57% 5.03%
Free Cash Flow (FCF) 1 613.5 767.2 1,260 946.8 1,051 1,097 1,282 1,347
Change - 25.05% 64.22% -24.85% 10.96% 4.45% 16.85% 5.04%
Announcement Date 1/19/22 1/19/23 1/18/24 1/17/25 1/20/26 - - -
1USD in Million
Estimates

Forecast Financial Ratios: Fastenal Company

Fiscal Period: December 2021 2022 2023 2024 2025 2026 2027 2028

Profitability

        
EBITDA Margin (%) 23.09% 23.35% 23.22% 22.34% 22.38% 22.66% 22.88% 23.25%
EBIT Margin (%) 20.25% 20.82% 20.81% 20.01% 20.19% 20.58% 20.85% 21.1%
EBT Margin (%) 20.09% 20.63% 20.72% 19.99% 20.18% 20.6% 20.81% 21.02%
Net margin (%) 15.39% 15.57% 15.72% 15.25% 15.35% 15.62% 15.76% 15.94%
FCF margin (%) 10.21% 10.99% 17.15% 12.55% 12.81% 11.81% 12.63% 12.25%
FCF / Net Income (%) 66.32% 70.59% 109.08% 82.29% 83.49% 75.6% 80.1% 76.86%

Profitability

        
ROA 22.39% 24.57% 25.63% 25.12% 25.81% 26.65% 27.75% 28.4%
ROE 32.03% 35.03% 35.47% 33.04% 33.29% 35.13% 36.1% 36.33%

Financial Health

        
Leverage (Debt/EBITDA) 0.11x 0.2x 0.02x - - - - -
Debt / Free cash flow 0.25x 0.42x 0.03x - - - - -

Capital Intensity

        
CAPEX / Current Assets (%) 2.61% 2.49% 2.35% 3% 2.99% 3.11% 3.03% 2.94%
CAPEX / EBITDA (%) 11.28% 10.66% 10.13% 13.44% 13.37% 13.72% 13.25% 12.65%
CAPEX / FCF (%) 25.53% 22.65% 13.72% 23.92% 23.35% 26.33% 24.02% 24.01%

Items per share

        
Cash flow per share 1 0.667 0.8174 1.25 1.022 1.127 1.261 1.34 1.509
Change - 22.55% 52.94% -18.29% 10.29% 11.9% 6.29% 12.61%
Dividend per Share 1 0.56 0.62 0.7 0.78 0.875 0.9784 1.057 1.139
Change - 10.71% 12.9% 11.43% 12.18% 11.82% 8% 7.74%
Book Value Per Share 1 2.643 2.748 2.927 3.154 3.435 3.677 4.009 4.399
Change - 3.95% 6.54% 7.74% 8.92% 7.04% 9.04% 9.73%
EPS 1 0.8 0.945 1.01 1 1.09 1.262 1.398 1.53
Change - 18.12% 6.88% -0.99% 9% 15.81% 10.73% 9.47%
Nbr of stocks (in thousands) 1,150,327 1,145,520 1,143,200 1,145,773 1,148,036 1,147,498 1,147,498 1,147,498
Announcement Date 1/19/22 1/19/23 1/18/24 1/17/25 1/20/26 - - -
1USD
Estimates
2026 *2027 *
P/E 40.2x 36.3x
PBR 13.8x 12.7x
EV / Sales 6.25x 5.71x
Yield 1.93% 2.08%

EPS & Dividend



Y-o-Y evolution of P/E

 

Year-on-year evolution of the Yield

Trader
Investor
Global
Quality
ESG MSCI
-
Sell
Consensus
Buy
Mean consensus
HOLD
Number of Analysts
18
Last Close Price
50.73USD
Average target price
48.84USD
Spread / Average Target
-3.73%

Quarterly revenue - Rate of surprise