Real Estate Budget & Forecast

[#1]

Lionpoint Group’s Real Estate Budget & Forecast Model takes a feed of tenancy/rent roll data from source systems, adds your assumptions (on inflation, rental value growth, void periods/downtime, future lease lengths, incentive packages, etc.), and forecasts future income and expenditure over the short and long term. This is a bottom-up model with top-down driver-based sensitivity modeling.

All assumptions can be overridden at segment, property, unit or lease level, and can be flexed globally for the purpose of scenario modeling.

This model can be integrated with Lionpoint Group’s Real Estate Portfolio & Fund Performance Forecast model to produce an integrated property portfolio performance forecast including debt and fund-level attributes, modeling how various factors affect your portfolio’s future capital growth, income return, and total return.

Features

Bottom-up Budget Collection

• Data is automatically collected from your property management system and used to create lease- and property-level cash flow forecasts
• Property-level cashflows are rolled up to user-defined region, sector, portfolio, and asset management hierarchies, with allowances for different ownership percentages at fund and JV levels
• Future events such as rent reviews, vacancies, and future lettings are collected in a simple asset manager dashboard, to predict future income and costs
• Asset managers can see all upcoming events at a glance, filtered by property and ordered by criticality (nearest events first or highest rents first)

Top-Down Assumption Layering

• Assumptions can be applied at the sector level, and overridden at property, unit, or lease level as desired, with a full audit trail of changes at each level
• Macroeconomic assumptions such as inflation, FX, ERV growth, and yield shift can be set at a global or country level and overridden at lower levels as appropriate
• All assumptions can be flexed globally for ‘What If…?’ analysis, allowing you to quickly see the impact of, for example, extending all voids (vacancies) by a given number of months, depressing ERV growth by a given amount from a chosen date, increasing or decreasing all tenant incentive packages, and so on

Detailed Income & Cost Forecast

• Income and costs are forecast at a very granular level of detail for each unit in your portfolio, including rental income, shortfalls from vacancies (irrecoverable service charges/CAM and business rates), agents’ fees, head rent payable, break fees receivable/payable, rent spreading adjustments
• Accounting adjustments are calculated on each lease and applied to cash forecasts to produce full a profit & loss statement
• Results of any change are instantly rolled up to the portfolio level to show the impact of any changes
• The impact of void costs, incentives, and rent reviews are visible to the user as well as allowing the asset manager to assess the suitability of a particular lease and the impact it has on the overall performance of an asset

Customizable P&L

• Detailed components of cashflow are combined according to your chart of accounts
• P&L can be recorded at any level of granularity, in cash terms or in accounting terms
• P&L reports display the financial data as desired – from segment to individual unit

Report by Region, Segment, or Asset Manager

• Reports roll up property-level data to sector/segment, region/geography, asset manager/sector head, and portfolio
• Drilldown is available through any hierarchy (geography, sector/segment or asset management hierarchy) or through the chart of accounts
• Sector heads can review the results of the forecasting process alongside asset managers’ commentary

Multi-National, Multi-Currency

• Global reporting with consolidation over multiple currencies, with a choice of consolidation currency by region

Integration with Other Systems

• Scheduled and ad-hoc property upload dashboard enables the import of underlying data from a variety of source systems
• The data can be reviewed and enriched through the upload page before being used in the Budget & Forecast model
• The model will store the original source version of the data so that this can be tracked for reporting and auditing purposes, and a comparison report will show you changes you’ve made to the data

Information

Size

2.61 GB

Language

English

Terms & Conditions

App stats

Modules

130

Roles

6

Formulas

1000

Reports

30

Contact: anaplan@lionpointgroup.com