Lesson 4: Budgets and spreadsheets
A weekly budget with costs in different periods
SkillPersonal budgets
Worked example
Jordan works full-time in a hardware store and takes home $812.40 a week after tax. His regular costs are:
| Item | Cost |
|---|---|
| Rent | $245 a week |
| Phone plan | $52 a month |
| Car registration (including CTP insurance) | $910 a year |
| Comprehensive car insurance | $1222 a year |
| Groceries | about $115 a week |
| Fuel | about $58 a week |
| Entertainment and eating out | about $95 a week |
| Clothes | about $65 a month |
(a) Convert every cost to a weekly amount. (b) Which items are discretionary, and how much does Jordan spend on them each week? (c) How much can Jordan save each week, and what percentage of his take-home pay is that? (d) Can he save $6000 for a trip in 26 weeks?
Step 1: Convert monthly costs to weekly
Monthly to weekly: multiply by 12, then divide by 52. Phone: . Clothes: .
A month is not 4 weeks. Going through the year (12 months = 52 weeks) keeps the conversion exact.
Step 2: Convert yearly costs to weekly
Registration: . Insurance: .
Step 3: Total the weekly spending
Step 4: Identify the discretionary spending
Entertainment and eating out, and clothes, are choices Jordan could cut: a week. Rent, the phone plan, registration and insurance are fixed. Groceries and fuel are essentials that vary, so he budgets an average for them.
Step 5: Find the savings and the percentage
Savings: a week. As a percentage:
Step 6: Test the savings goal
In 26 weeks: . That is just over $6000, so yes, but with only $16.40 to spare. One expensive week would put him behind, so trimming his discretionary spending a little would make the goal safer.
Answer
(a) Rent $245, phone $12, registration $17.50, insurance $23.50, groceries $115, fuel $58, entertainment $95, clothes $15 (total $581.00 a week). (b) Entertainment and eating out, and clothes: $110 a week. (c) $231.40 a week, about 28.5% of his take-home pay. (d) Yes — $6016.40 in 26 weeks — but only just.
Try a similar one
A fresh question of the same kind, checked as you answer, with hints and a full solution.
Method
Convert every amount to the same period (here, per week).
Total the spending and subtract it from take-home pay.
Use the surplus to test savings goals; look first at discretionary items if the budget is tight.
Watch out for
Dividing a monthly cost by 4 () instead of multiplying by 12 and dividing by 52.
Budgeting with gross pay. Tax comes out before Jordan is paid, so use take-home (net) pay.