Answer all questions $2-5$ usuing Excel Formulas. I need to be able to plug in the numbers to the formulas to show work of how I got the answers. Thank you!

A $6\mathrm{.}50\%$ coupon bond with $18$ years left to maturity is offered for sale at $$1,035\mathrm{.}25.$ What yield to maturity $[$interest rate$]$ is the bond offering? Assume interest payments are paid semi$-$annually, and solve using semi$-$annual compounding. Par value is $$1000.$