In: Finance

Calculations-
| Here, | ||
| Fv is the future value of amount invested | ||
| rate is the periodic interest rate | ||
| nper is no. of periods | ||
| pmt is the periodic payments | ||
| Pv is the present value of investmet | ||
| type = 0 if the amount is paid at the end of the year ,1 if it is paid at the beginning. | ||
Please upvote if the ans is helpful.In case of doubt,do comment.Thanks.