Viemed Healthcare, Inc. (VMD) 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
Viemed Healthcare, Inc. (VMD) Bundle
As an investor or analyst, this DCF Calculator for Viemed Healthcare, Inc. (VMD) is your go-to resource for accurate valuation. With real data from Viemed Healthcare already integrated, you can adjust forecasts and instantly observe the effects.
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 | 80.3 | 131.3 | 117.1 | 138.8 | 183.0 | 230.2 | 289.6 | 364.3 | 458.3 | 576.5 |
Revenue Growth, % | 0 | 63.61 | -10.85 | 18.6 | 31.82 | 25.79 | 25.79 | 25.79 | 25.79 | 25.79 |
EBITDA | 15.6 | 30.5 | 21.8 | 24.0 | 36.7 | 45.5 | 57.2 | 71.9 | 90.5 | 113.8 |
EBITDA, % | 19.46 | 23.25 | 18.66 | 17.31 | 20.06 | 19.75 | 19.75 | 19.75 | 19.75 | 19.75 |
Depreciation | 6.4 | 9.6 | 11.3 | 15.6 | 21.9 | 22.2 | 27.9 | 35.1 | 44.1 | 55.5 |
Depreciation, % | 7.97 | 7.3 | 9.66 | 11.26 | 11.95 | 9.63 | 9.63 | 9.63 | 9.63 | 9.63 |
EBIT | 9.2 | 21.0 | 10.5 | 8.4 | 14.8 | 23.3 | 29.3 | 36.9 | 46.4 | 58.3 |
EBIT, % | 11.48 | 15.96 | 8.99 | 6.05 | 8.11 | 10.12 | 10.12 | 10.12 | 10.12 | 10.12 |
Total Cash | 13.4 | 31.0 | 28.4 | 16.9 | 12.8 | 38.5 | 48.5 | 61.0 | 76.7 | 96.5 |
Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
Account Receivables | 11.5 | 12.4 | 14.7 | 15.4 | 18.5 | 26.5 | 33.3 | 41.9 | 52.7 | 66.3 |
Account Receivables, % | 14.37 | 9.42 | 12.57 | 11.1 | 10.08 | 11.51 | 11.51 | 11.51 | 11.51 | 11.51 |
Inventories | 1.4 | 2.3 | 2.5 | 3.6 | 4.6 | 4.9 | 6.2 | 7.8 | 9.8 | 12.3 |
Inventories, % | 1.69 | 1.76 | 2.1 | 2.57 | 2.53 | 2.13 | 2.13 | 2.13 | 2.13 | 2.13 |
Accounts Payable | 4.7 | 2.1 | 3.2 | 2.7 | 7.4 | 7.4 | 9.4 | 11.8 | 14.8 | 18.7 |
Accounts Payable, % | 5.86 | 1.6 | 2.77 | 1.91 | 4.05 | 3.24 | 3.24 | 3.24 | 3.24 | 3.24 |
Capital Expenditure | -13.4 | -13.0 | -19.7 | -22.9 | -26.1 | -34.2 | -43.0 | -54.1 | -68.0 | -85.6 |
Capital Expenditure, % | -16.68 | -9.93 | -16.87 | -16.49 | -14.26 | -14.85 | -14.85 | -14.85 | -14.85 | -14.85 |
Tax Rate, % | 28.82 | 28.82 | 28.82 | 28.82 | 28.82 | 28.82 | 28.82 | 28.82 | 28.82 | 28.82 |
EBITAT | 8.9 | 25.1 | 7.7 | 5.8 | 10.6 | 19.1 | 24.0 | 30.3 | 38.1 | 47.9 |
Depreciation | ||||||||||
Changes in Account Receivables | ||||||||||
Changes in Inventories | ||||||||||
Changes in Accounts Payable | ||||||||||
Capital Expenditure | ||||||||||
UFCF | -6.2 | 17.2 | -2.1 | -3.9 | 7.0 | -1.2 | 2.8 | 3.5 | 4.4 | 5.5 |
WACC, % | 11.02 | 11.02 | 10.99 | 10.98 | 10.98 | 11 | 11 | 11 | 11 | 11 |
PV UFCF | ||||||||||
SUM PV UFCF | 9.8 | |||||||||
Long Term Growth Rate, % | 2.00 | |||||||||
Free cash flow (T + 1) | 6 | |||||||||
Terminal Value | 62 | |||||||||
Present Terminal Value | 37 | |||||||||
Enterprise Value | 47 | |||||||||
Net Debt | -3 | |||||||||
Equity Value | 49 | |||||||||
Diluted Shares Outstanding, MM | 40 | |||||||||
Equity Value Per Share | 1.22 |
What You Will Get
- Comprehensive VMD Financials: Provides historical and projected data for precise valuation.
- Customizable Inputs: Adjust WACC, tax rates, revenue growth, and capital expenditures as needed.
- Dynamic Calculations: Intrinsic value and NPV are computed in real-time.
- Scenario Analysis: Evaluate various scenarios to assess Viemed’s future performance.
- User-Friendly Design: Designed for industry professionals while remaining accessible to newcomers.
Key Features
- Comprehensive Financial Data: Gain access to precise pre-loaded historical figures and future forecasts for Viemed Healthcare, Inc. (VMD).
- Adjustable Forecast Parameters: Modify highlighted cells for assumptions such as WACC, growth rates, and margins to suit your analysis.
- Real-Time Calculations: Automatic recalculations for DCF, Net Present Value (NPV), and cash flow assessments.
- User-Friendly Dashboard: Intuitive charts and summaries designed to help you visualize your valuation outcomes.
- Suitable for All Experience Levels: A straightforward, user-centric layout tailored for investors, CFOs, and consultants alike.
How It Works
- Step 1: Download the Excel file.
- Step 2: Review pre-entered Viemed Healthcare data (historical and projected).
- Step 3: Adjust key assumptions (yellow cells) based on your analysis.
- Step 4: View automatic recalculations for Viemed Healthcare’s intrinsic value.
- Step 5: Use the outputs for investment decisions or reporting.
Why Choose This Calculator for Viemed Healthcare, Inc. (VMD)?
- All-in-One Solution: Features DCF, WACC, and comprehensive financial ratio analyses tailored for healthcare.
- Flexible Inputs: Modify the highlighted cells to explore different financial scenarios specific to Viemed.
- In-Depth Analysis: Automatically computes Viemed’s intrinsic value and Net Present Value for informed decision-making.
- Integrated Data: Comes with historical and projected data for precise financial assessments.
- Expert-Level Tool: Perfect for financial analysts, investors, and consultants focused on the healthcare sector.
Who Should Use Viemed Healthcare, Inc. (VMD)?
- Healthcare Investors: Make informed investment choices with a comprehensive analysis of Viemed's market position.
- Financial Analysts: Streamline your workflow with ready-to-use financial models tailored for Viemed's performance.
- Consultants: Easily modify reports and presentations to showcase Viemed's growth potential to clients.
- Healthcare Enthusiasts: Enhance your knowledge of the industry by exploring Viemed's innovative healthcare solutions.
- Educators and Students: Utilize Viemed's case studies as a hands-on resource in healthcare finance courses.
What the Template Contains
- Comprehensive DCF Model: Editable template featuring detailed valuation calculations tailored for Viemed Healthcare, Inc. (VMD).
- Real-World Data: Viemed’s historical and projected financials preloaded for thorough analysis.
- Customizable Parameters: Modify 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: Integrated analysis for profitability, efficiency, and leverage metrics.
- Dashboard with Visual Outputs: Visualizations including charts and tables for clear, actionable results.