10-32 Spreadsheet Problem Build a spreadsheet that automatically computes the expected market return and risk for different assumptions about the state of the economy. a. First, create a spreadsheet like the one shown below and compute the expected return and standard deviation. A B State of Economy Probability of State Expected Market Return 2 Fast growth 0.13 35% 3 Slow growth 0.42 17% 4 No growth 0.25 3% 5 Recession 0.18 -15% 6 Depression 0.02 -30% 7 09 Sum= 1.00 9 Expected return = Standard deviation = 10 b. Compute the expected return and risk for the following two scenarios: A B 1 State of Economy Probability of State Expected Market Return 2 Fast growth 0.13 30% 3 Slow growth 0.33 15% 4 No growth 0.30 2% 5 Recession 0.20 -18% 6 Depression 0.04 -25% A B 1 State of Economy Probability of State Expected Market Return 2 Fast growth 0.15 40% 3 Slow growth 0.35 18 4 No growth 0.34 4 5 Recession 0.15 -20 6 Depression 0.01 -35