Answer:
Bond purchase price
Face value (FV) = $1,000
Coupon rate = 6.00%
Number of compounding periods per year = 1
Interest per period (PMT) = 60.00
Number of years to maturity = 5
Number of compounding periods till maturity (NPER) = 5
Market rate of return/Required rate of return = 4.00%
Market rate of return/Required rate of return per period (RATE) = 4.00%
Bond price = PV(RATE,NPER,PMT,FV)
Bond price = $1,089.04
Bond selling price:
Face value (FV) = $1,000
Coupon rate = 6.00%
Number of compounding periods per year = 1
Interest per period (PMT) = $60.00
Number of years to maturity = 4
Number of compounding periods till maturity (NPER) = 4
Market rate of return/Required rate of return = 3.00%
Market rate of return/Required rate of return per period (RATE) = 3.00%
Bond price = PV(RATE,NPER,PMT,FV)
Bond price = $1,111.51
Return during one year = Bond selling price - Bond purchase price + Interest per period) / Bond purchase price
Return during one year = ($1,111.51 - $1,089.04 + $60) / $1,089.04
Return during one year = $82.47 / $1,089.04
Return during one year = 0.075727246
Return during one year = 7.57%