Use the Excel spreadsheet and discuss your findings. This should include: · A discussion of the main statistics, such as · the expected return for each stock, · the standard deviation for each stock,...

I need the questions in the Word document answered but using the information in the Excel spreadsheet.



Use the Excel spreadsheet and discuss your findings. This should include: · A discussion of the main statistics, such as · the expected return for each stock, · the standard deviation for each stock, the expected return of the portfolio of the two stocks you selected using the various percentages allocated to each (50%-50%, 75%-25%, 25%-75%) provided in the sheet, · the standard deviation for each portfolio of the two stocks you selected using the various percentages allocated to each (50%-50%, 75%-25%, 25%-75%), · the beta of each stock, · the beta of a portfolio of the two stocks using the percentages allocated to each (50%-50%, 75%-25%, 25%-75%). · Be sure to discuss some of the key concepts too (e.g., point out the standard deviation of the portfolio is less than the weighted average of the standard deviations of the stocks in the portfolio) · Compute the coefficient of variation for the three different allocations · Which of the three (i.e., the 50-50%, 75-25%, or 25-75%) offers the best risk-return profile?