|
Virco Mfg. Corporation (VIRC) Valoración de DCF
US | Consumer Cyclical | Furnishings, Fixtures & Appliances | 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
Virco Mfg. Corporation (VIRC) Bundle
¡Explore el futuro financiero de Virco Mfg. Corporation (VIRC) con nuestra calculadora DCF fácil de usar! Ingrese sus proyecciones para el crecimiento, los márgenes y los gastos para calcular el valor intrínseco de Virco Mfg. Corporation (VIRC) y mejorar su estrategia de inversión.
Discounted Cash Flow (DCF) - (USD MM)
| Year | AY1 2020 |
AY2 2021 |
AY3 2022 |
AY4 2023 |
AY5 2024 |
FY1 2025 |
FY2 2026 |
FY3 2027 |
FY4 2028 |
FY5 2029 |
|---|---|---|---|---|---|---|---|---|---|---|
| Revenue | 191.1 | 152.8 | 184.8 | 231.1 | 269.1 | 297.7 | 329.2 | 364.1 | 402.8 | 445.5 |
| Revenue Growth, % | 0 | -20.03 | 20.96 | 25.02 | 16.47 | 10.6 | 10.6 | 10.6 | 10.6 | 10.6 |
| EBITDA | 11.3 | 4.2 | 2.0 | 10.0 | 37.0 | 16.6 | 18.4 | 20.3 | 22.5 | 24.8 |
| EBITDA, % | 5.91 | 2.77 | 1.1 | 4.34 | 13.75 | 5.58 | 5.58 | 5.58 | 5.58 | 5.58 |
| Depreciation | 6.1 | 5.7 | 4.2 | 4.0 | 5.1 | 7.6 | 8.4 | 9.3 | 10.3 | 11.4 |
| Depreciation, % | 3.2 | 3.71 | 2.26 | 1.73 | 1.89 | 2.56 | 2.56 | 2.56 | 2.56 | 2.56 |
| EBIT | 5.2 | -1.4 | -2.1 | 6.0 | 31.9 | 9.0 | 9.9 | 11.0 | 12.2 | 13.4 |
| EBIT, % | 2.72 | -0.94113 | -1.16 | 2.61 | 11.86 | 3.02 | 3.02 | 3.02 | 3.02 | 3.02 |
| Total Cash | 1.2 | .4 | 1.4 | 1.1 | 5.3 | 2.4 | 2.6 | 2.9 | 3.2 | 3.6 |
| Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
| Account Receivables | 12.1 | 10.0 | 18.0 | 18.5 | 23.2 | 23.4 | 25.9 | 28.6 | 31.6 | 35.0 |
| Account Receivables, % | 6.34 | 6.53 | 9.76 | 8.02 | 8.61 | 7.85 | 7.85 | 7.85 | 7.85 | 7.85 |
| Inventories | 43.3 | 38.3 | 47.4 | 67.4 | 58.4 | 73.9 | 81.8 | 90.5 | 100.1 | 110.7 |
| Inventories, % | 22.68 | 25.05 | 25.63 | 29.17 | 21.69 | 24.84 | 24.84 | 24.84 | 24.84 | 24.84 |
| Accounts Payable | 10.6 | 8.4 | 19.8 | 19.4 | 12.9 | 20.8 | 23.0 | 25.5 | 28.2 | 31.2 |
| Accounts Payable, % | 5.54 | 5.51 | 10.7 | 8.42 | 4.81 | 7 | 7 | 7 | 7 | 7 |
| Capital Expenditure | -4.2 | -2.2 | -3.0 | -3.3 | -5.2 | -5.1 | -5.7 | -6.3 | -7.0 | -7.7 |
| Capital Expenditure, % | -2.21 | -1.41 | -1.62 | -1.44 | -1.95 | -1.73 | -1.73 | -1.73 | -1.73 | -1.73 |
| Tax Rate, % | 25.07 | 25.07 | 25.07 | 25.07 | 25.07 | 25.07 | 25.07 | 25.07 | 25.07 | 25.07 |
| EBITAT | 4.5 | -1.1 | -8.7 | 12.4 | 23.9 | 7.9 | 8.7 | 9.6 | 10.6 | 11.8 |
| Depreciation | ||||||||||
| Changes in Account Receivables | ||||||||||
| Changes in Inventories | ||||||||||
| Changes in Accounts Payable | ||||||||||
| Capital Expenditure | ||||||||||
| UFCF | -38.4 | 7.5 | -13.3 | -7.8 | 21.6 | 2.4 | 3.3 | 3.7 | 4.1 | 4.5 |
| WACC, % | 8.29 | 8.11 | 8.47 | 8.47 | 8.11 | 8.29 | 8.29 | 8.29 | 8.29 | 8.29 |
| PV UFCF | ||||||||||
| SUM PV UFCF | 13.9 | |||||||||
| Long Term Growth Rate, % | 3.00 | |||||||||
| Free cash flow (T + 1) | 5 | |||||||||
| Terminal Value | 87 | |||||||||
| Present Terminal Value | 59 | |||||||||
| Enterprise Value | 73 | |||||||||
| Net Debt | 7 | |||||||||
| Equity Value | 66 | |||||||||
| Diluted Shares Outstanding, MM | 16 | |||||||||
| Equity Value Per Share | 4.02 |
What You Will Get
- Real Virco Data: Preloaded financials – from revenue to EBIT – based on actual and projected figures for Virco Mfg. Corporation (VIRC).
- Full Customization: Adjust all critical parameters (yellow cells) like WACC, growth %, and tax rates to fit your analysis needs.
- Instant Valuation Updates: Automatic recalculations to assess the impact of changes on Virco’s fair value.
- Versatile Excel Template: Designed for quick edits, scenario testing, and comprehensive projections.
- Time-Saving and Accurate: Avoid building models from scratch while ensuring precision and flexibility in your assessments.
Key Features
- Comprehensive DCF Calculator: Features detailed unlevered and levered DCF valuation models tailored for Virco Mfg. Corporation (VIRC).
- WACC Calculator: Pre-structured Weighted Average Cost of Capital sheet with adjustable inputs specific to VIRC.
- Customizable Forecast Assumptions: Adjust growth rates, capital expenditures, and discount rates as needed for accurate projections.
- Integrated Financial Ratios: Evaluate profitability, leverage, and efficiency ratios relevant to Virco Mfg. Corporation (VIRC).
- Interactive Dashboard and Charts: Visual representations that summarize essential valuation metrics for straightforward analysis.
How It Works
- Step 1: Download the prebuilt Excel template with Virco Mfg. Corporation’s (VIRC) data included.
- Step 2: Explore the pre-filled sheets and familiarize yourself with the key metrics.
- Step 3: Update forecasts and assumptions in the editable yellow cells (WACC, growth, margins).
- Step 4: Instantly view recalculated results, including Virco Mfg. Corporation’s (VIRC) intrinsic value.
- Step 5: Make informed investment decisions or generate reports using the outputs.
Why Choose Virco Mfg. Corporation (VIRC)?
- Industry Leader: A proven track record in manufacturing high-quality furniture solutions.
- Innovative Designs: Cutting-edge products that meet the evolving needs of educational environments.
- Sustainable Practices: Commitment to eco-friendly materials and processes for a greener future.
- Customer-Centric Approach: Dedicated support and customization options to fit unique client requirements.
- Trusted by Institutions: Preferred choice for schools and organizations seeking reliability and excellence.
Who Should Use This Product?
- Individual Investors: Make informed decisions about buying or selling Virco Mfg. Corporation (VIRC) stock.
- Financial Analysts: Streamline valuation processes with ready-to-use financial models for Virco Mfg. Corporation (VIRC).
- Consultants: Deliver professional valuation insights on Virco Mfg. Corporation (VIRC) to clients quickly and accurately.
- Business Owners: Understand how companies like Virco Mfg. Corporation (VIRC) are valued to guide your own strategy.
- Finance Students: Learn valuation techniques using real-world data and scenarios related to Virco Mfg. Corporation (VIRC).
What the Template Contains
- Operating and Balance Sheet Data: Pre-filled Virco Mfg. Corporation (VIRC) 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 Virco Mfg. Corporation (VIRC).
- Dashboard and Charts: Visual summary of valuation outputs and assumptions to analyze results easily.