Weight: 9% Submit: via the Dropbox tool Due: Friday of Week 10 by 11:59 pm ET...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
Weight: 9% Submit: via the Dropbox tool Due: Friday of Week 10 by 11:59 pm ET Note: Please refer to the Outline 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, the standard deviation, and correlation coefficients between the three funds. Construct three portfolios from these mutual funds. For each portfolio, 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 funds. 3. (2 Marks) Portfolio creation - Expected rate of return. 4. (2 Marks) Portfolio creation - Standard Deviation. 5. (1 Mark) Overall written report and presentation (Introduction, Conclusion, Graphs, Charts, Tables). Weight: 9% Submit: via the Dropbox tool Due: Friday of Week 10 by 11:59 pm ET Note: Please refer to the Outline 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, the standard deviation, and correlation coefficients between the three funds. Construct three portfolios from these mutual funds. For each portfolio, 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 funds. 3. (2 Marks) Portfolio creation - Expected rate of return. 4. (2 Marks) Portfolio creation - Standard Deviation. 5. (1 Mark) Overall written report and presentation (Introduction, Conclusion, Graphs, Charts, Tables).
Expert Answer:
Answer rating: 100% (QA)
Here is a report with analysis of three mutual fund portfolios I collected monthly total return data ... View the full answer
Related Book For
Income Tax Fundamentals 2013
ISBN: 9781285586618
31st Edition
Authors: Gerald E. Whittenburg, Martha Altus Buller, Steven L Gill
Posted Date:
Students also viewed these finance questions
-
15. Explain the following trends: (i) (ii) toiwo loke Why does fluorine have a smaller atomic radius than beryllium? essa sniwollat pd to doesnt ES Why does fluorine have a smaller atomic radius than...
-
Planning is one of the most important management functions in any business. A front office managers first step in planning should involve determine the departments goals. Planning also includes...
-
Calculate the IRR for the following projects. a. An initial outflow of $15,220 followed by inflows of $5,000, $6,000, and $6,500. b. An initial outflow of $47,104 followed by inflows of $16,000,...
-
Discuss the tax treatment of the sale of 1244 stock at a gain.
-
Reconsider the coefficient of restitution data in Exercise 10-32. Do the data suggest that the standard deviation is the same for both brands of drivers (use a = 0.05)? Explain how to answer this...
-
This case is a continuation of the Burburr Resorts & Hotels Corporation serial case that began. The components of the Burburr serial case can be completed in any order. Burburr has several properties...
-
Although it will fulfill her lifelong dream, Patricia is not confident that demand for her Tiny Trisha doll will exceed the breakeven point computed in Problem 6-5. If she chooses a less appealing...
-
(a) A mutual fund raised Rs. 150 lakhs on April 1, 2018 by issue of 15 lakh units at Rs. 10 per unit. The fund invested in several capital market instruments to build a portfolio of Rs. 140 lakhs,...
-
Stacey is 51 years old and has an annual salary of $350,000. Her employer integrates her 401(k) with Social Security. They have set the integration level equal to the taxable wage base. Their current...
-
What is true of the following code? (Choose three.) A. It compiles as is. B. It does not compile as is. C. Removing line 2 would create an additional compiler error. D. Removing line 2 would not...
-
Given the following two classes, each in a different package, which line inserted into the code allows the second class to compile? A. import static commerce.Bank.*; B. import static commerce.Bank;...
-
Which of the following modifiers can be applied to an abstract method? (Choose two.) A. final B. private C. public D. default E. protected F. concrete
-
Given the following class structures, which lines can be inserted into the blank independently that would allow the class to compile? (Choose two.) A. dino.Pterodactyl() B. Dinosaur.new Pterodactyl()...
-
What is the output of the Square program? A. 0 B. 2 C. 4 D. The code does not compile due to line x1. E. The code does not compile due to line x2. F. The code does not compile due to line x3. package...
-
A random sample of 83 reconstructed clay vessels from the Turquoise Ridge archaeological site indicated the standard deviation of diameters to be approximately 5.5 cm. How many more such clay vessels...
-
Establish identity. cos( + k) = (-1)k cos , k any integer
-
David and Darlene Jasper have one child, Sam, who is 6 years old. The Jaspers reside at 4639 Honeysuckle Lane, Los Angeles, CA 90248. David's Social Security number is 577-11-3311, Darlene's is...
-
In 2012, Michael has net short-term capital losses of $2,000, a net long-term capital loss of $45,000, and other ordinary taxable income of $45,000. a. Calculate the amount of Michael's deduction for...
-
In 2012, Lou has a salary of $54,000 from her job. She also has interest income of $1,700. Lou is single and has no dependents. During the year, Lou sold silver coins held as an investment for a...
-
In the FRED database, find a variable that is available in both a seasonally adjusted form and a not seasonally adjusted form. Plot both over time and describe how large the seasonal variation in the...
-
An economic variable is persistent if declines in the variable tend to be followed by more declines, and increases by more increases. This question asks you to study the persistence of the civilian...
-
It has been argued that the stock market predicts recessions. Using quarterly data since 1961, plot the real value of the stock market index (the Wilshire 5000 index in the last month of the quarter...
Study smarter with the SolutionInn App