This set of resources provides opportunities for students to solve problems involving percentages, rates and proportions using technology (spreadsheets) in the context of superannuation. The concept of compound interest is introduced through iterative calculations using spreadsheets.
Topic 1: Consumer arithmetic
Applications of rates and percentages:
- apply percentage increase or decrease in various contexts; for example, determining the impact of inflation on costs and wages over time, calculating percentage mark-ups and discounts, calculating GST, calculating profit or loss in absolute and percentage terms, and calculating simple and compound interest (ACMGM006)
Use of spreadsheets:
- use a spreadsheet to display examples of the above computations when multiple or repeated computations are required; for example, preparing a wage-sheet displaying the weekly earnings of workers in a fast food store where hours of employment and hourly rates of pay may differ, preparing a budget, or investigating the potential cost of owning and operating a car over a year. (ACMGM009)
- use geometric sequences to model and analyse (numerically, or graphically only) practical problems involving geometric growth and decay; for example, analysing a compound interest loan or investment … (ACMGM074).
Topic 3: Loans and compound interest
- review the principles of simple interest (ACMEM168)
- understand the concept of compound interest as a recurrence relation (ACMEM169)
- se technology to calculate the future value of a compound interest loan or investment and the total interest paid or earned (ACMEM171)
- use technology to investigate the effect of the interest rate and the number of compounding periods on the future value of a loan or investment. (ACMEM173)
Student learning resources
What is superannuation?
Making an Excel spreadsheet
Other resources you might like
Suggested activity sequence
This sequence is intended as a framework to be modified and adapted by teachers to suit the needs of a class group. If you assign this activity to a class, your students will be assigned all student resources on their 'My learning' page. You can also hand-pick the resources students are assigned by selecting individual resources when you add a work item to a class in 'My classes'.
Part A: Defining superannuation
- Organise students in groups of 3 or 4.
- Students read the explainer and in groups construct a brief definition of superannuation. Each group writes their definition on the board.
- When all definitions are displayed, discuss the concept of superannuation and develop a simple class definition.
Part B: Calculating super contributions
- Explicitly teach students how to calculate super guarantee using a gradual release of responsibility model. An example of modelling is provided below.
You’re a third-year apprentice plumber and your weekly wage is \$669.53 per week. How much super should your employer pay into your super account?
Super = 9.5% x salary
= 0.095 x 669.53
- Give students 5 simple calculations and a sixth one which is a bit more challenging – perhaps a ‘working backwards’ question, for example, if your employer pays \$72.30 into your super account, what’s your salary?
Part C: Calculating return on investment for super accounts
- Discuss investment returns earned on super accounts with students and the comparisons with interest. Consider the amounts people will accumulate in super if they just make contributions. Introduce the idea of interest adding to super balance.
- Apply the compound interest formula to some super balances to calculate return earned.
The main formula for calculating the new balance for compounding interest is:
P=original balance (Principal)
r=annual interest rate (%)
n=time in years
- Do a couple of examples on the board, for example.:
Super balance \$52,460, rate 6.5% 2 years.
= 52,460 (1.065)2
= \$59,501 - \$52,460
Part D: Practising
- As a class, talk through the requirements of the worksheet. Making an Excel spreadsheet – Flowchart may be helpful for students.
- Students complete the worksheet.
- Work through solutions with the whole class.
Part E: Investigating super
- Walk the students through the instructions for each task in the investigation.
- Students complete their investigations.
- As a class, discuss students’ findings.