Setting Up a Net Worth Tracking Spreadsheet
October 2018
I know a lot of people are probably wondering why my blog has essentially derailed into a personal finance fiesta—how does one go from posts about hydration and feelings to compound interest and index funds in one fell swoop?
Plain and simple, I firmly believe the money decisions young people my age are making right now are literally going to affect the rest of their lives. I cannot overstate the importance of having your financial shit together, and that has come more clearly into focus over the first year of my adult, working life.
After delving into this financial world of books, podcasts, and blogs galore, I’m learning so much information that I feel morally compelled to share with all of you. Maybe you’ve got $100,000 in student loan debt. Maybe you’ve got $100,000 in the bank. I don’t know your situation, and I’m not a guru—I’m not trying to prescribe you a one-size-fits-all solution.
I merely feel strongly (very strongly) that money apathy or ignorance in your early twenties is an alarmingly avoidable way to make your life 20 years from now much harder.
I want all of us to learn (together) about investing, saving, workarounds, hacks, and other money savviness that’ll help ALL of us get rich someday, so we aren’t working for paychecks in our seventies because we didn’t think to contribute to our 401k or open a robo-investing account.
The personal finance community is an interesting one. My latest exploratory obsession can be attributed to my friend Landon, who's gotten me into the "Financial Independence" craze: extremely frugality for about 10-12 years and retirement in your early to mid-30s. Yes, it's possible, and people are actually achieving it.
These are the types of things I want to share with you—from the most basic to the most radical.
Because after all, your money in your savings account(s) is losing at least 2% a year to inflation. I don’t want to scare you (maybe I do a little bit), but in order to build true wealth, you have to start right now. Like, yesterday. Time is money.
If you don’t know how much money you’re taking in vs. spending (i.e., your cash flow), you may be in for a rude awakening.
If you're like, "But KG, I don't even know where to start," fear not! I want everyone to get on the same page with this very easy first step. Devoting an hour to setting up this system and then 15 minutes once a month to maintaining it could mean the difference in hundreds of thousands of dollars (literally) in 40 years from now.
Creating a system
I’m talking, of course, about tracking your net worth. Maybe it’s the control freak in me, but I’m obsessed with full transparency and knowledge of my #assets. I want to know how much I’ve got, where it lives, and how fast it’s growing.
The system that has worked well for me (again, control freak) is a Google Sheet.
We’ll get into the accounts in a moment, but let’s talk for a second about setting up your system.
Pick a consistent day to check all accounts.
Since my budgets reset on the first of the month, I do my full assessment on the first of every month. I pay rent on the first too, though, so the money usually hasn’t cleared out of my account when I take down all the numbers (which is kind of cheating since it makes it look like I have more than I do, but hey, it’s MY system!).
Total the entire column of accounts once you’ve noted down the balances.
Make sure to total all your accounts so you can ensure your net worth is, in fact, going up every month. If your value is going down over time, that means you have a negative cash flow.* In other words, you’re spending more than you’re making, and/or living paycheck to paycheck (maybe without even realizing it). This is, in essence, why this exercise is so important.
*If you have a lot of investments and the market's really down one month, that could also account for a dip.
You could be consistently dipping into your savings without even realizing it if you’re spending on a credit card, or at the very least, you may be spending money you had intended to save.
If you track your accounts/net worth over a few months and notice your net worth is getting lower over time, you need to make some serious adjustments to your spending.
May I suggest this blog post about the joy of when less is enough and how to essentially convince yourself that your life will be better if you don’t reward yourself constantly and mindlessly with restaurant food and shopping sprees (to the point of dulling your pleasure centers). If there’s anything that can make saving sound sexy, it’s this.
And if you haven’t read my post about the beauty of compound interest and how this little exercise may convince you to give up Starbucks and monthly mani/pedis, I highly, highly suggest you read it below. You may just end up with an extra $10,000 because of it.
A few key accounts to track (if you don’t have them yet, no time like the present!)
Basics
Checking account(s)
High-yield checking or savings account(s)
401k and/or IRA
The accounts are no-brainers. If your company doesn’t offer a 401k, open a Roth IRA account instead. (IRA = Individual Retirement Account.)
If your company DOES offer one and offers a match, do whatever you have to do to contribute up to the match. This is legitimately free money. You have no excuse! It’s almost like an automatic raise you’re giving yourself by contributing.
I’m going to toot my own horn here for a second to try to encourage you to contribute to yours—I contribute 10% of every paycheck to my 401k and since it’s been gone from every paycheck since day one, I’ve never missed the money. This balance climbs faster than just about anything. Don’t lose out. Don’t know how? Ask your Benefits department or HR.
When it comes to high yield savings accounts, this is a pretty basic suggestion for where to store your emergency fund (that "$2,000 minimum, ideally 3-6 months expenses" emergency fund). Our Southwest Airlines Credit Union offers a checking account with a 4% interest rate which is actually bananas, so I have mine in there (instead of a traditional "savings" account).
But recently, I heard on a Financial Independence podcast that a Roth IRA is actually the best place to put your emergency fund because it'll grow way more quickly than a lousy savings account, but you can access the principal (your initial investment) without being penalized. You can't touch the interest until retirement, but you wouldn't have that interest anyway had it not been in the IRA.
So, just sock away your $10,000 in savings in a moderately risky IRA, and call it a day. (See? Not painting myself into a corner here—as I learn more from increasingly savvy finance experts, I'll share it with you here.)
Go one step further (c’mon, everyone’s doing it!)
Robo-investment account (like Betterment)
[Use that link during sign-up to get three free managed months! It's a 0.25% monthly fee on your investment otherwise, which is still very reasonable.]
Robinhood account for individual stocks & ETFs
[Use that link during sign-up to get one stock free!]
Assuming you have a fully funded emergency nest egg in the bank (at least $2,000 that you never touch unless you absolutely need it for an emergency) and are contributing to your 401k and/or Roth IRA, you really should look into external investing.
I’m going to plug the two services I use here since I can speak to them more intelligibly. Essentially, though, the extra mile exercise I'm suggesting is setting up investment accounts (and hey, right now’s a GREAT time to buy since the market is in the toilet—buy low, sell high).
Here’s the difference between the robo-investors & apps like Robinhood:
Robinhood is for buying individual stocks, index funds, ETFs, etc. This is so you can pick and buy your own (like the S&P 500 ETF from Vanguard, my favorite) shares.
Robo-investing apps like Betterment (and Ellevest, about which I’ve heard good things) are different in that they automatically invest and diversify your portfolio FOR you, which is great if you don’t want to think about it. I’ve set up an automatic deposit every month of my #SideHustle money from teaching at Corepower.
So, you fill out your information (age, income, etc.) and risk tolerance, and it allocates your investments properly. It can also project where your money will go over time and how it’ll change if you invest more, based on different market outcomes.
My current mix is 90% stocks and 10% bonds since I don’t anticipate needing to access this money for a very long time (so I’m OK with it fluctuating).
