Ocugen, Inc. (OCGN) 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
Ocugen, Inc. (OCGN) Bundle
Whether you're an investor or analyst, this Ocugen, Inc. (OCGN) DCF Calculator is your go-to tool for accurate valuation. It comes preloaded with real data from Ocugen, allowing you to adjust forecasts and observe the effects in real-time.
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 | 2.5 | 6.0 | 6.0 | 6.0 | 6.0 | 6.0 | 6.0 |
Revenue Growth, % | 0 | 0 | -100 | 0 | 142.6 | 0 | 0 | 0 | 0 | 0 |
EBITDA | -18.4 | -21.0 | -58.0 | -88.6 | -64.8 | -1.2 | -1.2 | -1.2 | -1.2 | -1.2 |
EBITDA, % | 100 | -49270.02 | 100 | -3560.73 | -1074.01 | -20 | -20 | -20 | -20 | -20 |
Depreciation | .1 | .1 | .6 | .5 | .7 | 4.0 | 4.0 | 4.0 | 4.0 | 4.0 |
Depreciation, % | 100 | 239.58 | 100 | 19.29 | 11.66 | 66.19 | 66.19 | 66.19 | 66.19 | 66.19 |
EBIT | -18.5 | -21.1 | -58.6 | -89.1 | -65.5 | -1.2 | -1.2 | -1.2 | -1.2 | -1.2 |
EBIT, % | 100 | -49509.6 | 100 | -3580.02 | -1085.67 | -20 | -20 | -20 | -20 | -20 |
Total Cash | 7.4 | 24.0 | 95.0 | 90.9 | 39.5 | 6.0 | 6.0 | 6.0 | 6.0 | 6.0 |
Total Cash, percent | .0 | .1 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
Account Receivables | .0 | .0 | .0 | .0 | .0 | 2.4 | 2.4 | 2.4 | 2.4 | 2.4 |
Account Receivables, % | 100 | 0 | 100 | 0 | 0 | 40 | 40 | 40 | 40 | 40 |
Inventories | .0 | .0 | .0 | .0 | .0 | 2.4 | 2.4 | 2.4 | 2.4 | 2.4 |
Inventories, % | 100 | 0 | 100 | 0 | 0 | 40 | 40 | 40 | 40 | 40 |
Accounts Payable | 1.9 | .4 | 2.3 | 8.1 | 3.2 | 5.5 | 5.5 | 5.5 | 5.5 | 5.5 |
Accounts Payable, % | 100 | 926.79 | 100 | 324.04 | 52.55 | 90.51 | 90.51 | 90.51 | 90.51 | 90.51 |
Capital Expenditure | .0 | -.3 | -.9 | -4.5 | -10.5 | -3.6 | -3.6 | -3.6 | -3.6 | -3.6 |
Capital Expenditure, % | 100 | -719.91 | 100 | -179.14 | -173.56 | -60 | -60 | -60 | -60 | -60 |
Tax Rate, % | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
EBITAT | -19.4 | -21.9 | -58.6 | -85.2 | -65.5 | -1.2 | -1.2 | -1.2 | -1.2 | -1.2 |
Depreciation | ||||||||||
Changes in Account Receivables | ||||||||||
Changes in Inventories | ||||||||||
Changes in Accounts Payable | ||||||||||
Capital Expenditure | ||||||||||
UFCF | -17.4 | -23.6 | -57.0 | -83.4 | -80.2 | -3.4 | -.8 | -.8 | -.8 | -.8 |
WACC, % | 21.65 | 21.65 | 21.65 | 21.64 | 21.65 | 21.65 | 21.65 | 21.65 | 21.65 | 21.65 |
PV UFCF | ||||||||||
SUM PV UFCF | -4.5 | |||||||||
Long Term Growth Rate, % | 2.00 | |||||||||
Free cash flow (T + 1) | -1 | |||||||||
Terminal Value | -4 | |||||||||
Present Terminal Value | -2 | |||||||||
Enterprise Value | -6 | |||||||||
Net Debt | -33 | |||||||||
Equity Value | 26 | |||||||||
Diluted Shares Outstanding, MM | 244 | |||||||||
Equity Value Per Share | 0.11 |
What You Will Get
- Pre-Filled Financial Model: Ocugen’s actual data allows for accurate DCF valuation.
- Full Forecast Control: Modify revenue growth, margins, WACC, and other essential drivers.
- Instant Calculations: Real-time updates ensure you see the outcomes as you make adjustments.
- Investor-Ready Template: A polished Excel file crafted for professional-level valuation.
- Customizable and Reusable: Designed for adaptability, enabling repeated use for in-depth forecasts.
Key Features
- Comprehensive DCF Calculator: Offers detailed unlevered and levered DCF valuation models tailored for Ocugen, Inc. (OCGN).
- WACC Calculator: Features a pre-built Weighted Average Cost of Capital sheet with adjustable inputs specific to Ocugen, Inc. (OCGN).
- Customizable Forecast Assumptions: Adjust growth rates, capital expenditures, and discount rates to suit Ocugen, Inc. (OCGN).
- Integrated Financial Ratios: Evaluate profitability, leverage, and efficiency ratios relevant to Ocugen, Inc. (OCGN).
- Interactive Dashboard and Charts: Visual presentations summarize essential valuation metrics for streamlined analysis of Ocugen, Inc. (OCGN).
How It Works
- Download the Template: Obtain immediate access to the Excel-based OCGN DCF Calculator.
- Input Your Assumptions: Modify the yellow-highlighted cells for growth rates, WACC, margins, and other variables.
- Instant Calculations: The model automatically recalculates Ocugen’s intrinsic value.
- Test Scenarios: Experiment with different assumptions to assess potential valuation shifts.
- Analyze and Decide: Leverage the results to inform your investment or financial strategy.
Why Choose This Calculator for Ocugen, Inc. (OCGN)?
- Accurate Data: Real Ocugen financials ensure reliable valuation results.
- Customizable: Adjust key parameters like growth rates, WACC, and tax rates to align with your projections.
- Time-Saving: Pre-built calculations save you from starting from scratch.
- Professional-Grade Tool: Tailored for investors, analysts, and consultants in the biotech sector.
- User-Friendly: Intuitive design and step-by-step guidance make it accessible for all users.
Who Should Use Ocugen, Inc. (OCGN)?
- Investors: Make informed decisions with insights from a leading biopharmaceutical company.
- Healthcare Analysts: Analyze market trends and opportunities in the gene therapy sector.
- Consultants: Customize reports and presentations based on Ocugen's innovative pipeline.
- Biotech Enthusiasts: Enhance your knowledge of cutting-edge therapies and their impact on patient care.
- Educators and Students: Utilize Ocugen's developments as case studies in biotechnology and pharmaceutical courses.
What the Ocugen, Inc. (OCGN) Template Contains
- Comprehensive DCF Model: Editable template featuring detailed valuation calculations tailored for Ocugen, Inc.
- Real-World Data: Ocugen’s historical and projected financials preloaded for in-depth analysis.
- Customizable Parameters: Modify WACC, growth rates, and tax assumptions to explore various scenarios.
- Financial Statements: Complete annual and quarterly breakdowns for enhanced insights into performance.
- Key Ratios: Integrated analysis for assessing profitability, efficiency, and leverage metrics.
- Dashboard with Visual Outputs: Interactive charts and tables providing clear, actionable results.