Found another mistake in my spreadsheet...

SecondCor521

Give me a museum and I'll fill it. (Picasso) Give me a forum ...
Joined
Jun 11, 2006
Messages
7,931
Location
Boise
Sometimes I think about being a CFP. Days like today encourage me not to.

I just found another mistake in my home-brewed "when can I retire?" spreadsheet.

The good news is that my new "gold" FIRE date is age 50.28, on September 4, 2019. This is two years earlier than before.

The bad news is now I don't trust my spreadsheet and am going to have to go over it to make sure I'm doing everything else correctly.

2Cor521
 
Sometimes I think about being a CFP. Days like today encourage me not to.

I just found another mistake in my home-brewed "when can I retire?" spreadsheet.

The good news is that my new "gold" FIRE date is age 50.28, on September 4, 2019. This is two years earlier than before.

The bad news is now I don't trust my spreadsheet and am going to have to go over it to make sure I'm doing everything else correctly.

2Cor521

I'm only concerned if you used to work at Enron in the accounting area..........;)
 
Well, since it will impact the rest of your life, I would check it closely.
 
Sometimes I think about being a CFP. Days like today encourage me not to.

I just found another mistake in my home-brewed "when can I retire?" spreadsheet.

The good news is that my new "gold" FIRE date is age 50.28, on September 4, 2019. This is two years earlier than before.

The bad news is now I don't trust my spreadsheet and am going to have to go over it to make sure I'm doing everything else correctly.

2Cor521

The fact your spreadsheet "mistake" delayed your ER 2 years simply means you will be a conservative CFP. One who builds in extra safety margins. That is a good thing.:)
 
What, you don't have that .28 figured out to the exact minute:confused: What kind of planner are you :rolleyes:


:D:D:D
 
I say check it again add some fudge factors to get you to FIRE tomorrow....
 
I should have retired 10 years ago but I couldn't sustain 25% average returns for the past 20 years............:(
 
(Trying out this new fancy multireply thingymabob.)

I'm only concerned if you used to work at Enron in the accounting area..........;)

Nope, never worked for them. Although if you have problems with a laser printer from a large, well-known manufacturer of same, I may be at fault.

Well, since it will impact the rest of your life, I would check it closely.

Yup, plan to. The error in this case revolved around my child support payments, which drop off over time as my kids become emancipated. Since this is a significant part of my budget, I have to do several things:

1. Model the drop off in my expenses over time.
2. Figure out the NPV of my future CS expenses at any given month in the future.
3. Model the increased savings I will be able to do (in theory, anyway) as my CS payments drop.

The fact your spreadsheet "mistake" delayed your ER 2 years simply means you will be a conservative CFP. One who builds in extra safety margins. That is a good thing.:)

Yeah, I'm nearly as conservative as Want2Retire, although I plan on spending the same in retirement, not more ;-).

FWIW, the bigger mistakes (don't ask me how I know) get fewer and more obvious the close you get to FIRE.

Oh dear. Sounds like the voice of experience ;-).

What, you don't have that .28 figured out to the exact minute:confused: What kind of planner are you :rolleyes:
:D:D:D

:p -- My spreadsheet tells me I can retire in the month in which my expenses hit 4% of my FIRE assets, so I only have it narrowed down to the month. You'll notice that all my retirement dates I've ever posted here are an integral number of months away from the day I posted them ;-).

I figure (a) within a month is close enough for now for planning purposes; things are very likely going to happen to change that number anyway, and (b) when I get closer I suspect that other factors may come into play -- I may be forced to retire a little early, or I may stay a little later. Too early to tell.

I say check it again add some fudge factors to get you to FIRE tomorrow....

I actually did a little sensitivity analysis and discovered that if I manage to maintain 0% inflation in my current expenses, increase my 401(k) savings rate from 20% to 25%, and retire on a 5% withdrawal rate, that I could retire at 46. I don't think I can at this point reasonably expect to do any better than that...

I should have retired 10 years ago but I couldn't sustain 25% average returns for the past 20 years............:(

Wait, I thought you were a guru?!? :p

2Cor521
 
Wait, I thought you were a guru?!? :p
2Cor521

Notice the screenname finance DUDE, NOt finance GURU...........:)
 
Yup, fudge factors help. Ours is "how much we want to leave to the kids". We keep that number on the high side, and certainly aren't telling them! If things go south, we have their "retirement booster" to count on. Also, checking your calcs against firecalc and the myriad of others out there helps calm the mind. If yours, and most of the others, say "OK" then you're probably not im much danger.

Rambler
 
Ours is "how much we want to leave to the kids". We keep that number on the high side, and certainly aren't telling them!
One's heirs should never learn that the dear ol' folks are worth more dead than alive...
 
I am a big believer in not exceeding the precision of the model. You don't have to be exact ... especially since you don't know when you are going to die (which can dramatically affect the results of any math). You just have to get in the ball park ... with a buffer ... This 'just in case' bucket should give you the ability to sleep at night. Good luck.
 
Back
Top Bottom