My Life Summarized in SpreadSheets

I’m a bit of a nerd (understatement) when it comes to tracking my finances.  I’ve posted downloadable spreadsheets of my finances in the past, but thought it wouldn’t be a bad idea to have a sort of master spreadsheet embedded for all to see.  Feel free to download them and customize them to your liking.  But don’t laugh at them, they’re not as bad as some others that I’ve seen.

I need to take the time to update a lot of things for this year (hey, I’ve been trying to get out and explore and enjoy life), so a lot of the sheets are not exactly up to date, but at least you get the gist.  Also my plan for 72(t) has sort of changed, rendering 1 sheet useless.

When looking at the spreadsheet, I’m still trying to figure out if my life is cool or sad 🙂 Not quite sure, but doing this stuff certainly helped me get to where I am financially…comfortable.

A few notes: I’m 100% liquid in that I have $0 in long term debt (just short term living stuff like utilities, food, transportation, etc.) and have been that way for a few years.  So, I don’t exactly have any debt paydown tracking worksheet.  Sorry.

So how about a little commentary on each sheet (or tab) starting at the far left (Net Worth):

Net Worth: Should be obvious what this is for, tracking your net worth.  You can see my spreadsheet obsession started in 1999 when I was still in college. Really it should have started when I was 16 and working my first job and maxing out my traditional ira back in the day.  I think it’s a pretty cool sheet, showing how your money grows over time.  I try not to obsess over it too much and update it annually (I do have a running total in my head though).  Some people do daily updates, but they probably need to get a life (looks who’s talking).  Check out my goal for each year.

Dividend Total: I started tracking my dividend income back in 2008 when my brokerage company started allowing dividend reinvestments.  Prior to that, dividends were just received in cash.  I keep saying I’ll go back and pull records to make a bunch of updates prior to 2008, but let’s be real…that’s not happening.  So, I’ll just be happy with that starting point in ’08.  I’m going to destroy that 2036 goal.

If I Die: This is probably the most important sheet.  Regardless of being married or not, there should be a list of assets (and liabilities) your loved ones can get to in order to settle your estate.  This is not a replacement for a will, you should have one of those.  But think of your spouse, for instance.  In most households, one person looks over the finances.  If that person dies, the surviving spouse could be left in the dark not knowing where the money is, or what bills need to get paid.  I’ve also done some major consolidation, personally, just to make my financial life as simple as possible.

Expenses: I need to update this, but I know I’m tracking right on par for the course (if just a little bit under for the year).  I pretty much charge everything and pay off the credit card each month.  My expenses are pretty simple housing stuff, food, car, health, discretionary/fun.  I wish I tracked this category sooner, but it looks like I have not had a mortgage payment since prior to 2012.  Notice the low car expenses in the past.  Also, at the bottom I compare dividend income to expenses.  I succeeded on my goal of eliminating wasteful spending, just need to finalize executing the plan (and spend more $ on fun times).

DRIP Plan: Just tracking my dividend reinvestments for a number of years.  Another way of comparing year over year, and quarter vs quarter.

DIV Worksheet: Just another way I was tracking the dividends and shares being reinvested over time.  It helps me know upcoming income for a given time.  Really need to update this.

72(t): This is completely out of date, as I think my plans have changed for the time being.  So really, it’s just a bunch of numbers for now.

UTMA DRIP: This is a small account I set up for a niece.  The goal is not to make her filthy loaded (she has to figure that out), but if the account can build into something triggering some decent passive income to start her out in life or maybe a down payment for a first home, that would be cool.  Ideally, she’s not touching this money until 25.  I remember what I was like in my early 20’s:


And I mean being that guy raising up the blow up doll


"Lookin' good motha' fucka'"

“Lookin’ good motha’ fucka'”

UNT/UTA/99 Galant: Just some old sheets I never deleted for some reason.  You get to see how much my college degrees cost me back in the day.  I had a small scholarship and was fortunate enough to receive some tuition reimbursements from a job I worked during those years (was so thankful for that).

And just like any great sales pitch… But wait there’s more!!! Here is a nifty spreadsheet for Mortgages (I didn’t create it).  You can input your mortgage details, add a little extra to your payments, it will calculate when your mortgage gets paid off.  ALL AVAILABLE FOR A LIMITED TIME!!! (Sorry for yelling, and it’s not really a limited time.  It’s here for a long as the site exist 😉 ).

So, how do you like it (the spreadsheets that is… or um you know 🙂 )?  TMI, just the right amount, not big enough?  Let me know below.


Follow me on the social medias:

