Mei sets up a superannuation account to save for retirement. She contributes $5000 at the end of each year into the account which earns interest at 6% per annum, compounded annually.
The spreadsheet shown models the first 4 years of the account.
- Calculate the value in cell C9. (1 mark)
--- 2 WORK AREA LINES (style=lined) ---
- From the end of year 4, Mei increases her annual contribution from $5000 to $8000. Calculate the balance in her superannuation account at the end of year 7, and determine how much more this is than if she had continued contributing $5000. (3 marks)
--- 10 WORK AREA LINES (style=lined) ---