How to use excel to predict interest

  • Thread starter Thread starter zmfizzle
  • Start date Start date
Z

zmfizzle

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.
 
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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How do I invoice a cost to a custom built MS Access Accounting Database? 0
Future Value of Mutual Funds 1
PayBack Period 2
Switched, powered USB3.0 hubs fail after a short time? 3
Rolling Average for Prediction 7
Reduction in Growth 4
Formula for evaluating predictions - Fantasy Football League 8
Switched, powered USB3.0 hubs fail after a short time 0

Back
Top