Answer:
The likely yield to maturity on the bonds is 10.23%.
Explanation:
The likely yield to maturity on the bonds can be calculated using the following RATE function in Excel:
YTM = RATE(nper,pmt,-pv,fv) .............(1)
Where;
YTM = likely yield to maturity on the bonds = ?
nper = number of periods = number of years until maturity = 4
pmt = annual coupon payment = annual coupon rate * Face value = 7.50% * $1,000 = $75 = 75
pv = present value = market price = $735 = 735
fv = face value or par value of the bond = 1000
Substituting the values into equation (1), we have:
YTM = RATE(40,75,-735,1000) ............ (2)
Inputting =RATE(40,75,-735,1000) into a cell in an excel (Note: as done in the attached excel file), the YTM is obtained as 10.23%.
Therefore, the likely yield to maturity on the bonds is 10.23%.