Financial Profiling & Optimization

Sometimes I wonder if I am spending too much money and should be saving more. It's tempting to try to micro-manage things by clipping coupons or skipping out on meals out with friends, but this strikes me as being similar to premature optimization of code, which as Knuth would say is the "root of all evil."

Just as it's not worth optimizing the 90% of the code where your program spends less than 1% of its time, it might not be worth packing your lunch every day to save a dollar a day ($250 per year) if your real problem is that you unnecessarily spend thousands of dollars on new laptops or other expensive equipment each year.

So what's the first step before I can figure out what to optimize? Profiling, naturally. About a year ago I grabbed a copy of MS Money, which is a personal finance tracking program. It can go online and download your bank account information and credit card statements. It tracks each transaction you make and uses heuristics to assign them to various expense categories. For example if Safeway is the merchant, it'll assign it to Groceries, if it's Comcast, then Utilities, and so on. Sometimes it doesn't know what a specific merchant should be assigned to so you have to configure it.

Once that's all set up, it can generate all kinds of plots showing your cash flow over time, estimated monthly budgets based on trended spending, and various other reports. Here's a pie chart of my spending over the last year:

Without this tool I would probably have had a hard time even estimating the percentage of my spending which goes into various categories, so it was quite interesting to see it charted like this.

The biggest item that jumps out of the chart is obviously "Mortgage/Rent", which in my case is just Rent. It accounts for nearly half of my spending, if you include Utilities (electricity, water, internet) along with it. I'm not sure whether this is a good or bad observation: on one hand I am spending a ridiculous amount of money on rent each month, but on the other hand it's nice to know that I'm not spending a similarly ridiculous amount of money on anything else.

"Education" is the next biggest category, which includes grad school tuition, fees, textbooks, etc.. I'm OK with spending a good chunk of money on this category since self-improvement and continual learning is a good thing. It's also nice that these expenses are completely reimbursed by Microsoft, so the chart of my "real" expenses should probably not even include this category (in which case Mortgage/Rent would fill more than half the pie).

Next biggest is "Hobbies/Leisure", which contains a large range of transactions, the largest of which are from "AMAZON.COM", "GAMESTOP/EBGAMES", "APPLE ONLINE" and "REI STORES."  Overall I'm not too concerned about the current size of this pie slice since Hobbies/Leisure is basically the category for "what you do with your spare time," which, in the end, is the whole point of working and making money. I was a bit surprised at the total cost of my Amazon purchases over the last year - I could probably be a lot better about borrowing "read once" books from the library rather than buying them outright (Amazon Prime makes it too easy..).

"Automotive" is up next, which seems to be about equally split between car insurance and gas. I think I already have my car insurance pretty well optimized, so about the only way to reduce spending here is to drive less.

I'm lumping Utilities in with Mortgage/Rent, so "Groceries" is next. The final number in this category was another minor surprise and is probably a good area for optimization. Whole Foods organic milk and cereal apparently add up pretty quickly.

The rest of the spending categories don't sum up to much, so some of them are actually surprising for being so small. I'm disappointed that "Travel/Vacation" is almost not even visible on the chart. I hope that next year's chart will show Travel/Vacation making some big gains. "Gifts" is one category which is too small to show up, which would be totally pathetic of me if it weren't for the fact that most of my gift purchases were probably from Amazon and thus got stuffed into the Hobbies/Leisure slice.

One thing which is notably missing from this chart is money allocated to savings accounts & stock investments (I guess they aren't "Spending" since I still have the money). I had to generate a separate report for savings & stock investments and was pleased to find that the total number there was about equal to the total number in the Spending chart, which means that I have a savings rate of 50%, which is a lot better than the U.S. average, which is hovering around 0% even with the recent "stimulus" package.

Overall this was an interesting exercise to do. Now that I know the actual numbers I don't feel all that guilty about spending too much (except for in a couple of areas). In fact, I'm now feeling like I can probably afford to spend more, especially in "Travel/Vacation".