Suppose that Company E issues bonds with a term of 65,438+00 years, with a face value of 65,438+000 yuan and coupon rate 65,438+02%, and pays interest once every six months. Question:

6 yuan per coupon. It will be sold after two years of issuance, with eight years left. 16 pays interest. Calculate with excel

When the market interest rate is 8%, the price = PV (4%,16,6100) =123.30 yuan.

When the market interest rate is 14%, the price = PV (7%,16,6100) = 90.55 yuan.