|
Valoración de DCF de Alignment Healthcare, Inc. (ALHC)
US | Healthcare | Medical - Healthcare Plans | NASDAQ
|
- ✓ Completamente Editable: Adáptelo A Sus Necesidades En Excel O Sheets
- ✓ Diseño Profesional: Plantillas Confiables Y Estándares De La Industria
- ✓ Predeterminadas Para Un Uso Rápido Y Eficiente
- ✓ No Se Necesita Experiencia; Fáciles De Seguir
Alignment Healthcare, Inc. (ALHC) Bundle
¡Descubra el verdadero valor de Alignment Healthcare, Inc. (ALHC) con nuestra calculadora DCF avanzada! Personalice los supuestos esenciales, explore varios escenarios y evalúe cómo los cambios afectan la valoración de la alineación de la salud, todo dentro de una plantilla de Excel conveniente.
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 | 757.0 | 959.2 | 1,167.8 | 1,434.2 | 1,823.6 | 2,272.4 | 2,831.6 | 3,528.3 | 4,396.6 | 5,478.5 |
| Revenue Growth, % | 0 | 26.72 | 21.74 | 22.81 | 27.16 | 24.61 | 24.61 | 24.61 | 24.61 | 24.61 |
| EBITDA | -13.3 | 9.5 | -161.8 | -113.5 | -105.3 | -128.7 | -160.3 | -199.8 | -248.9 | -310.2 |
| EBITDA, % | -1.75 | 0.98684 | -13.86 | -7.92 | -5.77 | -5.66 | -5.66 | -5.66 | -5.66 | -5.66 |
| Depreciation | 16.6 | 15.5 | 16.0 | 17.5 | 21.7 | 34.5 | 42.9 | 53.5 | 66.7 | 83.1 |
| Depreciation, % | 2.19 | 1.61 | 1.37 | 1.22 | 1.19 | 1.52 | 1.52 | 1.52 | 1.52 | 1.52 |
| EBIT | -29.8 | -6.0 | -177.8 | -131.0 | -127.0 | -163.1 | -203.3 | -253.3 | -315.6 | -393.3 |
| EBIT, % | -3.94 | -0.62499 | -15.23 | -9.14 | -6.96 | -7.18 | -7.18 | -7.18 | -7.18 | -7.18 |
| Total Cash | 86.5 | 207.3 | 466.6 | 409.5 | 202.9 | 512.1 | 638.1 | 795.1 | 990.8 | 1,234.6 |
| Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
| Account Receivables | 35.6 | 40.1 | 58.5 | 92.9 | 119.7 | 122.5 | 152.6 | 190.1 | 236.9 | 295.2 |
| Account Receivables, % | 4.71 | 4.18 | 5.01 | 6.48 | 6.57 | 5.39 | 5.39 | 5.39 | 5.39 | 5.39 |
| Inventories | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
| Inventories, % | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
| Accounts Payable | 15.4 | 15.7 | 17.4 | 171.9 | 170.1 | 120.3 | 149.9 | 186.8 | 232.7 | 290.0 |
| Accounts Payable, % | 2.03 | 1.63 | 1.49 | 11.99 | 9.33 | 5.29 | 5.29 | 5.29 | 5.29 | 5.29 |
| Capital Expenditure | -10.2 | -15.7 | -18.4 | -23.8 | -36.0 | -37.2 | -46.4 | -57.8 | -72.1 | -89.8 |
| Capital Expenditure, % | -1.35 | -1.64 | -1.57 | -1.66 | -1.97 | -1.64 | -1.64 | -1.64 | -1.64 | -1.64 |
| Tax Rate, % | 0.12011 | 0.12011 | 0.12011 | 0.12011 | 0.12011 | 0.12011 | 0.12011 | 0.12011 | 0.12011 | 0.12011 |
| EBITAT | -39.5 | -10.2 | -193.9 | -131.3 | -126.8 | -163.1 | -203.2 | -253.2 | -315.5 | -393.2 |
| Depreciation | ||||||||||
| Changes in Account Receivables | ||||||||||
| Changes in Inventories | ||||||||||
| Changes in Accounts Payable | ||||||||||
| Capital Expenditure | ||||||||||
| UFCF | -53.5 | -14.7 | -212.9 | -17.5 | -169.8 | -218.4 | -207.2 | -258.2 | -321.7 | -400.9 |
| WACC, % | 11.4 | 11.4 | 11.4 | 11.4 | 11.4 | 11.4 | 11.4 | 11.4 | 11.4 | 11.4 |
| PV UFCF | ||||||||||
| SUM PV UFCF | -992.2 | |||||||||
| Long Term Growth Rate, % | 4.00 | |||||||||
| Free cash flow (T + 1) | -417 | |||||||||
| Terminal Value | -5,631 | |||||||||
| Present Terminal Value | -3,282 | |||||||||
| Enterprise Value | -4,274 | |||||||||
| Net Debt | -32 | |||||||||
| Equity Value | -4,242 | |||||||||
| Diluted Shares Outstanding, MM | 186 | |||||||||
| Equity Value Per Share | -22.78 |
What You Will Get
- Editable Forecast Inputs: Easily modify assumptions (growth %, margins, WACC) to explore various scenarios.
- Real-World Data: Alignment Healthcare’s financial data pre-filled to kickstart your analysis.
- Automatic DCF Outputs: The template computes Net Present Value (NPV) and intrinsic value for you.
- Customizable and Professional: A refined Excel model that adapts to your valuation requirements.
- Built for Analysts and Investors: Perfect for testing projections, validating strategies, and enhancing efficiency.
Key Features
- Comprehensive Financial Data: Gain access to precise historical figures and future forecasts for Alignment Healthcare, Inc. (ALHC).
- Adjustable Forecast Parameters: Modify highlighted fields such as WACC, growth rates, and profit margins to fit your analysis.
- Real-Time Calculations: Instant updates for DCF, Net Present Value (NPV), and cash flow assessments.
- User-Friendly Dashboard: Clear charts and summaries designed to help you visualize valuation outcomes effectively.
- Designed for All Skill Levels: An intuitive layout tailored for investors, CFOs, and consultants alike.
How It Works
- Download: Obtain the pre-prepared Excel file containing Alignment Healthcare, Inc. (ALHC) financial data.
- Customize: Modify forecasts, such as revenue growth, EBITDA %, and WACC.
- Update Automatically: The intrinsic value and NPV calculations refresh in real-time.
- Test Scenarios: Develop various projections and instantly compare the results.
- Make Decisions: Leverage the valuation outcomes to inform your investment strategy.
Why Choose This Calculator for Alignment Healthcare, Inc. (ALHC)?
- Accuracy: Utilizes real Alignment Healthcare financials to ensure precise data.
- Flexibility: Tailored for users to easily test and adjust inputs as needed.
- Time-Saving: Eliminate the complexity of constructing a DCF model from the ground up.
- Professional-Grade: Crafted with the precision and usability expected at the CFO level.
- User-Friendly: Intuitive design makes it accessible for users without extensive financial modeling skills.
Who Should Use This Product?
- Investors: Evaluate Alignment Healthcare's valuation prior to making investment decisions.
- CFOs and Financial Analysts: Optimize valuation methodologies and assess financial forecasts.
- Startup Founders: Understand the valuation strategies of established companies like Alignment Healthcare.
- Consultants: Provide comprehensive valuation analyses for clients in the healthcare sector.
- Students and Educators: Utilize current data to enhance learning and teaching of valuation practices.
What the Template Contains
- Pre-Filled Data: Includes Alignment Healthcare’s 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 Alignment Healthcare’s profitability, efficiency, and leverage.
- Customizable Inputs: Edit revenue growth, margins, and tax rates with ease.
- Clear Dashboard: Charts and tables summarizing key valuation results.