Input on my Total Cost and Cost Per Mile Spreadsheet

[Lean L]

I made this spreadsheet to keep track of exactly how much money was going into my car. It seems like I was pouring money into it for preventative maintenance so I wanted to be able to better track it.

It's still missing various maintenance aspects that I will input as I figure out the cost. The point was to make a spreadsheet with minimal user interaction that can calculate how much I spent on the car. So far the cost is $0.69 per mile not including higher interval maintenance items. Let me know if I am missing anything or if it seems off. The spreadsheet also requires that all prices are averaged throughout the life of the vehicle which is very hard to do. It should still give me a ballpark figure though that should not be off by more than a few hundred dollars after years of tracking.

Thanks.

https://docs.google.com/spreadsheet/ccc?key=0ApMXXtkiI46fdDg5elVJUnNxcGxDZGJOVEZrRzFzSHc&usp=sharing

 

[Lean L]

Wow, updated the spreadsheet with depreciation $27xx sunks costs after owning the car for just over two months... Although I did consider registration and taxes as part of sunk cost. There are also earholds in there for future maintenance.

 

[MixMasterTang]

I looked at it on my phone, but now I'm even more confused. I don't see any mileage listed nor gas nor insurance. What is the formula you are using to calculate cost per mile? Also are there not yearly registration / personal property taxes.

 

[MixMasterTang]

Also where are the maintenance items? Tires, oil, filters, etc?

 

[Lean L]

All of that stuff is on sheet 2.