PLEASE POST THE EXCEL FORULUMAS AND SOLVE IN EXCEL!!!!!

1 6. The following table contains the probability distribution for the returns of three securities over the next year. Expected Returns Scenario Probability II III T-bills NI 0.03 -17% 5% 33% 3% #2 0.07 .9% 11% 17% 3% 3 0.15 7% 17% 79% N4 0.50 14% 25% 1% 3% NS 0.15 19% 2994 -9% 3% 0,07 27% 34% -17% 3% 27 35% 44% -27% 3% a) Determine the expected return and standard deviation of each security b) Calculate a variance and covariance matrix for these four securities using the given probabilities. c) Calculate a set of five portfolios that make up the capital market line using the Solver. d) Create a chart of the CML including the original securities 16 0,03