InnovAge Holding Corp. (INNV) DCF Valuation
- ✓ Entièrement Modifiable: Adapté À Vos Besoins Dans Excel Ou Sheets
- ✓ Conception Professionnelle: Modèles Fiables Et Conformes Aux Normes Du Secteur
- ✓ Pré-Construits Pour Une Utilisation Rapide Et Efficace
- ✓ Aucune Expertise N'Est Requise; Facile À Suivre
InnovAge Holding Corp. (INNV) Bundle
Discover the true value of InnovAge Holding Corp. (INNV) with our professional-grade DCF Calculator! Adjust key assumptions, explore various scenarios, and evaluate how changes affect InnovAge's valuation – all within a single Excel template.
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.