Need help with FV in Excell?

I just need to know how u put this in FV function in fomula in excel?

#

Institution/Rate/Deposit/ of years

Bank #1/ 3.47/ 1000/ 5

also included is amount deposited each year is 4,000?

Need help with FV in Excell?loan

= FV(0.0347, 2, -4000, -1000, 1)

First argument is your annual interest rate

Second argument is the length of time of your investment. The example using 2 years

3rd argument is the amount you put into the investment annually

4th argument is the present value of the investment

5th argument indicates whether the new amount is added 1: for beginning of a period or 0: for end of a period. The example indicates $4000 is invested in the beginning of a year.

If you are changing interest rate to monthly, make sure you divide payment into 12 as well.

Best wishes.