Data Inputs
- User-friendly spreadsheet input environment allowing you to create custom formulas or links to other worksheets.
- 10, 20, 30 or 40-year monthly and financial year cash flows with variable acquisition and disposal dates.
- Analyse up to 500 tenants for a property, with variables such as:
- Outgoings and Recoverables
- Turnover Rents and Thresholds
- Lease Incentives
- Lease Terms, Options and Option Probabilities
- Termination and Reletting
- Rental Escalation and Market Reviews
- Long Term Vacancy Allowances
- Multiple options for rent reviews such as CPI, market rent, fixed percentages or a fixed amount.
- Multiple capitalisation rates that can be applied for each type of use in the property.
- Up to 20 different escalation profiles that can be applied throughout the model to rental income, turnover, market rent and outgoings.
- Track Outgoings against industry benchmarks.
- Report Capital Expenses over the life of the investment.
Reporting
- Detailed Executive Summary report showing:
- Property valuation summary
- Profiles on the Major Tenancies and Uses
- Weighted Lease Durations
- Sensitivity Analysis tables on Capitalisation Rate, Discount Rate and Terminal Capitalisation Rate
- Performance Indicators such as Yields, NPV and IRR
- Summary of Annual Allowances
- Capitalisation Summary report with valuations based on:
- Passing Income
- Current Income Fully Leased
- Net Market Income
- Reversionary Market Income
- Dynamic DCF Report that can be configured by the user to display:
- Monthly or Financial Year Cash Flows
- Base Rents, Recoveries and Gross Income by individual tenant or grouped by sub totals
- Running Sale Price, Yield and IRR
- Informative Tenancy Charts that display:
- Top 5 Tenants by Income or Net Lettable Area
- Top 3 Uses by Income or Net Lettable Area
- Yearly Lease Expiry Profile
- Rental Escalation and CPI comparisons
- Outgoings comparisons
Investment Analysis
- Investment Analysis functionality to allow the user to calculate:
- Debt and Equity funding for acquisition
- Interest rate cover
- Loan to value ratios
- Fund management fees
- Working capital requirements
- Distributions to Investors
For a printable version of our Key Features, please download our Datasheet