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.