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
This model addresses the planning of global clinical trials and the forecasting of long-range expenses to accurately allocate project resources. It includes a trial management hub, consolidated portfolio analytics, financial and KPI reporting, and
finance
Clinical Trial Forecasting
Peloton’s Contingent Workforce Planning app enables you to quickly track and plan all 3rd party labor requirements while providing what-if scenario insight. Contingent labor planners can face difficult analysis of contract value and expiration of
other
Contingent Workforce Planning
Cloud solution that covers planning for operating expenses including workforce, technology spend and project expense in Anaplan’s latest UX. It combines a driver-based and zero-based budgeting approach and highlights other key functionality of
finance
Digital Cost Management (DCM)
Add-in from version 2.6 to version 3.2 to benefit from: faster performance; the ability to connect to saved views; the use of context selectors; and the use of pivot and filter to orientate and condense your data to one worksheet.
other
Migrate Excel Add-in version 2.6 to version 3.2
For front end sales affiliates, enable PSI control with statistical forecast and inventory plan and communicate global demands to the factories.
finance
S&OP with Multi Layer PSI Control (JP)
Digital Commercial Planning uses advanced analytics & industry leading practices to inform decision making across all steps of commercial planning cycle
supply chain
Digital Commercial Planning
The Anaplan NHS Pathology Planning and Reporting model supports hospitals to plan for their pathology services both locally and as part of the new networks.
finance
NHS - Pathology Planning & Model Hospital Reporting
Launch your finance system into the cloud in as little as 60 days with our proprietary Accelerator.
finance
FP&A Accelerator
Enhance CRM, improve forecast accuracy, and drive revenue with Twelve's proprietary Accelerator.
sales
Sales Forecasting & Analytics Accelerator
Create features, manage change requests, and track project development with Akili's Studio Production Planning App.
other
Studio Production Planning
The app enables organizations to plan for development and growth opportunities, and for total Brand Marketing investments being incurred for such opportunities
sales
Brand Marketing Investment Planning
IT Performance Management - Bridging the gap from the IT point solutions to a fully Connected Planning Experience
it
ITPM Quickstart for Carlyle Portfolio Companies
The Digital Assortment Solution uses advanced analytics and industry leading practices to guide retail merchants through the assortment planning process.
finance
Digital Assortment Solution (DAS)
Easily create projects, assign resources, and track revenues and expenses with the Akili Project Revenue & Expense Planning App
hr
Project Revenue & Expense Planning
The App contains the CSM sub-ledger requirements, accounting rules and the posting engine, reporting and analytics as well as data management capabilities.
finance
IFRS 17 - Life Insurance
Complete income statement, balance sheet, and cashflow planning including allocations, and currency translation.
finance
FP&A Quickstart
Complete income statement, balance sheet, and cashflow planning including allocations, and currency translation for the Carlyle Portfolio Companies.
finance
FP&A Quickstart for Carlyle Portfolio Companies
Daily inventory management and forecasting for core and limited time SKUs and Supplier/DC performance rating
supply chain
Daily Inventory Management
This App puts into practice 'connected planning' concept  in Anaplan linking plans from investors, property and fund managers into one single place.
finance
Property FP&A
Use Waterfall Allocation methodology to redistribute the costs across your organization.
finance
Waterfall Allocation
Allitix's Health System and Physicians Group Planning app addresses the difficulties with managing revenue, physician productivity and compensation.
finance
Health System & Physicians Group Planning
Track your sales opportunities and manage project profitability using PwC's Sales Opportunity Management and Revenue Forecasting app.
finance
Sales Opportunity Management & Revenue Forecast(JP)
Align your workforce plan with your business strategy to effectively manage your organization-wide talent needs with PwC's Workforce Planning app.
hr
Workforce Planning(JP)
Accurately capture your future performance and risk using PwC's app, by cascading ROIC to your key organizational KPIs as well as individual targets.
finance
IBP for ROIC Management(JP)
Streamline your budgeting, forecasting and reporting process, improving visibility of your global business with PwC's budget & Forecasting app.
finance
Budget & Forecasting (JP)