Readers Comments (28)

  1. Your Drip plan, in particular, is fascinating to look at. I’m in awe of your low expenses, and how you are covering that. Grateful that I’m reading you now – even though I wish I began reading you a long time ago.

    • Thanks ZJ, glad you find it interesting.
      I actually have a lot of updates I need to get to on that, but yes my essential (food, house, car) are really low. A nice benefit of being absolutely debt free.
      My qualified dividends cover my essential living. I plan to 72(t) money in my IRA sometime next year to cover my fun spending money.

      It’s also cool to see that income growing over time.

  2. Your blog has a tremendous amount of superb information and the spreadsheets are excellent reference. I really appreciate that you are keeping up to date with your data and this helps all us early retiree wannabees! Great work on your site and I will continue to read regularly. Your details are what other sites should inspire to achieve and unfortunately most on Rockstar Finance don’t. Awesome job BAMF!!!

    • Thanks for the kind words. Yep, my site is more for those interested in spreadsheets as opposed to touchy feely stories.
      I’ll have some more stuff coming soon, been slacking a little bit. Thanks for stopping by. Feel free to follow on FB or twitter for updates

  3. You actually reported it fantastically. buy cheap kamagra next day delivery Idzq83y

  4. tadalafil gel generic tadalafil 40 mg
    tadalafil online

  5. prescription drugs without a doctor: buy medication without an rx

  6. ventolin tablet generic albuterol tablets recall on ventolin inhaler 2018 what does albuterol do for bronchitis

  7. where to buy viagra online non prescription viagra viagra without a doctor prescription

  8. lasix 20 mg: buy furosemide online – lasix 100 mg tablet

  9. Hi there just wanted to give you a quick heads up and let you know a few of the pictures aren’t loading correctly.
    I’m not sure why but I think its a linking issue. I’ve tried it in two different web browsers
    and both show the same results.

  10. I do not even know how I ended up here, but I thought this post was great.

    I don’t know who you are but definitely you are going to a
    famous blogger if you aren’t already 😉 Cheers!

  11. You can definitely see your enthusiasm in the article you write.
    The arena hopes for more passionate writers like you
    who are not afraid to say how they believe. At all times
    go after your heart.

  12. I enjoyed this. Thank you.

  13. – tramadol and gabapentin

  14. prednisolone injections prednisolone 0.5 cream side effects of prednisolone in children how do you say this word prednisolone

Trackbacks & Pingbacks (101)

  1. Simplify Your Finances – BAMF
  2. 5 Spring Cleaning Tips for Your Finances – BAMF
  3. totally free no credit card dating sites
  4. cvs dapoxetine generic dapoxetine cost
  5. what country makes hydroxychloroquine
  6. does hydroxychloroquine work
  7. hydroxychloroquine vs quinine
  8. hydroxychloroquine online india
  9. diarrhea on keto diet
  10. ivermectil dosage and administration
  11. can people take priligy
  12. purchase ivermectin
  13. will plaquenil cure roundworm
  14. stromectol for uti in pregnancy
  15. buy prednisone online australia
  16. ivermecta trihydrate
  17. side effects for ivermectin
  18. ivermectin from mexico
  19. can you buy sildenafil over the counter
  20. ivermectin covid
  21. where can i buy ivermectin
  22. cialis no prescription
  23. viagra men
  24. ivermectin coronavirus
  25. buy ivermectin stromectol
  26. albuterol 900 mcg
  27. flccc ivermectin
  28. mask
  29. kory
  30. india ivermectin
  31. buy stromectol
  32. ivermectin 1%
  33. ivermectin 0.08
  34. ivermectin cream
  35. stromectol cost
  36. ivermectin buy nz
  37. stromectol 3 mg tablet price
  38. ivermectin tablets for humans
  39. ivermectin ontario
  40. is ivermectin safe for humans
  41. is ivermectin safe for humans
  42. cost of ivermectin
  43. where to get ivermectin
  44. ignition casino us
  45. buy stromectol
  46. what is cialis
  47. prednisone 20mg canada
  48. cialis with prescription online
  49. tadalafil generic india
  50. generic provigil pricing
  51. stromectol otc
  52. ivermectin new zealand
  53. viagra connect usa
  54. tadalafil vidal
  55. sildenafil teva
  56. ivermectin 4 tablets price
  57. difference between cialis and levitra
  58. cheap cialis canadian
  59. price of sildenafil tablets
  60. generic price for cialis
  61. tadalafil goodrx
  62. over the counter cialis cvs
  63. ivermectin history
  64. sildenafil tablets for men
  65. how to get cheap sildenafil online
  66. buy cialis online
  67. cialis over the counter singapore
  68. online generic cialis canada
  69. where to buy prednisone online
  70. where to buy prednisone online
  71. monupiravir
  72. cialis rezeptfrei
  73. get cialis
  74. ivermectin 6 tablet
  75. prednisone side effects in women
  76. buy cheap generic viagra
  77. generic for cialis
  78. online gambling casino
  79. cialis super active
  80. ivermectin dengue
  81. ivermectin 1% cream generic
  82. free slots win money instantly
  83. doxycycline buy usa
  84. buy viagra online
  85. online viagra soft
  86. buy viagra online
  87. ivermectin wormer
  88. ivermectina
  89. stromectol msd
  90. stromectol kaufen
  91. ivermectin 12mg tablets for human
  92. ivermectin 3 mg tablets
  93. price of ivermectin
  94. ivermectin tablets uk
  95. tadalafil pills
  96. lucky slots
  97. stromectol tab 3mg
  98. ivermectin 9 mg
  99. stromectol for humans
  100. stromectol covid 19
  101. tadala

Comments are closed.