Consider the following information. Your portfolio is invested 30 percent each in A and C, and 40 percent in B. What is the expected return of the portfolio? What is the variance of this portfolio? The standard deviation? Input area: State Boom Good Poor Bust weights Output area: Probability State Boom Good Poor Bust 0.15 0.45 0.30 0.10 Standard deviation Stock A 0.35 0.16 (0.01) (0.10) 0.30 E(R) Stock B (Use cells A6 to E11 from the given information to complete this question.) 0.40 0.17 (0.03) (0.12) 0.40 Probability Portfolio return Product Stock C 0.28 0.09 0.01 (0.09) 0.30 Return deviation Squared deviation Variance Product.

Can you please add excel equations with'!

Consider the following information. Your portfolio is invested 30 percent each in A and C, and 40 percent in B. What is the expected return of the portfolio? What is the variance of this portfolio? The standard deviation? Input oreo: (Use cells AG to E11 from the given information to complete this question.)