Please show excel formulas

Ninecent Corporation has a target capital structure of 70 percent common stock, 5 percent preferred stock, and 25 percent debt. Its cost of equity is 11 percent, the cost of preferred stock is 5 percent, and the pretax cost of debt is 6 percent. The relevant tax rate is 23 percent. What is the company's WACC? Input Area: \begin{tabular}{lr|} \hline Debt-equity ratio & 0.35 \\ Cost of equity & 11% \\ Cost of debt & 6% \\ Tax rate & 21% \\ \hline \end{tabular} (Use cells A6 to B9 from the given information to complete this question.) Output Area: Weight of debt Weight of equity WACC