1. What is the expected rate of return for an equal-weighted portfolio consisting of stock A and stock B? The expected return of stock A is 10% and the expected return of stock B is 12%.

2. What is the expected rate of return for an value-weighted portfolio consisting of stock A and stock B? The expected return of stock A is 10% and the expected return of stock B is 12%. The market value of stock A in the portfolio is $10 million and the market value of stock B in the portfolio is $20 million.

Please use Excel spreadsheet to calculate