Real Estate Budget & Forecast

mark_godfrey
Super Contributor

 

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 modelling.
All assumptions can be overridden at segment, property, unit or lease level, and can be flexed globally for the purpose of scenario modelling.
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, modelling 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 cashflow 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 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 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
Customisable 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 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
Complexity
Master

Lionpoint Group

Lionpoint Group is a global advisory firm with a unique focus on managers of and investors in alternative investments. Lionpoint's Corporate Performance Management (CPM) practice focuses on private capital markets, including private equity and debt, real estate, and infrastructure. Our business model combines the talents of industry leaders with experts in service delivery to assist clients in transforming front and back office operations through operating model restructure, process improvements, and the implementation of enabling technologies. From our offices in New York, Geneva and London, our model is to work as an extension of your team and transfer knowledge and expertise at every stage of the engagement.

Website
http://www.lionpointgroup.com
Address

Lionpoint Group - London

7-10 Adam Street

London, United Kingdom

WC2N 6AA

Phone: +44-20 7520 9099

------------

Lionpoint Group - New York

708 3rd Ave, 5th Floor

New York, NY 10017

United States

Phone: +1 (646) 450-4901

Email
anaplan@lionpointgroup.com