Join Early Retirement Today
Thread Tools Search this Thread Display Modes
Personal FIREcalc
Old 03-13-2007, 06:43 PM   #1
Dryer sheet wannabe
Join Date: Mar 2007
Posts: 13
Personal FIREcalc

I have been following RE for at least 10 years as I have been working my way to that goal. I have a DORY excel model from 1998, that I have taken apart and put back together with some changes.

I wanted to explore a highly variable withdraw rate. First, I added the last 9 years of financial data to the model from DORY, but for simplicity sake, I dropped all Fixed Income and focused on a 100% SP500 portfolio.

Next, I added the following rules:

I can configure the withdraw rate based on the Market Return - Inflation (the real return) to take a minimum withdraw in bad years and a large withdraw in good.

Second, I have configurations so the withdraw rate will vary through retirement - start low the first couple of years to adjust to retirement, middle very high, end moderately low - or any other strategy one wants to explore.

Third, I added a configurable rule that forces a minimum withdraw even in a good market if the portfolio value is a specific percent (inflation adjusted) below where it started. This really helped prevent failures in 1929, 1966, etc.

Forth, if the portfolio gets more than a specified percent (again inflation adjusted) above the starting portfolio value (maybe 50%), the withdraw rate is increased by 3% (or whatever value you want it to be).

I'm still working on this model and convincing myself it is accurate, but the initial results are very interesting.

For a 40 year cycle, 100% survivable, the worst starting year 1902, had an average withdraw rate of 3.65%. Only 3 cycles were below 4.0% average withdraw rate. But the average year was 6.3% and the best year was 8.5%.

Has anyone else experimented with highly variable FIREcalc?
rigel 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 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!


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

Advanced Search
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

Similar Threads
Thread Thread Starter Forum Replies Last Post
Firecalc slays a strawman, deceives many hankjoy FIRE and Money 46 11-30-2010 04:14 PM
Handling pensions and SS in Firecalc SecondCor521 FIRE and Money 5 04-19-2007 12:21 PM
FIRECalc data dumps or saved runs for referencing during posts? Nords FIRECalc support 6 01-25-2007 07:09 AM
dory36: old vs. new firecalc results? halo FIRECalc support 31 05-29-2006 10:31 PM

» Quick Links

All times are GMT -6. The time now is 04:38 AM.
Powered by vBulletin® Version 3.8.8 Beta 1
Copyright ©2000 - 2020, vBulletin Solutions, Inc.