Helius Medical Technologies, Inc. (HSDT) 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
Helius Medical Technologies, Inc. (HSDT) Bundle
Looking to determine the intrinsic value of Helius Medical Technologies, Inc.? Our HSDT DCF Calculator integrates real-world data with comprehensive customization features, allowing you to refine your projections and enhance your investment choices.
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 | 1.5 | .7 | .5 | .8 | .6 | .6 | .5 | .5 | .4 | .4 |
| Revenue Growth, % | 0 | -55.82 | -21.03 | 50.77 | -18.17 | -11.06 | -11.06 | -11.06 | -11.06 | -11.06 |
| EBITDA | -23.9 | -13.9 | -17.8 | -14.5 | -12.1 | -.6 | -.5 | -.5 | -.4 | -.4 |
| EBITDA, % | -1599.73 | -2103.48 | -3413.79 | -1842.95 | -1879.97 | -100 | -100 | -100 | -100 | -100 |
| Depreciation | .2 | .5 | .4 | .3 | .2 | .3 | .2 | .2 | .2 | .2 |
| Depreciation, % | 12.77 | 72.92 | 71.65 | 38.88 | 25.16 | 44.27 | 44.27 | 44.27 | 44.27 | 44.27 |
| EBIT | -24.1 | -14.4 | -18.2 | -14.8 | -12.3 | -.6 | -.5 | -.5 | -.4 | -.4 |
| EBIT, % | -1612.5 | -2176.4 | -3485.44 | -1881.83 | -1905.12 | -100 | -100 | -100 | -100 | -100 |
| Total Cash | 5.5 | 3.3 | 11.0 | 14.5 | 5.2 | .6 | .5 | .5 | .4 | .4 |
| Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
| Account Receivables | .6 | .2 | .3 | .3 | .6 | .3 | .3 | .2 | .2 | .2 |
| Account Receivables, % | 38.37 | 34.8 | 48.08 | 43.58 | 98.91 | 52.75 | 52.75 | 52.75 | 52.75 | 52.75 |
| Inventories | .6 | .4 | .5 | .6 | .5 | .4 | .3 | .3 | .3 | .2 |
| Inventories, % | 39.97 | 58.85 | 91.19 | 74.84 | 70.96 | 67.16 | 67.16 | 67.16 | 67.16 | 67.16 |
| Accounts Payable | 1.7 | .7 | 1.1 | .6 | .5 | .5 | .5 | .4 | .4 | .3 |
| Accounts Payable, % | 112.03 | 113.01 | 204.79 | 79.67 | 82.45 | 92.42 | 92.42 | 92.42 | 92.42 | 92.42 |
| Capital Expenditure | -.4 | -.1 | -.1 | .0 | .0 | -.1 | -.1 | .0 | .0 | .0 |
| Capital Expenditure, % | -23.6 | -10.59 | -10.73 | -2.16 | -4.5 | -10.32 | -10.32 | -10.32 | -10.32 | -10.32 |
| Tax Rate, % | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
| EBITAT | 10.7 | -14.2 | -18.2 | -13.2 | -12.3 | -.4 | -.4 | -.4 | -.3 | -.3 |
| Depreciation | ||||||||||
| Changes in Account Receivables | ||||||||||
| Changes in Inventories | ||||||||||
| Changes in Accounts Payable | ||||||||||
| Capital Expenditure | ||||||||||
| UFCF | 11.0 | -14.2 | -17.7 | -13.6 | -12.4 | .2 | -.2 | -.2 | -.2 | -.1 |
| WACC, % | 10.64 | 11.16 | 11.17 | 11.11 | 11.17 | 11.05 | 11.05 | 11.05 | 11.05 | 11.05 |
| PV UFCF | ||||||||||
| SUM PV UFCF | -.4 | |||||||||
| Long Term Growth Rate, % | 2.00 | |||||||||
| Free cash flow (T + 1) | 0 | |||||||||
| Terminal Value | -2 | |||||||||
| Present Terminal Value | -1 | |||||||||
| Enterprise Value | -1 | |||||||||
| Net Debt | -5 | |||||||||
| Equity Value | 4 | |||||||||
| Diluted Shares Outstanding, MM | 1 | |||||||||
| Equity Value Per Share | 6.27 |
What You Will Get
- Editable Excel Template: A fully customizable Excel-based DCF Calculator featuring pre-filled real HSDT financials.
- Real-World Data: Historical data and forward-looking estimates (highlighted in the yellow cells).
- Forecast Flexibility: Adjust forecast assumptions such as revenue growth, EBITDA %, and WACC.
- Automatic Calculations: Instantly observe the effect of your inputs on Helius Medical Technologies’ valuation.
- Professional Tool: Designed for investors, CFOs, consultants, and financial analysts.
- User-Friendly Design: Organized for clarity and ease of use, complete with step-by-step instructions.
Key Features
- Real-Life HSDT Data: Pre-filled with Helius Medical Technologies' historical financials and future growth projections.
- Fully Customizable Inputs: Modify revenue growth rates, profit margins, discount rates, tax considerations, and capital investments.
- Dynamic Valuation Model: Automatic updates to Net Present Value (NPV) and intrinsic value based on your specified inputs.
- Scenario Testing: Develop various forecasting scenarios to evaluate different valuation results.
- User-Friendly Design: Intuitive, organized, and crafted for both professionals and newcomers.
How It Works
- Download the Template: Get instant access to the Excel-based Helius Medical Technologies DCF Calculator.
- Input Your Assumptions: Adjust yellow-highlighted cells for growth rates, WACC, margins, and more.
- Instant Calculations: The model automatically updates Helius Medical Technologies’ intrinsic value.
- Test Scenarios: Simulate different assumptions to evaluate potential valuation changes.
- Analyze and Decide: Use the results to guide your investment or financial analysis.
Why Choose This Calculator?
- Designed for Experts: A sophisticated tool utilized by analysts, CFOs, and consultants in the medical technology field.
- Accurate Data: Helius Medical Technologies' historical and projected financials are preloaded for precision.
- Scenario Analysis: Easily simulate various forecasts and assumptions to explore different outcomes.
- Comprehensive Outputs: Automatically calculates intrinsic value, NPV, and essential metrics for informed decision-making.
- User-Friendly: Step-by-step instructions ensure a smooth experience throughout the calculation process.
Who Should Use This Product?
- Healthcare Investors: Develop comprehensive valuation models for assessing Helius Medical Technologies, Inc. (HSDT).
- Medical Device Teams: Evaluate valuation scenarios to inform product development strategies.
- Consultants and Advisors: Offer clients precise valuation insights for Helius Medical Technologies, Inc. (HSDT).
- Students and Educators: Utilize real-world data to practice and teach financial modeling in the healthcare sector.
- Tech and Medical Enthusiasts: Gain insights into how innovative medical technology companies like Helius Medical Technologies, Inc. (HSDT) are valued.
What the Template Contains
- Pre-Filled Data: Includes Helius Medical Technologies’ historical financials and forecasts.
- Discounted Cash Flow Model: Editable DCF valuation model with automatic calculations.
- Weighted Average Cost of Capital (WACC): A dedicated sheet for calculating WACC based on custom inputs.
- Key Financial Ratios: Analyze Helius Medical Technologies’ profitability, efficiency, and leverage.
- Customizable Inputs: Edit revenue growth, margins, and tax rates with ease.
- Clear Dashboard: Charts and tables summarizing key valuation results.