InspireMD, Inc. (NSPR) DCF Valuation
- ✓ Fully Editable: Tailor To Your Needs In Excel Or Sheets
- ✓ Professional Design: Trusted, Industry-Standard Templates
- ✓ Pre-Built For Quick And Efficient Use
- ✓ No Expertise Is Needed; Easy To Follow
InspireMD, Inc. (NSPR) Bundle
Explore InspireMD, Inc.'s (NSPR) financial outlook with our user-friendly DCF Calculator! Enter your projections for growth, margins, and expenses to uncover InspireMD, Inc.'s (NSPR) intrinsic value and inform your investment decisions.
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 | 3.7 | 2.5 | 4.5 | 5.2 | 6.2 | 7.5 | 9.0 | 10.9 | 13.2 | 15.9 |
Revenue Growth, % | 0 | -33.22 | 80.89 | 15.04 | 20 | 20.68 | 20.68 | 20.68 | 20.68 | 20.68 |
EBITDA | -9.9 | -10.4 | -14.6 | -18.5 | -20.9 | -7.5 | -9.0 | -10.9 | -13.2 | -15.9 |
EBITDA, % | -264.93 | -418.07 | -323.8 | -358.25 | -337 | -100 | -100 | -100 | -100 | -100 |
Depreciation | .2 | .2 | .2 | .2 | .2 | .3 | .4 | .5 | .6 | .7 |
Depreciation, % | 4.25 | 6.08 | 3.58 | 3.64 | 3.74 | 4.26 | 4.26 | 4.26 | 4.26 | 4.26 |
EBIT | -10.0 | -10.5 | -14.7 | -18.7 | -21.1 | -7.5 | -9.0 | -10.9 | -13.2 | -15.9 |
EBIT, % | -269.17 | -424.14 | -327.39 | -361.88 | -340.74 | -100 | -100 | -100 | -100 | -100 |
Total Cash | 5.5 | 12.6 | 34.0 | 17.8 | 39.0 | 7.5 | 9.0 | 10.9 | 13.2 | 15.9 |
Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
Account Receivables | 1.0 | .9 | 1.4 | 1.2 | 2.5 | 2.4 | 2.9 | 3.5 | 4.2 | 5.0 |
Account Receivables, % | 26.15 | 38.03 | 30.9 | 24.12 | 39.52 | 31.74 | 31.74 | 31.74 | 31.74 | 31.74 |
Inventories | 1.2 | 1.4 | 1.1 | 1.6 | 2.1 | 2.7 | 3.3 | 3.9 | 4.8 | 5.7 |
Inventories, % | 33.22 | 56.94 | 25.43 | 31.35 | 33.94 | 36.18 | 36.18 | 36.18 | 36.18 | 36.18 |
Accounts Payable | .6 | .2 | .9 | .7 | .9 | 1.1 | 1.3 | 1.6 | 2.0 | 2.4 |
Accounts Payable, % | 17.36 | 9.5 | 19.87 | 12.74 | 15.13 | 14.92 | 14.92 | 14.92 | 14.92 | 14.92 |
Capital Expenditure | -.3 | -.1 | -.3 | -.5 | -.4 | -.5 | -.6 | -.7 | -.9 | -1.1 |
Capital Expenditure, % | -7.63 | -3.54 | -7.65 | -9.15 | -6.14 | -6.82 | -6.82 | -6.82 | -6.82 | -6.82 |
Tax Rate, % | -0.32744 | -0.32744 | -0.32744 | -0.32744 | -0.32744 | -0.32744 | -0.32744 | -0.32744 | -0.32744 | -0.32744 |
EBITAT | -10.0 | -10.5 | -14.8 | -18.7 | -21.2 | -7.5 | -9.0 | -10.9 | -13.2 | -15.9 |
Depreciation | ||||||||||
Changes in Account Receivables | ||||||||||
Changes in Inventories | ||||||||||
Changes in Accounts Payable | ||||||||||
Capital Expenditure | ||||||||||
UFCF | -11.7 | -11.0 | -14.5 | -19.6 | -22.8 | -8.0 | -10.1 | -12.2 | -14.7 | -17.7 |
WACC, % | 8.73 | 8.73 | 8.73 | 8.73 | 8.73 | 8.73 | 8.73 | 8.73 | 8.73 | 8.73 |
PV UFCF | ||||||||||
SUM PV UFCF | -47.6 | |||||||||
Long Term Growth Rate, % | 2.00 | |||||||||
Free cash flow (T + 1) | -18 | |||||||||
Terminal Value | -269 | |||||||||
Present Terminal Value | -177 | |||||||||
Enterprise Value | -225 | |||||||||
Net Debt | -8 | |||||||||
Equity Value | -216 | |||||||||
Diluted Shares Outstanding, MM | 24 | |||||||||
Equity Value Per Share | -8.92 |
What You Will Get
- Real InspireMD Data: Preloaded financials – from revenue to EBIT – based on actual and projected figures for InspireMD, Inc. (NSPR).
- Full Customization: Adjust all critical parameters (yellow cells) such as WACC, growth %, and tax rates specific to InspireMD.
- Instant Valuation Updates: Automatic recalculations to analyze the impact of changes on InspireMD’s fair value.
- Versatile Excel Template: Tailored for quick edits, scenario testing, and detailed projections for InspireMD, Inc. (NSPR).
- Time-Saving and Accurate: Skip building models from scratch while ensuring precision and flexibility for InspireMD.
Key Features
- Comprehensive Historical Data: InspireMD's (NSPR) past financial reports and projected forecasts included.
- Customizable Parameters: Adjust discount rates, tax percentages, revenue growth, and profit margins as needed.
- Real-Time Analysis: View InspireMD's intrinsic value updating instantly.
- Intuitive Visual Representations: Interactive charts showcase valuation outcomes and essential metrics.
- Designed for Precision: A reliable resource tailored for analysts, investors, and financial professionals.
How It Works
- Download the Template: Gain immediate access to the Excel-based InspireMD, Inc. (NSPR) DCF Calculator.
- Input Your Assumptions: Modify the yellow-highlighted cells for growth rates, WACC, margins, and other variables.
- Instant Calculations: The model automatically recalculates InspireMD, Inc.'s (NSPR) intrinsic value.
- Test Scenarios: Experiment with different assumptions to assess potential changes in valuation.
- Analyze and Decide: Utilize the results to inform your investment or financial analysis decisions.
Why Choose InspireMD's Calculator?
- Precision: Utilizes real InspireMD financials for reliable data accuracy.
- Adaptability: Built for users to experiment and adjust inputs with ease.
- Efficiency: Bypass the complexity of creating a DCF model from the ground up.
- Expert-Level: Crafted with the precision and usability expected by CFOs.
- Intuitive: Simple to navigate, even for those lacking advanced financial modeling skills.
Who Should Use InspireMD, Inc. (NSPR)?
- Medical Device Investors: Develop comprehensive and reliable valuation models for investment analysis in the medical technology sector.
- Healthcare Finance Teams: Evaluate valuation scenarios to inform strategic decisions within healthcare organizations.
- Consultants and Advisors: Offer clients precise valuation insights for InspireMD, Inc. (NSPR) and similar companies.
- Students and Educators: Utilize real-world data to learn and teach financial modeling in the context of medical devices.
- Healthcare Technology Enthusiasts: Gain insights into how companies like InspireMD, Inc. (NSPR) are valued in the healthcare market.
What the Template Contains
- Comprehensive DCF Model: Editable template featuring detailed valuation calculations.
- Real-World Data: InspireMD, Inc.'s (NSPR) historical and projected financials preloaded for analysis.
- Customizable Parameters: Adjust WACC, growth rates, and tax assumptions to explore various scenarios.
- Financial Statements: Complete annual and quarterly breakdowns for enhanced insights.
- Key Ratios: Integrated analysis for profitability, efficiency, and leverage metrics.
- Dashboard with Visual Outputs: Charts and tables designed for clear, actionable results.