The annual returns for Stock A and Stock B are given below.

Date	Stock A	Stock B
2010-12-31	-10.50%	44.50%
2011-12-31	-7.50%	22.50%
2012-12-31	-5.00%	5.75%
2013-12-31	7.75%	10.50%
2014-12-31	8.45%	20.75%
2015-12-31	12.50%	18.75%
2016-12-31	10.50%	7.75%
2017-12-31	7.50%	2.50%
2018-12-31	2.25%	12.50%
2019-12-31	15.50%	18.75%

Build a financial model in excel which includes the following:

1. Calculate the average annual return for each stock (1.5 marks)
2. Calculate the variance of returns for each stock (1.5 marks)
3. Calculate the standard deviation of the returns for each stock (1.5 marks)
4. Calculate the covariance of returns between the two stocks (1.5 marks)
5. Using the 10-year average return as the expected return for each stock, calculate the minimum variance portfolio consisting of Stock A and Stock B (2 marks)
6. Using the 10-year average return as the expected return for each stock, calculate the expected return and standard deviation of a portfolio consisting of 90% Stock A and 10% Stock B. (2 marks)
7. Find and show another portfolio weighting mixture with the similar standard deviation but with a higher expected return than the 90% A, 10% B portfolio. (2 marks)