FIRECalc rewrite

[twaddle]

How about either:

1) Open Source FC so we can come up with our own tweaks.

or

2) Add a simple scripting language so we can play with our own withdrawal strategies, market timing variable allocation strategies, success criteria, and report generation.

[Rich_in_Tampa]

Here's the article I mentioned above - it's about drawing down your bonds first in the decumulation phase.

[ERD50]

Quote:

Originally Posted by Rich_in_Tampa Here's the article I mentioned above - it's about drawing down your bonds first in the decumulation phase.

Rich, if I read that right, the results should not be surprising at all. It looks like he is using a totally static model. He just assumes stocks return the same higher real rates than do bonds. Same numbers every year.

In that case, sure it makes sense to spend down the bonds first. You want to give the highest return investment the longest amount of time to grow (other things being equal).

So it would be interesting to see what would happen with the data set in FireCalc.

-ERD50

[Rich_in_Tampa]

Quote:

Originally Posted by ERD50 Rich, if I read that right, the results should not be surprising at all. It looks like he is using a totally static model. He just assumes stocks return the same higher real rates than do bonds. Same numbers every year. In that case, sure it makes sense to spend down the bonds first. You want to give the highest return investment the longest amount of time to grow (other things being equal). So it would be interesting to see what would happen with the data set in FireCalc.

Yup. Don't want to ambush Dory's thread, but I agree. However, for this to work, the asset types need to be held long enough to allow smoothing of volatility so, for example, 2 years of bond burn, then all stocks forever would not be as likely to survive as 7 or 10 or 15 years of fixed before tapping the stocks.

Boy would that be awesome to have within FC. Unfortunately, after bonds are burned you have additional choices: just start digging into stocks forever, or immediately convernt $xxx of stocks into bonds to start burning again (buckets of money approach).

[tightasadrum]

Along the same lines as Rich mentioned, how about,

1. more lines for reduced withdrawal in income page.

I have several investments in real estate. Unless I group then together as if I'm selling it all, I don't have needed flexibility. How complex does adding several more lines make the program? Four or five more lines would helpful.

2. The "how invested" page is ackward to me. How about putting down a table of all major catagories with input for % allocation. I'd like to see a catagory for REITS and commodity futures as well. Are TIPS on there now? Can't remember, but probably are.

[jIMOh]

here's some ideas

1) allow entering of current ages, ER age, regular retirement age and late retirement age within one running of it, giving probale successes for each age range.

1a) alow different entries for spouses. me age X, ER age of X+20, R age of X+30, LR age of X+40. Wife aged Y, ER age of Y+7, R age of Y+10, R age of Y+13.

2) allow a person to enter account types (Roth, 401k, taxable accounts) and tax rates for each account (based on current tax tables). Give an advanced option which can calculate RMD's and compare to income needed.

2a) allow different entries for spouse (2 roth lines, 2 401k lines etc...)

3) allow Firecalc to remember me, so I don't have to enter all info when I go to it. I ran it once around 6 months ago... in a year or so, when I hit some type of milestone or lump sum, I'd like to rerun it, but just update the initial assumptions I entered.

3a) allow to remember spouse info

4) allow firecalc to use yearly returns BACKWARDS (so 2007 return, then 2006, then 2005, then 2004, then 2003) to test strategy using various other market conditions. I have done reading which suggest if the 2000-2002 bear came earlier in retirement, it takes most SWR and ratches them down a notch. Allow user to see what this does.

4a) give the user the ability to put a "bear market" the first X years of retirement which have an overall return of -y% and see what this does to overall success rates.

[Rustic23]

I never figured out how to do this in the present FireCalc, so it may be possible, but how about the death of a spouse? Pension check goes down by 40%, SS by a third. Would be helpful to be able t what if different dates in the future.

[Lusitan]

Thanks for all your work on FireCalc, Dory - it's a great tool to play with when tinkering with FIRE plans.

Others have made great suggestions, far more substantial than mine, but here's one thing that I think should be changed:

FIRECalc asks for your current portfolio value (X) and then it allows you to input (Y) additional savings per year until your retirement year ZZZZ.

When viewing results, FIRECalc always starts out by saying "Your plan is to spend $, which is W% of your starting portfolio ..."

But for the percentage, it calculates the percentage based on your CURRENT portfolio, not your portfolio upon reaching ER (which is the important one). This makes for some eye-popping "withdrawal rates" that really are out of place. The end result calculations are fine, but this withdrawal rate thing really sticks out.

Who cares what percentage of my current portfolio I will be withdrawling starting in 2020 when I retire ... what's important is what percentage of my 2020 portfolio I'll be withdrawling when I retire in 2020.

Thanks for taking a look at this and other changes!

[lsbcal]

Another thought for the summary page. I use advanced FIRECalc and request the spreadsheet summary. Then I use the Excel functions to get the average, stddev, and min for the portfolio. I am particularly interested in the min (maximum drawdown) on the portfolio because I know I won't have the guts to live with an excessive drawdown. Also I want to know the year the max drawdown occurs to see if it's at the end of the test period or somewhere in the middle.

Currently the a historgram is showing the portfolio end value is shown. To complement this, it would be nice to see a histogram of the (worst) drawdowns for each starting retirement sequence.

As an alternative a few values could be produced:
average worst case drawdown =
(this is the average of the minimums for each sequence)
worst drawdown =
year of worst drawdown =

Les

[dory36]

Lots of excellent suggestions. Keep 'em coming. The "feature freeze" will probably be in about 2-3 weeks, when I move back onto the boat for a while.

To get a notice when there is a test version to play with, sign up for the mail list at http://firecalc.com/newfc.php.

dory36

[dory36]

An idea ... please give me some feedback.

