|
Calculated withdrawal amount for non-inflation adjusted pension
12-01-2019, 10:50 AM
|
#1
|
Recycles dryer sheets
Join Date: Apr 2015
Location: Austin
Posts: 106
|
Calculated withdrawal amount for non-inflation adjusted pension
I am modeling a scenario with a non-inflation pension by checking the "Inf-adjusted?" box. When I download the spreadsheet showing the calculations, the calculated withdrawal for the pension is inflation adjusted whether or not the "Inf-adjusted?" box is checked.
Am I missing something or is this a bug?
|
|
|
|
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-01-2019, 12:54 PM
|
#2
|
Give me a museum and I'll fill it. (Picasso) Give me a forum ...
Join Date: Jul 2014
Location: Spending the Kids Inheritance and living in Chicago
Posts: 17,094
|
It might help if you explained what you are talking about, which downloaded spreadsheet.
__________________
Fortune favors the prepared mind. ... Louis Pasteur
|
|
|
12-01-2019, 01:02 PM
|
#3
|
Give me a museum and I'll fill it. (Picasso) Give me a forum ...
Join Date: Jan 2006
Location: Rio Grande Valley
Posts: 38,145
|
I assume it is Firecalc.
__________________
Retired since summer 1999.
|
|
|
12-01-2019, 01:08 PM
|
#4
|
Recycles dryer sheets
Join Date: Jan 2017
Location: Bay Area
Posts: 248
|
Just uncheck the box. Checked means adj for inflation; unchecked means no COLA.
|
|
|
12-01-2019, 01:35 PM
|
#5
|
Thinks s/he gets paid by the post
Join Date: Mar 2013
Location: Coronado
Posts: 3,706
|
Yes, I think this is a bug in Firecalc. I reproduced it as follows:
- Other Income/Spending tab - add a 10000 pension starting in 2030 and uncheck inflation adj
- Investigate tab - check the box to provide data in spreadsheet
- Submit
- On the Results page open the "single-year" spreadsheet
See image below. It has the correct $10K in the input row at the top of column F, but it's been inflation adjusted to $14K by the time the income starts in year 12. The results are the same if you check the inflation adj box or don't, so it seems to be broken.
|
|
|
12-01-2019, 01:44 PM
|
#6
|
Recycles dryer sheets
Join Date: Jan 2017
Location: Bay Area
Posts: 248
|
Hmmm, I wonder if it affects the basic calculations not pulled into a spreadsheet.
Just checked, and it looks like checking/unchecking the inflation adj box does have an impact on the site generated outputs using the investigate tab....so maybe the bug is just in the download to spreadsheet process?
|
|
|
12-01-2019, 07:32 PM
|
#7
|
Recycles dryer sheets
Join Date: Apr 2015
Location: Austin
Posts: 106
|
Quote:
Originally Posted by Sunset
It might help if you explained what you are talking about, which downloaded spreadsheet.
|
Good point.
It's fairly easy to create. - Create a 30 year Firecalc scenario with everything zero ($0 spending, $0 portfolio)
- Under "Other Income / Spending", enter $10,000 pension beginning in 2025, with the inflation adjusted box unchecked.
- Click the Investigate tab and check the box for "provide data and formulas in a spreadsheet format".
- Hit submit.
- On the results page, download and open the "single year" spreadsheet showing the year-by-year results for the default period beginning in 1960.
- Open the downloaded spreadsheet. The withdrawal change column shows inflation adjusted amounts, with the first withdrawal change in 1963 of $10546.
Doing this with or without the inflation adjusted box checked gives the same results for withdrawal change.
I'm thinking that if the pension is not inflation adjusted, then the withdrawal change should be $10,000 each year.
Where am I going wrong?
|
|
|
12-01-2019, 08:20 PM
|
#8
|
Recycles dryer sheets
Join Date: Apr 2015
Location: Austin
Posts: 106
|
Quote:
Originally Posted by Nature Lover
Hmmm, I wonder if it affects the basic calculations not pulled into a spreadsheet.
Just checked, and it looks like checking/unchecking the inflation adj box does have an impact on the site generated outputs using the investigate tab....so maybe the bug is just in the download to spreadsheet process?
|
You are on to something. There's definitely a bug in the downloaded spreadsheet. See the attached screenshot with some rows hidden. From the description in the comments, the upper half is the calculated results from Firecalc, and the lower part is the same with the calculation in the spreadsheet. The comments say the upper and lower calculations should match, but they don't.
Both sections should reflect a $10,000 pension with no inflation adjustment, but I can't tell if either does.
Hmm..
|
|
|
|
Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
|
|
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
|
|
|