Join Early Retirement Today
Reply
 
Thread Tools Display Modes
Help Calculate Magic Number for Young Family
Old 03-08-2013, 02:15 PM   #1
Recycles dryer sheets
 
Join Date: Jan 2013
Posts: 79
Help Calculate Magic Number for Young Family

Assume a young family with expenses of 100k for the first 25 years, and then expenses of 50k for the next 25 years after that (empty nest period).

How would you calculate a retirement number for this whole 50year period?

Of course 3.3+mill, should be sufficient with a 3%swr if one wanted to be very conservative as the family would have 50k annual surplus during the empty nest period.

I know the magic number should be less...... but how much less? How low a number can the family "shoot for" and still be 99% confident?

Anyone care to take a stab. Thanks in advance.
Apex1 is offline   Reply With Quote
Join the #1 Early Retirement and Financial Independence Forum Today - It's Totally Free!

Are you planning to be financially independent as early as possible so you can live life on your own terms? Discuss successful investing strategies, asset allocation models, tax strategies and other related topics in our online forum community. Our members range from young folks just starting their journey to financial independence, military retirees and even multimillionaires. No matter where you fit in you'll find that Early-Retirement.org is a great community to join. Best of all it's totally FREE!

You are currently viewing our boards as a guest so you have limited access to our community. Please take the time to register and you will gain a lot of great new features including; the ability to participate in discussions, network with our members, see fewer ads, upload photographs, create a retirement blog, send private messages and so much, much more!

Old 03-08-2013, 02:23 PM   #2
Give me a museum and I'll fill it. (Picasso) Give me a forum ...
REWahoo's Avatar
 
Join Date: Jun 2002
Location: Texas: No Country for Old Men
Posts: 50,004
Have you tried running those numbers through FIRECalc? Input $100K annual spending and on the Other Income/Spending tab, input a pension of $50k starting 25 years after you retire, leaving the inflation adj box checked. This should have the effect of reducing your spending from your portfolio to $50K at that point.

Oh, and on the Investigate tab, select the Starting Portfolio Value button under the "Given a success rate, determine spending level for a set portfolio, or portfolio for a set spending level" option.
__________________
Numbers is hard
REWahoo is offline   Reply With Quote
Old 03-08-2013, 03:04 PM   #3
Recycles dryer sheets
 
Join Date: Jan 2013
Posts: 79
REwahoo: thank you so much for helping me! My head was beginning to hurt trying to figure it out on my own. Took me awhile to figure how to input the data into Firecalc and also never realized how powerful Firecalc is. Besides, i would have never figured out that adding 50k pension would have the same effect as 50k reduction in spending.

So, to answer my own question..... Firecalc spit out 2.6m (100k spending to start, 50k pension, 99%confidence)....... pretty neat stuff
Apex1 is offline   Reply With Quote
Old 03-08-2013, 03:08 PM   #4
Give me a museum and I'll fill it. (Picasso) Give me a forum ...
REWahoo's Avatar
 
Join Date: Jun 2002
Location: Texas: No Country for Old Men
Posts: 50,004
FIRECalc isn't perfect by a long shot, but it can do some really neat stuff if you play around with it for a while.

BTW, I haven't attempted to run your numbers through the calculator but your $2.6M number sound reasonable to me.
__________________
Numbers is hard
REWahoo is offline   Reply With Quote
Old 03-08-2013, 08:26 PM   #5
Thinks s/he gets paid by the post
 
Join Date: Jul 2005
Posts: 4,366
Careful running 50 year periods with FIRECalc. That won't give you many tested periods.
Animorph is offline   Reply With Quote
Old 03-08-2013, 08:40 PM   #6
Give me a museum and I'll fill it. (Picasso) Give me a forum ...
REWahoo's Avatar
 
Join Date: Jun 2002
Location: Texas: No Country for Old Men
Posts: 50,004
Apex, to better understand the caution note from Animorph take a look at FIRECalc: How it Works, especially the section titled "How about describing FIRECalc step by step?". Bottom line, the longer the retirement period the fewer the retirement cycle 'test runs' by FIRECalc.
__________________
Numbers is hard
REWahoo is offline   Reply With Quote
Old 03-08-2013, 10:38 PM   #7
Recycles dryer sheets
 
