Question

Allison bought a bond when it was issued by ABC Corporation 20 years ago. The bond, which has a $1,000 face value and a coupon rate equal to 10 percent, matures in eight years. Interest is paid every six months; the next interest payment is scheduled for six months from today. If the yield on similar risk investments is 8 percent, what should be the current market value (price) of the bond

Answer 1

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

Download xlsx