Sandy Beaches Corp. has debt outstanding that has a market value of $$529$ million with a yield to maturity of $5\mathrm{.}4\%.$ The company's preferred stock has a market value of $$125$ million with a cost of preferred equity of $11\%$ and the company's common stock has a market value of $$750$ million with a cost of common equity of $15\mathrm{.}2\%.$ The company has a tax rate of $21\%.$ Answer Questions $24$ and $25$ based on this information.

Question $24$: What is the company's WACC before applying the tax shield?

Question $25$: What is the company's

WACC after applying the tax shield? PLEASE SOLVE USING THE EXCEL FUNCTIONS