How does a loan balance fall as repayments are made, and how is interest split out?
Model reducing-balance loans with recurrence relations and amortisation tables.
Reducing-balance loans, recurrence relations, amortisation tables splitting interest from principal, and total interest paid in TCE Mathematics Applications.
Reviewed by: AI editorial process; not yet individually human-reviewed
Have a quick question? Jump to the Q&A page
What this dot point is asking
A reducing-balance loan charges interest only on the amount still owing. Because the balance falls with every repayment, the interest charged each period also falls, so a larger slice of each fixed repayment goes toward the principal as time passes.
The recurrence relation
The balance after each period is found by adding interest then subtracting the repayment.
The amortisation table
An amortisation table records, for each period, the interest charged, the principal repaid, and the new balance. It makes the inner workings of each repayment visible.
Total interest paid
The total interest over the life of the loan is the sum of all repayments minus the amount originally borrowed. This is often the figure that surprises borrowers, because over many years the interest can rival the principal.
The final repayment
The last repayment is usually smaller than the rest, because a full fixed repayment would overshoot and leave a negative balance. The final payment is exactly the outstanding balance plus its final period of interest, clearing the loan to zero.
Finding the balance owing partway through
A subtle exam point, tested in the first question above, is the difference between the value of payments already made and the balance still owing. The balance owing after some payments equals the present value of the payments that remain, so you must use the number of payments left, not the number made. With the finance solver, enter the original loan as , the repayment as , and the number of remaining periods as , then read as the outstanding balance, or solve for using the remaining payments. Confusing payments made with payments remaining is the single most common error in loan questions.
A complete answer uses with as the per-period rate, splits at least one repayment into interest and principal, uses the remaining payments when finding a balance partway through, and where asked finds total interest as total repayments minus the amount borrowed.
Exam-style practice questions
Practice questions written in the style of TASC exam questions on this dot point, with worked answer explainers. The year tag is the paper they imitate, not the source.
TCE 20242 marksAlex calculates how much they still owe on a home loan after 5 years. They repay \9007\%n = 5 \times 12$ in the exponent. What common error have they made?Show worked answer →
(2 marks) The formula Alex used finds the present value of only the payments made over 5 years, not the balance still owing after 5 years.
To find the amount outstanding after 5 years you must use the number of payments still left, which is the remaining 15 years: , not . By substituting 60 they have valued the wrong set of payments. The correct balance owing is the present value of the 180 remaining repayments.
TCE 20236 marksUse the interest-factor table for monthly compound interest. a) Find the amount borrowed over a 10-year loan if monthly repayments of \1665.316\%\ loan over 20 years at p.a. compounded monthly. c) How long to repay \5000\ at p.a. compounded monthly?Show worked answer →
a) (2 marks) Amount borrowed repayment factor, where the factor is read from the table for () and . This gives amount borrowed .
b) (2 marks) Rearrange to repayment loan factor, using and . The factor gives a monthly repayment of about .
c) (2 marks) Here factor . Find this factor in the column of the table; it corresponds to , so the loan is repaid in 12 months (1 year).
