1. Open the "Portfolio Risk and Return_Student" Excel file. In the "Student ID" worksheet, please put in your Name, Student ID (UIN) and select your course CRN. You must put in all information for asset return data to be displayed correctly. 2. Check the "Given Asset Monthly Return Data" worksheet, you will find three individual stocks and S\&P500 index monthly return data for 5 years ( 60 months). 3. In the "Answer Sheet" worksheet, use cell reference, please transfer the individual stock return data from "Given data" sheet to the "Answer Sheet". 4. Please build two portfolios: - Two stock portfolio of equal weighted stock1 and stock2. - Three stock portfolio of equal weighted stock1, stock2 and stock3. Calculate the above two portfolios' monthly return for the same 5 years. ( 20 points) 5. Calculate Average monthly returns and monthly volatilities for all individual stocks, S\&P500 index and the two portfolios. ( 60 points) 6. Click on "Portfolio Risk and Return Excel Project" and submit your Excel file. 1. Open the "Portfolio Risk and Return_Student" Excel file. In the "Student ID" worksheet, please put in your Name, Student ID (UIN) and select your course CRN. You must put in all information for asset return data to be displayed correctly. 2. Check the "Given Asset Monthly Return Data" worksheet, you will find three individual stocks and S\&P500 index monthly return data for 5 years ( 60 months). 3. In the "Answer Sheet" worksheet, use cell reference, please transfer the individual stock return data from "Given data" sheet to the "Answer Sheet". 4. Please build two portfolios: - Two stock portfolio of equal weighted stock1 and stock2. - Three stock portfolio of equal weighted stock1, stock2 and stock3. Calculate the above two portfolios' monthly return for the same 5 years. ( 20 points) 5. Calculate Average monthly returns and monthly volatilities for all individual stocks, S\&P500 index and the two portfolios. ( 60 points) 6. Click on "Portfolio Risk and Return Excel Project" and submit your Excel file