View Single Post
Old 06-27-2016, 06:11 PM   #60
DaFace DaFace is offline
Kind of a mod
 
DaFace's Avatar
 

Join Date: Aug 2005
Location: Donkey Land
Casino cash: $2146899
Quote:
Originally Posted by Amnorix View Post
I may have posted this before, but I wanted to pass along this tip about one of the better things I have ever done in terms of my overall financial planning and processes.

I track, on a monthly basis, my net worth. I do it the stupidest, old fashioned'est way you can imagine -- by plugging the numbers into a spreadsheet. Now there are apps for that, of course. Early on in life, when you have one or two bank accounts, it's not remotely necessary, but once you're older, and you have a spouse, and you have a 401(k) and the rollover IRA and your wife's rollover IRA and the defined contribution benefit fund and a house with a value offset by a mortgage, blah, blah, blah, it gets a bit more challenging to track it all.

So I have everything in a spreadsheet, and early every month I just update all the figures. For home value I use assessed value (usually a conservative number) and plug in the mortgage balance to offset. All the accounts are updated by month end statement figures, etc.

It has really helped me track everything that we have, and SEE the growth over time, which is very encouraging. Of course, you have to have the stomach to just plug in the numbers and avoid vomiting when years like 2008 come around, but then you can see exactly when you got back to where you were, and be like "hey, for the end of the ****ing world, that didn't take too long to recover from".

Anyway, I've found it useful for managing my financial life. Once you get the hang of it, updating the spreadsheet takes like half an hour a month. Not a big deal at all.
Huh - cool idea. I track all of my normal stuff in Quicken, which gives you a net worth calculation anyway (assuming you put all the big stuff in there). This would take me about 30 seconds a month to just record the value in a spreadsheet for long-term tracking. Thanks!

EDIT:

Or I could just find the Net Worth report in Quicken.

Still, it cuts out if I archive my file, so a spreadsheet will still be better long-term.

Last edited by DaFace; 06-27-2016 at 06:19 PM..
Posts: 51,702
DaFace is obviously part of the inner Circle.DaFace is obviously part of the inner Circle.DaFace is obviously part of the inner Circle.DaFace is obviously part of the inner Circle.DaFace is obviously part of the inner Circle.DaFace is obviously part of the inner Circle.DaFace is obviously part of the inner Circle.DaFace is obviously part of the inner Circle.DaFace is obviously part of the inner Circle.DaFace is obviously part of the inner Circle.DaFace is obviously part of the inner Circle.
    Reply With Quote