LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 5
Default Starting payment when increase rate is known & total payment is kn

Does anyone know of a function that can provide the the starting payment and
the subsequent payments thereafter to reach a total as defined.

Example:
Total payments must be 5000 over 5 years. The increase rate is 10% every
year, so what will the starting payment be.

I have been able to figure this out using Algebra type mathematical
formula's in excel, however i believe there must be a function that can very
easily achieve this more quickly. The field Total payments, no of payments
and increase rate is known, while the unknown is the starting payment and the
payments subsequent to that.
--
Thank you in advance
Shailendra Harri
 
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
loan calculator, int rate changes and fixed prin payment skip770 Excel Discussion (Misc queries) 0 December 15th 05 02:41 PM
how do I calculate a monthly payment based on a variable rate? Chick N Egg Excel Worksheet Functions 1 November 17th 05 09:00 PM
Calculate Interest Rate when payment changes! huntermcg Excel Worksheet Functions 2 October 25th 05 08:32 AM
calculate payment with first payment due date variable? Jody Solbach Excel Worksheet Functions 1 September 8th 05 05:46 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 03:06 AM.

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"