lnf.cymru stimulus sheet · PSE / Well-being · Year 9

Caerphilly Leisure Centre: Sample Monthly Payslips and Savings Spreadsheet

Keep this sheet beside your worksheet all lesson. Compare the two October payslips in Section 1 and Section 2, check the payroll glossary in Section 3, and use the spreadsheet savings model in Section 4.

1. Payslip 1: Megan Price (Age 18 · Pool Lifeguard · October 2026)

Important payroll check: Megan’s signed October paper timesheet shows she worked 80.0 basic hours at £10.00/hr and 10.0 overtime hours at £15.00/hr. Compare her signed timesheet with what was printed on her October payslip below:

Payments (printed on payslip) Hours Rate (£/hr) Amount (£)
Basic Lifeguard Hours 80.0 £10.00 £800.00
Weekend Overtime Hours (1.5 × rate) 6.5 (check timesheet!) £15.00 £97.50
Printed Gross Pay (before fixing the overtime error) £897.50

Megan’s Deductions Rules (Once Her Gross Pay Is Corrected to Include All 10.0 Overtime Hours)

2. Payslip 2: Rhodri Evans (Age 21 · Cafe Supervisor · October 2026)

Rhodri’s signed October timesheet shows 140.0 basic hours at £12.00/hr and 5.0 overtime hours at £16.00/hr (his hours match his payslip with no error).

Payments Hours Rate Amount Deductions Amount
Basic Supervisor Hours 140.0 £12.00 £1,680.00 Income Tax (PAYE) £142.00
Evening Overtime Hours 5.0 £16.00 £80.00 National Insurance (NI) £57.00
Workplace Pension (5% of Gross Pay) Calculate in Step 1
Gross Pay £1,760.00 Total Deductions & Net Pay Calculate in Step 1

3. Payroll Glossary: Gross Pay, Deductions and Net Pay

Term Meaning
Gross pay Total pay earned before any tax, National Insurance, pension or other deductions are taken off. Formula: Basic Pay + Overtime Pay.
Income Tax (PAYE) Pay As You Earn tax collected by HM Revenue & Customs (HMRC) to fund public services such as schools, roads and hospitals.
National Insurance (NI) Contributions collected on earnings above the threshold to qualify for the State Pension and certain state benefits.
Workplace Pension A percentage of gross pay saved for retirement; your employer also adds money into your pension pot on top.
Net pay (take-home pay) The actual money paid into your bank account after all deductions. Formula: Gross Pay − Total Deductions.

4. Spreadsheet Model: Saving £600.00 for Driving Lessons

Once Megan’s 3.5 missing overtime hours are added and her deductions are taken off, her Corrected Net Pay is £900.00 per month. She wants to save £600.00 for a block of 15 driving lessons before her birthday in 3 months’ time. She models two monthly budgets in a spreadsheet:

Cell row Budget category / item Col B: Plan A (Standard 50/30/20 Rule on £900 Net Pay) Col C: Plan B (Trimmed Wants Model on £900 Net Pay)
Row 2 Corrected Net Pay (£) £900.00 £900.00
Row 3 Needs (50%): bus pass, phone bill, board at home 50% of £900 = £450.00 50% of £900 = £450.00
Row 4 Wants: takeaways, clothes, cinema 30% of £900 = £270.00 Cut Wants by £20/month = £250.00
Row 5 Savings into £600 Driving Fund 20% of £900 = £180.00 / month £900 − (£450 + £250) = £200.00 / month
Row 6 Saved after 3 months (Formula: =B5*3 and =C5*3) £180 × 3 = £540.00 (£60 short) £200 × 3 = £600.00 (Target met!)
Row 7 Months to reach £600 (Formula: =600/B5 and =600/C5) 600 ÷ 180 = 3.33 months (needs 4th month) 600 ÷ 200 = 3.0 months (exact)