RECORDS / TERMS / THE NEXT APPOINTMENT

Used Car Ownership Cost Calculator: What to Include for Every Car in Your Household

Which costs belong in a used car ownership cost calculator, how to keep one record for every household vehicle, and how to use it to plan upkeep and spending.

14 min readMultiple vehicle household budgets9 viewsUsed Car Ownership Cost Calculator: What to Include for Every Car in Your Household
— · 0 votes
Contents
  1. What is the difference between ownership costs and running costs?
  2. Fixed costs
  3. Variable costs
  4. Which details do you already have to start the calculator?
  5. How do you set up one record for every vehicle in the household?
  6. What should each service note record?
  7. How do you calculate the yearly and per-kilometre cost of a used car?
  8. How to estimate depreciation for a used car
  9. How to include financing
  10. How to average irregular costs
  11. Worked example: two cars in one household
  12. How to calculate fuel costs from your records
  13. How do you build a vehicle running cost calculator in Excel?
  14. Which country-specific costs should you add?
  15. How do you use the record to plan routine upkeep and a maintenance budget?
  16. Practical example of planning ahead
  17. How can the record help decide which vehicle to keep, use or replace?
  18. What are common mistakes in used car cost calculations?

A used car ownership cost calculator should include every cost of owning a car, not only the price you paid. That means depreciation (the value the car loses while you own it), financing interest, insurance, registration fees and road tax, compulsory inspections, maintenance and repairs, tyres, fuel or charging, and smaller items such as parking, tolls and cleaning. Add these up for one year and divide by your annual mileage to get a cost per kilometre or per mile. For a household with two or more vehicles, the calculator works best as one organised record. Each car gets its own costs, service notes and due dates, so you can see which vehicle really costs the most to keep and plan upkeep before it becomes urgent.

What is the difference between ownership costs and running costs?

Ownership costs are everything a car costs you over the period you keep it. Running costs, also called vehicle operating costs, are the subset that rise and fall with how much you drive. This is why you may see tools labelled as a car running cost calculator, a vehicle running cost calculator or a vehicle operating cost calculator. Many of them only count fuel, servicing and tyres. A used car ownership cost calculator adds the costs you pay whether the car moves or not.

Cost typeWhat it includesChanges with distance driven?
DepreciationPurchase price minus expected resale value, spread over the ownership periodPartly: higher mileage usually lowers resale value
FinancingInterest and fees on a car loan or finance agreementNo
InsuranceAnnual or monthly premium, plus any excess you pay on a claimSlightly, if the policy is priced on declared mileage
Registration and road taxRegistration fees, vehicle tax or licence renewal set by your country or stateNo
InspectionsCompulsory roadworthiness or emissions tests, where they applyNo
Fuel or chargingPetrol, diesel, LPG or electricityYes
MaintenanceScheduled servicing, oil, filters, brakes, fluidsYes, because service intervals are set by distance or time
TyresReplacement tyres, puncture repairs, wheel alignmentYes
RepairsUnplanned fixes such as a failed battery or worn clutchPartly
OtherParking, tolls, cleaning, roadside assistance membershipVaries

Fixed costs

Fixed costs are the amounts you pay for a vehicle even if it stays parked all year. They include depreciation, financing, insurance, registration and inspections. In a multi-car household, fixed costs are the reason a second or third car can be expensive even when it is rarely driven.

Variable costs

Variable costs grow with every kilometre or mile you drive. They include fuel costs, servicing, tyres and wear-related repairs. These are the figures a basic car running cost calculator focuses on.

Which details do you already have to start the calculator?

Most of what a used car ownership cost calculator needs is already in the paperwork you keep for each vehicle. Gather these before you start, one pile per car:

  • Purchase receipt or sale agreement: the purchase price and the date you bought the car.
  • Finance agreement, if any: the loan amount, interest rate, monthly payment and term.
  • Insurance schedule or renewal notice: the premium, the renewal date and the excess.
  • Registration or tax documents: the amount and the expiry or renewal date.
  • Inspection certificate: the date passed and the next due date, where a test applies.
  • Service book, invoices or workshop emails: what was done, when, at what odometer reading, and the cost.
  • Fuel receipts or card statements: litres bought, price paid and, if you noted it, the odometer reading.
  • The odometer itself: today's reading gives you a starting point for measuring annual mileage.

You do not need a complete history to begin. Start from today's odometer reading and the bills you can find. The record becomes more accurate with each month you keep it.

How do you set up one record for every vehicle in the household?

