STAAR Surgical Company (STAA) 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
STAAR Surgical Company (STAA) Bundle
Designed for accuracy, our (STAA) DCF Calculator enables you to evaluate STAAR Surgical Company's valuation using real-world financial data, offering complete flexibility to modify all key parameters for improved 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 | 150.2 | 163.5 | 230.5 | 284.4 | 322.4 | 392.2 | 477.1 | 580.4 | 706.1 | 859.0 |
Revenue Growth, % | 0 | 8.84 | 41 | 23.4 | 13.37 | 21.65 | 21.65 | 21.65 | 21.65 | 21.65 |
EBITDA | 15.6 | 9.9 | 37.0 | 48.3 | 34.8 | 47.2 | 57.5 | 69.9 | 85.1 | 103.5 |
EBITDA, % | 10.35 | 6.03 | 16.05 | 16.99 | 10.8 | 12.05 | 12.05 | 12.05 | 12.05 | 12.05 |
Depreciation | 3.7 | 3.1 | 3.6 | 4.5 | 5.1 | 7.1 | 8.7 | 10.6 | 12.9 | 15.7 |
Depreciation, % | 2.46 | 1.89 | 1.58 | 1.59 | 1.59 | 1.82 | 1.82 | 1.82 | 1.82 | 1.82 |
EBIT | 11.9 | 6.8 | 33.3 | 43.8 | 29.7 | 40.1 | 48.8 | 59.3 | 72.2 | 87.8 |
EBIT, % | 7.89 | 4.14 | 14.47 | 15.4 | 9.21 | 10.22 | 10.22 | 10.22 | 10.22 | 10.22 |
Total Cash | 120.0 | 152.5 | 199.7 | 211.6 | 220.7 | 315.9 | 384.3 | 467.5 | 568.7 | 691.8 |
Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
Account Receivables | 31.0 | 35.2 | 43.5 | 62.4 | 98.0 | 89.0 | 108.2 | 131.7 | 160.2 | 194.9 |
Account Receivables, % | 20.64 | 21.55 | 18.89 | 21.96 | 30.39 | 22.69 | 22.69 | 22.69 | 22.69 | 22.69 |
Inventories | 17.1 | 18.1 | 17.3 | 24.2 | 35.1 | 38.7 | 47.1 | 57.3 | 69.7 | 84.8 |
Inventories, % | 11.41 | 11.08 | 7.5 | 8.5 | 10.9 | 9.88 | 9.88 | 9.88 | 9.88 | 9.88 |
Accounts Payable | 8.1 | 2.8 | 8.7 | 11.6 | 13.6 | 15.0 | 18.3 | 22.2 | 27.0 | 32.9 |
Accounts Payable, % | 5.36 | 1.72 | 3.77 | 4.07 | 4.2 | 3.83 | 3.83 | 3.83 | 3.83 | 3.83 |
Capital Expenditure | -10.2 | -8.4 | -13.6 | -18.1 | -18.2 | -23.4 | -28.5 | -34.6 | -42.2 | -51.3 |
Capital Expenditure, % | -6.78 | -5.14 | -5.92 | -6.37 | -5.64 | -5.97 | -5.97 | -5.97 | -5.97 | -5.97 |
Tax Rate, % | 36.65 | 36.65 | 36.65 | 36.65 | 36.65 | 36.65 | 36.65 | 36.65 | 36.65 | 36.65 |
EBITAT | 12.8 | 4.8 | 29.3 | 37.9 | 18.8 | 32.8 | 39.9 | 48.6 | 59.1 | 71.9 |
Depreciation | ||||||||||
Changes in Account Receivables | ||||||||||
Changes in Inventories | ||||||||||
Changes in Accounts Payable | ||||||||||
Capital Expenditure | ||||||||||
UFCF | -33.8 | -10.9 | 17.7 | 1.4 | -38.8 | 23.4 | -4.3 | -5.2 | -6.3 | -7.7 |
WACC, % | 7.27 | 7.23 | 7.25 | 7.25 | 7.22 | 7.24 | 7.24 | 7.24 | 7.24 | 7.24 |
PV UFCF | ||||||||||
SUM PV UFCF | 3.8 | |||||||||
Long Term Growth Rate, % | 4.00 | |||||||||
Free cash flow (T + 1) | -8 | |||||||||
Terminal Value | -245 | |||||||||
Present Terminal Value | -173 | |||||||||
Enterprise Value | -169 | |||||||||
Net Debt | -147 | |||||||||
Equity Value | -22 | |||||||||
Diluted Shares Outstanding, MM | 49 | |||||||||
Equity Value Per Share | -0.45 |
What You Will Receive
- Comprehensive Financial Model: STAAR Surgical Company’s actual performance data facilitates accurate DCF valuation.
- Complete Forecast Control: Modify revenue growth, profit margins, WACC, and other essential factors.
- Real-Time Calculations: Automatic updates provide immediate insights as you adjust parameters.
- Professional-Grade Template: A polished Excel file crafted for high-quality valuation presentations.
- Flexible and Reusable: Designed for adaptability, enabling frequent use for in-depth forecasts.
Key Features
- Comprehensive Data: STAAR Surgical Company’s historical financial statements and pre-filled projections.
- Customizable Variables: Adjust WACC, tax rates, revenue growth, and EBITDA margins as needed.
- Real-Time Insights: Observe STAAR Surgical’s intrinsic value recalculating instantly.
- Visual Representation: Dashboard graphs illustrate valuation outcomes and essential metrics.
- Precision Focused: A reliable tool designed for analysts, investors, and finance professionals.
How It Works
- 1. Download the Template: Obtain and open the Excel file containing STAAR Surgical Company's (STAA) preloaded data.
- 2. Adjust Key Inputs: Modify essential parameters such as growth rates, WACC, and capital expenditures.
- 3. Analyze Results in Real-Time: The DCF model automatically computes intrinsic value and NPV.
- 4. Explore Different Scenarios: Evaluate various forecasts to understand diverse valuation results.
- 5. Make Informed Decisions: Present expert valuation analyses to back your strategic choices.
Why Choose This Calculator for STAAR Surgical Company (STAA)?
- User-Friendly Interface: Tailored for both novices and seasoned professionals.
- Customizable Inputs: Adjust parameters easily to suit your financial analysis.
- Real-Time Feedback: Observe immediate updates to STAAR Surgical's valuation as you tweak inputs.
- Pre-Loaded Data: Comes with STAAR Surgical’s latest financial information for swift assessments.
- Preferred by Experts: Utilized by investors and analysts for making well-informed choices.
Who Should Use STAAR Surgical Company (STAA)?
- Healthcare Investors: Make informed investment choices with advanced insights into ophthalmic technologies.
- Market Analysts: Streamline your analysis process with comprehensive data on eye care innovations.
- Medical Consultants: Efficiently tailor presentations and reports for clients in the healthcare sector.
- Ophthalmology Enthusiasts: Enhance your knowledge of vision correction solutions through real-world applications.
- Educators and Students: Utilize it as a hands-on resource in medical and business education programs.
What the Template Contains
- Comprehensive DCF Model: Editable template featuring detailed valuation calculations tailored for STAAR Surgical Company (STAA).
- Real-World Data: STAAR Surgical’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 the company's performance.
- Key Ratios: Integrated analysis for profitability, efficiency, and leverage metrics specific to STAAR Surgical Company (STAA).
- Dashboard with Visual Outputs: Charts and tables providing clear, actionable results for informed decision-making.