How the payoff time is worked out
A new loan starts with a term and the repayment follows from it. An existing loan is the reverse problem: the balance, the rate and the repayment are known, and the time left is the unknown. Each repayment first covers the interest charged since the last one, and the rest reduces the balance. Solving the standard loan equation for the number of repayments gives:
n = −ln(1 − B × r ÷ M) ÷ ln(1 + r)
B is the balance owing now. r is the interest rate for one repayment period as a decimal: the yearly rate divided by 12 for monthly repayments, 26 for fortnightly or 52 for weekly. M is the repayment each period. ln is the natural logarithm, and n is the number of repayments left. The answer is rarely a whole number, so it is rounded up and the last repayment is smaller than the rest. When the rate is 0% the formula reduces to B ÷ M.
To go the other way, from a target time to the repayment that achieves it, the usual repayment formula applies, with n set to the number of periods in the target:
M = B × r ÷ (1 − (1 + r)−n)
Worked example: $350,000 owing at 6%, repaying $2,500 a month
- Rate per month. 6% ÷ 12 = 0.5%, so r = 0.005.
- Interest in the next repayment. $350,000 × 0.005 = $1,750. The other $750 of the $2,500 comes off the balance.
- The bracket. B × r ÷ M = $1,750 ÷ $2,500 = 0.7, and 1 − 0.7 = 0.3.
- The logarithms. ln(0.3) = −1.203973 and ln(1.005) = 0.00498754.
- Number of repayments. 1.203973 ÷ 0.00498754 = 241.4, so 241 full repayments and a smaller final one: 242 months, or 20 years and 2 months.
- Interest. Running the loan month by month, the final repayment is $991.61, the total repaid is $603,491.61 and the interest is $253,491.61.
Three ways to shorten it, compared
A higher regular repayment. Adding $300 a month makes the repayment $2,800. The loan is cleared in 197 months (16 years and 5 months), which is 45 months sooner, and the interest falls by $52,854.
A one-off lump sum. Paying $10,000 off the balance today, and keeping the repayment at $2,500, clears the loan in 229 months, 13 months sooner, and saves $22,350 in interest. Each dollar of the lump sum saves about $2.23 of interest because it would otherwise have been charged interest for nearly two decades.
Both together clear the loan in 188 months (15 years and 8 months) and save $68,970. The combined saving is a little less than the two added together, because each one shortens the period over which the other works.
A target time. To be finished in exactly 15 years (180 months), the formula gives a repayment of $2,953.50, which is $453.50 more than now. Interest falls to $181,629.80, a saving of $71,862.
Reading the result
The gap between the repayment and the interest is what matters. In the example only $750 of the first $2,500 reduces the balance, so an extra $300 increases the principal paid that month by 40%, not by 12%. This is why a modest increase has a large effect, and why the effect shrinks as the loan gets older and the interest share falls.
If the repayment is close to the interest, the loan barely moves. At $1,800 a month the example loan would take 719 months, almost 60 years. At $1,750 the repayment equals the interest and the balance never falls; the calculator reports this rather than a payoff time.
The payoff time is very sensitive to the rate. If the rate were 7% with the same $2,500 repayment, the loan would take 292 months instead of 242, and the interest would be $379,170. On a variable rate, rerun the figures whenever the rate or the repayment changes.
Common mistakes: entering the original loan amount instead of the balance owing today; entering a monthly repayment with the frequency set to fortnightly; and counting money held in an offset or redraw account as a lump sum already paid. The method also assumes interest is charged once per repayment period, while many lenders charge it daily, so a statement will differ slightly. Fees and any charge for repaying a fixed-rate loan early are not included.