Evolent Health, Inc. (EVH) DCF Valuation
- ✓ 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
Evolent Health, Inc. (EVH) Bundle
Explore Evolent Health, Inc.'s (EVH) financial outlook with our user-friendly DCF Calculator! Enter your projections for growth, margins, and expenses to determine Evolent Health, Inc.'s (EVH) intrinsic value and inform your investment decisions.
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 | 846.4 | 1,022.4 | 908.0 | 1,352.0 | 1,963.9 | 2,473.4 | 3,115.0 | 3,923.1 | 4,940.8 | 6,222.6 |
Revenue Growth, % | 0 | 20.8 | -11.2 | 48.91 | 45.26 | 25.94 | 25.94 | 25.94 | 25.94 | 25.94 |
EBITDA | -245.9 | -241.4 | 55.7 | 43.7 | -24.8 | -220.4 | -277.6 | -349.7 | -440.4 | -554.6 |
EBITDA, % | -29.06 | -23.61 | 6.13 | 3.24 | -1.26 | -8.91 | -8.91 | -8.91 | -8.91 | -8.91 |
Depreciation | 66.6 | 60.8 | 60.0 | 90.3 | 123.4 | 165.2 | 208.1 | 262.0 | 330.0 | 415.6 |
Depreciation, % | 7.87 | 5.95 | 6.61 | 6.68 | 6.28 | 6.68 | 6.68 | 6.68 | 6.68 | 6.68 |
EBIT | -312.6 | -302.2 | -4.4 | -46.5 | -148.2 | -385.6 | -485.7 | -611.7 | -770.4 | -970.2 |
EBIT, % | -36.93 | -29.56 | -0.48196 | -3.44 | -7.55 | -15.59 | -15.59 | -15.59 | -15.59 | -15.59 |
Total Cash | 101.0 | 340.5 | 266.3 | 188.2 | 192.8 | 486.3 | 612.4 | 771.3 | 971.4 | 1,223.4 |
Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
Account Receivables | 77.4 | 124.4 | 130.6 | 254.7 | 446.7 | 382.3 | 481.5 | 606.4 | 763.7 | 961.8 |
Account Receivables, % | 9.15 | 12.17 | 14.38 | 18.84 | 22.75 | 15.46 | 15.46 | 15.46 | 15.46 | 15.46 |
Inventories | -150.1 | -445.1 | -308.2 | -415.9 | .0 | -623.2 | -784.8 | -988.4 | -1,244.9 | -1,567.8 |
Inventories, % | -17.73 | -43.53 | -33.95 | -30.76 | 0 | -25.2 | -25.2 | -25.2 | -25.2 | -25.2 |
Accounts Payable | 37.5 | 32.0 | 96.1 | 57.2 | 48.2 | 122.8 | 154.7 | 194.8 | 245.3 | 308.9 |
Accounts Payable, % | 4.43 | 3.13 | 10.58 | 4.23 | 2.46 | 4.96 | 4.96 | 4.96 | 4.96 | 4.96 |
Capital Expenditure | -35.5 | -29.5 | -25.0 | -38.4 | -28.7 | -69.9 | -88.1 | -110.9 | -139.7 | -175.9 |
Capital Expenditure, % | -4.2 | -2.88 | -2.75 | -2.84 | -1.46 | -2.83 | -2.83 | -2.83 | -2.83 | -2.83 |
Tax Rate, % | 44.15 | 44.15 | 44.15 | 44.15 | 44.15 | 44.15 | 44.15 | 44.15 | 44.15 | 44.15 |
EBITAT | -292.0 | -299.0 | -4.4 | -14.0 | -82.8 | -291.8 | -367.5 | -462.8 | -582.9 | -734.1 |
Depreciation | ||||||||||
Changes in Account Receivables | ||||||||||
Changes in Inventories | ||||||||||
Changes in Accounts Payable | ||||||||||
Capital Expenditure | ||||||||||
UFCF | -150.7 | -25.2 | -48.4 | -17.4 | -605.0 | 565.7 | -153.2 | -192.9 | -242.9 | -306.0 |
WACC, % | 10.54 | 10.7 | 10.73 | 8.72 | 9.46 | 10.03 | 10.03 | 10.03 | 10.03 | 10.03 |
PV UFCF | ||||||||||
SUM PV UFCF | -112.7 | |||||||||
Long Term Growth Rate, % | 4.00 | |||||||||
Free cash flow (T + 1) | -318 | |||||||||
Terminal Value | -5,277 | |||||||||
Present Terminal Value | -3,272 | |||||||||
Enterprise Value | -3,385 | |||||||||
Net Debt | 452 | |||||||||
Equity Value | -3,837 | |||||||||
Diluted Shares Outstanding, MM | 111 | |||||||||
Equity Value Per Share | -34.49 |
What You Will Receive
- Customizable Excel Template: A fully adjustable Excel-based DCF Calculator featuring pre-filled real EVH financials.
- Authentic Data: Historical performance data and forward-looking projections (highlighted in the yellow cells).
- Adjustable Forecasts: Modify forecast parameters such as revenue growth, EBITDA %, and WACC.
- Instant Calculations: Quickly observe how your inputs affect Evolent Health’s valuation.
- Professional Resource: Designed for investors, CFOs, consultants, and financial analysts.
- User-Centric Layout: Organized for clarity and ease of navigation, complete with step-by-step guidance.
Key Features
- Comprehensive EVH Data: Pre-filled with Evolent Health's historical performance metrics and future growth estimates.
- Fully Customizable Inputs: Modify revenue growth rates, profit margins, discount rates, tax implications, and capital investments.
- Dynamic Valuation Model: Instant updates to Net Present Value (NPV) and intrinsic value based on user-defined parameters.
- Scenario Analysis: Generate various forecast scenarios to evaluate distinct valuation possibilities.
- User-Friendly Interface: Intuitive, organized, and suitable for both industry experts and newcomers.
How It Works
- Download: Get the comprehensive Excel file containing Evolent Health's (EVH) financial data.
- Customize: Modify forecasts, such as revenue growth, EBITDA %, and WACC.
- Update Automatically: Intrinsic value and NPV calculations refresh in real-time.
- Test Scenarios: Develop various projections and compare results instantly.
- Make Decisions: Leverage the valuation outcomes to inform your investment strategy.
Why Choose This Calculator for Evolent Health, Inc. (EVH)?
- Accurate Data: Utilizes real Evolent Health financials for trustworthy valuation outcomes.
- Customizable: Tailor key metrics such as growth rates, WACC, and tax rates to align with your forecasts.
- Time-Saving: Built-in calculations save you from starting from the ground up.
- Professional-Grade Tool: Crafted for investors, analysts, and consultants in the healthcare sector.
- User-Friendly: Simple interface and clear instructions make it accessible for all users.
Who Should Use This Product?
- Investors: Accurately estimate Evolent Health, Inc.'s (EVH) fair value before making investment decisions.
- CFOs: Leverage a professional-grade DCF model for financial reporting and analysis specific to Evolent Health, Inc. (EVH).
- Consultants: Quickly adapt the template for valuation reports tailored to Evolent Health, Inc. (EVH) for clients.
- Entrepreneurs: Gain insights into financial modeling techniques utilized by leading healthcare companies like Evolent Health, Inc. (EVH).
- Educators: Use it as a teaching tool to demonstrate valuation methodologies relevant to Evolent Health, Inc. (EVH).
What the Template Contains
- Historical Data: Includes Evolent Health’s past financials and baseline forecasts.
- DCF and Levered DCF Models: Detailed templates to calculate Evolent Health’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 Evolent Health’s financials.
- Interactive Dashboard: Visualize valuation results and projections dynamically.