The Pension Series (Part 11) : Pension Lump Sum Case Study — Updated

Substantive Revision

This is a substantive revision to the original Pension Series Part 11 article I published on 18 JAN 2018. I updated this article because I have a new method for calculating the Total Dollar Value (TDV) of pensions that do not possess a Cost of Living Adjustment (COLA). The new method is far more accurate than the old method, so I am updating all articles in which I used the old method. That said, the new formula didn’t change the results of this case study because the estimated value of the pension annuities on offer increased vice decreased. As a result, the new method only strengthened the recommendation I made for the ChooseFI listener to concentrate on comparing the difference in value between her $75,740 lump sum offer and the lifetime annuity starting at age 60. 

Any additions I made to the text are in blue. Sentences from the old version of this article that discuss my old TDV method are struck through. I only used the feature a few times in the text, mostly to replace the old TDV steps with the new. As a result, the article itself remains fairly coherent. 

If you want more information on why I updated the TDV formula for no COLA pensions, then go to Part 4 of the Pension Series for the abridged version. That is the source article for all my TDV calculations, and as such I updated it first. If you’d rather read a more in-depth explanation about the impacts of inflation and the correct way to incorporate it into TDV calculations, then you’ll need to wait for my book, “The Golden Albatross: How To Determine If Your Pension Is Worth It“. It’s currently scheduled to be published in early 2020 by ChooseFI publishing.

Pension Lump Sum Case Study

Hello! If you are a ChooseFI listener who made their way here to read my response to a ChooseFI listener’s pension question in Episode 58R, you’re in the right place! You can probably skip the Context section and go straight to the case study if you want. Also, if you’re one of the many listeners and readers who reached out to me as a result of my interview in Episode 57, thank you. I’d like to thank Jonathan and Brad as well for providing me the opportunity to spread the Golden Albatross message!

Pension Lump Sum Case Study

ChooseFI … it does what the label says.

On the other hand, if you have no idea what I am talking about, read the context portion. I wrote it just for you…

Context Is Key

Pension Lump Sum Case Study

There’s Jonathan and wife (I assume).

In late 2017, Jonathan Mendonsa and Brad Barrett from the ChooseFI podcast interviewed yours truly. It proved a great experience. When the episode aired on 08 JAN 2018, it generated a lot of traffic to my blog, FaceBook (FB) group, and FB page. It turns out though, that my interaction with Choose FI listeners was destined for more than one interview and intermittent responses in the ChooseFI FB group to pension questions. Jonathan and Brad asked me to joint their team as the resident researcher for pension questions based on my pension “expertise”. I guess pickings were slim when it came to bloggers who write about Financial Independence (FI) and Pensions! I didn’t have enough happening in my life between my family, military career, and blog; so I said “yes”.

There’s Brad and family. I hope he’s feeling better.

They didn’t waste any time either. I caught my first listener question on Christmas weekend 2017 .. with a due date of 12 JAN 18. They asked for an answer before their weekly round up episode, in which they review what they learned from the week’s interview and answer listener’s questions. Of course, that was the intended week of my interview, so it played into the overall theme of pensions for the week. I was happy to provide. Unfortunately, Brad got sick during the week of 12 JAN, so they pushed my listener question and answer to Episode 58R on 19 JAN 18. No big deal, we got there in the end.

Pension Lump Sum Case Study

Grumpus Maximus in the wild.

Thus, this post is the written version (with better grammar) of the same pension lump sum case study I read out loud on ChooseFI Episode 58R. You can find Tess’s (the listener’s) seemingly simple question at 38m53s into the episode, and my long-winded response immediately following. You’ll need to at least listen to her question to understand my response below.

Right onto my overly complicated answer to Tess’s question.

The Set Up

Whether or not a person should take a pension lump sum is the pension question I see asked most often in the ChooseFI FB group. As a result, I hope this proves an enlightening discussion for a portion of ChooseFI listeners.

Tess asked a seemingly simple question for which no simple or precise answer exists. To paraphrase in terms I use on my blog, Tess wants to calculate the Total Dollar Value (TDV) of her three different pension options in today’s dollars in order to compare them to her company’s lump-sum offer (also in today’s dollars).

