Physicians Realty Trust (DOC) DCF Valuation
- ✓ 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
Physicians Realty Trust (DOC) Bundle
Explore the financial prospects of Physicians Realty Trust (DOC) with our user-friendly DCF Calculator! Simply enter your assumptions regarding growth rates, profit margins, and expenses to calculate the intrinsic value of Physicians Realty Trust (DOC) and enhance your investment strategy.
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 | 415.3 | 437.5 | 457.7 | 526.6 | 2,181.0 | 2,055.4 | 1,937.1 | 1,825.6 | 1,720.5 | 1,621.4 |
| Revenue Growth, % | 0 | 5.35 | 4.62 | 15.06 | 314.14 | -5.76 | -5.76 | -5.76 | -5.76 | -5.76 |
| EBITDA | 257.3 | 1,133.2 | 281.0 | 314.5 | 1,189.4 | 1,387.9 | 1,308.0 | 1,232.7 | 1,161.7 | 1,094.8 |
| EBITDA, % | 61.97 | 259.01 | 61.39 | 59.73 | 54.54 | 67.52 | 67.52 | 67.52 | 67.52 | 67.52 |
| Depreciation | 951.1 | 1,472.6 | 1,579.0 | 1,711.6 | 749.9 | 1,785.7 | 1,682.9 | 1,586.0 | 1,494.7 | 1,408.6 |
| Depreciation, % | 229.03 | 336.6 | 344.99 | 325.01 | 34.38 | 86.88 | 86.88 | 86.88 | 86.88 | 86.88 |
| EBIT | -693.8 | -339.5 | -1,298.1 | -1,397.1 | 439.5 | -1,469.4 | -1,384.8 | -1,305.1 | -1,229.9 | -1,159.1 |
| EBIT, % | -167.06 | -77.59 | -283.61 | -265.28 | 20.15 | -71.49 | -71.49 | -71.49 | -71.49 | -71.49 |
| Total Cash | 2.4 | 2.5 | 9.9 | 7.7 | 139.0 | 45.8 | 43.2 | 40.7 | 38.3 | 36.1 |
| Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
| Account Receivables | 186.2 | 237.6 | 464.5 | 428.3 | 274.3 | 1,204.7 | 1,135.3 | 1,070.0 | 1,008.4 | 950.3 |
| Account Receivables, % | 44.84 | 54.32 | 101.49 | 81.32 | 12.58 | 58.61 | 58.61 | 58.61 | 58.61 | 58.61 |
| Inventories | -4.9 | 117.6 | 2.0 | -12.6 | .0 | 97.5 | 91.9 | 86.6 | 81.7 | 76.9 |
| Inventories, % | -1.19 | 26.88 | 0.4291 | -2.39 | 0 | 4.75 | 4.75 | 4.75 | 4.75 | 4.75 |
| Accounts Payable | .0 | 269.1 | 227.6 | 265.6 | 240.3 | 710.0 | 669.1 | 630.6 | 594.3 | 560.0 |
| Accounts Payable, % | 0 | 61.52 | 49.74 | 50.43 | 11.02 | 34.54 | 34.54 | 34.54 | 34.54 | 34.54 |
| Capital Expenditure | -40.1 | -33.9 | -32.6 | -39.9 | .0 | -131.9 | -124.3 | -117.2 | -110.4 | -104.1 |
| Capital Expenditure, % | -9.67 | -7.75 | -7.12 | -7.57 | 0 | -6.42 | -6.42 | -6.42 | -6.42 | -6.42 |
| Tax Rate, % | 2.83 | 2.83 | 2.83 | 2.83 | 2.83 | 2.83 | 2.83 | 2.83 | 2.83 | 2.83 |
| EBITAT | -85.3 | -50.5 | -379.9 | -479.9 | 427.1 | -552.4 | -520.6 | -490.6 | -462.4 | -435.7 |
| Depreciation | ||||||||||
| Changes in Account Receivables | ||||||||||
| Changes in Inventories | ||||||||||
| Changes in Accounts Payable | ||||||||||
| Capital Expenditure | ||||||||||
| UFCF | 644.4 | 1,483.4 | 1,013.8 | 1,280.5 | 1,293.0 | 543.1 | 1,072.0 | 1,010.3 | 952.2 | 897.3 |
| WACC, % | 6.13 | 6.17 | 6.42 | 6.51 | 7.61 | 6.57 | 6.57 | 6.57 | 6.57 | 6.57 |
| PV UFCF | ||||||||||
| SUM PV UFCF | 3,679.5 | |||||||||
| Long Term Growth Rate, % | 4.00 | |||||||||
| Free cash flow (T + 1) | 933 | |||||||||
| Terminal Value | 36,348 | |||||||||
| Present Terminal Value | 26,446 | |||||||||
| Enterprise Value | 30,125 | |||||||||
| Net Debt | 6,965 | |||||||||
| Equity Value | 23,160 | |||||||||
| Diluted Shares Outstanding, MM | 547 | |||||||||
| Equity Value Per Share | 42.32 |
What You Will Receive
- Comprehensive Financial Model: Physicians Realty Trust’s (DOC) actual data facilitates accurate DCF valuation.
- Complete Forecast Customization: Modify revenue growth, profit margins, WACC, and other essential parameters.
- Real-Time Calculations: Automatic updates provide immediate feedback as you adjust inputs.
- Professional-Grade Template: A polished Excel file crafted for high-quality valuation presentations.
- Flexible and Reusable: Designed for adaptability, enabling repeated application for in-depth forecasts.
Key Features
- 🔍 Real-Life DOC Financials: Pre-filled historical and projected data for Physicians Realty Trust (DOC).
- ✏️ Fully Customizable Inputs: Adjust all critical parameters (yellow cells) like WACC, growth %, and tax rates.
- 📊 Professional DCF Valuation: Built-in formulas calculate Physicians Realty Trust’s intrinsic value using the Discounted Cash Flow method.
- ⚡ Instant Results: Visualize Physicians Realty Trust’s valuation instantly after making changes.
- Scenario Analysis: Test and compare outcomes for various financial assumptions side-by-side.
How It Works
- Step 1: Download the Excel file for Physicians Realty Trust (DOC).
- Step 2: Review the pre-filled financial data and forecasts for Physicians Realty Trust (DOC).
- Step 3: Adjust key inputs such as revenue growth, WACC, and tax rates (highlighted cells).
- Step 4: Observe the DCF model update in real-time as you change your assumptions.
- Step 5: Evaluate the outputs and leverage the results for your investment strategies.
Why Choose This Calculator for Physicians Realty Trust (DOC)?
- Designed for Industry Experts: A sophisticated tool tailored for real estate analysts, investors, and financial advisors.
- Comprehensive Data: Physicians Realty Trust’s historical and projected financials preloaded for precise analysis.
- Flexible Scenario Analysis: Easily test various investment scenarios and assumptions.
- Insightful Outputs: Automatically computes intrinsic value, NPV, and essential financial metrics.
- User-Friendly: Detailed instructions lead you through each step of the calculation process.
Who Should Use This Product?
- Real Estate Students: Understand investment strategies and apply them using real-world data.
- Researchers: Utilize industry-specific models in academic studies or publications.
- Investors: Evaluate your own investment strategies and assess valuation metrics for Physicians Realty Trust (DOC).
- Financial Analysts: Enhance your analysis with a pre-built, customizable DCF model tailored for real estate.
- Property Managers: Learn how large real estate investment trusts like Physicians Realty Trust (DOC) are assessed.
What the Template Contains
- Pre-Filled DCF Model: Physicians Realty Trust’s (DOC) financial data preloaded for immediate use.
- WACC Calculator: Detailed calculations for Weighted Average Cost of Capital specific to (DOC).
- Financial Ratios: Evaluate (DOC)’s profitability, leverage, and efficiency metrics.
- Editable Inputs: Modify assumptions such as growth rates, margins, and CAPEX to suit your analysis.
- Financial Statements: Access annual and quarterly reports to support comprehensive evaluation.
- Interactive Dashboard: Effortlessly visualize key valuation metrics and outcomes for (DOC).