60 40 401 30 Assets Existing New Portfolio Portfolio ALUWORK AGA 30 Lyxor Required 1. Using the annual return data provided in Exhibit 1 of the case for ALUWORKS and AGA, calculate their mean returns, standard deviations, covariance, and correlation. With these numbers, calculate the standard deviation and return for Desiree Mofakye's entire portfolio (6 marks). 2. After adding Lyxor USDJIA, what is the portfolio's new standard deviation and return? How does the new portfolio compare with the calculation in Question 1? 6 marks). 3. Based on your data analysis, should Desiree Mofakye diversify her portfolio or remain invested in SA and GHANA only? 6 marks). 4. Calculate the betas of ALUWORKS, AGA, and Lyxor USDJIA. To calculate the covariance with the market proxy, use the Lyxor World return data shown in Exhibit 1 in the case. Assuming a risk-free rate of 2.5 per cent and a market risk premium of 5.5 per cent, what are the required returns for each of the three ETFs? (6 marks). 5.Calculate the existing portfolio's beta and the new portfolio's beta. Assuming a risk-free rate of 2.5 percent and a market risk premium of 5.5 per cent, what are the two portfolios' required returns? (6 marks). 60 40 401 30 Assets Existing New Portfolio Portfolio ALUWORK AGA 30 Lyxor Required 1. Using the annual return data provided in Exhibit 1 of the case for ALUWORKS and AGA, calculate their mean returns, standard deviations, covariance, and correlation. With these numbers, calculate the standard deviation and return for Desiree Mofakye's entire portfolio (6 marks). 2. After adding Lyxor USDJIA, what is the portfolio's new standard deviation and return? How does the new portfolio compare with the calculation in Question 1? 6 marks). 3. Based on your data analysis, should Desiree Mofakye diversify her portfolio or remain invested in SA and GHANA only? 6 marks). 4. Calculate the betas of ALUWORKS, AGA, and Lyxor USDJIA. To calculate the covariance with the market proxy, use the Lyxor World return data shown in Exhibit 1 in the case. Assuming a risk-free rate of 2.5 per cent and a market risk premium of 5.5 per cent, what are the required returns for each of the three ETFs? (6 marks). 5.Calculate the existing portfolio's beta and the new portfolio's beta. Assuming a risk-free rate of 2.5 percent and a market risk premium of 5.5 per cent, what are the two portfolios' required returns? (6 marks)