|
Valoración de DCF Properties Urban Edge (UE)
US | Real Estate | REIT - Diversified | 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
Urban Edge Properties (UE) Bundle
¡Agilice su análisis y mejore la precisión con nuestra calculadora DCF (UE)! Equipado con datos reales de propiedades del borde urbano y suposiciones personalizables, esta herramienta le permite pronosticar, analizar y valorar las propiedades del borde urbano como un inversor experimentado.
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 | 387.6 | 330.1 | 425.1 | 397.9 | 416.9 | 429.8 | 443.0 | 456.6 | 470.7 | 485.2 |
| Revenue Growth, % | 0 | -14.85 | 28.78 | -6.39 | 4.77 | 3.08 | 3.08 | 3.08 | 3.08 | 3.08 |
| EBITDA | 220.5 | 154.2 | 256.2 | 204.2 | 457.5 | 270.9 | 279.2 | 287.8 | 296.7 | 305.8 |
| EBITDA, % | 56.88 | 46.7 | 60.28 | 51.32 | 109.73 | 63.04 | 63.04 | 63.04 | 63.04 | 63.04 |
| Depreciation | 283.8 | 277.6 | 276.7 | 290.2 | 101.2 | 274.7 | 283.1 | 291.9 | 300.8 | 310.1 |
| Depreciation, % | 73.21 | 84.1 | 65.1 | 72.92 | 24.26 | 63.92 | 63.92 | 63.92 | 63.92 | 63.92 |
| EBIT | -63.3 | -123.4 | -20.5 | -85.9 | 356.3 | 4.6 | 4.7 | 4.9 | 5.0 | 5.2 |
| EBIT, % | -16.33 | -37.39 | -4.82 | -21.6 | 85.46 | 1.06 | 1.06 | 1.06 | 1.06 | 1.06 |
| Total Cash | 433.0 | 384.6 | 164.5 | 85.5 | 101.1 | 244.5 | 252.0 | 259.8 | 267.8 | 276.0 |
| Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
| Account Receivables | 95.4 | 77.8 | 78.5 | 82.2 | 75.5 | 90.6 | 93.4 | 96.3 | 99.2 | 102.3 |
| Account Receivables, % | 24.62 | 23.56 | 18.47 | 20.67 | 18.11 | 21.08 | 21.08 | 21.08 | 21.08 | 21.08 |
| Inventories | 6.6 | 7.1 | .0 | 43.3 | .0 | 12.6 | 13.0 | 13.4 | 13.8 | 14.3 |
| Inventories, % | 1.7 | 2.14 | 0.000000235 | 10.87 | 0 | 2.94 | 2.94 | 2.94 | 2.94 | 2.94 |
| Accounts Payable | 13.0 | .0 | 8.1 | 102.5 | 14.2 | 29.6 | 30.5 | 31.4 | 32.4 | 33.4 |
| Accounts Payable, % | 3.36 | 0 | 1.9 | 25.76 | 3.42 | 6.89 | 6.89 | 6.89 | 6.89 | 6.89 |
| Capital Expenditure | -91.3 | -28.5 | -95.4 | -116.0 | .0 | -72.0 | -74.2 | -76.5 | -78.9 | -81.3 |
| Capital Expenditure, % | -23.55 | -8.64 | -22.44 | -29.16 | 0 | -16.76 | -16.76 | -16.76 | -16.76 | -16.76 |
| Tax Rate, % | 10.58 | 10.58 | 10.58 | 10.58 | 10.58 | 10.58 | 10.58 | 10.58 | 10.58 | 10.58 |
| EBITAT | -59.0 | -196.6 | -19.3 | -79.0 | 318.6 | 4.3 | 4.4 | 4.6 | 4.7 | 4.8 |
| Depreciation | ||||||||||
| Changes in Account Receivables | ||||||||||
| Changes in Inventories | ||||||||||
| Changes in Accounts Payable | ||||||||||
| Capital Expenditure | ||||||||||
| UFCF | 44.5 | 56.6 | 176.4 | 142.6 | 381.5 | 194.5 | 211.1 | 217.6 | 224.3 | 231.2 |
| WACC, % | 8.61 | 8.74 | 8.63 | 8.59 | 8.54 | 8.62 | 8.62 | 8.62 | 8.62 | 8.62 |
| PV UFCF | ||||||||||
| SUM PV UFCF | 841.7 | |||||||||
| Long Term Growth Rate, % | 3.50 | |||||||||
| Free cash flow (T + 1) | 239 | |||||||||
| Terminal Value | 4,670 | |||||||||
| Present Terminal Value | 3,088 | |||||||||
| Enterprise Value | 3,930 | |||||||||
| Net Debt | 1,687 | |||||||||
| Equity Value | 2,243 | |||||||||
| Diluted Shares Outstanding, MM | 118 | |||||||||
| Equity Value Per Share | 19.08 |
What You Will Get
- Real UE Financial Data: Pre-filled with Urban Edge Properties’ historical and projected data for precise analysis.
- Fully Editable Template: Modify key inputs like revenue growth, WACC, and EBITDA % with ease.
- Automatic Calculations: See Urban Edge Properties’ intrinsic value update instantly based on your changes.
- Professional Valuation Tool: Designed for investors, analysts, and consultants seeking accurate DCF results.
- User-Friendly Design: Simple structure and clear instructions for all experience levels.
Key Features
- Accurate Urban Edge Financials: Gain access to reliable pre-loaded historical data and future forecasts.
- Tailored Forecast Assumptions: Modify highlighted cells such as WACC, growth rates, and profit margins.
- Real-Time Calculations: Automatic updates for DCF, Net Present Value (NPV), and cash flow assessments.
- Interactive Dashboard: User-friendly charts and summaries to clearly present your valuation findings.
- Suitable for All Levels: A straightforward, intuitive layout designed for investors, CFOs, and consultants alike.
How It Works
- Download the Template: Gain immediate access to the Excel-based UE DCF Calculator.
- Input Your Assumptions: Modify the yellow-highlighted cells for growth rates, WACC, margins, and other variables.
- Instant Calculations: The model will automatically refresh Urban Edge Properties’ intrinsic value.
- Test Scenarios: Explore various assumptions to assess potential changes in valuation.
- Analyze and Decide: Utilize the outcomes to inform your investment or financial analysis.
Why Choose This Calculator for Urban Edge Properties (UE)?
- User-Friendly Interface: Tailored for both novices and seasoned professionals.
- Customizable Inputs: Adjust parameters easily to suit your financial analysis.
- Real-Time Feedback: Observe immediate changes in Urban Edge Properties' valuation with input modifications.
- Pre-Configured Data: Comes with Urban Edge Properties' actual financial metrics for swift evaluations.
- Relied Upon by Experts: Favored by investors and analysts for making educated investment choices.
Who Should Use This Product?
- Investors: Evaluate Urban Edge Properties’ (UE) market position before making investment decisions.
- CFOs and Financial Analysts: Enhance valuation methodologies and validate financial forecasts for Urban Edge Properties (UE).
- Real Estate Developers: Understand the valuation strategies of established real estate firms like Urban Edge Properties (UE).
- Consultants: Provide comprehensive valuation analyses and reports for clients in the real estate sector.
- Students and Educators: Utilize current market data to learn and teach real estate valuation principles.
What the Template Contains
- Historical Data: Includes Urban Edge Properties’ (UE) past financials and baseline forecasts.
- DCF and Levered DCF Models: Detailed templates to calculate Urban Edge Properties’ (UE) intrinsic value.
- WACC Sheet: Pre-built calculations for Weighted Average Cost of Capital.
- Editable Inputs: Modify key drivers like growth rates, EBITDA %, and CAPEX assumptions.
- Quarterly and Annual Statements: A complete breakdown of Urban Edge Properties’ (UE) financials.
- Interactive Dashboard: Visualize valuation results and projections dynamically.