Join Early Retirement Today
Reply
 
Thread Tools Search this Thread Display Modes
Present Value Calculator and Equation for a Pension
Old 02-18-2014, 08:51 AM   #1
Recycles dryer sheets
 
Join Date: Feb 2010
Posts: 396
Present Value Calculator and Equation for a Pension

Hi:

Does anyone know where I can find a present value calculator and an equation for a defined benefit pension with and without a cost of living adjustment.

I am trying to figure out the present value of my state government pension. The COLA is pending a class action appeal decision, so I want to figure out the best case/worst case scenario.

Ultimately, I will use the present value of the pension when making my stock/bond portfolio allocation decision.

Thank you for your help.
__________________

__________________
nico08 is offline   Reply With Quote
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!

Old 02-18-2014, 08:58 AM   #2
Give me a museum and I'll fill it. (Picasso)
Give me a forum ...
HFWR's Avatar
 
Join Date: May 2005
Location: Lawn chair in Texas
Posts: 12,962
Net Present Value Calculator | Investopedia

Can also use NPV function in a spreadsheet.
__________________

__________________
Have Funds, Will Retire

...not doing anything of true substance...
HFWR is offline   Reply With Quote
Old 02-18-2014, 09:04 AM   #3
Recycles dryer sheets
 
Join Date: Feb 2010
Posts: 396
Thank you HFWR. But based on that Investopedia calculator, where/how do I include the COLA part of the pension?
__________________
nico08 is offline   Reply With Quote
Old 02-18-2014, 09:09 AM   #4
Give me a museum and I'll fill it. (Picasso)
Give me a forum ...
HFWR's Avatar
 
Join Date: May 2005
Location: Lawn chair in Texas
Posts: 12,962
Try this one instead...

Pension calculator
__________________
Have Funds, Will Retire

...not doing anything of true substance...
HFWR is offline   Reply With Quote
Old 02-18-2014, 09:20 AM   #5
Recycles dryer sheets
 
Join Date: Feb 2010
Posts: 396
Thank you HFWR. But that one has to do with the value of a survivor benefit for married people. I am single. I am having a hard time finding a calculator and an equation that will give me the present value of my pension both with and without a COLA.
__________________
nico08 is offline   Reply With Quote
Old 02-18-2014, 09:28 AM   #6
Give me a museum and I'll fill it. (Picasso)
Give me a forum ...
HFWR's Avatar
 
Join Date: May 2005
Location: Lawn chair in Texas
Posts: 12,962
Sorry, I'm actually supposed to be w*rking...

Try Graduated Annuities Using Excel | TVMCalcs.com

Or google "NPV of cola-adjusted pension"...
__________________
Have Funds, Will Retire

...not doing anything of true substance...
HFWR is offline   Reply With Quote
Old 02-19-2014, 08:57 AM   #7
Give me a museum and I'll fill it. (Picasso)
Give me a forum ...
HFWR's Avatar
 
Join Date: May 2005
Location: Lawn chair in Texas
Posts: 12,962
I'm posting a spreadsheet in the thread, so others can do a sanity check. Didn't think posting it here would cause any particular invasion of privacy or personal info.

DR% = discount rate, COLA% self-explanatory, and ER% is the "effective rate", derived by dividing DR by COLA ((1+DR)/(1+COLA))-1. Change DR to see the effect of different discount rates.

The data indicate the current age, and the pension payout for that year. Each following year is adjusted by the COLA%. Since no payments occur until age 60, those cells are zeroes. These cells can also be changed, and the changes will be reflected in the resulting NPV.

Note that things get weird if, say, you input a 1% DR and a 3% COLA. The numbers get really large, because the ER goes negative...
Attached Files
File Type: xls NPV.xls (28.0 KB, 12 views)
__________________

__________________
Have Funds, Will Retire

...not doing anything of true substance...
HFWR is offline   Reply With Quote
Reply


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

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are Off
Pingbacks are Off
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Calculating present value of a COLA'd pension David1961 FIRE and Money 11 08-19-2013 02:48 PM
Net Present Value of State Government Pension and Social Security Benefit nico08 FIRE and Money 19 08-22-2011 12:44 AM
Estimating "present value net worth" Nords FIRE and Money 71 06-07-2009 09:31 PM
Present value of Social Security Sam FIRE and Money 50 04-01-2007 10:53 PM
Present Value of Social Security Telly FIRE and Money 15 10-03-2006 12:10 PM

 

 
All times are GMT -6. The time now is 01:00 PM.
 
Powered by vBulletin® Version 3.8.8 Beta 1
Copyright ©2000 - 2017, vBulletin Solutions, Inc.