In: Finance
(a) | Yield-to-maturity | =RATE(nper,pmt,pv,fv) | Where, | ||||
= 6.98% | nper | = | 4 | ||||
pmt | = | $ 45.00 | |||||
pv | = | $ -916.00 | |||||
fv | = | $ 1,000.00 | |||||
(b) | Yield-to-maturity | =RATE(nper,pmt,pv,fv) | Where, | ||||
= 3.90% | nper | = | 4 | ||||
pmt | = | $ 45.00 | |||||
pv | = | $ -1,022.00 | |||||
fv | = | $ 1,000.00 | |||||
(c) | Price of bond | =-pv(rate,nper,pmt,fv) | Where, | ||||
= $ 948.02 | rate | = | 6% | ||||
nper | = | 4 | |||||
pmt | = | $ 45.00 | |||||
fv | = | $ 1,000.00 | |||||
(d) | Yes | ||||||
At 6% rate of interest, price of bonds should be $ 948.02. But, it is offered at lower price of $ 916.So, it is better to but the bond at $ 916. | |||||||