|
Valoración DCF de Kite Realty Group Trust (KRG)
US | Real Estate | REIT - Retail | 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
Kite Realty Group Trust (KRG) Bundle
¡Agilice su análisis y mejore la precisión con nuestra calculadora DCF (KRG)! Utilizando datos reales de Kite Realty Group Trust y permitiendo suposiciones ajustables, esta herramienta le permite pronosticar, evaluar y evaluar (KRG) al igual que un inversor experto.
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 | 315.2 | 266.6 | 373.3 | 802.0 | 823.0 | 1,084.8 | 1,429.8 | 1,884.6 | 2,484.1 | 3,274.2 |
| Revenue Growth, % | 0 | -15.4 | 40.01 | 114.83 | 2.62 | 31.81 | 31.81 | 31.81 | 31.81 | 31.81 |
| EBITDA | 193.8 | 164.4 | 178.9 | 535.8 | 556.5 | 662.8 | 873.6 | 1,151.5 | 1,517.8 | 2,000.5 |
| EBITDA, % | 61.5 | 61.64 | 47.93 | 66.81 | 67.62 | 61.1 | 61.1 | 61.1 | 61.1 | 61.1 |
| Depreciation | 244.7 | 249.6 | 341.7 | 743.1 | 426.4 | 883.5 | 1,164.5 | 1,535.0 | 2,023.2 | 2,666.7 |
| Depreciation, % | 77.63 | 93.62 | 91.53 | 92.65 | 51.81 | 81.45 | 81.45 | 81.45 | 81.45 | 81.45 |
| EBIT | -50.8 | -85.3 | -162.8 | -207.2 | 130.1 | -220.7 | -290.9 | -383.5 | -505.4 | -666.2 |
| EBIT, % | -16.12 | -31.98 | -43.6 | -25.84 | 15.81 | -20.35 | -20.35 | -20.35 | -20.35 | -20.35 |
| Total Cash | 31.3 | 43.6 | 218.2 | 115.8 | 36.4 | 224.8 | 296.4 | 390.6 | 514.9 | 678.6 |
| Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
| Account Receivables | 55.3 | 57.2 | 68.4 | 101.3 | 113.3 | 181.6 | 239.4 | 315.5 | 415.9 | 548.1 |
| Account Receivables, % | 17.54 | 21.43 | 18.33 | 12.63 | 13.77 | 16.74 | 16.74 | 16.74 | 16.74 | 16.74 |
| Inventories | .0 | 121.9 | -.3 | -35.1 | .0 | 89.5 | 117.9 | 155.5 | 204.9 | 270.1 |
| Inventories, % | 0.000000317 | 45.7 | -0.08009102 | -4.38 | 0 | 8.25 | 8.25 | 8.25 | 8.25 | 8.25 |
| Accounts Payable | 72.1 | 79.4 | 195.8 | 219.9 | 207.3 | 342.1 | 451.0 | 594.4 | 783.5 | 1,032.7 |
| Accounts Payable, % | 22.87 | 29.78 | 52.44 | 27.42 | 25.19 | 31.54 | 31.54 | 31.54 | 31.54 | 31.54 |
| Capital Expenditure | -53.3 | -38.3 | -57.3 | -158.5 | -142.6 | -181.6 | -239.4 | -315.5 | -415.8 | -548.1 |
| Capital Expenditure, % | -16.9 | -14.35 | -15.35 | -19.77 | -17.32 | -16.74 | -16.74 | -16.74 | -16.74 | -16.74 |
| Tax Rate, % | 2.9 | 2.9 | 2.9 | 2.9 | 2.9 | 2.9 | 2.9 | 2.9 | 2.9 | 2.9 |
| EBITAT | -95.6 | -81.7 | -162.2 | -208.0 | 126.3 | -217.4 | -286.6 | -377.8 | -497.9 | -656.3 |
| Depreciation | ||||||||||
| Changes in Account Receivables | ||||||||||
| Changes in Inventories | ||||||||||
| Changes in Accounts Payable | ||||||||||
| Capital Expenditure | ||||||||||
| UFCF | 112.6 | 13.2 | 349.5 | 402.7 | 350.4 | 461.5 | 661.2 | 871.5 | 1,148.7 | 1,514.1 |
| WACC, % | 8.41 | 8.35 | 8.41 | 8.41 | 8.37 | 8.39 | 8.39 | 8.39 | 8.39 | 8.39 |
| PV UFCF | ||||||||||
| SUM PV UFCF | 3,517.3 | |||||||||
| Long Term Growth Rate, % | 2.00 | |||||||||
| Free cash flow (T + 1) | 1,544 | |||||||||
| Terminal Value | 24,171 | |||||||||
| Present Terminal Value | 16,157 | |||||||||
| Enterprise Value | 19,674 | |||||||||
| Net Debt | 3,021 | |||||||||
| Equity Value | 16,653 | |||||||||
| Diluted Shares Outstanding, MM | 220 | |||||||||
| Equity Value Per Share | 75.79 |
What You Will Get
- Real KRG Financials: Access to historical and projected data for precise valuation.
- Customizable Inputs: Adjust WACC, tax rates, revenue growth, and capital expenditures as needed.
- Dynamic Calculations: Intrinsic value and NPV are computed in real-time.
- Scenario Analysis: Explore various scenarios to assess Kite Realty Group's future prospects.
- User-Friendly Interface: Designed for industry professionals while remaining approachable for newcomers.
Key Features
- 🔍 Real-Life KRG Financials: Pre-filled historical and projected data for Kite Realty Group Trust (KRG).
- ✏️ Fully Customizable Inputs: Adjust all critical parameters (yellow cells) like WACC, growth %, and tax rates.
- 📊 Professional DCF Valuation: Built-in formulas calculate Kite Realty's intrinsic value using the Discounted Cash Flow method.
- ⚡ Instant Results: Visualize Kite Realty'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 prebuilt Excel template featuring Kite Realty Group Trust’s (KRG) data.
- Step 2: Navigate through the pre-filled sheets to familiarize yourself with the essential metrics.
- Step 3: Modify forecasts and assumptions in the editable yellow cells (WACC, growth, margins).
- Step 4: Instantly see the recalculated results, including Kite Realty Group Trust’s (KRG) intrinsic value.
- Step 5: Utilize the outputs to make informed investment choices or create detailed reports.
Why Choose Kite Realty Group Trust (KRG)?
- Save Time: Utilize our streamlined resources without the hassle of starting from scratch.
- Enhance Accuracy: Dependable financial insights and calculations minimize valuation errors.
- Fully Customizable: Adjust the model to align with your unique assumptions and forecasts.
- Easy to Analyze: Intuitive charts and outputs simplify the interpretation of results.
- Endorsed by Professionals: Crafted for experts who prioritize precision and functionality.
Who Should Use This Product?
- Real Estate Investors: Develop comprehensive valuation models for assessing property investments.
- Corporate Finance Teams: Evaluate valuation scenarios to inform strategic decisions within the organization.
- Consultants and Advisors: Deliver precise valuation insights for Kite Realty Group Trust (KRG) to clients.
- Students and Educators: Utilize real-world data to enhance learning and practice in financial modeling.
- Market Analysts: Gain insights into how real estate investment trusts (REITs) like Kite Realty Group Trust (KRG) are valued in the market.
What the Template Contains
- Pre-Filled Data: Includes Kite Realty Group Trust’s (KRG) historical financials and forecasts.
- Discounted Cash Flow Model: Editable DCF valuation model with automatic calculations.
- Weighted Average Cost of Capital (WACC): A dedicated sheet for calculating WACC based on custom inputs.
- Key Financial Ratios: Analyze Kite Realty Group Trust’s (KRG) profitability, efficiency, and leverage.
- Customizable Inputs: Edit revenue growth, margins, and tax rates with ease.
- Clear Dashboard: Charts and tables summarizing key valuation results.