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

Bayfield Training is a prominent global supplier of investment grade Real Estate executive education. Having begun as pioneers in the field of Real Estate Financial Modelling, today Bayfield has a huge extended network of experts, specialists and professionals within this sector. This enables the company to provide a wide range of education for businesses and employees within the field of International Real Estate.