In: Finance
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