Travel and vehicles

How to track your vehicle's depreciation year by year

Calculate vehicle depreciation yourself: note the purchase price, estimate resale value once a year, and add the drop to running costs for a full cost per km.

Editorial illustration for How to track your vehicle's depreciation year by year

To track depreciation, write down what you paid for the vehicle, then once a year record an estimated sale value. The fall between two readings is that year's depreciation, and it is a real cost of owning even though no money leaves your account. Add it to fuel, service and insurance and you get a cost per km that reflects the whole picture.

What is depreciation, in rupees you can see?

A vehicle is worth less every year, and you only collect that loss when you sell. Tracking it yearly spreads the pain over the years you actually used the vehicle, instead of surprising you at resale. It is an estimate by nature, so treat the figures as a range and the method as the point.

How do I estimate the sale value each year?

  1. Pick the same date every year, for example the purchase anniversary.
  2. Search listings for the same model, similar age, similar kilometres and similar condition. Note three or four asking prices.
  3. If you can, get one dealer or exchange quote as well. Quotes are usually lower than listings, so keep the two apart.
  4. Record a single working figure, such as the middle of your range, and the date and source.
  5. Keep the odometer reading that day, because kilometres affect value.

The sheet layout, with made-up numbers

Suppose a car was bought for ₹9,00,000 on-road. Your yearly estimates are below.

Year endEstimated sale valueDrop in the year
Purchase₹9,00,000Not applicable
Year 1₹7,60,000₹1,40,000
Year 2₹6,70,000₹90,000
Year 3₹5,95,000₹75,000

After three years the total fall is ₹3,05,000 (₹9,00,000 minus ₹5,95,000), which matches ₹1,40,000 plus ₹90,000 plus ₹75,000. The drop is not even: the first year usually costs the most, which is a pattern worth seeing in your own sheet. In year three the monthly equivalent is ₹75,000 divided by 12, or ₹6,250.

How do I add depreciation to running costs?

Gather the year's running costs and the interest part of your loan payments. Say year three had fuel ₹84,000, service ₹18,000, insurance ₹20,000 and parking ₹12,000, which is ₹1,34,000, plus loan interest of ₹55,000 taken from the loan statement. Then add the ₹75,000 depreciation.

  • Running costs: ₹1,34,000
  • Loan interest: ₹55,000
  • Depreciation: ₹75,000
  • Total cost of owning for the year: ₹2,64,000

If the car covered 10,000 km that year, the full cost is ₹2,64,000 divided by 10,000, or ₹26.40 per km.

Does the estimate need to be exact?

No. If your range is ₹5,80,000 to ₹6,10,000, writing ₹5,95,000 is fine, and the yearly drop is still informative. What matters is to use the same method each year so the changes are comparable. For a two-wheeler, the layout is the same.

Where does a tracker fit in?

Spreadsheet or app, the running-cost side comes from your transactions. SpendixAI can import your statements and group fuel, service and insurance under a vehicle category, and then your yearly depreciation sits beside it as a single manual entry. Reports can then give you the running total to divide by the kilometres on your odometer.

One more use for the numbers: if you plan to replace the vehicle, the estimated value at that point is what you carry into the next purchase as a trade-in or sale amount. Seeing it fall year by year, instead of discovering it on the day you sell, helps you plan the gap you will need to fund.

If the vehicle was bought second-hand, the same method works. Start with the price you paid and the date, and take your first yearly estimate a year later. The drop in the first year may look smaller or larger than on a new vehicle, and that difference is useful information about how the model you chose holds its value.

Yearly checklist

  • Odometer reading and date.
  • Three or four listing prices, plus any dealer quote.
  • Your single working figure and the drop since last year.
  • Running costs, loan interest and the new cost per km.
SPENDIXAI JOURNAL

Useful ideas start with a clearer picture of your own spending.

Explore your reports