Pupils are told they have just left University and secured their first job, they will be randomly assigned a job and a city to live in as well as a method of transport from the random excel generator (you may need to get on google maps if your geography isn't great!)
There are three tasks, the first is to calculate monthly take home pay after tax, NI and student loan.
In task two they must then take into account rent and living costs and task three incorporate the cost of travel to and from work. Finally there are some questions to think about and extend, you can add your own in here, for example re-calculating after a pay rise or how long until funds run out if they lose their job.
*Some of the jobs on the excel spreadsheet aren't very applicable to the graduate starting salary field but you can discuss and estimate with the students for this. You could even have a chat about how not everyone follows their degree field into their career. Also I made an average salary of £21500 for anyone who was in a job like hairdressing or a fireman etc to save argument.
The aim is to be able to calculate the deductions from pay and instill the idea of financial responsibility whilst having a bit of fun.
There is no sheet to fill in as I wanted my groups to create this themselves and structure their workings out without much scaffolding.
Have fun, any comments or criticisms are welcome.
There are three tasks, the first is to calculate monthly take home pay after tax, NI and student loan.
In task two they must then take into account rent and living costs and task three incorporate the cost of travel to and from work. Finally there are some questions to think about and extend, you can add your own in here, for example re-calculating after a pay rise or how long until funds run out if they lose their job.
*Some of the jobs on the excel spreadsheet aren't very applicable to the graduate starting salary field but you can discuss and estimate with the students for this. You could even have a chat about how not everyone follows their degree field into their career. Also I made an average salary of £21500 for anyone who was in a job like hairdressing or a fireman etc to save argument.
The aim is to be able to calculate the deductions from pay and instill the idea of financial responsibility whilst having a bit of fun.
There is no sheet to fill in as I wanted my groups to create this themselves and structure their workings out without much scaffolding.
Have fun, any comments or criticisms are welcome.
Something went wrong, please try again later.
Brilliant! Using it for our Core maths students. Fits in perfectly with the course and of course their future aspirations.
Report this resourceto let us know if it violates our terms and conditions.
Our customer service team will review your report and will be in touch.
£0.00