I am trying to use excel to solve this and cannot seem to get it to work. I need to be able to show the exact formula(s) used. I have unlocked several documents but am still struggling.

Fundamentals of Finance

2. Using semi-annual compounding, what is the price of a 5 percent coupon bond with 10 years left to maturity and a market interest rate of 7.2 percent? Assume that interest payments are paid semi-annually and that par value is $1000.