Join Early Retirement Today
Thread Tools Search this Thread Display Modes
Percentage of Remaining Portfolio- Spending Models
Old 02-03-2014, 08:03 PM   #1
Recycles dryer sheets
Join Date: Feb 2010
Posts: 375
Percentage of Remaining Portfolio- Spending Models


I would like to know if there is a way that I could see how low my safe withdrawal rate would be in the worst case scenarios of the Percentage of Remaining Portfolio spending plan. I know that there is the line graph, but it is difficult for me to see exactly how low my safe withdrawal rate could be and the likelihood of having that lowest safe withdrawal rate.


nico08 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!

Old 02-05-2014, 09:27 AM   #2
Recycles dryer sheets
Join Date: Jun 2002
Posts: 373
Set your annual withdrawal to $0, but add 4% (or whatever annual % you want to model) to the portfolio annual expense ratio.

You can also model combinations of the two to look at variable & fixed SWR's.

PS: credit for this technique belongs to SGeeeee

Cb is offline   Reply With Quote
Old 02-05-2014, 10:33 AM   #3
Thinks s/he gets paid by the post
Join Date: Jul 2005
Posts: 3,801
FIRECalc does have a built-in percent of portfolio withdrawal option, including a setting for a minimum percentage of last year's withdrawal (such as for the 95% rule).

Set the withdrawal amount for the first year as normal. This sets the percentage amount that will be taken each year. Then click on the Spending Models tab and select Percentage of Remaining Portfolio. Within this selection you can also select a percentage of last year's withdrawal as a floor.

The results page gives the lowest portfolio amount throughout retirement:

"Here is how your portfolio would have fared in each of the 113 cycles. The lowest and highest portfolio balance throughout your retirement was $471,381 to $2,098,686, with an average of $1,118,338. (Note: values are in terms of the dollars as of the beginning of the retirement period for each cycle.) "

More relevant to the OP, the Investigate tab has a box you can check to generate an Excel spreadsheet for any one scenario starting on 1960 or after.

Display the results of the retirement plan

The success rate of your portfolio and withdrawal plans, and optionally provide data and formulas in a spreadsheet format, using as the starting retirement year in the spreadsheet showing a full retirement cycle (must be on or after the first year data were available, and early enough to show a full cycle). Note: Spreadsheets are not formatted; they are for verifying numbers and calculations only. For 30 year terms only."

A lot of work, but you can get an exact number for your portfolio minimum during retirement for any scenario starting in 1960 or beyond.

Note that there is not really a "safe withdrawal rate" when using a fixed portfolio percentage withdrawal. You will never run out of money. Your key concerns are the smallest withdrawal made during retirement and the size of the portfolio, which are of course directly related. If the lowest portfolio value times your withdrawal percentage gives you a withdrawal that will meet or exceed your non-discretionary expenses you are in the "safe" zone. Of course many here would add a safety margin to that.
Animorph is offline   Reply With Quote
Old 02-05-2014, 12:25 PM   #4
Give me a museum and I'll fill it. (Picasso)
Give me a forum ...
Midpack's Avatar
Join Date: Jan 2008
Location: Chicagoland
Posts: 10,662
Originally Posted by Animorph View Post
Note that there is not really a "safe withdrawal rate" when using a fixed portfolio percentage withdrawal. You will never run out of money.
+1, that's why I didn't reply the first time I read the first post, wasn't entirely sure what the OP was really asking.
No one agrees with other people's opinions; they merely agree with their own opinions -- expressed by somebody else. Sydney Tremayne
Retired Jun 2011 at age 57

Target AA: 60% equity funds / 35% bond funds / 5% cash
Target WR: Approx 2.5% Approx 20% SI (secure income, SS only)
Midpack is online now   Reply With Quote
Old 02-20-2014, 11:01 AM   #5
Confused about dryer sheets
Join Date: Feb 2014
Location: Fairport NY
Posts: 1
I was looking at the safe withdrawal rate models, and like nico08 wanted to look at some of the data instead of just the graphs. Using the option to download the data into Excel as suggested by Animorph lets me look at the data, but there are some problems with it (or with me) and things don't make sense:

1. The 1960 data in column C, "Infl Adj Withdrawals", is identical if the spending model has been set to "Constant Spending Power" or to "Percentage of Remaining Portfolio". The Excel formulas in the bottom half of the spreadsheet show that the correct spending model rules are not being used for this column.

2. In disagreement with the note in the spreadsheet at A36, the 1960 data for a "Percentage of Remaining Portfolio" spending model in the top half of the spreadsheet (calculated by FIREcalc) does not match the data in the bottom half (calculated by Excel).

Assuming that the problem is in the downloaded spreadsheet (or my understanding of it) and not in the results calculated in FIREcalc, I created new columns for withdrawals and inflation adjusted withdrawals by subtracting the "Starting Portfolio" data form the previous year "Ending Portfolio". This looked like what I wanted; the 1960 period had some ups and downs. More added columns for the new withdrawal data as a percent of total and as a percent of previous year showed most years sitting at 4.5% as desired except a few like 1975 (1974 was a down year)where the 95% rule kicked in and made the withdrawal larger than 4.5%.

Bottom line, the FIREcalc computed data looks ok to me, but some of the downloadable spreadsheet data does not. And 1960 was a tough year to retire...
Tupper is offline   Reply With Quote

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
Question about FIRECalc spending models howdidigetthisold FIRECalc support 0 03-19-2013 09:11 AM
In FIRECalc, why does CSP provide better result than % of Remaining Portfolio Model? nico08 FIRE and Money 0 10-26-2011 11:35 AM
Dumb "spending models" tab question gsmolin FIRECalc support 8 10-18-2011 08:53 AM
2 Different Spending Models but Same Result...What Up? pinot FIRECalc support 8 06-03-2010 08:23 AM
% of Remaining Portfolio Spending Model Issue ProspectiveBum FIRECalc support 0 01-22-2008 01:52 PM


All times are GMT -6. The time now is 12:31 PM.
Powered by vBulletin® Version 3.8.8 Beta 1
Copyright ©2000 - 2016, vBulletin Solutions, Inc.