Skip to main content

Calculator

Mortgage repayment calculator for New Zealand

Enter a loan amount, an interest rate and a term to see what the regular repayment, the total interest and the payoff date could look like. Then test extra repayments, a different rate, or a second scenario beside the first.

Skip to results
Illustrative starting figures. The starting figures are illustrative examples, not market data, a quote or today’s rates. Replace them with your own. The interest rate shown is an example, not today’s market rate.

Your loan

All amounts are in New Zealand dollars (NZD).

How do you want to enter the loan?
$NZD

Use the rate your lender quoted, or one you want to test.

%
years
Repayment frequency

On top of the scheduled repayment. Fixed-rate loans may restrict or charge for extra repayments.

$

Adds scenario B, a copy of A that you can change one input at a time.

The figures you type stay in this browser tab. The calculators do not send them to PropertyKete, to analytics or to anyone else, do not save them to an account, and do not put them in the page address. Reloading the page clears them.

Like every page on this site, these pages load the site-wide measurement tag described in our privacy policy. The calculators do not pass it your figures. Privacy policy.

Repayment $2,997.75 monthly. Total interest $579,193.

Your estimate

Repayment each month
$2,997.75
360 repayments over the term
Total interest
$579,193
Total repaid
$1,079,193
Loan cleared in
30 years
Date shown once your device date is known

Owing half the starting loan. The balance first falls to half the starting loan or less after 21 years, by which point $505,127 of interest has been paid. Early repayments are mostly interest, so this is later than half the term.

Illustrative calculation only. Not an offer of finance or personalised financial advice. Actual repayments, eligibility, rates, fees and interest calculations depend on your lender and circumstances.

How the loan is paid down

Balance owing over time

Balance owing over timeThe balance starts at $500,000 and reaches zero after 30 years. The table below gives the same figures by year.$0$200,000$400,000$600,000Year 0Year 5Year 10Year 15Year 20Year 25Year 30Years from today
  • Balance owing
The balance starts at $500,000 and reaches zero after 30 years. The table below gives the same figures by year.

Where each year’s repayments go

Principal and interest paid each yearEach bar is one year of repayments, split into the part that reduces the loan and the part that is interest. Early years are mostly interest; later years are mostly principal.$0$10k$20k$30k$40k1611162126Loan year
  • Principal repaid
  • Interest paid
Each bar is one year of repayments, split into the part that reduces the loan and the part that is interest. Early years are mostly interest; later years are mostly principal.
Show the year-by-year table
Repayments split into interest and principal for each loan year, with the balance at the end of the year
YearInterestPrincipalTotal paidBalance at year end
Year 1$29,833$6,140$35,973$493,860
Year 2$29,454$6,519$35,973$487,341
Year 3$29,052$6,921$35,973$480,420
Year 4$28,625$7,348$35,973$473,073
Year 5$28,172$7,801$35,973$465,272
Year 6$27,691$8,282$35,973$456,990
Year 7$27,180$8,793$35,973$448,197
Year 8$26,638$9,335$35,973$438,862
Year 9$26,062$9,911$35,973$428,951
Year 10$25,451$10,522$35,973$418,429
Year 11$24,802$11,171$35,973$407,258
Year 12$24,113$11,860$35,973$395,398
Year 13$23,381$12,592$35,973$382,806
Year 14$22,605$13,368$35,973$369,438
Year 15$21,780$14,193$35,973$355,245
Year 16$20,905$15,068$35,973$340,177
Year 17$19,975$15,998$35,973$324,179
Year 18$18,989$16,984$35,973$307,195
Year 19$17,941$18,032$35,973$289,163
Year 20$16,829$19,144$35,973$270,019
Year 21$15,648$20,325$35,973$249,694
Year 22$14,395$21,578$35,973$228,116
Year 23$13,064$22,909$35,973$205,207
Year 24$11,651$24,322$35,973$180,885
Year 25$10,151$25,822$35,973$155,062
Year 26$8,558$27,415$35,973$127,647
Year 27$6,867$29,106$35,973$98,541
Year 28$5,072$30,901$35,973$67,640
Year 29$3,166$32,807$35,973$34,833
Year 30$1,143$34,833$35,976$0

If the interest rate changes

