Join Early Retirement Today
Reply
 
Thread Tools Display Modes
starting year for sampling
Old 05-10-2012, 05:35 PM   #1
Recycles dryer sheets
 
Join Date: Dec 2010
Posts: 445
starting year for sampling

The starting year of stock market /economy sampling in Firecalc makes a huge difference in the results. What starting date gives the most valid result? If I put 1871, I get 68 %; 1955, 37%; 1945, 56%. Thanks for your thoughts.
palomalou 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 05-10-2012, 05:56 PM   #2
Give me a museum and I'll fill it. (Picasso)
Give me a forum ...
Midpack's Avatar
 
Join Date: Jan 2008
Location: NC
Posts: 21,204
I understand how the results would change as your reducing the data/cycles used, but what's the purpose of entering a starting year other than the default 1871? Unless you know of bad or unrepresentative data in early years, doesn't more data provide more meaningful results? You entered 1955 for example, that's only 27 cycles (based on 30 years) - many of us will be retired for 30-40 years.
__________________
No one agrees with other people's opinions; they merely agree with their own opinions -- expressed by somebody else. Sydney Tremayne
Retired Jun 2011 at age 57

Target AA: 50% equity funds / 45% bonds / 5% cash
Target WR: Approx 1.5% Approx 20% SI (secure income, SS only)
Midpack is online now   Reply With Quote
Old 05-10-2012, 08:51 PM   #3
Recycles dryer sheets
 
Join Date: Dec 2010
Posts: 445
Thanks, Midpack. I just wondered whether I would get very different results, and wow, did I ever! No scientific reason to dispute the 1871, just wondering/fretting.
palomalou is offline   Reply With Quote
Old 05-10-2012, 09:30 PM   #4
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 palomalou View Post
Thanks, Midpack. I just wondered whether I would get very different results, and wow, did I ever! No scientific reason to dispute the 1871, just wondering/fretting.
To track down starting years that result in outliers in your outcomes, drop a spreadsheet and run a histogram of the end year you're interested in. Also, just sort the column of that same year and note which years give you the worse outcomes.

The FireCalc run I do which I feel best tests my current situation (complicated by upcoming portfolio adjustments funding 529b's for the grandkids, setting up a trust for a special needs grandson, helping to fund MIL's future NH care and blaah, blaah, blaah) has a dip in year 5. The run recovers and is 100% successful with significant margin, but, still, I was interested in what beginning year ( and the econ condx of those times) resulted in a dip in year 5 given my parameters. I just requested the excel sheet and sorted year 5 from highest to lowest amounts and then noted which beginning year corresponded to the low dip.

There's a lot of info in the Excel sheets you can drop when doing the FireCalc runs.

And you're spot on that the starting year is a major factor in the outcome variability. Frankly, there isn't all that much you can do about it except to accept that even the best laid, conservative plans with lots of flexibility may be a wild roller coaster ride. It's just the way it is.

BTW, you're just kind of beating around the bush by changing the default 1871 starting year. Go in and actually look at the outcomes for all the starting years. It's not hard to do and very interesting, especially if you plot histo's and gasp at the fact that a set of parameters can result in going broke or dieing very, very rich depending on the years you're living your plan.
__________________
"I wasn't born blue blood. I was born blue-collar." John Wort Hannam
youbet is offline   Reply With Quote
Old 05-11-2012, 08:32 AM   #5
Give me a museum and I'll fill it. (Picasso)
Give me a forum ...
Midpack's Avatar
 
Join Date: Jan 2008
Location: NC
Posts: 21,204
Quote:
Originally Posted by youbet View Post
The FireCalc run I do which I feel best tests my current situation (complicated by upcoming portfolio adjustments funding 529b's for the grandkids, setting up a trust for a special needs grandson, helping to fund MIL's future NH care and blaah, blaah, blaah) has a dip in year 5. The run recovers and is 100% successful with significant margin, but, still, I was interested in what beginning year ( and the econ condx of those times) resulted in a dip in year 5 given my parameters. I just requested the excel sheet and sorted year 5 from highest to lowest amounts and then noted which beginning year corresponded to the low dip.
I've also played with the spreadsheet results and it can be helpful and interesting indeed.

I'm confused by the exercise you describe above though. Picking out a FIRECALC start year(s) with a dip in returns at year five isn't the same as your known unusual expenses in year five. A dip in returns is not the same as unusual expenses, sequence of returns would actually compound the dip if you'd retired that year. Maybe you've already done it, but I'd be more inclined to enter the expenses you describe above as "off chart spending" or "lump sum changes (subtract)" in FIRECALC on those tabs. Those results may be even more representative of what you might have expected.

Apologies if I misunderstood your exercise or you've already tried off chart and or lump sum subtraction for comparison. FWIW...
__________________
No one agrees with other people's opinions; they merely agree with their own opinions -- expressed by somebody else. Sydney Tremayne
Retired Jun 2011 at age 57

Target AA: 50% equity funds / 45% bonds / 5% cash
Target WR: Approx 1.5% Approx 20% SI (secure income, SS only)
Midpack is online now   Reply With Quote
Old 05-12-2012, 04:42 PM   #6
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 Midpack View Post
I've also played with the spreadsheet results and it can be helpful and interesting indeed.

I'm confused by the exercise you describe above though. Picking out a FIRECALC start year(s) with a dip in returns at year five isn't the same as your known unusual expenses in year five.
Correct.
Quote:
A dip in returns is not the same as unusual expenses, sequence of returns would actually compound the dip if you'd retired that year.
Correct again
Quote:
Maybe you've already done it, but I'd be more inclined to enter the expenses you describe above as "off chart spending" or "lump sum changes (subtract)" in FIRECALC on those tabs.
That's what I did. Then I looked at the FireCalc output graph, noted that one starting year had an interesting dip in portfolio value at year #5 (not a dip in "returns" as you stated). I dropped the Excel data and sorted the year 5 outputs, just out of curiosity, to see what starting year resulted in the portfolio value dip in year #5. Interestingly, it was 1937. It's of no particular consequense other than contemplating how the parameters of my run interact with the FireCalc data beginning in 1937.

Just giving a simple example of how you can look at, sort, graph, run descriptive statistics, etc., on FireCalc output data. It's never led me to any significant actionable conclusions, but it's interesting. The biggest thing I've learned from repeatedly doing this is that ending portfolio values vary wildly depending on the years you're FIRE'd and there is little you can do about it. Learn to love variation!
__________________
"I wasn't born blue blood. I was born blue-collar." John Wort Hannam
youbet 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 12:13 PM.
 
Powered by vBulletin® Version 3.8.8 Beta 1
Copyright ©2000 - 2024, vBulletin Solutions, Inc.