Payment Arrangement Calculator: Arrears Schedule
See when a proposed payment clears overdue instalments while keeping up with new ones.
Your payment arrangement
Your catch-up plan
Example inputsCorrect the marked fields to calculate the schedule.
- 6 months
- $800.00
- $4,725
Arrears balance over time
Opening arrears and the balance after selected payments.
| Period | Catch-up paid | Arrears left |
|---|---|---|
| 1 | $800.00 | $3,925.00 |
| 2 | $800.00 | $3,125.00 |
| 3 | $800.00 | $2,325.00 |
| 4 | $800.00 | $1,525.00 |
| 5 | $800.00 | $725.00 |
| 6 | $725.00 | $0.00 |
Keep Arrears and New Instalments Separate
Opening arrears are the amount already overdue. Enter the ongoing instalment and the proposed total payment using the same frequency. If the client proposes paying $800 extra on top of a $2,140 instalment, enter $2,940 as the proposed total.
The calculator applies the proposed payment to the new instalment first. Any shortfall adds to arrears. Enter only the extra interest or charges the creditor expects to add to arrears each period, excluding charges already included in the opening balance or regular instalment.
Read the Catch-Up Schedule
Arrears fall when the proposed payment covers the new instalment and leaves more than the period’s charges. At exactly that threshold, the balance stays flat. Below it, arrears grow.
In the example, $4,725 in arrears clears in six months with $800 extra each month and no added charges. The first five extra payments total $4,000. The final extra payment is $725, so the sixth payment including the usual instalment is $2,865.
The schedule shows up to 12 payments and the final payment if it falls later. To check an intervening balance before the final payment, subtract the net reduction per payment multiplied by the number of payments made from the opening arrears. Total catch-up payments include entered charges and exclude ongoing instalments.
Confirm the Agreed Arrangement
Use the projection to discuss a proposed amount and frequency with the creditor. Ask for the arrears balance they are using, the first payment date and how they will apply interest and charges. Their terms determine the actual schedule.
The estimate uses the same entered charge in every period until arrears clear. Daily interest, variable fees or charges rolled into the main loan can give a different result. If the creditor agrees to change the regular instalment for the whole arrangement, run the estimate again with the agreed amount.
The lender assesses hardship requests and confirms any repayment changes it agrees to. Moneysmart explains how to ask your lender for help with mortgage repayments.