Advanced Subtraction/Addition problem (#2)

Ok with the help of another member they were able to come up with this attached simplified worksheet. The basic function is that there are multiple debts and I wanted to add additional payments which would go into the first debt first, then when it reached a zero balance to the second debt and so on.

Its flawless and exactly what I was looking for. But here is my new problem, which I couldn't solve on my own.


I want to add monthly interest and monthly minimum payments to each debt and combine it with the setup I have now where the additional payments subtract that much more from the first given debt and then moves down the line as they reach zero balances.

Any help would be greatly appreciated. Thanks in advance.

How about this formula in C3:

Please Login or Register  to view this content.

copied down to C5 and then across the table

and this formula in C6:

Please Login or Register  to view this content.

copied down to C7 and across the table

Maybe the attached is what you want then?