Homework: Finance Managers
You can download data for the following questions from yahoo finance.
Pick two stocks, say Walmart and IBM. Look at their monthly closing prices for last 4 years and
• Calculate Beta for each of them.
• Using the CAP.M. model, calculate the expected return for each. Assume a market risk premium of 8% and risk free rate of 4%.
• Calculate the standard deviation for each stock.
• Calculate the correlation coefficient between the two stocks.
• Form portfolios of the two stocks by changing their weights between zero and one hundred percent and measure the risk and return of those portfolios
• Using excel, graph the efficient frontier.
Format your homework according to the following formatting requirements:
o The answer should be typed, using Times New Roman font (size 12), double spaced, with one-inch margins on all sides.
o The response also includes a cover page containing the title of the homework, the student's name, the course title, and the date. The cover page is not included in the required page length.
o Also include a reference page. The Citations and references must follow APA format. The reference page is not included in the required page length.