Medical Properties Trust, Inc. (MPW) 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
Medical Properties Trust, Inc. (MPW) Bundle
Looking to assess the intrinsic value of Medical Properties Trust, Inc.? Our (MPW) DCF Calculator merges real-world data with comprehensive customization features, enabling you to refine your forecasts and enhance your investment choices.
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 | 854.2 | 1,249.2 | 1,544.7 | 1,542.9 | 871.8 | 929.1 | 990.1 | 1,055.2 | 1,124.5 | 1,198.4 |
| Revenue Growth, % | 0 | 46.25 | 23.65 | -0.1177 | -43.49 | 6.57 | 6.57 | 6.57 | 6.57 | 6.57 |
| EBITDA | 733.8 | 1,092.7 | 1,359.9 | 1,336.7 | 684.6 | 792.7 | 844.7 | 900.3 | 959.4 | 1,022.5 |
| EBITDA, % | 85.9 | 87.47 | 88.04 | 86.64 | 78.53 | 85.32 | 85.32 | 85.32 | 85.32 | 85.32 |
| Depreciation | 272.7 | 420.8 | 506.0 | 539.2 | 603.4 | 376.3 | 401.0 | 427.4 | 455.5 | 485.4 |
| Depreciation, % | 31.93 | 33.68 | 32.76 | 34.95 | 69.21 | 40.5 | 40.5 | 40.5 | 40.5 | 40.5 |
| EBIT | 461.1 | 671.9 | 853.9 | 797.5 | 81.3 | 416.3 | 443.7 | 472.9 | 503.9 | 537.0 |
| EBIT, % | 53.98 | 53.78 | 55.28 | 51.69 | 9.32 | 44.81 | 44.81 | 44.81 | 44.81 | 44.81 |
| Total Cash | 1,462.3 | 549.9 | 459.2 | 235.7 | 250.0 | 404.5 | 431.1 | 459.4 | 489.6 | 521.8 |
| Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
| Account Receivables | 910.4 | 1,395.0 | 2,113.4 | 1,182.0 | 681.0 | 845.0 | 900.5 | 959.7 | 1,022.7 | 1,089.9 |
| Account Receivables, % | 106.58 | 111.67 | 136.82 | 76.61 | 78.12 | 90.95 | 90.95 | 90.95 | 90.95 | 90.95 |
| Inventories | 1,827.9 | .0 | 1,244.0 | -304.5 | .0 | 298.8 | 318.4 | 339.3 | 361.6 | 385.4 |
| Inventories, % | 213.99 | 0.00000008 | 80.53 | -19.74 | 0 | 32.16 | 32.16 | 32.16 | 32.16 | 32.16 |
| Accounts Payable | .0 | 387.5 | 603.6 | 621.3 | 412.2 | 292.9 | 312.2 | 332.7 | 354.5 | 377.8 |
| Accounts Payable, % | 0 | 31.01 | 39.08 | 40.27 | 47.28 | 31.53 | 31.53 | 31.53 | 31.53 | 31.53 |
| Capital Expenditure | -4,858.8 | -4,285.4 | -65.5 | -1,540.4 | .0 | -565.0 | -602.2 | -641.7 | -683.9 | -728.8 |
| Capital Expenditure, % | -568.81 | -343.04 | -4.24 | -99.84 | 0 | -60.82 | -60.82 | -60.82 | -60.82 | -60.82 |
| Tax Rate, % | 18.97 | 18.97 | 18.97 | 18.97 | 18.97 | 18.97 | 18.97 | 18.97 | 18.97 | 18.97 |
| EBITAT | 462.2 | 625.7 | 766.5 | 750.0 | 65.9 | 381.3 | 406.4 | 433.1 | 461.5 | 491.9 |
| Depreciation | ||||||||||
| Changes in Account Receivables | ||||||||||
| Changes in Inventories | ||||||||||
| Changes in Accounts Payable | ||||||||||
| Capital Expenditure | ||||||||||
| UFCF | -6,862.1 | -1,508.2 | -539.3 | 2,246.4 | 656.6 | -389.4 | 149.4 | 159.2 | 169.6 | 180.8 |
| WACC, % | 5.6 | 5.35 | 5.23 | 5.38 | 4.91 | 5.29 | 5.29 | 5.29 | 5.29 | 5.29 |
| PV UFCF | ||||||||||
| SUM PV UFCF | 179.0 | |||||||||
| Long Term Growth Rate, % | 4.00 | |||||||||
| Free cash flow (T + 1) | 188 | |||||||||
| Terminal Value | 14,552 | |||||||||
| Present Terminal Value | 11,245 | |||||||||
| Enterprise Value | 11,424 | |||||||||
| Net Debt | 9,918 | |||||||||
| Equity Value | 1,506 | |||||||||
| Diluted Shares Outstanding, MM | 599 | |||||||||
| Equity Value Per Share | 2.52 |
What You Will Receive
- Pre-Filled Financial Model: Medical Properties Trust, Inc.'s (MPW) actual data facilitates accurate DCF valuation.
- Comprehensive Forecast Control: Modify revenue growth, profit margins, WACC, and other essential metrics.
- Real-Time Calculations: Instantaneous updates allow you to view results as adjustments are made.
- Investor-Ready Template: A polished Excel file crafted for high-quality valuation presentations.
- Customizable and Reusable: Designed for adaptability, enabling repeated application for in-depth forecasts.
Key Features
- Comprehensive MPW Data: Pre-filled with Medical Properties Trust’s historical financials and forward-looking projections.
- Fully Customizable Inputs: Adjust revenue growth, margins, WACC, tax rates, and capital expenditures tailored to MPW.
- Dynamic Valuation Model: Automatic updates to Net Present Value (NPV) and intrinsic value based on your inputs for [MPW].
- Scenario Testing: Create multiple forecast scenarios to analyze different valuation outcomes for Medical Properties Trust.
- User-Friendly Design: Simple, structured, and designed for both professionals and beginners in the real estate investment sector.
How It Works
- Download the Template: Gain immediate access to the Excel-based MPW DCF Calculator.
- Input Your Assumptions: Modify the yellow-highlighted cells for growth rates, WACC, margins, and more.
- Instant Calculations: The model automatically recalculates Medical Properties Trust’s intrinsic value.
- Test Scenarios: Experiment with different assumptions to assess potential valuation fluctuations.
- Analyze and Decide: Utilize the results to inform your investment or financial analysis.
Why Choose This Calculator for Medical Properties Trust, Inc. (MPW)?
- Comprehensive Tool: Features DCF, WACC, and financial ratio analyses tailored for healthcare real estate.
- Customizable Inputs: Modify yellow-highlighted cells to explore different investment scenarios.
- Detailed Insights: Automatically computes Medical Properties Trust’s intrinsic value and Net Present Value.
- Preloaded Data: Historical and projected data provide reliable starting points for analysis.
- Professional Quality: Perfect for real estate analysts, investors, and financial consultants specializing in healthcare.
Who Should Use This Product?
- Investors: Evaluate Medical Properties Trust, Inc. (MPW) for informed stock trading decisions.
- CFOs and Financial Analysts: Optimize valuation methods and assess financial forecasts.
- Healthcare Executives: Understand the valuation processes of REITs like Medical Properties Trust, Inc. (MPW).
- Consultants: Create comprehensive valuation analyses for healthcare clients.
- Students and Educators: Utilize real-time data to study and teach valuation strategies.
What the Template Contains
- Operating and Balance Sheet Data: Pre-filled Medical Properties Trust, Inc. (MPW) historical data and forecasts, including revenue, EBITDA, EBIT, and capital expenditures.
- WACC Calculation: A dedicated sheet for Weighted Average Cost of Capital (WACC), including parameters like Beta, risk-free rate, and share price.
- DCF Valuation (Unlevered and Levered): Editable Discounted Cash Flow models showing intrinsic value with detailed calculations.
- Financial Statements: Pre-loaded financial statements (annual and quarterly) to support analysis.
- Key Ratios: Includes profitability, leverage, and efficiency ratios for Medical Properties Trust, Inc. (MPW).
- Dashboard and Charts: Visual summary of valuation outputs and assumptions to analyze results easily.