You have done your research for the following investments and your friend has provided their expectations for the markets for next year. Probability of State of State of Stock Stock Economy Economy B TSX Boom .30 30% -9% 18% Normal .40 16% 12% 10% Recession .30 -10% 20% -10% * Remember to show all of your work * j. Calculate the beta of Stock A. (2 marks) k. Calculate the beta of stock B. (2 marks) 1. Calculate the beta for the TSX. (2 marks) m. Using an excel spreadsheet and the calculations you have done above, prepare a spreadsheet that provides the expected returns and the risk for a portfolio that invests in stock A and stock B. Prepare the calculations using 4% increments in the weights. (10 marks) You have done your research for the following investments and your friend has provided their expectations for the markets for next year. Probability of State of State of Stock Stock Economy Economy B TSX Boom .30 30% -9% 18% Normal .40 16% 12% 10% Recession .30 -10% 20% -10% * Remember to show all of your work * j. Calculate the beta of Stock A. (2 marks) k. Calculate the beta of stock B. (2 marks) 1. Calculate the beta for the TSX. (2 marks) m. Using an excel spreadsheet and the calculations you have done above, prepare a spreadsheet that provides the expected returns and the risk for a portfolio that invests in stock A and stock B. Prepare the calculations using 4% increments in the weights. (10 marks)