Milestone Pharmaceuticals Inc. (MIST) 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
Milestone Pharmaceuticals Inc. (MIST) Bundle
Enhance your investment choices with the Milestone Pharmaceuticals Inc. (MIST) DCF Calculator! Explore real financial data for Milestone, adjust growth projections and expenses, and instantly visualize how these changes affect the intrinsic value of MIST.
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 | .0 | .0 | 15.0 | 5.0 | 1.0 | .6 | .4 | .3 | .2 | .1 |
| Revenue Growth, % | 0 | 0 | 0 | -66.67 | -80 | -36.67 | -36.67 | -36.67 | -36.67 | -36.67 |
| EBITDA | -57.9 | -50.7 | -43.0 | -58.4 | -56.8 | -.1 | -.1 | -.1 | .0 | .0 |
| EBITDA, % | 100 | 100 | -286.53 | -1167.28 | -5684.5 | -20 | -20 | -20 | -20 | -20 |
| Depreciation | .2 | .4 | .4 | .5 | .1 | .3 | .2 | .1 | .1 | .0 |
| Depreciation, % | 100 | 100 | 2.41 | 9.6 | 9.2 | 44.24 | 44.24 | 44.24 | 44.24 | 44.24 |
| EBIT | -58.1 | -51.1 | -43.3 | -58.8 | -56.9 | -.1 | -.1 | -.1 | .0 | .0 |
| EBIT, % | 100 | 100 | -288.95 | -1176.88 | -5693.7 | -20 | -20 | -20 | -20 | -20 |
| Total Cash | 119.8 | 142.3 | 114.1 | 64.6 | 66.0 | .6 | .4 | .3 | .2 | .1 |
| Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
| Account Receivables | .8 | .9 | .5 | 1.2 | 3.9 | .4 | .3 | .2 | .1 | .1 |
| Account Receivables, % | 100 | 100 | 3.22 | 24.26 | 385.1 | 65.5 | 65.5 | 65.5 | 65.5 | 65.5 |
| Inventories | -.6 | -.7 | -.4 | -.3 | .0 | .2 | .2 | .1 | .1 | .0 |
| Inventories, % | 100 | 100 | -2.37 | -6.62 | 0 | 38.2 | 38.2 | 38.2 | 38.2 | 38.2 |
| Accounts Payable | 4.4 | 4.6 | 4.4 | 2.3 | 4.0 | .5 | .3 | .2 | .1 | .1 |
| Accounts Payable, % | 100 | 100 | 29.23 | 45.26 | 398.1 | 74.9 | 74.9 | 74.9 | 74.9 | 74.9 |
| Capital Expenditure | -.4 | .0 | .0 | -.3 | -.1 | .0 | .0 | .0 | .0 | .0 |
| Capital Expenditure, % | 100 | 100 | 0 | -5.44 | -11.2 | -3.33 | -3.33 | -3.33 | -3.33 | -3.33 |
| Tax Rate, % | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
| EBITAT | -58.1 | -51.1 | -43.1 | -57.6 | -56.9 | -.1 | -.1 | -.1 | .0 | .0 |
| Depreciation | ||||||||||
| Changes in Account Receivables | ||||||||||
| Changes in Inventories | ||||||||||
| Changes in Accounts Payable | ||||||||||
| Capital Expenditure | ||||||||||
| UFCF | -54.1 | -50.4 | -42.9 | -60.2 | -58.2 | -.2 | .2 | .1 | .1 | .0 |
| WACC, % | 9.85 | 9.85 | 9.84 | 9.81 | 9.85 | 9.84 | 9.84 | 9.84 | 9.84 | 9.84 |
| PV UFCF | ||||||||||
| SUM PV UFCF | .1 | |||||||||
| Long Term Growth Rate, % | 2.00 | |||||||||
| Free cash flow (T + 1) | 0 | |||||||||
| Terminal Value | 0 | |||||||||
| Present Terminal Value | 0 | |||||||||
| Enterprise Value | 0 | |||||||||
| Net Debt | 38 | |||||||||
| Equity Value | -38 | |||||||||
| Diluted Shares Outstanding, MM | 43 | |||||||||
| Equity Value Per Share | -0.88 |
What You Will Get
- Comprehensive Milestone Data: Preloaded financials – from revenue to EBIT – based on actual and projected figures for Milestone Pharmaceuticals Inc. (MIST).
- Full Customization: Adjust all critical parameters (yellow cells) like WACC, growth %, and tax rates to suit your analysis.
- Instant Valuation Updates: Automatic recalculations to assess the impact of changes on Milestone Pharmaceuticals Inc.'s (MIST) fair value.
- Versatile Excel Template: Designed for quick edits, scenario testing, and detailed projections specific to Milestone Pharmaceuticals Inc. (MIST).
- Time-Saving and Accurate: Eliminate the need to build models from scratch while ensuring precision and flexibility.
Key Features
- Comprehensive Financial Data: Gain access to precise historical data and future forecasts for Milestone Pharmaceuticals Inc. (MIST).
- Adjustable Forecast Parameters: Modify highlighted fields such as discount rates, growth projections, and profit margins.
- Real-Time Calculations: Enjoy automatic updates for DCF, Net Present Value (NPV), and cash flow assessments.
- User-Friendly Dashboard: Visualize your valuation outcomes with clear charts and concise summaries.
- Suitable for All Levels: Designed for investors, CFOs, and consultants with a straightforward and intuitive layout.
How It Works
- Step 1: Download the Excel file for Milestone Pharmaceuticals Inc. (MIST).
- Step 2: Review the pre-filled financial data and forecasts specific to Milestone Pharmaceuticals.
- Step 3: Adjust key inputs such as revenue growth, WACC, and tax rates (highlighted cells).
- Step 4: Observe the DCF model update in real-time as you modify your assumptions.
- Step 5: Evaluate the outputs and leverage the results for your investment strategies.
Why Choose This Calculator?
- User-Friendly Interface: Tailored for both newcomers and seasoned professionals.
- Customizable Inputs: Adjust parameters easily to suit your financial analysis.
- Real-Time Feedback: Observe immediate changes to Milestone Pharmaceuticals Inc.'s (MIST) valuation as you modify inputs.
- Preloaded Data: Comes with Milestone Pharmaceuticals Inc.'s (MIST) actual financial metrics for swift evaluations.
- Relied Upon by Experts: Utilized by investors and analysts for making well-informed investment choices.
Who Should Use Milestone Pharmaceuticals Inc. (MIST)?
- Investors: Gain insights into the pharmaceutical market with comprehensive data and analysis tools.
- Healthcare Analysts: Streamline your research with ready-to-use financial models tailored for biotech companies.
- Consultants: Easily modify presentations and reports to showcase Milestone Pharmaceuticals Inc. (MIST) to clients.
- Pharmaceutical Enthusiasts: Enhance your knowledge of drug development and market strategies through detailed case studies.
- Educators and Students: Utilize it as a valuable resource for coursework in pharmaceutical finance and management.
What the Milestone Pharmaceuticals Template Contains
- Comprehensive DCF Model: Editable template with detailed valuation calculations tailored for Milestone Pharmaceuticals Inc. (MIST).
- Real-World Data: Milestone Pharmaceuticals’ historical and projected financials preloaded for thorough analysis.
- Customizable Parameters: Adjust 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: Built-in analysis focusing on profitability, efficiency, and leverage specific to Milestone Pharmaceuticals.
- Dashboard with Visual Outputs: Charts and tables providing clear, actionable results for informed decision-making.