Healthcare Realty Trust Incorporated (HR) 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
Healthcare Realty Trust Incorporated (HR) Bundle
Whether you're an investor or an analyst, this (HR) DCF Calculator is your go-to resource for accurate valuation. Loaded with real data from Healthcare Realty Trust Incorporated, you can adjust forecasts and instantly observe the effects.
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 | 470.3 | 499.6 | 534.8 | 932.6 | 1,343.8 | 1,786.4 | 2,374.7 | 3,156.9 | 4,196.7 | 5,578.9 |
| Revenue Growth, % | 0 | 6.24 | 7.04 | 74.38 | 44.08 | 32.94 | 32.94 | 32.94 | 32.94 | 32.94 |
| EBITDA | 276.2 | 274.2 | 287.6 | 555.6 | 780.5 | 1,018.4 | 1,353.8 | 1,799.7 | 2,392.4 | 3,180.4 |
| EBITDA, % | 58.73 | 54.88 | 53.77 | 59.57 | 58.08 | 57.01 | 57.01 | 57.01 | 57.01 | 57.01 |
| Depreciation | 643.8 | 665.3 | 449.1 | 853.9 | 730.7 | 1,536.0 | 2,041.9 | 2,714.4 | 3,608.4 | 4,796.9 |
| Depreciation, % | 136.89 | 133.17 | 83.98 | 91.56 | 54.38 | 85.98 | 85.98 | 85.98 | 85.98 | 85.98 |
| EBIT | -367.6 | -391.2 | -161.5 | -298.3 | 49.8 | -767.9 | -1,020.8 | -1,357.0 | -1,804.0 | -2,398.2 |
| EBIT, % | -78.16 | -78.29 | -30.21 | -31.98 | 3.71 | -42.99 | -42.99 | -42.99 | -42.99 | -42.99 |
| Total Cash | .7 | 15.3 | 13.2 | 61.0 | 25.7 | 50.4 | 67.0 | 89.1 | 118.5 | 157.5 |
| Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
| Account Receivables | 83.5 | 78.2 | 84.9 | 243.2 | 353.7 | 363.2 | 482.9 | 641.9 | 853.3 | 1,134.4 |
| Account Receivables, % | 17.75 | 15.65 | 15.87 | 26.07 | 26.32 | 20.33 | 20.33 | 20.33 | 20.33 | 20.33 |
| Inventories | 91.4 | 39.7 | 13.2 | .0 | .0 | 106.6 | 141.7 | 188.4 | 250.5 | 332.9 |
| Inventories, % | 19.43 | 7.95 | 2.47 | 0.000000107 | 0 | 5.97 | 5.97 | 5.97 | 5.97 | 5.97 |
| Accounts Payable | 78.5 | 81.2 | 17.0 | 57.4 | 212.0 | 207.4 | 275.7 | 366.5 | 487.3 | 647.7 |
| Accounts Payable, % | 16.7 | 16.25 | 3.19 | 6.15 | 15.78 | 11.61 | 11.61 | 11.61 | 11.61 | 11.61 |
| Capital Expenditure | -64.7 | -94.0 | -100.7 | -163.5 | -231.0 | -307.7 | -409.0 | -543.7 | -722.8 | -960.8 |
| Capital Expenditure, % | -13.75 | -18.81 | -18.83 | -17.54 | -17.19 | -17.22 | -17.22 | -17.22 | -17.22 | -17.22 |
| Tax Rate, % | 1.35 | 1.35 | 1.35 | 1.35 | 1.35 | 1.35 | 1.35 | 1.35 | 1.35 | 1.35 |
| EBITAT | 159.3 | -104.0 | -34.7 | 777.0 | 49.1 | -225.3 | -299.5 | -398.2 | -529.3 | -703.7 |
| Depreciation | ||||||||||
| Changes in Account Receivables | ||||||||||
| Changes in Inventories | ||||||||||
| Changes in Accounts Payable | ||||||||||
| Capital Expenditure | ||||||||||
| UFCF | 642.1 | 527.0 | 269.5 | 1,362.6 | 593.0 | 882.3 | 1,246.9 | 1,657.6 | 2,203.6 | 2,929.4 |
| WACC, % | 4.4 | 4.97 | 4.86 | 4.4 | 6.5 | 5.03 | 5.03 | 5.03 | 5.03 | 5.03 |
| PV UFCF | ||||||||||
| SUM PV UFCF | 7,504.8 | |||||||||
| Long Term Growth Rate, % | 2.00 | |||||||||
| Free cash flow (T + 1) | 2,988 | |||||||||
| Terminal Value | 98,739 | |||||||||
| Present Terminal Value | 77,268 | |||||||||
| Enterprise Value | 84,773 | |||||||||
| Net Debt | 5,273 | |||||||||
| Equity Value | 79,499 | |||||||||
| Diluted Shares Outstanding, MM | 379 | |||||||||
| Equity Value Per Share | 209.80 |
What You Will Get
- Pre-Filled Financial Model: Healthcare Realty Trust's actual data enables precise DCF valuation.
- Full Forecast Control: Adjust revenue growth, margins, WACC, and other key drivers.
- Instant Calculations: Automatic updates ensure you see results as you make changes.
- Investor-Ready Template: A refined Excel file designed for professional-grade valuation.
- Customizable and Reusable: Tailored for flexibility, allowing repeated use for detailed forecasts.
Key Features
- Comprehensive DCF Analysis Tool: Features both unlevered and levered DCF valuation models tailored for Healthcare Realty Trust Incorporated (HR).
- WACC Estimator: Pre-configured Weighted Average Cost of Capital sheet with adjustable parameters for precise calculations.
- Customizable Forecast Inputs: Alter growth projections, capital spending, and discount rates to fit specific scenarios.
- Integrated Financial Ratios: Evaluate profitability, leverage, and efficiency ratios specifically for Healthcare Realty Trust Incorporated (HR).
- Visual Dashboard and Graphs: Graphical representations that encapsulate essential valuation metrics for streamlined analysis.
How It Functions
- Download the Template: Gain immediate access to the Excel-based HR DCF Calculator.
- Input Your Assumptions: Modify the yellow-highlighted cells for growth rates, WACC, margins, and additional parameters.
- Instant Calculations: The model automatically recalculates Healthcare Realty Trust's intrinsic value.
- Test Scenarios: Experiment with various assumptions to assess potential valuation fluctuations.
- Analyze and Decide: Utilize the outcomes to inform your investment or financial analysis decisions.
Why Choose This Calculator for Healthcare Realty Trust Incorporated (HR)?
- Accurate Data: Utilize real financials from Healthcare Realty Trust for dependable valuation outcomes.
- Customizable: Modify essential parameters such as growth rates, WACC, and tax rates to fit your forecasts.
- Time-Saving: Built-in calculations save you the hassle of starting from the ground up.
- Professional-Grade Tool: Tailored for investors, analysts, and consultants in the healthcare real estate sector.
- User-Friendly: Easy-to-navigate design and clear instructions facilitate use for everyone.
Who Should Use This Product?
- Healthcare Students: Explore real estate investment strategies and apply them using actual market data.
- Researchers: Integrate industry-specific models into academic studies and publications.
- Real Estate Investors: Validate your investment hypotheses and assess valuation outcomes for Healthcare Realty Trust Incorporated (HR).
- Financial Analysts: Enhance your analysis with a ready-to-use, customizable financial model tailored for real estate.
- Property Managers: Understand how large healthcare REITs like Healthcare Realty Trust Incorporated (HR) are evaluated in the market.
What the Template Contains
- Operating and Balance Sheet Data: Pre-filled Healthcare Realty Trust Incorporated (HR) historical data and forecasts, including revenue, EBITDA, EBIT, and capital expenditures.
- WACC Calculation: A dedicated sheet for Weighted Average Cost of Capital (WACC), featuring parameters like Beta, risk-free rate, and share price.
- DCF Valuation (Unlevered and Levered): Editable Discounted Cash Flow models illustrating intrinsic value with comprehensive calculations.
- Financial Statements: Pre-loaded financial statements (annual and quarterly) to support in-depth analysis.
- Key Ratios: Includes profitability, leverage, and efficiency ratios for Healthcare Realty Trust Incorporated (HR).
- Dashboard and Charts: Visual summary of valuation outputs and assumptions to facilitate result analysis.