How’s Your Financial Life?

January 06, 2017

With today being my first post of 2017, it’s a great time to spend an hour or two over this weekend looking back at the year that was and looking forward to the year that is just starting. I have an annual tradition that I started long ago and will continue for as long as I am lucid. Feel free to use my annual process as a starting point, tweak it, and make it your own.

Each year, I put together a quick “How’s my financial life?” spreadsheet. I only need a few reference sources and in less than 30 minutes, I feel like I have a much clearer understanding of where I stand financially. Along the top of the spreadsheet, I list the year and on the vertical (Column A), I list the things I want to measure annually. Here are the things I measure and where I find the information:

Total Assets – I use this Financial Organizer. The goal is for this to increase each year.  Tracking the dollar and percentage increases are things I’ve added to my simple spreadsheet over time.

Total Debt – This is also found on the Financial Organizer. The goal is for this to decrease annually and eventually get to $0!

Net Worth – This is simply the total assets minus total debt. An increasing net worth is my primary financial goal each year.  This is another thing I track in dollar and percentage terms.

Annual Income – I use my last pay stub of the year. This is a number that should go up each year and if it doesn’t – that could be a warning sign. Or it could mean that you’ve happily retired or downsized your work stress level.

Estimated Mortgage Payoff Date – I pay a bit of extra principal with each payment and at year end, my mortgage company can calculate when the mortgage will be paid in full at my current level of extra principal payments. You can also build this yourself with an “amortization calculator.” (If you Google that term, you’ll find a bunch of them). This is important to me because when my mortgage is paid off, I’ll consider myself financially secure. At that point, my embedded cost of living will be property taxes, insurance, utilities, food and fun.

401(k) Balance and 401(k) Contributions for the Year – For the contributions, I need my last pay stub for the year and for the balance, I can either log on to the website of my 401(k) provider or quickly check Mint for my balance. Each year, I enjoy seeing the balance go up! (I wasn’t so happy with this back in 2008, though.)

Savings Balance – This is one I like to track in order to make sure I have an adequate emergency fund. I enjoy seeing it go up, although it took a big step backward last year because I used a chunk of savings as the down payment on a house. So while I wasn’t ecstatic when I saw that the balance went down, I understand why it did and will work to build it back in short order.  I can check this balance in Mint while I get my 401(k) balance, so locating the info is the easiest part of the job.

Life Insurance Death Benefit – I check this each year to ensure that should this be my last year on the planet, my mortgage can be paid off, my kids’ college can be handled without loans and there could be something left over for them to have a little head start in life, along with a few of my favorite charities getting a few bucks to do the great work that they do. I have to check a file in my desk to make sure that my information is up to date. We had a change in benefits at work and I replaced one policy with another last year so this is a data point that is in flux.

Date of Last Will Update – This is another item that I need to look in my desk drawer files to confirm. Looking at it this year, I’m probably due for an update. The last update of mine was almost 10 years ago, right after my ex-wife and I separated. (It’s amazing how quickly a decade can fly by when you’re having fun!) Hitting the 10 year mark or a significant life change are my triggers for updating this important document, along with my powers of attorney and healthcare directives.

Those are the data points that I can put together in the time that it takes me to watch one college basketball game. (Hey, it’s nice to have a pleasant distraction while working on your financial life.) So pick a game to watch and get busy.