One equation, solved in two directions
A loan with equal repayments is described by a single equation linking four things: the amount borrowed, the interest rate, the repayment and the number of repayments. Fix any three and the fourth follows. This page solves it for the two unknowns people most often need.
Fixed term: find the repayment
PMT = P × r ÷ (1 − (1 + r)−n)
Fixed repayment: find the number of repayments
n = −ln(1 − P × r ÷ PMT) ÷ ln(1 + r)
P is the amount borrowed. r is the interest rate for one repayment period as a decimal: the yearly rate ÷ 12 for monthly repayments, 26 for fortnightly or 52 for weekly. n is the number of repayments. PMT is the repayment each period. ln is the natural logarithm, the “ln” key on a scientific calculator. The second formula is the first one rearranged to make n the subject. At a 0% rate they reduce to PMT = P ÷ n and n = P ÷ PMT.
Worked example: $15,000 at 12% a year
With monthly repayments, r = 12% ÷ 12 = 1% = 0.01. The first month’s interest is $15,000 × 0.01 = $150.
If the term is fixed at 4 years
- n = 4 × 12 = 48 repayments.
- 1.01−48 = 0.620260, and 1 − 0.620260 = 0.379740.
- PMT = $150 ÷ 0.379740 = $395.01 a month.
- Total repaid is 48 × $395.0075 = $18,960.36 (using the repayment before it is rounded to the cent), so the interest is $3,960.36.
If the repayment is fixed at $400 a month
- P × r ÷ PMT = $150 ÷ $400 = 0.375, and 1 − 0.375 = 0.625.
- ln(0.625) = −0.470004, and ln(1.01) = 0.00995033.
- n = 0.470004 ÷ 0.00995033 = 47.2, to one decimal place.
- You cannot make 0.2 of a repayment. The answer means 47 full repayments of $400 and then a smaller final one. After 47 repayments $93.41 is still owing; with one more month’s interest the final repayment is $94.35.
- Total repaid is 47 × $400 + $94.35 = $18,894.35, so the interest is $3,894.35. The loan takes 48 months: 4 years.
When the loan never ends
Look at the term inside the logarithm: 1 − P × r ÷ PMT. If the repayment equals the interest for the period, that term is zero; if the repayment is smaller, it is negative. Neither has a logarithm, and that is the mathematics telling you there is no answer. A repayment of $150 a month on the example loan pays exactly the interest and nothing else, so the balance stays at $15,000 forever. Pay less than $150 and the balance grows.
The practical rule: a repayment must be larger than P × r, the interest charged in one period, before it reduces the debt at all. The calculator shows this figure and warns you when your repayment does not clear it.
Small increases matter most near the minimum
Time to repay does not shrink in proportion to the repayment. On the example loan:
- $160 a month, only $10 above the interest, takes 279 repayments: 23 years and 3 months.
- $200 a month takes 140 repayments (11 years and 8 months) and costs $12,864.50 in interest.
- $300 a month takes 70 repayments (5 years and 10 months) and costs $5,898.55.
- $400 a month takes 48 repayments (4 years) and costs $3,894.35.
- $500 a month takes 36 repayments (3 years) and costs $2,923.09.
Doubling the repayment from $200 to $400 cuts the time by about two-thirds, not half, and saves about $8,970 in interest. The reason is that only the part of each repayment above the interest reduces the debt. At $200, just $50 of the first repayment comes off the balance; at $400 it is $250, five times as much.
What to watch for
Use the rate for the period, not the yearly rate, in both formulas; putting 0.12 where 0.01 belongs is the most common error when working by hand. Keep the frequency consistent too: a fortnightly repayment needs the yearly rate ÷ 26.
The result assumes a constant repayment and a fixed rate. Credit cards and other revolving accounts usually set a minimum repayment that falls as the balance falls, which stretches the payoff time far beyond what this calculator shows for a constant amount. Fees are not included.