Cost of Equity with and without Flotation
Javits & Sons' common stock currently trades at $29.00 a share. It is expected to pay an annual dividend of $2.00 a share at the end of the year (D1 = $2.00), and the constant growth rate is 7% a year.
What is the company's cost of common equity if all of its equity comes from retained earnings? Round your answer to two decimal places
b. If the company were to issue new stock, it would incur a 17% flotation cost. What would the cost of equity from new stock be? Round your answer to two decimal places
How do I solve this using excel step by step