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 -114 -199 -275
Change - 111.04% -88.09% -244.19% -172.4% 24.9% -74.56% -38.19%
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 293.2 307.1 322.4
Change - 10.98% -0.58% 31.08% 8.3% 19.51% 4.76% 4.97%
Free Cash Flow (FCF) 1 613.5 767.2 1,260 946.8 1,051 1,121 1,274 1,339
Change - 25.05% 64.22% -24.85% 10.96% 6.7% 13.65% 5.13%
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.64% 22.86% 23.29%
EBIT Margin (%) 20.25% 20.82% 20.81% 20.01% 20.19% 20.56% 20.83% 21.08%
EBT Margin (%) 20.09% 20.63% 20.72% 19.99% 20.18% 20.56% 20.77% 20.97%
Net margin (%) 15.39% 15.57% 15.72% 15.25% 15.35% 15.59% 15.74% 15.91%
FCF margin (%) 10.21% 10.99% 17.15% 12.55% 12.81% 12.09% 12.58% 12.23%
FCF / Net Income (%) 66.32% 70.59% 109.08% 82.29% 83.49% 77.52% 79.95% 76.87%

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.08% 36.06% 36.31%

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.16% 3.03% 2.94%
CAPEX / EBITDA (%) 11.28% 10.66% 10.13% 13.44% 13.37% 13.96% 13.27% 12.64%
CAPEX / FCF (%) 25.53% 22.65% 13.72% 23.92% 23.35% 26.15% 24.11% 24.07%

Items per share

        
Cash flow per share 1 0.667 0.8174 1.25 1.022 1.127 1.274 1.34 1.504
Change - 22.55% 52.94% -18.29% 10.29% 13.08% 5.17% 12.23%
Dividend per Share 1 0.56 0.62 0.7 0.78 0.875 0.9697 1.057 1.139
Change - 10.71% 12.9% 11.43% 12.18% 10.82% 8.98% 7.74%
Book Value Per Share 1 2.643 2.748 2.927 3.154 3.435 3.69 4 4.381
Change - 3.95% 6.54% 7.74% 8.92% 7.43% 8.39% 9.52%
EPS 1 0.8 0.945 1.01 1 1.09 1.259 1.392 1.522
Change - 18.12% 6.88% -0.99% 9% 15.48% 10.6% 9.35%
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 41.4x 37.5x
PBR 14.1x 13x
EV / Sales 6.4x 5.85x
Yield 1.86% 2.03%

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
52.15USD
Average target price
48.07USD
Spread / Average Target
-7.83%

Quarterly revenue - Rate of surprise