Join Date: Jan 2013
Posts: 79
Quote:
Originally Posted by Animorph View Post
Careful running 50 year periods with FIRECalc. That won't give you many tested periods.
Thanks Animorph,

Right and i did re-read the explanation of how FIRECalc works, but what other alternative is there? Isn't Firecalc already "conservative enough" if I input and look for a 100% success despite a 50 year period??

I guess you could mitigate the risk over such a long period by adjusting the spending along the way or possibly side jobs/re-entering the workforce if there is a shortfall. Or padding the initial requirement numbers even more leading to the OMY syndrome.....
Apex1 is offline   Reply With Quote
Old 03-09-2013, 12:26 PM   #8
Thinks s/he gets paid by the post
 
Join Date: Jul 2005
Posts: 4,366
Quote:
Originally Posted by Apex1 View Post
Thanks Animorph,

Right and i did re-read the explanation of how FIRECalc works, but what other alternative is there? Isn't Firecalc already "conservative enough" if I input and look for a 100% success despite a 50 year period??

I guess you could mitigate the risk over such a long period by adjusting the spending along the way or possibly side jobs/re-entering the workforce if there is a shortfall. Or padding the initial requirement numbers even more leading to the OMY syndrome.....
You won't get any scenario that includes starting retirement in 1999, for example, if your retirement period is more than 12 years or so (depending on whenever the last year of data is). For a 50 year period, your last starting year is roughly 1961. Maybe not one of the better times to start, but maybe not one of the worst. One thing you can do is try a shorter period but require a specific ending value. In your case two 25 year periods might be useful.

The is nothing "conservative" about FIRECalc, only about how you use it. It uses actual historical returns and inflation. If you think future returns will be less than historical averages, FIRECalc may be optimistic.
Animorph is offline   Reply With Quote
Old 03-09-2013, 01:22 PM   #9
Thinks s/he gets paid by the post
Live And Learn's Avatar
 
Join Date: Feb 2012
Location: Tampa Bay Area
Posts: 1,866
Quote:
Originally Posted by Animorph View Post
One thing you can do is try a shorter period but require a specific ending value. In your case two 25 year periods might be useful. .
What a GREAT idea ! I'm going to do that right now for myself !
__________________
"For the time being no discipline brings joy, but seems grievous and painful; but afterwards it yields a peaceable fruit of righteousness to those who have been trained by it." ~
Hebrews 12:11

ER'd in June 2015 at age 52. Initial WR 3%. 50/40/10 (Equity/Bond/Short Term) AA.
Live And Learn is offline   Reply With Quote
Old 03-09-2013, 01:43 PM   #10
Give me a museum and I'll fill it. (Picasso)
Give me a forum ...
youbet's Avatar
 
Join Date: Mar 2005
Location: Chicago
Posts: 13,151
Quote:
Originally Posted by REWahoo View Post
Apex, to better understand the caution note from Animorph take a look at FIRECalc: How it Works, especially the section titled "How about describing FIRECalc step by step?". Bottom line, the longer the retirement period the fewer the retirement cycle 'test runs' by FIRECalc.
Yes, and longer test periods can actually look better than shorter periods in some cases. Intuitively you wouldn't think so, but in some of my runs with 100% success rates, I have a higher minimum ending balance using 30 yrs than with 25 yrs.
__________________
"I wasn't born blue blood. I was born blue-collar." John Wort Hannam
youbet is offline   Reply With Quote
Old 03-09-2013, 11:42 PM   #11
Recycles dryer sheets
 
Join Date: Jan 2013
Posts: 79
Quote:
Originally Posted by Animorph View Post
One thing you can do is try a shorter period but require a specific ending value. In your case two 25 year periods might be useful.

