ANNUITIES

Author: Stephen L. Nelson, CPA
Source: articledashboard.com

Curious, how much money you accumulate in your Roth retirement account? If you have Microsoft Excel you have (or just run on other popular spreadsheet program) to your computer, you can use the FV function to forecast the future value of your Roth IRA or Roth 401 (k). To change the FV function calculates the future value of an investment, given the interest rate, the number of payments, payment, the current value of investments, and, where appropriate, the type of pension. (For more information on the type-of-annuity switch a little 'later.) The function uses the following, variable annuities, syntax: = FV (rate, NPER, PMT, PV, type) This little bit complicated, I admit. But suppose you want the future value of an individual retirement account, it was already $ 20,000 in his play and are $ 400 per month to be calculated. Beside her sat the buoyancy account valuein future 25 years, we expect a year to 10% calculated interest.To to earn the future value of individual retirement account, in this case, the function of FV, type in a cell of spreadsheet type = FV (10% / 12.25 * 12, -400, -20000.0) Returns the value 771872.26roughly $ 772,000 handful dollars.A of things to note: the annual interest of 10% a monthly interest rate of conversion, the formula divides the annual interest rate of 12 may also convert the 25-year tenure ended in a month, multiply the formula 25, 12 Note also that the monthly payments and the initial values these show, variable annuities, negative amounts because they represented outflows. And the function returns the future value amount as a positive value because it reflects cash flow, in the end you get. The 0 at the end of the type of pension should be replaced. If you are the type-of-annuity switch to 1, Excel assumes payments occur at the beginning of the period (months) in this case, the pension, because after the convention. If you set the annuity switch to 0 or you omit the argument, Excel assumes payments occur at the end of the period following the annual convention of pensions.