Follow-up on my first post on variable withdraw strategy.
Using a flat 4% just isn't what I will be willing to do. If the market is down, I'm not comfortable taking 4% out at the bottom, after several down years (think 1929) I would take even less. In good times, I would like to take more. Mostly, I want to maximize the money I take out between 60-80 without going broke later and I also don't want to leave $Ms to someone else, I want to spend it, but without risking going broke.
So, I developed a stripped down, custom FIREcalc to test this - it doesn't have all the features, but it does test this theory.
Inputs: 100% stock portfolio, 40 year retirement (have down 30 yr also with similar results), CPI inflation
I look up the Market return minus inflation in the following table and get this year's withdrawal rate
:
Return - Inflation / Withdrawal
17% 10.0%
16% 9.0%
15% 8.0%
14% 7.5%
13% 7.0%
12% 6.5%
11% 6.0%
10% 5.5%
9% 5.0%
8% 4.5%
7% 4.5%
6% 4.0%
5% 4.0%
4% 3.5%
3% 3.0%
2% 2.5%
Then I look up age in a table like this (only part of the table)
Age Maximum Withdrawal
55 2.5%
56 2.5%
57 2.5%
58 3.0%
59 6.0%
60 9.0%
61 9.0%
62 9.0%
63 9.0%
64 10.0%
65 10.0%
66 10.0%
I then take the smaller number as the withdraw rate for that year.
If the real dollar value of the portfolio is less than 50% of the starting value, I over ride the withdraw and only take 1.5% This fixed going broke in 1929 and 1966 and makes a lot of sense to me!
If the real dollar value of the portfio is greater than 125%, than I add an additional 4% withdraw to the withdraw from above. If real dollar value is greater than 150%, then I add 10%. This helps spend money in the good times! That's about it. Here are the results:
Starting with 1871 data through 2006:
Number of Cycles 97
Number of Successful Cycles 97
Percent Surviability 100%
Min ending portfolio value in real dollars as percent of beginning portfolio 56 %
Median ending portfolio value in real dollars as % of beginning portfolio 105 %
Max ending portfolio value in real dollars as percent of beginning portfolio 247 %
Min avg withdrawal rate 3.84%
Median avg withdrawal rate 6.26%
Max avg withdrawal rate 13.63%
Worst cycle 3.84%
2nd worst cycle 3.89%
3rd worst cycle 4.03%
4th worst cycle 4.10%
5th worst cycle 4.11%
Cycles between 0 - 4 2
Cycles between 4 - 4.5 13
Cycles between 4.5 - 5 6
Cycles between 5 - 6 22
Cycles between 6 -7 13
Cycles between 7- 8 6
Cycles between 8 - 9 8
Cycles between 9+ 27
I think these rules are common sense, are not data mining, just trying to squeeze more money out of the portfolio by selling (spending) more in good times and selling less in bad (belt tightening in poor times).
The results I'm getting says one can safe squeeze, in most market conditions, a lot more than 4% from the portfolio.
Anyone else have some similar calculations?
Using a flat 4% just isn't what I will be willing to do. If the market is down, I'm not comfortable taking 4% out at the bottom, after several down years (think 1929) I would take even less. In good times, I would like to take more. Mostly, I want to maximize the money I take out between 60-80 without going broke later and I also don't want to leave $Ms to someone else, I want to spend it, but without risking going broke.
So, I developed a stripped down, custom FIREcalc to test this - it doesn't have all the features, but it does test this theory.
Inputs: 100% stock portfolio, 40 year retirement (have down 30 yr also with similar results), CPI inflation
I look up the Market return minus inflation in the following table and get this year's withdrawal rate
:
Return - Inflation / Withdrawal
17% 10.0%
16% 9.0%
15% 8.0%
14% 7.5%
13% 7.0%
12% 6.5%
11% 6.0%
10% 5.5%
9% 5.0%
8% 4.5%
7% 4.5%
6% 4.0%
5% 4.0%
4% 3.5%
3% 3.0%
2% 2.5%
Then I look up age in a table like this (only part of the table)
Age Maximum Withdrawal
55 2.5%
56 2.5%
57 2.5%
58 3.0%
59 6.0%
60 9.0%
61 9.0%
62 9.0%
63 9.0%
64 10.0%
65 10.0%
66 10.0%
I then take the smaller number as the withdraw rate for that year.
If the real dollar value of the portfolio is less than 50% of the starting value, I over ride the withdraw and only take 1.5% This fixed going broke in 1929 and 1966 and makes a lot of sense to me!
If the real dollar value of the portfio is greater than 125%, than I add an additional 4% withdraw to the withdraw from above. If real dollar value is greater than 150%, then I add 10%. This helps spend money in the good times! That's about it. Here are the results:
Starting with 1871 data through 2006:
Number of Cycles 97
Number of Successful Cycles 97
Percent Surviability 100%
Min ending portfolio value in real dollars as percent of beginning portfolio 56 %
Median ending portfolio value in real dollars as % of beginning portfolio 105 %
Max ending portfolio value in real dollars as percent of beginning portfolio 247 %
Min avg withdrawal rate 3.84%
Median avg withdrawal rate 6.26%
Max avg withdrawal rate 13.63%
Worst cycle 3.84%
2nd worst cycle 3.89%
3rd worst cycle 4.03%
4th worst cycle 4.10%
5th worst cycle 4.11%
Cycles between 0 - 4 2
Cycles between 4 - 4.5 13
Cycles between 4.5 - 5 6
Cycles between 5 - 6 22
Cycles between 6 -7 13
Cycles between 7- 8 6
Cycles between 8 - 9 8
Cycles between 9+ 27
I think these rules are common sense, are not data mining, just trying to squeeze more money out of the portfolio by selling (spending) more in good times and selling less in bad (belt tightening in poor times).
The results I'm getting says one can safe squeeze, in most market conditions, a lot more than 4% from the portfolio.
Anyone else have some similar calculations?