Join Early Retirement Today
Reply
 
Thread Tools Search this Thread Display Modes
Spreadsheet to ease SWR calculations using Guytons Decision Rules
Old 08-24-2007, 04:59 PM   #1
Thinks s/he gets paid by the post
walkinwood's Avatar
 
Join Date: Jul 2006
Location: Denver
Posts: 2,676
Spreadsheet to ease SWR calculations using Guytons Decision Rules

I liked the approach taken by Guyton and Klinger in this paper, though I don't feel comfortable with the high initial SWR that they propose in later tables.
FPA Journal - Decision Rules and Maximum Initial Withdrawal Rates

I put together a spreadsheet (attached) to make it easier to determine the annual withdrawal using only the previous year's inflation, and value of portfolio at the beginning of the current year.

There is one assumptions made. a)The Capital Preservation Rule & the Prosperity Rule would not apply at the same time. Also, the Inflation Rule is used even though the paper seems to drop it in later calculations.

The spreadsheet has some example portfolio values to force the Capital Preservation Rule and the Prosperity Rule to come into play. It shows how your annual withdrawal as a percentage of portfolio self-corrects as your portfolio value goes up and down.

I would like your input on the spreadsheet. Is it correct? Useful? Suggestions to improve?
Attached Files
File Type: zip Decision Rules SWR.zip (5.1 KB, 239 views)
__________________

__________________
walkinwood 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 08-24-2007, 06:26 PM   #2
Recycles dryer sheets
 
Join Date: Aug 2007
Location: Midwest
Posts: 109
Haven't had a chance to look at the spreadsheet yet. But reading the article you linked, I read the following:

Quote:
In Guyton's original article, he increased the time frame to 40 years, citing increasing life expectancies.
Fair enough, depending on your age of retirement. Then it goes on to say:
Quote:
He introduced three decision rules ....... These decision rules were systematically applied throughout a retirement distribution period beginning in 1973,
If you notice the parts I've emphasized by underlining, I'm wondering how this works out. Did Guyton invent a time machine? Does he have data through 2013? More importantly, is the future data provided? I'll be sure to look for it in the spreadsheet.
__________________

__________________
Engineering My Finances Blog
EngineeringMyFinances is offline   Reply With Quote
Old 08-24-2007, 07:03 PM   #3
Dryer sheet wannabe
 
Join Date: Jun 2002
Posts: 21
Walkinwood- Thank you. This is a nice piece of work. I have been giving serious thought to using Guytons Decision Rules and this will be very helpful.
__________________
stevelb is offline   Reply With Quote
Old 08-24-2007, 07:19 PM   #4
Thinks s/he gets paid by the post
ronin's Avatar
 
Join Date: Oct 2003
Posts: 1,190
I compared the Guyton rules to the method used here using an excel spreadsheet: http://www.analyzenow.com/ and found this method to be superior. I also added the Guyton rules to the analyzenow method but didn't find the increased complexity to be worth it.
__________________
We are, as I have said, one equation short. Keynes
ronin is online now   Reply With Quote
Old 08-24-2007, 08:15 PM   #5
Dryer sheet wannabe
 
Join Date: Jun 2002
Posts: 21
ronin - Which method is superior? The Dynamic Pro at www.analyzenow or Walkinwood's spread sheet using the Guyton rules? Not really too familar with the Dynamic Pro - yet.
__________________
stevelb is offline   Reply With Quote
Old 08-24-2007, 08:32 PM   #6
Thinks s/he gets paid by the post
walkinwood's Avatar
 
Join Date: Jul 2006
Location: Denver
Posts: 2,676
Engineering,

Guyton's original study (same journal, oct 2004) used the 'perfect storm' you cite. The original study only used a single 30 year worst case period and extended this to 40 years by
"... assuming a conservative average annual return of three percent above inflation from 2004–2012"

This study shows the results based on monte-carlo simulations.

Ronin,
Thanks for the link.
__________________
walkinwood is offline   Reply With Quote
Re: Guyton withdrawal decision rules
Old 08-24-2007, 11:43 PM   #7
Dryer sheet wannabe
 
Join Date: Sep 2006
Posts: 20
Re: Guyton withdrawal decision rules

A while back I created a Monte Carlo based retirement planner that implements withdrawal decision rules similar to Guyton's.

It's available online for free at: http://www.flexibleRetirementPlanner.com

I tried to document everything and have built up a pretty good FAQ which is up on the site. Please don't hesitate to ask questions if anything doesn't make sense.

Regards,

Jim
__________________
FRPGuy is offline   Reply With Quote
Old 08-25-2007, 10:28 AM   #8
Thinks s/he gets paid by the post
ronin's Avatar
 
Join Date: Oct 2003
Posts: 1,190
Quote:
Originally Posted by stevelb View Post
ronin - Which method is superior? The Dynamic Pro at www.analyzenow or Walkinwood's spread sheet using the Guyton rules? Not really too familar with the Dynamic Pro - yet.
Sorry I wasn't clear. Actually I think most of my work and reference material is on my work computer, so I was going from memory. I will be back in the office at the end of next week and I can look at the specifics and give better links then. I think Hebeler's hybrid method was preferable to me but it depended on what exactly you were after. I think it was discussed previously in this thread: endowment method of retirement spending
__________________

__________________
We are, as I have said, one equation short. Keynes
ronin is online now   Reply With Quote
Reply


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
A Decision Analysis approach to SWR choices Rich_by_the_Bay FIRE and Money 27 03-09-2006 09:18 AM
SWR, terminal values, TIPS, I-bnds & comm paper sgeeeee FIRE and Money 144 02-25-2004 04:35 PM

 

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