Clearside Biomedical, Inc. (CLSD) 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
Clearside Biomedical, Inc. (CLSD) Bundle
Whether you’re an investor or analyst, this (CLSD) DCF Calculator is your go-to resource for accurate valuation. Loaded with real data from Clearside Biomedical, Inc., you can 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 | 2.2 | 7.9 | 29.6 | 1.3 | 8.2 | 12.4 | 18.8 | 28.4 | 42.9 | 64.8 |
| Revenue Growth, % | 0 | 263.28 | 274.65 | -95.51 | 519.89 | 51.12 | 51.12 | 51.12 | 51.12 | 51.12 |
| EBITDA | -30.1 | -17.9 | -.4 | -29.5 | -23.1 | -10.0 | -15.1 | -22.8 | -34.5 | -52.1 |
| EBITDA, % | -1384.86 | -227.2 | -1.52 | -2220.27 | -280.31 | -80.3 | -80.3 | -80.3 | -80.3 | -80.3 |
| Depreciation | .2 | .2 | .2 | .1 | .1 | .6 | .9 | 1.4 | 2.1 | 3.2 |
| Depreciation, % | 9.71 | 2.28 | 0.60186 | 10.93 | 0.81449 | 4.87 | 4.87 | 4.87 | 4.87 | 4.87 |
| EBIT | -30.3 | -18.1 | -.6 | -29.6 | -23.1 | -10.0 | -15.1 | -22.8 | -34.5 | -52.1 |
| EBIT, % | -1394.57 | -229.48 | -2.12 | -2231.2 | -281.12 | -80.42 | -80.42 | -80.42 | -80.42 | -80.42 |
| Total Cash | 22.6 | 17.3 | 30.4 | 48.3 | 28.9 | 12.4 | 18.8 | 28.4 | 42.9 | 64.8 |
| Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
| Account Receivables | .0 | .0 | 10.0 | .0 | .2 | .9 | 1.3 | 2.0 | 3.1 | 4.7 |
| Account Receivables, % | 0 | 0 | 33.81 | 0 | 2.07 | 7.18 | 7.18 | 7.18 | 7.18 | 7.18 |
| Inventories | .0 | .0 | .9 | .0 | .0 | .1 | .1 | .2 | .3 | .4 |
| Inventories, % | 0 | 0 | 3.11 | 0 | 0 | 0.62282 | 0.62282 | 0.62282 | 0.62282 | 0.62282 |
| Accounts Payable | 1.3 | 2.0 | .9 | 1.1 | 2.2 | 4.8 | 7.3 | 11.0 | 16.6 | 25.1 |
| Accounts Payable, % | 58.9 | 25.3 | 3.18 | 79.13 | 26.81 | 38.66 | 38.66 | 38.66 | 38.66 | 38.66 |
| Capital Expenditure | .0 | -.1 | .0 | -.2 | -1.8 | -1.0 | -1.6 | -2.4 | -3.6 | -5.4 |
| Capital Expenditure, % | -1.15 | -0.69673 | 0 | -18.54 | -21.6 | -8.4 | -8.4 | -8.4 | -8.4 | -8.4 |
| Tax Rate, % | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
| EBITAT | -30.1 | -17.9 | -.6 | -30.6 | -23.1 | -10.0 | -15.1 | -22.8 | -34.4 | -52.0 |
| Depreciation | ||||||||||
| Changes in Account Receivables | ||||||||||
| Changes in Inventories | ||||||||||
| Changes in Accounts Payable | ||||||||||
| Capital Expenditure | ||||||||||
| UFCF | -28.6 | -17.1 | -12.4 | -19.7 | -23.9 | -8.6 | -13.8 | -20.8 | -31.4 | -47.5 |
| WACC, % | 18.06 | 18.03 | 18.12 | 18.12 | 18.12 | 18.09 | 18.09 | 18.09 | 18.09 | 18.09 |
| PV UFCF | ||||||||||
| SUM PV UFCF | -66.6 | |||||||||
| Long Term Growth Rate, % | 2.00 | |||||||||
| Free cash flow (T + 1) | -48 | |||||||||
| Terminal Value | -301 | |||||||||
| Present Terminal Value | -131 | |||||||||
| Enterprise Value | -198 | |||||||||
| Net Debt | 14 | |||||||||
| Equity Value | -212 | |||||||||
| Diluted Shares Outstanding, MM | 62 | |||||||||
| Equity Value Per Share | -3.43 |
What You Will Get
- Pre-Filled Financial Model: Clearside Biomedical’s actual data provides an accurate DCF valuation.
- Full Forecast Control: Modify revenue growth, margins, WACC, and other critical factors.
- Instant Calculations: Automatic updates allow you to view results in real-time as you make adjustments.
- Investor-Ready Template: A polished Excel file crafted for high-quality valuation.
- Customizable and Reusable: Designed for adaptability, enabling repeated use for comprehensive forecasts.
Key Features
- 🔍 Real-Life CLSD Financials: Pre-filled historical and projected data for Clearside Biomedical, Inc.
- ✏️ Fully Customizable Inputs: Adjust all critical parameters (yellow cells) like WACC, growth %, and tax rates.
- 📊 Professional DCF Valuation: Built-in formulas calculate Clearside's intrinsic value using the Discounted Cash Flow method.
- ⚡ Instant Results: Visualize Clearside's valuation instantly after making changes.
- Scenario Analysis: Test and compare outcomes for various financial assumptions side-by-side.
How It Works
- 1. Access the Model: Download and open the Excel file containing Clearside Biomedical, Inc.'s (CLSD) financial data.
- 2. Adjust Key Inputs: Modify essential parameters such as revenue growth rates, discount rates, and capital investment figures.
- 3. Analyze Results Immediately: The DCF model automatically computes the intrinsic value and net present value (NPV).
- 4. Explore Different Scenarios: Evaluate various projections to understand different valuation possibilities.
- 5. Make Informed Decisions: Utilize professional valuation analyses to guide your investment choices.
Why Choose This Calculator for Clearside Biomedical (CLSD)?
- Accuracy: Utilizes accurate Clearside financials for reliable data.
- Flexibility: Tailored for users to easily adjust and test various inputs.
- Time-Saving: Eliminate the need to construct a DCF model from the ground up.
- Professional-Grade: Crafted with the precision and usability expected at the CFO level.
- User-Friendly: Intuitive design makes it accessible for users without advanced financial modeling skills.
Who Should Use This Product?
- Professional Investors: Develop comprehensive and accurate valuation models for analyzing Clearside Biomedical, Inc. (CLSD).
- Corporate Finance Teams: Evaluate valuation scenarios to inform strategic decisions within the organization.
- Consultants and Advisors: Deliver precise valuation insights to clients interested in Clearside Biomedical, Inc. (CLSD).
- Students and Educators: Utilize real-world financial data to enhance learning and practice in financial modeling.
- Biotech Enthusiasts: Gain insights into how biotechnology companies like Clearside Biomedical, Inc. (CLSD) are valued in the market.
What the Template Contains
- Operating and Balance Sheet Data: Pre-filled Clearside Biomedical 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 Clearside Biomedical, Inc. (CLSD).
- Dashboard and Charts: Visual summary of valuation outputs and assumptions to analyze results easily.