Reference no: EM132040356
Investing in 2 risky assets and the risk free asset:
You consider investing in three assets: CVX, IBM, and the risk-free asset. You decide to use the following inputs:
E[rCVX]=7.6%, CVX=19.4%, E[rIBM]=9.8%, IBM=27.5%, rf=3.0%, CVX,IBM=0.239.
a. What is the expected return and standard deviation of the portfolio that invests w=25% in CVX and 75% in IBM? Make sure to indicate what formulas to use and to show your work.
b. Download the Excel spreadsheet PS3.xls from canvas and adapt it to put together a table that shows the risk return combinations of investing in CVX and IBM using 0.1 steps from w=0 to w=1 (same as the table in class for XOM and MSFT).
c. Which of the 11 portfolios in your table has the highest Sharpe ratio? Using the solver, find the weights in the optimal risky portfolio. To access the solver go to Data à solver, located at the top right of the screen. If you cannot find the solver, try going to File à Options à Add-Ins à Manage Excel Add-ins. (Hint: Choose the right target cell and choose ‘Max’). What is the expected return and standard deviation of the optimal risky portfolio?