Answer:
$5.97
Explanation:
In order to determine the capital gain of the bond in a year's time,it is first first of all important to calculate the yield to maturity on the bond which is arrived at by applying the rate formula in excel as follows:
=rate(nper,pmt,-pv,fv)
nper is the number of coupon interest the bond would pay over its entire life of 15 years which is 15
pmt is the annual interest,7.9%*$1000=$79
pv is the current market price of the bond which is $790
fv is the value of $1000
=rate(15,79,-790,1000)=10.79%
Afterwards,the price of the bond in one year' time can then be calculated:
=-pv(rate,nper,pmt,fv)
The variables in the formula are as above except for nper which would reduce by 1 in a year's time
=-pv(10.79%,14,79,1000)
pv=$ 795.97
Hence the capital gain=price now-price one year ago/price one year ago
price now is $795.97
price one year ago was $790
Capital gain=$795.97-$790=$5.97
Capital gain %= ($795.97-$790)/$790=0.76%
