Question

The dollar return for a semiannual bond with the following characteristics assuming that you can earn the same yield on a 9-year certificate of deposit are:

Coupon rate = 6.10%

Time to maturity = 9 years

Price = $109.79

YTM (BEY) = 4.75%

a. Calculate the realized rate of return for the buy and hold investor if market interest rates increase by 50 basis points after purchase and before the first coupon payment.

b. Calculate the realized rate of return of the investor who sells the bond after 5 years, but interest rates decrease by 50 basis point after purchase and before the first coupon payment.

Can someone PLEASE solve this in excel? (Please show equations). I need the answers I would appreciate your help.

Answer 1

Answers: