Question

The YTM on a bond is the interest rate you earn on your investment if interest rates don’t change. If you actually sell the bond before it matures, your realized return is known as the holding period yield (HPY).
a) Suppose that today you buy a bond for $1,150. The bond has a face value of $1,000, 10 years to maturity, a 9 percent coupon rate, and the coupons are paid annually. What rate of return do you expect to earn on your investment?
b) Two years from now, the YTM on your bond has declined by 1 percent, and you decide to sell. What price will your bond sell for? What is the HPY on your investment? Compare this yield to the YTM when you first bought the bond. Why are they different?

Answer 1

PMT coupon payment FV face value NPER pv=price rate (number of payments) RATE(nper,pmt,-pv,fv) 10 $1,000.00 $1,150.00 6.88% 90 RATE(10,90,-1150,1000) a) Expected rate of return 6.88% b-1) Price after 2 years $1,194.91 PV(6.88%-1%,8,90,1000) b-2) Holding period yield 9.69% RATE(2,90,-1150,1194.91) YTM is the rate that would be earned if held till the maturity. but holding period return is the yield earned for interim sale