Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 2
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Increasing payment in future value formula? AXPJESTER Excel Worksheet Functions 5 May 20th 23 07:43 PM
what should a future payment schedule have on it Acaciabusser Excel Discussion (Misc queries) 3 April 10th 07 03:52 PM
calculate payment with first payment due date variable? Jody Solbach Excel Worksheet Functions 1 September 8th 05 05:46 PM
series graph -- one series being added to another series rich zielinski via OfficeKB.com Charts and Charting in Excel 3 March 30th 05 06:23 PM
how do you get a positive number payment with a mortgage payment . sam Excel Worksheet Functions 1 February 2nd 05 05:32 AM


All times are GMT +1. The time now is 08:12 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"