Payoff table
For a payment you already know: when the balance reaches zero, and what paying extra changes.
The last month pays only what is left, including that month's interest.
The Debt Payoff template keeps a balance and a payment for each debt in a spreadsheet you own.