Please show me how to calculate this in Excel

Calculate the WACC with below data:

Tax Rate $30\%$

The company current debt outstanding $-$ coupon rate $7\%$ and yield to maturity $6\%$

Beta $0\mathrm{.}9$

Expected stock market index return of $15\%$

Preferred Dividend $$13$

$10$ Year treasury rate $4\%$

Preferred stock current price $$146$

Target capital allocation: $45\%$ debt, $10\%$ preferred and $45\%$ common equity