k_cs (cost of cs, internal common, retained earnings)

common stockholders recently received $2 dividend per share , and they expect dividends to grow at an annual rate of 10%. if market price of the security is $50, the investor's required rate of return, k_cs is ? k_nc (cost of new cs, external common)

refer to k_cs case above. if flotation costs are 15% of market price, the cost of new cs, k_nc ? pls answer in excel