Lesson 4: Budgets and spreadsheets

A weekly budget with costs in different periods

SkillPersonal budgets

Worked example

  • Complex familiar
  • Technology active

Jordan works full-time in a hardware store and takes home $812.40 a week after tax. His regular costs are:

ItemCost
Rent$245 a week
Phone plan$52 a month
Car registration (including CTP insurance)$910 a year
Comprehensive car insurance$1222 a year
Groceriesabout $115 a week
Fuelabout $58 a week
Entertainment and eating outabout $95 a week
Clothesabout $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?

1 of 6 steps
  1. Step 1: Convert monthly costs to weekly

    Monthly to weekly: multiply by 12, then divide by 52. Phone: $52×12÷52=$12.00\$52 \times 12 \div 52 = \$12.00. Clothes: $65×12÷52=$15.00\$65 \times 12 \div 52 = \$15.00.

Try a similar one

A fresh question of the same kind, checked as you answer, with hints and a full solution.

Method

  1. Convert every amount to the same period (here, per week).

  2. Total the spending and subtract it from take-home pay.

  3. 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 ($52÷4=$13\$52 \div 4 = \$13) 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.

Save your progress with a free account