You are unlikely to be asked to do this in the exam, in fact the multiple choice format is very poorly suited to testing such knowledge. This tutorial looks at how portfolio risk calculations can be modeled within Excel. What we really need for that is matrices, and Excel. This formula is not really scalable to real life situations where a portfolio may consist of tens or hundreds of securities. This formula is very useful in forming an intuitive understanding of how correlation affects risk, and examining various concepts relating to portfolio construction. This brief article is a practical demonstration of how portfolio variance can be modeled in Excel – the underlying math, and an actual spreadsheet for your playing pleasure! Enjoy!Ĭalculating portfolio variance for a portfolio of two assets with a given correlation is a fairly trivial task – you use the formula to get the portfolio variance, and take the square root to get the standard deviation or volatility. But consider a situation when there are 10, 15, maybe hundreds of assets. When it comes to calculating portfolio variance with just two assets, life is simple. This article is about an Excel model for calculating portfolio variance.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. Archives
March 2023
Categories |