The simplest approach is a single record, on paper, in a notebook app or in a spreadsheet. Every cost and service note goes in one place, and each entry is tagged with the vehicle it belongs to. Keeping everything together stops receipts for different cars getting mixed up. It also lets you compare vehicles side by side.

  1. Create a vehicle list. Give each car a short name, such as "Car A – hatchback" or "Car B – van". Note the registration number, purchase date, purchase price and odometer reading at purchase.
  2. Create a cost log. Make one row per expense with these columns: date, vehicle, category, description, odometer reading, amount.
  3. Use the same categories for every car. For example: fuel, insurance, registration, inspection, servicing, tyres, repairs, financing, other. Consistent categories make totals comparable.
  4. Create a due-dates list. For each vehicle, record the next insurance renewal, registration renewal, inspection and service. Note each service by date and by odometer reading, whichever comes first.
  5. Log costs as they happen. Enter each receipt the same day or week. Brief entries made promptly are more useful than a detailed catch-up months later.
  6. Review once a month. Check totals per vehicle, update odometer readings and look at what falls due in the next 60 to 90 days.

What should each service note record?

A useful service note records enough detail that you, another household member or a new workshop can tell what was done and what comes next. Include:

  • Date of the work and odometer reading at the time
  • Workshop or person who did the work
  • Work done and parts replaced, such as oil and filter change, brake pads or battery
  • Total cost, split into parts and labour if the invoice shows it
  • Advice given for later, for example "rear tyres close to limit, replace within six months"
  • Next service due, by date and by odometer reading

The "advice given" line matters most for planning. Workshops often flag items that are not yet urgent. Writing them down turns a vague warning into a dated, costed item in your maintenance budget.

How do you calculate the yearly and per-kilometre cost of a used car?

The yearly ownership cost of a used car is the sum of its yearly depreciation, financing interest, insurance, registration, inspection, maintenance, tyres, repairs, fuel and other costs. The cost per kilometre (or per mile) is that yearly total divided by the distance driven in the same year.

Yearly cost = depreciation per year + financing interest per year + insurance + registration and tax + inspections + maintenance + tyres + repairs + fuel + other

Cost per km = yearly cost ÷ kilometres driven in that year

How to estimate depreciation for a used car

Depreciation is the drop in a car's value between the day you buy it and the day you sell it. To estimate it, decide how long you expect to keep the car (the ownership period) and what it might sell for at the end. Then use this formula:

Depreciation per year = (purchase price − expected resale value) ÷ ownership period in years

To estimate resale value, look at current asking prices for the same model with the age and mileage your car will have when you sell. Treat the figure as an estimate and revise it once a year.

How to include financing

If you bought the car with a loan or finance agreement, include only the interest and fees in the yearly cost. Do not include the full monthly repayment. The part of each payment that repays the loan amount is already covered by the purchase price and depreciation. Counting it again would double-count it. Your lender's statement normally shows how much of each payment is interest.

How to average irregular costs

Some costs arrive every few years, such as a set of tyres or a timing belt replacement. Spread them over the years they last. For example, tyres costing 600 that you expect to last three years add 200 per year to the calculator.

Worked example: two cars in one household

The figures below are illustrative, in generic currency units, to show how the calculation works. Use your own receipts and local prices.

Item (per year)Car A: newer hatchback, daily commuterCar B: older estate, weekend use
Purchase price9,0004,000
Expected resale value / ownership period4,000 after 4 years1,500 after 3 years
Depreciation1,250833
Insurance700500
Registration and tax300300
Servicing and repairs600800
Tyres (averaged)200150
Fuel1,512 (12,000 km at 7 L/100 km, 1.80 per litre)810 (5,000 km at 9 L/100 km, 1.80 per litre)
Yearly total4,5623,393
Cost per km0.380.68

Car B is cheaper to own in total but costs almost twice as much per kilometre. Its fixed costs are spread over far fewer kilometres, and its older parts need more repairs. This kind of comparison is the main benefit of tracking several vehicles in one record. It helps a household decide which car to use for longer trips, and whether keeping a lightly used second car is worth its fixed costs.

How to calculate fuel costs from your records

Fuel cost per year equals the distance driven multiplied by fuel consumption, multiplied by the price per litre. To find your real consumption, fill the tank and note the odometer reading. At the next full fill-up, divide the litres added by the kilometres driven and multiply by 100. The result is litres per 100 km (L/100 km). In the United Kingdom, consumption is usually quoted in miles per gallon (mpg) while fuel is sold by the litre. Use one unit consistently within your record.

How do you build a vehicle running cost calculator in Excel?

A vehicle running cost calculator in Excel, or any spreadsheet program, needs three sheets: a vehicle list, a cost log and a summary. The summary totals each vehicle's costs automatically from the log.

  1. Vehicles sheet: columns for vehicle name, registration, purchase date, purchase price, expected resale value, ownership period in years, and odometer at purchase. Add a calculated column for depreciation per year: (purchase price − resale value) ÷ years.
  2. Log sheet: columns for date, vehicle, category, description, odometer and amount. Use a drop-down list (data validation) for vehicle and category so the spelling always matches.
  3. Summary sheet: list each vehicle in a row and each category in a column. A SUMIFS formula adds up the log by vehicle and category. For example, =SUMIFS(Log!F:F, Log!B:B, $A2, Log!C:C, B$1) totals column F of the log where the vehicle matches cell A2 and the category matches cell B1.
  4. Distance driven: subtract the earliest odometer reading of the year from the latest, using MAXIFS and MINIFS on the log's odometer column for each vehicle.
  5. Per-km cost: add depreciation to the category totals, then divide by the distance driven.
  6. Due dates: keep a separate table of upcoming renewals and services. Sort it by date so the next item is always at the top.

