Asset Allocation Modelling
Course
In London
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
Start date
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.
Reviews
Subjects
- Excel
- Real Estate
- Property
- MS Excel
- Calculate risk
- Assets
- Portfolios
- Optimisation
- Build
- Techniques
- Allocations
Teachers and trainers (1)
Bayfield Training
Proviider
Course programme
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