|
Valoración de DCF de la empresa del sujeto (Fast)
US | Industrials | Industrial - Distribution | NASDAQ
|
- ✓ Completamente Editable: Adáptelo A Sus Necesidades En Excel O Sheets
- ✓ Diseño Profesional: Plantillas Confiables Y Estándares De La Industria
- ✓ Predeterminadas Para Un Uso Rápido Y Eficiente
- ✓ No Se Necesita Experiencia; Fáciles De Seguir
Fastenal Company (FAST) Bundle
¡Descubra el verdadero valor de la compañía Fastenal (FAST) con nuestra calculadora DCF avanzada! Ajuste los supuestos clave, explore varios escenarios y evalúe cómo los cambios afectan la valoración de la compañía de sujetos (RÁPIDO), todo dentro de una sola plantilla de Excel.
Discounted Cash Flow (DCF) - (USD MM)
Year | AY1 2019 |
AY2 2020 |
AY3 2021 |
AY4 2022 |
AY5 2023 |
FY1 2024 |
FY2 2025 |
FY3 2026 |
FY4 2027 |
FY5 2028 |
---|---|---|---|---|---|---|---|---|---|---|
Revenue | 5,333.7 | 5,647.3 | 6,010.9 | 6,980.6 | 7,346.7 | 7,965.6 | 8,636.6 | 9,364.1 | 10,152.9 | 11,008.1 |
Revenue Growth, % | 0 | 5.88 | 6.44 | 16.13 | 5.24 | 8.42 | 8.42 | 8.42 | 8.42 | 8.42 |
EBITDA | 1,205.9 | 1,304.2 | 1,388.2 | 1,630.9 | 1,706.0 | 1,838.2 | 1,993.0 | 2,160.9 | 2,342.9 | 2,540.3 |
EBITDA, % | 22.61 | 23.09 | 23.09 | 23.36 | 23.22 | 23.08 | 23.08 | 23.08 | 23.08 | 23.08 |
Depreciation | 148.7 | 162.4 | 170.7 | 176.6 | 177.3 | 214.2 | 232.3 | 251.8 | 273.0 | 296.0 |
Depreciation, % | 2.79 | 2.88 | 2.84 | 2.53 | 2.41 | 2.69 | 2.69 | 2.69 | 2.69 | 2.69 |
EBIT | 1,057.2 | 1,141.8 | 1,217.5 | 1,454.3 | 1,528.7 | 1,624.0 | 1,760.8 | 1,909.1 | 2,069.9 | 2,244.3 |
EBIT, % | 19.82 | 20.22 | 20.25 | 20.83 | 20.81 | 20.39 | 20.39 | 20.39 | 20.39 | 20.39 |
Total Cash | 174.9 | 245.7 | 236.2 | 230.1 | 221.3 | 284.7 | 308.6 | 334.6 | 362.8 | 393.4 |
Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
Account Receivables | 741.8 | 769.4 | 900.2 | 1,013.2 | 1,087.6 | 1,144.3 | 1,240.7 | 1,345.2 | 1,458.5 | 1,581.4 |
Account Receivables, % | 13.91 | 13.62 | 14.98 | 14.51 | 14.8 | 14.37 | 14.37 | 14.37 | 14.37 | 14.37 |
Inventories | 1,366.4 | 1,337.5 | 1,523.6 | 1,708.0 | 1,522.7 | 1,909.2 | 2,070.1 | 2,244.5 | 2,433.5 | 2,638.5 |
Inventories, % | 25.62 | 23.68 | 25.35 | 24.47 | 20.73 | 23.97 | 23.97 | 23.97 | 23.97 | 23.97 |
Accounts Payable | 192.8 | 207.0 | 233.1 | 255.0 | 264.1 | 293.2 | 317.9 | 344.7 | 373.7 | 405.2 |
Accounts Payable, % | 3.61 | 3.67 | 3.88 | 3.65 | 3.59 | 3.68 | 3.68 | 3.68 | 3.68 | 3.68 |
Capital Expenditure | -246.4 | -168.1 | -156.6 | -173.8 | -172.8 | -239.7 | -259.8 | -281.7 | -305.5 | -331.2 |
Capital Expenditure, % | -4.62 | -2.98 | -2.61 | -2.49 | -2.35 | -3.01 | -3.01 | -3.01 | -3.01 | -3.01 |
Tax Rate, % | 24.11 | 24.11 | 24.11 | 24.11 | 24.11 | 24.11 | 24.11 | 24.11 | 24.11 | 24.11 |
EBITAT | 801.1 | 866.0 | 932.4 | 1,097.7 | 1,160.1 | 1,232.8 | 1,336.7 | 1,449.3 | 1,571.4 | 1,703.7 |
Depreciation | ||||||||||
Changes in Account Receivables | ||||||||||
Changes in Inventories | ||||||||||
Changes in Accounts Payable | ||||||||||
Capital Expenditure | ||||||||||
UFCF | -1,212.0 | 875.8 | 655.7 | 825.0 | 1,284.6 | 793.3 | 1,076.6 | 1,167.3 | 1,265.6 | 1,372.2 |
WACC, % | 9 | 9 | 9 | 9 | 9 | 9 | 9 | 9 | 9 | 9 |
PV UFCF | ||||||||||
SUM PV UFCF | 4,323.8 | |||||||||
Long Term Growth Rate, % | 4.00 | |||||||||
Free cash flow (T + 1) | 1,427 | |||||||||
Terminal Value | 28,547 | |||||||||
Present Terminal Value | 18,555 | |||||||||
Enterprise Value | 22,879 | |||||||||
Net Debt | 314 | |||||||||
Equity Value | 22,565 | |||||||||
Diluted Shares Outstanding, MM | 573 | |||||||||
Equity Value Per Share | 39.38 |
What You Will Get
- Real FAST Financials: Access to historical and projected data for precise valuation.
- Customizable Inputs: Adjust WACC, tax rates, revenue growth, and capital expenditures as needed.
- Dynamic Calculations: Intrinsic value and NPV are computed in real-time.
- Scenario Analysis: Explore various scenarios to assess Fastenal’s future performance.
- User-Friendly Design: Designed for professionals while remaining approachable for newcomers.
Key Features
- Pre-Loaded Data: Fastenal Company's historical financial statements and pre-filled forecasts.
- Fully Adjustable Inputs: Modify WACC, tax rates, revenue growth, and EBITDA margins as needed.
- Instant Results: Observe Fastenal's intrinsic value recalculating in real time.
- Clear Visual Outputs: Dashboard charts illustrate valuation results and essential metrics.
- Built for Accuracy: A professional tool designed for analysts, investors, and finance professionals.
How It Works
- Download the Template: Gain immediate access to the Excel-based FAST DCF Calculator.
- Input Your Assumptions: Modify the yellow-highlighted cells for growth rates, WACC, margins, and more.
- Instant Calculations: The model automatically recalculates Fastenal's intrinsic value.
- Test Scenarios: Experiment with different assumptions to assess potential valuation shifts.
- Analyze and Decide: Utilize the outcomes to inform your investment or financial analysis.
Why Choose This Calculator for Fastenal Company (FAST)?
- Accurate Data: Utilize real Fastenal financials for dependable valuation outcomes.
- Customizable: Modify essential parameters such as growth rates, WACC, and tax rates to align with your forecasts.
- Time-Saving: Ready-made calculations remove the hassle of starting from scratch.
- Professional-Grade Tool: Tailored for investors, analysts, and consultants in the field.
- User-Friendly: Easy-to-navigate design and comprehensive instructions ensure accessibility for all users.
Who Should Use This Product?
- Investors: Accurately assess Fastenal's (FAST) fair value prior to making investment choices.
- CFOs: Utilize a high-quality DCF model for financial reporting and strategic analysis.
- Consultants: Efficiently modify the template for client valuation reports.
- Entrepreneurs: Acquire knowledge about financial modeling practices employed by leading companies.
- Educators: Implement it as a resource to teach valuation techniques.
What the Template Contains
- Pre-Filled Data: Includes Fastenal Company's historical financials and projections.
- Discounted Cash Flow Model: Editable DCF valuation model featuring automatic calculations.
- Weighted Average Cost of Capital (WACC): A dedicated sheet for calculating WACC based on user-defined inputs.
- Key Financial Ratios: Evaluate Fastenal's profitability, efficiency, and leverage metrics.
- Customizable Inputs: Easily modify revenue growth, profit margins, and tax rates.
- Clear Dashboard: Visual representations and tables summarizing essential valuation findings.