Reader AnatoliN asked me to share the spreadsheet I used to work out the fixed and variable costs on my car. So, I cleaned it up, and with great fanfare, here is the car costs spreadsheet.
Remember that garbage in leads to garbage out. Unless you have an accurate list of your car expenses, this spreadsheet cannot magically give accurate answers. In my experience, most people know they paid too much for their cars and have a hard time admitting the real costs to others and to themselves.
If you want to protect your ego from the brutal truth of how ridiculously expensive cars are, I suggest using the advertised price of $23,999 that got you into the dealership showroom rather than the actual $33,000 you paid after various add-ons and taxes. You can also just estimate your gas costs instead of looking up your credit card bill to see that you actually pay much more. Leaving out the cost of new tires or brakes might help as well.
OK, enough sarcasm. You get the point. If you don’t include all costs, then the final answer will be wrong. For those who try it out, please let me know if you find the spreadsheet useful.