Markowitz Model - Modern Portfolio Theory

  • Thanks to the Variance-Covariance matrix, a portfolio of 30 securities can be considered;
  • A methodology is available within the workbook;
  • In order to maximise the Sharpe ratio and to draft the Markowitz efficient frontier, the Solver add-in is required.
Download
Markowitz.zip
Compressed Archive in ZIP Format 665.9 KB