In: Economics
Bond B: Matures in 6 years, offers a coupon rate of 7% and has a face value of $7000
Purchase price of the bond has been found using the PV function in excel.
Purchase price of bond A =-PV(F10,F7,F11,F9,0) = 11509.89
Purchase price of bond B = -PV(L10.L7,L11,L9,0) = 6371.97
Negative sigh with pv function has been used to make pv value positive. This is done make calculations much easier.
Capital gain on bond A= F9-F12= -1509.89
Capital gain on bond B = L9-L12 = 628.03
ROR on bond A = (F11+F9-F12)/F12 = -2.69%
ROR on bond B = (L11+L9-L12)/L12 = 17.55%