Activity 01
Spreadsheet Simulation: Super Growth Projections
Provide templates in Google Sheets for students to enter variables like age, salary, and return rates, then generate 40-year projections. Pairs adjust inputs to compare early versus late starts. Conclude with a class share-out of key findings.
Why is superannuation a compulsory part of the Australian economic system?
Facilitation TipDuring the Spreadsheet Simulation, circulate to troubleshoot common Excel errors such as incorrect cell references or formula omissions that skew final projections.
What to look forPresent students with two hypothetical superannuation scenarios: one with early, consistent voluntary contributions and another with later, larger contributions. Ask them to calculate the projected final balance for each using a provided spreadsheet template and write one sentence explaining which strategy yielded a better outcome and why.