
Non COLA DB pension reductions to cover inflation ?
12262009, 05:57 PM

#1

Full time employment: Posting here.
Join Date: Dec 2004
Posts: 607

Non COLA DB pension reductions to cover inflation ?
I'll have a nonCOLA DB pension.
Is there a way to figure out how much you'd need to "set aside" each year to offset inflation in future years ? The goal is to "mimic" a COLA pension.
Example: Given a $10,000 /year DB pension. 3% inflation. 5% investment return. 30 year life expectancy.
I'm trying to understand the amount you can spend the first year, then spend the equivalent inflationadjusted amount in future years.
I tried to model with some spreadsheets  looks like one could spend around $7,000 first year and increased 3% more each year to offset inflation over a 30 year period.
__________________




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 EarlyRetirement.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!

12262009, 07:21 PM

#2

Thinks s/he gets paid by the post
Join Date: Jan 2006
Posts: 1,012

Quote:
Originally Posted by Delawaredave5
I'll have a nonCOLA DB pension.
Is there a way to figure out how much you'd need to "set aside" each year to offset inflation in future years ? The goal is to "mimic" a COLA pension.
Example: Given a $10,000 /year DB pension. 3% inflation. 5% investment return. 30 year life expectancy.
I'm trying to understand the amount you can spend the first year, then spend the equivalent inflationadjusted amount in future years.
I tried to model with some spreadsheets  looks like one could spend around $7,000 first year and increased 3% more each year to offset inflation over a 30 year period.

using an annuity quoter i found that an inflation adjusted annuity with annual payments starting at $6633.72 ( and adjusted for inflation) costs the same as a fixed annuity with annual payments of $10000.00. so maybe $6633.72 is your answer.
__________________



12262009, 08:18 PM

#3

Full time employment: Posting here.
Join Date: Dec 2004
Posts: 607

Quote:
Originally Posted by jdw_fire
using an annuity quoter i found that an inflation adjusted annuity with annual payments starting at $6633.72 ( and adjusted for inflation) costs the same as a fixed annuity with annual payments of $10000.00. so maybe $6633.72 is your answer.

Wow  great way to look at it  thanks !!!!!!!!!!!!
33% reduction is a big adjustment between COLA and nonCOLA.
But I guess that reduction is reduced if one assumes shorter time periods.



12272009, 09:26 AM

#4

Recycles dryer sheets
Join Date: May 2005
Posts: 441

4. A very simple approach that almost anyone can use. Each year you make a new calculation to determine how much you can spend by adding the following three components:
a) all of your aftertax social security or a COLA pension,
b) your aftertax fixed pension multiplied by your age as a percentage, e.g., 60% at age 60, and
c) each year you can spend your previous year’s investment balance divided by an estimate of the years you have yet to live. This is essentially the same budget you would get with the old IRA minimum distribution rules with the recalculation alternative, but it can be used much earlier than the mandatory 70 ˝ age. The investment balance must be an aftertax value and should not include reserves needed for known large value items and some kind of allowance for emergencies.
(This approach is equivalent to assuming a zero percent real return which, in turn, is equivalent to a higher than 80% success rate for a fairly wide range of portfolio allocations.)
Frm Analyzenow.com



12292009, 01:29 AM

#5

Thinks s/he gets paid by the post
Join Date: Sep 2008
Posts: 2,171

Quote:
Originally Posted by Delawaredave5
I'll have a nonCOLA DB pension.
Is there a way to figure out how much you'd need to "set aside" each year to offset inflation in future years ? The goal is to "mimic" a COLA pension.
Example: Given a $10,000 /year DB pension. 3% inflation. 5% investment return. 30 year life expectancy.
I'm trying to understand the amount you can spend the first year, then spend the equivalent inflationadjusted amount in future years.
I tried to model with some spreadsheets  looks like one could spend around $7,000 first year and increased 3% more each year to offset inflation over a 30 year period.

