hakluke@~

~$ finance/mortgage

Mortgage payoff 🏦

The bank quotes you a 30-year sentence. Extra repayments, a lump sum and an offset account all commute it — this shows by exactly how much, period by period, and what each lever is worth in interest you never pay.

Saved

Fill in the loan as it stands, then open paying it down faster and watch what each lever does. Nothing is sent anywhere — your figures live in your browser and nowhere else.

The loan
Repayment frequency

Minimum repayment: .

Paying it down faster

The offset account

Paid off in saving

Verdict

Crunching…

With your extras
Minimum only
Interest saved
Time saved

What you still owe

Minimum repayments With extras + offset

Every dollar of gap between the two lines is a dollar the bank charges interest on for years — which is why the savings compound the way they do.

Interest, running total

the gap at the end is what you keep
Minimum repayments With extras + offset

What another $100 a month does

Extras only — the curve holds your offset and lump sum at zero so you can see this one lever cleanly. Steepest at the start: the first $100 is the best $100.

If rates move

same loan, same extras, repriced
Rate Repayment Per month Paid off in Total interest

How this works

  • The repayment formula is not a mystery. The minimum is the payment that, at your rate, lands the balance on exactly zero at the end of the term. Early on almost all of it is interest; the principal only starts moving properly in the back half. That front-loading is why every trick below works best early.
  • Extra repayments attack the principal directly. Each extra dollar stops earning the bank interest for every remaining year of the loan, which is why $100 a month can be worth tens of thousands — the saving is the interest that dollar would have generated, compounded to the end of the term.
  • An offset reduces interest, not the repayment. Interest is charged on the balance minus whatever sits in offset. Your repayment stays the same, so more of each payment hits the principal and the term shortens. Every offset dollar effectively earns your mortgage rate, tax-free — hard to beat with a savings account that gets taxed.
  • The fortnightly “trick” is just extra repayments in disguise. Paying half your monthly repayment every fortnight makes 26 half-payments — thirteen months of repayments a year instead of twelve. Model it here by switching to fortnightly and adding the difference as an extra; the frequency switch alone uses the true amortising fortnightly minimum, which is not the trick.
  • Offset vs. redraw: mathematically identical while the money sits there, legally different. Offset money is yours; redraw is the bank letting you re-borrow your own extra repayments, and they can change the rules. This model treats the money as staying put either way.
  • The rate is held flat. Real loans reprice every time the RBA clears its throat — the “if rates move” table shows what that does, but the projection itself assumes today’s rate for the duration.
  • Not modelled: fees, interest-only periods, split loans, repayment holidays, or the willpower required to leave a fat offset account alone.

General information only, not financial advice — I’m a hacker, not a financial adviser. Check anything that matters against your actual loan contract. Your numbers stay in your browser.

Fair warning, before you trust anything above: this was built by one random guy on the internet who likes spreadsheets — not an accountant, not a financial adviser, not a lawyer. It almost certainly contains bugs, simplifications, and rules that have quietly gone out of date. You probably shouldn’t use it for anything that matters.

Nothing on this page is financial, tax or legal advice, or a recommendation to do anything. The numbers are provided as-is with no warranty of any kind, and I accept no liability for any loss that comes from relying on them. Before making a real decision, check the figures against the ATO’s published rates and talk to someone actually licensed to advise you. If you use these numbers anyway, you do so entirely at your own risk.