Independence Realty Trust, Inc. (IRT) DCF Valuation
- ✓ 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
Looking to assess the intrinsic value of Independence Realty Trust, Inc.? Our (IRT) DCF Calculator integrates real-world data with extensive customization features, allowing you to adjust forecasts and enhance your investment strategies.
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.