View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
[email protected] zmfizzle@gmail.com is offline
external usenet poster
 
Posts: 1
Default 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.