How can I write the formula for PV in Excel? Thank you

9-4. and the market s requireu ylliu iu iu (Valuing bonds) (Related to Checkpoint 9.4 on page 273) Calculate the value of a bond that matures in 10 years and has a $1,000 par value. The annual coupon interest rate 296 PART 2 | Valuation of Financial Assets is 9 percent, and the market's required yield to maturity on a comparable maturity on a comparable-risk bond is 15 percent. What would be the value of this bond if it pays interest semiannually