Reducing-Balance Loans and Amortisation - TCE Mathematics Applications (Tasmania)
“Model reducing-balance loans with recurrence relations and amortisation tables.”
You must model a reducing-balance loan with the recurrence , build an amortisation table that splits each repayment into interest and principal, and find quantities such as the balance after a payment, the interest paid, and the total cost of the loan.
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.
A loan where interest each period is calculated on the current outstanding balance. A fixed repayment is made each period; part covers the interest just charged and the rest reduces the principal.
The recurrence relation
The balance after each period is found by adding interest then subtracting the repayment.
Here is the interest rate per repayment period and is the fixed repayment. Multiply by first to add interest, then subtract the repayment .
A loan of charges 1 percent per month and is repaid at per month.
Step 1: Identify the recurrence parameters
The annual rate would need dividing by 12 to get a monthly rate, but here we are told directly that the monthly interest rate is 1 percent, so . The fixed monthly repayment is and the initial balance is . These three values fully define the recurrence .
Step 2: Apply the recurrence for month 1
Each period we multiply the current balance by to add one period of interest, then subtract the repayment . Interest accrues on the outstanding balance before the repayment is applied, which is why we multiply first.
Step 3: Apply the recurrence for months 2 and 3
The same rule applies in every subsequent period. Because the balance is now lower, the interest charged is slightly less, so a slightly larger fraction of the payment reduces the principal.
After three months the balance has fallen to about .
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.
For each period: interest balance ; principal reduction repayment interest; new balance old balance principal reduction. As the balance falls, the interest portion shrinks and the principal portion grows.
For the loan above, examine the first repayment.
Step 1: Calculate the interest charged for the period
Interest is charged on the balance outstanding at the start of the period, before any repayment is applied. This is the defining feature of a reducing-balance loan: the lender is entitled only to interest on what is actually owed.
Step 2: Find the principal reduction
The repayment of must first cover the interest just charged; whatever remains goes toward reducing the debt. Subtracting the interest from the repayment gives the principal reduction.
Step 3: Confirm the new balance
Deducting the principal reduction from the opening balance gives the closing balance for the period. This should match the recurrence result exactly.
This confirms the table entry agrees with the recurrence. Of the first repayment, is interest and only pays down the debt. In later months the interest portion is smaller because the balance is lower, so an ever-growing share of each payment clears principal.
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.
Suppose the loan above is fully repaid by 24 monthly payments of and a smaller final payment, with the repayments totalling .
Step 1: Understand what "total repaid" includes
Every dollar paid to the lender over the life of the loan is either returning borrowed principal or paying for the use of that money as interest. Adding up all repayments gives the total outflow, and comparing it to the amount originally borrowed separates the two components. The total of all payments is given as .
Step 2: Calculate the total interest paid
Because the total repaid is the original principal plus all interest charges combined, subtracting the amount borrowed leaves only the interest. This works regardless of how the interest was distributed across the repayments.
Step 3: Interpret the result for the borrower
Borrowing costs an additional in interest, making the total cost of the loan . This figure helps borrowers compare loan options: a lower rate or shorter term reduces the total interest paid, even if individual repayments are higher.
Each period, interest is added to the current balance first, then the repayment is taken off. Calculating principal as repayment minus interest, rather than repayment alone, is what makes the table balance to the recurrence.
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.
A reducing-balance loan does not charge interest on the original amount the whole time. Interest is recalculated on the shrinking balance each period, so applying a flat rate to the starting principal massively overstates the interest. Always charge on the current balance, not the original.
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 questions
Questions in the style of TASC exam questions on this dot point, each with a worked answer. They are written by ExamExplained unless tagged "Past paper"; the year shows the paper a question is modelled on.
Practice2 marksAlex calculates how much they still owe on a home loan after 5 years. They repay each month, interest is p.a. compounding monthly, and the loan lasts 20 years. Their calculation uses the present-value-of-annuity formula with 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.
Practice6 marksUse the interest-factor table for monthly compound interest. a) Find the amount borrowed over a 10-year loan if monthly repayments of are made at p.a. compounded monthly. b) Find the monthly repayment on a loan over 20 years at p.a. compounded monthly. c) How long to repay with monthly repayments of 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).