|
Valoración de DCF Humana Inc. (HUM)
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
Humana Inc. (HUM) Bundle
¡Simplifique la valoración de Humana Inc. (HUM) con esta calculadora DCF personalizable! Con el Real Humana Inc. (Hum) Financials y las entradas de pronóstico ajustables, puede probar escenarios y descubrir el valor razonable de Humana Inc. (HUM) en minutos.
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 | 64,888.0 | 77,155.0 | 83,064.0 | 92,870.0 | 106,374.0 | 120,444.5 | 136,376.2 | 154,415.2 | 174,840.3 | 197,967.2 |
| Revenue Growth, % | 0 | 18.9 | 7.66 | 11.81 | 14.54 | 13.23 | 13.23 | 13.23 | 13.23 | 13.23 |
| EBITDA | 4,170.0 | 5,446.0 | 4,340.0 | 4,678.0 | 4,930.0 | 6,836.8 | 7,741.2 | 8,765.1 | 9,924.5 | 11,237.3 |
| EBITDA, % | 6.43 | 7.06 | 5.22 | 5.04 | 4.63 | 5.68 | 5.68 | 5.68 | 5.68 | 5.68 |
| Depreciation | 575.0 | 616.0 | 713.0 | 845.0 | 917.0 | 1,039.4 | 1,176.9 | 1,332.6 | 1,508.8 | 1,708.4 |
| Depreciation, % | 0.88614 | 0.79839 | 0.85837 | 0.90987 | 0.86205 | 0.86297 | 0.86297 | 0.86297 | 0.86297 | 0.86297 |
| EBIT | 3,595.0 | 4,830.0 | 3,627.0 | 3,833.0 | 4,013.0 | 5,797.4 | 6,564.3 | 7,432.6 | 8,415.7 | 9,528.9 |
| EBIT, % | 5.54 | 6.26 | 4.37 | 4.13 | 3.77 | 4.81 | 4.81 | 4.81 | 4.81 | 4.81 |
| Total Cash | 4,054.0 | 4,673.0 | 3,394.0 | 5,061.0 | 21,320.0 | 10,089.0 | 11,423.5 | 12,934.6 | 14,645.5 | 16,582.7 |
| Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
| Account Receivables | 1,056.0 | 1,138.0 | 1,814.0 | 1,674.0 | 2,035.0 | 2,168.4 | 2,455.3 | 2,780.0 | 3,147.8 | 3,564.1 |
| Account Receivables, % | 1.63 | 1.47 | 2.18 | 1.8 | 1.91 | 1.8 | 1.8 | 1.8 | 1.8 | 1.8 |
| Inventories | -20,944.0 | -24,779.0 | -26,707.0 | -27,857.0 | .0 | -30,482.3 | -34,514.4 | -39,079.7 | -44,249.0 | -50,101.9 |
| Inventories, % | -32.28 | -32.12 | -32.15 | -30 | 0 | -25.31 | -25.31 | -25.31 | -25.31 | -25.31 |
| Accounts Payable | 3,529.0 | 3,693.0 | 4,183.0 | 4,940.0 | 16,810.0 | 8,764.3 | 9,923.5 | 11,236.2 | 12,722.4 | 14,405.3 |
| Accounts Payable, % | 5.44 | 4.79 | 5.04 | 5.32 | 15.8 | 7.28 | 7.28 | 7.28 | 7.28 | 7.28 |
| Capital Expenditure | -736.0 | -964.0 | -1,316.0 | -1,120.0 | -1,004.0 | -1,473.7 | -1,668.7 | -1,889.4 | -2,139.3 | -2,422.3 |
| Capital Expenditure, % | -1.13 | -1.25 | -1.58 | -1.21 | -0.94384 | -1.22 | -1.22 | -1.22 | -1.22 | -1.22 |
| Tax Rate, % | 26.43 | 26.43 | 26.43 | 26.43 | 26.43 | 26.43 | 26.43 | 26.43 | 26.43 | 26.43 |
| EBITAT | 2,815.9 | 3,535.4 | 3,171.7 | 3,014.4 | 2,952.5 | 4,535.8 | 5,135.7 | 5,815.1 | 6,584.2 | 7,455.2 |
| Depreciation | ||||||||||
| Changes in Account Receivables | ||||||||||
| Changes in Inventories | ||||||||||
| Changes in Accounts Payable | ||||||||||
| Capital Expenditure | ||||||||||
| UFCF | 26,071.9 | 7,104.4 | 4,310.7 | 4,786.4 | -13,482.5 | 26,404.6 | 9,548.4 | 10,811.4 | 12,241.5 | 13,860.7 |
| WACC, % | 5.99 | 5.93 | 6.1 | 5.99 | 5.93 | 5.99 | 5.99 | 5.99 | 5.99 | 5.99 |
| PV UFCF | ||||||||||
| SUM PV UFCF | 62,559.8 | |||||||||
| Long Term Growth Rate, % | 2.00 | |||||||||
| Free cash flow (T + 1) | 14,138 | |||||||||
| Terminal Value | 354,640 | |||||||||
| Present Terminal Value | 265,176 | |||||||||
| Enterprise Value | 327,735 | |||||||||
| Net Debt | 6,962 | |||||||||
| Equity Value | 320,773 | |||||||||
| Diluted Shares Outstanding, MM | 124 | |||||||||
| Equity Value Per Share | 2,577.71 |
What You Will Get
- Real Humana Data: Preloaded financials – from revenue to EBIT – based on actual and projected figures.
- Full Customization: Adjust all critical parameters (yellow cells) like WACC, growth %, and tax rates.
- Instant Valuation Updates: Automatic recalculations to analyze the impact of changes on Humana’s fair value.
- Versatile Excel Template: Tailored for quick edits, scenario testing, and detailed projections.
- Time-Saving and Accurate: Skip building models from scratch while maintaining precision and flexibility.
Key Features
- Comprehensive DCF Calculator: Provides in-depth unlevered and levered DCF valuation models tailored for Humana Inc. (HUM).
- WACC Calculator: Features a pre-configured Weighted Average Cost of Capital sheet with adjustable inputs specific to healthcare.
- Customizable Forecast Assumptions: Easily adjust growth rates, capital expenditures, and discount rates to reflect market conditions.
- Integrated Financial Ratios: Evaluate profitability, leverage, and efficiency ratios specifically for Humana Inc. (HUM).
- Interactive Dashboard and Charts: Visual representations of key valuation metrics facilitate straightforward analysis.
How It Works
- Download the Template: Get instant access to the Excel-based HUM DCF Calculator.
- Input Your Assumptions: Adjust yellow-highlighted cells for growth rates, WACC, margins, and more.
- Instant Calculations: The model automatically updates Humana Inc.’s intrinsic value.
- Test Scenarios: Simulate different assumptions to evaluate potential valuation changes.
- Analyze and Decide: Use the results to guide your investment or financial analysis.
Why Choose This Calculator for Humana Inc. (HUM)?
- Accurate Data: Real Humana financials provide trustworthy valuation outcomes.
- Customizable: Modify essential parameters such as growth rates, WACC, and tax rates to align with your forecasts.
- Time-Saving: Pre-built calculations streamline the process and eliminate the need for starting from scratch.
- Professional-Grade Tool: Tailored for investors, analysts, and consultants in the healthcare sector.
- User-Friendly: An intuitive design and step-by-step guidance ensure ease of use for everyone.
Who Should Use This Product?
- Investors: Accurately assess Humana Inc.’s (HUM) fair value prior to making investment choices.
- CFOs: Utilize a high-quality DCF model for financial reporting and analysis at Humana Inc. (HUM).
- Consultants: Easily customize the template for valuation reports tailored for Humana Inc. (HUM) clients.
- Entrepreneurs: Discover financial modeling techniques employed by leading healthcare companies like Humana Inc. (HUM).
- Educators: Implement it as a teaching resource to illustrate valuation methodologies relevant to Humana Inc. (HUM).
What the Template Contains
- Pre-Filled DCF Model: Humana Inc.’s (HUM) financial data preloaded for immediate use.
- WACC Calculator: Detailed calculations for Weighted Average Cost of Capital.
- Financial Ratios: Evaluate Humana Inc.’s (HUM) profitability, leverage, and efficiency.
- Editable Inputs: Change assumptions such as growth, margins, and CAPEX to fit your scenarios.
- Financial Statements: Annual and quarterly reports to support detailed analysis.
- Interactive Dashboard: Easily visualize key valuation metrics and results.