The problem: long term retirements, say 50 years, miss the problem years of the mid 1960s, since there are no 50 year data sets that start with the rough years of the mid 1960s. (100 year retirements, if you believe in extreme life extension possbilities, miss the Great Depression.)

The hypothesis: Failures occur when there are down years in the early part of the retirement cycle. If the early years are OK or better, no problem. That is anecdotal, but I think the data will support it. So, we can predict the long term outcome based on the first ~5 years. If this hypothesis is correct, we can include data all the way up to 2002 for prediction of retirement plan success of unlimited retirement terms.

Thoughts? It makes me wish I had been storing all the gazillion runs, so I would have a large body of data for analysis. Statisticians... how can I come up with a rule, such as "If the 5th year portfolio balance is below 63.3% of the starting balance, then ..."?

Whatever year seems most valid (the earlier the better), I need to develop a mapping of Nth year ratio to later year outcomes.

dory36

[ERD50]

Quote:

Originally Posted by dory36 An idea ... please give me some feedback. The problem: long term retirements, say 50 years, miss the problem years of the mid 1960s, Whatever year seems most valid (the earlier the better), I need to develop a mapping of Nth year ratio to later year outcomes. dory36

Glad you are going to try to tackle this. I'm not sure there is any good answer. But, a suggestion:

Maybe this would take too many calculations, but what if you wrapped around and just kept tacking on the 'extra' years from the start of the data up to where you start to overlap.

Example: 50 year run cannot currently utilize data past 1956 to get a full 50 years. So do the normal runs, then when you run from 1957 to 2006, use each year from 1871 to 1956 tacked on to complete the data set. Then run 1958 to 2006, and tack on two year periods from 1871 to 1958, etc, etc, etc.

Too much computer time?

Off hand, that seems like a very negative way to look at it, you could have two of the worst sequences to deal with in those 50 years. But, let's see... 1974, 1929 - just 45 years apart! Maybe two disasters should be 'expected' over a 50 year period?

That's a grim thought to end a holiday on!

-ERD50

[twaddle]

Quote:

Originally Posted by dory36 The problem: long term retirements, say 50 years, miss the problem years of the mid 1960s, since there are no 50 year data sets that start with the rough years of the mid 1960s. (100 year retirements, if you believe in extreme life extension possbilities, miss the Great Depression.) The hypothesis: Failures occur when there are down years in the early part of the retirement cycle. If the early years are OK or better, no problem. That is anecdotal, but I think the data will support it. So, we can predict the long term outcome based on the first ~5 years. If this hypothesis is correct, we can include data all the way up to 2002 for prediction of retirement plan success of unlimited retirement terms.

Predictions of success? Correlation between the start of the sequence and failure? Err, sounds like a slipery slope to me. Definitely not in the spirit of the old FIREcalc.

But it would be an interesting alternative to FIREcalc. My guess is that the new FIREcalc would conclude that anybody who retired in the year 2000 would be doomed to failure (i.e., negative real returns at the end of 5 years).

[Cb]

Quote:

Originally Posted by dory36 Lots of excellent suggestions. Keep 'em coming. The "feature freeze" will probably be in about 2-3 weeks, when I move back onto the boat for a while. To get a notice when there is a test version to play with, sign up for the mail list at http://firecalc.com/newfc.php. dory36

That link doesn't work for me.

Cb

[ERD50]

Quote:

Originally Posted by Cb That link doesn't work for me. Cb

it is not formatted correctly,

just paste this into a new window and it went through for me:

firecalc.com/newfc.php

or try one of these:

FIRECalc

corrected version of link

-ERD50

[halo]

Dory

Re: the upcoming new Firecalc:

On the Options Page, where it asks "What Year Will You Retire?" is it possible to add the option to answer a different question instead, namely "What Year DID You Retire?"

This way you could run Firecalc to make sure your retirement is on track if you've already exited the work force.

Can this be done?

Thanks!

[SecondCor521]

Quote:

Originally Posted by halo Dory Re: the upcoming new Firecalc: On the Options Page, where it asks "What Year Will You Retire?" is it possible to add the option to answer a different question instead, namely "What Year DID You Retire?" This way you could run Firecalc to make sure your retirement is on track if you've already exited the work force. Can this be done? Thanks!

halo,

You can just put your current data in and it will tell you if you're on track. Just pretend like you're a new retiree...your money doesn't know any differently.

2Cor521

[Jimmyrd]

Hi,
First thank you so much for Firecalc. I recently found it after reading Scott Burns recent column in the WSJ Sunday pages.
I am not very proficient yet with use of Firecalc but would make a suggestion or two.
1. SS for self and spouse is included in FC. I would like to see a place to enter defined pension plan(s). They should include a provision for inflation , or not, depending on the type of plan. (and one for spouse too).
2. An easy way to print results for study would be very helpful.
Again, thank you.

Jimmy

[REWahoo]

Quote:

Originally Posted by Jimmyrd ... I would like to see a place to enter defined pension plan(s). They should include a provision for inflation , or not, depending on the type of plan. (and one for spouse too).

Jimmy, the Advanced FIRECalc version has a provision for multiple pensions.

Look on the "How Much Will You Spend" tab at the three "Increase/Decrease withdrawals by" options near the bottom of the page. For a pension, you would click the "decrease withdrawals by" button, put in the amount of pension, the year it starts, then check the box if it is adjusted for inflation.

[Ziggy]

If one could have more options for downloading spreadsheets with the formulas and factors, that would be very useful. For instance, could you allow one to start in any year (not just 1960) and to go for more years (i.e.: up to 40 vs 30 now)?

Want to say, though, this is wonderful work you are doing. it is impressive and it is much appreciated! Thanks, Ziggy