One of the reasons there is never a precise answer to the TDV question is due to the vague nature of all retirement planning. Most importantly none of us know how long we will live! Nor do we know exactly what our rate of return or inflation rates will be. Thus, the clear mathematical answer Tess desires is an estimation at best, and a guess at worst.

Dude .. I just showed you my picture. There’s no way this Gorilla will fit in there.

Pension Lump Sum Framework

Since some estimations are better than others, it’s best to understand what we are dealing with, so let’s discuss some general facts about pension lump sums in order to frame our discussion.

Why do private pension funds, or any pension fund for that matter, offer lump sums? I will tell you it’s not out of the goodness of their hearts. No, pension funds offer lump sums primarily because it allows them to transfer risk at a discounted rate to the pensioner.

In other words, the company transfers the future risk of running out of money with which to pay the pensioner over to the pensioner in the present day. By taking a lump sum the pensioner incurs the risk of running out of money in the future, not the pension fund. Assuming the pensioner actually invests the money (a big assumption in my opinion), the pensioner runs the risk by not employing an appropriate Safe Withdrawal Rate (SWR) and therefore withdrawing all their money prior to death. As ERN McCracken has written about prolifically; employment of a SWR can be a tricky thing if an investor does not understand the facts and math.

The U.S. government further incentivizes the risk transfer from company to the pensioner with its rules that govern pension lump sum calculations. Most importantly, the rules allow companies to use what an article at Forbes.com calls “unrealistically high rates of return” for a lump sum invested by the pensioner. Higher than normal rates of return from an invested lump sum (again assuming the lump sum gets invested at all) forces the pensioner to reach for returns to achieve the same value that an annuitized payout would offer.

No surprise there …

The U.S. government also forces companies to use the government’s longevity estimates which inexplicably combines male and female longevity into one table. This is unfair to women offered lump sums since U.S. women statistically live longer than men. Conversely, for U.S. males, this unfairly bumps up their lump sum offer.

Since companies are legally allowed to “low-ball” their pensioners, TDV calculations almost always end up greater than the pension lump sum offered. Thus, anyone looking to compare a lump sum payout to the future value of their annuitized pension using today’s dollars should brace themselves. In rare cases, inflation mitigates this effect, but that isn’t the norm in my experience. If Tess wants a good article explaining these issues further, she can go to the Forbes.com article by William Baldwin (not the actor) I reference above. The article also provides a calculator which (supposedly) mitigates the flaws in U.S. based lump sum calculations and offers a true lump sum calculation.

Pension Safety

The final factor to understand up front in any lump sum discussion is pension safety. Pension safety is something of a trump card (no pun intended) when it comes to lump sums. If a high likelihood of pension fund failure exists, then no matter how “low-ball” the lump sum offer, a pensioner will probably take it.

“Danger Will Robinson, Danger!”

That said, pension safety is an area many people, including many of the ChooseFI Facebook followers, tend to misunderstand. Much of the advice I see in the ChooseFI FB Group generally equates to “assume your pension won’t be there for you, and if it is, it’s just icing on top of the cake”. If that were true, then logic should dictate that everyone take the lump sum offer.

But it’s not true. Each pension fund is run and managed separately from one another. To say that all pensions are doomed is not only inaccurate, but unhelpful to those trying to use a pension to help them achieve FI.

Thus, I would advise anyone in Tess’s situation to dig into the financial details of their pension fund. Pension funds and the companies that own them are required to produce annual statements and reports which disclose how well funded the pension fund is. If for some reason Tess cannot find those reports for her particular company, then I would recommend she go to Boston College’s Center for Retirement Research and see what information they have among their reams of reports on pensions. By doing this, someone should be able to build a much better estimate of the likelihood that their pension fund might fail in the future.

For a private pension, let me further point out that all may not be lost even if the pension fund fails. Many private and union pension funds in the U.S. belong to the Pension Benefit Guarantee Corporation (PBGC). The PBGC is a U.S. Government-backed insurance scheme meant to act as the final backstop for all pension funds who are paying members. However, the Multi-Employer Program (MEP) portion of the PBGC itself is massively underfunded and in need of much reform, which limits its usefulness if you are in a MEP. Check out my article on the PBGC if you want more specific information on the safety of MEPs and Single Employer Programs (SEPs).

