|
HealthEquity, Inc. (HQY) DCF Valuation
US | Healthcare | Medical - Healthcare Information Services | NASDAQ
|
- ✓ 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
HealthEquity, Inc. (HQY) Bundle
Designed for accuracy, our (HQY) DCF Calculator enables you to assess the valuation of HealthEquity, Inc. using real-world financial data and provides the flexibility to modify all essential parameters for improved forecasts.
Discounted Cash Flow (DCF) - (USD MM)
| Year | AY1 2020 |
AY2 2021 |
AY3 2022 |
AY4 2023 |
AY5 2024 |
FY1 2025 |
FY2 2026 |
FY3 2027 |
FY4 2028 |
FY5 2029 |
|---|---|---|---|---|---|---|---|---|---|---|
| Revenue | 532.0 | 733.6 | 756.6 | 861.7 | 999.6 | 1,176.8 | 1,385.5 | 1,631.1 | 1,920.4 | 2,260.9 |
| Revenue Growth, % | 0 | 37.89 | 3.13 | 13.9 | 16 | 17.73 | 17.73 | 17.73 | 17.73 | 17.73 |
| EBITDA | 123.3 | 154.9 | 103.0 | 171.5 | 282.4 | 249.6 | 293.9 | 346.0 | 407.3 | 479.6 |
| EBITDA, % | 23.17 | 21.12 | 13.61 | 19.9 | 28.25 | 21.21 | 21.21 | 21.21 | 21.21 | 21.21 |
| Depreciation | 55.4 | 115.9 | 137.2 | 161.2 | 153.1 | 184.4 | 217.1 | 255.6 | 301.0 | 354.3 |
| Depreciation, % | 10.4 | 15.8 | 18.13 | 18.71 | 15.31 | 15.67 | 15.67 | 15.67 | 15.67 | 15.67 |
| EBIT | 67.9 | 39.0 | -34.2 | 10.3 | 129.3 | 65.2 | 76.8 | 90.4 | 106.4 | 125.3 |
| EBIT, % | 12.77 | 5.32 | -4.52 | 1.2 | 12.94 | 5.54 | 5.54 | 5.54 | 5.54 | 5.54 |
| Total Cash | 191.7 | 328.8 | 225.4 | 254.3 | 404.0 | 425.0 | 500.4 | 589.1 | 693.5 | 816.5 |
| Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
| Account Receivables | 70.9 | 72.8 | 87.4 | 96.8 | 104.9 | 133.0 | 156.6 | 184.4 | 217.1 | 255.6 |
| Account Receivables, % | 13.32 | 9.92 | 11.56 | 11.24 | 10.49 | 11.31 | 11.31 | 11.31 | 11.31 | 11.31 |
| Inventories | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
| Inventories, % | 0 | 0 | 0 | 0.000000116 | 0 | 0.0000000232 | 0.0000000232 | 0.0000000232 | 0.0000000232 | 0.0000000232 |
| Accounts Payable | 4.0 | 1.6 | 27.5 | 13.9 | 12.0 | 17.5 | 20.6 | 24.2 | 28.5 | 33.6 |
| Accounts Payable, % | 0.74813 | 0.22002 | 3.64 | 1.61 | 1.2 | 1.49 | 1.49 | 1.49 | 1.49 | 1.49 |
| Capital Expenditure | -42.1 | -97.0 | -137.1 | -119.1 | -46.1 | -135.8 | -159.8 | -188.2 | -221.5 | -260.8 |
| Capital Expenditure, % | -7.91 | -13.22 | -18.12 | -13.82 | -4.61 | -11.54 | -11.54 | -11.54 | -11.54 | -11.54 |
| Tax Rate, % | 25.76 | 25.76 | 25.76 | 25.76 | 25.76 | 25.76 | 25.76 | 25.76 | 25.76 | 25.76 |
| EBITAT | 62.4 | 83.3 | -22.7 | 7.1 | 96.0 | 52.3 | 61.6 | 72.5 | 85.4 | 100.5 |
| Depreciation | ||||||||||
| Changes in Account Receivables | ||||||||||
| Changes in Inventories | ||||||||||
| Changes in Accounts Payable | ||||||||||
| Capital Expenditure | ||||||||||
| UFCF | 8.8 | 97.9 | -11.3 | 26.1 | 193.1 | 78.3 | 98.4 | 115.8 | 136.4 | 160.6 |
| WACC, % | 6.75 | 6.8 | 6.6 | 6.61 | 6.65 | 6.68 | 6.68 | 6.68 | 6.68 | 6.68 |
| PV UFCF | ||||||||||
| SUM PV UFCF | 476.7 | |||||||||
| Long Term Growth Rate, % | 4.00 | |||||||||
| Free cash flow (T + 1) | 167 | |||||||||
| Terminal Value | 6,227 | |||||||||
| Present Terminal Value | 4,506 | |||||||||
| Enterprise Value | 4,983 | |||||||||
| Net Debt | 529 | |||||||||
| Equity Value | 4,454 | |||||||||
| Diluted Shares Outstanding, MM | 87 | |||||||||
| Equity Value Per Share | 51.22 |
What You Will Get
- Real HealthEquity Data: Preloaded financials – from revenue to EBIT – based on actual and projected figures for HealthEquity, Inc. (HQY).
- Full Customization: Adjust all critical parameters (yellow cells) like WACC, growth %, and tax rates to fit HealthEquity's unique financial landscape.
- Instant Valuation Updates: Automatic recalculations to analyze the impact of changes on HealthEquity, Inc.'s (HQY) fair value.
- Versatile Excel Template: Tailored for quick edits, scenario testing, and detailed projections specific to HealthEquity, Inc. (HQY).
- Time-Saving and Accurate: Skip building models from scratch while maintaining precision and flexibility for HealthEquity, Inc. (HQY).
Key Features
- Comprehensive Health Data: Gain access to reliable historical metrics and future forecasts for HealthEquity, Inc. (HQY).
- Adjustable Financial Assumptions: Modify highlighted cells for key inputs like discount rates, growth expectations, and profit margins.
- Real-Time Analytics: Instant updates to cash flow projections, Discounted Cash Flow (DCF), and Net Present Value (NPV) calculations.
- User-Friendly Dashboard: Intuitive charts and summaries designed to help you interpret your valuation insights effortlessly.
- Suitable for All Skill Levels: A straightforward, accessible format tailored for investors, financial officers, and advisors.
How It Works
- Step 1: Download the Excel file.
- Step 2: Review HealthEquity's pre-filled financial data and forecasts.
- Step 3: Modify critical inputs like revenue growth, WACC, and tax rates (highlighted cells).
- Step 4: Watch the DCF model update instantly as you tweak assumptions.
- Step 5: Analyze the outputs and use the results for investment decisions regarding HealthEquity, Inc. (HQY).
Why Choose This Calculator?
- Accurate Data: Real HealthEquity financials ensure reliable valuation results.
- Customizable: Adjust key parameters like growth rates, WACC, and tax rates to align with your forecasts.
- Time-Saving: Pre-built calculations save you from starting from scratch.
- Professional-Grade Tool: Tailored for investors, analysts, and consultants.
- User-Friendly: Intuitive design and step-by-step guidance make it accessible for all users.
Who Should Use HealthEquity, Inc. (HQY)?
- Healthcare Professionals: Understand the financial implications of health savings accounts and their management.
- Academics: Utilize comprehensive data on health equity for research and teaching purposes.
- Investors: Evaluate investment opportunities and analyze the financial performance of HealthEquity, Inc. (HQY).
- Financial Analysts: Enhance your analysis with industry-specific metrics and insights on health savings accounts.
- Small Business Owners: Discover how health savings accounts can benefit your employees and your bottom line.
What the Template Contains
- Comprehensive DCF Model: Editable template featuring detailed valuation calculations tailored for HealthEquity, Inc. (HQY).
- Real-World Data: HealthEquity’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.
- Key Ratios: Integrated analysis for profitability, efficiency, and leverage metrics.
- Dashboard with Visual Outputs: Charts and tables designed for clear, actionable insights.