Health Catalyst, Inc. (HCAT) 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
Health Catalyst, Inc. (HCAT) Bundle
Looking to determine the intrinsic value of Health Catalyst, Inc.? Our (HCAT) DCF Calculator integrates real-world data with extensive customization options, allowing you to refine your forecasts and make more informed 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 | 154.9 | 188.8 | 241.9 | 276.2 | 295.9 | 348.7 | 410.9 | 484.1 | 570.4 | 672.1 |
| Revenue Growth, % | 0 | 21.88 | 28.11 | 14.18 | 7.13 | 17.83 | 17.83 | 17.83 | 17.83 | 17.83 |
| EBITDA | -44.5 | -79.5 | -101.7 | -82.9 | -66.5 | -115.3 | -135.8 | -160.0 | -188.6 | -222.2 |
| EBITDA, % | -28.71 | -42.08 | -42.03 | -30.02 | -22.46 | -33.06 | -33.06 | -33.06 | -33.06 | -33.06 |
| Depreciation | 9.2 | 23.0 | 41.1 | 51.5 | 42.2 | 47.5 | 55.9 | 65.9 | 77.6 | 91.5 |
| Depreciation, % | 5.95 | 12.19 | 16.99 | 18.65 | 14.27 | 13.61 | 13.61 | 13.61 | 13.61 | 13.61 |
| EBIT | -53.7 | -102.5 | -142.8 | -134.4 | -108.7 | -162.7 | -191.7 | -225.9 | -266.2 | -313.6 |
| EBIT, % | -34.65 | -54.27 | -59.02 | -48.67 | -36.73 | -46.67 | -46.67 | -46.67 | -46.67 | -46.67 |
| Total Cash | 228.3 | 270.9 | 445.0 | 363.5 | 317.7 | 348.7 | 410.9 | 484.1 | 570.4 | 672.1 |
| Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
| Account Receivables | 27.6 | 48.3 | 48.8 | 48.0 | 60.3 | 70.6 | 83.2 | 98.1 | 115.5 | 136.1 |
| Account Receivables, % | 17.79 | 25.57 | 20.17 | 17.37 | 20.37 | 20.26 | 20.26 | 20.26 | 20.26 | 20.26 |
| Inventories | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
| Inventories, % | 0 | 0.00000053 | 0.000000413 | 0 | 0 | 0.000000189 | 0.000000189 | 0.000000189 | 0.000000189 | 0.000000189 |
| Accounts Payable | 3.6 | 5.3 | 4.7 | 4.4 | 6.6 | 7.6 | 9.0 | 10.6 | 12.5 | 14.7 |
| Accounts Payable, % | 2.34 | 2.82 | 1.94 | 1.6 | 2.24 | 2.19 | 2.19 | 2.19 | 2.19 | 2.19 |
| Capital Expenditure | -4.3 | -10.5 | -18.5 | -17.4 | -14.3 | -18.9 | -22.3 | -26.2 | -30.9 | -36.4 |
| Capital Expenditure, % | -2.8 | -5.54 | -7.63 | -6.3 | -4.84 | -5.42 | -5.42 | -5.42 | -5.42 | -5.42 |
| Tax Rate, % | -0.30223 | -0.30223 | -0.30223 | -0.30223 | -0.30223 | -0.30223 | -0.30223 | -0.30223 | -0.30223 | -0.30223 |
| EBITAT | -53.8 | -101.4 | -136.6 | -130.4 | -109.0 | -160.0 | -188.5 | -222.1 | -261.7 | -308.4 |
| Depreciation | ||||||||||
| Changes in Account Receivables | ||||||||||
| Changes in Inventories | ||||||||||
| Changes in Accounts Payable | ||||||||||
| Capital Expenditure | ||||||||||
| UFCF | -72.9 | -107.9 | -115.1 | -95.7 | -91.2 | -140.8 | -166.1 | -195.7 | -230.6 | -271.7 |
| WACC, % | 8.3 | 8.28 | 8.23 | 8.25 | 8.3 | 8.27 | 8.27 | 8.27 | 8.27 | 8.27 |
| PV UFCF | ||||||||||
| SUM PV UFCF | -776.4 | |||||||||
| Long Term Growth Rate, % | 2.00 | |||||||||
| Free cash flow (T + 1) | -277 | |||||||||
| Terminal Value | -4,418 | |||||||||
| Present Terminal Value | -2,969 | |||||||||
| Enterprise Value | -3,746 | |||||||||
| Net Debt | 143 | |||||||||
| Equity Value | -3,888 | |||||||||
| Diluted Shares Outstanding, MM | 56 | |||||||||
| Equity Value Per Share | -68.92 |
What You Will Receive
- Customizable Excel Template: A fully adjustable Excel-based DCF Calculator featuring pre-filled real HCAT financials.
- Real-World Insights: Historical data and forward-looking projections (as illustrated in the highlighted cells).
- Forecast Adaptability: Modify forecast assumptions such as revenue growth, EBITDA %, and WACC.
- Instant Calculations: Quickly observe how your inputs affect Health Catalyst’s valuation.
- Professional Resource: Designed for investors, CFOs, consultants, and financial analysts.
- Intuitive Layout: Organized for clarity and ease of use, complete with step-by-step guidance.
Key Features
- Comprehensive Health Data: Access reliable historical data and future forecasts tailored for Health Catalyst, Inc. (HCAT).
- Adjustable Forecast Parameters: Modify highlighted cells for key metrics such as WACC, growth rates, and profit margins.
- Real-Time Calculations: Instant updates to DCF, Net Present Value (NPV), and cash flow assessments.
- Interactive Dashboard: User-friendly charts and summaries to effectively present your valuation findings.
- Designed for All Users: An intuitive layout suitable for investors, CFOs, and healthcare consultants alike.
How It Works
- Step 1: Download the Excel file for Health Catalyst, Inc. (HCAT).
- Step 2: Review the pre-filled financial data and forecasts for Health Catalyst.
- 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 assumptions.
- Step 5: Evaluate the outputs and leverage the results for your investment strategies.
Why Choose Health Catalyst, Inc. (HCAT)?
- Streamline Your Workflow: No need to start from scratch – our solutions are ready to implement.
- Enhance Accuracy: Dependable data and methodologies minimize errors in healthcare analytics.
- Fully Adaptable: Customize our tools to align with your specific healthcare insights and forecasts.
- User-Friendly Interface: Intuitive dashboards and outputs simplify data interpretation.
- Endorsed by Industry Leaders: Crafted for professionals who prioritize accuracy and functionality.
Who Should Use This Product?
- Healthcare Providers: Enhance decision-making regarding investments in Health Catalyst, Inc. (HCAT).
- Data Analysts: Improve data analysis processes with comprehensive healthcare analytics tools.
- Consultants: Provide clients with actionable insights and strategies based on Health Catalyst, Inc. (HCAT) data.
- Healthcare Administrators: Gain a deeper understanding of how companies like Health Catalyst, Inc. (HCAT) impact healthcare delivery and operations.
- Students in Health Policy: Explore real-world applications of healthcare analytics and their implications for the industry.
What the Template Contains
- Historical Data: Includes Health Catalyst’s past financials and baseline forecasts.
- DCF and Levered DCF Models: Detailed templates to calculate Health Catalyst’s intrinsic value.
- WACC Sheet: Pre-built calculations for Weighted Average Cost of Capital.
- Editable Inputs: Modify key drivers like growth rates, EBITDA %, and CAPEX assumptions.
- Quarterly and Annual Statements: A complete breakdown of Health Catalyst’s financials.
- Interactive Dashboard: Visualize valuation results and projections dynamically.