- How to Calculate Pension Liability
- Tax Deduction Values for Clothing and Household Items
- Comparison of a Return on Investment & Net Present Worth
- How to Figure Out How Long It Takes an Investment to Grow
- How to Determine the Net Income for Stock Equity Statements
- How to Calculate Net Present Values of a Certificate of Deposit Using Excel
Calculating the net present value of a future pension is just like calculating the present value of any other income stream. It can be done with a pen and paper, but a calculator and/or spreadsheet software like Microsoft Excel can make the process easier. The only other necessary items are a few important formulas and items of information.
Present Value Introduction
Present value calculations are a way to take an amount of money or a series of payments which are due to you in the future and determine how much money that income is worth today. For a pension plan, two main steps are involved: First, you'll calculate the total value of the pension plan at the time it will begin, which is your retirement age. Then you'll discount that amount of money to the present.
To calculate the value of the pension at the time you retire, determine with the annualized payments the pension sends. If you have the yearly payment, that's all you need. If you have a monthly payment, multiply by 12, or multiply a quarterly payment by 4, and so on. We'll call this number PMT, which is short for "payment." After that, you'll calculate the number of years you expect the pension to pay out: For example, if you plan to retire at 65 and you estimate that you'll live to about 80, use 15. This number will be called "n." Finally, you'll find a discount rate for the money. If you don't have the rate of return of the pension fund, estimate with a few different rates to build an idea of the present value under varying rate scenarios. This number will be identified as "r." Finally, you'll plug all these numbers into the present value formula: Present value = PMT * [ 1 - (1 + r) ^ -n ] / r
Net Present Value
The number found in the last section is the present value of the pension at the time you retire. Next, you'll discount this amount back to your current age. The formula is simple: Net present value = CF/[(1 + r) ^ n] -- where CF, or "cash flow," is the final number from the last section's calculation. This formula accounts for the number of years you have left until you retire and the pension begins to pay out.
Importance of NPV
The net present value of a pension or any other stream of income is an important tool to calculate how an income stream's value in current dollars. Net present value accounts for the fact that the money is spread out over several years and could be invested and paying a return in that time period.
- Photodisc/Photodisc/Getty Images