Quote Originally Posted by pistulka View Post
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.