Calculate the new NPER when a baloon payment is made

So I would like to understand how can I calculate the new payment periods (nper) if a balloon payment is made on a loan that has a fixed rate till year 5th and a new fixed rate on wards (till the loan is repayed).

I have been able to reverse engineer the calculation from the bank for othese balloon payments, yet I always need to rely on their calculation for the new NPER.


What I would like to do is calculate on my own the NPER for different balloon payments (play different scenarios and decide how high the balloon payment should be to fit my needs), and no matter how much I try it seems I can not get around this.

hope this makes sense..

Hi there,

Take a look at the attached workbook and see if it gets you moving in the right direction.

Hope this helps - please let me know how you get on.

Regards,

Greg M