PLEASE USE EXCEL FUNCTIONS ONLY, AND HIGHLIGHT the steps! thanks!

PLEASE USE EXCEL FUNCTIONS ONLY, AND HIGHLIGHT the steps! thanks!

PLEASE USE EXCEL FUNCTIONS ONLY, AND HIGHLIGHT the steps! thanks!

PLEASE USE EXCEL FUNCTIONS ONLY, AND HIGHLIGHT the steps! thanks!

6. Refer to the table containing the share price of company T and W below: Date 31-Dec-18 31-Jan-19 28-Feb-19 31-Mar-19 30-Apr-19 31-May-19 30-Jun-19 31-Jul-19 31-Aug-19 30-Sep-19 31-Oct-19 30-Nov-19 31-Dec-19 Share T price 4.09 4.15 4.56 4.43 4.80 4.81 5.11 4.62 4.25 4.23 4.00 4.21 5.04 Share W price 79.37 81.19 80.24 83.06 82.7 82.97 85.75 87.82 81.85 83.88 80.45 89.06 85.87 (a) Compute the returns for both companies. Please use the return definition used in the labs. (1 mark) (b) Compute the average return and standard deviation for each of the returns. (2 marks) (c) Compute the Covariance between the returns. Provide a brief interpretation of what the Covariance measures. (2 marks) (d) Assume that you construct a portfolio where you invest 40% in company T and 60% in company W. What is the average return and standard deviation of this portfolio? (2 marks) (e) Assume that you construct a portfolio where you invest 60% in company T and 40% in company W. What is the average return and standard deviation of this portfolio? (2 marks) (f) Based on the calculation in parts (d) and (e) above, which portfolio weighting you would like to choose, i.e., 40% in company T and 60% in company W or 60% in company T and 40% in company W? Please provide your reasoning. (1 mark)