Generation Bio Co. (GBIO) 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
Generation Bio Co. (GBIO) Bundle
Enhance your investment strategies with the Generation Bio Co. (GBIO) DCF Calculator! Dive into authentic financial data, adjust growth projections and expenses, and instantly observe how these modifications affect the intrinsic value of Generation Bio Co. (GBIO).
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 | .0 | .0 | .0 | .0 | 5.9 | 5.9 | 5.9 | 5.9 | 5.9 | 5.9 |
Revenue Growth, % | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
EBITDA | -60.4 | -77.7 | -114.6 | -136.1 | -133.3 | 3.5 | 3.5 | 3.5 | 3.5 | 3.5 |
EBITDA, % | 100 | 100 | 100 | 100 | -2257.79 | 60 | 60 | 60 | 60 | 60 |
Depreciation | 1.9 | 3.4 | 4.5 | 5.1 | 5.3 | 5.8 | 5.8 | 5.8 | 5.8 | 5.8 |
Depreciation, % | 100 | 100 | 100 | 100 | 89.14 | 97.83 | 97.83 | 97.83 | 97.83 | 97.83 |
EBIT | -62.3 | -81.1 | -119.1 | -141.2 | -138.6 | 3.5 | 3.5 | 3.5 | 3.5 | 3.5 |
EBIT, % | 100 | 100 | 100 | 100 | -2346.93 | 60 | 60 | 60 | 60 | 60 |
Total Cash | 15.1 | 262.3 | 375.1 | 279.1 | 264.4 | 5.9 | 5.9 | 5.9 | 5.9 | 5.9 |
Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
Account Receivables | .4 | .0 | .0 | .4 | 4.1 | 5.6 | 5.6 | 5.6 | 5.6 | 5.6 |
Account Receivables, % | 100 | 100 | 100 | 100 | 70.26 | 94.05 | 94.05 | 94.05 | 94.05 | 94.05 |
Inventories | .0 | .0 | .0 | .0 | -.2 | 4.7 | 4.7 | 4.7 | 4.7 | 4.7 |
Inventories, % | 100 | 100 | 100 | 100 | -3.18 | 79.36 | 79.36 | 79.36 | 79.36 | 79.36 |
Accounts Payable | 2.3 | .3 | 2.0 | .7 | 2.3 | 5.2 | 5.2 | 5.2 | 5.2 | 5.2 |
Accounts Payable, % | 100 | 100 | 100 | 100 | 39.74 | 87.95 | 87.95 | 87.95 | 87.95 | 87.95 |
Capital Expenditure | -20.0 | -5.5 | -6.0 | -8.8 | -7.4 | -1.2 | -1.2 | -1.2 | -1.2 | -1.2 |
Capital Expenditure, % | 100 | 100 | 100 | 100 | -125.29 | -20 | -20 | -20 | -20 | -20 |
Tax Rate, % | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
EBITAT | -61.3 | -77.1 | -114.6 | -136.5 | -138.6 | 3.4 | 3.4 | 3.4 | 3.4 | 3.4 |
Depreciation | ||||||||||
Changes in Account Receivables | ||||||||||
Changes in Inventories | ||||||||||
Changes in Accounts Payable | ||||||||||
Capital Expenditure | ||||||||||
UFCF | -77.6 | -80.7 | -114.3 | -141.9 | -142.6 | 4.6 | 8.0 | 8.0 | 8.0 | 8.0 |
WACC, % | 9.91 | 9.82 | 9.85 | 9.86 | 9.95 | 9.88 | 9.88 | 9.88 | 9.88 | 9.88 |
PV UFCF | ||||||||||
SUM PV UFCF | 27.5 | |||||||||
Long Term Growth Rate, % | 2.00 | |||||||||
Free cash flow (T + 1) | 8 | |||||||||
Terminal Value | 104 | |||||||||
Present Terminal Value | 65 | |||||||||
Enterprise Value | 92 | |||||||||
Net Debt | 31 | |||||||||
Equity Value | 61 | |||||||||
Diluted Shares Outstanding, MM | 64 | |||||||||
Equity Value Per Share | 0.95 |
What You Will Receive
- Pre-Filled Financial Model: Generation Bio Co.’s (GBIO) actual data supports accurate DCF valuation.
- Comprehensive Forecast Control: Modify revenue growth, profit margins, WACC, and other essential drivers.
- Real-Time Calculations: Instant updates allow you to view results as you adjust inputs.
- Professional-Grade Template: A polished Excel file crafted for high-quality valuation presentations.
- Customizable and Reusable: Designed for adaptability, enabling repeated use for in-depth forecasts.
Key Features
- 🔍 Real-Life GBIO Financials: Pre-filled historical and projected data for Generation Bio Co.
- ✏️ Fully Customizable Inputs: Adjust all critical parameters (yellow cells) like WACC, growth %, and tax rates.
- 📊 Professional DCF Valuation: Built-in formulas calculate Generation Bio’s intrinsic value using the Discounted Cash Flow method.
- ⚡ Instant Results: Visualize Generation Bio’s valuation instantly after making changes.
- Scenario Analysis: Test and compare outcomes for various financial assumptions side-by-side.
How It Works
- Download the Template: Gain immediate access to the Excel-based GBIO DCF Calculator.
- Input Your Assumptions: Modify the yellow-highlighted cells for growth rates, WACC, margins, and other variables.
- Instant Calculations: The model automatically computes Generation Bio Co.’s intrinsic value.
- Test Scenarios: Experiment with various assumptions to assess potential changes in valuation.
- Analyze and Decide: Leverage the results to inform your investment or financial analysis.
Why Choose This Calculator for Generation Bio Co. (GBIO)?
- Designed for Experts: A sophisticated tool tailored for analysts, CFOs, and consultants in the biotech sector.
- Comprehensive Data: Generation Bio's historical and projected financials are preloaded for precise analysis.
- Flexible Scenario Analysis: Effortlessly simulate various forecasts and assumptions.
- Clear Results: Automatically computes intrinsic value, NPV, and essential metrics.
- User-Friendly: Step-by-step guidance ensures a smooth user experience.
Who Should Use This Product?
- Investors: Evaluate Generation Bio Co.'s (GBIO) market potential before making investment decisions.
- CFOs and Financial Analysts: Optimize valuation methodologies and assess financial forecasts for GBIO.
- Startup Founders: Understand the valuation strategies of biotechnology firms like Generation Bio Co. (GBIO).
- Consultants: Create detailed valuation assessments for clients in the biotech sector.
- Students and Educators: Utilize current data to learn and teach valuation practices relevant to the biotech industry.
What the Template Contains
- Operating and Balance Sheet Data: Pre-filled Generation Bio Co. (GBIO) 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 Generation Bio Co. (GBIO).
- Dashboard and Charts: Visual summary of valuation outputs and assumptions to analyze results easily.