BOND VALUATION Madsen Motorss bonds have 23 years remaining to maturity. Interest is paid annually; they have a $1,000 par value; the coupon interest rate is 9%; and the yield to maturity is 11%. What is the bonds current market price? 7-3 BOND VALUATION Nesmith Corporations outstanding bonds have a $1,000 par value, an 8% semiannual coupon, 14 years to maturity, and an 11% YTM. What is the bonds price? in excel format

example

i.e.: PV(FV=100, NPER= 10, Rate = 2%)