Lesson 4: Budgets and spreadsheets

Can Mia afford to run a car?

SkillsPersonal budgetsSpreadsheet calculationsRates and percentages

Worked example

  • Complex unfamiliar
  • Technology active

Mia is deciding whether she can afford to run a small used car. She sets up this spreadsheet.

ABCD
1ItemCost per year ($)InputValue
2Registration (incl. CTP)910Distance (km per year)11 500
3Comprehensive insurance1080Fuel use (L/100 km)6.8
4Servicing420Petrol price ($/L)1.95
5Tyres (averaged)240
6Roadside assistance105
7Fuel
8Total

(a) Write a formula for cell B7 and calculate the yearly fuel cost. (b) Write a formula for cell B8 and calculate the total yearly cost. (c) Mia earns $420 a week from her part-time job. Calculate the weekly cost of the car and evaluate whether she can afford it.

1 of 6 steps
  1. Step 1: Write the fuel formula

    Fuel used is distance ÷100×\div 100 \times fuel rate, and cost is litres ×\times price, so B7 is =D2/100*D3*D4.

Try a similar one

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

Method

  1. Use rates to turn usage into cost (distance → litres → dollars).

  2. Let the spreadsheet add the parts with a SUM formula.

  3. Convert the total to the same period as the income.

  4. Judge affordability by what is left for everything else, and state your assumptions.

Watch out for

  • Multiplying the distance by 6.8 without dividing by 100, which gives a fuel bill of $152 490.

  • Typing numbers into formulas (such as =11500/100*6.8*1.95). It works once, but the sheet will not update when an input changes.

Save your progress with a free account