The two questions and their formulas
Both parts of this page use the equation for a debt repaid in equal instalments, solved for a different unknown each time.
How long does a given repayment take?
n = −ln(1 − P × r ÷ PMT) ÷ ln(1 + r)
What repayment clears the debt in a given number of periods?
PMT = P × r ÷ (1 − (1 + r)−n)
P is the amount owing. r is the interest rate for one repayment period as a decimal: the yearly rate ÷ 12 for monthly repayments, ÷ 26 for fortnightly, ÷ 52 for weekly. PMT is the repayment each period, n is the number of repayments and ln is the natural logarithm. For the date question, n is the number of whole repayment periods between the start date and the target date, with the first repayment one period after the start. At 0% the formulas become n = P ÷ PMT and PMT = P ÷ n.
The first formula rarely gives a whole number. The calculator makes the whole repayments, then a smaller final one for what is left, and counts interest on that basis.
Worked example: $12,000 at 15% a year
With monthly repayments r = 15% ÷ 12 = 1.25% = 0.0125, so the first month’s interest is $12,000 × 0.0125 = $150.
Debt-free in two years
- Starting on 15 January 2026 with a target of 15 January 2028, there are 24 monthly repayments, the first on 15 February 2026 and the last on the target date.
- 1.0125−24 = 0.742197, and 1 − 0.742197 = 0.257803.
- PMT = $150 ÷ 0.257803 = $581.84 a month.
- Total repaid is 24 × $581.84 = $13,964.15 (using the unrounded repayment), so the interest is $1,964.15.
Allowing a third year (36 repayments) brings the repayment down to $415.98 and lifts the interest to $2,975.42. Paid fortnightly instead, the same two years hold 52 repayments of $267.77, and the interest is $1,924.19.
Four amounts side by side
| Repayment | Repayments | Time | Interest |
|---|---|---|---|
| $250 | 74 | 6 years 2 months | $6,440.40 |
| $300 | 56 | 4 years 8 months | $4,739.59 |
| $400 | 38 | 3 years 2 months | $3,134.26 |
| $600 | 24 | 2 years | $1,895.36 |
To check one row by hand, take $300: P × r ÷ PMT = $150 ÷ $300 = 0.5, ln(0.5) = −0.693147 and ln(1.0125) = 0.012423, so n = 0.693147 ÷ 0.012423 = 55.8. That is 55 repayments of $300 and a final one of $239.59, for 55 × $300 + $239.59 = $16,739.59 repaid and $4,739.59 of interest.
Reading the comparison
The table shows a pattern that holds for every debt: the first dollars above the interest do the most work. Going from $250 to $300 adds $50 a month, finishes 18 months sooner and saves $1,700.81. Going from $400 to $600 adds $200 a month, four times as much, yet finishes 14 months sooner and saves $1,238.90. Each step up still helps, but by less.
The reason is the $150. Only the part of a repayment above the period’s interest reduces the debt. At $250 that part is $100; at $300 it is $150, half as much again, for one-fifth more outlay. Near the interest level the effect is extreme: $160 a month, just $10 above the interest, takes 224 repayments (18 years 8 months) and costs $23,710.64. At $150 or less the debt is never repaid, and the calculator says so instead of giving a time.
What to keep in mind
- Whole periods only. If the target date falls part-way through a period, the calculator uses the last full repayment date on or before it, so you finish slightly early rather than late.
- Month ends. A monthly schedule that starts on the 31st uses the last day of shorter months.
- Frequency changes the rate per period, not just the amount. Fortnightly is 26 repayments a year, not 24, so a fortnightly amount is a little less than half the monthly one.
- A fixed rate and no new borrowing are assumed. On a credit card, new purchases and a minimum repayment that shrinks with the balance change the picture; see the credit card calculator below.
- Fees are not included, and no lender’s early-repayment rules are applied.