Don’t worry, they got anywhere between 20% to 60% of your back.

Facts and Assumptions

So with that long-winded framing of Tess’s question out of the way, let’s discuss the important facts and assumptions about Tess’s pension and lump sum offer:

  • I assumed Tess was asking about the pension lump sum for herself, not a spouse, and used female life expectancy rates
  • We know Tess’s pension is a private pension since she mentioned a company
    • No details on which company, so no ability to judge pension safety, or if it’s a U.S. company
    • I assumed the pension is safe, and the company is U.S. based
  • No ability to judge if the company’s a member of the PBGC
    • I assumed it is a member; although it doesn’t matter for this scenario
  • No survivorship consideration (as relayed via email)
  • No mention of a cost of living adjustment (COLA)
    • I assumed there is no COLA, which means inflation is at play
    • As a result, I assumed a 2% annual rate of inflation for all calculations
  • I didn’t see in the email or hear in the voice mail (VM) about any other pension benefits like healthcare
    • I assumed there were none
  • Tess is 48 (according to follow-up email) so has 7, 12, or 17 years to wait until pension payouts start; depending on which choice she makes
    • Assuming no COLA, that’s 7, 12, or 17 years of inflation eating away at the value of her payouts before they start at ages 55, 60, and 65, respectively.
    • This means the value of the different monthly payouts offered ($690, $1066, and $1254) would respectively be worth $601, $841, $896 in today’s dollars when those payouts start. I made those calculations with this inflation calculator at BuyUpside.com
  • The Pension Lump Sum offer is $75,740
  • Finally, since Tess’s pension doesn’t start immediately, she needs to understand the Immediacy Effect as discovered and described by Big ERN McCracken in his 17th article of the Safe Withdrawal Rate Series
    • It’s worth a read, but I’ve yet to figure out how to value the immediacy effect mathematically for TDV calculations

Calculations

Oh yeah, it’s just like that.

Right, I’m ready to make the TDV calculations now. Here’s how I do it for a no COLA pension, like Tess’s, that’s offset by a significant amount of time. Take the inflation-adjusted monthly payouts I noted above, and turn them into annual amounts. After that, pick an annual inflation rate. As stated above, I used 2% since it is the U.S. Federal Reserve’s target rate.  Then multiply the various totals by the number of years left from the start point of each pension payout to the end of Tess’s assumed life. Finally, adjust that total again for inflation using the BuyUpside.com calculatorThen place each of the annual values from the above age driven scenarios, seperately, into the below formula (as explained in Part 4 of the Pension Series), along with the inflation rate, and the Expected Life Span (ELS) of the annuity. 

No COLA Pension TDV = IDV(((1-r)^(ELS+1)-(1-r))/-r)

  • IDV = annual pension payment
  • r = annual inflation rate (negative growth)
  • ELS = Expected Life Span after retirement starts (or any number of years you want to use)

Once done, you end up with something like the outcomes below.

Scenario #1 Age 55 Pension Pay Out

  • $601 x 12 months = $7212 per year = IDV
  • ELS = 28 years
  • r = .02
    • 7212*(((1-.02)^(28+1)-(1-.02))/-.02) = $152,672 TDV

Scenario #2 Age 60 Pension Pay Out

  • $841 x 12 months = $10,092 per year = IDV
  • ELS = 23
  • r = .02
    • 10092*(((1-.02)^(23+1)-(1-.02))/-.02) = $183,785 TDV

Scenario #3 Age 65 Pension Pay Out

  • $896 x 12 months = $10,752 per year
  • ELS = 23
  • r = .02
    • 10752*(((1-.02)^(18+1)-(1-.02))/-.02) = $160,617 TDV

Comparison of TDVs to Lump Sum Offers

Wahay, we did it! Not only did we determine today’s TDV for Tess’s future pension payouts, but we also discovered that Scenario 2 provides the most money over her life expectancy (if our assumptions hold true). About this point is where I typically caution readers to remember the TDVs are at best estimations! Tess actually has to make it to 83 years of age to realize this scenario. Not only that, but she has to die (sorry Tess) at 83 for this to hold true too. Finally, our 2% inflation rate has to hold true over the lifetime of our scenario as well.

