- Use Excel and solve the following problem. Note that to answer question 1 and 2, you must use MMULT, not linear equation. Submit your excel file by 11/18/2020, 11:59 pm. There is a portfolio, which consist of two stocks: Amazon (AMZN) and Bank of America (BAC). The weight on AMZN is 0.43 and the weight on BAC is 0.57. The average monthly returns for AMZN and BAC are 1.2% and 0.7%, respectively. The standard devisions for AMZN and BA are 1.57% and 0.83%. The covariance between AMZN and BAC is 0.337%. 1. Calculate a portfolio return. 2. Calculate a portfolio risk (standard deviation). 3. Plot an efficient frontier using two assets. (Hint: Use "Data Table")