Thanks for using JustAnswer. My name isXXXXX will do whatever I can to answer your question
FV is the correct formula to use
the important thing to remember with FV is to be especially careful with the number of periods and interest rate.
Start with a set number in years for example 5 years. Then if it is annual your number of periods is 5, monthly is 60, quarterly is 20 and so on. That way all the time frames would be the same.
The interest rate is always in apr, so it is important to divide the interest rate by the number of payments per year. then you will get correct values. Also interest is always entered as a decimal number so 3 percent would be entered into excel as 0.03 not 3 as 3 would be 300 percent. hope that makes sense.
So to get the correct interest rate you would divide the interest rate by the number of payments per year in the FV formula. So $125 quarterly payment at 3.5 percent for 5 years would be entered, say you start with a $1000 present value, would be entered into excel like this
hope this makes sense to you.
here is an example of how this would work in excel. Click the link to downloadhttp://ge.tt/5PTvBhs/v/0?c
let me know if it is clearer to you, or if you have any problems with the formula provided. Or if I even misunderstood what you needed