Two separate illustrations. “Repayment recalculated” is what the repayment would need to be to still clear the loan on schedule. “If you kept paying today’s amount” shows what happens to the payoff time if the repayment does not move.

Effect of rate changes on the repayment, total interest and payoff time
RateRepayment recalculatedTotal interestIf you kept paying today’s amount
4.00% (-2)$2,387.08$359,34620 years 4 months
5.00% (-1)$2,684.11$466,27823 years 10 months
6.00% (yours)$2,997.75$579,19330 years
7.00% (+1)$3,326.51$697,54751 years 9 months
8.00% (+2)$3,668.82$820,779Balance never falls: interest alone is about $3,333.33 a month

If the repayment does not cover the interest being charged, the balance never falls and there is no payoff date. The table says so rather than inventing one. These are illustrations at a single steady rate, not a forecast of rates.

Show the working for these numbers
  1. Rate per period = annual rate ÷ periods per year = 6% ÷ 12 = 0.5%.
  2. Number of repayments n = 30 years × 12 = 360.
  3. Scheduled repayment = loan × r ÷ (1 − (1 + r)−n) = $2,997.75, rounded to the nearest cent.
  4. First period: interest = opening balance × r = $500,000.00 × 0.5% = $2,500.00; the rest of the repayment, $497.75, reduces the balance to $499,502.25.
  5. The same step repeats each period on the new balance. Interest is rounded to the nearest cent each period, and the last repayment is whatever clears the final few cents ($3,000.44 here).

This is a periodic-rate (annuity) schedule, not a dated daily-accrual one. Lenders may accrue interest daily, take repayments on different dates, round differently, or change the rate, so their figures can differ from these.

Take the schedule with you

Copy the full repayment schedule to paste into a spreadsheet, or save it as a CSV file. This happens on your device; nothing is uploaded.

What price could my deposit and repayment budget support?

Optional. Starts from your own figures and works the repayment formula backwards. It uses the rate (6.00%), term (30 years) and frequency (monthly) from scenario A. This is not a lender’s borrowing assessment and not a recommendation of what to bid.

Deposit and buying costs both come out of this.

$
$
$
Not a borrowing assessment. This is arithmetic on the cash, costs and repayment you entered. It is not what a lender would lend, and not the price you could buy at or should bid.
Indicative price ceiling (arithmetic only)
$650,374
Loan $500,374 + deposit $150,000
If the rate were 8.00%
$558,850
Loan $408,850

The deposit used is 23.1% of the ceiling price. Upfront costs are taken out of your cash once; they are not added to the price.

What this leaves out. Income, existing debts, living costs, a lender’s own stress test and lending policy, loan-to-value rules, and whether a lender would lend at this deposit level are all excluded. See the Reserve Bank’s loan-to-value page for the rules banks work within.

Illustrative calculation only. Not an offer of finance or personalised financial advice. Actual repayments, eligibility, rates, fees and interest calculations depend on your lender and circumstances.

Next step

Thinking about keeping savings in an offset account? The offset calculator models one loan portion day by day and compares it with the same loan without an offset.

Open the offset calculator

Carries your loan amount, term and frequency across as the total mortgage. You then choose how much of it is offset-eligible.

These calculators do arithmetic on the numbers you enter. They are not a lender’s assessment, a quote, a valuation, or financial, legal or tax advice, and they do not tell you whether you could borrow or what a lender would offer. PropertyKete does not know the price of any home from its address.

What this calculator does

It estimates the regular repayment that would clear a loan of a given size, at a given interest rate, over a given term, paid weekly, fortnightly or monthly. From the same schedule it shows total interest, total repaid and when the loan would be cleared, and how all of that moves if you add an extra repayment or the rate changes.

It can also hold two scenarios side by side, and it can work backwards from the repayment you would be comfortable paying to a rough price ceiling. Every figure is arithmetic on the numbers you type. The rate in the starting figures is an illustration and not today’s market rate; use the rate your lender has quoted or the one you want to test.

How the calculation works

The calculator uses the standard level-payment (annuity) method, one period at a time. The rate for each period is the annual rate divided by the number of periods in a year: 52 for weekly, 26 for fortnightly, 12 for monthly. The number of repayments is the term in years times the same figure.

