Free Offset vs Extra Repayments Calculator (Australia)
NEW (24 Oct 2026): Google Sheets edition included. Your download now has the Excel workbook plus a PDF with a one-click link to make your own Google Sheets copy (same formulas, checked cell by cell against the Excel version).
NEW in version 1.2 (22 Oct 2026): every tab now looks and works like an app screen, not a worksheet: no gridlines or row numbers, a branded header with a one-line instruction on each tab, Home and Dashboard links, cleaner tables and clearly marked input cells. Same tested formulas: every result was checked identical to the previous version.
NEW in version 1.1: a one-page Dashboard with the interest and time you save, net savings with an offset vs extra repayments, and a chart; a clickable Home page; and a cleaner layout throughout. Same tested formulas.
Should spare cash go in your offset, into extra repayments, or in a savings account? See the interest and years you'd save on an Australian home loan, after offset fees, and why a savings account usually loses after tax.
- Interactive web version: open it in any browser, change the figures and watch the loan balance chart update
- Excel version included too
- Interest and time saved from a lump sum and/or extra monthly amounts
- Offset vs extra repayments: the same interest saving, less any offset package fee, plus the access and tax differences explained in plain English
- Savings account comparison after tax at your marginal rate (2026-27 rates)
- Month-by-month loan schedule in the Excel version
What you get: 1 interactive .html file and 1 Excel workbook (.xlsx). Example figures included.
General information only, not financial or tax advice. It does not consider your personal circumstances. Your rights under the Australian Consumer Law are not excluded. Questions: hello.plainnumbersco@gmail.com
From Plain Numbers Co: Australian spreadsheets and calculators for property investors, sole traders and families.Want more? See our paid Australian spreadsheets, save 15% on two or more with code BUY2SAVE15 (orders of A$36+), or get all five in the Complete Australian Money Toolkit. Need something we don't sell? We build custom spreadsheets
Designed by Plain Numbers Co with the help of AI tools. Listing images are designed previews of the actual file.
