I am having trouble correctly calculating the semiannual portion of this can you please assist with the correct formula entries for excel

(Related to Checkpoint 9.4) (Bond valuation) A bond that matures in 14 years has a $1,000 par value. The annual coupon interest rate is 15 percent and the market's required yield to maturity on a comparable-risk bond is 18 percent. What would be the value of this bond if it paid interest annually? What would be the value of this bond if it paid interest semiannually? a. The value of this bond if it paid interest annually would be $849.76. (Round to the nearest cent.) b. The value of this bond if it paid interest semiannually would be : (Round to the nearest cent.)