A home loan calculator with offset account shows how much interest and time you could save by keeping money in an offset account linked to your mortgage. Enter the loan, the rate, the term and the average balance you hold in the account. The tool compares the loan with and without the offset, using the same repayment, so you can see the saving in dollars and in months.
How to use the home loan calculator with offset account
- Enter the loan amount, the interest rate and the term.
- Enter the average offset balance you expect to keep.
- Leave the repayment blank for the standard repayment, or enter your own, then press Calculate.
What an offset account does
MoneySmart explains that with a $750,000 loan and a $50,000 offset you are only charged interest on $700,000. It says interest on most home loans is calculated daily, and each day the lender subtracts your offset balance from your loan balance before calculating interest [1]. The offset does not earn interest itself. The benefit is interest you avoid, and it is usually called a saving because the money in the account stays yours.
How the tool works
Each month the interest is the loan balance minus the offset, never below zero, times the yearly rate divided by 12. The balance goes up by that interest and down by your repayment. The tool repeats this until the loan is cleared, with the offset and again with none, then compares the two. This monthly loop is our own working, and the offset balance is held constant for the whole loan.
The standard repayment
If you leave the repayment blank, the tool uses the standard repayment for the term with no offset, which is the usual loan formula. For $750,000 at 6.25 percent over 30 years it is $4,617.88 a month. The offset does not lower the repayment. You keep paying the same amount, so the loan finishes sooner, which is where the time saving comes from.
The MoneySmart example
MoneySmart's own scenario is a $750,000 loan over 30 years at 6.25 percent with $50,000 average in an offset account. It says the borrower pays over $3,000 less in a year, nearly $230,000 less over the life of the loan, and finishes about four years earlier [1]. The tool gives $227,212.01 less interest, 49 months sooner and $3,216.09 in the first year. Without the offset the loan takes 360 months and costs $912,436.44 in interest, and with it 311 months and $685,224.43. All three match the scenario.
Why the totals can differ a little
MoneySmart's calculator compounds on the repayment frequency, assumes the rate stays fixed, includes no up-front fees, and says it is a model and not a prediction [2]. It does not publish how it calculates the offset, so we use monthly steps. A lender that charges daily interest will give figures a few dollars away from ours.
Offset balance and your own repayment
The tool treats the offset as one average figure for the whole loan. Your real balance will rise and fall, so use a realistic average. If you enter your own repayment, it must be more than the first month's interest on the loan with no offset, otherwise the loan never ends and the tool says the figure is out of range. A bigger repayment shortens both cases.
Fees and rates
MoneySmart notes that some banks charge for an offset account, either through a higher rate or fees [1]. The tool does not add a fee. If your lender charges one, take its yearly cost away from the saving to see the net benefit.
Check the account is linked
MoneySmart reports an ASIC review of offset accounts and advises you to check that your account is linked to the loan [1]. A savings account that is not linked does not reduce your interest, however large the balance.
What the results do not show
Variable rates move, offset balances change, and you may make extra repayments. None of this is modelled. Treat the result as a guide to the size of the saving and ask your lender for its own figures.
A quick check
A rough check of the first-year saving is the offset balance times the rate. For $50,000 at 6.25 percent that is $3,125, close to the $3,216.09 the monthly loop finds because the loan balance falls and compounding adds a little.
When an offset account helps most
The saving depends on the size of the balance and on how long it stays there. Each $10,000 held for a year at a rate of 6.25 percent avoids about $625 of interest, which is our own arithmetic. A balance of a few hundred dollars saves almost nothing, while $100,000 saves about $6,250 a year at the start. Try a few balances in the tool to see how the payoff date moves.
What this tool does not compare
The tool compares a loan with an offset against the same loan without one. It does not model extra repayments, redraw facilities, fixed rate periods or a rate that changes at renewal. For a different question, such as paying down the loan, use a prepayment calculator instead.
Common mistakes
- Counting the offset balance as earning interest. It reduces the interest charged and earns none.
- Using a balance that is not an average. One big deposit does not last all year.
- Forgetting fees. Some lenders charge for offset accounts.
- Entering a repayment below the interest. The loan balance would never fall.
What next
Use this often? Add Home Loan Ca to your Home screen.
Frequently asked questions
How does this home loan calculator with offset account work?
Each month it charges interest on the loan balance minus the offset, then reduces the balance by your repayment. It runs the loan with and without the offset and compares them.
Does an offset account lower my repayment?
No. The repayment stays the same, so the saving shows up as less interest and an earlier payoff.
Does the offset account earn interest?
No. It reduces the interest you are charged on the loan, so you save interest instead of earning it.
Why might my lender's figures differ?
Lenders usually charge interest daily and your offset balance will move, so their figures can differ by a few dollars from this monthly estimate.
Does the calculator include fees?
No. Some lenders charge a fee or a higher rate for offset accounts. Take that cost away from the saving.
Sources
Was this tool helpful?
What went wrong?
We only receive the reason you pick, never what you typed into the tool.
Thanks for your feedback.