Leon opens a superannuation account to build up savings for retirement. At the end of each year he pays in $4000, and the account earns 5% per annum, compounded annually.
The spreadsheet below models the first 4 years of the account.
- Write down the formula used in cell C9, using appropriate grid references. (1 mark)
--- 1 WORK AREA LINES (style=lined) ---
- Determine the value that belongs in cell C9. (1 mark)
--- 1 WORK AREA LINES (style=lined) ---
- Starting from the end of year 4, Leon lifts his yearly payment from $4000 to $7000. Find the balance in the account at the end of year 7, and state how much larger this is than if he had stayed with $4000 payments. (3 marks)
--- 10 WORK AREA LINES (style=lined) ---


