Personal Finance 
58
comments

How to Measure and Track Your Net Worth

Email  Print Print  

Net Worth Spreadsheet ExampleWhen 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 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:

  • For our assets, we categories them as liquid (cash, CDs, savings, checking), investment (taxable brokerage), Federal (bonds), and retirement (IRAs, 401(k)s). We feel that separating them by how easy and painless (tax and feewise) it is to access the funds is valuable.
  • We don’t track our credit card debt because we pay it off each month. We only have two other liabilities, student loan debt and a mortgage, and they get their own categories.
  • We do not include our car’s value because it doesn’t add anything to our understanding of net worth. We paid off both before we started tracking our net worth. If we had loans, we’d keep the Kelly Blue Book private sale value on after the loans are paid off just to keep continuity.
  • We include our home’s appraisal value to help offset the mortgage. Much like a car loan needing a car to give it some perspective, we keep the appraisal value.

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!

{ 58 comments, please add your thoughts now! }

Related Posts


RSS Subscribe Like this article? Get all the latest articles sent to your email for free every day. Enter your email address and click "Subscribe." Your email will only be used for this daily subscription and you can unsubscribe anytime.

58 Responses to “How to Measure and Track Your Net Worth”

  1. daenyll says:

    I don’t keep track of my net worth, it’s in the negatives, I own no real assets and just finished grad school so have massive amounts of loans, but I update my spreadsheets of loans, budget, savings and retirement accounts monthly or more often.

  2. Thanks Jim. I really think the only thing that matters for net worth calculation is cash, and the most liquid of securities with a haircut. Nothing else matters.

    It’s all an illusion!

    • NateUVM says:

      Well, it really comes down to context. In your example, the qualifying factor is liquidity over time.

      Clearly, in your case, FS, your time-frame is a case of minute-by-minute. You need to know what you can use at that moment.

      For others, however, when looking at their overall net worth, they want to consider the OVERALL view of their assets, regardless of how liquid they may be. Because, over time, you CAN sell a house, and that CAN have value.

      Not saying yours is the wrong approach. Not in the least. Just that I don’t think you can really say that “nothing else matters,” besides cash and the most liquid of assets. Again, it merely depends on what context the figures are being used within.

  3. Yes, it is an extreme to say nothing else matters, but when you treat the home equity, 401k, stock investments, private equity as NOTHING, you will enjoy something when it’s time to cash in.

    It’s important not to live like your illiquid investments are dependable.

  4. Adam says:

    I agree that doing it consistancy beats how you do it.

    I tried a written budget for a while and it worked to an extent but it was only after I starting tracking the real number of the sum of my assets and saw it move up and down each month that I could see the real results.

    At first I thought I didn’t need to do it as I was following my budget, but its surprising how much knowing you are accountable for that number each month, can affect your financial behaviour.

  5. Rodney says:

    I been recording my net worth for some 30 years now , and it feels good to see how I are doing from one year to the next . When you have as many assets as me , you need to have one peace of paper, to see how I am doing . I have been a mulit millionare for some 20 years now , so it help to see what i have and were it is . I forget what i have at times so this help me .


Please Leave a Reply
Bargaineering Comment Policy


Previous Article: «
Next Article: »
Advertising Disclosure: Bargaineering may be compensated in exchange for featured placement of certain sponsored products and services, or your clicking on links posted on this website.
About | Contact Me | Privacy Policy/Your California Privacy Rights | Terms of Use | Press
Copyright © 2014 by www.Bargaineering.com. All rights reserved.