|
Independence Realty Trust, Inc. (IRT) Valoración de DCF
US | Real Estate | REIT - Residential | 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
Independence Realty Trust, Inc. (IRT) Bundle
¿Busca evaluar el valor intrínseco de Independence Realty Trust, Inc.? Nuestra calculadora DCF (IRT) integra datos del mundo real con extensas características de personalización, lo que le permite ajustar los pronósticos y mejorar sus estrategias de inversión.
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 | 203.2 | 211.9 | 250.3 | 628.5 | 661.0 | 685.8 | 711.6 | 738.4 | 766.1 | 794.9 |
Revenue Growth, % | 0 | 4.27 | 18.1 | 151.16 | 5.16 | 3.76 | 3.76 | 3.76 | 3.76 | 3.76 |
EBITDA | 52.8 | 105.2 | 220.9 | 345.3 | 291.1 | 360.6 | 374.1 | 388.2 | 402.8 | 418.0 |
EBITDA, % | 25.99 | 49.65 | 88.26 | 54.95 | 44.04 | 52.58 | 52.58 | 52.58 | 52.58 | 52.58 |
Depreciation | 155.2 | 171.6 | 201.2 | 538.2 | 219.0 | 489.0 | 507.3 | 526.4 | 546.2 | 566.7 |
Depreciation, % | 76.37 | 80.96 | 80.39 | 85.62 | 33.13 | 71.29 | 71.29 | 71.29 | 71.29 | 71.29 |
EBIT | -102.4 | -66.4 | 19.7 | -192.8 | 72.1 | -128.4 | -133.2 | -138.2 | -143.4 | -148.8 |
EBIT, % | -50.38 | -31.31 | 7.88 | -30.68 | 10.91 | -18.72 | -18.72 | -18.72 | -18.72 | -18.72 |
Total Cash | 9.9 | 8.8 | 36.0 | 16.1 | 22.9 | 40.3 | 41.8 | 43.4 | 45.0 | 46.7 |
Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
Account Receivables | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
Account Receivables, % | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
Inventories | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
Inventories, % | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
Accounts Payable | 25.4 | 25.4 | 106.3 | 109.7 | 109.1 | 138.4 | 143.7 | 149.1 | 154.7 | 160.5 |
Accounts Payable, % | 12.5 | 11.99 | 42.49 | 17.45 | 16.5 | 20.19 | 20.19 | 20.19 | 20.19 | 20.19 |
Capital Expenditure | -45.6 | -37.4 | -43.0 | -84.0 | -146.6 | -127.3 | -132.1 | -137.1 | -142.2 | -147.6 |
Capital Expenditure, % | -22.45 | -17.65 | -17.17 | -13.36 | -22.18 | -18.56 | -18.56 | -18.56 | -18.56 | -18.56 |
Tax Rate, % | 3.26 | 3.26 | 3.26 | 3.26 | 3.26 | 3.26 | 3.26 | 3.26 | 3.26 | 3.26 |
EBITAT | -14.7 | 96.3 | 3.5 | -53.9 | 69.8 | -40.3 | -41.8 | -43.4 | -45.0 | -46.7 |
Depreciation | ||||||||||
Changes in Account Receivables | ||||||||||
Changes in Inventories | ||||||||||
Changes in Accounts Payable | ||||||||||
Capital Expenditure | ||||||||||
UFCF | 120.2 | 230.5 | 242.7 | 403.7 | 141.5 | 350.7 | 338.6 | 351.3 | 364.6 | 378.3 |
WACC, % | 6.65 | 6.43 | 6.71 | 6.87 | 7.94 | 6.92 | 6.92 | 6.92 | 6.92 | 6.92 |
PV UFCF | ||||||||||
SUM PV UFCF | 1,461.3 | |||||||||
Long Term Growth Rate, % | 4.00 | |||||||||
Free cash flow (T + 1) | 393 | |||||||||
Terminal Value | 13,470 | |||||||||
Present Terminal Value | 9,640 | |||||||||
Enterprise Value | 11,101 | |||||||||
Net Debt | 2,379 | |||||||||
Equity Value | 8,723 | |||||||||
Diluted Shares Outstanding, MM | 224 | |||||||||
Equity Value Per Share | 38.87 |
What You Will Get
- Editable Excel Template: A fully customizable Excel-based DCF Calculator featuring pre-filled real IRT financials.
- Real-World Data: Historical data and forward-looking estimates (highlighted in the yellow cells).
- Forecast Flexibility: Adjust forecast assumptions such as revenue growth, EBITDA %, and WACC.
- Automatic Calculations: Instantly observe the effects of your inputs on Independence Realty Trust’s valuation.
- Professional Tool: Designed for investors, CFOs, consultants, and financial analysts.
- User-Friendly Design: Organized for clarity and ease of use, complete with step-by-step instructions.
Key Features
- Customizable Financial Metrics: Adjust essential inputs such as rental income growth, occupancy rates, and operating expenses.
- Instant DCF Valuation: Automatically computes intrinsic value, NPV, and other financial outputs in real-time.
- High Precision Results: Leverages Independence Realty Trust’s (IRT) actual financial data for accurate valuation insights.
- Streamlined Scenario Testing: Easily evaluate various assumptions and analyze results side by side.
- Efficiency Booster: Avoid the hassle of constructing intricate valuation models from the ground up.
How It Works
- Step 1: Download the Excel file.
- Step 2: Review pre-entered Independence Realty Trust, Inc. (IRT) data (historical and projected).
- Step 3: Adjust key assumptions (yellow cells) based on your analysis.
- Step 4: View automatic recalculations for Independence Realty Trust, Inc. (IRT)’s intrinsic value.
- Step 5: Use the outputs for investment decisions or reporting.
Why Choose This Calculator for Independence Realty Trust, Inc. (IRT)?
- User-Friendly Interface: Tailored for both novice and seasoned investors.
- Customizable Inputs: Adjust parameters easily to suit your investment analysis.
- Real-Time Valuation: Observe immediate updates to IRT’s valuation as you change inputs.
- Pre-Loaded Data: Comes with IRT’s actual financial metrics for swift evaluations.
- Endorsed by Experts: Utilized by analysts and investors for strategic decision-making.
Who Should Use This Product?
- Investors: Accurately assess Independence Realty Trust, Inc.'s (IRT) fair value prior to making investment choices.
- CFOs: Utilize a high-quality DCF model for financial reporting and analysis specific to IRT.
- Consultants: Efficiently modify the template for valuation reports tailored to IRT clients.
- Entrepreneurs: Discover financial modeling insights employed by leading real estate investment trusts.
- Educators: Implement it as a teaching resource to illustrate valuation techniques in real estate.
What the Template Contains
- Historical Data: Includes Independence Realty Trust, Inc. (IRT)’s past financials and baseline forecasts.
- DCF and Levered DCF Models: Detailed templates to calculate Independence Realty Trust, Inc. (IRT)’s 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 Independence Realty Trust, Inc. (IRT)’s financials.
- Interactive Dashboard: Visualize valuation results and projections dynamically.