| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| time addition to predict finish time | Excel Worksheet Functions | |||
| to compute interest rate from principal and interest amount | Excel Discussion (Misc queries) | |||
| Formula to predict a future date | Excel Worksheet Functions | |||
| How do I set up a sales forecast to predict sales per hour, when . | Excel Discussion (Misc queries) | |||
| Effective rate of Interest and Copounding Interest | Excel Worksheet Functions | |||
Linear Mode
