Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Modified Problem Assignment 3 Weight: 9% Submit: via the Dropbox tool Due: Friday of Week 10 by 11:59 pm ET Note: Please refer to the
Modified Problem Assignment 3 Weight: 9% Submit: via the Dropbox tool Due: Friday of Week 10 by 11:59 pm ET Note: Please refer to the Outiline for exact due dates. Choose arbitrarily one bond fund, one Canadian equity fund, and one international fund that have at least five years of data obtain the data necessary to calculate the monthly rate of return for the past ten years. Use EXCEL to calculate the average rates of return, thestandard deviation, and correlation coefficients between the three funds. Construct three portfolios trom these mutioal funds. For each portfofio, calculate the expected rate of return and the standard deviation. Comment on the relative strengths and weaknesses of the portfolios, identifying which you would prefer to invest in. The marking guidelines are as follows: 1. (2 Marks) Monthly rates of return over the last 10 years of three funds (Bond, Canadian Equity, International). 2. (2 Marks) Average rates of return, standard deviations, and correlation coefficients between the above fuinds. 3. (2 Marks) Portfolio creation - Expected rate of return 4. (2 Marks) Portfolio creation - Standard Deviation. 5. 11 Mark) Overall written report and presentation (Introduction, Conclusion, Graphs, Charts, Tables). Total =9 marks Please show al the links on the EXCEL spreadsheet so I can determine how your calculations were derivod. Modified Problem Assignment 3 Weight: 9% Submit: via the Dropbox tool Due: Friday of Week 10 by 11:59 pm ET Note: Please refer to the Outiline for exact due dates. Choose arbitrarily one bond fund, one Canadian equity fund, and one international fund that have at least five years of data obtain the data necessary to calculate the monthly rate of return for the past ten years. Use EXCEL to calculate the average rates of return, thestandard deviation, and correlation coefficients between the three funds. Construct three portfolios trom these mutioal funds. For each portfofio, calculate the expected rate of return and the standard deviation. Comment on the relative strengths and weaknesses of the portfolios, identifying which you would prefer to invest in. The marking guidelines are as follows: 1. (2 Marks) Monthly rates of return over the last 10 years of three funds (Bond, Canadian Equity, International). 2. (2 Marks) Average rates of return, standard deviations, and correlation coefficients between the above fuinds. 3. (2 Marks) Portfolio creation - Expected rate of return 4. (2 Marks) Portfolio creation - Standard Deviation. 5. 11 Mark) Overall written report and presentation (Introduction, Conclusion, Graphs, Charts, Tables). Total =9 marks Please show al the links on the EXCEL spreadsheet so I can determine how your calculations were derivod
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access with AI-Powered Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started