You are considering investing in the following securities and have developed the probability distributions for their returns over the next year.

a. Calculate the expected return and standard deviation of each security.
b. Create a variance/covariance matrix for the four securities. See page 422 for an example of how to create a formula that uses probabilities instead of historical (equally weighted) data.
c. Using the Solver, create a set of 11 portfolios that make up the capital market line. Create a chart of the CML from your results, and add a plot of the original securities.
d. Find the weights of each security in the market portfolio by maximizing the Sharpe ratio.
e. How does the risk/return trade-off of the original securities compare to that available on the CML?

Transcribed Image Text:

Expected Returns Economic Outlook Probability OMG BRB NOOBT-bill:s Recession 0.10 -29% 9% 16% 3% -14% Slow growth Average Fast growth 0.20 3% 11% 3% 0.40 14% 7% 4% 3% 0.20 23% 11% 7% 3% Boom 0.10 34% | 14% 14% 3%