This preview has intentionally blurred sections. Sign up to view the full version.View Full Document
Unformatted text preview: ActSc 372 WINTER 2010 Assignment 3 Due Date: Friday February 26, 2010 (Beginning of Class) 1. Excel Exercise. This question requires a data set that can be downloaded from the course webpage. All Excel program must be uploaded to the course webpage via dropbox before the due date. Details on how to upload your program will be posted on the course webpage. You must also include documentation on how to run the program on obtaining the answers to the questions below. The data set contains the monthly prices of S&amp;P/TSX (ticker symbolGSPTSE), RIM, Royal Bank, Rogers Communications, and Manulife Life, for periods February, 2000 to February 2010. Now answer the following parts based on the above data set: (a) Use Excel to compute the average monthly returns and the variance-covariance matrix of the index and stocks. (b) Assume the standard Markowitz model holds, use Excel Solver to find the min- imum variance portfolio (give its mean, standard deviation, and the portfolio weights). Use Excel Solver again to determine the minimum attainable risk (inweights)....
View Full Document
This note was uploaded on 06/21/2010 for the course ACTSC 5255 taught by Professor Tan,kens during the Spring '10 term at Waterloo.
- Spring '10