Excel formula for investments

[Dean01]

Hi guys

Struggling to find something (which seems so simple!)

Can anyone advise what excel formula I can use to calculate the future value of my investment which includes an initial amount and monthly deposits?

TIA

 

[Solmonster]

FV

 

[Solmonster]

Remember if payments is monthly, your rate should also be in months

 

[Dean01]

Remember if payments is monthly, your rate should also be in months

what inputs have to be negative?

 

[Solmonster]

Both the the initial and pmt should be negative to show your FV as positive