Lesson 5 of 7 · 16 min
Reducing balance loans and pensions, step by step
Model a reducing balance loan or a retirement pension with , track the balance period by period, and split each payment into interest and principal.
What you will be able to do
- Explain what an ordinary annuity is: interest is calculated before each payment is made.
- Write the recurrence relation , with its starting value, for a loan or a pension.
- Use the recurrence relation to find the balance after a few periods.
- Find how much of a payment is interest and how much reduces the balance.
A home loan, a car loan or a personal loan is not left to grow. Each month the bank charges interest on what you still owe, and then your repayment comes off. Early on, most of each repayment goes on interest; as the balance falls, more and more of it pays down the loan. This is a reducing balance loan.
A retirement pension works the same way in reverse roles: a lump sum (say, your superannuation) earns interest each month, and then your pension payment is withdrawn. Both are ordinary annuities — equal payments, with each period's interest calculated before that period's payment.
Definition
The reducing balance recurrence relation
- is the starting amount: the amount borrowed, or the lump sum in the pension fund
- is the balance after payments
- is the interest rate per period and is the periodic payment
Read it as: add this period's interest (multiply by ), then subtract the payment. The relation is in the QCAA formula book.
Worked example
The first three months of a car loan
Aisha borrows $20 000 for a car at 7.2% p.a. compounded monthly and repays $500 at the end of each month.
(a) Write a recurrence relation for the balance owing after months.
(b) Complete a table showing the interest and the balance for the first 3 months.
(c) How much of the loan has she paid off after 3 months?
Step 1: Write the recurrence relation
, so , .
Step 2: Month 1
Interest . Balance .
Step 3: Month 2
Interest . Balance .
Step 4: Month 3
Interest . Balance .
Each month the interest is a little smaller, because it is charged on a smaller balance — so a little more of the $500 reduces the loan.
Step 5: Set out the table
Month Opening balance Interest Repayment Closing balance 1 $20 000.00 $120.00 $500 $19 620.00 2 $19 620.00 $117.72 $500 $19 237.72 3 $19 237.72 $115.43 $500 $18 853.15 Step 6: Find the principal repaid
. Of the $1500 she has repaid, $353.15 was interest.
Try it yourself first, then check the working one step at a time.
Answer
(a) , . (b) Balances $19 620.00, $19 237.72 and $18 853.15. (c) $1146.85 of the loan has been repaid.
Method
Write with = amount borrowed.
Each period: interest , then new balance .
Principal repaid = amount borrowed − balance.
Watch out for
Subtracting the repayment before adding the interest.
Saying she has paid off $1500. Only the part of each repayment above the interest reduces the loan.
In the table, the interest column shrinks each month and the balance falls a little faster each time. Lower the repayment to $120: that only covers the first month's interest, so the balance never falls. Raise it and see how much sooner the loan is repaid.
Noah borrows $30 000 at 8.4% p.a. compounded monthly. How much interest is charged in the first month?
Noah repays $620 a month on the $30 000 loan at 8.4% p.a. compounded monthly. Use the recurrence relation , , to find the balance after 2 repayments, correct to the nearest cent.
Key idea
Interest and principal in each payment
In any period:
- interest charged
- principal repaid
In Noah's first month, $210 of his $620 is interest and only $410 reduces the loan. For the balance to fall at all, the payment must be more than the interest. A payment equal to the interest, , is an interest-only payment: the balance stays the same forever.
$450 000 borrowed at 6% p.a. compounded monthly, repaid at $2697.98 a month over 30 years. After 10 years, more than $376 000 is still owing.
The dashed line shows what the balance would do if the same amount of principal came off every month. The real balance stays above it: in the early years most of each repayment is interest. That is why extra repayments early in a loan save so much interest.
Maree retires with $350 000 in her superannuation. It earns 6% p.a. compounded monthly, and she withdraws a pension of $2500 at the end of each month. Which recurrence relation models the balance of her fund?
Tip
Recurrence relations with payments on a calculator
Type 20000 and press =. Then type Ans × 1.006 − 500 and press = once for each month. Write each balance down as you go if the question asks for a table.
Common mistake
Order of operations
- , not . Interest first, then the payment.
- is for regular deposits into savings (the next topic). Loan repayments and pension withdrawals are .
- Keep full calculator values between steps. If you round each balance to the cent, your answer may differ from the exact one by a cent or two — that's fine, but say you rounded.
Summary
A reducing balance loan or a pension: , amount borrowed or lump sum.
Ordinary annuity: interest is calculated on the balance, then the payment is made.
Interest in a period is ; the rest of the payment, , reduces the balance.
The payment must exceed the interest for the balance to fall; early payments are mostly interest.
Finished the lesson?
Try the 3 quick checks above and the lesson completes itself, or mark it complete now.