Another way is to put your parameters into FIRE Calc and vary the spending to see how much you could have spent without ever running out of money. I put in a starting portfolio value of zero, annual income $10K, and 100% of the portfolio in 5year treasuries (Intermediate term gov't bonds have returned an average of 5.3%/year from 19262007, which was as close as I could get to 5% with an actual asset class). There are 109 possible 30year series. At 3% inflation, the first portfolio fails at a spending level of $6385/year, pretty close to the annuity quote. However, if the actual inflation rate is used, the historically safe spending level is much lower—with CPI instead of a constant 3% inflation, the first portfolio fails with annual spending of only $4687.
I can think of two possible reasons the safe level with CPI is so much lower than with 3%. The most obvious possibility is that inflation has historically averaged higher than 3%, or it could be that the sequence of inflation rates has a large effect, or maybe both.



12292009, 04:15 AM

#6

Thinks s/he gets paid by the post
Join Date: Jul 2004
Posts: 1,083

I'm even simpler  I use the exponential function in excel  for example, assuming an inflation rate of 3%, I multiply 1+the inflation rate and take it to the power of the year in question.
Example: amt*(1.03)^yr  so you could do this for each year, subtract the original amount and you will see what you would need to augment to equal the purchasing power of the original amount today.
Example: 10,000*(1.03)= year 1; 10,000*(1.03)^2 = year 2, etc.
At least that's what I remember from my financial engineering class before we had spreadsheets and did everything by hand :)
__________________
Deserat aka Bridget
“We sleep soundly in our beds because rough men stand ready in the night to visit violence on those who would do us harm.”  George Orwell/Winston Churchill



12292009, 06:14 AM

#7

Full time employment: Posting here.
Join Date: Dec 2004
Posts: 607

Quote:
Originally Posted by kyounge1956
Another way is to put your parameters into FIRE Calc and vary the spending to see how much you could have spent without ever running out of money. I put in a starting portfolio value of zero, annual income $10K, and 100% of the portfolio in 5year treasuries (Intermediate term gov't bonds have returned an average of 5.3%/year from 19262007, which was as close as I could get to 5% with an actual asset class). There are 109 possible 30year series. At 3% inflation, the first portfolio fails at a spending level of $6385/year, pretty close to the annuity quote.

Thanks ! This is close to annuity calculation, my spreadsheet, and "spend percentage equal to your age"  so they are all consistent.



12292009, 12:45 PM

#8

Thinks s/he gets paid by the post
Join Date: Sep 2008
Posts: 2,171

Consistent with each other maybe, but not with "reality"—the safe spending with CPI was much lower. You might want to try FIRE Calc again using CPI instead of 3% and see if you are comfortable with the percentage of times the portfolio would have been exhausted.
There are two other things I haven't taken into account. The first of these is determining an acceptable risk level. Are you counting on this pension to meet part of your basic living expenses, or do you have other resources for that and this pension is more like frosting on the cake? The other is the time span. I assumed a 30 year span, but if your pension will pay you $10K/year for your life, I think my FIRE Calc scenarios are probably somewhat off. Using a 30 year span may have been more akin to a "time certain" series of payments than a lifetime one. You might want to lengthen the span to 40, 50 or more years to see what happens to the safe spending level.



12292009, 01:02 PM

#9

Full time employment: Posting here.
Join Date: Dec 2004
Posts: 607

Quote:
Originally Posted by kyounge1956
Are you counting on this pension to meet part of your basic living expenses, or do you have other resources for that and this pension is more like frosting on the cake? The other is the time span. I assumed a 30 year span, but if your pension will pay you $10K/year for your life, I think my FIRE Calc scenarios are probably somewhat off.

I'm still w*rking and in planning stages. Right now I'm guessing my retirement "income" will be:
45% pensions
45% portfolio
10% SS
Plan to retire around 55  so 30 year horizon seems OK (but I don't want to spark an "actuarial debate"...)



12292009, 01:23 PM

#10

Thinks s/he gets paid by the post
Join Date: Sep 2008
Posts: 2,171

Quote:
Originally Posted by Delawaredave5
I'm still w*rking and in planning stages. Right now I'm guessing my retirement "income" will be:
45% pensions
45% portfolio
10% SS
Plan to retire around 55  so 30 year horizon seems OK (but I don't want to spark an "actuarial debate"...)

OK, no debate, but for planning purposes it would probably be a good idea to find out what happens if you live longer than you expect to. Forewarned is forearmed, and all that.



12302009, 09:12 AM

#11

Thinks s/he gets paid by the post
Join Date: Oct 2006
Posts: 3,972

Quote:
Originally Posted by rmark
4. A very simple approach that almost anyone can use.
Each year you make a new calculation to determine how much you can spend by adding the following three components:
a) all of your aftertax social security or a COLA pension,
b) your aftertax fixed pension multiplied by your age as a percentage, e.g., 60% at age 60, and
c) each year you can spend your previous year’s investment balance divided by an estimate of the years you have yet to live. This is essentially the same budget you would get with the old IRA minimum distribution rules with the recalculation alternative, but it can be used much earlier than the mandatory 70 ˝ age. The investment balance must be an aftertax value and should not include reserves needed for known large value items and some kind of allowance for emergencies.
(This approach is equivalent to assuming a zero percent real return which, in turn, is equivalent to a higher than 80% success rate for a fairly wide range of portfolio allocations.)
Frm Analyzenow.com

It looks like this is Option 4 on a list of approaches. I tried Googling and couldn't get a hit on this. I looked at the website and didn't see it toward the top. Do you have a link?



12302009, 10:06 AM

#12

Recycles dryer sheets
Join Date: May 2005
Posts: 441

Analyzenow.com  planning,post retirement  scroll down to article titled 'For Retirees only'.



12302009, 12:31 PM

#13

Thinks s/he gets paid by the post
Join Date: Oct 2006
Posts: 3,972

Thanks. This approach to a fixed pension is new to me. I was wondering what his other approaches were.



Also looking at this approach
12312009, 02:26 PM

#14

Recycles dryer sheets
Join Date: Sep 2007
Posts: 82

Also looking at this approach
I am also in the planning stages and have a $60K annual pension coming to me when I retire in about 8 years (at age 57). I had thought this would be a good approach and had used Excel to model it similar to the OP.
The amount quoted using FIRECALC sounds so different  I'll have to try that myself to see the results.
I haven't really seen this topic discussed before  is this commonly used by people with a fixed pension? Anyone have any reallife experience with this approach?
The most interesting part of this exercise is seeing how much money you need in 30 or 35 years to maintain the same level of spending. 3% a year sounds so harmless until you do the math!



12312009, 10:06 PM

#15

Thinks s/he gets paid by the post
Join Date: Sep 2008
Posts: 2,171

Quote:
Originally Posted by rmark
Analyzenow.com  planning,post retirement  scroll down to article titled 'For Retirees only'.

Could you post a link directly to the article? I went to the site and looked around but didn't see "For Retirees Only".
thx



01012010, 10:16 AM

#16

Recycles dryer sheets
Join Date: Sep 2007
Posts: 82

Quote:
Originally Posted by kyounge1956
Could you post a link directly to the article? I went to the site and looked around but didn't see "For Retirees Only".
thx

From the main page, click on "Planning Post Retirement"; scroll down to "For Retirees Only"



01012010, 12:48 PM

#17

Thinks s/he gets paid by the post
Join Date: Sep 2008
Posts: 2,171

Quote:
Originally Posted by boilerman
From the main page, click on "Planning Post Retirement"; scroll down to "For Retirees Only"

Finally found it. The link to Planning Post Retirement isn't on the main page, it's under "Helpful Articles".
__________________




Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)


Thread Tools 
Search this Thread 


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













