Category Archives: Uncategorized

Personal Finance Foundation – Part 1 – Know Where You’re Starting (Calculating Net Worth)

So you’re on the journey to get your financial house in order.  You first need to know where you’re starting.  You do this by measuring your net worth.  Net worth is calculated by adding up your assets and then subtracting your liabilities.  A very, very simple example: You have a savings account balance of $10,000 and have a credit card balance of $2,000.  You’re net worth would be $8,000 ($10,000 in assets minus $2,000 in liabilities).  It’s certainly possible to have a negative net worth (think of the recent college graduate with student loan debt but no assets to their name), too.

As you can see, one way to increase your net worth is to increase the value of your assets.  Another way to increase your net worth is to decrease the value of your liabilities.  Often, though, and especially in the world of personal finance loud mouths, an extreme emphasis is placed on either increasing assets or decreasing liabilities, as if both can’t be accomplished simultaneously.  Both can be accomplished together and you’ll find positive movement in your net worth by focusing on both initially in your journey to a healthier financial state.

Here is a screen clip of an Excel spreadsheet I use to track my net worth:

Net Worth Spreadsheet
Net Worth Spreadsheet

You can download the spreadsheet here.  As you enter assets and liabilities, the spreadsheet automatically adds up both categories and automatically updates the resulting net worth value.  I update my spreadsheet monthly in order to keep tabs on my financial health and, more importantly, to see if something is out of whack and needs to be addressed.  Frequently updating your net worth will provide you with encouragement when you’re taking the right steps and seeing net worth grow, but it will also alert you if you’re slipping into bad habits.  It’s better to catch a bad habit a month or two in rather than realizing years later that the bad habit has caused you major financial damage.

Here are some challenges I’ve encountered while tracking net worth:

Challenge 1:  Accurately valuing certain assets and liabilities.  The value of a given asset or liability may not be black and white.  For example, when including a home’s value in net worth calculations, you should use the going market price for your home and avoid using values that may inaccurately inflate or undershoot the actual value.  This means that your home’s taxable appraised value may or may not be near the home’s market price (i.e., what you’d get if you sold the home).

Challenge 2:  If you have an asset that you’re financing, like a home or a car, make sure to include both the asset and the accompanying loan on your net worth statement.  Again, make sure you’re valuing the asset accurately (hint:  Kelley Blue Book is a great way to value cars).

Challenge 3:  Even though you’re enthusiastic about a collection you have (American Girl dolls, stamps, coins, etc.), they may not be nearly as liquid (i.e., easy to sell) as you think, and they may not be worth nearly as much as you envision.  I don’t include collectibles or jewelry in my net worth statement because I don’t see them as liquid assets.  This is an arguable point, though.  If you choose to include collectibles or hard-to-value items on your net worth statement, try to be accurate with their valuation.

Challenge 4:  You’ll encounter ups and downs in your net worth if a sizeable portion of your asses are in volatile categories, like stocks.  You’ll notice the ups and downs even more if you track your net worth monthly.  This is OK, as stocks (I’m thinking index funds when I say “stocks”) appreciate over long (10+ years) periods of time.  Just make sure that if you’re net worth is declining in value that you’re not contributing to this with reckless spending, overloading credit cards, or buying that Corvette you probably can’t afford right now.

Now that you know your net worth, you have a baseline from which to measure progress or regression.  If your net worth increases, this shows financial progress.  If your net worth decreases, this shows regression, and you should be especially aware of what’s causing the decline.  Your goal should be to increase your net worth over time.

Personal Finance Foundation – Part 2 – Coming Soon!

Why You Should Use Index Funds in Your Retirement Accounts

When I first started learning about investing and retirement accounts, I struggled to determine where I should invest my money.  Thankfully, several great personal finance web sites (including Motley Fool and Bogleheads) agreed that investing in index funds led to the most benefit for most people.  Index funds are mutual funds that track what is called a market index, like the Standard and Poor’s 500, and maintain small slices of companies in proportion to the companies’ share of the index.  For example, if Apple currently makes up 2% of the S&P 500, an S&P 500 index fund would place 2% of its holdings in Apple.

Why is indexing preferred over investing in actively managed funds, where fund managers buy and sell stocks on a frequent basis?  The frequent buying and selling of stocks generates commissions for the fund managers and their companies (this is your money going to pay the fund managers).  Additionally, there are often fees associated with the initial purchase of actively managed funds.  At the end of the day, actively managed funds must increase in value not only to match the gains of index funds, but also to cover actively managed funds’ much higher expenses.

Study after study indicates that index funds outperform actively managed funds:

I recommend Vanguard Funds ( for index funds, as Vanguard’s funds have the lowest expense ratios.  One fund that is highly recommended by many proponents of indexing is Vanguard’s Total Stock Market Index Fund (VTSAX), which has an extremely low expense ratio of 0.05%.  In comparison, many actively managed funds have expense ratios of over 1.00%.  While this extra percentage point may not seem like a lot, when compounded over time, this extra 1.00% may result in you paying fund managers tens of thousands, if not hundreds of thousands, of dollars that could have been used to grow your retirement nest egg.