I would choose stock A as it has a lower selling price of $35.00, pays a higher dividend or $4.50 and the required rate of return is this same.D1 = 6, P0=100 (50), Ks = 11% (15%)SO we have P0 = D1/(Ks-g)or g = Ks D1/P0 = 11% 6/100 = 5%So P1 = D1*(1+g)/(Ks-g) = 6*(1+5%)/(11%-5%) = $105.00So Stock price should be $105.00 for giving a 11% return.#3- You are considering three investments.Using the panel of Excel data on the next page and the Stocks Support Template 2015.xlsx that shows the formulas in the cells, answer these questions: