Answer:
Yield to maturity = 6.42%
Explanation:
The yield to maturity (YTM) can be calculated using the following RATE function in
Excel:
YTM = RATE(nper,pmt,-pv,fv) .............(1)
Where;
YTM = yield to maturity = ?
nper = number of periods = Number of semiannuals = Number of years * Number of semiannuals in a year = 8 * 2 = 16
pmt = semiannual coupon payment = face value * semiannual coupon rate = 1000 * 7.25% = 72.50 (Note: This is an inflow to the bondholder and it is therefore a positive figure).
pv = present value = current bond price = -$1,000 * 108.126% = -1,081.26 (Note: This is an outflow to the buyer of the bond and it is therefore a negative figure).
fv = face value of the bond = 1000 (Note: This is an inflow to the bondholder
and it is therefore a positive figure).
Substituting the values into equation (1), we have:
RATE(16,72.20,-1081.26,1000)
YTM = RATE(16,72.50,-1081.26,1000) ............ (2)
Inputting =RATE(16,72.50,-1081.26,1000) into excel (Note: as done in the
attached excel file), the YTM is obtained as 6.42%.
Therefore, YTM is 6.42%.