Asset Allocation Modelling

Asset Allocation Modelling

Build your own Asset Allocation Model in Excel for Real Estate Investment Portfolios. The course uses Excel to analyse return series, interrogate the reliability of forecasts and reconstruct, from scratch, the mathematics behind diversification. It also explores, using real world examples, the many assumptions behind technical portfolio construction in general and the further problems associated with property portfolios. The course will also show delegates how to benchmark their returns against a chosen index and learn why and how they under or over performed. The course will provide you with an entire toolkit to build an optimiser and performance model in Excel, and these tools will be completed on the course.

On this course you will:

  • Learn how to calculate risk and return for individual property assets and portfolios
  • Understand the benefits and limits of diversification
  • Build your own optimisation, asset allocation and performance models
  • Learn tools to improve optimisation techniques
  • Appreciate the difference between technical and proactive allocations
  • Learn how to measure performance against a benchmark

Who will benefit from this course?

  • Junior Fund Managers
  • Private Equity Analysts
  • Asset Managers
  • Real Estate Investors
  • Real Estate Advisors

Course Details

Upcoming Dates – Public Course Dates
In-Person & Virtual
Number of days:
One day
Course type: Financial Modelling
Course level:
Pre-requisite: Real Estate Analyst

How to Book

Course Bookings contact:

Jacob Noble
[email protected]

Samuel Musgrave
[email protected]

Course Delivery & Administration:

Emma Wilson
[email protected]

Go to Top