Brandywine Realty Trust (BDN) 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
Brandywine Realty Trust (BDN) Bundle
Engineered for accuracy, our (BDN) DCF Calculator allows you to assess Brandywine Realty Trust's valuation using actual financial data and provides complete flexibility to modify essential parameters for improved projections.
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).