If you could please show how to do it on excel that would be great. Will be sure to leave a like.

N [ M 3. Eva invested in two stocks. She put 22% into stock A, which has an expected return of 11.9%, and the rest into stock B, with an expected return of 18.6%. What is the expected return of her portfolio? (Note: Round your answer to 3 decimal places.) 4. You are interested in investing in a British company that expects to grow steadily at an annual rate of 6 percent for the foreseeable future. The firm paid a dividend of 2.30 last year. If your required rate of return is 10 percent, what is the most you would be willing to pay for this stock? (Round to the nearest Pound). A. 24 B. 29 C. 58 D. 61