Early Repayment Calculator NZ: Estimate Loan Savings

An early repayment calculator for New Zealand estimates how extra payments or a lump sum could change a loan’s payoff time and interest, using your balance, interest rate, scheduled payment and planned extra payment. Enter the figures from your lender’s loan information to see an illustrative result; the calculator cannot account for every loan contract or lender charge.

Formula

The calculator uses a standard fixed-rate, monthly-payment approximation. First, it subtracts the lump-sum payment from the balance. It then estimates the number of monthly payments required using:

n = ceil(round(−ln(1 − rB ÷ M) ÷ ln(1 + r), 6)), where r = APR ÷ 1200 and M = scheduled monthly payment + extra monthly repayment.

• B is the balance after the immediate lump sum, in dollars: starting balance minus lump-sum repayment.
• APR is the annual percentage rate entered as a percent, such as 8 for 8%.
• r is the monthly interest rate as a decimal.
• M is the assumed total monthly payment, in dollars.
• n is the estimated number of monthly payments, rounded up to a whole month.

Estimated interest is calculated as M × n − B. The comparison output repeats the month calculation using the original balance and scheduled payment only. The method assumes level payments and a fixed rate; it does not model a final payment that is smaller than the usual monthly amount, so the interest result is an approximation.

Worked Example

Using the calculator’s default inputs: balance $20,000, APR 8%, scheduled payment $500 per month, extra payment $100 per month, and no lump sum:

1. Convert the annual rate to a monthly decimal: r = 8 ÷ 1200 = 0.0066667.
2. The balance after the lump sum is $20,000 − $0 = $20,000. The monthly payment used is $500 + $100 = $600.
3. Apply the payoff formula: n = ceil(round(−ln(1 − 0.0066667 × 20,000 ÷ 600) ÷ ln(1.0066667), 6)) = 38 months.
4. Estimated interest with the extra payment is $600 × 38 − $20,000 = $2,800.
5. For comparison, using $500 per month and no extra payment gives ceil(round(−ln(1 − 0.0066667 × 20,000 ÷ 500) ÷ ln(1.0066667), 6)) = 45 months.

On these assumptions, the calculator estimates repayment about seven months earlier. The actual final payment and total interest may differ because lenders calculate interest and process payments under the terms of each loan.

Assumptions

• The interest rate stays fixed for the whole estimate.
• Payments are made monthly, with the first payment one month after the calculation date; an entered lump sum reduces the balance immediately.
• Interest compounds monthly at APR ÷ 12, represented by the monthly rate in the formula.
• The estimate excludes lender fees, taxes, insurance, PMI and escrow, and does not model changing rates, payment dates, arrears, redraws or other account transactions.

How to Use an Early Repayment Calculator in NZ

Use the current outstanding balance rather than the original amount borrowed. Check your loan statement or online account for the balance and the rate that applies to the loan. Enter the regular payment amount and the additional amount you are considering paying each month. If you plan a one-off payment, enter it as a lump sum. The comparison output estimates the payoff period using the scheduled payment alone.

For an estimate that is closer to your situation, confirm whether the stated payment is monthly and whether it includes any bundled charges. If your loan is split into portions with different rates, calculate each portion separately or obtain a combined repayment projection from the lender; treating different rates as one rate can distort the result. A variable rate also means a long-term projection is only a snapshot of the inputs you entered.

What the Results Mean

The month figures are estimated whole months, not guaranteed payoff dates. A result of 38 months means the formula rounds the calculated period up to 38 monthly payments. The interest output is a simplified total for the assumed payment stream; it is not a lender quote or a precise statement of interest avoided. To estimate a difference in interest, compare like-for-like scenarios and subtract the extra-payment estimate from the no-extra estimate only if both use consistent assumptions.

A critical limitation is that the calculator assumes the payment covers the interest due. If it does not, the logarithm in the formula has no valid repayment result. The extra payment can also be too large relative to the balance: if a lump sum equals or exceeds the balance, the remaining balance is zero or negative and this formula cannot calculate a normal monthly payoff. For those cases, ask the lender for a settlement or payout figure.

NZ Loan Terms, Charges and Common Mistakes

In New Zealand, a personal loan, vehicle loan, home loan or other credit agreement may set its own rules for extra repayments, payment frequency and charges. Whether an early repayment fee applies, and how interest is recalculated, depends on the specific agreement and circumstances. Do not assume that an extra payment is automatically applied to principal in the way this estimate models. Check your contract and ask the lender how an additional payment would be processed and whether a charge or administrative step applies.

• Using the original balance: enter the balance remaining today, not the amount borrowed at the start.
• Entering a percentage incorrectly: use 8 for 8% APR, not 0.08; the calculator divides the percentage by 1200.
• Mixing payment frequencies: this calculator expects monthly payments. Weekly or fortnightly payment amounts cannot be entered as though they were monthly figures.
• Ignoring timing: a lump sum paid later, or an extra payment made on a different date each month, will not match the immediate lump-sum and level monthly-payment assumptions.
• Forgetting charges or rate changes: fees and future rate changes are not included, and could change the actual cost or payoff date.

Frequently Asked Questions

How much interest could I save by paying my loan early?
The calculator estimates interest under the inputs you provide, but its simplified interest total is not a lender’s exact figure. Compare the estimate with and without extra payments, then confirm the effect and any applicable charges with your lender.

Can I use this for a New Zealand mortgage?
You can use it for a rough illustration if the loan is represented by one balance, one fixed rate and monthly payments. It does not model split loans, revolving credit, changing rates, lender-specific break costs or other contract terms.

Does a lump-sum payment reduce the loan balance immediately?
This calculator assumes it does. Ask the lender when the payment would be applied, how interest is treated, and whether the loan agreement permits the payment on those terms.

Why does the calculator show no valid payoff estimate?
The formula requires a payment that covers monthly interest and a positive balance after any lump sum. Check the APR, payment amounts and balance. If a proposed payment clears the loan, request the lender’s payout figure instead.

Are early repayment fees included?
No. Fees and other charges depend on the loan agreement and are not inputs in this calculator. Check the applicable terms with the lender before making a repayment decision.

This result is an estimate; the lender’s disclosure gives the exact figures.

Related

• Loan Calculator With One-Time Extra Payment
• Loan Extra Pay Calculator: See Interest and Time Saved
• JPMorgan Loan Payment Calculator and Formula

in bal | Remaining loan balance | $ | 20000 | 0.01 | 100000000
in apr | Interest rate (APR) | % | 8 | 0.01 | 100
in pmt | Scheduled monthly payment | $ | 500 | 0.01 | 1000000
in extra | Extra monthly repayment | $ | 100 | 0 | 1000000
in lump | One-off repayment now | $ | 0 | 0 | 100000000
out months | Estimated months to repay | months | ceil(round(-ln(1 - (apr / 1200) * (bal - lump) / (pmt + extra)) / ln(1 + apr / 1200), 6)) | 0
out interest | Estimated interest with extra payments | $ | (pmt + extra) * months - (bal - lump) | 2
out base | Estimated months without extra payments | months | ceil(round(-ln(1 - (apr / 1200) * bal / pmt) / ln(1 + apr / 1200), 6)) | 0