CalcTrace

Loan Payment Calculator

Answer either of the two questions borrowers ask. If you know how long you want the loan to run, find the repayment. If you know what you can afford to pay, find how long the loan will take to clear and what it will cost.

Last updated .

What do you want to find?

I know the

Repayment frequency

Result

Monthly repayment

– per month

–Number of repayments
–Interest in first repayment
–Total interest
–Total repaid

What you repay

    What a different term would do

    TermRepaymentTotal interest
    Show the working

      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

      1. n = 4 × 12 = 48 repayments.
      2. 1.01−48 = 0.620260, and 1 − 0.620260 = 0.379740.
      3. PMT = $150 ÷ 0.379740 = $395.01 a month.
      4. 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

      1. P × r ÷ PMT = $150 ÷ $400 = 0.375, and 1 − 0.375 = 0.625.
      2. ln(0.625) = −0.470004, and ln(1.01) = 0.00995033.
      3. n = 0.470004 ÷ 0.00995033 = 47.2, to one decimal place.
      4. 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.
      5. 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:

      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.