Only need parts D and E, step by step would be greatly appreciate, especially an excel formula. Thanks

Cost of capital Edna Recording Studios, Inc., reported earnings available to common stock of $4,800,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 45% debt, 25% preferred stock, and 30% common stock. It is taxed at a rate of 24%. a. If the market price of the common stock is $48 and dividends are expected to grow at a rate of 6% per year for the foreseeable future, what is the company's cost of retained earnings financing? b. If underpricing and flotation costs on new shares of common stock amount to $8 per share, what is the company's cost of new common stock financing? c. The company can issue $2.46 dividend preferred stock for a market price of $33 per share. Flotation costs would amount to $4 per share. What is the cost of preferred stock financing? d. The company can issue $1,000-par-value, 11% coupon, 12-year bonds that can be sold for $1,240 each. Flotation costs would amount to $20 per bond. Use the estimation formula to figure the approximate after-tax cost of debt financing? e. What is the WACC? a. If the market price of the common stock is $48 and dividends are expected to grow at a rate of 6% per year for the foreseeable future, the company's cost of retained earnings financing is 8.69 %. (Round to two decimal places.) b. If underpricing and flotation costs on new shares of common stock amount to $8 per share, the company's cost of new common stock financing is 9.23 %. (Round to two decimal places.) c. If the company can issue $2.46 dividend preferred stock for a market price of $33 per share, and flotation costs would amount to $4 per share, the cost of preferred stock financing is 8.48 %. (Round to two decimal places.) d. If the company can issue $1,000-par-value, 11% coupon, 12-year bonds that can be sold for $1,240 each, and flotation costs would amount to $20 per bond, using the estimation formula, the approximate after-tax cost of debt financing is 6.28 %. (Round to two decimal places.) e. Using the cost of retained earnings, Ir, the firm's WACC, ra, is 7.55 %. (Round to two decimal places.) Using the cost of new common stock, rn, the firm's WACC, ra, is 7.71 %. (Round to two decimal places.)