2. Check tho "Given Asset Monthly Return Data' worksheet, you will find three individual stocks and S\&P500 index monthly rehurn datia for 5 years ( 60 months) 3. In tho "Answer Sheot" worksheet, use cell reference, please transfer the individual stock retum data from "Given data" sheet fo ithe "Answer Sheel" 4. Please build two portiolios: - Two stock portfolio of equal weighted stock 1 and stock? - Three stock porttolio of equat weighted stock 1 , stock 2 and stock3 Calculate the above two portfolios' monthly return for the same 5 yeare, ( 20 points) 5 Calculate Average monthly returns and monthly volatilities for all individual stocks, 38P500 index and the two portfollos. (60 points) Aigniment 559 2. Check tho "Given Asset Monthly Return Data' worksheet, you will find three individual stocks and S\&P500 index monthly rehurn datia for 5 years ( 60 months) 3. In tho "Answer Sheot" worksheet, use cell reference, please transfer the individual stock retum data from "Given data" sheet fo ithe "Answer Sheel" 4. Please build two portiolios: - Two stock portfolio of equal weighted stock 1 and stock? - Three stock porttolio of equat weighted stock 1 , stock 2 and stock3 Calculate the above two portfolios' monthly return for the same 5 yeare, ( 20 points) 5 Calculate Average monthly returns and monthly volatilities for all individual stocks, 38P500 index and the two portfollos. (60 points) Aigniment 559