On Mon, 20 Aug 2007 22:47:42 -0700, joeu2004
sayd the following:
On Aug 20, 9:01 pm, Crackles McFarly wrote:
On Mon, 20 Aug 2007 17:56:42 -0700, joeu2004 wrote:
For example, consider an
initial investment of $10,000 and monthly investments of $100, with a
return of 1% per month compounded over 5 years.
=fv(1%, 12*5, -100, -100000)
This results in the (correctly) positive value of $189,836.64 (rounded).
http://www.dinkytown.net/java/CACompoundSavings.html
THAT ONE doesn't jive with Excel's results...Don't know why either.
You are probably entering incorrect parameters. That calculator
matches my result above (rounded to the dollar) when I enter 12% for
"rate of return", select "compound monthly" and uncheckmark "make
deposits at the start of each period".
If you describe the parameters that you are entering, I might be able
to explain any difference that you see, if the above explanation does
not.
OK, here is my example I am using
Initial investment of $500.00
With $100 per month, every month.
At a return rate of exactly 10%
For a period of exactly 25 years.
thank you