In: Finance
Trevor Price bought 10-year bonds issued by Harvest Foods five years ago for $6,809.76. The bonds make semiannual coupon payments at a rate of 8.4 percent. If the current price of the bonds is $10,390, what is the yield that Trevor would earn by selling the bonds today? (Round intermediate calculations to 4 decimal places, e.g. 1.2514 and final answer to 2 decimal places, e.g. 15.25%.)
Effective annual yield ? %
Yield is calculated using the RATE function as follows:
=RATE(nper,pmt,-pv,fv)
=RATE(10*2,8.4%/2*10000,-6809.76,10390)*2
=14.79%
Effective annual yield is:-
=(1+APR/n)^n-1
=(1+14.79%/2)^2-1
=15.34%
Where,
nper is no of periods the bond is held,
pmt is payment per period received,
pv is the purchase price,
fv is the selling price