In Excel

Place your answer in the corresponding green answer cell for each question. The answer cell must contain a formula that references one or more cells in the work box or - no hard-coded numbers in the answer cell or the cell it references. 9. What is the standard deviation of returns on a portfolio that is invested 35% in both Stocks A and C, and 30% in Stock B? Rate of return if state occurs Stock A Stock B Stock C State of economy Probability of state occurring 8% 92% 11.60% Growth Stagnant 21.60% 7.40% 12.80% 7.20% 10.10% 10. A company recently paid its first annual dividend of $.75 a share and plans to increase the dividend by 2.3% per year indefinitely. What is the cost of equity if the current stock price is $5 a share