Mortgage repayment calculator methodology
Amortisation, rate-change and offset assumptions.
Scheduled monthly repayment
Using principal B, monthly nominal interest rate r (annual percentage divided by 1200), and n months, scheduled repayment is B × r / (1 − (1+r) to the power −n). At 0% interest it is B / n. At the entered rate-change month, the scheduled payment is recalculated for the outstanding balance over the remaining original term.
Monthly interest and principal
Interest in month m is max(0, outstanding balance less offset balance) × nominal annual percentage / 1200. Principal paid is scheduled plus extra repayment less interest, capped at outstanding principal. Offset balances may grow monthly; they reduce interest but are not principal repayments. A fully offset mortgage may still require scheduled repayments.
Interpretation
The calculator returns initial scheduled repayment, total interest, monthly schedule, actual total repayments, payoff month and a no-extra/no-offset interest baseline using the same rate-change assumption. The full schedule is exportable as CSV.
Limitations
This is a month-end payment model with nominal annual rate divided by 12. Many Australian lenders accrue daily interest and apply lender-specific posting, frequency and minimum-repayment adjustments. Monthly offset changes take effect at the beginning of each model month. It does not calculate fees, tax or lender approval.
Verification examples
- $600,000 at 6% over 30 years: approximately $3,597.30 scheduled payment per month.
- $12,000 at 0% over 12 months: $1,000 monthly, no interest.
- Full offset of loan balance: zero interest while the offset fully covers principal.
- A rate change in month 1 yields the same amortisation as a loan starting at that new rate.
Independent numerical fixtures: tests/gps-mortgage-math.test.js.
Sources: Moneysmart mortgage calculator; Moneysmart mortgage offset accounts.