Context
Task 1
Task 2
Task 3
Task 4
Task 5
Task 6
Task 7
Task 8
Task 9
|
Resource
Sheet 12
Peterson income and
expenditure
These are the figures for the
Peterson’s income and expenditure for one month.
You can use this outline as a
guide for building your own spreadsheet or you may choose your own design to suit
yourself.
Remember:
You will need total income figures, total expenditure figures, and a balance figure.
| Income |
£s |
| Jay Peterson |
2,100 after stoppages |
| Helen Peterson |
1,100 after stoppages |
| Phillip Peterson |
20 contribution |
| |
|
| Expenditure |
|
| Gas |
50 |
| Electricity |
45 |
| Telephone |
50 |
| Council Tax (10 months only) |
140 |
| Water Rates |
60 |
| Mortgage |
620 |
| Insurance (Life) |
100 |
| Insurance (Home) |
30 |
| Insurance (Car 1) |
50 |
| Insurance (Car 2) |
35 |
| Car Loan 1 |
250 |
| Car Loan 2 |
180 |
| Other loans/HP |
200 |
| Food/petrol/extras |
800 |
| Clothing |
100 |
| Entertainment |
250 |
| Gemma's allowance |
80 |
| Driving lessons (Gemma) |
60 |
Timed Practical Task 
Home
|