Templates › Home and money
What my car costs template
By Ratio · Every result was worked out by Ratio on
Fuel is worked out from how far you drive and what your car uses. Add the fixed costs and see the total per year, per month and per kilometre.
| You type | Ratio shows |
|---|---|
| # What my car costs | |
| distance = 12000 | 12,000 |
| consumption = 6.5 | 6.5 |
| fuel price = 1.75 | 1.75 |
| Fuel distance / 100 * consumption * fuel price | 1,365 |
| Insurance 540 | 540 |
| Road tax 180 | 180 |
| Service 400 | 400 |
| Tyres 150 | 150 |
| Parking 360 | 360 |
| yearly = sum | 2,995 |
| yearly / 12 | 249.58 |
| yearly / distance | 0.2496 |
Nothing opened? Get Ratio, free for 7 days. The template is copied: paste it into a new sheet. On Windows and Linux, copy the text and paste it into Ratio.
How it works
Consumption is litres per 100 km, so fuel is distance / 100 × litres × price. The three settings sit above a blank line, so sum adds up only the costs.
Make it yours
Put in your yearly distance, your car's consumption and the fuel price. Paying off a loan? Add Loan 12 * 220 to the list.
Questions
Does it include depreciation? Not yet. Add a line like Depreciation 20000 / 8 for a car you plan to keep eight years.
Miles and gallons? Yes. Ratio reads 300 mi at 30 mpg; see the fuel cost calculator.