Answer:
Current market value (price) of the bond = $ 1,081.11
Explanation:
The current market value (price) of the bond can be calculated using the following excel function:
Current market value (price) of the bond = PV(rate, NPER, -PMT, -FV) ........... (1)
Where:
rate = Semiannual yield on similar risk investments = yield on similar risk investments / 2 = 8% / 2 = 4%
NPER = Number of period = Year to maturity * Number of semiannuals in a year = 8 * 2 = 16
PMT = Payment = (FV * Coupon rate) / Number of semiannuals in a year = ($1,000 * 10%) / 2 = $50 = 50
FV = Face value = $1,000 = 1000
Substituting all the relevant value into equation (1), we have:
Current market value (price) of the bond = PV(4%, 10, -50, -1000)
Inputing =PV(4%, 10, -50, -1000) in any cell in excel sheet (Note: as done in the attached excel file), we have:
Current market value (price) of the bond = $ 1,081.11