I Am Trying To Use Excel To Solve This And Cannot Seem To Get It To Work I Need

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.

 

"Looking for a Similar Assignment? Get Expert Help at an Amazing Discount!"