Question 4(23 marks/Risk Return and CAPM Theo has $600,000 to invest and is considering the merits of two securities. She is interested in the common shares of Corporation X and Corporation Y. The possible annual rate of return of security is shown as below Possible Annual Rate of Return of Security in 2018: State of Affair Boom Normal Recession Probability 0.2 0.6 0.2 Stock X 25% 15% -10% Stock Y -5% 10% 20% Each part is independent (a) Calculate the expected rate of return and variance of rate of return of Stock X and Stock Y (8 marks) Assuming the weight of Stock X is 30% and the weight of Stock Y is 70%, calculate the expected rate of return and variance of the portfolio. Compare the portfolio risk with the risk of the stocks and explain the difference, if any (b) (10 marks) If the risk-free rate is 2%, the market risk premium is 10%, the beta of Stock X is 18 and the beta of Stock Y is 1.2, calculate the beta and the required rate of return of the portfolio as stated in part (b) And determine whether the portfolio is overpriced or underpriced. (c) (5 marks) Pls teach me the calculation part of (b) & (c) only but not using excel; only by using formula