Question: 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


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 stock 3 . 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, 5&P500 index and the two portfolios. (60 points) 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 stock 3 . 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, 5&P500 index and the two portfolios. (60 points)
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
