 Download Latest Version
 Request KeyCode
 Training Videos
 FAQ's
 User Guides
 Tech Support
 Free Webinar Training
 Download Court Forms
 Modify Professional Listing
 Renew Subscription
Did You Know...
Family Law Software can calculate child support guideline amounts in 21 states.
Search all help content: 

Question: How can I tell if my pension valuation is right? Answer: Here's how you can get a ballpark sense of whether the result you are getting from the definedbenefit pension calculator is correct. Let's assume the following facts: Pension will pay $2,000 per month at retirement No Cost of living adjustment (that is, no COLA), just to keep it relatively simple. This means: Annual pension is $2,000 * 12 = $24,000. 1. Ballpark value at retirement date. In order to get a ballpark sense of the value at retirement, go to Excel or a Google Docs spreadsheet, and input the following formula: =PV(0.025,18,24000) This is asking for the present value of payments of $2,000 per month for 18 years using a discount rate of 2.5%. This gives a value of $344,480. The next step would be to discount this number back to the present, by multiplying by (1/(1.025)^15). If the first formula was in block A1, this formula would be: =A1*(1/(1.025)^15) You are just dividing by 1.025 to discount by 2.5% for each of the 15 years between now and the time the person turns age 65. The result this gives is $237,852. You then compare this to the software's result. Plugging these numbers in, and using the RP2000 table, I got a software result of $242,292. The software is also discounting for mortality, and is doing a much more sophisticated mortality table analysis. But this gives you a ballpark. Note that the date started in plan, and separation dates affect coverture, but they do not affect the plan's value. 