Hi! Could you help me solve this question,please. Thank you.

Question 12 (answer all parts) You are asked to compare the following securities: a treasury bill, FTSEALL Index (market portfolio), HighSpeed PLC (a telecommunication company stock), WaterField PLC (a utility company stock) and Metal-Gold PLC (a counter-cyclical company stock). You have collected annual stock prices of each of them and calculated the realized returns for 6 years. You report all realized returns in Table 1 below. HighSpeed WaterField Metal-Gold year Treasury bill FTSEALL PLC PLC PLC 2009 3% -4% -3% 5% 14% 2010 2% -2% 2% 6% 6% 201 1 1% 3% 7% 4% 3% 2012 1% 7% 12% 5% -5% 2013 1% 11% 12% 6% -7% 2014 1% 12% 14% 7% -11% a) Calculate the excess return of each realized return for each security in Table 1. (3 marks) b) Use the excess returns in part a) to calculate the historical average excess returns and volatilities of each security. Show your calculations through the exercise and briefly comment on the results. (You make the assumption that each historical average excess return is a good proxy of the expected return of each security) (6 marks) c) Now using the information in part b), calculate the beta of each security. Briefly interpret the results. (6 marks) d) Once you have calculated the required rate of return of each security using the CAPM formula, indicate whether each security is undervalued or overvalued and explain why