In: Finance
Rate of Return If State Occurs | ||||||||||||
State of | Probability of | |||||||||||
Economy | State of Economy | Stock A | Stock B | Stock C | ||||||||
Boom | .15 | .39 | .49 | .29 | ||||||||
Good | .55 | .15 | .20 | .08 | ||||||||
Poor | .25 | −.01 | −.09 | −.07 | ||||||||
Bust | .05 | −.20 | −.24 | −.10 | ||||||||
a. |
Your portfolio is invested 24 percent each in A and C, and 52 percent in B. What is the expected return of the portfolio? (Do not round intermediate calculations and enter your answer as a percent rounded to 2 decimal places, e.g., 32.16.) |
b-1. | What is the variance of this portfolio? (Do not round intermediate calculations and round your answer to 5 decimal places, e.g., .16161.) |
b-2. | What is the standard deviation? (Do not round intermediate calculations and enter your answer as a percent rounded to 2 decimal places, e.g., 32.16.) |
Please refer to below spreadsheet for calculation and answer. Cell reference also provided.
Cell reference -