Question: 7. Redo your analysis adding a new riskfree security that has a return of 0.5% each month. Include a weight for this security when calculating


7. Redo your analysis adding a new riskfree security that has a return of 0.5% each month. Include a weight for this security when calculating the monthly portfolio returns. That is, there will now be 13 weights, one for each of the 12 stocks and one for the riskfree security. Again, these weights must sum to one. Allow for short sales, and use Solver to calculate the (annual) portfolio standard deviation when the annual portfolio returns are set to 5%, 10%, 20%, 30%, and 40%. Plot the results on the same XY Scatter Plot, and in addition keep track of the portfolio weights of the optimal portfolio. What do you notice about the relative weights of the different stocks in the portfolio as you change the target return? Can you identify the tangent portfolio
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
