Virgin Galactic Holdings, Inc. (SPCE) DCF Valuation
- ✓ Fully Editable: Tailor To Your Needs In Excel Or Sheets
- ✓ Professional Design: Trusted, Industry-Standard Templates
- ✓ Pre-Built For Quick And Efficient Use
- ✓ No Expertise Is Needed; Easy To Follow
Virgin Galactic Holdings, Inc. (SPCE) Bundle
Whether you’re an investor or analyst, this (SPCE) DCF Calculator is your go-to resource for accurate valuation. It comes preloaded with real data from Virgin Galactic Holdings, Inc., allowing you to adjust forecasts and immediately observe the effects.
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 | 3.8 | .2 | 3.3 | 2.3 | 6.8 | 8.1 | 9.7 | 11.5 | 13.7 | 16.3 |
| Revenue Growth, % | 0 | -93.71 | 1283.19 | -29.77 | 194.12 | 19.13 | 19.13 | 19.13 | 19.13 | 19.13 |
| EBITDA | -206.3 | -635.1 | -341.3 | -476.3 | -475.6 | -8.1 | -9.7 | -11.5 | -13.7 | -16.3 |
| EBITDA, % | -5455.25 | -266834.87 | -10366.83 | -20602.34 | -6994.75 | -100 | -100 | -100 | -100 | -100 |
| Depreciation | 7.0 | 9.8 | 11.5 | 11.1 | 13.4 | 8.1 | 9.7 | 11.5 | 13.7 | 16.3 |
| Depreciation, % | 185.11 | 4109.66 | 349.88 | 480.02 | 196.6 | 100 | 100 | 100 | 100 | 100 |
| EBIT | -213.3 | -644.8 | -352.8 | -487.4 | -489.0 | -8.1 | -9.7 | -11.5 | -13.7 | -16.3 |
| EBIT, % | -5640.36 | -270944.54 | -10716.71 | -21082.35 | -7191.35 | -100 | -100 | -100 | -100 | -100 |
| Total Cash | 480.4 | 665.9 | 603.9 | 909.0 | 874.0 | 8.1 | 9.7 | 11.5 | 13.7 | 16.3 |
| Total Cash, percent | .0 | .3 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
| Account Receivables | .5 | .5 | .0 | .0 | .0 | 1.8 | 2.2 | 2.6 | 3.1 | 3.7 |
| Account Receivables, % | 12.19 | 226.89 | 0 | 0 | 0 | 22.44 | 22.44 | 22.44 | 22.44 | 22.44 |
| Inventories | 26.8 | 30.5 | 29.7 | 24.0 | 16.3 | 8.1 | 9.7 | 11.5 | 13.7 | 16.3 |
| Inventories, % | 709.26 | 12807.98 | 901.22 | 1039.92 | 239.72 | 100 | 100 | 100 | 100 | 100 |
| Accounts Payable | 7.0 | 6.0 | 9.2 | 16.3 | 32.4 | 8.1 | 9.7 | 11.5 | 13.7 | 16.3 |
| Accounts Payable, % | 186.14 | 2520.17 | 280.59 | 706.14 | 476.69 | 100 | 100 | 100 | 100 | 100 |
| Capital Expenditure | -19.4 | -17.2 | -4.6 | -16.5 | -44.3 | -8.1 | -9.7 | -11.5 | -13.7 | -16.3 |
| Capital Expenditure, % | -513.38 | -7227.31 | -140.8 | -713.19 | -651.6 | -100 | -100 | -100 | -100 | -100 |
| Tax Rate, % | -0.0902599 | -0.0902599 | -0.0902599 | -0.0902599 | -0.0902599 | -0.0902599 | -0.0902599 | -0.0902599 | -0.0902599 | -0.0902599 |
| EBITAT | -213.3 | -644.9 | -352.9 | -488.0 | -489.5 | -8.1 | -9.7 | -11.5 | -13.7 | -16.3 |
| Depreciation | ||||||||||
| Changes in Account Receivables | ||||||||||
| Changes in Inventories | ||||||||||
| Changes in Accounts Payable | ||||||||||
| Capital Expenditure | ||||||||||
| UFCF | -246.0 | -657.1 | -341.4 | -480.7 | -496.6 | -26.0 | -10.0 | -11.9 | -14.2 | -16.9 |
| WACC, % | 6.09 | 6.09 | 6.09 | 6.09 | 6.09 | 6.09 | 6.09 | 6.09 | 6.09 | 6.09 |
| PV UFCF | ||||||||||
| SUM PV UFCF | -67.2 | |||||||||
| Long Term Growth Rate, % | 2.00 | |||||||||
| Free cash flow (T + 1) | -17 | |||||||||
| Terminal Value | -421 | |||||||||
| Present Terminal Value | -313 | |||||||||
| Enterprise Value | -381 | |||||||||
| Net Debt | 201 | |||||||||
| Equity Value | -582 | |||||||||
| Diluted Shares Outstanding, MM | 17 | |||||||||
| Equity Value Per Share | -34.49 |
What You Will Get
- Real Virgin Galactic Data: Preloaded financials – from revenue to EBIT – based on actual and projected figures.
- Full Customization: Adjust all critical parameters (yellow cells) like WACC, growth %, and tax rates.
- Instant Valuation Updates: Automatic recalculations to analyze the impact of changes on Virgin Galactic’s fair value.
- Versatile Excel Template: Tailored for quick edits, scenario testing, and detailed projections.
- Time-Saving and Accurate: Skip building models from scratch while maintaining precision and flexibility.
Key Features
- Comprehensive Historical Data: Virgin Galactic's (SPCE) past financial statements and pre-filled projections.
- Customizable Parameters: Adjust WACC, tax rates, revenue growth, and EBITDA margins as needed.
- Real-Time Valuation: Watch Virgin Galactic's intrinsic value update instantly.
- Intuitive Visualizations: Dashboard graphs illustrate valuation outcomes and essential metrics.
- Designed for Precision: A professional-grade tool tailored for analysts, investors, and financial professionals.
How It Works
- Download the Template: Get instant access to the Excel-based SPCE DCF Calculator.
- Input Your Assumptions: Adjust yellow-highlighted cells for growth rates, WACC, margins, and more.
- Instant Calculations: The model automatically updates Virgin Galactic’s intrinsic value.
- Test Scenarios: Simulate different assumptions to evaluate potential valuation changes.
- Analyze and Decide: Use the results to guide your investment or financial analysis.
Why Choose This Calculator?
- Designed for Industry Experts: A sophisticated tool utilized by analysts, CFOs, and consultants in the aerospace sector.
- Accurate Data: Virgin Galactic's historical and projected financials preloaded for precise analysis.
- Flexible Scenario Analysis: Easily simulate various forecasts and assumptions to evaluate potential outcomes.
- Comprehensive Outputs: Automatically computes intrinsic value, NPV, and essential financial metrics.
- User-Friendly Interface: Step-by-step guidance to simplify the calculation process.
Who Should Use This Product?
- Individual Investors: Make informed decisions about buying or selling Virgin Galactic Holdings, Inc. (SPCE) stock.
- Financial Analysts: Enhance valuation processes with comprehensive financial models tailored for the space industry.
- Consultants: Provide clients with expert valuation insights on emerging aerospace companies like Virgin Galactic.
- Business Owners: Gain insights into how innovative companies like Virgin Galactic are valued to inform your own business strategies.
- Finance Students: Explore valuation methodologies using real-world data from the aerospace sector.
What the Template Contains
- Operating and Balance Sheet Data: Pre-filled Virgin Galactic Holdings, Inc. (SPCE) 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 Virgin Galactic Holdings, Inc. (SPCE).
- Dashboard and Charts: Visual summary of valuation outputs and assumptions to analyze results easily.