|
Valuación de DCF de Virtra, Inc. (VTSI)
US | Industrials | Aerospace & Defense | 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
VirTra, Inc. (VTSI) Bundle
¡Descubra el verdadero valor de Virtra, Inc. (VTSI) con nuestra calculadora DCF avanzada! Ajuste los supuestos clave, explore varios escenarios y evalúe cómo los cambios afectan la valoración de Virtra, 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 | 18.7 | 19.1 | 24.4 | 28.3 | 38.0 | 45.7 | 54.8 | 65.8 | 79.1 | 94.9 |
Revenue Growth, % | 0 | 2.01 | 28.01 | 15.83 | 34.42 | 20.07 | 20.07 | 20.07 | 20.07 | 20.07 |
EBITDA | .9 | 1.9 | 1.5 | 3.5 | 11.6 | 5.8 | 7.0 | 8.3 | 10.0 | 12.0 |
EBITDA, % | 4.57 | 9.97 | 5.95 | 12.3 | 30.61 | 12.68 | 12.68 | 12.68 | 12.68 | 12.68 |
Depreciation | .6 | .7 | .9 | 1.3 | 1.4 | 1.7 | 2.1 | 2.5 | 3.0 | 3.6 |
Depreciation, % | 3.16 | 3.54 | 3.76 | 4.59 | 3.74 | 3.76 | 3.76 | 3.76 | 3.76 | 3.76 |
EBIT | .3 | 1.2 | .5 | 2.2 | 10.2 | 4.1 | 4.9 | 5.9 | 7.1 | 8.5 |
EBIT, % | 1.4 | 6.42 | 2.19 | 7.71 | 26.87 | 8.92 | 8.92 | 8.92 | 8.92 | 8.92 |
Total Cash | 3.3 | 6.8 | 19.7 | 13.5 | 18.8 | 21.1 | 25.4 | 30.5 | 36.6 | 43.9 |
Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
Account Receivables | 5.9 | 6.8 | 7.8 | 10.5 | 16.8 | 16.5 | 19.8 | 23.8 | 28.5 | 34.3 |
Account Receivables, % | 31.51 | 35.56 | 32.1 | 37.06 | 44.25 | 36.09 | 36.09 | 36.09 | 36.09 | 36.09 |
Inventories | 1.9 | 3.5 | 5.0 | 9.6 | 12.4 | 10.6 | 12.7 | 15.3 | 18.3 | 22.0 |
Inventories, % | 10.42 | 18.42 | 20.52 | 33.89 | 32.61 | 23.17 | 23.17 | 23.17 | 23.17 | 23.17 |
Accounts Payable | .6 | .3 | .8 | 1.3 | 2.3 | 1.7 | 2.1 | 2.5 | 3.0 | 3.6 |
Accounts Payable, % | 3.32 | 1.81 | 3.23 | 4.42 | 6 | 3.76 | 3.76 | 3.76 | 3.76 | 3.76 |
Capital Expenditure | -.9 | -.1 | -3.7 | -3.3 | -1.1 | -3.2 | -3.8 | -4.6 | -5.5 | -6.7 |
Capital Expenditure, % | -4.7 | -0.32485 | -15.29 | -11.81 | -2.97 | -7.02 | -7.02 | -7.02 | -7.02 | -7.02 |
Tax Rate, % | 17.79 | 17.79 | 17.79 | 17.79 | 17.79 | 17.79 | 17.79 | 17.79 | 17.79 | 17.79 |
EBITAT | -.1 | 1.4 | .5 | 1.7 | 8.4 | 2.9 | 3.4 | 4.1 | 4.9 | 5.9 |
Depreciation | ||||||||||
Changes in Account Receivables | ||||||||||
Changes in Inventories | ||||||||||
Changes in Accounts Payable | ||||||||||
Capital Expenditure | ||||||||||
UFCF | -7.6 | -.7 | -4.4 | -7.1 | .6 | 3.0 | -3.4 | -4.1 | -5.0 | -6.0 |
WACC, % | 6.58 | 7.06 | 7.02 | 6.95 | 6.97 | 6.92 | 6.92 | 6.92 | 6.92 | 6.92 |
PV UFCF | ||||||||||
SUM PV UFCF | -11.7 | |||||||||
Long Term Growth Rate, % | 4.00 | |||||||||
Free cash flow (T + 1) | -6 | |||||||||
Terminal Value | -212 | |||||||||
Present Terminal Value | -152 | |||||||||
Enterprise Value | -164 | |||||||||
Net Debt | -10 | |||||||||
Equity Value | -154 | |||||||||
Diluted Shares Outstanding, MM | 11 | |||||||||
Equity Value Per Share | -14.02 |
What You Will Get
- Real VTSI Financial Data: Pre-filled with VirTra’s historical and projected data for precise analysis.
- Fully Editable Template: Modify key inputs like revenue growth, WACC, and EBITDA % with ease.
- Automatic Calculations: See VirTra’s intrinsic value update instantly based on your changes.
- Professional Valuation Tool: Designed for investors, analysts, and consultants seeking accurate DCF results.
- User-Friendly Design: Simple structure and clear instructions for all experience levels.
Key Features
- Comprehensive Data: Access VirTra’s historical financial reports and pre-populated forecasts.
- Customizable Inputs: Adjust WACC, tax rates, revenue growth, and EBITDA margins to suit your analysis.
- Real-Time Insights: Watch VirTra’s intrinsic value update instantly as you modify inputs.
- Intuitive Visualizations: Dashboard graphs illustrate valuation outcomes and essential metrics clearly.
- Designed for Precision: A professional-grade tool crafted for analysts, investors, and finance professionals.
How It Works
- Download: Get the pre-prepared Excel file containing VirTra, Inc.'s (VTSI) financial information.
- Customize: Modify projections, including revenue growth, EBITDA %, and WACC.
- Update Automatically: The intrinsic value and NPV calculations refresh in real-time.
- Test Scenarios: Develop various projections and instantly compare results.
- Make Decisions: Utilize the valuation outputs to inform your investment choices.
Why Choose VirTra, Inc. (VTSI)?
- Enhance Training Efficiency: Our simulations provide realistic scenarios that save training time.
- Boost Safety: Innovative technology reduces risks during training exercises.
- Customizable Solutions: Adapt our systems to meet your specific training needs and goals.
- User-Friendly Interface: Intuitive design allows for straightforward operation and analysis.
- Industry-Leading Support: Backed by a team of experts dedicated to your success.
Who Should Use VirTra, Inc. (VTSI)?
- Law Enforcement Agencies: Enhance training programs with realistic simulation technology.
- Military Trainers: Utilize advanced scenarios for effective combat readiness training.
- Educational Institutions: Integrate immersive learning experiences into criminal justice and law enforcement curricula.
- Corporate Trainers: Improve employee training with engaging, interactive simulations.
- Safety Professionals: Use simulations to promote awareness and preparedness in emergency situations.
What the Template Contains
- Operating and Balance Sheet Data: Pre-filled VirTra, Inc. historical data and forecasts, including revenue, EBITDA, EBIT, and capital expenditures.
- WACC Calculation: A dedicated sheet for Weighted Average Cost of Capital (WACC), including parameters like Beta, risk-free rate, and share price.
- DCF Valuation (Unlevered and Levered): Editable Discounted Cash Flow models showing intrinsic value with detailed calculations.
- Financial Statements: Pre-loaded financial statements (annual and quarterly) to support analysis.
- Key Ratios: Includes profitability, leverage, and efficiency ratios for VirTra, Inc. (VTSI).
- Dashboard and Charts: Visual summary of valuation outputs and assumptions to analyze results easily.