3 two decimal places, except in requirement a.) a. Use the MS Excel RATE function to determine the compound annual mite of growth in eamings (n=4). Annual growh rate b. Based on the growth rate determined in part a, project eamings for next year (E1). (Round to fwo places to the ight of the decimal point) Next years eamings, E1 c. Assume the dividend payout ratio is 40 percent. Compute (D1) (Round to two places to the right of the decimal point.) Next year's dividend, D1 d. The current price of the stock is $50. Uaing the growh rate (g) from part a and (D1) from part c, compute K. e. If the flotation cost is $3.75, compute the cost of new common stock (Ke)