The company estimates that it can issue debt at a rate of $r_d=12\%,$ and its tax rate is $25\%.$ It can issue preferred stock that pays a

constant dividend of $$6\mathrm{.}00$ per year at $$50\mathrm{.}00$ per share. Also, its common stock currently sells for $$30\mathrm{.}00$ per share; the next

expected dividend, $D_1,$ is $$3\mathrm{.}50,$ and the dividend is expected to grow at a constant rate of $4\%$ per year. The target capital

structure consists of $70\%$ common stock, $10\%$ debt, and $20\%$ preferred

stock.

What is the cost of each of the capital components? That is$,$ what is the cost of debt, cost of preferred, and cost of equity?

What is Serenity's Super Sopapillas' WACC?

Only projects with expected returns that exceed the WACC will be accepted. Which projects should Serenity's Super

Sopapillas accept? What is the dollar amount of Serenity's Super Sopapillas' optimal capital budget?

I would like this laid out in excel with proper formulas to show my work.