
Question on Firecalc Monte Carlo
11232006, 08:13 AM

#1

Dryer sheet aficionado
Join Date: Nov 2006
Posts: 40

Question on Firecalc Monte Carlo
I have programmed my own MC analysis in Excel and the results do not generally agree well with what I get from FC, which I am trying to use as a check on my methodology. One odd thing I notice about FC is that the MC results are serially correlated with one another. If you look at the right graph, showing how the portfolio would have ended up in each of the 205 runs, you can see clearly that successive results are highly correlated. In a true Monte Carlo simulation, this should not be the case.
What is going on here ?




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 EarlyRetirement.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!

Re: Question on Firecalc Monte Carlo
11232006, 09:12 AM

#2

EarlyRetirement.org Founder Developer of FIRECalc
Join Date: Jun 2002
Posts: 1,840

Re: Question on Firecalc Monte Carlo
That's because the methofology isn't changed when you substitute random data for historical data.
The monte carlo process in FIRECalc generates random numbers within the bounds you set and assigns them to each year being tested. Then FIRECalc uses the same methodology for survival testing as it uses on historical data. So result 1 is a sequence of year 1  year 30, and result 2 is a sequence of year 2  year 31, etc.
If you are looking for a true brute force monte carlo analysis, FIRECalc ain't it. The monte carlo option is just to let people substitute different rates of return and volatility while retaining the methodology, so they can investigate different investment classes.
(When FIRECalc was being developed, it was tested against a thenavailable web tool for monte carlo analysis. That tool ran 10,000 iterations using a given rate of return and volatility. Not surprisingly, the results approximated what FIRECalc was showing, when historical returns and volatility were entered.)
Sorry to say, that tool disappeared years ago. The remnants can be seen at http://web.archive.org/web/200302030...drawalSim.html. I haven't seen a tool as easy to use.
__________________
Often uninformed, seldom undecided.
Twenty years from now you will be more disappointed by the things you didn't do than by the ones you did do. So throw off the bowlines. Sail away from the safe harbor. Catch the trade winds in your sails. Explore. Dream. Discover. Mark Twain



Re: Question on Firecalc Monte Carlo
11232006, 09:33 AM

#3

Dryer sheet aficionado
Join Date: Nov 2006
Posts: 40

Re: Question on Firecalc Monte Carlo
Thanks for the reply Dory, I can now stop wondering why it doesn't agree with my "bruteforce" excel method, in which I run 8000 iterations per year. I did find that Firecalc results were significantly worse than my method and it had me quite concerned.
I still don't understand what FC is doing though, can you give me a little more detail on how it generates its series ?



Re: Question on Firecalc Monte Carlo
11232006, 10:00 AM

#4

Dryer sheet aficionado
Join Date: Nov 2006
Posts: 40

Re: Question on Firecalc Monte Carlo
I also think that I have found a problem with the MC calculator.
If you put in a $1mm starting portfolio and take out 25000 per year for 40 years , with a 3.1% return and 3.1% inflation, with zero volatility, then you should end up with 0 in the portfolio at the end, this being a zero real return. In this case, FC returns 63,361, which I think is a significant difference from the expected 0.



Re: Question on Firecalc Monte Carlo
11232006, 12:17 PM

#5

EarlyRetirement.org Founder Developer of FIRECalc
Join Date: Jun 2002
Posts: 1,840

Re: Question on Firecalc Monte Carlo
See How about describing FIRECalc step by step? at http://firecalc.com/intro.php.
The effect you are seeing is because the money you withdrew on Jan 1, enough to get you through the year with enough to cover inflation for the year as well, does not contribute to the growth of the portfolio for that year. It is cash under your mattress.
If you were to pay all your expenses using a zerointerest credit card that you then paid off at the end of each year AFTER the portfolio growth had occurred, then your numbers would match up.
__________________
Often uninformed, seldom undecided.
Twenty years from now you will be more disappointed by the things you didn't do than by the ones you did do. So throw off the bowlines. Sail away from the safe harbor. Catch the trade winds in your sails. Explore. Dream. Discover. Mark Twain



Re: Question on Firecalc Monte Carlo
11232006, 01:50 PM

#6

Dryer sheet aficionado
Join Date: Nov 2006
Posts: 40

Re: Question on Firecalc Monte Carlo
I must disagree with you here Dory, in a zero real return environment with investment certainty (zero vol), then your annual wd's are simply principal divided by years.
In a world with no inflation and no return, it seems quite clear that we should be entitled 40 separate payments of 25000 per year in the example I gave you.
Thank you for your prompt replies and I will read the link you gave me.



Re: Question on Firecalc Monte Carlo
11232006, 02:31 PM

#7

Dryer sheet aficionado
Join Date: Nov 2006
Posts: 40

Re: Question on Firecalc Monte Carlo
I also found a pretty good Monte Carlo tool here :
http://www.effisols.com/
Unfortunately, the trial version is fairly worthless and the one that works costs $29, but I think it's worth it, it's a very nice tool.



Re: Question on Firecalc Monte Carlo
11232006, 03:00 PM

#8

Give me a museum and I'll fill it. (Picasso) Give me a forum ...
Join Date: Jun 2002
Location: Texas: No Country for Old Men
Posts: 49,725

Re: Question on Firecalc Monte Carlo
macnjus, you might want to use the search button to take a look at some of the threads discussing how FIRECalc differs from traditional Monte Carlo tools. Note that Monte Carlo calculations largely ignore the correlation between asset classes, something many of us think is important. Here is one sample thread:
http://earlyretirement.org/forums/i...6395#msg166395
__________________
Numbers is hard



