In: Finance
Harrimon Industries bonds have 5 years left to maturity. Interest is paid annually, and the bonds have a $1,000 par value and a coupon rate of 9%.
%
%
a]
YTM is calculated using RATE function in Excel with these inputs :
nper = 5 (5years to maturity with 1 annual coupon payment each year)
pmt = 1000 * 9% (annual coupon payment = face value * annual coupon rate. This is a positive figure as it is an inflow to the bondholder)
pv = -858 (current bond price. This is a negative figure as it is an outflow to the buyer of the bond)
fv = 1000 (face value of the bond receivable on maturity. This is a positive figure as it is an inflow to the bondholder)
The RATE is calculated to be 13.04%. This is the YTM.
b]
YTM is calculated using RATE function in Excel with these inputs :
nper = 5 (5years to maturity with 1 annual coupon payment each year)
pmt = 1000 * 9% (annual coupon payment = face value * annual coupon rate. This is a positive figure as it is an inflow to the bondholder)
pv = -1087 (current bond price. This is a negative figure as it is an outflow to the buyer of the bond)
fv = 1000 (face value of the bond receivable on maturity. This is a positive figure as it is an inflow to the bondholder)
The RATE is calculated to be 6.88%. This is the YTM.
c]
III - You would buy the bond as long as the yield to maturity at this price is greater than your required rate of return. The YTM at this price is 13.04%. whereas your required rate of return is 12%.