Those are a lot of assumptions, and they don’t include any of the other assumptions I made about Tess’s pension due to a lack of information. For instance, the addition of other pension benefits like healthcare, or a major pension safety concern, seriously complicates comparing a TDV to a pension lump sum. If that happens to be anyone else in the audience, then refer to Part 8 of my Pension Series for more detailed comparison methods.

However, in Tess’s case let’s assume everything is true up to this point and holds true throughout the lifetime of our TDV scenarios. As a result, I would recommend she concentrate on the difference between Scenario 2 and the lump sum offer. That comparison truly highlights the “low-ball” effect I described towards the beginning of this response. Tess’s lump sum offer is worth approximately half of what she’s owed in Scenario 2. Not good, but that’s what the U.S. law allows.

Other Methods

One last point worth noting, my method isn’t the only one out there for calculating pension lump sums. Both Financial Samurai and Actuary on Fire also wrote fairly extensive posts on how to value a pension. Actuary’s is probably the easiest, as it makes a lot of assumptions, and uses the XNPV function on MS Excel. Actuary’s method and mine are conceptually similar since we both base our calculations on the potential amount earned, discounted for inflation. Financial Samurai uses a Rate of Return method for comparing the value of a pension, which is something I don’t do. This illustrates the point I was trying to make at the beginning of this post though. Since there is no precise method for calculating TDV for a pension, there is no one correct method.

“You are an 18 year old girl who lives in a small city in Japan.” OK, that’s a Weezer song. I have no idea whether or not Financial Samurai is actually a samurai … or a girl.

Conclusion

At this point, it’s over to Tess for her determination as to what to do. The TDV estimates argue for Scenario #2, but then again that doesn’t take into account what’s going on her personal life. As Airmen Mildollar likes to say, personal finance is personal; which means no two pension lump sums comparison scenarios will be the same. And, as Brad Barret likes to point out on the ChooseFI podcast all the time, people value different things as well. All I’ve done is arm Tess with knowledge by showing her a way (not the way) to estimate her pension’s Total Dollar Value (TDV). She can use that knowledge to compare it to her lump-sum offer, but what she chooses to do with that knowledge is up to her. Best of luck Tess!

Post Script

What do you think of my new method for calculating TDV? If you like it or have questions, let me know. I can be reached at grumpusmaximus@grumpusmaximus.com. Depending on your situation, I may even ask your permission to anonymize the data and publish it as a case study article so other readers can learn from it! 

By the way, anyone can learn how to make the calculations above but they may not necessarily have the time. To help with that, I wrote a post for Part 13 of the Pension Series about a Master Pension Value Calculator that one of my reader’s developed. It has several different formulas for calculating TDV cooked into an Excel spreadsheet . It’s free for all to use, but use it at your own risk. Remember, I’m not a certified professional, nor am I a math genius. Consider the formula I showed you above and the calculator as informational tools only. Consult a CPA, CFA, or CFP prior to any major money decisions. 