The is nothing "conservative" about FIRECalc, only about how you use it. It uses actual historical returns and inflation. If you think future returns will be less than historical averages, FIRECalc may be optimistic.
Requiring a specific ending value seems arbitrary to me. What would you suggest for the assumptions given in the OP? I initially considered the idea of breaking the calculation into two 25 periods with 100% success rate in each period but that gave me a number of 3.75m that seems too high (2.5m for the first 25 year period of 100k expense and 1.25m for the second 25 year period of 50k expense) ...... even higher than 3.3m (3% swr of 100k throughout the entire 50 years)
Apex1 is offline   Reply With Quote
Old 03-09-2013, 11:56 PM   #12
Recycles dryer sheets
 
Join Date: Jan 2013
Posts: 79
Quote:
Originally Posted by youbet View Post
Yes, and longer test periods can actually look better than shorter periods in some cases. Intuitively you wouldn't think so, but in some of my runs with 100% success rates, I have a higher minimum ending balance using 30 yrs than with 25 yrs.
Yes I found the same results with many of the longer test periods.

My intuition tells me that FireCalc is less reliable in these cases (because of less sample size/test runs) but on the other hand,my intuition also tells me the longer the test period, the greater the likelihood of regression to the mean.
Apex1 is offline   Reply With Quote
Old 03-10-2013, 12:19 AM   #13
Recycles dryer sheets
 
Join Date: Jan 2013
Posts: 79
Quote:
Originally Posted by Animorph View Post
The is nothing "conservative" about FIRECalc, only about how you use it. It uses actual historical returns and inflation. If you think future returns will be less than historical averages, FIRECalc may be optimistic.
I was using "conservative" in reference to using 100% success rate in FIRECalc which usually results in an average ending portfolio that is significantly higher than the starting portfolio.
Apex1 is offline   Reply With Quote
Old 03-10-2013, 03:58 PM   #14
Thinks s/he gets paid by the post
 
Join Date: Jul 2005
Posts: 4,366
Quote:
Originally Posted by Apex1 View Post
Requiring a specific ending value seems arbitrary to me. What would you suggest for the assumptions given in the OP? I initially considered the idea of breaking the calculation into two 25 periods with 100% success rate in each period but that gave me a number of 3.75m that seems too high (2.5m for the first 25 year period of 100k expense and 1.25m for the second 25 year period of 50k expense) ...... even higher than 3.3m (3% swr of 100k throughout the entire 50 years)
I don't have a great answer for the OP. My best quick answer would be to run the second period first with the normal $0 ending. Find the 100% success rate starting value. Then run the first period with an ending value equal to the 100% success rate second period starting value. Then you can find the first period starting value that gives you 100% success. Or, you could try 90% or whatever. Given these are not exactly random trials, I think the combined probability of 90% and 90% is open to interpretation.
Animorph is offline   Reply With Quote
Old 03-10-2013, 08:10 PM   #15
Recycles dryer sheets
 
Join Date: Jan 2013
Posts: 79
Quote:
Originally Posted by Animorph View Post
I don't have a great answer for the OP. My best quick answer would be to run the second period first with the normal $0 ending. Find the 100% success rate starting value. Then run the first period with an ending value equal to the 100% success rate second period starting value. Then you can find the first period starting value that gives you 100% success. Or, you could try 90% or whatever. Given these are not exactly random trials, I think the combined probability of 90% and 90% is open to interpretation.
Thanks or spelling that out or me! Great idea!! I got slightly ober 3mill doing it this way (90% or the irst period).
Apex1 is offline   Reply With Quote
Old 03-10-2013, 09:27 PM   #16
Give me a museum and I'll fill it. (Picasso)
Give me a forum ...
Amethyst's Avatar
 
Join Date: Dec 2008
Posts: 12,598
The effect of pension income, for us, is very different from the effect of reduced spending. Our pensions are/will be entirely taxable - Federal, state, local. Reduced spending, OTOH, is an exact dollar-for-dollar gain.

Your mileage may vary, as not all pensions are taxed, or taxed the same way.

Amethyst


