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 415 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 5 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. 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 Recession Slow growth Average Fast growth Boom Probability 0.05 0.25 0.40 0.25 0.05 OMG -32% -15% 16% 25% 38% BRB -10% 3% NOOB 18% 12% 490 -8% 16% | T-bills 3% 3% 3% 3% 3% 12% 16%