You have done your research for the following investments and your friend has provided their expectations for the markets for next year.

State of Economy	Probability of State of Economy	Stock A	Stock B	TSX
Boom	.30	30%	-9%	18%
Normal	.40	16%	12%	10%
Recession	.30	-10%	20%	-10%

1. Calculate the expected return for stock A. (2 marks)

2. Calculate the expected return for stock B. (2 marks)

3. Calculate the expected return for the TSX. (2 marks)

4. Calculate the risk for stock A. (2 marks)

5. Calculate the risk for stock B. (2 marks)

6. Calculate the risk for the TSX. (2 marks)

7. Calculate the covariance and correlation of the returns for stock A and stock B. (2 marks)

8. Calculate the covariance and correlation of the returns for stock A and the TSX. (2 marks)

1. Calculate the covariance and correlation of the returns for stock B and the TSX. (2 marks)

10. Calculate the beta of Stock A. (2 marks)

11. Calculate the beta of stock B. (2 marks)

12. Calculate the beta for the TSX. (2 marks)

13. 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)