Minerva Surgical, Inc. (UTRS) 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
Minerva Surgical, Inc. (UTRS) Bundle
Discover the true value of Minerva Surgical, Inc. (UTRS) with our top-tier DCF Calculator! Adjust essential assumptions, explore various scenarios, and examine how modifications affect Minerva Surgical's valuation – all within one convenient Excel template.
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).