FIRECalc and the Hapless Y2K Retiree

NW-Bound

Give me a museum and I'll fill it. (Picasso) Give me a forum ...
Joined
Jul 3, 2008
Messages
35,712
I was inspired by a concurrent thread by Haha, where he asked whether any of us has seen his/her portfolio going below its starting point.

See: http://www.early-retirement.org/for...-portfolio-decrease-since-retiring-69887.html

In the above thread, I contributed a link to a site where it was shown that a Y2K retiree with a portfolio of 75% equity and 25% 6-month commercial paper would be in deep trouble. By Jan 2013 his portfolio is already down to 36% in real terms. I was not the first to post a link to that table; in fact, I learned about it from earlier posts by several posters on this forum.

The 36% final value after 13 years of retirement looks bleak. However, raddr, the author of that table used a portfolio of high equity AA of 75%, plus a 4% WR. So, I wondered if the above could have compounded the effects of the "Lost Decade" in stocks.

I am glad I still had part-time income from 2000 till 2012, so I did fairly well financially. But to satisfy my own curiosity about the fate of earlier retirees, I've got to check further on my own. And FIRECalc is the natural tool to use here. And as I already collected the run results, I might as well share them here as a community service.

To aid anybody who wants to double check the results, here is what I did. I set FIRECalc to $1M initial portfolio, and for 12-year runs. In the "Investigate" tab, I chose to download a single-run result spreadsheet starting with the year 2000. If I set the run duration for 13 years, FIRECalc would back off the initial year to 1999. Apparently, FIRECalc only has data up to the end of 2011 (start of 2000 to end of 2011 encompasses 12 years).

On the portfolio tab, for the simple stock/bond portfolio, FIRECalc offers the following fixed income (FI) options: commercial paper, long-term rate, 30-yr Treasury, and 5-yr Treasury. I ran them all. For each choice of FI asset, I ran a mix with 60%, 50%, 40%, and 0% total equity market, with total market being the only choice here for equity. I believe the Total US Market index is fairly close to the S&P 500. The expense ratio was left at the default 0.18%.

The results are shown below for $1M initial portfolio in 1/2000, and a WR of 4% with COLA.

Commercial Paper +Ending Nominal Val (1/2012)Ending Infl. Adj. Value
100% equity404K300K
60% equity525K391K
50% equity545K406K
40% equity561K418K
0% equity583K434K

Long Int. Rate +Ending Nominal Val (1/2012)Ending Infl. Adj. Value
100% equity404K300K
60% equity638K475K
50% equity692K515K
40% equity742K553K
0% equity907K675K

30-Yr Treasury +Ending Nominal Val (1/2012)Ending Infl. Adj. Value
100% equity404K300K
60% equity655K488K
50% equity714K532K
40% equity771K574K
0% equity960K715K


5-Yr Treasury +Ending Nominal Val (1/2012)Ending Infl. Adj. Value
100% equity404K300K
60% equity612K456K
50% equity657K489K
40% equity699K521K
0% equity825K614K


Observations:

  • The 60% commercial paper + 40% equity portfolio ended with $391K. This is close to the 75/25 raddr case, which ended with $360K one year later in Jan 2013.
  • The 100% equity case is just terrible, with $300K final value.
  • The more equity, the worse the final value. That is true no matter what you choose for FI. They do not call the recent years the "Lost Decade" for nothing.
  • The best case is the portfolio with 100% 30-yr treasury. It ended with the portfolio nearly intact in nominal terms, but a bit above $700K in real terms. That is a lot better than the balanced portfolio with 50% equity mixed in.

So, balanced portfolios did not do well during the "Lost Decade" for stocks. We already knew that stock return was flat over this period of 2000-2012, even with dividends. What I found surprising was that rebalancing did not help that much, as the best one could do was holding no equity at all.

Now, knowing after the fact that 100% 30-yr Treasury was best, I wondered what happened if the unlucky retiree cut back on his WR. Following is the result showing effects of various WR rates.

