|
12-06-2007, 01:14 PM
|
#1
|
Give me a museum and I'll fill it. (Picasso) Give me a forum ...
Join Date: Jun 2006
Location: Boise
Posts: 7,866
|
Sensitivity analysis
Hi all,
I alluded to this in my other thread.
How many of you have done a sensitivity analysis on your retirement spreadsheet? What variables did you change? What did you learn? Did you change anything as a result?
2Cor521
__________________
"At times the world can seem an unfriendly and sinister place, but believe us when we say there is much more good in it than bad. All you have to do is look hard enough, and what might seem to be a series of unfortunate events, may in fact be the first steps of a journey." Violet Baudelaire.
|
|
|
|
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!
|
12-06-2007, 01:35 PM
|
#2
|
Moderator Emeritus
Join Date: Feb 2006
Location: San Francisco
Posts: 8,827
|
Quote:
Originally Posted by SecondCor521
How many of you have done a sensitivity analysis on your retirement spreadsheet? What variables did you change? What did you learn? Did you change anything as a result?
|
Not rigorously, but I've done it. Pretty much the items Dory looks at: size of nestegg, year of retirement, expenses. I haven't bothered with inflation or returns.
I didn't find it helpful - felt like splitting hairs. I think many of us over-analyze and over-quantify the planning piece. I've still found nothing much better than the old "25 x expenses" rule.
Once you are convinced your plan is at least sane, the real FIRE-busters are black swans. Common sense and flexibility reign.
__________________
Rich
San Francisco Area
ESR'd March 2010. FIRE'd January 2011.
As if you didn't know..If the above message contains medical content, it's NOT intended as advice, and may not be accurate, applicable or sufficient. Don't rely on it for any purpose. Consult your own doctor for all medical advice.
|
|
|
12-06-2007, 01:51 PM
|
#3
|
Give me a museum and I'll fill it. (Picasso) Give me a forum ...
Join Date: Jun 2006
Location: Boise
Posts: 7,866
|
Ahh...I should be more explicit. I'm doing sensitivity analysis on my "how soon can I retire?" spreadsheet, not on the after retirement part. I'm pretty much sold on the 4% rule plus your common sense and flexibility.
2Cor521
__________________
"At times the world can seem an unfriendly and sinister place, but believe us when we say there is much more good in it than bad. All you have to do is look hard enough, and what might seem to be a series of unfortunate events, may in fact be the first steps of a journey." Violet Baudelaire.
|
|
|
12-06-2007, 01:53 PM
|
#4
|
Give me a museum and I'll fill it. (Picasso) Give me a forum ...
Join Date: Sep 2005
Location: Northern IL
Posts: 26,821
|
Sure. A 1% change in SWR either puts me in the street or puts in a penthouse eventually.
I retired anyhow. The alternative is work until you die. At some point you just have to say - OK, I'm reasonable satisfied with the risk/reward.
That can be impacted by how tolerable/good/bad your last years of employments are.
Yep, what Rich_in_Tampa says.
-ERD50
|
|
|
12-06-2007, 01:55 PM
|
#5
|
Give me a museum and I'll fill it. (Picasso) Give me a forum ...
Join Date: Sep 2005
Location: Northern IL
Posts: 26,821
|
darn - no 'posts appeared while you reply feature!'
OK, that's easy. Keep working until you have 25x (or whatever you are comfortable with!).
-ERD50
|
|
|
12-06-2007, 02:28 PM
|
#6
|
Recycles dryer sheets
Join Date: Jul 2005
Posts: 113
|
retiring in 16 years if everything goes right. Tested the what if things go wrong. Bad/good market = +or- 3 years. Low/high wage increases = +or- 3 years. Inflation is almost a non factor if it also increases my pay. In my spreadsheet I assume that I hold my expenses at current levels + inflation +1%. If I am not able to avoid lifestyle creep I can a 10 years or more. The biggest factor was LBYM.
After testing these factors I stopped sweating the investing details. <-- this is coming from someone who is a Portfolio Manager by day.
|
|
|
12-06-2007, 03:24 PM
|
#7
|
Give me a museum and I'll fill it. (Picasso) Give me a forum ...
Join Date: Apr 2003
Location: Hooverville
Posts: 22,983
|
I can't se how "figuring out" when you are going to retire many years in the future could possibly be useful, other than to have an escape to look forward to. It may or may not come true; there might be 40 miles of bad road ahead.
Ha
__________________
"As a general rule, the more dangerous or inappropriate a conversation, the more interesting it is."-Scott Adams
|
|
|
12-06-2007, 06:18 PM
|
#8
|
Give me a museum and I'll fill it. (Picasso) Give me a forum ...
Join Date: Oct 2003
Posts: 5,105
|
People have told me I'm insensitive but I'm working on it.
__________________
Sometimes death is not as tragic as not knowing how to live. This man knew how to live--and how to make others glad they were living. - Jack Benny at Nat King Cole's funeral
|
|
|
12-06-2007, 06:41 PM
|
#9
|
Give me a museum and I'll fill it. (Picasso) Give me a forum ...
Join Date: Jul 2006
Posts: 11,401
|
I do sensitivity analysis regularly on my own spreadsheets and on FireCalc. It enables me to visualize "what if" inflation went up, returns went down, I had to retire earlier than planned, asset allocation was different, etc. I am testing the reslience of my portfolio. Since I am RE - 5 years I don't generally bother doing sensitivity analysis on exact withdrawal rates till age 100, because that far out, there are too many variables to guess at. But it's interesting to save a FireCalc scenario (or a spreadsheet) and to return to it a year or two later. You find that some of your preferred assumptions will have changed.
|
|
|
12-06-2007, 06:58 PM
|
#10
|
Moderator Emeritus
Join Date: Jan 2007
Location: New Orleans
Posts: 47,474
|
My spreadsheet is not set up to solve the problem, "When can I retire?"
It is set up to solve the problem, "How much income can I put in place for a retirement date between November, 2009 and July, 2010, and what do I have to do to make this income consistent with what I will need?" as well as some other related questions.
Working beyond 2010 has not been an option that I would consider since a few months after creating the spreadsheet. I have been working on my spreadsheet since around 2000, so it did allow a 9-10 year timeframe.
I have spent countless hours juggling possible income sources, looking at what various sizes of a fixed immediate lifetime annuity might do for me, for example, correcting the expected rate of growth of my nestegg as time went by and it grew faster than anticipated, and correcting other factors, and trying various scenarios with different inflation, consumption, salary increases, and other factors. Before my house was paid off, I tried various irregular sized lump sum payments, and various times, to see the effect on the balance left.
__________________
Already we are boldly launched upon the deep; but soon we shall be lost in its unshored, harbourless immensities. - - H. Melville, 1851.
Happily retired since 2009, at age 61. Best years of my life by far!
|
|
|
|
Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
|
|
Thread Tools |
|
Display Modes |
Linear Mode
|
Posting Rules
|
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts
HTML code is Off
|
|
|
|
» Recent Threads
|
|
|
|
|
|
|
|
|
|
|
|
|
» Quick Links
|
|
|