Calculating the “present value” of your money plays an important part in your retirement planning. Put in simple terms, the present value represents an amount of money you need to have in your account today to meet a future expense or a series of future cash outflows, given a specified rate of return.
Calculating Present Value
If you will need $200,000 in your account 10 years from now, the present value, or the amount you need to start with today, will change based on various assumed rates of return:
If you earn a 3% return, you’ll need $148,818 to start.At 4%, you’ll need $135,112.If you get a 5% return, you only need to start with $122,782.
You can do these calculations on an HP12C calculator app or any other financial calculator app that you can download to your smartphone or tablet. You can also find financial calculators online. Use these entries to do the calculations:
N (number of periods) = 10I (interest) = rate of returnPMT (periodic payment) = 0FV (required future value) = $200,000Then hit PV (present value) to solve for present value.
This simple present value calculation shows you that the higher the rate of return, the lower the amount needed today to fund your future expenses.
Retirement and the Unknown Time Horizon
Suppose you know that in order to live comfortably in retirement, you’ll need $20,000 per year in addition to your Social Security income. How much do you need to save to provide the $20,000 a year? A present value calculation gives you the answer. To do this calculation, you now have two unknown variables: the rate of return and your longevity. The table below shows the respective present values taking both variables into account. In the table, you see the range of results:
If you live for 20 years and can earn a 5% rate of return, you’ll need $261,706 to provide you with $20,000 per year.If you live 30 years and earn a 3% rate of return, you’ll need $403,769.
If your family and personal health history indicate that you may have a long life expectancy, you’ll need to save more and/or work longer than someone with a shorter one. Start by adding up your anticipated annual expenses. Then, subtract out your anticipated fixed sources of income such as Social Security, determine how long you think you could live, and calculate the present value of that stream of expenses. Compare that to what you now have saved—or what you think you’ll have saved by your retirement date—and you’ll have a rough idea of whether you’re on track or not for your savings goal.
An Annuity Investment Example
Suppose, for example, that you want to guarantee that you’ll receive $2,000 each month ($24,000 per year) in retirement on top of your Social Security income. You decide that you want a conservative investment, so you choose to invest money into an annuity that will make payments each month to you for the rest of your life once you retire. Assume that your annuity grows at a rate of 3.5% annually. You would need to deposit $456,858 today (present value) in exchange for the security of your $2,000 monthly payment for 30 years. By choosing higher-risk investments, you could earn a higher return on your money, but this deal may sound great to you if you value a low-risk investment and anticipate living a long life.
Other PV Applications
There are a number of ways you can apply present value calculations to your retirement planning.
Calculating Present Value in Excel
When using a Microsoft Excel spreadsheet, you can use a PV formula to do the calculations for you. The formula menu has a PV function with an interface that will ask you for the rate, total number of payments, amount of payment, future value, and whether payments should be applied at the beginning or end of a period.
Present Value of Your Social Security Benefits
Present value calculations are the best way to compare one Social Security claiming choice to another. Many online Social Security calculators use this methodology and do the calculations for you. That can help you see which choice would be worth more to you over your expected lifetime.
Present Value of Pension Options
A present value calculation is also an effective way to compare different pension choices. If you anticipate a long life expectancy, one option may be worth more to you in terms of present value than another option. If you are married, you ought to consider joint life expectancy in your calculations.
