In: Finance

calculations-

| Here, | ||
| Fv is the future value of bond | ||
| rate is the periodic interest rate | ||
| nper is no. of periods | ||
| pmt is the periodic payments | ||
| Pv is the present value of bond | ||
| type = 0 if the amount is paid at the end of the year ,1 if it is paid at the beginning. | ||
As no method was mentioned I have solved the problem using excel function.
Please upvote if the answer is helpful.In case of doubt,do comment.Thanks.