Please show all steps in excel format and formulas. Thank you.

The company estimates that it can issue debt at a rate of rd=11%, and its tax rate is 25%. It can issue preferred stock that pays a constant dividend of $4.00 per year at $55.00 per share. Also, its common stock currently sells for $43.00 per share; the next expected dividend, D 1, is $4.25; and the dividend is expected to grow at a constant rate of 6% per year. The target capital structure consists of 75% common stock, 15% debt, and 10% preferred stock. a. What is the cost of each of the capital components? Do not round intermediate calculations. Round your answers to two decimal places. Cost of debt: (3) Cost of preferred stock: (3) Cost of retained earnings: (3) b. What is Adamson's WACC? Do not round intermediate calculations. Round your answer to two decimal places. (3)