Opthea Limited (OPT) 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
Opthea Limited (OPT) Bundle
Explore the financial prospects of Opthea Limited (OPT) with our user-friendly DCF Calculator! Enter your assumptions regarding growth rates, profit margins, and expenses to calculate the intrinsic value of Opthea Limited (OPT) and inform your investment decisions.
Discounted Cash Flow (DCF) - (USD MM)
| Year | AY1 2020 |
AY2 2021 |
AY3 2022 |
AY4 2023 |
AY5 2024 |
FY1 2025 |
FY2 2026 |
FY3 2027 |
FY4 2028 |
FY5 2029 |
|---|---|---|---|---|---|---|---|---|---|---|
| Revenue | .1 | .1 | .1 | .1 | .1 | .1 | .1 | .1 | .1 | .1 |
| Revenue Growth, % | 0 | -36.96 | 35.95 | 28.88 | -22.65 | 1.31 | 1.31 | 1.31 | 1.31 | 1.31 |
| EBITDA | -15.5 | -32.9 | -82.8 | -138.8 | -124.4 | -.1 | -.1 | -.1 | -.1 | -.1 |
| EBITDA, % | -17079.2 | -57455.77 | -106489.56 | -138554.61 | -160443.72 | -100 | -100 | -100 | -100 | -100 |
| Depreciation | .1 | .1 | .1 | .1 | .1 | .1 | .1 | .1 | .1 | .1 |
| Depreciation, % | 98.71 | 155.46 | 86.43 | 93.38 | 82.64 | 92.23 | 92.23 | 92.23 | 92.23 | 92.23 |
| EBIT | -15.6 | -32.9 | -82.9 | -138.9 | -124.4 | -.1 | -.1 | -.1 | -.1 | -.1 |
| EBIT, % | -17177.91 | -57611.24 | -106575.99 | -138647.99 | -160526.36 | -100 | -100 | -100 | -100 | -100 |
| Total Cash | 38.6 | 97.9 | 40.4 | 83.3 | 107.2 | .1 | .1 | .1 | .1 | .1 |
| Total Cash, percent | .0 | .2 | .1 | .1 | .1 | .0 | .0 | .0 | .0 | .0 |
| Account Receivables | 5.5 | .0 | .0 | 4.1 | 7.4 | .0 | .0 | .0 | .0 | .0 |
| Account Receivables, % | 6043.57 | 0 | 0 | 4072.22 | 9484.89 | 60 | 60 | 60 | 60 | 60 |
| Inventories | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
| Inventories, % | 0 | 0.00108718 | 0 | 0.000620489815 | 0 | 0.000341534173 | 0.000341534173 | 0.000341534173 | 0.000341534173 | 0.000341534173 |
| Accounts Payable | 2.5 | 1.5 | 7.1 | 11.1 | 23.7 | .1 | .1 | .1 | .1 | .1 |
| Accounts Payable, % | 2778.61 | 2628.5 | 9118.3 | 11071.39 | 30529.44 | 100 | 100 | 100 | 100 | 100 |
| Capital Expenditure | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
| Capital Expenditure, % | -2.51 | -18.51 | -18.65 | -20.25 | -26.86 | -17.36 | -17.36 | -17.36 | -17.36 | -17.36 |
| Tax Rate, % | 4.1 | 4.1 | 4.1 | 4.1 | 4.1 | 4.1 | 4.1 | 4.1 | 4.1 | 4.1 |
| EBITAT | -10.3 | -29.7 | -77.6 | -133.4 | -119.3 | -.1 | -.1 | -.1 | -.1 | -.1 |
| Depreciation | ||||||||||
| Changes in Account Receivables | ||||||||||
| Changes in Inventories | ||||||||||
| Changes in Accounts Payable | ||||||||||
| Capital Expenditure | ||||||||||
| UFCF | -13.2 | -25.2 | -72.0 | -133.4 | -110.0 | -16.3 | .0 | .0 | .0 | .0 |
| WACC, % | 12.25 | 13.38 | 13.54 | 13.65 | 13.65 | 13.3 | 13.3 | 13.3 | 13.3 | 13.3 |
| PV UFCF | ||||||||||
| SUM PV UFCF | -14.4 | |||||||||
| Long Term Growth Rate, % | 2.00 | |||||||||
| Free cash flow (T + 1) | 0 | |||||||||
| Terminal Value | 0 | |||||||||
| Present Terminal Value | 0 | |||||||||
| Enterprise Value | -14 | |||||||||
| Net Debt | -19 | |||||||||
| Equity Value | 5 | |||||||||
| Diluted Shares Outstanding, MM | 80 | |||||||||
| Equity Value Per Share | 0.06 |
What You Will Receive
- Comprehensive Financial Model: Utilizes Opthea Limited’s (OPT) actual data for accurate DCF valuation.
- Complete Forecast Flexibility: Modify revenue growth, profit margins, WACC, and other essential factors.
- Real-Time Calculations: Instant updates allow you to view results immediately as adjustments are made.
- Professional-Grade Template: A polished Excel file crafted for high-quality valuation presentations.
- Adaptable and Reusable: Designed for versatility, enabling multiple uses for thorough forecasting.
Key Features
- Comprehensive Historical Data: Opthea Limited’s (OPT) past financial statements and pre-filled projections.
- Customizable Parameters: Adjust WACC, tax rates, revenue growth, and EBITDA margins to fit your analysis.
- Real-Time Valuation: Instantly view the recalculated intrinsic value of Opthea Limited (OPT).
- Visual Insights: Dashboard charts present valuation outcomes and essential metrics clearly.
- Designed for Precision: A reliable tool tailored for analysts, investors, and finance professionals.
How It Works
- Step 1: Download the Excel file.
- Step 2: Review pre-entered Opthea Limited (OPT) data (historical and projected).
- Step 3: Adjust key assumptions (yellow cells) based on your analysis.
- Step 4: View automatic recalculations for Opthea Limited’s intrinsic value.
- Step 5: Use the outputs for investment decisions or reporting.
Why Choose Opthea Limited (OPT)?
- Innovative Solutions: Benefit from cutting-edge therapies tailored for eye diseases.
- Proven Efficacy: Clinical trials demonstrate the effectiveness of our treatments.
- Patient-Centric Approach: We prioritize the needs and experiences of our patients.
- Expert Team: Our professionals are leaders in ophthalmology and biotechnology.
- Strong Commitment: Dedicated to advancing research and improving patient outcomes.
Who Should Use This Product?
- Individual Investors: Make informed decisions about buying or selling Opthea Limited (OPT) stock.
- Financial Analysts: Streamline valuation processes with ready-to-use financial models specific to Opthea Limited (OPT).
- Consultants: Deliver professional valuation insights on Opthea Limited (OPT) to clients quickly and accurately.
- Business Owners: Understand how biopharmaceutical companies like Opthea Limited (OPT) are valued to guide your own strategy.
- Finance Students: Learn valuation techniques using real-world data and scenarios related to Opthea Limited (OPT).
What the Template Contains
- Pre-Filled Data: Includes Opthea Limited’s historical financials and forecasts.
- Discounted Cash Flow Model: Editable DCF valuation model with automatic calculations.
- Weighted Average Cost of Capital (WACC): A dedicated sheet for calculating WACC based on custom inputs.
- Key Financial Ratios: Analyze Opthea Limited’s profitability, efficiency, and leverage.
- Customizable Inputs: Edit revenue growth, margins, and tax rates with ease.
- Clear Dashboard: Charts and tables summarizing key valuation results.