Personal finance template
Car Ownership Cost Calculator Template
Know what your car really costs. Fuel, insurance, service and depreciation add up to a yearly and per-km cost.
Opening a template uses no credits.
What's inside
| Row | A | B |
|---|---|---|
| 1 | Input | Value |
| 2 | Km per year | 15,000 |
| 3 | Litres per 100 km | 6.5 |
| 4 | Fuel price per litre | 19 |
| 5 | Fuel cost | =B2/100*B3*B4 |
| 6 | Insurance | 7,000 |
| 7 | Service | 4,000 |
| 8 | Depreciation | 25,000 |
| 9 | Total per year | =SUM(B5:B8) |
| 10 | Cost per km | =B9/B2 |
Preview with sample numbers. Formulas are shown in green.
The formulas, explained
B5 =B2/100*B3*B4
Distance times fuel use times price.
B10 =B9/B2
Total yearly cost divided by kilometres driven.
Make it yours by asking
Try a request like this in Tabstra:
"Create a car cost calculator with distance per year, fuel use, fuel price, insurance, service, depreciation, total yearly cost and cost per km"