Variable payment rate for the NPER function

If you want to change rates and make additional payments, see if this helps:

http://pistulka.com/other

Then look for "Amortization Schedule With Variable Rates" on the right hand side. Should be first one.

Originally Posted by pistulka

If you want to change rates and make additional payments, see if this helps:

http://pistulka.com/other

Then look for "Amortization Schedule With Variable Rates" on the right hand side. Should be first one.

Hi pistulka,

Thank you for suggesting this. I have looked at it and it is very close to what I need. I simply need to work out how to use the formulas to allow the monthly payments to change instead of the interest rate.

In case people are interested in a possible way to do this a poster called MickG on the other forum I have posted this question has said that he could have a possible solution. If that is the case I will share his answer here or you can view the thread using the following link as stated by joeu2004:

http://www.mrexcel.com/forum/excel-q...r-5-years.html

Thank you also to everyone else above that has responded and I again apologise if anyone feels I acted inappropriately by posting on different forums and worded my question differently.