The regular repayment is the amount that, paid every period at that rate, brings the balance to exactly zero after the last repayment. Each period, interest is the opening balance times the period rate; the rest of the repayment reduces the balance. Interest and repayments are rounded to the nearest cent, and the final repayment is whatever clears the last few cents.

This is a periodic approximation, not a dated daily schedule. Many lenders work out interest daily and charge it on set dates, and the two methods can differ by small amounts over a long loan. The offset calculator on this site uses a day-by-day model for that reason: an offset depends on daily balances and cannot be approximated one period at a time.

A worked example

Borrow $500,000 at 6% a year over 30 years, paid monthly. The rate per month is 0.5%, there are 360 repayments, and the repayment is $2,997.75 a month. Over the full term that is $1,079,193 repaid, of which $579,193 is interest.

Add $200 a month and, with the same rate and the same scheduled repayment, the loan is cleared in 25 years 6 months instead of 30 years, and $103,145 less interest is paid.

Early repayments are mostly interest, so you still owe more than half the loan for longer than half the term. In this example the balance first falls to half the starting loan or less after 21 years, not after 15 years.

Extra repayments

An extra repayment goes straight to the balance, so the interest charged on every later period is a little lower. Held against the same rate and the same scheduled repayment, extra repayments can shorten the loan and cut total interest; they cannot increase interest. The earlier in the loan they are made, the more they save.

Fixed-rate loans may restrict extra repayments or charge for them, and rules differ between lenders and products. Check your loan terms before planning around an extra repayment.

Paying half the monthly amount every fortnight is not the same as paying the monthly amount. There are 26 fortnights in a year, so 26 half-payments add up to 13 monthly payments, not 12. The calculator shows that difference in the annual outlay line when you compare frequencies.

When the rate changes

The rate-change table shows two different things, and they should not be confused. “Repayment recalculated” asks what the repayment would need to be to still clear the loan on schedule at the new rate. “If you kept paying today’s amount” asks how long the loan would take if the repayment stayed where it is.

On the example loan, one percentage point more recalculates the repayment to $3,326.51 a month. Keeping the original $2,997.75 instead stretches the payoff to 51 years 9 months.

If the repayment you keep paying does not cover the interest being charged, the balance never falls. The calculator then says so, rather than showing a payoff date. On the example loan, two points more raises the monthly interest to about $3,333, which is more than the $2,997.75 repayment.

Comparing two scenarios

Add scenario B to test one change against your starting point: a different rate, a shorter term, an extra repayment, a smaller loan, or a different frequency. B starts as a copy of A, the page lists exactly which inputs differ, and the comparison shows repayment, annual outlay, total interest, total repaid and payoff time side by side.

Scenario B is a what-if, not a bank quote. When the two scenarios use different frequencies the repayment per period is not directly comparable, so compare the annual outlay line instead.

A price ceiling from a repayment budget

The optional price-ceiling section runs the repayment formula backwards. From the cash you have, your estimated buying costs, the most you would put toward repayments each period, and the rate and term above, it works out the loan that repayment would clear and adds the deposit left after costs. A second line repeats it at a higher rate.

This is not a borrowing-capacity assessment. A lender looks at income, existing debts, living costs, its own stress tests and its lending policy, and none of that is modelled here. Treat the result as a way to see how a repayment budget, a rate and a deposit interact, and not as the price you could buy at or the amount a lender would lend.

Why your bank’s figure may differ

  • Interest method. Lenders may accrue interest daily and charge it on set dates; this calculator charges one period’s interest at a time.
  • Payment timing. The date of your first repayment, and the day each one is taken, change how much interest builds up.
  • Rate changes. A fixed rate ends; a floating rate can move at any time. This calculator holds one rate for the whole loan unless you test another.
  • Rounding. Lenders round at different steps, so a repayment can differ by a few cents.
  • Fees and loan structure. Establishment fees, split loans with different rates and terms, and offset or revolving facilities are not modelled here.

Common misunderstandings

  • The repayment shown is not guaranteed for the life of the loan. It is the repayment at the rate you entered.
  • Total interest is a projection on one assumed rate. It is not a prediction of what you will pay.
  • A longer term lowers each repayment but raises total interest, because interest is charged on the balance for longer.
  • Weekly and fortnightly repayments are not simply the monthly figure divided up; they change how many payments are made each year.