The same layout works in free spreadsheet tools. What matters is the structure: one log, consistent categories and a vehicle column on every row.

Which country-specific costs should you add?

The cost categories are the same everywhere, but each country has its own compulsory charges, inspections and names for them. When you use a car running cost calculator for the UK, Ireland, India, Australia, New Zealand or South Africa, check that it includes the local items below. Then enter your own amounts and dates from your official notices, because rates change and often depend on the vehicle.

CountryLocal items to include in the record
United KingdomVehicle Excise Duty (road tax), the annual MOT test once a car reaches the required age, insurance, and any local clean-air zone or congestion charges you pay. Record distances in miles if that is how you think about your driving.
IrelandMotor tax, the NCT (National Car Test) for older cars, insurance, and tolls on the routes you use.
IndiaRoad tax, usually paid at registration, so it belongs in the purchase cost of a used car if it was transferred with the vehicle. Also record insurance renewals including the mandatory third-party cover, PUC (Pollution Under Control) certificate renewals, and FASTag toll top-ups.
AustraliaRegistration ("rego"), compulsory third party (CTP) insurance, which is bundled with registration in some states and bought separately in others, any comprehensive insurance, roadside assistance membership, and tolls.
New ZealandVehicle licensing ("rego"), the Warrant of Fitness (WoF) inspection, insurance, and Road User Charges for vehicles that pay them, such as diesels.
South AfricaAnnual vehicle licence disc renewal, the roadworthy certificate required when ownership changes, insurance, vehicle tracking subscription if your insurer requires one, and tolls.

For a household with several cars, renewal dates are easy to lose track of. Put every registration, tax, inspection and insurance date for every vehicle into the same due-dates list.

How do you use the record to plan routine upkeep and a maintenance budget?

A maintenance budget is the amount you set aside each month so that servicing, tyres and repairs are paid from savings rather than from that month's income. Your cost record tells you how much to set aside for each vehicle.

  1. Find last year's maintenance spending per car. Add servicing, tyres and repairs for each vehicle from your log.
  2. Add known upcoming items. Include the next scheduled service and anything the workshop flagged in your service notes, such as brake pads or tyres. Ask for or estimate a cost for each.
  3. Allow for age. Older, higher-mileage cars are more likely to need unplanned repairs, so budget more for them than last year's figure suggests.
  4. Divide the yearly figure by 12. This is the monthly amount to set aside for that car. Keeping it as a separate savings balance per vehicle shows clearly which car is using up its share.
  5. Do the same for fixed renewals. Divide each annual insurance, registration and inspection cost by 12 and save monthly. A renewal for one car then never lands on top of a repair bill for another without warning.
  6. Check the due-dates list every month. Book services ahead when the date or odometer limit is close. In a multi-car household, try to spread services and renewals across different months.

Practical example of planning ahead

Suppose your service note for Car B from March says "timing belt due at 160,000 km". Car B now reads 152,000 km and covers about 5,000 km a year. You can expect the job in roughly a year and a half. Add an estimated cost to Car B's maintenance budget now, and divide it over the months remaining. When the job comes due, the money is already there. You can also judge whether the repair makes sense given the car's expected resale value.

How can the record help decide which vehicle to keep, use or replace?

Comparing yearly totals and cost per km across vehicles shows where household money actually goes. Look for these patterns:

  • High cost per km from low use: a car that rarely moves but carries full insurance and registration may be cheaper to replace with occasional rentals or shared use. This depends on how often you genuinely need it.
  • Rising repair costs: if one car's repairs grow each year and approach its resale value, the record gives you a clear basis for deciding when to sell.
  • Trip allocation: using the car with the lower per-km running cost for longer trips can reduce fuel and wear spending across the household.
  • Insurance and renewal timing: having all renewal dates side by side makes it easier to compare quotes in time rather than accepting automatic renewals.

What are common mistakes in used car cost calculations?

  • Leaving out depreciation: it is often one of the largest costs, even though no bill arrives for it.
  • Counting loan repayments as a running cost: include only interest and fees, or you count the purchase price twice.
  • Mixing vehicles in one total: without a vehicle column, you cannot see which car is costing more.
  • Ignoring irregular costs: tyres, batteries and major services should be averaged across the years they last.
  • Using a manufacturer's fuel figure instead of your own: real consumption from your fill-ups is more accurate for your driving.
  • Not recording odometer readings: without them you cannot calculate annual mileage, cost per km or service timing.

A used car ownership cost calculator is only as useful as the record behind it. Start with the receipts, documents and odometer readings you already have. Log each cost and service as it happens, and review the totals and due dates once a month. You will then know what each car in your household really costs and what upkeep is coming next.