Federal Realty Investment Trust (FRT) 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
Federal Realty Investment Trust (FRT) Bundle
Engineered for accuracy, our (FRT) DCF Calculator allows you to evaluate the valuation of Federal Realty Investment Trust using real-world financial data and provides complete flexibility to modify all key 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 | 935.8 | 835.5 | 951.2 | 1,074.4 | 1,132.2 | 1,192.9 | 1,256.9 | 1,324.3 | 1,395.4 | 1,470.2 |
| Revenue Growth, % | 0 | -10.72 | 13.85 | 12.95 | 5.38 | 5.36 | 5.36 | 5.36 | 5.36 | 5.36 |
| EBITDA | 710.7 | 544.6 | 674.7 | 828.8 | 728.2 | 843.4 | 888.7 | 936.3 | 986.6 | 1,039.5 |
| EBITDA, % | 75.94 | 65.18 | 70.93 | 77.14 | 64.32 | 70.7 | 70.7 | 70.7 | 70.7 | 70.7 |
| Depreciation | 557.9 | 562.0 | 646.2 | 711.6 | 321.8 | 690.6 | 727.6 | 766.7 | 807.8 | 851.1 |
| Depreciation, % | 59.62 | 67.27 | 67.93 | 66.23 | 28.42 | 57.89 | 57.89 | 57.89 | 57.89 | 57.89 |
| EBIT | 152.8 | -17.5 | 28.5 | 117.3 | 406.5 | 152.8 | 161.0 | 169.7 | 178.8 | 188.3 |
| EBIT, % | 16.33 | -2.09 | 3 | 10.91 | 35.9 | 12.81 | 12.81 | 12.81 | 12.81 | 12.81 |
| Total Cash | 127.4 | 798.3 | 162.1 | 85.6 | 250.8 | 373.0 | 393.0 | 414.1 | 436.3 | 459.7 |
| Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
| Account Receivables | 183.0 | 199.7 | 178.6 | 207.1 | 210.9 | 238.9 | 251.7 | 265.2 | 279.4 | 294.4 |
| Account Receivables, % | 19.56 | 23.9 | 18.77 | 19.28 | 18.63 | 20.03 | 20.03 | 20.03 | 20.03 | 20.03 |
| Inventories | -.1 | 4.7 | .0 | -267.4 | .0 | -58.1 | -61.2 | -64.5 | -67.9 | -71.6 |
| Inventories, % | -0.01389204 | 0.56386 | 0 | -24.89 | 0 | -4.87 | -4.87 | -4.87 | -4.87 | -4.87 |
| Accounts Payable | 255.5 | 228.6 | 235.2 | 190.3 | 171.2 | 267.8 | 282.1 | 297.3 | 313.2 | 330.0 |
| Accounts Payable, % | 27.3 | 27.37 | 24.72 | 17.72 | 15.12 | 22.45 | 22.45 | 22.45 | 22.45 | 22.45 |
| Capital Expenditure | -409.9 | -501.9 | -440.5 | -416.7 | -311.1 | -516.4 | -544.1 | -573.3 | -604.1 | -636.5 |
| Capital Expenditure, % | -43.8 | -60.08 | -46.31 | -38.79 | -27.48 | -43.29 | -43.29 | -43.29 | -43.29 | -43.29 |
| Tax Rate, % | 4.14 | 4.14 | 4.14 | 4.14 | 4.14 | 4.14 | 4.14 | 4.14 | 4.14 | 4.14 |
| EBITAT | 104.4 | -.4 | 14.1 | 75.5 | 389.6 | 85.7 | 90.3 | 95.1 | 100.2 | 105.6 |
| Depreciation | ||||||||||
| Changes in Account Receivables | ||||||||||
| Changes in Inventories | ||||||||||
| Changes in Accounts Payable | ||||||||||
| Capital Expenditure | ||||||||||
| UFCF | 325.0 | 11.3 | 252.1 | 564.4 | 109.9 | 386.5 | 278.5 | 293.4 | 309.2 | 325.7 |
| WACC, % | 7.88 | 6.88 | 7.59 | 7.82 | 8.3 | 7.7 | 7.7 | 7.7 | 7.7 | 7.7 |
| PV UFCF | ||||||||||
| SUM PV UFCF | 1,288.5 | |||||||||
| Long Term Growth Rate, % | 4.00 | |||||||||
| Free cash flow (T + 1) | 339 | |||||||||
| Terminal Value | 9,164 | |||||||||
| Present Terminal Value | 6,325 | |||||||||
| Enterprise Value | 7,614 | |||||||||
| Net Debt | 4,437 | |||||||||
| Equity Value | 3,177 | |||||||||
| Diluted Shares Outstanding, MM | 81 | |||||||||
| Equity Value Per Share | 39.07 |
What You Will Get
- Editable Forecast Inputs: Easily modify assumptions (growth %, margins, WACC) to explore various scenarios.
- Real-World Data: Federal Realty Investment Trust’s (FRT) financial information pre-filled to accelerate your analysis.
- Automatic DCF Outputs: The template computes Net Present Value (NPV) and intrinsic value automatically.
- Customizable and Professional: A refined Excel model that adjusts to your valuation requirements.
- Built for Analysts and Investors: Perfect for evaluating projections, confirming strategies, and enhancing efficiency.
Key Features
- 🔍 Real-Life FRT Financials: Pre-filled historical and projected data for Federal Realty Investment Trust (FRT).
- ✏️ Fully Customizable Inputs: Adjust all critical parameters (yellow cells) like WACC, growth %, and tax rates.
- 📊 Professional DCF Valuation: Built-in formulas calculate Federal Realty Investment Trust’s intrinsic value using the Discounted Cash Flow method.
- ⚡ Instant Results: Visualize Federal Realty Investment Trust’s valuation instantly after making changes.
- Scenario Analysis: Test and compare outcomes for various financial assumptions side-by-side.
How It Works
- 1. Access the Template: Download and open the Excel file featuring Federal Realty Investment Trust's (FRT) preloaded data.
- 2. Adjust Key Inputs: Modify essential parameters such as growth rates, WACC, and capital expenditures.
- 3. Get Immediate Results: The DCF model automatically computes intrinsic value and NPV in real-time.
- 4. Explore Different Scenarios: Evaluate various forecasts to investigate potential valuation results.
- 5. Present with Assurance: Deliver expert valuation insights to back your investment decisions.
Why Choose This Calculator for Federal Realty Investment Trust (FRT)?
- Designed for Investors: A specialized tool tailored for real estate analysts, portfolio managers, and investors.
- Comprehensive Data: Federal Realty’s historical and projected financials are preloaded for precise analysis.
- Flexible Scenario Analysis: Effortlessly test various market conditions and investment strategies.
- Insightful Outputs: Automatically computes intrinsic value, NPV, and other vital metrics.
- User-Friendly: Detailed instructions lead you seamlessly through each step of the calculation.
Who Should Use Federal Realty Investment Trust (FRT)?
- Real Estate Investors: Leverage insights from a trusted REIT to make informed investment choices.
- Portfolio Managers: Enhance your portfolio with reliable data and performance metrics from Federal Realty.
- Market Analysts: Utilize comprehensive reports to analyze market trends and property valuations.
- Real Estate Enthusiasts: Expand your knowledge of real estate investment strategies through practical examples.
- Students and Educators: Incorporate real-world case studies into finance and real estate curricula.
What the Template Contains
- Comprehensive DCF Model: Editable template with detailed valuation calculations tailored for Federal Realty Investment Trust (FRT).
- Real-World Data: Federal Realty Investment Trust’s (FRT) historical and projected financials preloaded for analysis.
- Customizable Parameters: Adjust WACC, growth rates, and tax assumptions to test various scenarios for Federal Realty Investment Trust (FRT).
- Financial Statements: Full annual and quarterly breakdowns for deeper insights into Federal Realty Investment Trust (FRT).
- Key Ratios: Built-in analysis for profitability, efficiency, and leverage specific to Federal Realty Investment Trust (FRT).
- Dashboard with Visual Outputs: Charts and tables for clear, actionable results related to Federal Realty Investment Trust (FRT).