|
Innovage Holding Corp. (INNV) DCF Valoración
US | Healthcare | Medical - Care Facilities | 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
InnovAge Holding Corp. (INNV) Bundle
¡Descubra el verdadero valor de Innovage Holding Corp. (INNV) con nuestra calculadora DCF de grado profesional! Ajuste los supuestos clave, explore varios escenarios y evalúe cómo los cambios afectan la valoración de Innovage, todo dentro de una sola plantilla de Excel.
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 | 567.2 | 637.8 | 698.6 | 688.1 | 763.9 | 824.0 | 888.9 | 958.8 | 1,034.3 | 1,115.7 |
| Revenue Growth, % | 0 | 12.45 | 9.54 | -1.51 | 11.01 | 7.87 | 7.87 | 7.87 | 7.87 | 7.87 |
| EBITDA | 61.5 | -5.9 | 9.2 | -29.2 | 1.2 | 11.8 | 12.7 | 13.7 | 14.8 | 15.9 |
| EBITDA, % | 10.85 | -0.92317 | 1.32 | -4.25 | 0.15108 | 1.43 | 1.43 | 1.43 | 1.43 | 1.43 |
| Depreciation | 11.3 | 12.3 | 13.9 | 20.0 | 19.0 | 18.6 | 20.1 | 21.7 | 23.4 | 25.2 |
| Depreciation, % | 1.99 | 1.93 | 1.99 | 2.91 | 2.48 | 2.26 | 2.26 | 2.26 | 2.26 | 2.26 |
| EBIT | 50.3 | -18.2 | -4.7 | -49.3 | -17.8 | -6.8 | -7.4 | -8.0 | -8.6 | -9.3 |
| EBIT, % | 8.86 | -2.85 | -0.67431 | -7.16 | -2.33 | -0.83112 | -0.83112 | -0.83112 | -0.83112 | -0.83112 |
| Total Cash | 112.9 | 201.5 | 184.4 | 173.5 | 102.8 | 192.1 | 207.2 | 223.5 | 241.1 | 260.1 |
| Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
| Account Receivables | 48.1 | 38.0 | 42.7 | 24.6 | 51.4 | 50.8 | 54.8 | 59.1 | 63.8 | 68.8 |
| Account Receivables, % | 8.47 | 5.96 | 6.11 | 3.58 | 6.73 | 6.17 | 6.17 | 6.17 | 6.17 | 6.17 |
| Inventories | 1.7 | 2.2 | .0 | -.3 | .0 | 1.0 | 1.1 | 1.2 | 1.3 | 1.4 |
| Inventories, % | 0.29285 | 0.35027 | 0.000000143 | -0.03807658 | 0 | 0.12101 | 0.12101 | 0.12101 | 0.12101 | 0.12101 |
| Accounts Payable | 28.9 | 32.4 | 50.6 | 44.6 | 55.5 | 51.3 | 55.4 | 59.7 | 64.4 | 69.5 |
| Accounts Payable, % | 5.09 | 5.07 | 7.24 | 6.48 | 7.26 | 6.23 | 6.23 | 6.23 | 6.23 | 6.23 |
| Capital Expenditure | -11.8 | -19.5 | -38.2 | -23.4 | -7.9 | -24.8 | -26.8 | -28.9 | -31.1 | -33.6 |
| Capital Expenditure, % | -2.09 | -3.06 | -5.47 | -3.39 | -1.04 | -3.01 | -3.01 | -3.01 | -3.01 | -3.01 |
| Tax Rate, % | 2.2 | 2.2 | 2.2 | 2.2 | 2.2 | 2.2 | 2.2 | 2.2 | 2.2 | 2.2 |
| EBITAT | 37.1 | -23.3 | -5.2 | -39.5 | -17.4 | -6.2 | -6.7 | -7.2 | -7.8 | -8.4 |
| Depreciation | ||||||||||
| Changes in Account Receivables | ||||||||||
| Changes in Inventories | ||||||||||
| Changes in Accounts Payable | ||||||||||
| Capital Expenditure | ||||||||||
| UFCF | 15.7 | -17.5 | -13.7 | -30.5 | -22.6 | -16.9 | -13.4 | -14.4 | -15.6 | -16.8 |
| WACC, % | 5.74 | 5.95 | 5.95 | 5.79 | 5.93 | 5.87 | 5.87 | 5.87 | 5.87 | 5.87 |
| PV UFCF | ||||||||||
| SUM PV UFCF | -65.1 | |||||||||
| Long Term Growth Rate, % | 2.00 | |||||||||
| Free cash flow (T + 1) | -17 | |||||||||
| Terminal Value | -442 | |||||||||
| Present Terminal Value | -333 | |||||||||
| Enterprise Value | -398 | |||||||||
| Net Debt | 56 | |||||||||
| Equity Value | -454 | |||||||||
| Diluted Shares Outstanding, MM | 136 | |||||||||
| Equity Value Per Share | -3.34 |
What You Will Get
- Editable Excel Template: A fully customizable Excel-based DCF Calculator featuring pre-filled real InnovAge Holding Corp. (INNV) financials.
- Real-World Data: Historical data and forward-looking estimates (as indicated in the highlighted cells).
- Forecast Flexibility: Adjust forecast assumptions such as revenue growth, EBITDA %, and WACC.
- Automatic Calculations: Instantly observe the effects of your inputs on InnovAge Holding Corp.'s (INNV) valuation.
- Professional Tool: Designed for investors, CFOs, consultants, and financial analysts.
- User-Friendly Design: Organized for clarity and ease of use, complete with step-by-step instructions.
Key Features
- 🔍 Real-Life INNV Financials: Pre-filled historical and projected data for InnovAge Holding Corp.
- ✏️ Fully Customizable Inputs: Adjust all critical parameters (yellow cells) like WACC, growth %, and tax rates.
- 📊 Professional DCF Valuation: Built-in formulas calculate InnovAge’s intrinsic value using the Discounted Cash Flow method.
- ⚡ Instant Results: Visualize InnovAge’s valuation instantly after making changes.
- Scenario Analysis: Test and compare outcomes for various financial assumptions side-by-side.
How It Works
- Step 1: Download the Excel file.
- Step 2: Review InnovAge Holding Corp.'s (INNV) pre-filled financial data and forecasts.
- 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 for InnovAge Holding Corp. (INNV)?
- Accuracy: Utilizes real InnovAge 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 by CFOs.
- User-Friendly: Simple to navigate, even for individuals without extensive financial modeling skills.
Who Should Use InnovAge Holding Corp. (INNV)?
- Healthcare Investors: Make informed investment choices with a comprehensive analysis of InnovAge's market position.
- Financial Analysts: Streamline your workflow with an adaptable financial model tailored for InnovAge's unique business structure.
- Consultants: Effortlessly modify the framework for client briefings or strategic reports focused on InnovAge's services.
- Healthcare Enthusiasts: Enhance your knowledge of the senior care market through practical insights and examples from InnovAge.
- Educators and Students: Leverage it as a valuable resource for teaching and learning about healthcare finance and business operations.
What the Template Contains
- Comprehensive DCF Model: Editable template featuring detailed valuation calculations.
- Real-World Data: InnovAge Holding Corp.’s (INNV) historical and projected financials preloaded for 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 providing clear, actionable results.