Asset Allocation Modelling

Course

In London

Price on request

Description

  • Type

    Intensive workshop

  • Level

    Advanced

  • Methodology

    Inhouse

  • Location

    London

  • Duration

    1 Day

  • Start date

    Different dates available

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.

Important information

Documents

  • Asset Allocation Modelling.pdf

Facilities

Location

Start date

London
See map

Start date

Different dates availableEnrolment now open

About this course

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

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

Real Estate Analyst

We received your request and will get back to you with a response as soon as possible.
If you have any further questions, please contact us by email: R.Augustiniene@bayfieldtraining.com.

Questions & Answers

Add your question

Our advisors and other users will be able to reply to you

Who would you like to address this question to?

Fill in your details to get a reply

We will only publish your name and question

Reviews

Subjects

  • Excel
  • Real Estate
  • Property
  • MS Excel
  • Calculate risk
  • Assets
  • Portfolios
  • Optimisation
  • Build
  • Techniques
  • Allocations

Teachers and trainers (1)

Bayfield Training

Bayfield Training

Proviider

Course programme

DAY ONE

Revisiting Risk
• Single Asset Risk: Historic Returns
• Single Asset Risk: Expectations
• Multi Asset Risk: Correlations; Formula and Increasingnumber of Assets
• Compiling Data for Risk Analysis

Correlations
• Understanding Paired Assets and Subsectors
• Is the Past a guide to the Future?
• Are correlations explanatory or co-incidence?

Optimisation
• Using Solver to find minimum Risk Portfolios
• Understanding Technical Allocations
• Issues with Optimisation

Attribution Analysis
• Benchmarking Returns
• Attributing Asset Allocation and Stock Selection
• Tracking Error
•Understanding Proactive Allocations

Asset Allocation Modelling

Price on request