Quote:
Originally Posted by Apex1 View Post
esides, i would have never figured out that adding 50k pension would have the same effect as 50k reduction in spending.
__________________
If you understood everything I say, you'd be me ~ Miles Davis
'There is only one success – to be able to spend your life in your own way.’ Christopher Morley.
Even a blind clock finds an acorn twice a day.
Amethyst is offline   Reply With Quote
Old 03-10-2013, 09:49 PM   #17
Give me a museum and I'll fill it. (Picasso)
Give me a forum ...
 
Join Date: Sep 2005
Location: Northern IL
Posts: 26,821
Quote:
Originally Posted by Apex1 View Post
Requiring a specific ending value seems arbitrary to me. What would you suggest for the assumptions given in the OP? I initially considered the idea of breaking the calculation into two 25 periods with 100% success rate in each period but that gave me a number of 3.75m that seems too high (2.5m for the first 25 year period of 100k expense and 1.25m for the second 25 year period of 50k expense) ...... even higher than 3.3m (3% swr of 100k throughout the entire 50 years)
The 'problem' (better to call it an anomaly?) with two consecutive 25 year runs is you get hit with the the absolute worst 25 year period, followed by the exact same absolute worst 25 year period. A double-whammy!

It's as if we had two consecutive Great Depressions, or two 70s-80-s market/inflation cycles spaced 25 years apart. I don't think any 50 year period has actually been as bad as two of the worst 25 year periods stacked together.

It might still be useful, just keep that in mind when looking at the numbers.

-ERD50
ERD50 is offline   Reply With Quote
Old 03-11-2013, 08:43 AM   #18
Recycles dryer sheets
 
Join Date: Jan 2013
Posts: 79
Quote:
Originally Posted by Amethyst View Post
The effect of pension income, for us, is very different from the effect of reduced spending. Our pensions are/will be entirely taxable - Federal, state, local. Reduced spending, OTOH, is an exact dollar-for-dollar gain.

Your mileage may vary, as not all pensions are taxed, or taxed the same way.

Amethyst
Enter the after-tax pension amount?

For me personally, I am trying to predict all my personal expenses on an after tax basis (and not include the taxes as an expense). However, the spending amount ("start here tab")I enter into Firecalc is grossed up to a before-tax amount. At least, thats I how look at it.
Apex1 is offline   Reply With Quote
Old 03-11-2013, 08:54 AM   #19
Recycles dryer sheets
 
Join Date: Jan 2013
Posts: 79
Quote:
Originally Posted by ERD50 View Post
The 'problem' (better to call it an anomaly?) with two consecutive 25 year runs is you get hit with the the absolute worst 25 year period, followed by the exact same absolute worst 25 year period. A double-whammy!

It's as if we had two consecutive Great Depressions, or two 70s-80-s market/inflation cycles spaced 25 years apart. I don't think any 50 year period has actually been as bad as two of the worst 25 year periods stacked together.

It might still be useful, just keep that in mind when looking at the numbers.

-ERD50
Thanks for putting this into context! At the same time, if you string two consecutive bull markets, you might have been able to pull the plug ALOT sooner.
Apex1 is offline   Reply With Quote
Old 03-11-2013, 11:20 AM   #20
Recycles dryer sheets
FinancialDave's Avatar
 
Join Date: Nov 2012
Location: Olympia
Posts: 150
To be honest I really don't think any of these calculators are going to be any more accurate than a general rule of thumb that if you save 15% of your salary from in your mid twenties to age 66 you will do fine. If you want to retire earlier then just up the saving rate - the goal being to hit 25 times your retirement expenses by retirement time. When you get within 15 years or so of retirement, you can start fine tuning your glide path, but trying to do it over 25 years is a bit much.

fd
FinancialDave is offline   Reply With Quote
Reply


Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are Off
Pingbacks are Off
Refbacks are Off


» Quick Links

 
All times are GMT -6. The time now is 07:22 AM.
 
Powered by vBulletin® Version 3.8.8 Beta 1
Copyright ©2000 - 2024, vBulletin Solutions, Inc.