|
Brandywine Realty Trust (BDN) DCF Valoración
US | Real Estate | REIT - Office | 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
Brandywine Realty Trust (BDN) Bundle
Ingementista para su precisión, nuestra calculadora DCF (BDN) le permite evaluar la valoración de Brandywine Realty Trust utilizando datos financieros reales y proporciona flexibilidad completa para modificar los parámetros esenciales para mejorar las proyecciones.
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 | 580.4 | 534.9 | 486.8 | 506.1 | 514.7 | 504.4 | 494.4 | 484.6 | 474.9 | 465.5 |
| Revenue Growth, % | 0 | -7.85 | -8.98 | 3.96 | 1.69 | -1.99 | -1.99 | -1.99 | -1.99 | -1.99 |
| EBITDA | 322.4 | 279.6 | 250.1 | 276.7 | 91.3 | 233.7 | 229.0 | 224.5 | 220.0 | 215.6 |
| EBITDA, % | 55.55 | 52.28 | 51.37 | 54.67 | 17.74 | 46.32 | 46.32 | 46.32 | 46.32 | 46.32 |
| Depreciation | 468.0 | 424.0 | 396.6 | 407.4 | 188.8 | 361.7 | 354.5 | 347.5 | 340.6 | 333.8 |
| Depreciation, % | 80.63 | 79.28 | 81.46 | 80.5 | 36.68 | 71.71 | 71.71 | 71.71 | 71.71 | 71.71 |
| EBIT | -145.6 | -144.4 | -146.5 | -130.7 | -97.5 | -128.1 | -125.5 | -123.0 | -120.6 | -118.2 |
| EBIT, % | -25.08 | -27 | -30.09 | -25.82 | -18.95 | -25.39 | -25.39 | -25.39 | -25.39 | -25.39 |
| Total Cash | 90.5 | 46.3 | 27.5 | 17.6 | 58.3 | 45.1 | 44.2 | 43.3 | 42.5 | 41.6 |
| Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
| Account Receivables | 190.5 | 168.9 | 179.1 | 190.8 | 198.7 | 179.1 | 175.5 | 172.0 | 168.6 | 165.2 |
| Account Receivables, % | 32.82 | 31.58 | 36.79 | 37.69 | 38.61 | 35.5 | 35.5 | 35.5 | 35.5 | 35.5 |
| Inventories | 114.2 | 67.2 | 39.9 | 28.6 | .0 | 46.5 | 45.6 | 44.7 | 43.8 | 42.9 |
| Inventories, % | 19.68 | 12.57 | 8.2 | 5.64 | 0.000000194 | 9.22 | 9.22 | 9.22 | 9.22 | 9.22 |
| Accounts Payable | 113.3 | 122.0 | 150.2 | 132.4 | 123.8 | 124.5 | 122.0 | 119.6 | 117.2 | 114.9 |
| Accounts Payable, % | 19.53 | 22.81 | 30.84 | 26.17 | 24.06 | 24.68 | 24.68 | 24.68 | 24.68 | 24.68 |
| Capital Expenditure | -198.3 | -160.3 | -135.1 | -263.0 | -156.5 | -175.8 | -172.3 | -168.9 | -165.5 | -162.2 |
| Capital Expenditure, % | -34.16 | -29.96 | -27.76 | -51.97 | -30.4 | -34.85 | -34.85 | -34.85 | -34.85 | -34.85 |
| Tax Rate, % | -0.01266907 | -0.01266907 | -0.01266907 | -0.01266907 | -0.01266907 | -0.01266907 | -0.01266907 | -0.01266907 | -0.01266907 | -0.01266907 |
| EBITAT | -144.4 | -143.7 | -145.0 | -130.2 | -97.5 | -127.4 | -124.8 | -122.4 | -119.9 | -117.5 |
| Depreciation | ||||||||||
| Changes in Account Receivables | ||||||||||
| Changes in Inventories | ||||||||||
| Changes in Accounts Payable | ||||||||||
| Capital Expenditure | ||||||||||
| UFCF | -66.1 | 197.3 | 161.8 | -3.8 | -53.2 | 32.4 | 59.4 | 58.2 | 57.1 | 55.9 |
| WACC, % | 6.43 | 6.44 | 6.42 | 6.44 | 6.46 | 6.44 | 6.44 | 6.44 | 6.44 | 6.44 |
| PV UFCF | ||||||||||
| SUM PV UFCF | 216.6 | |||||||||
| Long Term Growth Rate, % | 4.00 | |||||||||
| Free cash flow (T + 1) | 58 | |||||||||
| Terminal Value | 2,386 | |||||||||
| Present Terminal Value | 1,746 | |||||||||
| Enterprise Value | 1,963 | |||||||||
| Net Debt | 2,104 | |||||||||
| Equity Value | -141 | |||||||||
| Diluted Shares Outstanding, MM | 172 | |||||||||
| Equity Value Per Share | -0.82 |
What You Will Get
- Editable Forecast Inputs: Effortlessly modify assumptions (growth %, margins, WACC) to explore various scenarios.
- Real-World Data: Brandywine Realty Trust’s (BDN) financial data pre-loaded to enhance your analysis.
- Automatic DCF Outputs: The template computes Net Present Value (NPV) and intrinsic value for you automatically.
- Customizable and Professional: A sleek Excel model that tailors to your valuation requirements.
- Built for Analysts and Investors: Perfect for evaluating projections, validating strategies, and optimizing efficiency.
Key Features
- Accurate Brandywine Realty Trust Financials: Access reliable pre-loaded historical data and future projections for (BDN).
- Customizable Forecast Assumptions: Modify yellow-highlighted cells such as WACC, growth rates, and margins tailored for (BDN).
- Dynamic Calculations: Automatic updates to DCF, Net Present Value (NPV), and cash flow analysis specific to (BDN).
- Visual Dashboard: User-friendly charts and summaries to effectively visualize your valuation results for (BDN).
- For Professionals and Beginners: An intuitive design crafted for investors, CFOs, and consultants focusing on (BDN).
How It Works
- 1. Access the Template: Download and open the Excel file containing Brandywine Realty Trust’s (BDN) preloaded data.
- 2. Modify Assumptions: Adjust key inputs such as growth rates, WACC, and capital expenditures.
- 3. View Results Immediately: The DCF model automatically calculates intrinsic value and NPV.
- 4. Explore Scenarios: Evaluate multiple forecasts to examine various valuation outcomes.
- 5. Utilize with Assurance: Present expert valuation insights to inform your decisions.
Why Choose This Calculator for Brandywine Realty Trust (BDN)?
- Comprehensive Tool: Offers DCF, WACC, and financial ratio analyses all in one convenient package.
- Customizable Inputs: Modify the yellow-highlighted cells to explore different scenarios.
- Detailed Insights: Automatically computes Brandywine Realty Trust’s intrinsic value and Net Present Value.
- Preloaded Data: Historical and projected data provide reliable starting points for analysis.
- Professional Quality: Perfect for financial analysts, investors, and business consultants focusing on real estate.
Who Should Use This Product?
- Investors: Accurately assess Brandywine Realty Trust’s (BDN) fair value prior to making investment choices.
- CFOs: Utilize a top-tier DCF model for financial reporting and analysis related to Brandywine Realty Trust (BDN).
- Consultants: Efficiently customize the template for valuation reports tailored to clients involving Brandywine Realty Trust (BDN).
- Entrepreneurs: Acquire knowledge on financial modeling practices employed by leading real estate companies like Brandywine Realty Trust (BDN).
- Educators: Implement it as a teaching resource to illustrate valuation techniques relevant to Brandywine Realty Trust (BDN).
What the Template Contains
- Comprehensive DCF Model: Editable template featuring detailed valuation calculations for Brandywine Realty Trust (BDN).
- Real-World Data: Historical and projected financials for Brandywine Realty Trust (BDN) preloaded for in-depth analysis.
- Customizable Parameters: Modify WACC, growth rates, and tax assumptions to explore various scenarios.
- Financial Statements: Complete annual and quarterly breakdowns for enhanced insights into Brandywine Realty Trust (BDN).
- Key Ratios: Integrated analysis for profitability, efficiency, and leverage specific to Brandywine Realty Trust (BDN).
- Dashboard with Visual Outputs: Charts and tables designed for clear and actionable results regarding Brandywine Realty Trust (BDN).