View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Crackles McFarly Crackles McFarly is offline
external usenet poster
 
Posts: 49
Default Investing,Mutual Funds Formula?

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