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

Number of days: One day
Course type: Financial Modelling
Course level:
Pre-requisite: Real Estate Analyst


How to Book

In-house Course:


Any Questions?

Contact our team members:

Kendal Bahadirgil
k.bahadirgil@bayfieldtraining.com

Jacob Noble
j.noble@bayfieldtraining.com

  • Thank you for expressing interest in this course!

    Fill out the form below and we will email the brochure over to you as soon as possible.

  • Chat with us
    Chat with us
    Questions? We're here to help you!
    Connecting...
    None of our operators are available at the moment. Please, try again later.
    Our operators are busy. Please try again later
    :
    :
    :
    Have you got question? Write to us!
    :
    :
    This chat session has ended
    Was this conversation useful? Vote this chat session.
    Good Bad