100% 30-Yr TreasuryEnding Nominal Val (1/2012)Ending Infl. Adj. Value
0.0% WR1690K1258K
3.0% WR + COLA1143K851K
3.5% WR + COLA1052K783K
4.0% WR + COLA960K715K

A cut back of WR by 25% from 4% to 3% helps the final value by 19% ($715K to $815K).

Final Observation:

As I explained, FIRECalc only lets me get to Jan 2012. Since then, the market has rallied, and 30-yr Treasury has dropped -14% in 2013, using VUSTX as a surrogate. This would equalize the results in the table somewhat, but I think our 50/50 indexed balanced-portfolio retiree is still sweating.

People in some active funds like Wellesley or Wellington might do better, thanks to the skill of the fund managers. I might do a follow-up on that.
 
Last edited:
For those of us getting ready to retire today, how comparable is the current market to 2000? Anyone got a crystal ball?

Great research, BTW. Thank you.
 
Great work NW. I did not realize it was that bad.

Ha
 
Good stuff, NW.


I'd be very interested to see how a mix of W&W compares.

I had the exact same thought as I was reading your post - what would today's results be if I had kept 3 years worth of annual withdrawals in Wellesley and the rest in Wellington?
 
For those of us getting ready to retire today, how comparable is the current market to 2000? Anyone got a crystal ball?

Great research, BTW. Thank you.
You can make a pretty good quick and dirty estimate by making a ratio of PE10 at the peak of that 2000 market, and PE10 now. 2000 was much more outrageously high. However, the current market PE10 is not far below the well remembered 1929 high.

Ha
 
I knew it was that bad, as a proud member of Y2K retiree class. I also figured that my 2.5-3% withdrawal rate helped save me.

But I am still trying to figure out how I ended breaking even on nominal basis at the start of 2013 and after this year on inflation adjusted basis, with a portfolio that was between 55-85% equities
 
People in some active funds like Wellesley or Wellington might do better, thanks to the skill of the fund managers. I might do a follow-up on that.

Thanks for this thread, I was also reviewing that 'hapless retiree' thread.

This isn't a full update, but a quick eyeball of how Wellesley held up in the 2000-2003 time period is amazing. It didn't just not go down as much as as a balanced fund, it actually pretty much went UP the entire time!

Its response to the 2007-2008 downturn is more what I would expect. Did they get lucky in 2000? Was it skill? Could that have worked against them if they misjudged?

It would be interesting to see how a 30% allocation to Wellesley would have smoothed out the trough.

PerfCharts - StockCharts.com - Free Charts (reset the time period bar if you visit the site)



-ERD50
 

Attachments

  • Screenshot - VWINX-SPY-VBINX.png
    Screenshot - VWINX-SPY-VBINX.png
    94.8 KB · Views: 39
Last edited:
Great post NW-Bound!!! I am going to go back and review your research in greater detail as it is interesting stuff.

I interpret your findings as what happens with reverse dollar cost averaging. The 2000 retiree had a sideways secular with two dramatic downturns to be withdrawing from a stock portfolio. Also it is interesting that Firecalc stops at 2011 which would ignore the bond bull market since that point but that is minor in the greater scheme of your research.

Aim Hi, haha hit the nail on the head. This is a good time to be cautious with new stock purchases. In 1999 the PE 10 was at 43.? as I recall, and right now it is about 26 which isn't as high as 1999 but is still a historically high number. However, who knows for sure which way the market is going to go and when? No one. If I did, I would not be typing away here but I'd be out shorting the market or buying more of it. As for me, I don't worry too much about it. I have an AA I am content with and I tend to ignore the markets.
 
Its response to the 2007-2008 downturn is more what I would expect. Did they get lucky in 2000? Was it skill? Could that have worked against them if they misjudged?

I think that Wellesley held up pretty well in 2000 because it invested in "boring" dividend payers and avoided the kind of stocks that got decimated when the tech bubble burst. Its hefty bond allocation also juiced returns as interests rates decreased from 2000 to 2003.
 