12 thoughts on “The Pension Series (Part 11) : Pension Lump Sum Case Study — Updated

  1. GM- I’m being Mr Proofreader here- in the “Context” section you have the interview date as 2017. You have it correctly later but thought you might want to know. Keep your great content coming!

  2. GM – are the private sector “lump sum” pension distributions generally allowed to roll into a tax deferred vehicle like an IRA? Or would the pensioner taking a lump sum have a big tax hit in the year the lump sum was taken?

    • Army Doc,

      During my research into the Pension Lump Sum article, I saw references to some pension plans allowing the lump sum to roll into 401Ks and traditional IRAs. However, I did not research how wide spread that practice is or what determines when a lump sum can be rolled into a tax deferred account.

      Regards,

      GM

  3. Thank you Grumpus. I was wondering if you can go through the same way of figuring for an annuity? I was talked into putting $50k into an annuity after my husband died in2009. If I wait until I’m 73( 60 now) it will give me $1000/ month for life and any left over goes to my kids. If I close it now I think month.
    It sounded similar to me.

  4. The calculation seems flawed, but the result in the good range.
    You seems to be doing a*n*(1+inflation)^-n. This is a simplification of the correct formula. Also it implies that we would be investing all our money at inflation rate of return. While we should not use a rate of return including risk, using bonds rate (currently T-Bonds rate of return (risk free?) = 4.107%), which is way above the 2% you are using.

    The formula should be a*((1-v^n)/d)*(1-v^m) where
    a = annuity amount
    v = (1 + Expected Rate of Return)^-1
    d= 1-v
    n= 83-55
    m=55-48

    Using the risk free? T-Bonds rates (4.107%), we get
    Opt 1 (7212 at age 55) = 93,237$
    Opt 2 (10,092 at age 60) = 95,287$
    Opt 3 (10,752 at age 65) = 70,868$

    However, like your article perfectly indicate, if the Lump sum option is worth or not depends on what you will do with the money, in fact if you would take the money and invest it yourself at 7% per years in a more risky asset allocation, you would get Opt2 (10,092 at age 60 using 7% RoR) = 54,046$. Basically you will be able to get more “annuity” if you would get the Lump sum. However if you were thinking to use the “4% rule” to replace the annuity, you would need 10,092*25*1,07^-12 = 112,024. If you would “remove inflation protection” from the “SWR” it basically grow to a 5% rule (or about), you would get 10,092*20*1,07^-12= 89,619$

    Long comment to say, I disagree with your calculation, but I agree with the conclusion.

    • Hi Patrice,

      Thanks for reading the article and taking the time to make a comment! Happy to see that you also subscribed to follow-me on WordPress. Thank you very much.

      So, it looks like you are using a discount rate formula to me, which is something I don’t typically do. I don’t like discount rate formulas because discount rates are subjective. Pensions are guaranteed by law, so the only time a discount rate should come into effect is when you need to create one for a situation where a pension may not pay out as guaranteed. In that case I would use something like Bayes’ theorem to develop a discount rate based on previous incidents of pensions not paying out.

      However, that wasn’t the case in this pension analysis based on the fact that I listed in the assumptions that the pension was safe. Therefore, all we need to really figure out is what Tess was owed by law, discounted into today’s dollars based on inflation. Yes, I’m aware of the “time value of money” but again, that’s a subjective discount and not in play in my opinion since I assumed the fact that the pension would pay out as promised.

      This disagreement on the use of formulas also plays into two other comments that I made in this article. One, is that there is no correct method for calculating a pension’s value. Thus, I listed at least two other bloggers who chose to create formulas which you might find more to your mathematical liking. The other is that outside of this simplistic scenario, once you start taking other factors into consideration that play into the value of a pension, making the calculations is much harder. This includes COLA and health care. As I said in the article, if that’s the case, a person should refer to Part 8 of the pension series. Although, you still probably won’t agree with my forulas based on the lack of a discount rate.

      Again thanks for reading, and keep the comments coming.

      Regards,

      GM

      • One of my concern with the formula used is that it used only n = 83-55. There’s still m=55-48 years until 2017.

        Next, the formula a*n*(1+inflation)^-n put the same weight to all the money. However, the money earn at age 83 are less valuable than the money earn near age 55. Since it conpounded interest is not a linear formula, this makes some difference. That was why I was recommending to use the classic annuities formula. Even replacing the discount rate by inflation rate would be nice 🙂

        I disagree to discount at inflation rate, but to go at least to the “risk free rate” which would by definition means it is risk free. T-Bill (10years investment) seems appropriate due to the lenght of the deferral period. If it’s risk free, then anyone could go in the market to get that rate with no risk.

        I’ll look at your other article as soon as I find the time.

  5. Wow! Like a bullet whizzing past my head and not having time to duck is what I felt like when reading all the calculation formulas. But then I only made it to Algebra 3-4 in high school. My pension is a state government pension and no option to take a lump sum so this is all for nothing to me. However, the calculator in Baldwin’s article for Forbes was a good read, and enjoyed the calculator which I will help with in-laws. As always, thank you for the education, links, and calculator!

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.