Hi,

Does anyone know if it is possible to use the NPER function if your monthly payments change and do not stay at a fixed rate for the duration of the loan?

The reason I need this is because I would like to work out how long it will take to repay a loan at the same time as allowing for the client to increase the amount they pay back each month.

At the moment I can only get an accurate forecast if I keep the monthly payments fixed.

Any help is appreciated.