View Single Post
  #10   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 Tue, 21 Aug 2007 12:49:19 -0700, joeu2004
sayd the following:

On Aug 21, 12:35 pm, Crackles McFarly wrote:
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.


=fv(10%/12, 12*25, -100, -500)

Results in $21,838.02. Calculator result: $21,838. Where's the
error you are talking about?


A few of the online mutual fund investment calcs are different is what
I mean.

But you are talking about mutual funds, not savings. I would not
estimate the "total return" over 25 years in that manner.



I'm told 8-12% is a good range, got to settle on one so I picked 10%
as an avg rate of return in the mutual funds arena...