- Bargaineering - http://www.bargaineering.com/articles -

How to Measure and Track Your Net Worth

When you were in school, chances are you knew what you needed on each test to get an A, a B, or a C (or avoid an F!). At work, you have project deadlines to meet and performance criteria to fulfill. When it comes to your finances, there isn’t a convenient, single number you can use to track your progress. In school, there was your GPA. In personal finance, you can’t just look at your account balances because it doesn’t give you the whole picture. That’s where measuring and tracking your net worth can come in handy.

Every month I record a snapshot of our family’s net worth in a simple excel spreadsheet. By definition, net worth is your total assets minus your total liabilities. Examples of assets are cash, investments, and real estate. Examples of liabilities are debts like credit card, car loan, student loan, and mortgages. Nothing fancy there, just some simple math.

The value in doing this each month is that it gives us a “state of the family finances” you really can’t get in looking at any other number. You might have savings goals, like X dollars for a home downpayment, or budgeting goals, don’t spend more than $250 on restaurants this month, but nothing that gives you guidance across all of your goals quite like your net worth.

Consistency Trumps Methodology

I recommend ignoring what you read about what to count and what to ignore for your net worth equation. Come up with an equation that works for you and your family. We don’t include cars in our net worth, maybe you want to include your car(s). We keep our home value static (it’s the appraisal value) each month whereas you might want to adjust it based on comparable sales or some other metric. In the end, you want to keep your figures consistent from month to month because it’s the difference that matters, not the final number (so much).

In addition to giving you a progress report each time you update it (we do it once a month), it also gives you the opportunity to have a financial check-in [3] with your family. When you discuss the finances, take whatever notes you have and enter them into the place you track your finances.

Big increase because of a bonus? Put a note.
Big drop because you had to pay taxes? Put a note.
No change but you sold some stock for gains? Put a note.

In a few months to a year (or more), when you go back to review your progress, these notes will be important to add some commentary to otherwise boring numbers.

How We Track Net Worth

It’s pretty simple, we add up all of our assets and subtract our liabilities. Thanks and have a great day! 🙂

Just kidding, not quite done yet. While those are the basics, we do a few different things and play a few statistics games when it comes to coding each of our accounts. Here are some the things we do:

In terms of statistics, we sum up all the categories (liabilities, liquid, investment, Federal, and retirement) into individual columns and then sum them into a total value (subtracting liabilities). This gives us a month to month snapshot of our total net worth as well as the changes in our various categories each month. We include notes in each cell whenever there’s something notable. For example, we recently rolled over my wife’s old 401(k) to Vanguard and noted this in the various columns. In a year or so, when we go back to look at 2009, we’ll know why our Vanguard account suddenly surged mid-year for no reason.

What are some tips and tricks you’ve used in tracking your net worth? Techniques you’ve used to achieve your goals sooner or just give you the opportunity to track them better? I’d love to hear about the things you’ve done so we can improve our process!