How to use excel to predict interest
 

Hello,
I am trying to set up excel to predict what the value of an investment
would be. It would be an initial investment (say $5,000) with a 4.5%
interest yearly. I would also like to know how to factor in adding
money to the fund at the beginning of each month. I would like this
equation to factor for 5 years. Every time I use a finance function I
get an error, and I do not know which to use. Any help would be
greatly appreciated.

How to use excel to predict interest
 

I think the FV function is the one you want. You will it in help if you
simply use FV as search criteria.

Also check out the 'See also' which has other finacnial functions.

Regards,

OssieMac

" wrote:

Hello,
I am trying to set up excel to predict what the value of an investment
would be. It would be an initial investment (say $5,000) with a 4.5%
interest yearly. I would also like to know how to factor in adding
money to the fund at the beginning of each month. I would like this
equation to factor for 5 years. Every time I use a finance function I
get an error, and I do not know which to use. Any help would be
greatly appreciated.