Slowly Sipping Coffee

Our FIRE calculator – Excel style!

I am an Excel addict. This is a fact, and one I am not ashamed of. Some people get bored and whip out their phone/iPad to play Candy Crush or some WWII tank game (ahem… Mr SSC). I open my Excel spreadsheets. And, probably to no one’s surprise – one of my favorite Excel pastimes is playing with the SSC budgets and doing some rudimentary forward calculations to see if we can reach FIRE even sooner!

Over the past few months, I’ve met a few other Excel-addict which has been fun.  And this month Mrs. Maroon and I decided to join forces to show off some of the fun budgeting calculations we do with Excel. So, please click on over to the Mixing Maroons to check out how she utilizes Excel!

So, today, I am going to discuss one of my latest spreadsheets – my “How much do we need to FIRE?”. Yes, I realize that there are all sorts of super awesome simulators out there that do all this (like firecalc), but I am interested in more than the end result – I like to go in and fiddle with numbers to get a better understanding of all the inputs and assumptions. In a strange way, I find it therapeutic in that it makes me feel not-so-crazy for planning on giving up a huge salary.

One of the reasons for creating my own forward modeling was to be able to include some issues that concern me. Among them are:

  • Adding in the extra cost of teenagers
  • Setting healthcare to inflate more rapidly than the general CPI
  • Estimating the effect of dividends on our withdrawals
  • Playing around with different stock/bond weightings.
  • Effect of part-time jobs and pre-60 tapping of 401k/IRAs

Below shows how I have this all set up. You can see my ‘inputs’ are mostly green boxes.

How we estimate our FIRE goal

How we estimate our FIRE goal

So now to zoom in, so you can actually see what I am doing. Over on the very left side, I have my “total invest” set to $750,000. Right now that is about what I think Mr. SSC and I will need after we pay off the house to last us until we are 60 and living off of our 401ks and IRAs.   Also in the left most box – I have some fund information that I use to calculate my returns and dividends. I just selected 3 funds from Vanguard – an equity, income, and bond fund. I also included their fund fees, just to be a tad more accurate. Right now I have all the returns and such set to be the same each year – but I have it set up so I can put in more accurate historical information… same with inflation. Right now I assume 2%. Why 2%? Well, I’m cheap and we don’t buy a whole bunch. So, essentially I’m hoping that our costs are below inflation. I call it optimism.

Investment Returns, and Inflation

Investment Returns, and Inflation

OK – the next set of columns is where I put in our expected costs. At the top, you can see I have an estimated need of $45,000 a year. This includes taxes, but not healthcare. Below the cell labeled “HC inflate” I have healthcare inflating at 4% a year, and it initially costing us $9000/year. Next column of expenses is teenagers. Here I estimate that teenagers cost an extra $200/month/kid. Maybe its food, maybe school activities or extra clothes. And honestly, I have no idea if $200 is reasonable – it may be too much, or two little. I just recall watching my brother eat 3 chicken breasts at a time… every day. Next, we have a ‘new’ car column, and then its all totaled up for our yearly expenses.

Estimated expenses, and investment allocation

Estimated expenses, and income after FIRE

I know – I know – this is fascinating!

Also in the above figure on the right-hand side are our Investment Allocations – Here I can play with how much cash to keep on hand (1 year), and a stock/equity bond split (this is really cool to play with). So these columns show me how all my cash and investments are allocated. That bright yellow box – that tells me if I turn 60 with any money left!!!

One of my goals with the spreadsheet was to pull in dividend income. So, these dividends below are just based on the three mutual funds that I mentioned before. I also have a column where I can put in additional income – whether from a part-time gig when the kids are older, or from tapping the 401ks a little bit early.

FIRE dividend estimation and income/backdoor Roth

FIRE dividend estimation and income/backdoor Roth

Pretty fun stuff – huh? Now I need to add more colors to make it even jazzier  Then, my next step is to get Mr. SSC to check this out, so that he will REALLY believe me that we can agree on our goal of $750k.  He’s still a little squeamish about this all.  !  Do any others of you out there prefer Excel? Or what software is your favorite?

And if you want to see some more fun with Excel head over to Mixing Maroons!

Oh, and hopefully this works… here is a link to the spreadsheet that I discussed. Remember – I’m a geologist, not some super finance guru – so, let me know if you find any errors!  Budget_calculator

12 thoughts on “Our FIRE calculator – Excel style!

  1. Mrs. Maroon

    Awesome stuff!! Thanks so much for joining in the fun – yes, most definitely the fun – with me! These estimates are so detailed. You’ve got stuff in here that I haven’t even thought about for FIRE. In all honesty, I’ve kinda relied on Mr. Maroon to plan ahead for the future. Now I’d say it’s my turn to dive head first into the details!

    1. Mrs SSC Post author

      Thanks! Mr. SSC’s latest is he wants me to add in big house repairs and appliance updates… there is always something more to think about! Since I wrote this post, I even added in more columns to better estimate our taxes, including what our cost basis would be for the investments as we slowly cash them out. It is so much fun!

  2. Debtless in Texas

    This is awesomely detailed. It is always nice to find other excel nerds (enthusiasts) to see how different folks use excel.

    Is there any way you would be willing to share it with us? Perhaps scrub the numbers and/or have a blank version to mess around with ourselves? That would be excel-ent.

    1. Mrs SSC Post author

      Great idea! This spreadsheet is almost pure hypothetical numbers, so I will clean one up right away, and hopefully get something out tonight!

  3. Tawcan

    I love Excel sheets, just recently posted a Financial Independence / Early Retirement spreadsheet based on J. Money’s original sheet. We use a number of different spreadsheets in our household to help us track everything. Your excel sheet is very detailed, good job.

  4. ARBM

    After reading about Mrs. Maroon’s budget spreadsheet, and now learning about your FIRE calculator, I definitely have my weekend planned out… Excel fun! If I can get a simulation sorted out for us, I can get my fiance to believe in the early retirement dream. 🙂

    Thanks so much for sharing! I’m excited to play with this on the weekend.

    1. Mrs SSC Post author

      Sounds like an awesome weekend! OK – I just added the spreadsheet to bottom of my post, so now people should be able to download it. Its the first time I’ve tried to share an Excel file this way – so let me know if you have issues!

  5. Even Steven

    As you might already know, I love the spreadsheet. I use it once a week, I added some monthly budget items and my first page of FIRE vs my FIRE budget. I set up a hypothetical column and a real investment column for each, which I thought I would love, but i’m struggling to keep everything up to date when the big picture stuff for my real investment column is on personal capital.

Leave a Reply

Your email address will not be published. Required fields are marked *