Price and Yield to Maturity for Bonds Assignment | Homework For You
March 17th, 2020
Question 3 Use an Excel spreadsheet to calculate the appropriate price and yield to maturity for the three bonds listed below:

a. Bond with coupon rate of 10% and face value of $1000 that matures in 6 years.
b. Bond with coupon rate of 5% and face value of $1000 that matures in 4 years
C. Bond with coupon rate of 2% and face value of $1000 that matures in 2 years.
Assume that the one-year, two-year, three-year, four-year, five-year, and six-year spot rates are 4.00%, 4.50%, 4.75%, 5.00%, 5.20%, and 5.50%, respectively. All coupons are paid annually. Get Finance homework help today