Reducing-balance loans, amortisation tables and total interest for HSC Maths Standard 2
“Use recurrence relations and amortisation tables to calculate loan repayments, outstanding balances and the total interest paid on a reducing-balance loan”
A reducing-balance loan satisfies with closed form ; build an amortisation table by computing interest on each opening balance, subtracting that from the payment to get principal repaid, and rolling forward; total interest is .
What this dot point is asking
NESA wants you to do five things with a reducing-balance loan. Model it with a recurrence relation, which is a rule that gives each new balance from the one before. Build an amortisation table by hand for a few periods. Find the outstanding balance after payments using the closed-form formula. Split a payment into its interest and principal parts. You should also be able to find the total interest paid over the life of the loan.
The answer
How a reducing-balance loan works
A loan of dollars is repaid by equal payments at the end of each compounding period. Each period two things happen in order:
- Interest is added to the opening balance at the per-period rate .
- The payment is subtracted.
The closing balance is what is still owed, and it becomes next period's opening balance. The balance shrinks a little each period, so the interest charged on it shrinks too. The payment stays the same, so a steadily larger slice of it goes to paying down the principal (the amount you still owe). That is why it is called a reducing-balance loan: the balance the interest is charged on reduces over time. The chart below shows a real loan being paid off.
The closing balance is what is still owed. Let be the balance just after the th payment.
This is the recurrence model, with .
Each period, interest is charged on the opening balance at the per-period rate, then the payment is subtracted: , with . The interest portion of a payment is and the principal portion is . Because the balance falls each period, the interest portion shrinks and the principal portion grows, so early payments are mostly interest and late payments are mostly principal.
Building the amortisation table, row by row
An amortisation table tracks each period in five columns: opening balance, interest, payment, principal repaid, and closing balance. The safest way to build one is one row at a time, carrying each closing balance down to be the next opening balance. Take a $20000 car loan at per month (a p.a. rate) with $400 monthly repayments, and build the first three months stage by stage.
Stage 1, the first month. The opening balance is the full loan, $20000. Interest is , i.e. $100.00. The payment is $400, so the principal repaid is , i.e. $300.00, and the closing balance is , i.e. $19700.00.
| Month | Opening | Interest () | Payment | Principal repaid | Closing |
|---|---|---|---|---|---|
Stage 2, carry the closing balance down. Month opens at last month's close, $19700.00. Interest is , i.e. $98.50 (already lower, because the balance is lower). Principal repaid is , i.e. $301.50, slightly more than last month, and the closing balance is , i.e. $19398.50.
| Month | Opening | Interest () | Payment | Principal repaid | Closing |
|---|---|---|---|---|---|
Stage 3, repeat the pattern. Month opens at $19398.50. Interest is , i.e. $96.99, principal repaid is , i.e. $303.01, and the closing balance is $19095.49.
| Month | Opening | Interest () | Payment | Principal repaid | Closing |
|---|---|---|---|---|---|
Stage 4, read the trend. Watch the two middle columns across the three rows: interest falls () while principal repaid rises (). The payment never changes, but its split shifts steadily from interest towards principal. Continuing this table to the end, the loan is fully repaid at month (the final payment is a little under $400).
| Month | Opening | Interest () | Payment | Principal repaid | Closing |
|---|---|---|---|---|---|
Each row follows the same three rules: interest is the opening balance times the per-period rate; principal repaid is payment minus interest; closing balance is opening plus interest minus payment. The final payment is only $272.27, because after month just $270.92 of principal (plus a final $1.35 of interest) remains. Over the whole loan the borrower pays $23072.27, so the total interest is , i.e. $3072.27.
Closed-form for the balance
Iterating the recurrence using a geometric series gives
The first term, , is what the loan would grow to if no payments were ever made. The second term is the future value of the payments made so far. Future value means what those payments are worth by the time of the th payment, once their own interest is counted. This is the same sum used for superannuation. The difference between the two terms is what is still owed. Use this closed form as a shortcut for "the balance after the th payment" when is too big for a table to be practical.
The recurrence and the formula are two views of the same loan
The table (recurrence) and the closed-form formula always agree, because the formula is just the recurrence iterated times and summed as a geometric series. Use whichever the question points to:
- Recurrence / table when asked to "use an amortisation table", to show the first few months, or to find a principal-versus-interest split for a particular payment.
- Closed form when asked for the balance after many payments (say or ) directly, without building every row.
If both appear, run the table for the first few rows and use the closed form to jump to the period the question wants, then sanity-check that they meet.
Interest vs principal split
For the th payment:
- Interest portion: (interest on the previous closing balance)
- Principal portion:
Early in the loan, most of each payment goes to interest. Near the end, almost all goes to principal. This is why paying extra early saves far more interest than paying the same amount later. An extra dollar paid in month avoids interest for the whole rest of the loan. The same dollar paid near the end avoids almost none, because there is little time left.
Total interest paid
If the loan is repaid by payments of :
That is, total cash paid out minus the original loan amount. (If the final payment is a smaller partial payment, add up the actual payments instead of using .) Total interest is a favourite final part because it turns the abstract schedule into a single dollar figure that shows the real cost of borrowing.
Interest-only versus reducing-balance
A reducing-balance loan pays off both interest and some principal each period, so the balance falls. An interest-only loan pays only the interest each period, , so the principal never changes and the balance stays flat at for the interest-only term. Two consequences worth knowing:
- On an interest-only loan, every payment is identical () and no principal is ever repaid, so the total interest over periods is simply , and you still owe the whole at the end.
- A reducing-balance payment must be larger than the interest-only payment, because it has to cover the interest and chip away at the principal. If a payment equals exactly the interest (), the balance never moves; if it is less than the interest (), the balance actually grows and the loan never finishes. NESA sometimes tests this "does the loan ever finish?" condition.
Australian mortgage context
A typical Sydney mortgage in 2025: $700000 borrowed at around per annum (typical major-bank variable rate, RBA cash rate plus bank margin). Over years monthly:
, .
The repayment formula (also on the reference sheet) gives , i.e. about $4596 per month. Total paid over years is about $1.38 million. Total interest is about $678800, almost as much as the $700000 first borrowed. This is the headline fact about long mortgages: over a few decades you can pay close to double what you borrowed.
How exam questions ask about reducing-balance loans
Each wording maps to one of the tools above:
- "Complete the next row of the table" or "find the balance after the 3rd repayment." A recurrence / amortisation-table question: interest on opening balance, principal = payment minus interest, roll forward.
- "Find the balance owing after the 12th (or th) payment." Use the closed-form .
- "How much of the 5th payment is interest / pays off the loan?" A split question: , principal . Find first (table or formula).
- "Find the monthly repayment / instalment." Use the repayment formula .
- "Find the total interest paid over the life of the loan." Total interest (or sum the actual payments if the last is partial).
- "After how many months is the loan repaid?" Set and solve for with logs; round up to the next whole period (the final payment is partial).
- "Why does so little of an early payment reduce the principal?" An explanation question: interest is charged on the large early balance, so most of is consumed by interest.
Build an amortisation schedule for a $50000 loan at per month with $1100 payments, use the closed-form balance formula to find when the loan is paid off, then calculate monthly repayments on a $650000 mortgage at p.a. over years.
Pay off a $50000 loan by hand and by formula
Compute the first three months of the amortisation schedule: Each month, interest is charged on the current (opening) balance before the repayment reduces it. Because the balance falls slightly each month, the interest charge also falls, so a larger slice of the fixed repayment goes towards principal. Tracking this for the first few months reveals the pattern.
| Month | Opening balance | Interest () | Payment | Principal repaid | Closing balance |
|---|---|---|---|---|---|
| 1 | |||||
| 2 | |||||
| 3 |
Notice the principal portion grows each month (from to to ) and the interest portion shrinks correspondingly.
Apply the closed-form balance formula at : Repeating the table for 60 rows by hand is impractical. The closed-form formula computes the balance after periods directly. We substitute to check whether the loan survives five years.
A negative balance means the repayments overshoot zero before months have passed, so the loan is fully repaid before the five-year mark.
Solve for the exact number of months: Setting the balance formula equal to zero and solving for gives the precise payoff month. We rearrange to isolate on one side, then take logarithms.
The loan is paid off in months (the final payment is slightly less than $1100).
Repayment and total interest on an Australian mortgage
For the mortgage we use the repayment formula directly. The monthly rate is , so and for a 30-year term. Computing first keeps the arithmetic manageable.
, .
i.e. about $3897.08 per month.
Find the total interest paid: Multiplying the monthly repayment by the number of payments gives the total amount paid to the bank. Subtracting the original loan reveals how much of that total was interest, not principal.
In dollars, the total paid is about $1402948.80 and the total interest about $752948.80.
Final answer: The $50000 loan is paid off in months. The $650000 mortgage at p.a. over years requires a monthly repayment of approximately $3897.08, with total interest of $752948.80.
Edge case: interest-only versus reducing-balance, same loan
Take the $650000 at p.a. ( per month) from the worked example. An interest-only payment would be , i.e. $3250 per month. Compare:
- Interest-only: pay $3250 a month, the balance stays at $650000 forever, and after, say, years ( months) you have paid , i.e. $195000 in interest and still owe the full $650000.
- Reducing-balance: pay $3897.08 a month (about $647 more), and the loan is gone in years with the principal fully cleared.
The extra $647 a month is exactly what buys down the principal. This is why interest-only periods lower the payment in the short term but cost more overall: nothing is being repaid.
Lay the amortisation table out with the five standard columns (opening, interest, payment, principal repaid, closing) and label them; markers award method marks for the correct structure even if one number slips. Compute interest on the opening balance, not the closing one. Carry full cents down each row, and round only the final reported figure. For "balance after the th payment" use the closed form and show the substitution; for "complete the table" use the recurrence. State total interest as with a sentence saying it is total payments minus the amount borrowed. If asked whether a loan ever finishes, compare the payment with the first interest charge : if it never does.
- Using simple interest
- Loan interest is added to the balance each period, then the next interest is calculated on the new balance. Compound, not simple.
- Computing interest on the closing balance
- Interest is charged on the opening balance for the period, before the payment is subtracted.
- Forgetting to convert the rate
- Monthly compounding requires the monthly rate . Using the annual rate gives a wildly wrong answer.
- Wrong sign on the closed form
- The balance formula subtracts the payment term. Sign errors mean you compute the wrong direction.
- Treating principal repaid as constant
- Early payments are mostly interest; the principal repaid grows each period, so the balance does not fall in equal steps.
- Ignoring the no-completion case
- If , the loan never finishes because the payment does not even cover the interest. A worded problem may test this.
A reducing-balance loan is the normal kind of loan you use to buy a car or a house. You pay the same amount every month, but that money does two jobs at once. Part of it pays the rent on the money you still owe (the interest), and the rest pays back a bit of what you borrowed. Each month you owe a little less, so the interest part gets smaller and the part that pays off the loan gets bigger. That is why paying extra early helps so much: it cuts down the amount you are charged interest on for years to come.
Exam-style questions
Questions in the style of NESA 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.
2022 HSC-style5 marksA car loan of $25000 at per annum compounded monthly is repaid by monthly instalments of $498.21. Find the balance owing immediately after the 12th payment. Round to the nearest cent.Show worked answer →
Per-period rate: . Monthly payment .
The balance after payments is
.
.
, i.e. $20680.79.
Markers reward the outstanding-balance formula, accurate intermediate values, and the answer rounded to cents.
2021 HSC-style4 marksUse an amortisation table to find the balance after monthly repayments of $1200 on a $60000 loan at per annum compounded monthly.Show worked answer →
Per-period rate: .
Month : opening , interest , payment , principal repaid , closing .
Month : opening , interest , payment , principal repaid , closing .
Month : opening , interest , payment , principal repaid , closing , i.e. $57286.48.
Markers reward a clean amortisation table layout, interest computed on the opening balance each period, principal repaid as payment minus interest, and the closing balance.
Practice questions
Original practice questions graded from foundation to exam level, each with a full worked solution. Try them before revealing the solution.
foundation1 markThe first three rows of the amortisation table for a $15000 personal loan with monthly repayments of $450 are shown.
| Month | Opening | Interest | Payment | Principal repaid | Closing |
|---|---|---|---|---|---|
| | | | | | |
| | | | | | |
| | | | | ? | |
Read the interest charged in month from the table, then find the principal repaid in month (the value marked ?).
Show worked solution →
Read the interest from the table. The month row shows the interest charged is $71.24.
Find the principal repaid. Principal repaid is the payment minus the interest:
i.e. $378.76.
State the answer. The principal repaid in month is $378.76.
Check. The closing balance equals the opening balance minus the principal repaid: , which matches the table.
foundation2 marksA personal loan of $18000 is charged interest at per month and repaid by monthly instalments of $500. Complete the first row of the amortisation table: find the interest charged in month , the principal repaid, and the closing balance.Show worked solution →
Interest on the opening balance. Month opens at the full loan, $18000. Interest is the opening balance times the per-period rate:
i.e. $90.00.
Principal repaid. The payment is $500, and principal repaid is payment minus interest:
i.e. $410.00.
Closing balance. The closing balance is opening plus interest minus payment:
i.e. $17590.00.
Check. Closing balance equals opening minus principal repaid: , which matches.
foundation2 marksA $9000 personal loan is fully repaid by equal monthly instalments of $415.50. Find the total interest paid over the life of the loan.Show worked solution →
Find the total amount paid. With every instalment the same, the total paid is the number of payments times the payment:
i.e. $9972.00.
Subtract the amount borrowed. Total interest is total paid minus the principal:
i.e. $972.00.
State the answer. The total interest paid over the life of the loan is $972.00.
Check. The interest is a small fraction of the $9000 borrowed, which is reasonable for a short year loan.
foundation3 marksMia has a reducing-balance loan charged at per annum compounded monthly, repaid by monthly instalments of $620. Just before her next repayment the balance owing is $12350. Find the interest portion and the principal portion of that repayment, and the new balance owing afterwards.Show worked solution →
Convert the rate. Monthly compounding uses the monthly rate:
Interest portion. Interest is charged on the balance owing before the payment:
i.e. $55.58.
Principal portion. Principal repaid is the payment minus the interest:
i.e. $564.42.
New balance. Subtract the principal repaid from the old balance:
i.e. $11785.58.
Check. The two portions add to the payment: , which matches.
core4 marksA $25000 car loan is charged interest at per month with normal monthly repayments of $600. In the very first month the borrower pays an extra $1000, so the month payment is $1600. (a) Find the balance owing after the month payment of $1600. (b) Find the interest charged in month , and state how much less it is than the $122.63 that would have been charged without the extra repayment.Show worked solution →
Part (a), interest in month 1. Interest is charged on the opening balance $25000 at :
i.e. $125.00.
Closing balance after the $1600 payment. Closing is opening plus interest minus the payment:
i.e. $23525.00.
Part (b), interest in month 2. Month opens at $23525.00, so
i.e. $117.63.
- Compare with no extra repayment
- The interest is less, i.e. $5.00 less.
- State the answer
- The balance after month is $23525.00, and the month interest is $117.63, which is $5.00 less than it would have been.
- Check
- The extra $1000 of principal saves one month's interest of , matching the $5.00 reduction.
core4 marksA $30000 car loan is charged interest at per month and repaid by monthly instalments of $650. Use an amortisation table to find the balance owing immediately after the third repayment, showing each row.Show worked solution →
- Set up the rule for each row
- The per-period rate is . For each month: interest is the opening balance times , principal repaid is minus that interest, and the closing balance is opening plus interest minus . Carry each closing balance down as the next opening balance.
- Month 1
- Opening $30000. Interest . Principal repaid . Closing .
- Month 2
- Opening $29500. Interest . Principal repaid . Closing .
- Month 3
- Opening $28997.50. Interest . Principal repaid . Closing .
| Month | Opening | Interest | Payment | Principal repaid | Closing |
|---|---|---|---|---|---|
State the answer. The balance owing immediately after the third repayment is $28492.49.
Check. Interest falls each month () while principal repaid rises (), as expected for a reducing-balance loan.
core4 marksA $40000 loan is charged interest at per annum compounded monthly and repaid by monthly instalments of $780. Use the formula to find the balance owing immediately after the th repayment. Round to the nearest cent.Show worked solution →
Convert the rate and list the values. Monthly compounding gives
with , and .
Find the growth factor.
Substitute into the formula.
Evaluate each term. The first term is . The annuity factor is , so the second term is .
State the answer. The balance owing immediately after the th repayment is $33072.95.
Check. Twelve payments total , but the balance has fallen by only ; the difference is the interest charged over the first year, which is positive and less than a full year's interest on the opening balance (), as expected since the balance is shrinking.
core3 marksA $20000 car loan at per month is repaid by monthly instalments of $400. The amortisation table shows the balance after the fourth repayment is $18790.97. Find the interest portion and the principal portion of the fifth repayment.Show worked solution →
Identify the balance the interest is charged on. The fifth payment's interest is charged on the balance after the fourth payment, which is the opening balance for month : $18790.97.
Interest portion. Interest is the opening balance times the per-period rate :
i.e. $93.95.
Principal portion. Principal repaid is the payment minus the interest:
i.e. $306.05.
State the answer. Of the fifth repayment, $93.95 is interest and $306.05 reduces the principal.
Check. The two portions add to the payment: , which matches.
exam5 marksThe Tran family have a $300000 home loan charged at per annum compounded monthly, with normal monthly repayments of $1934.
(a) Construct the first two rows of the amortisation table, showing the opening balance, interest, payment, principal repaid and closing balance for each month.
(b) In month the family use a tax refund to pay an extra $5000 on top of their normal $1934 repayment. Find the balance owing immediately after the month payment.
(c) Hence find the interest charged in month , and state how much less it is than the $1493.46 that would have been charged in month without the extra repayment.
Show worked solution →
- Part (a), set up the monthly rate
- Monthly compounding gives . For each row: interest is the opening balance times , principal repaid is minus that interest, and closing is opening plus interest minus .
- Month 1
- Interest . Principal repaid . Closing .
- Month 2
- Opening $299566.00. Interest . Principal repaid . Closing .
| Month | Opening | Interest | Payment | Principal repaid | Closing |
|---|---|---|---|---|---|
Part (b), month 3 with the extra repayment. Month opens at $299129.83. Interest . The payment is , so
i.e. $293691.48.
Part (c), month 4 interest. Month opens at $293691.48, so
i.e. $1468.46. This is less, i.e. $25.00 less.
State the answer. After month the balance is $293691.48, and the month interest is $1468.46, which is $25.00 less than without the extra repayment.
Check. The extra $5000 of principal saves one month's interest of , matching the $25.00 reduction.
exam5 marksThe Nguyen family borrow $360000 for a home at per annum compounded monthly, repaid over years. (a) Use the repayment formula to find the monthly repayment, to the nearest cent. (b) Find the total amount of interest paid over the life of the loan.Show worked solution →
Part (a), convert the rate and term. Monthly compounding over years gives
Find the discount factor.
Substitute into the repayment formula.
i.e. about $2319.49 per month.
Part (b), total interest. Total interest is total payments minus the amount borrowed, with :
State the answer. The monthly repayment is about $2319.49, and the total interest paid is about $335847.00.
Check. The total interest is just under the amount borrowed, which is typical for a -year loan at this rate, so the figure is the right order of magnitude.
exam4 marksA borrower takes a $50000 loan at per annum compounded monthly and plans to repay it with monthly instalments of $370. By comparing the repayment with the first month's interest, explain whether this loan will ever be repaid, and describe what happens to the balance.Show worked solution →
Convert the rate. Monthly compounding gives
Find the first month's interest. Interest is charged on the opening balance $50000:
i.e. $375.00.
Compare the repayment with the interest. The repayment is $370, which is less than the interest of $375. So the payment does not even cover one month's interest. Formally, the loan finishes only if ; here and , so .
Describe what happens to the balance. Since the payment is $5 short of the interest in month , the unpaid $5 of interest is added to the balance:
i.e. the balance rises to $50005.00. The balance grows every month, so the interest charged grows too, and the gap widens.
State the answer. The loan is never repaid: because the $370 repayment is smaller than the $375 monthly interest, the balance increases each month instead of falling.
Check. The condition for a loan that never finishes is satisfied (), confirming the conclusion.
exam5 marksA $45000 loan is charged interest at per annum compounded monthly and repaid by monthly instalments of $900. (a) By setting the balance to zero and using logarithms, find the number of months needed to repay the loan. (b) Find the value of the smaller final payment.Show worked solution →
Part (a), set up the equation. With , and , set the closed-form balance to zero:
Rearrange to isolate the power. Note , so
Collecting the terms gives
Take logarithms.
Since the th payment leaves a small balance still owing, a th (smaller) payment is needed, so the loan is repaid in months.
Part (b), find the final payment. After full payments the balance owing is $609.56 (from the closed form with ). The final payment must clear this balance plus its one month of interest:
i.e. $612.61.
State the answer. The loan is repaid in months, with a smaller final payment of $612.61.
Check. The final payment $612.61 is less than the regular $900, as expected for a partial last instalment, and applying it to the month- opening balance of $609.56 leaves , so the loan clears exactly.