Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Future Value Payment Series
Is there a function that will calculate the total payments made where the
payments are made monthly, but the payment amount changes annually by a certain percentage say 3%. For example: 1/2008 - 12/2008 12 payments made at first day of each month of $100 for year 1/2009 - 12/2009 12 payments made at first day of each month of $103 for year 1/2010 - 12/2010 12 payments made at first day of each month of $106.09 for year 1/2010 - 12/2010 12 payments made at first day of each month of $109.27 for year total payments made $5,020.35 Thank you for your help. -- Roger Maniccia emdeon 26 Century Blvd Nashville, Tenn 615-886-9031 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Increasing payment in future value formula? | Excel Worksheet Functions | |||
what should a future payment schedule have on it | Excel Discussion (Misc queries) | |||
calculate payment with first payment due date variable? | Excel Worksheet Functions | |||
series graph -- one series being added to another series | Charts and Charting in Excel | |||
how do you get a positive number payment with a mortgage payment . | Excel Worksheet Functions |