Please use excel to solve and show working

CE ste BIU 7 - A Cells Editing Alignment Number Conditional Format as Cell Formatting Table 1 Styles Styles oboard F Font V for AB D E F H 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 the portfolio? The standard deviation? Stock B 0.45 State Boom Good Poor Bust Probability 0.10 0.60 025 0.05 Stock A 0.35 0.16 (0.00 (012) 0.10 Stock C 0.27 008 (0.04) (0.09) 10:06) 10.20) weights 0.30 0:40 0.30 Complete the following analysis. Do not hard code values in your calculations. Portfolio Return Product Return Deviation Squared Deviation Product B State Boom Good 9 Sheet1