Consider the following information on a portfolio of three stocks. If your portfolio is invested 40 percent each in stock A and B, and 20 percent in stock C, what is the expected return, variance and standard deviation of the portfolio? (Can you please include all excel functions so I learn where the answers are coming from, thank you so much!)

3 4 s 6 7 Consider the following information on a portfolio of three stocks. If your portfolio is invested 40 percent each in stock A and B, and 20 percent in stock C, what is the expected return, variance and standard deviation of the portfolio? 10 12 13 Input area: us 16 17 8 19 0.15 0.33 State Boom Normal Bus: 0.60 0.25 0.04 0.09 0.15 0.13 (0.14) 0.55 0.19 (0.28) 0.40 0.40 0.20 2 3 es Output area: e7 8 Return Squared Portfolio Return 20 11 12 13 State Boom Poor Bus! S Expected Return: E(R) - 1000 27 Variance 18 19 10 Standard Deviation 32 23