|
06-20-2019, 09:39 AM
|
#1
|
Dryer sheet wannabe
Join Date: Mar 2019
Posts: 14
|
Firecalc Question
I am trying to simulate the following scenario. Retire in 2022 with a ~$2.5M portfolio value, for 34 years with $140K spend. I'm not including in the value of that portfolio a certain amount of stock that I will then sell for a period of say, 8 years, immediately after starting retirement. I would then sell each of those years to get $140K to use as my spending for those years.
Would I enter that in the "Pension Income" section as $140k per year starting in 2022. But then how do I stop it in 2030? Enter an offsetting $140k of "Off Chart Spending" in the same section?
|
|
|
|
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!
|
06-20-2019, 10:12 AM
|
#2
|
Give me a museum and I'll fill it. (Picasso) Give me a forum ...
Join Date: Sep 2005
Location: Northern IL
Posts: 26,806
|
Seems that should work. Maybe simpler to just assume zero growth in your portfolio for those 8 years, and then just look forward from there, and ignore the previous 8 years?
Try both.
-ERD50
|
|
|
06-20-2019, 10:23 AM
|
#3
|
Give me a museum and I'll fill it. (Picasso) Give me a forum ...
Join Date: Nov 2010
Location: Sarasota, FL & Vermont
Posts: 36,204
|
Quote:
Originally Posted by Pacinotti
I am trying to simulate the following scenario. Retire in 2022 with a ~$2.5M portfolio value, for 34 years with $140K spend. I'm not including in the value of that portfolio a certain amount of stock that I will then sell for a period of say, 8 years, immediately after starting retirement. I would then sell each of those years to get $140K to use as my spending for those years.
Would I enter that in the "Pension Income" section as $140k per year starting in 2022. But then how do I stop it in 2030? Enter an offsetting $140k of "Off Chart Spending" in the same section?
|
The pension income/off-chart spending should work as would just not starting withdrawals until 2030. I would probably run it both ways, as well as including the stock in the retirement portfolio and starting withdrawals in 2022. And see if any of the runs are significantly different.
__________________
If something cannot endure laughter.... it cannot endure.
Patience is the art of concealing your impatience.
Slow and steady wins the race.
Retired Jan 2012 at age 56
|
|
|
06-20-2019, 10:24 AM
|
#4
|
Give me a museum and I'll fill it. (Picasso) Give me a forum ...
Join Date: Nov 2010
Location: Sarasota, FL & Vermont
Posts: 36,204
|
Quote:
Originally Posted by ERD50
Seems that should work. Maybe simpler to just assume zero growth in your portfolio for those 8 years, and then just look forward from there, and ignore the previous 8 years?
Try both.
-ERD50
|
Why assume zero growth for the first 8 years? As I understand it the OP will be using a side fund for the first 8 years and leaving their retirement portfolio to grow.
__________________
If something cannot endure laughter.... it cannot endure.
Patience is the art of concealing your impatience.
Slow and steady wins the race.
Retired Jan 2012 at age 56
|
|
|
06-20-2019, 10:25 AM
|
#5
|
Give me a museum and I'll fill it. (Picasso) Give me a forum ...
Join Date: Jun 2006
Location: Boise
Posts: 7,862
|
As long as you're starting the stock sales at the same time as you start retirement, you could just enter $0 as your base spending level, then have a single entry of $140K of Off Chart Spending in 2030.
A minor detail would be to decide whether inflation affects that $140K over that time frame at all. Over 8 years and at that spending level it's probably not noticeable.
__________________
"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.
|
|
|
06-20-2019, 10:25 AM
|
#6
|
Thinks s/he gets paid by the post
Join Date: Mar 2014
Location: Apex and Bradenton
Posts: 1,762
|
There's more than one way to do this.
No, not in pension the way I have in mind.
Your stock will pay the $140k/year for years 2022-2029 (with 100% certainty). As far as FireCalc is concerned, you'll retire in 2030 for 26 years with a $2.5M portfolio (no growth/this is very conservative) and need $140k/year.
Spending: 140,000
Portfolio: 2,500,000
Years: 26
What year will you retire: 2030 (On the Not Retired tab)
"FIRECalc Results
Your spending in every year after the first year will be adjusted for inflation, so the spending power is preserved.
Because you indicated a future retirement date (2030), the withdrawals won't start until that year. The tested period is 11 years of preretirement plus 15 years of retirement, or 26 years.
FIRECalc looked at the 123 possible 26 year periods in the available data, starting with a portfolio of $2,500,000 and spending your specified amounts each year thereafter.
Here is how your portfolio would have fared in each of the 123 cycles. The lowest and highest portfolio balance at the end of your retirement was $1,228,106 to $15,274,416, with an average at the end of $7,100,174. (Note: this is looking at all the possible periods; values are in terms of the dollars as of the beginning of the retirement period for each cycle.)
For our purposes, failure means the portfolio was depleted before the end of the 26 years. FIRECalc found that 0 cycles failed, for a success rate of 100.0%."
|
|
|
06-20-2019, 10:32 AM
|
#7
|
Give me a museum and I'll fill it. (Picasso) Give me a forum ...
Join Date: Nov 2010
Location: Sarasota, FL & Vermont
Posts: 36,204
|
Another way to solve it would be to become a supporter, log-in and use the Manual Entry of Spending Changes. Make your spending on the Start Here tab as -0-, then input 140000 in the year you will start withdrawals.
__________________
If something cannot endure laughter.... it cannot endure.
Patience is the art of concealing your impatience.
Slow and steady wins the race.
Retired Jan 2012 at age 56
|
|
|
06-20-2019, 10:41 AM
|
#8
|
Dryer sheet wannabe
Join Date: Mar 2019
Posts: 14
|
See... there is more than one way to skin this cat, that's why I asked...
Great suggestions all, thanks!
|
|
|
06-20-2019, 10:47 AM
|
#9
|
Give me a museum and I'll fill it. (Picasso) Give me a forum ...
Join Date: Sep 2005
Location: Northern IL
Posts: 26,806
|
Quote:
Originally Posted by pb4uski
Why assume zero growth for the first 8 years? As I understand it the OP will be using a side fund for the first 8 years and leaving their retirement portfolio to grow.
|
It's just an alternative to the pension entries. Use any assumption you like, but we don't know it will grow in 8 years, so zero growth (actually inflation matching growth) is a reasonably conservative approach.
I've done something similar for a real simple 'reality check' on things. I break down my retirement in 5 year segments to match some changes (SS, pensions, harvesting 0% LTCG, ROTH conversions, etc), adjust my spending and income, and just assume my portfolio matches inflation. That doesn't get you the detail of the impact of sequence of returns, but it's also conservative enough that it kind of washes out. It just makes me feel a bit more comfortable that the numbers make some sense, that I didn't miss something big.
-ERD50
|
|
|
06-20-2019, 10:48 AM
|
#10
|
Dryer sheet wannabe
Join Date: Mar 2019
Posts: 14
|
Quote:
Originally Posted by pb4uski
Another way to solve it would be to become a supporter, log-in and use the Manual Entry of Spending Changes. Make your spending on the Start Here tab as -0-, then input 140000 in the year you will start withdrawals.
|
How would this be different than what Latexman suggested?
|
|
|
06-20-2019, 11:04 AM
|
#11
|
Give me a museum and I'll fill it. (Picasso) Give me a forum ...
Join Date: Nov 2010
Location: Sarasota, FL & Vermont
Posts: 36,204
|
Quote:
Originally Posted by Pacinotti
How would this be different than what Latexman suggested?
|
Not sure... might be the same.
__________________
If something cannot endure laughter.... it cannot endure.
Patience is the art of concealing your impatience.
Slow and steady wins the race.
Retired Jan 2012 at age 56
|
|
|
06-20-2019, 11:31 AM
|
#12
|
Thinks s/he gets paid by the post
Join Date: Apr 2011
Location: Madison
Posts: 1,337
|
The OP doesn't say what stock(s) he is intending to sell each year for $140K. How can you know that this stock(s) will maintain that value? They could hit a Black Swan event and crater just as well as grow in value.
__________________
Wild Bill shoulda taken more out of his IRA when he could have. . . .
|
|
|
06-20-2019, 02:04 PM
|
#13
|
Thinks s/he gets paid by the post
Join Date: Dec 2017
Posts: 2,522
|
Quote:
Originally Posted by dtbach
The OP doesn't say what stock(s) he is intending to sell each year for $140K. How can you know that this stock(s) will maintain that value? They could hit a Black Swan event and crater just as well as grow in value.
|
+1 If it's a stock, it has some level of volatility. Rather than excluding the stock as an asset, I'd include it, but input a custom AA. Then FIRECALC can appropriately model the success rate.
__________________
Balance in everything.
|
|
|
06-21-2019, 07:05 AM
|
#14
|
Dryer sheet wannabe
Join Date: Mar 2019
Posts: 14
|
Yes, the price for the stock in question could of course alter the amounts that I am able to extract. It is a large and variable holding (employer stock) in my current portfolio so somehow weaving it into an AA proportion would be not too meaningful. In this question I am wrapping up that uncertainty by conservatively estimating I could extract 140K for 8 years.
My question was primarily directed at understanding the mechanics of Firecalc not so much the question of how to best handle this stock. That would be a matter for another subject post entirely.
In my first post here I tried, rather poorly, to lay out my situation but understandably I received no replies because I didn't know which precise questions to ask. There are too many variables right now so I am going down the thought process of trying to narrow those down and decide how to best deal with that large holding of stock.
|
|
|
06-21-2019, 12:15 PM
|
#15
|
Thinks s/he gets paid by the post
Join Date: Dec 2017
Posts: 2,522
|
Pacinotti - for FIRECALC to model the risk associated with your employer stock, I'd include it in your total invested assets on the first tab, then go to the Your Portfolio tab and set up a custom AA. I would choose a Mixed Portfolio, and assign the employer stock % to to the fund type that most closely mirrors the risk/volatility of your company stock. I've done this with my employer's stock. My employer stock is in a medium-sized company, but it's highly diversified, and prior to becoming publicly traded last month, had little volatility. I therefore assigned the percentage of the portfolio associated with the employer stock to Mid-Cap.
If this doesn't answer your questions, you may want to check out the FIRECALC support forum: FIRECalc support - Early Retirement & Financial Independence Community
Cheers!
__________________
Balance in everything.
|
|
|
|
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
|
|
|