XI - - = Data Sheet (1) [Protected View] - Microsoft Excel (Product Activation Failed) File Home Insert Page Layout Formulas Data Review View OX Protected View This file originated from an Internet location and might be unsafe. Click for more details. Enable Editing A1 fx Date x > 0 G H I J K L M M N o P Q R A 482 ###### 483 ###### 484 ###### 485 ###### E 11.68 11.59 10.5 486 ###### 487 ###### 488 ###### 489 ###### 490 ###### 491 ###### 492 ###### 493 ###### 494 ###### 495 4/1/2020 496 4/2/2020 497 4/3/2020 498 4/6/2020 499 4/7/2020 500 4/8/2020 501 4/9/2020 502 ###### 503 B 23 24 19.92 19.06 12.76 9.9 12.44 8.9 11.21 15 19.41 19.1 18.4 18.8 20.66 20.15 19.55 20.12 21.06 19.88 22 28.4 32.35 31.47 31.72 36.46 37.32 37.85 35.59 37.05 36.69 35.87 37.9 36.59 38.9 38.52 39.31 39.51 39.61 40.36 38.41 D 178.49 216.11 174.51 172.33 170.67 171.33 159.86 159.41 168 168 182.17 166.47 182.81 187.45 195.5 190 182.02 191.37 183.18 182.91 189.5 10.71 10.02 8.82 9.33 8.21 8.8 9.31 9.22 8.76 9 9.09 9.63 9.08 8.64 F 1.47 1.425 1.28 1.18 1.1 0.99 1.095 0.905 1.07 1.145 1.28 1.145 1.325 1.34 1.335 1.325 1.23 1.365 1.31 1.29 1.37 9 38.61 40.02 9.13 9.36 9.48 504 505 506 507 50s K Ready Activate Windows Go to Settings to activate Windows Data Sheet E 100% + 3:31 PM O Type here to search gi gi 9/10/2020 Prime Video C Get Homework He X C2) Review The Belc x m Assignment X MP124 Corporate X Untitled Spreadsh: x G screenshot in hp + 0 E File C:/Users/Best%20Point/Downloads/MP124%20Corporate%20Finance%20Assignment.pdf : You have recently inherited some money from a wealthy uncle. Part of the condition of the inheritance requires that you invest this money wisely so that you have money to live on in your old age. Luckily, you have been studying corporate finance and have acquired some skills to help with your investment. Your uncles 'Will didn't stipulate how you should invest this money. However, as part of the requirements you must produce a report showing how you intend to invest the money before you have access to it. A friend has suggested five stocks that you should consider investing in. He has downloaded for you the prices of these stocks for the last 2-3 years (this is in the data sheet). Task: (a) (b) (c) (d) (e) Conduct a brief analysis of the five companies (max 1500 words). Calculate the risk and return of all five companies as well as the market. In reporting your findings annualise the average return and standard deviation. Indicate the best and worst performing stocks. Calculate covariance/correlation of the stocks. Calculate the expected return and standard deviation of an equally waited portfolio (investing 20% into each share) Your inheritance was $1million. How many shares would you invest in each of the 5 stocks (assuming the equally weighted portfolio - Price based on closing price on 30th April). Explain your decision in doing so. If you have an opportunity to invest in a market portfolio, how well did you portfolio perform compared to the market portfolio? Using the closing price on 28th September, what is the value of your portfolio on this date? (f) (g) (h) Required: Activate Windows Go to Settings to activate Windows. Answer each of the above questions and present it back as a report. XI - - = Data Sheet (1) [Protected View] - Microsoft Excel (Product Activation Failed) File Home Insert Page Layout Formulas Data Review View OX Protected View This file originated from an Internet location and might be unsafe. Click for more details. Enable Editing A1 fx Date x > 0 G H I J K L M M N o P Q R A 482 ###### 483 ###### 484 ###### 485 ###### E 11.68 11.59 10.5 486 ###### 487 ###### 488 ###### 489 ###### 490 ###### 491 ###### 492 ###### 493 ###### 494 ###### 495 4/1/2020 496 4/2/2020 497 4/3/2020 498 4/6/2020 499 4/7/2020 500 4/8/2020 501 4/9/2020 502 ###### 503 B 23 24 19.92 19.06 12.76 9.9 12.44 8.9 11.21 15 19.41 19.1 18.4 18.8 20.66 20.15 19.55 20.12 21.06 19.88 22 28.4 32.35 31.47 31.72 36.46 37.32 37.85 35.59 37.05 36.69 35.87 37.9 36.59 38.9 38.52 39.31 39.51 39.61 40.36 38.41 D 178.49 216.11 174.51 172.33 170.67 171.33 159.86 159.41 168 168 182.17 166.47 182.81 187.45 195.5 190 182.02 191.37 183.18 182.91 189.5 10.71 10.02 8.82 9.33 8.21 8.8 9.31 9.22 8.76 9 9.09 9.63 9.08 8.64 F 1.47 1.425 1.28 1.18 1.1 0.99 1.095 0.905 1.07 1.145 1.28 1.145 1.325 1.34 1.335 1.325 1.23 1.365 1.31 1.29 1.37 9 38.61 40.02 9.13 9.36 9.48 504 505 506 507 50s K Ready Activate Windows Go to Settings to activate Windows Data Sheet E 100% + 3:31 PM O Type here to search gi gi 9/10/2020 Prime Video C Get Homework He X C2) Review The Belc x m Assignment X MP124 Corporate X Untitled Spreadsh: x G screenshot in hp + 0 E File C:/Users/Best%20Point/Downloads/MP124%20Corporate%20Finance%20Assignment.pdf : You have recently inherited some money from a wealthy uncle. Part of the condition of the inheritance requires that you invest this money wisely so that you have money to live on in your old age. Luckily, you have been studying corporate finance and have acquired some skills to help with your investment. Your uncles 'Will didn't stipulate how you should invest this money. However, as part of the requirements you must produce a report showing how you intend to invest the money before you have access to it. A friend has suggested five stocks that you should consider investing in. He has downloaded for you the prices of these stocks for the last 2-3 years (this is in the data sheet). Task: (a) (b) (c) (d) (e) Conduct a brief analysis of the five companies (max 1500 words). Calculate the risk and return of all five companies as well as the market. In reporting your findings annualise the average return and standard deviation. Indicate the best and worst performing stocks. Calculate covariance/correlation of the stocks. Calculate the expected return and standard deviation of an equally waited portfolio (investing 20% into each share) Your inheritance was $1million. How many shares would you invest in each of the 5 stocks (assuming the equally weighted portfolio - Price based on closing price on 30th April). Explain your decision in doing so. If you have an opportunity to invest in a market portfolio, how well did you portfolio perform compared to the market portfolio? Using the closing price on 28th September, what is the value of your portfolio on this date? (f) (g) (h) Required: Activate Windows Go to Settings to activate Windows. Answer each of the above questions and present it back as a report