Consider the following information: State of Economy Inflationary Recession Probability of State of Economy 0.60 0.40 Rate of Return if State Occurs Stock A Stock B Stock C 0.18 0.04 0.31 0.03 0.16 -0.11 Required: What is the expected return on a portfolio invested 20% each in Stock A and Stock B and 60% in Stock C? What is the variance and standard deviation of the portfolio? Show the work in Excel with formula Consider the following information: State of Economy Inflationary Recession Probability of State of Economy 0.60 0.40 Rate of Return if State Occurs Stock A Stock B Stock C 0.18 0.04 0.31 0.03 0.16 -0.11 Required: What is the expected return on a portfolio invested 20% each in Stock A and Stock B and 60% in Stock C? What is the variance and standard deviation of the portfolio? Show the work in Excel with formula