| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Create an annuity in Excel having monthly deposits plus interest
I need to create an annuity which has an initial value plus constant deposits
made monthly over the period. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Create an annuity in Excel having monthly deposits plus interest
See help on the FV function. When you enter teh interest rate, make sure that you divide the annual
rate by 12 to get the monthly rate: =FV(8%/12,60,-100, -5000) will return the value of an annuity that is intially worth $5,000, you deposit $100 each month for five years, get an 8% APR. HTH, Bernie MS Excel MVP "gas" wrote in message ... I need to create an annuity which has an initial value plus constant deposits made monthly over the period. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Interest Functions | Excel Worksheet Functions | |||
| create excel based standalone application | Excel Discussion (Misc queries) | |||
| Create database in excel? | New Users to Excel | |||
| TRYING TO SET UP EXCEL SPREADSHEET ON MY COMPUTER | New Users to Excel | |||
| create price list from excel sheet | Excel Discussion (Misc queries) | |||
Linear Mode
