The Motley Fool Discussion Boards

Previous Page

Investing/Strategies / Retirement Investing


Subject:  Re: Need Present value (?) calculation help Date:  1/14/2013  2:29 PM
Author:  BruceCM Number:  71250 of 78166

To answer your question, the PV calc is a little more difficult than just inputting the current annual payments, a discount rate and life expectancy years. This is because the military pension, unlike private pensions, is indexed for inflation, so the PMT part of the calc will be growing most of the future years. Hence, you'll have to use the Excel XIRR function or the uneven cash flow function on a finan