I think that Wellesley held up pretty well in 2000 because it invested in "boring" dividend payers and avoided the kind of stocks that got decimated when the tech bubble burst. Its hefty bond allocation also juiced returns as interests rates decreased from 2000 to 2003.
I think you are correct. I have a spreadsheet showing the following annual performance (including dividends) for Wellesley (VWINX) during that time period:

2000 16.2%
2001 7.4%
2002 4.6%
2003 9.7%
2004 7.6%
 
Yes, Wellesley and Wellington have been conservative funds which buy stodgy low P/E stocks. Anyone can go to Morningstar to look at the performance of these two funds vs. VFINX (S&P index), and to see that these funds lagged the index badly during the go-go years of 1980-2000. But then, they have made up all that in the last 12 years. Reversion to the mean works, even if it takes two decades!

Anyway, from Yahoo, I have downloaded the annual total return of Wellesley, Wellington, VFINX (S&P Index), and VUSTX which is long-term Treasury fund, for the years 2000-2012. The numbers for Wellesley and Wellington are for the Admiral shares which have lower expense ratios. For the years 2000, 2001, I had to use the normal shares.

Looking at the table below, one can see that the S&P index got 3 bad years in a row, starting at 2000. However, VUSTX was the reverse.

So, how could a 50/50 blend of VFINX+VUSTX be so bad? By just eyeballing the data, I could not see the reason. Do I doubt the results of FIRECalc?

Let me just say that I am putting the returns of these 4 funds into a spreadsheet I am building, and will report back on what I find.

Note: All numbers are in percent.

YearWellesleyWellington-- VFINX ----VUSTX--Inflation
2000
16.17​
10.40​
-9.06​
19.7​
3.4​
2001
7.39​
4.19​
-12.02​
4.31​
2.8​
2002
4.72​
-6.81​
-22.15​
16.67​
1.6​
2003
9.78​
20.90​
28.5​
2.68​
2.3​
2004
7.70​
11.34​
10.74​
7.12​
2.7​
2005
3.56​
6.99​
4.77​
6.61​
3.4​
2006
11.39​
15.07​
15.64​
1.74​
3.2​
2007
5.76​
8.48​
5.39​
9.24​
2.8​
2008
-9.79​
-22.23​
-37.02​
22.51​
3.8​
2009
16.14​
22.34​
26.49​
-12.06​
-0.4​
2010
10.71​
11.04​
14.91​
8.92​
1.6​
2011
9.74​
3.95​
1.97​
29.27​
3.2​
2012
10.10​
12.67​
15.82​
3.46​
2.1​
 
Even though having a portfolio high in 30-yr treasuries may have held up well against withdrawals since 2000, I would NOT recommend that strategy today.
 
Even though having a portfolio high in 30-yr treasuries may have held up well against withdrawals since 2000, I would NOT recommend that strategy today.
Yes, the rate decline since the 1980's will not be repeated.

Maybe growth at "almost" any price will be pushed by governments around the world. Just a guess.
 
...(snip)...
This isn't a full update, but a quick eyeball of how Wellesley held up in the 2000-2003 time period is amazing. It didn't just not go down as much as as a balanced fund, it actually pretty much went UP the entire time!
...
I think the chart posted might not be quite right. Here is a Morningstar chart with some selected balanced funds and the SP500 index:

k16l3d.jpg
 
I think that Wellesley held up pretty well in 2000 because it invested in "boring" dividend payers and avoided the kind of stocks that got decimated when the tech bubble burst. Its hefty bond allocation also juiced returns as interests rates decreased from 2000 to 2003.

Yes, but when I use that site to check other DIV-based funds/ETFs they don't do anywhere near as well well as Wellesley, even if I eyeball some bond fund balance in there.

