Calculate the current price of a bond that pays semi-annual coupon payments and has the following characteristics:
(a) NPER 15,
(b) Coupon Payments $73, and
(c) Market Rate of Interest13%.the market rate. Using Excel's PV() function: RATE6.50%(This is the semi-annual required rate of return or YTM.) NPER15 (This is the number of semi annual periods to maturity.) MT($73.00) (This is the semi-annual coupon interest payment.)FV($1,000.00)(This is the par or face value of the bond .)TYPE0(Input 0 or 1. 0 or blank means ordinary annuity. 1 means annuity due.)PV$1,075.22 (Type formula here: = PV(rate, nper, pmt, fv, type)