|
Valoración de DCF de Minerva Surgical, Inc. (UTRS)
US | Healthcare | Medical - Healthcare Information Services | NASDAQ
|
- ✓ 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
Minerva Surgical, Inc. (UTRS) Bundle
¡Descubra el verdadero valor de Minerva Surgical, Inc. (UTR) con nuestra calculadora DCF de nivel superior! Ajuste los supuestos esenciales, explore varios escenarios y examine cómo las modificaciones afectan la valoración de Minerva Surgical, todo dentro de una plantilla de Excel conveniente.
Discounted Cash Flow (DCF) - (USD MM)
Year | AY1 2019 |
AY2 2020 |
AY3 2021 |
AY4 2022 |
FY1 2023 |
FY2 2024 |
FY3 2025 |
FY4 2026 |
FY5 2027 |
|
---|---|---|---|---|---|---|---|---|---|---|
Revenue | 26.0 | 37.8 | 52.1 | 50.3 | 63.7 | 80.6 | 102.0 | 129.0 | 163.3 | |
Revenue Growth, % | 0 | 45.19 | 37.96 | -3.47 | 26.56 | 26.56 | 26.56 | 26.56 | 26.56 | |
EBITDA | -17.7 | -8.2 | -18.9 | -20.1 | -26.3 | -33.3 | -42.2 | -53.4 | -67.6 | |
EBITDA, % | -67.88 | -21.61 | -36.19 | -39.91 | -41.4 | -41.4 | -41.4 | -41.4 | -41.4 | |
Depreciation | 2.0 | 7.2 | 10.3 | 10.8 | 10.8 | 13.7 | 17.3 | 21.9 | 27.8 | |
Depreciation, % | 7.62 | 19.14 | 19.75 | 21.49 | 17 | 17 | 17 | 17 | 17 | |
EBIT | -19.6 | -15.4 | -29.1 | -30.9 | -37.2 | -47.0 | -59.5 | -75.3 | -95.4 | |
EBIT, % | -75.49 | -40.75 | -55.94 | -61.4 | -58.39 | -58.39 | -58.39 | -58.39 | -58.39 | |
Total Cash | 27.1 | 17.4 | 40.6 | 6.9 | 37.8 | 47.9 | 60.6 | 76.7 | 97.0 | |
Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | |
Account Receivables | 3.9 | 8.4 | 7.3 | 7.2 | 10.5 | 13.2 | 16.8 | 21.2 | 26.8 | |
Account Receivables, % | 15.17 | 22.19 | 14 | 14.4 | 16.44 | 16.44 | 16.44 | 16.44 | 16.44 | |
Inventories | 4.7 | 10.2 | 15.7 | 16.9 | 17.3 | 21.9 | 27.7 | 35.1 | 44.4 | |
Inventories, % | 18.24 | 27.01 | 30.1 | 33.5 | 27.21 | 27.21 | 27.21 | 27.21 | 27.21 | |
Accounts Payable | 4.2 | 3.5 | 3.6 | 2.8 | 6.0 | 7.6 | 9.7 | 12.2 | 15.5 | |
Accounts Payable, % | 16.12 | 9.28 | 6.97 | 5.58 | 9.49 | 9.49 | 9.49 | 9.49 | 9.49 | |
Capital Expenditure | -.2 | -.5 | -.6 | -.1 | -.5 | -.7 | -.8 | -1.1 | -1.4 | |
Capital Expenditure, % | -0.8573 | -1.2 | -1.12 | -0.14515 | -0.83068 | -0.83068 | -0.83068 | -0.83068 | -0.83068 | |
Tax Rate, % | -0.03225712 | -0.03225712 | -0.03225712 | -0.03225712 | -0.03225712 | -0.03225712 | -0.03225712 | -0.03225712 | -0.03225712 | |
EBITAT | -26.3 | -15.3 | -29.2 | -30.9 | -37.1 | -47.0 | -59.4 | -75.2 | -95.2 | |
Depreciation | ||||||||||
Changes in Account Receivables | ||||||||||
Changes in Inventories | ||||||||||
Changes in Accounts Payable | ||||||||||
Capital Expenditure | ||||||||||
UFCF | -29.1 | -19.1 | -23.7 | -22.1 | -27.3 | -39.7 | -50.3 | -63.6 | -80.5 | |
WACC, % | 8.12 | 8.06 | 8.12 | 8.12 | 8.1 | 8.1 | 8.1 | 8.1 | 8.1 | |
PV UFCF | ||||||||||
SUM PV UFCF | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | -200.1 | |
Long Term Growth Rate, % | 2.00 | |||||||||
Free cash flow (T + 1) | -82 | |||||||||
Terminal Value | -1,345 | |||||||||
Present Terminal Value | -911 | |||||||||
Enterprise Value | -1,111 | |||||||||
Net Debt | 33 | |||||||||
Equity Value | -1,144 | |||||||||
Diluted Shares Outstanding, MM | 1 | |||||||||
Equity Value Per Share | -794.21 |
What You Will Receive
- Genuine Minerva Data: Preloaded financials – from revenue to EBIT – based on actual and projected figures for Minerva Surgical, Inc. (UTRS).
- Complete Customization: Modify all essential parameters (yellow cells) such as WACC, growth %, and tax rates.
- Immediate Valuation Updates: Automatic recalculations to assess the effects of changes on Minerva’s fair value.
- Flexible Excel Template: Designed for quick adjustments, scenario analysis, and comprehensive projections.
- Efficient and Precise: Avoid starting from scratch while ensuring accuracy and adaptability.
Key Features
- Comprehensive Financial Data: Gain access to precise pre-loaded historical figures and future forecasts for Minerva Surgical, Inc. (UTRS).
- Adjustable Forecast Parameters: Modify yellow-highlighted fields such as WACC, growth rates, and profit margins.
- Real-Time Calculations: Automatic updates for DCF, Net Present Value (NPV), and cash flow assessments.
- User-Friendly Dashboard: Intuitive charts and summaries to easily interpret your valuation outcomes.
- Suitable for All Levels: A straightforward, user-centric design tailored for investors, CFOs, and consultants alike.
How It Works
- Download: Obtain the pre-formatted Excel file containing Minerva Surgical, Inc.’s (UTRS) financial data.
- Customize: Modify projections, such as revenue growth, EBITDA %, and WACC.
- Update Automatically: The intrinsic value and NPV calculations refresh in real-time.
- Test Scenarios: Generate various forecasts and instantly compare results.
- Make Decisions: Leverage the valuation insights to inform your investment strategy.
Why Choose Minerva Surgical, Inc. (UTRS) Calculator?
- Comprehensive Tool: Offers analyses for DCF, WACC, and financial ratios all in one solution.
- Customizable Inputs: Modify the yellow-highlighted cells to explore different financial scenarios.
- Detailed Insights: Automatically computes Minerva Surgical’s intrinsic value and Net Present Value.
- Preloaded Data: Access to both historical and projected data for reliable benchmarks.
- Professional Quality: Perfect for financial analysts, investors, and business advisors.
Who Should Use This Product?
- Healthcare Investors: Develop comprehensive valuation models for Minerva Surgical, Inc. (UTRS) to enhance portfolio performance.
- Medical Device Teams: Evaluate valuation scenarios to inform product development and market strategies.
- Consultants and Advisors: Deliver precise valuation insights for clients interested in Minerva Surgical, Inc. (UTRS).
- Students and Educators: Utilize current data to practice and teach financial modeling in the healthcare sector.
- Industry Analysts: Gain insights into how medical technology companies like Minerva Surgical, Inc. (UTRS) are valued within the market.
What the Template Contains
- Pre-Filled DCF Model: Minerva Surgical, Inc.'s (UTRS) financial data preloaded for immediate use.
- WACC Calculator: Detailed calculations for Weighted Average Cost of Capital specific to Minerva Surgical, Inc. (UTRS).
- Financial Ratios: Evaluate Minerva Surgical, Inc.'s (UTRS) profitability, leverage, and efficiency.
- Editable Inputs: Change assumptions such as growth, margins, and CAPEX to fit your scenarios for Minerva Surgical, Inc. (UTRS).
- Financial Statements: Annual and quarterly reports from Minerva Surgical, Inc. (UTRS) to support detailed analysis.
- Interactive Dashboard: Easily visualize key valuation metrics and results for Minerva Surgical, Inc. (UTRS).