|
Inventrust Properties Corp. (IVT) Valoración de DCF
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
InvenTrust Properties Corp. (IVT) Bundle
¡Optimice su tiempo y mejore la precisión con nuestra calculadora DCF (IVT)! Equipado con datos reales de Inventrust Properties Corp. y suposiciones personalizables, esta herramienta le permite pronosticar, analizar y evaluar (IVT) 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 | 226.5 | 197.8 | 212.0 | 236.7 | 259.8 | 270.2 | 280.9 | 292.1 | 303.8 | 315.8 |
| Revenue Growth, % | 0 | -12.65 | 7.15 | 11.67 | 9.77 | 3.98 | 3.98 | 3.98 | 3.98 | 3.98 |
| EBITDA | 184.0 | 96.3 | 98.0 | 174.0 | 149.2 | 166.0 | 172.6 | 179.4 | 186.6 | 194.0 |
| EBITDA, % | 81.26 | 48.69 | 46.25 | 73.49 | 57.44 | 61.43 | 61.43 | 61.43 | 61.43 | 61.43 |
| Depreciation | 200.4 | 190.8 | 187.2 | 200.0 | 113.4 | 216.9 | 225.5 | 234.5 | 243.8 | 253.5 |
| Depreciation, % | 88.47 | 96.43 | 88.29 | 84.5 | 43.66 | 80.27 | 80.27 | 80.27 | 80.27 | 80.27 |
| EBIT | -16.3 | -94.4 | -89.1 | -26.1 | 35.8 | -50.9 | -52.9 | -55.0 | -57.2 | -59.5 |
| EBIT, % | -7.21 | -47.74 | -42.04 | -11.01 | 13.78 | -18.84 | -18.84 | -18.84 | -18.84 | -18.84 |
| Total Cash | 255.1 | 222.6 | 44.9 | 137.8 | 99.8 | 171.7 | 178.5 | 185.6 | 193.0 | 200.7 |
| Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
| Account Receivables | 30.2 | 29.0 | 30.1 | 34.5 | 35.4 | 38.0 | 39.5 | 41.1 | 42.7 | 44.4 |
| Account Receivables, % | 13.33 | 14.65 | 14.18 | 14.59 | 13.61 | 14.07 | 14.07 | 14.07 | 14.07 | 14.07 |
| Inventories | 296.6 | 253.9 | 75.1 | -.1 | .0 | 127.2 | 132.3 | 137.5 | 143.0 | 148.7 |
| Inventories, % | 130.96 | 128.35 | 35.44 | -0.05998978 | 0 | 47.08 | 47.08 | 47.08 | 47.08 | 47.08 |
| Accounts Payable | 29.8 | 28.3 | 36.2 | 42.8 | 44.6 | 43.1 | 44.8 | 46.6 | 48.5 | 50.4 |
| Accounts Payable, % | 13.16 | 14.3 | 17.08 | 18.08 | 17.16 | 15.95 | 15.95 | 15.95 | 15.95 | 15.95 |
| Capital Expenditure | -53.0 | -18.7 | -19.4 | -23.7 | -27.3 | -33.8 | -35.1 | -36.5 | -38.0 | -39.5 |
| Capital Expenditure, % | -23.39 | -9.44 | -9.16 | -10.02 | -10.51 | -12.5 | -12.5 | -12.5 | -12.5 | -12.5 |
| Tax Rate, % | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
| EBITAT | -16.1 | -335.7 | -475.9 | -12.7 | 35.8 | -45.5 | -47.3 | -49.2 | -51.2 | -53.2 |
| Depreciation | ||||||||||
| Changes in Account Receivables | ||||||||||
| Changes in Inventories | ||||||||||
| Changes in Accounts Payable | ||||||||||
| Capital Expenditure | ||||||||||
| UFCF | -165.7 | -121.2 | -122.6 | 241.0 | 122.8 | 6.2 | 138.2 | 143.7 | 149.4 | 155.4 |
| WACC, % | 5.17 | 5.19 | 5.19 | 4.5 | 5.19 | 5.05 | 5.05 | 5.05 | 5.05 | 5.05 |
| PV UFCF | ||||||||||
| SUM PV UFCF | 499.3 | |||||||||
| Long Term Growth Rate, % | 4.00 | |||||||||
| Free cash flow (T + 1) | 162 | |||||||||
| Terminal Value | 15,447 | |||||||||
| Present Terminal Value | 12,077 | |||||||||
| Enterprise Value | 12,576 | |||||||||
| Net Debt | 718 | |||||||||
| Equity Value | 11,858 | |||||||||
| Diluted Shares Outstanding, MM | 68 | |||||||||
| Equity Value Per Share | 174.86 |
What You Will Get
- Real IVT 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: Evaluate various scenarios to assess InvenTrust's future performance.
- User-Friendly Design: Designed for professionals while remaining approachable for newcomers.
Key Features
- Comprehensive InvenTrust Financials: Gain access to precise pre-loaded historical data and future forecasts.
- Adjustable Forecast Parameters: Modify yellow-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.
- User-Friendly Dashboard: Clear and concise charts and summaries to help visualize your valuation outcomes.
- Designed for All Skill Levels: An intuitive layout tailored for investors, CFOs, and consultants alike.
How It Works
- Download: Obtain the ready-to-use Excel file containing InvenTrust Properties Corp.'s (IVT) financial data.
- Customize: Modify forecasts such as rental income growth, operating margins, and discount rates.
- Update Automatically: The intrinsic value and NPV calculations refresh in real-time.
- Test Scenarios: Develop various projections and evaluate results immediately.
- Make Decisions: Leverage the valuation outcomes to inform your investment approach.
Why Choose This Calculator for InvenTrust Properties Corp. (IVT)?
- Accurate Data: Utilize real InvenTrust financials for dependable valuation outcomes.
- Customizable: Modify essential parameters such as growth rates, WACC, and tax rates to fit your forecasts.
- Time-Saving: Pre-configured calculations save you the hassle of starting from the ground up.
- Professional-Grade Tool: Tailored for investors, analysts, and consultants in the real estate sector.
- User-Friendly: Easy-to-navigate layout and clear instructions ensure accessibility for all users.
Who Should Use This Product?
- Individual Investors: Gain insights to make informed decisions regarding InvenTrust Properties Corp. (IVT) stock transactions.
- Financial Analysts: Enhance valuation methodologies with comprehensive financial models tailored for real estate investments.
- Consultants: Provide clients with timely and precise valuation assessments for properties under InvenTrust Properties Corp. (IVT).
- Real Estate Developers: Learn how large real estate investment trusts like InvenTrust Properties Corp. (IVT) determine their market value to inform your development strategies.
- Finance Students: Explore valuation principles using practical examples and data from InvenTrust Properties Corp. (IVT).
What the Template Contains
- Pre-Filled Data: Contains InvenTrust Properties Corp.'s (IVT) historical financials and forecasts.
- Discounted Cash Flow Model: Editable DCF valuation model with automatic calculations tailored for (IVT).
- Weighted Average Cost of Capital (WACC): A dedicated sheet for calculating WACC based on custom inputs for (IVT).
- Key Financial Ratios: Analyze InvenTrust Properties Corp.'s (IVT) profitability, efficiency, and leverage.
- Customizable Inputs: Easily edit revenue growth, margins, and tax rates for (IVT).
- Clear Dashboard: Visual representations of charts and tables summarizing key valuation results for (IVT).