In: Finance
1. Par value of the bond (FV) = $1,000
Coupon rate = 10%/2 = 5% (being semi-annual)
Coupon amount payable per period (PMT) = $1,000 X 5% = $50
Number of periods (NPER) = 5 years X 2 = 10 (being semi-annual)
The YTM of the bond is 15% (given)
Therefore, the YTM of the semi-annual bond = 15%/2 = 7.5%.
Let the price of the bond be PV.
The YTM is calculated in excel using the RATE function as follows:
RATE (NPER, PMT, -PV, FV, 0) = 7.5%
Or, RATE (10, 50, -PV, 1000, 0) = 7.5%
Or, PV = $828.40.
Hence, option A is correct.
2. Current yield is computed as follows:
Annual Interest / Price
= $55 / $950 = 5.79%.
Hence, option C is correct.
3. Par value of the bond (FV) = $1,000
Coupon rate = 5.5%
Coupon amount payable per period (PMT) = $1,000 X 5.5% = $55
The present value of the bond (PV) = -$950
Number of periods (NPER) = 6
Therefore, YTM of the bond is calculated in excel using the RATE function as follows:
RATE (NPER, PMT, PV, FV, 0) = RATE (6, 55, -950, 1000, 0) = 6.53%.
Hence, option E is correct.
4. The yield to call is calculated in excel using the RATE function as follows:
NPER = Time to call = 5 years
Coupon amount payable per period (PMT) = $100
Present value of the bond (PV) = -$1,180
Par value of the bond or callable value (FV) = $1,100
Therefore, YTC = RATE (NPER, PMT, PV, FV, 0) = RATE (5, 100, -1180, 1100, 0) = 7.30%.
Hence, option E is correct.