Fire Calculator 40 year observation

Trawler

Recycles dryer sheets
Joined
Aug 31, 2009
Messages
262
Location
westerville
As I go thru the use all calculator stage found this information interesting from Fireclac.
Outside of retiring in 1929 one sure would have a bunch at the end.
Would love to see one of these except 1929 repeat it self.

Input
$1,400,000 Mixed Portfolio $60K annual spend all other defulted to fire calc presets No other income
18 times portfolio worth less $1.4m after 1st year.
of those 10 recovered in 2nd year of retirement
of those 2 recovered in 3rd year
of retirementof those 1 recovered in 4th year of retirement
of those 2 recovered in 5th year of retirement
of those 1 recovered in 9th year of retirement
of those 1 recovered in 16th year of retirement
of those 1 Never recovered 1929 retiement.
20 x Porfolio was worth more than $1.4m after year 1
only 5 of these were ever worth less than $1.4M over the 40 year period.
of those 5 all recovered to more than $1.4M
2 recovered in the next year
1 recovered in year 6 after the slip below 1.4M
1 recovered in year 16 after slipping below $1.4m
No Portfolio in this category went below 1.4M after 18 years

Outside of 1929 ending Portfolio value was between $7.5M and $109M
 

Attachments

  • CVT1A (version 1).xls
    39 KB · Views: 15
Last edited:
It is interesting to see that the Mixed Portfolio has 1 failure in this time frame (1929, as pointed out by the OP), while the 75/25 has 26 failures.

I'd be hard pressed to dump money into long term bonds at this point though.

-ERD50
 
It is interesting to see that the Mixed Portfolio has 1 failure in this time frame (1929, as pointed out by the OP), while the 75/25 has 26 failures.

I'd be hard pressed to dump money into long term bonds at this point though.

-ERD50

What is the Asset allocation of the mixed portfolio?
 
Just to state the obvious...

For longer time frames, there far fewer independent data time frames available. Therefore, the quality of the results you project are quite a bit less reliable than for shorter spans. In other words, the variance of the results is expected to be significantly higher.

Perhaps therefore, You should take these results as entertainment rather than on how things will turn out.

Your mileage may vary
 
Last edited:
Just to state the obvious...

For longer time frames, there far fewer independent data time frames available. Therefore, the quality of the results you project are quite a bit less reliable than for shorter spans. In other words, the variance of the results is expected to be significantly higher.

Perhaps therefore, You should take these results as entertainment rather than on how things will turn out.

Your mileage may vary
From FIRECALC FWIW...
FIRECalc looked at the 101 possible 40 year periods in the available data...
versus 111 for a 30 year run. Variance in results significantly higher?
 
From FIRECALC FWIW...versus 111 for a 30 year run. Variance in results significantly higher?

FireCalc makes 101 periods out of the available data. However the periods are not independent. They are quite well correlated. That's true also for the 30-year periods but less so.
 
I ran mine for a 40-year period and had the following results:

1. the 80/20 total market (bonds in 30-year treasuries) had 17 failures (83.2%)

2. Mixed portfolio #1 (60/40 - 5% SM VALUE, 40% S&P 500, 15% LG VALUE, 35% LT TREASURY, 5% ST TREASURY) had 3 failures

3. Mixed portfolio #2 (70/30 - 5% SM VALUE, 40% S&P 500, 25% LG VALUE, 25% LT TREASURY, 5% ST TREASURY) had 1 failure

4. Mixed portfolio #3 (80/20 - 10% SM VALUE, 45% S&P 500, 25% LG VALUE, 15% LT TREASURY, 5% ST TREASURY) had 0 failures
 
All,
To confirm I did use the Fire Calc's defualt mixed portfolio when I ran the original spreadsheet.

I am waiting for rates to go up to square up our Bond allocation. Currently around 5% bonds with 20% cash set aside for bond purchases. 75% equities thru a mix mutual funds.

I do enjoy market history study as entertainment as well as some tool to try and predict future outcomes because many time the market does repeat itself but may not always. Only thing for sure is it will go up and down.
Most calculators are telling me to we are FI now.

It will not be long before taking the Leap into ER.

Wife is nurse and looking at some seasonal postions that will make HC available with my PE conditions.

Thanks all
 
Back
Top Bottom