doingthesums

Home loans

Offset & extra repayments calculator

Your offset balance, an extra repayment and a lump sum, all in one go. See the new payoff date and the interest you would never pay.

Your loan

$
%
yrs

What you would change

$

What you keep in the offset account, on average.

$
$

The link carries your figures so you can send it to whoever you share the loan with. Nothing is stored on our side.

As it stands

$0

 As it isWith changes

Balance owing

As it is With your changes

How this is worked out

  • Interest is charged each repayment period on your balance minus your offset.
  • Your scheduled repayment is calculated from the balance, rate and years left, then held flat. Paying extra does not reduce what you owe each period — it shortens the loan, which is what lenders actually do.
  • A lump sum is applied before the first period's interest.
  • Your rate stays the same for the whole loan. Change it to test a rise or a cut.
  • Your offset balance is treated as constant. A real offset moves with your pay cycle; modelling that needs a cash-flow forecast nobody has, so this is a deliberate simplification.
  • Fees, rate changes your lender makes, and redraw are not included.

Does an offset beat paying the loan down?

For interest, they are identical — a dollar in the offset for the life of the loan saves exactly what a dollar paid off the loan today would have saved, to the cent. That is not a rule of thumb, it falls out of the arithmetic: interest on balance minus offset is the same number as interest on a balance that is lower by the same amount.

What paying it off buys you is an earlier finish, because you no longer owe that money. What the offset buys you is that you still have it. Which one wins depends on whether you would rather be free sooner or keep the cash available — not on the interest, because the interest is a tie.