The Game of Life

Table of Contents

Fork me on GitHub

1 Growing up

  • One day you'll be an adult.
  • One of the many challenges you'll face is learning to keep on top of your finances.
  • You'll likely have a job with pays you once a month.
  • You'll also have lots of different bills to pay and some unpredictable financial 'bumps in the road' as you go along, like unexpected car repair bills.
  • In this topic, you'll use spreadsheet software to plan a budget, using real-world figures.
  • Can you avoid the overdraft?

Download It

  • Download this file to your H: drive, and save it in a new folder.
  • Open the spreadsheet in Excel.

Learn It

  • We'll start by getting you a job.
  • Open www.indeed.co.uk in a new browser tab.
  • Search for jobs in a 15 mile radius of the School's postcode (PE10 9JE)
  • Find 3 different jobs that you could get which will take someone with no prior experience. Record how much they pay in the provided cells from F4 to H6.
  • Some of the jobs will quote an hourly rate (e.g. £10 per hour). Others will show an annual salary (e.g. £15k per year). Don't worry about this for now; just record the details available.
  • Let's start by looking at a job with an hourly rate; the least this will be in the National Minimum wage, which in 2016 is £6.70 for someone aged 21 to 24. This goes up to £7.20 once you turn 25.
  • Calculating how much tax you'll pay as adult is complicated. Online tools such as this one can give you good indication though. Earning the minimum wage (or close to it) means that you won't pay very much tax at all. This increases as your earnings go up.
  • Our model will assume you pay a third of your pay in tax and pension contributions, although things aren't quite that simple in real life.
  • We'll make a rough-and-ready pay calculator to estimate how much pay you could take home after you've paid your tax and National Insurance.

Try It

  • We'll need to write some formulae to perform our calculations.
  • Locate cell C6 and enter the following: =C3*C4. On spreadsheets, we tell Excel we want to use a formula by starting with an equals sign.
  • What has this done in the cell?
  • If you choose a job with an hourly rate, you'll need to calculate the annual salary. Next, we'll calculate our take-home pay in cell C10.
  • You'll need to use the value in cell C6 and take away the deductions in C7.
  • Next, try and calculate the monthly take-home pay in cell C11. There are (on average) about 4.5 weeks in a month.
  • Finally, calculate the annual take-home salary in C12.
  • Once your formulae are complete, try answering these questions:
    • How much more do you earn in a week if your pay went up to £10 an hour?
    • What if you're on £10 an hour and you decide to only work four days a week (30 hours)?

Learn It

  • Some jobs are advertised by hourly rate, and others by annual salary.
  • Calculating the hourly rate of a salaried post makes it possible to compare two different jobs to see which is better paid.
  • You'll need to know a few things first though.
  • To start with, you'll need to know how many days you actually work in a year (we'll assume 365 days a year).
  • In the UK, full-time (i.e. 37.5 hours a week) workers are entitled to 28 days of paid holiday a year. We'll
  • People tend to work 5 days a week, so we'll need to know how many Saturdays and Sundays there are in a year.
  • We can take the holiday and weekend days from 365 to see how many work days there are in a year.
  • A standard 9am-5pm working day includes a 30 minute (usually unpaid) lunch break. That's 7.5 hours paid work every day.

Try It

  • Use the data above to complete cells C19, C20 and C21.
  • Write formulae in cells C23, C24 and C25 to calculate the hourly rate for a job paying £15,000 per year.
  • Is that more or less than the minimum wage for someone aged 23?
  • If you're stuck on how to complete the formulae for this lesson, the tutorial below will walk you through it:

Badge It

  • Complete the formulae above.
  • Silver: What is the hourly rate for someone on £20,000 a year? Upload a screenshot of your calculations to collect the badge. Use the formulae view.
  • Gold: Find the average UK annual salary, and calculate what this is as an hourly rate. What is the weekly take-home pay for this salary?
  • Platinum: What is the pre-tax (i.e. not take-home) salary of someone earning £30 per hour?