VDIGX looks about the same as SPY, DVY did better in the 2000 crunch, but still fell (again, eyeballing some bond holding in there doesn't help much). And DVY looks to have taken a huge hit from the 2007 peak down to 2008-2009, more volatile than SPY (though some bond allocation would temper that)!

PerfCharts - StockCharts.com - Free Charts

-ERD50
 
...(snip)...
To aid anybody who wants to double check the results, here is what I did. I set FIRECalc to $1M initial portfolio, and for 12-year runs. In the "Investigate" tab, I chose to download a single-run result spreadsheet starting with the year 2000. If I set the run duration for 13 years, FIRECalc would back off the initial year to 1999. Apparently, FIRECalc only has data up to the end of 2011 (start of 2000 to end of 2011 encompasses 12 years).
...
Nice work NW-Bound.

I recently ran FIRECalc to get some specific sequences that appear to be worst case:
1) start in 1929 - Great Depression and into WW2
2) start in 1966 - recessions + 1970's inflation
3) start in 2000 - recent nasty sequence

I might have gotten to these results a little differently then you. It's unclear to me from your discussion of your procedures above. Anyway, in the investigate tab I selected spreadsheet results and also selected the starting retirement year (like 1929, 1966 or 2000). Then in the results I selected the second spread sheet: "Open a spreadsheet showing the year by year inputs, data, ... ". The last column in this spreadsheet shows the sequence for the selected year.

This is a way to get the numerical results for those lowest level lines in the familiar colored line chart FIRECalc puts out in the summary sheet.
 
I think the chart posted might not be quite right. Here is a Morningstar chart with some selected balanced funds and the SP500 index:

k16l3d.jpg

Note the time frames are slightly different.

I'm not saying some other balanced funds did not do as well as Wellesley (I didn't have Wellington or D&C in my chart). I'm just saying it looks to be more than some simple indexing, as the general style dividend 'index funds' did not do as well.

-ERD50
 
Yes, but when I use that site to check other DIV-based funds/ETFs they don't do anywhere near as well well as Wellesley, even if I eyeball some bond fund balance in there.

VDIGX looks about the same as SPY, DVY did better in the 2000 crunch, but still fell (again, eyeballing some bond holding in there doesn't help much). And DVY looks to have taken a huge hit from the 2007 peak down to 2008-2009, more volatile than SPY (though some bond allocation would temper that)!

PerfCharts - StockCharts.com - Free Charts

-ERD50

I think that Wellesley is more value-oriented than most dividend "index funds". Therefore, Wellesley's management largely avoided the P/E expansion trap of the late 1990s.
 
Note the time frames are slightly different.

I'm not saying some other balanced funds did not do as well as Wellesley (I didn't have Wellington or D&C in my chart). I'm just saying it looks to be more than some simple indexing, as the general style dividend 'index funds' did not do as well.

-ERD50
Yes, these finds do extremely well. I use Wellington as a benchmark. The way I do it is to mix Wellington, some international pure equity, and my short bond + cash into a benchmark. And damned it, that Wellington is tough to beat. If I beat it, it's only by a very small amount.

Yet, I still worry about turning it all over to any one active manager team. Maybe in my dotage I'll consider a mix of balanced funds like Wellington, Wellesley, and Dodge & Cox.
 
Maybe in my dotage I'll consider a mix of balanced funds like Wellington, Wellesley, and Dodge & Cox.
I was a big D&C fan until it fell prey to the lure of financial stocks in the run up to 2008. I recall it took a beating compared to the two Vanguard funds.
 
Last edited:
Even though having a portfolio high in 30-yr treasuries may have held up well against withdrawals since 2000, I would NOT recommend that strategy today.

Yes, the rate decline since the 1980's will not be repeated.

Maybe growth at "almost" any price will be pushed by governments around the world. Just a guess.

Much of the gain in Treasuries is in principal appreciation, not due to the dividend. And the only way for principal to appreciate some more is for the interest rate to go even lower, or for deflation to occur. What already happened was once in a lifetime perhaps, not unlike the dotcoms of the late 90s.
 
