Virco Mfg. Corporation (VIRC) DCF Valuation
- ✓ 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 the financial future of Virco Mfg. Corporation (VIRC) with our user-friendly DCF Calculator! Enter your projections for growth, margins, and expenses to calculate the intrinsic value of Virco Mfg. Corporation (VIRC) and enhance your investment strategy.
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.