1. Calculate the expected return (sample arithmetic mean) and sample standard deviation of returns of each...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
1. Calculate the expected return (sample arithmetic mean) and sample standard deviation of returns of each asset class. Also calculate the sample geometric mean average historical rate of return for each asset class. Comment on the relationship between arithmetic mean and geometric mean returns. (15%) 2. Calculate the correlation matrix of returns. Comment on the correlation matrix, with reference to the potential for risk reducing benefits from diversification across this set of assets. (10%) 3. Using the approach recommended in the instruction video on the course website, construct (i) a covariance matrix for the asset classes; (ii) a border- multiplied covariance matrix, based on an equally weighted risky-asset portfolio. (10%) 4. Construct a restricted minimum variance frontier and a restricted efficient frontier for these asset classes, using target expected rates of return of 4%, 5%, 6%, 7%, 8% , 9%, 10 % , 11%, 12%, 13%, 14%, 15%, 16%, 17% and 18%. Graph them. (10%) 5. Assuming a coefficient of risk aversion of 5 and assuming the investor is not able to borrow, identify which of the above target rates of return maximises the investor's utility. (5%) 6. Construct an unrestricted minimum variance frontier and an unrestricted efficient frontier for these asset classes, using target expected rates of return of 4%, 5%, 6%, 7%, 8%, 9%, 10 %, 11%, 12%, 13%, 14%, 15%, 16%, 17% and 18%. Graph them. (10%) 7. Assuming a coefficient of risk aversion of 5 and assuming the investor is not able to borrow, identify which of the above target rates of return maximises the investor's utility. (5%) 8. Explain the reasons for any difference between the utility-maximising target expected rate of return in questions 5 and 7. (5%) 9. Now assume it is possible for the investor to borrow funds at a rate of interest of 1.5% per annum, which is also the rate of interest on the risk-free asset, but it is not permitted to short-sell risky assets. Draw a capital allocation line onto the diagram. Show that it is now possible to obtain the same target expected rate of return you identified in question 5, but at lower risk. What combined portfolio should be selected if the aim is to maximise investor utility, based on the restricted frontier and the capital allocation line? (15%) 10. What assumptions have you made when undertaking the above analysis? Suppose that economic conditions have changed, so that expected returns on risky assets are lower than during the sample period, risks are higher and correlations are higher. What would this imply? In what sense is fundamental uncertainty of relevance to investment analysts and those who offer investment advice? (15%) Year 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 A -5.7 0.6 22.8 32.6 11.8 8 20.6 14 20.6 12.4 24 -7.6 -1.1 18.6 28.9 16.6 -2.1 -6 20.7 30 B -1.1 -1.5 10.4 16.5 2.5 4.7 2.6 1.4 14.8 11.9 -2.3 -2.6 9.8 2.8 -1.2 1.1 7.7 5.9 9.5 10.2 Asset Class(% returns) C D -3.2 -8.6 0 1.1 2.2 34.5 3.9 40.6 1.5 15.8 2.4 7.3 2.2 13.4 -1.9 5.6 5.5 10.3 11.2 13.3 -1.6 26.6 -0.8 -4.1 7.9 -0.4 0.8 35.3 -2.7 2.8 2.7 22.5 7.5 -0.7 8.6 -2.5 13.4 30.5 18 42.4 E -3.4 0.3 20.1 54.6 23.9 4.4 13.2 26 26.3 6.6 32.2 -5.8 -1.9 8.2 38.8 2.9 -0.2 -3.6 22.8 58.1 F -13.1 -0.1 11.1 2.5 1.3 2.8 6.4 5.3 5.5 16.8 -1.7 4.7 6.2 1 3.7 1.9 4.5 4.9 10 10.4 G -13 2 52.1 50.4 21.1 6.7 8.7 2.3 5.1 14.2 29.5 -2.2 -0.1 66.8 0.3 30.6 -0.2 -1.1 44.9 60 1. Calculate the expected return (sample arithmetic mean) and sample standard deviation of returns of each asset class. Also calculate the sample geometric mean average historical rate of return for each asset class. Comment on the relationship between arithmetic mean and geometric mean returns. (15%) 2. Calculate the correlation matrix of returns. Comment on the correlation matrix, with reference to the potential for risk reducing benefits from diversification across this set of assets. (10%) 3. Using the approach recommended in the instruction video on the course website, construct (i) a covariance matrix for the asset classes; (ii) a border- multiplied covariance matrix, based on an equally weighted risky-asset portfolio. (10%) 4. Construct a restricted minimum variance frontier and a restricted efficient frontier for these asset classes, using target expected rates of return of 4%, 5%, 6%, 7%, 8% , 9%, 10 % , 11%, 12%, 13%, 14%, 15%, 16%, 17% and 18%. Graph them. (10%) 5. Assuming a coefficient of risk aversion of 5 and assuming the investor is not able to borrow, identify which of the above target rates of return maximises the investor's utility. (5%) 6. Construct an unrestricted minimum variance frontier and an unrestricted efficient frontier for these asset classes, using target expected rates of return of 4%, 5%, 6%, 7%, 8%, 9%, 10 %, 11%, 12%, 13%, 14%, 15%, 16%, 17% and 18%. Graph them. (10%) 7. Assuming a coefficient of risk aversion of 5 and assuming the investor is not able to borrow, identify which of the above target rates of return maximises the investor's utility. (5%) 8. Explain the reasons for any difference between the utility-maximising target expected rate of return in questions 5 and 7. (5%) 9. Now assume it is possible for the investor to borrow funds at a rate of interest of 1.5% per annum, which is also the rate of interest on the risk-free asset, but it is not permitted to short-sell risky assets. Draw a capital allocation line onto the diagram. Show that it is now possible to obtain the same target expected rate of return you identified in question 5, but at lower risk. What combined portfolio should be selected if the aim is to maximise investor utility, based on the restricted frontier and the capital allocation line? (15%) 10. What assumptions have you made when undertaking the above analysis? Suppose that economic conditions have changed, so that expected returns on risky assets are lower than during the sample period, risks are higher and correlations are higher. What would this imply? In what sense is fundamental uncertainty of relevance to investment analysts and those who offer investment advice? (15%) 1. Calculate the expected return (sample arithmetic mean) and sample standard deviation of returns of each asset class. Also calculate the sample geometric mean average historical rate of return for each asset class. Comment on the relationship between arithmetic mean and geometric mean returns. (15%) 2. Calculate the correlation matrix of returns. Comment on the correlation matrix, with reference to the potential for risk reducing benefits from diversification across this set of assets. (10%) 3. Using the approach recommended in the instruction video on the course website, construct (i) a covariance matrix for the asset classes; (ii) a border- multiplied covariance matrix, based on an equally weighted risky-asset portfolio. (10%) 4. Construct a restricted minimum variance frontier and a restricted efficient frontier for these asset classes, using target expected rates of return of 4%, 5%, 6%, 7%, 8% , 9%, 10 % , 11%, 12%, 13%, 14%, 15%, 16%, 17% and 18%. Graph them. (10%) 5. Assuming a coefficient of risk aversion of 5 and assuming the investor is not able to borrow, identify which of the above target rates of return maximises the investor's utility. (5%) 6. Construct an unrestricted minimum variance frontier and an unrestricted efficient frontier for these asset classes, using target expected rates of return of 4%, 5%, 6%, 7%, 8%, 9%, 10 %, 11%, 12%, 13%, 14%, 15%, 16%, 17% and 18%. Graph them. (10%) 7. Assuming a coefficient of risk aversion of 5 and assuming the investor is not able to borrow, identify which of the above target rates of return maximises the investor's utility. (5%) 8. Explain the reasons for any difference between the utility-maximising target expected rate of return in questions 5 and 7. (5%) 9. Now assume it is possible for the investor to borrow funds at a rate of interest of 1.5% per annum, which is also the rate of interest on the risk-free asset, but it is not permitted to short-sell risky assets. Draw a capital allocation line onto the diagram. Show that it is now possible to obtain the same target expected rate of return you identified in question 5, but at lower risk. What combined portfolio should be selected if the aim is to maximise investor utility, based on the restricted frontier and the capital allocation line? (15%) 10. What assumptions have you made when undertaking the above analysis? Suppose that economic conditions have changed, so that expected returns on risky assets are lower than during the sample period, risks are higher and correlations are higher. What would this imply? In what sense is fundamental uncertainty of relevance to investment analysts and those who offer investment advice? (15%) Year 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 A -5.7 0.6 22.8 32.6 11.8 8 20.6 14 20.6 12.4 24 -7.6 -1.1 18.6 28.9 16.6 -2.1 -6 20.7 30 B -1.1 -1.5 10.4 16.5 2.5 4.7 2.6 1.4 14.8 11.9 -2.3 -2.6 9.8 2.8 -1.2 1.1 7.7 5.9 9.5 10.2 Asset Class(% returns) C D -3.2 -8.6 0 1.1 2.2 34.5 3.9 40.6 1.5 15.8 2.4 7.3 2.2 13.4 -1.9 5.6 5.5 10.3 11.2 13.3 -1.6 26.6 -0.8 -4.1 7.9 -0.4 0.8 35.3 -2.7 2.8 2.7 22.5 7.5 -0.7 8.6 -2.5 13.4 30.5 18 42.4 E -3.4 0.3 20.1 54.6 23.9 4.4 13.2 26 26.3 6.6 32.2 -5.8 -1.9 8.2 38.8 2.9 -0.2 -3.6 22.8 58.1 F -13.1 -0.1 11.1 2.5 1.3 2.8 6.4 5.3 5.5 16.8 -1.7 4.7 6.2 1 3.7 1.9 4.5 4.9 10 10.4 G -13 2 52.1 50.4 21.1 6.7 8.7 2.3 5.1 14.2 29.5 -2.2 -0.1 66.8 0.3 30.6 -0.2 -1.1 44.9 60 Year 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 A -5.7 0.6 22.8 32.6 11.8 8 20.6 14 20.6 12.4 24 -7.6 -1.1 18.6 28.9 16.6 -2.1 -6 20.7 30 B -1.1 -1.5 10.4 16.5 2.5 4.7 2.6 1.4 14.8 11.9 -2.3 -2.6 9.8 2.8 -1.2 1.1 7.7 5.9 9.5 10.2 Asset Class(% returns) C D -3.2 -8.6 0 1.1 2.2 34.5 3.9 40.6 1.5 15.8 2.4 7.3 2.2 13.4 -1.9 5.6 5.5 10.3 11.2 13.3 -1.6 26.6 -0.8 -4.1 7.9 -0.4 0.8 35.3 -2.7 2.8 2.7 22.5 7.5 -0.7 8.6 -2.5 13.4 30.5 18 42.4 E -3.4 0.3 20.1 54.6 23.9 4.4 13.2 26 26.3 6.6 32.2 -5.8 -1.9 8.2 38.8 2.9 -0.2 -3.6 22.8 58.1 F -13.1 -0.1 11.1 2.5 1.3 2.8 6.4 5.3 5.5 16.8 -1.7 4.7 6.2 1 3.7 1.9 4.5 4.9 10 10.4 G -13 2 52.1 50.4 21.1 6.7 8.7 2.3 5.1 14.2 29.5 -2.2 -0.1 66.8 0.3 30.6 -0.2 -1.1 44.9 60
Expert Answer:
Answer rating: 100% (QA)
1 To calculate the expected return sample arithmetic mean sample standard deviation and sample geometric mean for each asset class we can use the provided data Here are the calculations Expected Retur... View the full answer
Related Book For
Microsoft Excel Data Analysis And Business Modeling
ISBN: 9780137613663
7th Edition
Authors: Wayne Winston
Posted Date:
Students also viewed these finance questions
-
Discuss which organizational structure (i.e. functional, product-market divisional, matrix) you would recommend Guelph General Hospital implement, assuming the hospital moves forward with the...
-
In Figure 3,4, C is the event that an ore contains and U is the event that it contains uranium. Explain in copper (a) region 5; (b) regions 4 and 6 together; (c) regions 7 and 8 together; d) regions...
-
Explain the correlation here and solve please When the average price of movie tickets rises, it has an effect on the purchase of computer games. (Analyze computer games.) 1. Draw and Label...
-
Thor Bhd. (Thor) is a listed company in Malaysia, specializes in selling batteries. At 31 December 2021, Thor holds four distinct types of batteries in its warehouse. The accountant of Thor provided...
-
Find the companion matrix of p(x) = x3 + 3x2 - 4x + 12 and then find the characteristic polynomial of C(p).
-
Please respond to the following: From the e-Activity, assess the advantages and disadvantages of the continued use of the traditional relational database and then decide if businesses should be...
-
Adjusting Entries-Prepayments Tyndal Company had the following items that required adjustment at December 31, 2018. a. Purchased equipment for \(\$ 40,000\) on January 1, 2018. Tyndal estimates...
-
A bond with 5 years to maturity and a coupon rate of 6% has a par, or face, value of $20,000. Interest is paid annually. If you required a return of 8% on this bond, what is the value of this bond to...
-
QUESTION 1 In conjunction with the housing foreclosure crisis of 2009, many economists expressed increasing concern about the level of credit card debt and efforts of banks to raise interest rates on...
-
1. Assume a 30% tax rate, and the Totals per financial statements provided. Complete the following schedule as per Figure 16.4. Assume that the Totals per financial statements (second to bottom row)...
-
Peran apa yang dapat dimainkan komite audit dalam mendeteksi dan/atau membatasi manajemen laba
-
Distinguish between factoring and invoice discounting. Explain the circumstances in which a company considering these two forms of finance would be likely to prefer factoring rather than invoice...
-
Assume that the one component unit had program revenues of \($30,000\) and expenses of \($42,000\) and spent \($10,000\) for land during Year 4. However, it should have been handled as a blended...
-
Large businesses should not have working capital problems. It is easy for them to borrow large sums on a long-term basis. The problem for large businesses is not working capital; it is excessive...
-
Susan Byrne, the CEO of Troy Industrial Designs (TID), has called a meeting to evaluate the present method of charging the two offices at Dublin and Shannon, Ireland for the shared services of the...
-
Discuss the effects on just in time of increasing proportions of manufacturing (for the UK) taking place in Eastern Europe, Africa and Asia.
-
Help I System Announcements Exercise 22-14 a-c Oriole Company had $234,200 of net income in 2019 when the selling price per unit was $151, the variable costs per unit were $91, and the fixed costs...
-
In the figure, two loudspeakers, separated by a distance of d1 = 2.63 m, are in phase. Assume the amplitudes of the sound from the speakers are approximately the same at the position of a listener,...
-
Find all transactions in which Hallagan sold eyeliner in the West region.
-
A prescription drug is produced in the United States and sold internationally. Each unit of the drug costs $60 to produce. In the German market, the drug sells for 150 per unit. The current exchange...
-
A roulette wheel contains the numbers 0, 00, 1, 2, ..., 36. Suppose you bet on each of 25 spins that 00 will show. After 25 spins, what is the chance you have won at least once?
-
An Euler circuit that visits every vertex _______________ a Hamilton cycle. Fill in the blank with is or is not to make the statement true.
-
Unlike in a Hamilton cycle, the vertex where the Hamilton path begins is _______________ the vertex where the Hamilton path ends. Fill in the blank with the same as or different from to make the...
-
Every cycle _______________ a circuit. Fill in the blank with is or is not to make the statement true.
Study smarter with the SolutionInn App