Re: Question on Firecalc Monte Carlo
11232006, 03:20 PM

#9

Dryer sheet aficionado
Join Date: Nov 2006
Posts: 40

Re: Question on Firecalc Monte Carlo
Thanks Wahoo. When I run my MC, I first put together a variance/covariance matrix to take correlations and volatilities of the various assets into account, using this, I generate an overall portfolio expected return and volatility and run the MC using these overall numbers. I agree that the correlations between asset classes are crucial and you shouldnt use MC without taking them into account.



Re: Question on Firecalc Monte Carlo
11232006, 04:54 PM

#10

Moderator Emeritus
Join Date: Dec 2002
Location: Oahu
Posts: 26,846

Re: Question on Firecalc Monte Carlo
Quote:
Originally Posted by macnjus
I first put together a variance/covariance matrix to take correlations and volatilities of the various assets into account, using this, I generate an overall portfolio expected return and volatility

How do you model correlations that change over the decades and volatility that rises/falls in magnitude?
__________________
*
Coauthor (with my daughter) of “Raising Your MoneySavvy Family For Next Generation Financial Independence.”
Author of the book written on ER.org: "The Military Guide to Financial Independence and Retirement."
I don't spend much time here— please send a PM.



Re: Question on Firecalc Monte Carlo
11232006, 07:14 PM

#11

Dryer sheet aficionado
Join Date: Nov 2006
Posts: 40

Re: Question on Firecalc Monte Carlo
That obviously gets a lot more complicated, I simply assume constant correlation and vol, which certainly will not be the case. But we also know for certain that the future will not be like the past, so I think it helps a lot to look at both.
When you get to 100% success on the historicals, then I think it helps to look at some MC's to model situations where the returns are not like the past. For example, My "conservative" assumption right now is that stocks are priced to return in the 6.5% zone, which is well under historicals. I think historicals are overstating the likelihood of portfolio survival.



Re: Question on Firecalc Monte Carlo
11232006, 07:20 PM

#12

Give me a museum and I'll fill it. (Picasso) Give me a forum ...
Join Date: Jun 2002
Location: Texas: No Country for Old Men
Posts: 49,725

Re: Question on Firecalc Monte Carlo
Quote:
Originally Posted by macnjus
I think historicals are overstating the likelihood of portfolio survival.

Why?
__________________
Numbers is hard



Re: Question on Firecalc Monte Carlo
11232006, 07:29 PM

#13

Dryer sheet aficionado
Join Date: Nov 2006
Posts: 40

Re: Question on Firecalc Monte Carlo
Many many reasons why. For example, the existence of this board is one indication that many more people are aware of the power of investing in the stock market; I believe that the demand for stocks has gone up relative to the supply. Any time you increase demand in a market without increaing supply, the price goes up, and all else equal, when the price goes up the expected return goes down. John Hussman runs an interesting mutual fund and has posted some very good research on this topic on his website at this address :
www.hussman.net



Re: Question on Firecalc Monte Carlo
11242006, 03:28 AM

#14

EarlyRetirement.org Founder Developer of FIRECalc
Join Date: Jun 2002
Posts: 1,840

Re: Question on Firecalc Monte Carlo
Quote:
Originally Posted by macnjus
I must disagree with you here Dory, in a zero real return environment with investment certainty (zero vol), then your annual wd's are simply principal divided by years.
In a world with no inflation and no return, it seems quite clear that we should be entitled 40 separate payments of 25000 per year in the example I gave you.
Thank you for your prompt replies and I will read the link you gave me.

You missed my point.
In the FIRECalc methodology, you take the withdrawal on Jan 1, and calculate returns on 12/31. The withdrawal you take has the inflation in it.
So year 1 has growth based on 975000, not 1 million.
The withdrawal includes the inflation for the year though, as described in the link I gave you.
So in a 40 year model in FIRECalc, you have inflation on 40 withdrawals, but the growth is based on a starting point of 39/40 of your starting amount.
__________________
Often uninformed, seldom undecided.
Twenty years from now you will be more disappointed by the things you didn't do than by the ones you did do. So throw off the bowlines. Sail away from the safe harbor. Catch the trade winds in your sails. Explore. Dream. Discover. Mark Twain



Re: Question on Firecalc Monte Carlo
11242006, 06:15 AM

#15

Dryer sheet aficionado
Join Date: Nov 2006
Posts: 40

Re: Question on Firecalc Monte Carlo
That makes sense, it's a timing issue. For example, a contiinuous withdrawal of the inflated amount each day over the course of the year would balance out.



Re: Question on Firecalc Monte Carlo
11242006, 11:17 AM

#16

Moderator Emeritus
Join Date: Dec 2002
Location: Oahu
Posts: 26,846

Re: Question on Firecalc Monte Carlo
Quote:
Originally Posted by macnjus
That makes sense, it's a timing issue.

Dory'll be glad to know that...
__________________
*
Coauthor (with my daughter) of “Raising Your MoneySavvy Family For Next Generation Financial Independence.”
Author of the book written on ER.org: "The Military Guide to Financial Independence and Retirement."
I don't spend much time here— please send a PM.




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


Thread Tools 
Search this Thread 


Display Modes 
Linear Mode

Posting Rules

You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts
HTML code is Off




» Recent Threads













» Quick Links


