Using an Excel spreadsheet to calculate yield to maturity: What is the yield to maturity on the following bonds; all have a maturity of 10 years, a face value of $1,000, and a coupon rate of 9 percent (paid semi-annually). The bonds current market values are $945.50, $987.50, $1,090.00, and $1,225.875, respectively. Market Value Total Pmts. Periodic Coupon pmt. Face Value 945.50 10x2=20 1000(0.9)/2=45 1000 987.50 20 45 1000 1090.00 20 45 1000 1225.875 20 45 1000 Yield to Maturity will be 9.87% 9.19% 7.69% 5.97%