|
Valoración de DCF de UnitedHealth Group Incorporated (UNH)
US | Healthcare | Medical - Healthcare Plans | NYSE
|
- ✓ 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
UnitedHealth Group Incorporated (UNH) Bundle
¡Agilice su análisis y mejore la precisión con nuestra calculadora DCF de UnitedHealth Group Incorporated (UNH)! Utilizando datos reales de UnitedHealth y supuestos personalizables, esta herramienta le permite pronosticar, analizar y valorar UnitedHealth como un inversor experimentado.
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 | 242,155.0 | 255,639.0 | 285,273.0 | 322,132.0 | 367,533.0 | 408,122.4 | 453,194.4 | 503,244.0 | 558,821.0 | 620,535.8 |
| Revenue Growth, % | 0 | 5.57 | 11.59 | 12.92 | 14.09 | 11.04 | 11.04 | 11.04 | 11.04 | 11.04 |
| EBITDA | 22,405.0 | 25,296.0 | 27,073.0 | 31,835.0 | 32,517.0 | 38,663.7 | 42,933.6 | 47,675.0 | 52,940.1 | 58,786.7 |
| EBITDA, % | 9.25 | 9.9 | 9.49 | 9.88 | 8.85 | 9.47 | 9.47 | 9.47 | 9.47 | 9.47 |
| Depreciation | 2,720.0 | 2,891.0 | 3,103.0 | 3,400.0 | 3,972.0 | 4,471.4 | 4,965.2 | 5,513.6 | 6,122.5 | 6,798.7 |
| Depreciation, % | 1.12 | 1.13 | 1.09 | 1.06 | 1.08 | 1.1 | 1.1 | 1.1 | 1.1 | 1.1 |
| EBIT | 19,685.0 | 22,405.0 | 23,970.0 | 28,435.0 | 28,545.0 | 34,192.2 | 37,968.3 | 42,161.4 | 46,817.6 | 51,988.1 |
| EBIT, % | 8.13 | 8.76 | 8.4 | 8.83 | 7.77 | 8.38 | 8.38 | 8.38 | 8.38 | 8.38 |
| Total Cash | 14,245.0 | 19,781.0 | 23,907.0 | 27,911.0 | 29,628.0 | 31,610.4 | 35,101.4 | 38,977.9 | 43,282.5 | 48,062.5 |
| Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
| Account Receivables | 21,462.0 | 25,404.0 | 28,082.0 | 30,450.0 | 38,970.0 | 39,751.2 | 44,141.2 | 49,016.0 | 54,429.2 | 60,440.2 |
| Account Receivables, % | 8.86 | 9.94 | 9.84 | 9.45 | 10.6 | 9.74 | 9.74 | 9.74 | 9.74 | 9.74 |
| Inventories | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
| Inventories, % | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
| Accounts Payable | 40,695.0 | 44,367.0 | 49,126.0 | 56,771.0 | 31,958.0 | 63,422.4 | 70,426.6 | 78,204.3 | 86,841.0 | 96,431.5 |
| Accounts Payable, % | 16.81 | 17.36 | 17.22 | 17.62 | 8.7 | 15.54 | 15.54 | 15.54 | 15.54 | 15.54 |
| Capital Expenditure | -2,071.0 | -2,051.0 | -2,454.0 | -2,802.0 | -3,386.0 | -3,517.1 | -3,905.5 | -4,336.8 | -4,815.8 | -5,347.6 |
| Capital Expenditure, % | -0.85524 | -0.8023 | -0.86023 | -0.86983 | -0.92128 | -0.86178 | -0.86178 | -0.86178 | -0.86178 | -0.86178 |
| Tax Rate, % | 23.12 | 23.12 | 23.12 | 23.12 | 23.12 | 23.12 | 23.12 | 23.12 | 23.12 | 23.12 |
| EBITAT | 15,150.5 | 16,637.9 | 18,571.1 | 21,717.8 | 21,945.1 | 26,119.9 | 29,004.5 | 32,207.7 | 35,764.6 | 39,714.4 |
| Depreciation | ||||||||||
| Changes in Account Receivables | ||||||||||
| Changes in Inventories | ||||||||||
| Changes in Accounts Payable | ||||||||||
| Capital Expenditure | ||||||||||
| UFCF | 35,032.5 | 17,207.9 | 21,301.1 | 27,592.8 | -10,801.9 | 57,757.5 | 32,678.4 | 36,287.4 | 40,294.9 | 44,744.9 |
| WACC, % | 6.86 | 6.85 | 6.87 | 6.86 | 6.86 | 6.86 | 6.86 | 6.86 | 6.86 | 6.86 |
| PV UFCF | ||||||||||
| SUM PV UFCF | 175,414.9 | |||||||||
| Long Term Growth Rate, % | 2.00 | |||||||||
| Free cash flow (T + 1) | 45,640 | |||||||||
| Terminal Value | 938,907 | |||||||||
| Present Terminal Value | 673,795 | |||||||||
| Enterprise Value | 849,210 | |||||||||
| Net Debt | 37,110 | |||||||||
| Equity Value | 812,100 | |||||||||
| Diluted Shares Outstanding, MM | 938 | |||||||||
| Equity Value Per Share | 865.78 |
What You Will Get
- Real UNH Financials: Access to historical and projected data for precise valuation.
- Customizable Inputs: Adjust WACC, tax rates, revenue growth, and capital expenditures as needed.
- Instant Calculations: Intrinsic value and NPV are computed in real-time.
- Scenario Analysis: Evaluate various scenarios to assess UnitedHealth Group's future performance.
- User-Friendly Design: Designed for professionals while remaining approachable for newcomers.
Key Features
- Comprehensive Historical Data: UnitedHealth Group’s (UNH) past financial statements and pre-filled projections.
- Customizable Parameters: Adjust WACC, tax rates, revenue growth, and EBITDA margins as needed.
- Real-Time Calculations: Observe UnitedHealth Group’s intrinsic value update instantly.
- Intuitive Visualizations: Dashboard graphs illustrate valuation outcomes and essential metrics.
- Designed for Precision: A reliable tool tailored for analysts, investors, and finance professionals.
How It Works
- Download: Get the pre-prepared Excel file containing UnitedHealth Group's (UNH) financial data.
- Customize: Modify forecasts, including revenue growth, EBITDA %, and WACC.
- Update Automatically: The intrinsic value and NPV calculations refresh in real-time.
- Test Scenarios: Generate various projections and instantly compare results.
- Make Decisions: Leverage the valuation outcomes to inform your investment strategy.
Why Choose UnitedHealth Group (UNH)?
- Comprehensive Services: A wide range of healthcare solutions tailored to meet diverse needs.
- Proven Track Record: Years of experience in delivering quality health services and insurance.
- Innovative Technology: Cutting-edge tools and platforms enhance patient care and streamline operations.
- Commitment to Wellness: Focused on improving health outcomes and promoting preventative care.
- Industry Leadership: Recognized as a leader in the healthcare sector, trusted by millions.
Who Should Use This Product?
- Healthcare Investors: Develop comprehensive and accurate valuation models for portfolio management related to UnitedHealth Group (UNH).
- Corporate Finance Departments: Evaluate valuation scenarios to inform strategic decisions within their organizations.
- Consultants and Financial Advisors: Deliver precise valuation insights for clients interested in UnitedHealth Group (UNH) stock.
- Students and Academics: Utilize real-world data to enhance learning and teaching of financial modeling techniques.
- Health Sector Enthusiasts: Gain insights into how healthcare companies like UnitedHealth Group (UNH) are valued in the financial markets.
What the Template Contains
- Historical Data: Includes UnitedHealth Group's past financials and baseline forecasts.
- DCF and Levered DCF Models: Detailed templates to calculate UnitedHealth Group'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 UnitedHealth Group's financials.
- Interactive Dashboard: Visualize valuation results and projections dynamically.