Vericel Corporation (VCEL) DCF Valuation
- ✓ Totalmente Editável: Adapte-Se Às Suas Necessidades No Excel Ou Planilhas
- ✓ Design Profissional: Modelos Confiáveis E Padrão Da Indústria
- ✓ Pré-Construídos Para Uso Rápido E Eficiente
- ✓ Não É Necessária Experiência; Fácil De Seguir
Vericel Corporation (VCEL) Bundle
Assess Vericel Corporation's financial outlook like an expert! This VCEL (VCEL) DCF Calculator comes with pre-filled financials and offers complete flexibility to modify revenue growth, WACC, margins, and other essential assumptions to align with your predictions.
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 | 117.9 | 124.2 | 156.2 | 164.4 | 197.5 | 225.4 | 257.3 | 293.7 | 335.2 | 382.6 |
| Revenue Growth, % | 0 | 5.37 | 25.77 | 5.24 | 20.17 | 14.14 | 14.14 | 14.14 | 14.14 | 14.14 |
| EBITDA | -5.1 | 9.9 | -4.6 | -11.6 | 2.9 | -2.2 | -2.6 | -2.9 | -3.3 | -3.8 |
| EBITDA, % | -4.35 | 7.95 | -2.95 | -7.08 | 1.45 | -0.99618 | -0.99618 | -0.99618 | -0.99618 | -0.99618 |
| Depreciation | 4.5 | 6.8 | 7.4 | 8.2 | 4.6 | 9.7 | 11.0 | 12.6 | 14.4 | 16.4 |
| Depreciation, % | 3.84 | 5.5 | 4.73 | 4.99 | 2.35 | 4.28 | 4.28 | 4.28 | 4.28 | 4.28 |
| EBIT | -9.7 | 3.1 | -12.0 | -19.8 | -1.8 | -11.9 | -13.6 | -15.5 | -17.7 | -20.2 |
| EBIT, % | -8.19 | 2.46 | -7.68 | -12.07 | -0.89512 | -5.28 | -5.28 | -5.28 | -5.28 | -5.28 |
| Total Cash | 69.7 | 75.8 | 103.4 | 119.5 | 109.6 | 141.8 | 161.9 | 184.8 | 210.9 | 240.7 |
| Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
| Account Receivables | 32.2 | 34.5 | 37.4 | 46.5 | 58.4 | 61.7 | 70.5 | 80.4 | 91.8 | 104.8 |
| Account Receivables, % | 27.3 | 27.79 | 23.97 | 28.31 | 29.54 | 27.38 | 27.38 | 27.38 | 27.38 | 27.38 |
| Inventories | 6.8 | 9.4 | 13.4 | 16.0 | 13.1 | 17.2 | 19.7 | 22.5 | 25.6 | 29.3 |
| Inventories, % | 5.78 | 7.53 | 8.57 | 9.73 | 6.63 | 7.65 | 7.65 | 7.65 | 7.65 | 7.65 |
| Accounts Payable | 6.3 | 6.8 | 9.0 | 16.9 | 22.3 | 17.2 | 19.7 | 22.4 | 25.6 | 29.2 |
| Accounts Payable, % | 5.38 | 5.44 | 5.77 | 10.3 | 11.31 | 7.64 | 7.64 | 7.64 | 7.64 | 7.64 |
| Capital Expenditure | -2.6 | -2.6 | -7.9 | -7.6 | -27.5 | -12.6 | -14.4 | -16.4 | -18.7 | -21.4 |
| Capital Expenditure, % | -2.22 | -2.11 | -5.07 | -4.62 | -13.93 | -5.59 | -5.59 | -5.59 | -5.59 | -5.59 |
| Tax Rate, % | -34.37 | -34.37 | -34.37 | -34.37 | -34.37 | -34.37 | -34.37 | -34.37 | -34.37 | -34.37 |
| EBITAT | -7.9 | 2.9 | -11.8 | -20.7 | -2.4 | -11.3 | -12.9 | -14.7 | -16.8 | -19.2 |
| Depreciation | ||||||||||
| Changes in Account Receivables | ||||||||||
| Changes in Inventories | ||||||||||
| Changes in Accounts Payable | ||||||||||
| Capital Expenditure | ||||||||||
| UFCF | -38.6 | 2.6 | -17.0 | -23.9 | -28.8 | -26.9 | -25.0 | -28.5 | -32.5 | -37.1 |
| WACC, % | 12.05 | 12.06 | 12.07 | 12.07 | 12.07 | 12.06 | 12.06 | 12.06 | 12.06 | 12.06 |
| PV UFCF | ||||||||||
| SUM PV UFCF | -105.8 | |||||||||
| Long Term Growth Rate, % | 2.00 | |||||||||
| Free cash flow (T + 1) | -38 | |||||||||
| Terminal Value | -376 | |||||||||
| Present Terminal Value | -213 | |||||||||
| Enterprise Value | -319 | |||||||||
| Net Debt | 19 | |||||||||
| Equity Value | -338 | |||||||||
| Diluted Shares Outstanding, MM | 48 | |||||||||
| Equity Value Per Share | -7.10 |
What You Will Receive
- Comprehensive Financial Model: Vericel Corporation’s (VCEL) actual data facilitates accurate DCF analysis.
- Complete Forecast Flexibility: Modify revenue growth, profit margins, WACC, and other essential factors.
- Real-Time Calculations: Automatic updates allow you to view results instantly as you make adjustments.
- Professional-Grade Template: A polished Excel file crafted for high-quality valuation presentations.
- Adaptable and Reusable: Designed for versatility, enabling repeated use for in-depth financial forecasts.
Key Features
- Customizable Financial Metrics: Adjust essential inputs such as revenue projections, operating margins, and investment levels.
- Instant DCF Valuation: Quickly computes intrinsic value, net present value, and additional financial metrics.
- High-Precision Analytics: Leverages Vericel Corporation’s (VCEL) actual financial data for accurate valuation results.
- Effortless Scenario Testing: Easily evaluate various assumptions and analyze different outcomes.
- Efficiency Booster: Streamlines the valuation process, removing the need for intricate model development from the ground up.
How It Works
- Step 1: Download the prebuilt Excel template featuring Vericel Corporation's (VCEL) data.
- Step 2: Navigate through the pre-filled sheets to grasp the essential metrics.
- Step 3: Modify forecasts and assumptions in the editable yellow cells (WACC, growth, margins).
- Step 4: Instantly observe recalculated results, including Vericel Corporation's (VCEL) intrinsic value.
- Step 5: Make well-informed investment decisions or create reports based on the outputs.
Why Choose This Calculator for Vericel Corporation (VCEL)?
- Accuracy: Utilizes real Vericel financial data for precise calculations.
- Flexibility: Allows users to easily test and adjust their inputs as needed.
- Time-Saving: Eliminate the complexity of constructing a DCF model from the ground up.
- Professional-Grade: Crafted with the expertise and precision expected at the CFO level.
- User-Friendly: Intuitive interface suitable for users without extensive financial modeling skills.
Who Should Use This Product?
- Investors: Accurately estimate Vericel Corporation’s (VCEL) fair value before making investment decisions.
- CFOs: Leverage a professional-grade DCF model for financial reporting and analysis specific to Vericel Corporation (VCEL).
- Consultants: Quickly adapt the template for valuation reports tailored for Vericel Corporation (VCEL) clients.
- Entrepreneurs: Gain insights into financial modeling techniques used by leading biotech firms like Vericel Corporation (VCEL).
- Educators: Use it as a teaching tool to demonstrate valuation methodologies relevant to the biotech sector, including Vericel Corporation (VCEL).
What the Template Contains
- Preloaded VCEL Data: Historical and projected financial data, including revenue, EBIT, and capital expenditures.
- DCF and WACC Models: Professional-grade sheets for calculating intrinsic value and Weighted Average Cost of Capital.
- Editable Inputs: Yellow-highlighted cells for adjusting revenue growth, tax rates, and discount rates.
- Financial Statements: Comprehensive annual and quarterly financials for deeper analysis.
- Key Ratios: Profitability, leverage, and efficiency ratios to evaluate performance.
- Dashboard and Charts: Visual summaries of valuation outcomes and assumptions.