Expected return and standard deviation of the portfolio

Assignment Help Financial Management

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?

Reference no: EM132040356

Questions Cloud

Another put options on VGF at the money : To hedge you position, you can buy or sell VGF stock, or another put options on VGF at the money (i.e. with a strike price of 77).

Investing in the market portfolio : Your analysis suggest that the risk premium of the market is 6.2% and the standard deviation of stocks is 16.4%. what is the slope of the CML.

Difference in yields on bonds with the same time to maturity : Which of the following factors could explain difference in yields on bonds with the same time to maturity? Which of the following would affect supply of bonds.

Calculate standard deviation of equally weighted portfolios : You calculate the standard deviation of the equally weighted portfolios with 10, 20, and 50 assets.

Expected return and standard deviation of the portfolio : What is the expected return and standard deviation of the portfolio that invests w=25% in CVX and 75% in IBM?

Nonconventional typically refers to projects that : "Nonconventional" typically refers to projects that:

Cross over point for these mutually exclusive projects : What is the Cross Over point for these mutually Exclusive Projects?

Capital structure consists solely of debt-common equity : Hook Industries's capital structure consists solely of debt and common equity. What percentage of the company's capital structure consists of debt

Average return is equal to stock expected rate of return : If Sidman reinvests retained earnings in projects whose average return is equal to the stock's expected rate of return, what will be next year's EPS?

User Account

All Pages