Hi

Thank you both for the quick and perfectly spot-on response. I changed
the rate to be 7.747975613527150% and the FV returned zero, as I'd
hoped.

Cheers

Steve



On Tue, 28 Nov 2006 15:00:50 +0000, Steve Simons
wrote:

Note: I have previously posted this in NG
microsoft.public.excel.worksheetfunctions (note the lack of a 'dot'
before functions). I've had no response, and it looks like a very
queit NG, so have posted here. Hopefully someone can help . . . .


Hi

I am trying to calculate using the RATE and FV functions and find that
the results do not tally:-

Initially I did a RATE function as below:

RATE function:-

"time period
years" Payment Present Value Future Value Type
10 -1200.00 100,000 0 0

Interest rate: 7.75% =RATE(A2*12,B2,C2,D2,E2)*12


I assumed that, if I did a FV function with values corresponding to
the above, I would get a Future Value of zero. But no. I got a FV of
-19.18. Can anyone explain why this is please?

FV function

interest rate "time period
years" Payment Present Value Type
7.75% 10 -1200.00 100000.00 0

Future Value -19.18 =FV(A2/12,B2*12,C2,D2,E2)

Can anyone explain why this is please?

I may also post some more messages asking for help on finance
functions.

TIA

Steve