I would prefer a MS Excel spreadsheet created for these answers if possible. Thank you kindly.

Cost of capital Edna Recording Studios, Inc., reported earnings available to common stock of $4,400,000 last year. From those earnings, the company paid a dividend of $1 .22 on each of its 1,000,000 common shares outstanding. The capital structure of the company includes 40% debt, 25% preferred stock, and 35% common stock. It is taxed at a rate of 35%. a. If the market price of the common stock is $49 and dividends are expected to grow at a rate of 8% per year for the foreseeable future, what is the company's cost of retained earnings nancing? b. If underpricing and otation costs on new shares of common stock amount to $5 per share, what is the company's cost of new common stock nancing? c. The company can issue $2.43 dividend preferred stock for a market price of $27 per share. Flotation costs would amount to $5 per share. What is the cost ofprefened stock nancing? d. The company can issue $1,000-parvalue, 11% coupon, 12-year bonds that can be sold for $1,110 each. Flotation costs would amount to $35 per bond. Use the estimation fon'nula to gure the approximate after-tax cost of debtnancing? e. What is the WACC