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