|
Valoración de DCF Omega Healthcare Investors, Inc. (OHI)
US | Real Estate | REIT - Healthcare Facilities | 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
Omega Healthcare Investors, Inc. (OHI) Bundle
¡Mejore sus estrategias de inversión con la calculadora DCF Omega Healthcare Investors, Inc. (OHI)! Explore datos financieros auténticos, ajuste las proyecciones y gastos de crecimiento, y observe instantáneamente cómo estos cambios afectan el valor intrínseco de Omega Healthcare Investors, Inc. (OHI).
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 | 928.8 | 892.4 | 1,062.8 | 878.2 | 949.7 | 963.9 | 978.2 | 992.7 | 1,007.5 | 1,022.5 |
| Revenue Growth, % | 0 | -3.92 | 19.1 | -17.37 | 8.14 | 1.49 | 1.49 | 1.49 | 1.49 | 1.49 |
| EBITDA | 856.7 | 782.2 | 906.9 | 722.7 | 810.8 | 834.5 | 846.9 | 859.5 | 872.3 | 885.2 |
| EBITDA, % | 92.24 | 87.65 | 85.33 | 82.29 | 85.38 | 86.58 | 86.58 | 86.58 | 86.58 | 86.58 |
| Depreciation | 374.5 | 648.9 | 496.6 | 486.0 | 319.7 | 479.5 | 486.7 | 493.9 | 501.2 | 508.7 |
| Depreciation, % | 40.32 | 72.71 | 46.73 | 55.33 | 33.66 | 49.75 | 49.75 | 49.75 | 49.75 | 49.75 |
| EBIT | 482.3 | 133.3 | 410.3 | 236.7 | 491.2 | 354.9 | 360.2 | 365.6 | 371.0 | 376.5 |
| EBIT, % | 51.92 | 14.94 | 38.6 | 26.95 | 51.72 | 36.83 | 36.83 | 36.83 | 36.83 | 36.83 |
| Total Cash | 24.1 | 163.5 | 20.5 | 297.1 | 442.8 | 199.1 | 202.1 | 205.1 | 208.2 | 211.3 |
| Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
| Account Receivables | 1,193.3 | 1,141.2 | 1,578.9 | 1,462.5 | 232.1 | 818.2 | 830.4 | 842.7 | 855.3 | 868.0 |
| Account Receivables, % | 128.47 | 127.88 | 148.56 | 166.53 | 24.44 | 84.89 | 84.89 | 84.89 | 84.89 | 84.89 |
| Inventories | 455.8 | 498.1 | .0 | 499.7 | .0 | 311.9 | 316.5 | 321.2 | 326.0 | 330.8 |
| Inventories, % | 49.07 | 55.82 | 0.0000000941 | 56.89 | 0 | 32.36 | 32.36 | 32.36 | 32.36 | 32.36 |
| Accounts Payable | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
| Accounts Payable, % | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
| Capital Expenditure | -139.7 | -75.1 | -95.1 | -47.2 | .0 | -72.8 | -73.9 | -75.0 | -76.1 | -77.3 |
| Capital Expenditure, % | -15.04 | -8.42 | -8.94 | -5.38 | 0 | -7.56 | -7.56 | -7.56 | -7.56 | -7.56 |
| Tax Rate, % | 5.26 | 5.26 | 5.26 | 5.26 | 5.26 | 5.26 | 5.26 | 5.26 | 5.26 | 5.26 |
| EBITAT | 478.4 | 130.8 | 410.9 | 231.7 | 465.3 | 347.8 | 353.0 | 358.3 | 363.6 | 369.0 |
| Depreciation | ||||||||||
| Changes in Account Receivables | ||||||||||
| Changes in Inventories | ||||||||||
| Changes in Accounts Payable | ||||||||||
| Capital Expenditure | ||||||||||
| UFCF | -935.8 | 714.4 | 872.8 | 287.2 | 2,515.1 | -143.4 | 749.0 | 760.1 | 771.4 | 782.9 |
| WACC, % | 7.51 | 7.49 | 7.52 | 7.49 | 7.44 | 7.49 | 7.49 | 7.49 | 7.49 | 7.49 |
| PV UFCF | ||||||||||
| SUM PV UFCF | 2,250.2 | |||||||||
| Long Term Growth Rate, % | 3.50 | |||||||||
| Free cash flow (T + 1) | 810 | |||||||||
| Terminal Value | 20,302 | |||||||||
| Present Terminal Value | 14,147 | |||||||||
| Enterprise Value | 16,397 | |||||||||
| Net Debt | 4,625 | |||||||||
| Equity Value | 11,773 | |||||||||
| Diluted Shares Outstanding, MM | 250 | |||||||||
| Equity Value Per Share | 47.01 |
What You Will Get
- Real OHI Financial Data: Pre-filled with Omega Healthcare Investors, Inc.'s historical and projected data for precise analysis.
- Fully Editable Template: Modify key inputs like revenue growth, WACC, and EBITDA % with ease.
- Automatic Calculations: See Omega Healthcare's intrinsic value update instantly based on your changes.
- Professional Valuation Tool: Designed for investors, analysts, and consultants seeking accurate DCF results.
- User-Friendly Design: Simple structure and clear instructions for all experience levels.
Key Features
- Real Omega Financials: Access precise pre-loaded historical data and future projections for Omega Healthcare Investors, Inc. (OHI).
- Customizable Forecast Assumptions: Modify yellow-highlighted cells such as WACC, growth rates, and margins to fit your analysis.
- Dynamic Calculations: Automatic updates to DCF, Net Present Value (NPV), and cash flow analysis tailored for OHI.
- Visual Dashboard: User-friendly charts and summaries to help visualize your valuation results for Omega Healthcare Investors, Inc. (OHI).
- For Professionals and Beginners: An intuitive structure designed for investors, CFOs, and consultants interested in OHI.
How It Works
- Step 1: Download the Excel file.
- Step 2: Review pre-entered Omega Healthcare Investors, Inc. (OHI) data (historical and projected).
- Step 3: Adjust key assumptions (yellow cells) based on your analysis.
- Step 4: View automatic recalculations for Omega Healthcare's intrinsic value.
- Step 5: Use the outputs for investment decisions or reporting.
Why Choose This Calculator for Omega Healthcare Investors, Inc. (OHI)?
- Accurate Data: Real Omega Healthcare financials provide dependable valuation results.
- Customizable: Tailor key parameters such as growth rates, WACC, and tax rates to align with your forecasts.
- Time-Saving: Pre-built calculations save you from starting from the ground up.
- Professional-Grade Tool: Crafted for investors, analysts, and consultants in the healthcare sector.
- User-Friendly: Intuitive design and step-by-step guidance ensure ease of use for everyone.
Who Should Use Omega Healthcare Investors, Inc. (OHI)?
- Institutional Investors: Develop comprehensive and trustworthy valuation models for healthcare REIT analysis.
- Financial Analysts: Evaluate valuation scenarios to inform investment strategies in the healthcare sector.
- Investment Advisors: Deliver precise valuation insights to clients considering investments in Omega Healthcare.
- Academic Researchers: Utilize real-world data to study and teach financial modeling in the healthcare industry.
- Healthcare Sector Enthusiasts: Gain insights into how healthcare REITs like Omega Healthcare Investors are valued in the market.
What the Template Contains
- Preloaded OHI Data: Historical and projected financial data, including revenue, EBIT, and capital expenditures.
- DCF and WACC Models: Professional-grade sheets for calculating intrinsic value and Weighted Average Cost of Capital.
- Editable Inputs: Yellow-highlighted cells for adjusting revenue growth, tax rates, and discount rates.
- Financial Statements: Comprehensive annual and quarterly financials for deeper analysis.
- Key Ratios: Profitability, leverage, and efficiency ratios to evaluate performance.
- Dashboard and Charts: Visual summaries of valuation outcomes and assumptions.