Consider the following information on returns and probabilities:

State Probability X Z

Boom .25 15% 10%

Normal .60 10% 9%

Recession .15 5% 10%

Use a spreadsheet application (Excel Worksheet) to compute the following:

1) expected return and standard deviation for a Fund-X

2) expected return and standard deviation for a Fund-Z

3) portfolio return if an investment of $6,000 in Fund X and $4,000 in Fund Z

4) portfolio risk based on an investment of $6,000 in Fund X and $4,000 in Fund Z