This story began when I wrote about benchmark issue in CAPM. Then, it continued with an Excel model for optimisation of shares or funds portfolio. The main problem defined in the model is to select shares and find the optimised asset allocation in a portfolio with three scenarios:
1. Assumed CAPM can't be applied and historical data is important therefore historical mean (average) return and standard deviation are used to simulate random return normal distribution and calculate Variance Covariance matrix.
2. Assumed CAPM can't be applied and cumulative data is important therefore projected mean (average) return and standard deviation are used to simulate random return normal distribution and calculate Variance Covariance matrix.
3. Assume CAPM can be applied and cumulative data is important therefore projected CAPM return and standard deviation are used to simulate random return normal distribution and calculate Variance Covariance matrix.
Starting by processing 13 NZ shares in the optimisation model with the three scenarios then applying the result of the share selection and the asset allocation into three passive portofolios, after one month holding period I found the return as follows:
Scenario 1 = -8.98%
![](https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjnJ75GBIzK_7Ppc3_ox4wJaA3uw-zt5_q4GZ5C71UGfAUIpSa9npgYWjyKghPcFwQsJnjUibuEaTW6AB-IOryOZmOGetCfe8QqnVcXL_4QZXVVCVrJJlfSTeZrA0inrWXiiyDe/s400/ScreenHunter_001.jpg)
Scenario 2 = -2.86%
![](https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEi0qyBUS-himUw78dPtSTAtXoaMhlfmuUnd0yhtd9LHiq-DAXBIQaceaRAK0t2gcr73bTHON4Pd0FnCahaqs593BJNt8zG66yGN7LNczV6HjLxbeQP0XU5gQACvi_gnUQgDgcGK/s400/ScreenHunter_002.jpg)
Scenario 3 = +6.06%
![](https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgUn6JTIVTmdYkBV9AZSrR61RlxlolLt6c_QnpRPrFEcd7_UySpT0alIKAv85RFHSH0HRheYQgZ3evIDtwhhFt2Um6gAJK3-Z3Wvon_BCej2OHMr6YT9KO6Fh3yaf5_rYKqk4wZ/s400/ScreenHunter_004.jpg)
I will update after 12 months.
1. Assumed CAPM can't be applied and historical data is important therefore historical mean (average) return and standard deviation are used to simulate random return normal distribution and calculate Variance Covariance matrix.
2. Assumed CAPM can't be applied and cumulative data is important therefore projected mean (average) return and standard deviation are used to simulate random return normal distribution and calculate Variance Covariance matrix.
3. Assume CAPM can be applied and cumulative data is important therefore projected CAPM return and standard deviation are used to simulate random return normal distribution and calculate Variance Covariance matrix.
Starting by processing 13 NZ shares in the optimisation model with the three scenarios then applying the result of the share selection and the asset allocation into three passive portofolios, after one month holding period I found the return as follows:
Scenario 1 = -8.98%
![](https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjnJ75GBIzK_7Ppc3_ox4wJaA3uw-zt5_q4GZ5C71UGfAUIpSa9npgYWjyKghPcFwQsJnjUibuEaTW6AB-IOryOZmOGetCfe8QqnVcXL_4QZXVVCVrJJlfSTeZrA0inrWXiiyDe/s400/ScreenHunter_001.jpg)
Scenario 2 = -2.86%
![](https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEi0qyBUS-himUw78dPtSTAtXoaMhlfmuUnd0yhtd9LHiq-DAXBIQaceaRAK0t2gcr73bTHON4Pd0FnCahaqs593BJNt8zG66yGN7LNczV6HjLxbeQP0XU5gQACvi_gnUQgDgcGK/s400/ScreenHunter_002.jpg)
Scenario 3 = +6.06%
![](https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgUn6JTIVTmdYkBV9AZSrR61RlxlolLt6c_QnpRPrFEcd7_UySpT0alIKAv85RFHSH0HRheYQgZ3evIDtwhhFt2Um6gAJK3-Z3Wvon_BCej2OHMr6YT9KO6Fh3yaf5_rYKqk4wZ/s400/ScreenHunter_004.jpg)
I will update after 12 months.
Post a Comment
<< Home