Your task is to:
Select any two of these stocks, and calculate the most efficient portfolio (on a mean/variance basis) that you can create by using JUST THOSE TWO ASSETS .
a) Select two stocks – you may DELETE the rest. Delete the columns in the data file so you don't get confused.
b) What is (i.e., calculate) the BETA of each stock?
c) Use the One Factor Index Model (CAPM) to estimate the expected return of each. That is, use CAPM's Security Market Line equation to calculate the required rate of return, and assume that the Market is in equilibrium.
d) What is the weight of each (of your two) stock in the optimal portfolio?
e) What are the characteristics in expected return and in standard deviation of the optimal portfolio (of your two stocks)?
You have a client who wishes to have a portfolio with a rate of return of (expected) 10%. What mix of two of your two stocks and of money market funds (paying 2%) or margin borrowing (cost = 7%) would you recommend?