...

So, how could a 50/50 blend of VFINX+VUSTX be so bad? By just eyeballing the data, I could not see the reason. Do I doubt the results of FIRECalc?

Let me just say that I am putting the returns of these 4 funds into a spreadsheet I am building, and will report back on what I find.

Note: All numbers are in percent.

YearWellesleyWellington-- VFINX ----VUSTX--Inflation
2000
16.17​
10.40​
-9.06​
19.7​
3.4​
2001
7.39​
4.19​
-12.02​
4.31​
2.8​
2002
4.72​
-6.81​
-22.15​
16.67​
1.6​
2003
9.78​
20.90​
28.5​
2.68​
2.3​
2004
7.70​
11.34​
10.74​
7.12​
2.7​
2005
3.56​
6.99​
4.77​
6.61​
3.4​
2006
11.39​
15.07​
15.64​
1.74​
3.2​
2007
5.76​
8.48​
5.39​
9.24​
2.8​
2008
-9.79​
-22.23​
-37.02​
22.51​
3.8​
2009
16.14​
22.34​
26.49​
-12.06​
-0.4​
2010
10.71​
11.04​
14.91​
8.92​
1.6​
2011
9.74​
3.95​
1.97​
29.27​
3.2​
2012
10.10​
12.67​
15.82​
3.46​
2.1​

So, I have done what I said I would do, and some more. I have also resolved the apparent conflict between FIRECalc and my eyeballing of VUSTX.

It will take longer to prepare the tables for posting than it did for me to make the spreadsheet runs to check against FIRECalc and raddr's result. So, bear with me. Results will be shown shortly.
 
First, I need to show the data I obtained off Vanguard site and Yahoo.

I will then use this data in a spreadsheet. The idea is to show performance of a theoretical balanced indexer à la FIRECalc and other similar retirement calculators. I saw something there that bothered me, and I am the type who likes to overturn stones. :)

And then, I want to see performance of the passive indexer vs. Wellesley and Wellington share holders.

The annual returns of the following MFs are shown.

VUSTX: Vanguard Long-term Treasury
VTSAX: Vanguard Total Stock Market (US)
VFIAX: Vanguard S&P 500 Index
VWIAX: Wellesley Admiral
VWENX: Wellington Admiral

All numbers are in percent.
Year
VUSTX​
VTSAX​
VFIAX​
VWIAX​
VWENX​
Inflation​
2000
19.7​
-9.06#​
-9.06​
16.17*​
10.40*​
3.38​
2001
4.31​
-10.89​
-12.02​
7.39*​
4.19*​
2.83​
2002
16.67​
-20.95​
-22.15​
4.72​
-6.81​
1.59​
2003
2.68​
31.42​
28.5​
9.78​
20.9​
2.27​
2004
7.12​
12.61​
10.82​
7.7​
11.34​
2.68​
2005
6.61​
6.09​
4.87​
3.56​
6.99​
3.39​
2006
1.74​
15.63​
15.75​
11.39​
15.07​
3.24​
2007
9.24​
5.57​
5.47​
5.76​
8.48​
2.85​
2008
22.52​
-36.99​
-36.97​
-9.79​
-22.23​
3.85​
2009
-12.05​
28.83​
26.62​
16.14​
22.34​
-0.34​
2010
8.93​
17.26​
15.05​
10.71​
11.04​
1.64​
2011
29.28​
1.08​
2.08​
9.74​
3.95​
3.16​
2012
3.47​
16.38​
15.96​
10.1​
12.67​
2.07​
2013
-13.03​
33.52​
32.33​
9.57​
19.76​
1.45**​

Notes:

Admiral shares are used where available to reduce expense ratio.
#: N/A, and VFIAX is used for filler.
*: N/A. Normal shares (non-Admiral) are used for filler.
**: Data available only through Oct, and pro-rated through year end.
 
Last edited:
Back
Top Bottom