I need help with 9-2,9-9,9-11. I need it in a spread excel spread sheet

\fb. A new common stock issue that paid a $1.80 dividend last d. 6. year. The par value of the stock rcent per year. This growth rate any maintains a constant $2750, but 5 percent is 5515, and earnings per share have grown at a rate of 7 pe IS expected to continue into the foreseeable future. The comp dividend-earnings ratio of 30 percent. The price of this stock is now flotation costs are anticipated. the common stock is $43. The Internal common equity when the current market price of hereafter at a 7 percent an- expected dividend this coming year should be $3 .50, increasing t nual growth rate. The corporation's tax rate is 34 percent. A preferred stock paying a 9 percent dividend on a $150 par value. If a new issue is offered, flotation costs will be 12 percent of the current price of $175 . A bond selling to yield 12 percent after flotation costs, but before adjusting for the marginal corporate tax rate of 34 percent. In other words, 12 percent is the rate that equates the net proceeds from the bond With the present value of the future cash flows (principal and interest). 9-2. (Cost ofeqm'ty) Salte Corporation is issuing new common stock at a market price of $27. Divi- dends last year were $145 and are expected to grow at an annual rate of 6 percent forever. Flora- tion costs will be 6 percent of market price. What is Salte's cost of equity