Using the Solver Add-in function in Excel, determine the optimal weights for the 4 assets in...

Transcribed Image Text:

Using the Solver Add-in function in Excel, determine the optimal weights for the 4 assets in your portfolio. Optimal weights will be those that give you a portfolio with the highest mean return for a given level of risk (hint: you want to maximise the Sharpe Ratio by allowing the weights for each asset to change). You must provide detailed record of solver procedures. Note: Assume NO borrowing is allowed, you will need to constrain each of the weights to be between 0 and 1. Please provide a brief summary of your analysis of Part B in the Word document (max 1 page). Using the Solver Add-in function in Excel, determine the optimal weights for the 4 assets in your portfolio. Optimal weights will be those that give you a portfolio with the highest mean return for a given level of risk (hint: you want to maximise the Sharpe Ratio by allowing the weights for each asset to change). You must provide detailed record of solver procedures. Note: Assume NO borrowing is allowed, you will need to constrain each of the weights to be between 0 and 1. Please provide a brief summary of your analysis of Part B in the Word document (max 1 page).