The equation the rate is hidden in
A loan with equal repayments obeys one equation. When you know the rate it gives the repayment directly:
PMT = P × r ÷ (1 − (1 + r)−n)
PMT is the repayment each period, P is the amount borrowed, n is the number of repayments and r is the interest rate for one repayment period as a decimal. Here you know PMT, P and n and want r. The yearly rate shown as the result is r multiplied by the number of repayments in a year, which is how loan rates are normally quoted.
Why there is no formula for the rate
Try to rearrange the equation for r and you get stuck, because r appears twice: once on its own and once inside a power. Clearing the fraction gives
P × r × (1 + r)n = PMT × ((1 + r)n − 1)
which is a polynomial in r of degree n + 1. For a five-year monthly loan that is degree 61. Mathematics has general formulas for polynomials only up to degree four, and nothing in this equation lets you isolate r by algebra once there are more than a couple of repayments. So the rate is found the way every spreadsheet and financial calculator finds it: by trying values and improving them until the equation balances.
This calculator uses bisection. It relies on one fact: a higher rate always means a higher repayment. So if a trial rate gives a repayment that is too low, the true rate is higher; if too high, the true rate is lower. Start with a range that must contain the answer, test the middle, keep the half that contains the answer, and repeat. Each step halves the uncertainty, so after 20 steps a range two percentage points wide has shrunk to less than 0.000002 of a point.
Worked example: $20,000 over 5 years at $400 a month
- Start with the totals. 60 repayments of $400 come to $24,000, so the interest is $4,000.
- Try 6%. r = 0.005 and the formula gives a repayment of $386.66. That is less than $400, so the rate is above 6%.
- Try 8%. The repayment would be $405.53. Too much, so the rate is between 6% and 8%.
- Try the middle, 7%. $396.02: too low. The rate is between 7% and 8%.
- Try 7.5%. $400.76: slightly too high. Between 7% and 7.5%.
- Try 7.25%. $398.39: too low. Between 7.25% and 7.5%.
- Try 7.375%. $399.57: too low. Try 7.4375%. $400.17: too high.
- Keep halving. The range closes in on 7.42%. Check: at 7.42% the formula gives $400.00.
Flat rate versus reducing-balance rate
The 7.42% above is a reducing-balance rate: each period’s interest is charged only on what you still owe, so the interest charge falls as you repay. Home loans and most personal loans are quoted this way.
A flat rate charges interest on the full amount borrowed for the entire term, as though you never repaid a cent until the end:
Flat rate = total interest ÷ P ÷ years
Repayment at a flat rate = P × (1 + flat rate × years) ÷ n
For the example, $4,000 ÷ $20,000 ÷ 5 = 0.04, a flat rate of 4% a year. It is the very same loan with the very same repayments, yet one description says 4% and the other says 7.42%. The flat figure is lower because it measures the interest against the full $20,000, when the average amount you actually owe across the five years is only a little over half of that.
For loans of a few years the reducing-balance rate is close to double the flat rate (about 1.9 times here). A $10,000 loan at a flat 5% over 3 years has repayments of $319.44 a month, which is a reducing-balance rate of 9.31%. The gap is not a fixed ratio, though: $100,000 at 6% over 30 years has a flat equivalent of 3.86%. Never compare a flat rate on one loan with a reducing-balance rate on another. Convert both to the same basis first, which is what the “A flat rate” option above does.
Reading the result
Nominal and effective rates
The headline figure is the nominal yearly rate: the rate per period times the number of periods. Because interest is charged every period, the cost over a full year is slightly more. The effective annual rate allows for that:
Effective annual rate = (1 + r)m − 1
where m is the number of repayment periods in a year. In the example r is 0.6183% a month, so the effective annual rate is 7.68%. Use the nominal rate to compare with advertised loan rates and the effective rate to compare loans with different repayment frequencies.
Fees change the answer
The calculator sees only the numbers you give it. If a $500 fee was taken out of the loan so that you received $19,500 but still repay $400 a month for five years, enter $19,500 as the amount borrowed: the rate you are effectively paying is 8.49%, not 7.42%.
Limits
The method assumes equal repayments at regular intervals, the first one a full period after the loan starts, and nothing left owing at the end. It does not suit loans with a balloon payment, an interest-only period or a rate that changes. If your repayments add up to less than the amount borrowed, no positive rate fits and the calculator says so.