Ocular Therapeutix, Inc. (OCUL) 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
Ocular Therapeutix, Inc. (OCUL) Bundle
Evaluate the financial outlook of Ocular Therapeutix, Inc. (OCUL) like a professional! This (OCUL) DCF Calculator provides you with pre-filled financials and the flexibility to modify revenue growth, WACC, margins, and other crucial assumptions to align with your projections.
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 | 4.2 | 17.4 | 43.5 | 51.5 | 58.4 | 92.3 | 145.8 | 230.3 | 363.8 | 574.6 |
Revenue Growth, % | 0 | 311.71 | 150.08 | 18.32 | 13.49 | 57.95 | 57.95 | 57.95 | 57.95 | 57.95 |
EBITDA | -77.7 | -146.1 | -75.6 | -61.9 | -66.4 | -92.3 | -145.8 | -230.3 | -363.8 | -574.6 |
EBITDA, % | -1839.15 | -839.48 | -173.74 | -120.22 | -113.64 | -100 | -100 | -100 | -100 | -100 |
Depreciation | 2.5 | 2.8 | 2.4 | 2.1 | 3.0 | 16.7 | 26.4 | 41.7 | 65.9 | 104.1 |
Depreciation, % | 59.85 | 15.93 | 5.56 | 4.1 | 5.1 | 18.11 | 18.11 | 18.11 | 18.11 | 18.11 |
EBIT | -80.3 | -148.9 | -78.0 | -64.0 | -69.4 | -92.3 | -145.8 | -230.3 | -363.8 | -574.6 |
EBIT, % | -1899.01 | -855.42 | -179.3 | -124.32 | -118.74 | -100 | -100 | -100 | -100 | -100 |
Total Cash | 54.4 | 228.1 | 164.2 | 102.3 | 195.8 | 92.3 | 145.8 | 230.3 | 363.8 | 574.6 |
Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
Account Receivables | 2.5 | 12.3 | 21.1 | 21.3 | 26.2 | 49.0 | 77.4 | 122.3 | 193.1 | 305.1 |
Account Receivables, % | 60.28 | 70.4 | 48.56 | 41.41 | 44.79 | 53.09 | 53.09 | 53.09 | 53.09 | 53.09 |
Inventories | 1.0 | 1.2 | 1.3 | 2.0 | 2.3 | 7.4 | 11.7 | 18.5 | 29.2 | 46.1 |
Inventories, % | 22.57 | 6.9 | 2.87 | 3.83 | 3.94 | 8.02 | 8.02 | 8.02 | 8.02 | 8.02 |
Accounts Payable | 3.3 | 2.7 | 4.6 | 5.1 | 4.4 | 22.3 | 35.3 | 55.7 | 88.0 | 138.9 |
Accounts Payable, % | 77.31 | 15.57 | 10.55 | 9.95 | 7.51 | 24.18 | 24.18 | 24.18 | 24.18 | 24.18 |
Capital Expenditure | -2.2 | -.8 | -1.2 | -3.7 | -6.1 | -14.4 | -22.8 | -36.0 | -56.9 | -89.8 |
Capital Expenditure, % | -52.95 | -4.83 | -2.74 | -7.21 | -10.42 | -15.63 | -15.63 | -15.63 | -15.63 | -15.63 |
Tax Rate, % | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
EBITAT | -83.6 | -152.7 | -128.7 | -57.2 | -69.4 | -90.3 | -142.7 | -225.4 | -356.0 | -562.3 |
Depreciation | ||||||||||
Changes in Account Receivables | ||||||||||
Changes in Inventories | ||||||||||
Changes in Accounts Payable | ||||||||||
Capital Expenditure | ||||||||||
UFCF | -83.5 | -161.3 | -134.5 | -59.1 | -78.4 | -98.0 | -158.8 | -250.9 | -396.3 | -625.9 |
WACC, % | 10.71 | 10.71 | 10.71 | 10.56 | 10.71 | 10.68 | 10.68 | 10.68 | 10.68 | 10.68 |
PV UFCF | ||||||||||
SUM PV UFCF | -1,044.1 | |||||||||
Long Term Growth Rate, % | 2.00 | |||||||||
Free cash flow (T + 1) | -638 | |||||||||
Terminal Value | -7,354 | |||||||||
Present Terminal Value | -4,428 | |||||||||
Enterprise Value | -5,472 | |||||||||
Net Debt | -112 | |||||||||
Equity Value | -5,359 | |||||||||
Diluted Shares Outstanding, MM | 86 | |||||||||
Equity Value Per Share | -62.61 |
What You Will Get
- Real OCUL Financial Data: Pre-filled with Ocular Therapeutix’s historical and projected data for precise analysis.
- Fully Editable Template: Modify key inputs like revenue growth, WACC, and EBITDA % with ease.
- Automatic Calculations: See Ocular Therapeutix’s intrinsic value update instantly based on your changes.
- Professional Valuation Tool: Designed for investors, analysts, and consultants seeking accurate DCF results.
- User-Friendly Design: Simple structure and clear instructions for all experience levels.
Key Features
- Customizable Financial Metrics: Adjust essential parameters such as revenue projections, gross margin %, and R&D expenditures.
- Instant DCF Valuation: Quickly computes intrinsic value, NPV, and other financial metrics with ease.
- High-Precision Accuracy: Leverages Ocular Therapeutix's actual financial data for reliable valuation results.
- Effortless Scenario Analysis: Evaluate various assumptions and analyze results without hassle.
- Efficiency Booster: Avoid the complexities of constructing detailed valuation models from the ground up.
How It Works
- Download the Template: Gain immediate access to the Excel-based OCUL DCF Calculator.
- Input Your Assumptions: Modify the yellow-highlighted cells for growth rates, WACC, margins, and other variables.
- Instant Calculations: The model automatically recalculates Ocular Therapeutix’s intrinsic value.
- Test Scenarios: Experiment with various assumptions to assess potential valuation shifts.
- Analyze and Decide: Utilize the outcomes to inform your investment or financial strategy.
Why Choose This Calculator for Ocular Therapeutix, Inc. (OCUL)?
- Designed for Industry Experts: A sophisticated tool utilized by healthcare analysts, investment managers, and researchers.
- Comprehensive Data: Ocular Therapeutix’s historical and projected financials are preloaded for precision.
- Versatile Scenario Analysis: Effortlessly model various forecasts and assumptions.
- Clear and Concise Outputs: Automatically computes intrinsic value, NPV, and essential metrics.
- User-Friendly Interface: Step-by-step guidance simplifies the entire calculation process.
Who Should Use Ocular Therapeutix, Inc. (OCUL)?
- Investors: Gain insights into innovative therapies and make informed investment choices.
- Healthcare Analysts: Utilize comprehensive data to assess the company's market position and growth potential.
- Consultants: Tailor presentations and reports for clients focusing on the ophthalmic pharmaceutical sector.
- Biotech Enthusiasts: Enhance your knowledge of drug development processes and therapeutic innovations.
- Educators and Students: Employ real-world case studies in academic settings related to biotechnology and pharmaceuticals.
What the Template Contains
- Pre-Filled Data: Contains Ocular Therapeutix’s historical financials and projections.
- Discounted Cash Flow Model: Editable DCF valuation model with automated calculations.
- Weighted Average Cost of Capital (WACC): A dedicated sheet for calculating WACC using custom inputs.
- Key Financial Ratios: Evaluate Ocular Therapeutix's profitability, efficiency, and leverage.
- Customizable Inputs: Easily modify revenue growth, margins, and tax rates.
- Clear Dashboard: Visuals and tables summarizing essential valuation results.