future value calculation

[farmer1]

i need to calculate the future value of a series of annual payments at 5% annual interest rate.the payments are;40000 now then15000 annually for a total of 20 payments. total payment 325000. assume payment on 1st of the year. need to display value at end of each year

[dabrows]

assuming you are looking for discreet compounding..i suggest you read this...


http://office.microsoft.com/en-us/ex...001111745.aspx