Forecasting The Future Value Of Your IRA

Summary:
Curious about how much money you'll accumulate in your individual retirement account (IRA)? Just use Microsoft Excel to calculate a pretty good estimate says author and CPA Stephen L. Nelson.


Article Body:
If youve got Microsoft Excel (or just about any other popular spreadsheet program) running on your computer, you can use its FV function to forecast the future value of your IRA account.

The FV function calculates the future value of an investment given its interest rate,
the number of payments, the payment, the present value of the investment, and,
optionally, the type-of-annuity switch. (More about the type-of-annuity switch a little later.)

The function uses the following syntax:

=FV(rate,nper,pmt,pv,type)

This little pretty complicated, I grant you. But suppose you want to calculate the future value of an IRA account thats already got $10,000 in it and to which youre contributing $200-a-month. Further suppose that you want to know the account balanceits future valuein 25 years and that you expect to earn 10% annual interest.

To calculate the future value of the IRA account in this case using the FV function, you enter the following into a worksheet cell:

=FV(10%/12,25*12,-200,-10000,0)

The function returns the value 385936.13roughly $386,000 dollars.

A handful of things to note: To convert the 10% annual interest to a monthly interest rate, the formula divides the annual interest rate by 12. Similarly, to convert the 25-year term to a term in months, the formula multiplies 25 by 12.

Also, notice that the monthly payment and initial present values show as negative amounts because they represent cash outflows. And the function returns the future value amount as a positive value because it reflects a cash inflow the investor ultimately receives.

That 0 at the end of the function is the type-of-annuity switch. If you set the type-of-annuity switch to 1, Excel assumes payments occur at the beginning of the period (month in this case), following the annuity due 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 ordinary annuity convention.

Want to learn more? Check out "FINANCIAL FREEDOM: A Wealth Manual For The Middle Class" by Dr. Bryan Stoker free online at
http://www.autopilot101.com/free/book_FF/index.htm

And don't miss more than 770 ways to slash your bills with our online home study course, "MONEY SECRETS". Check it out at
http://www.autopilot101.com/free/book_MS/index.htm

 

 
Translate Page Into German Translate Page Into French Translate Page Into Italian Translate Page Into Portuguese Translate Page Into Spanish Translate Page Into Japanese Translate Page Into Korean

More Articles

 

 

Search This Site

 

Related Products And FREE Videos





 

More Articles


Do You Have A Plan For Sticking To Your Budget?

... Especially in the early days of sticking to your budget, it is important to re-train yourself to curb spending. Making a budget is really the easy part in financial management. It is sticking to the budget and making your spending match your plan that is the difficult process. By disciplining yourself and retraining your spending habits, you can achieve your budget goals. Want to learn more? Check out ... 

Read Full Article  


Basic Financial Information Tips (Part II)

... this within 60 days of the charge to preserve your rights and avoid negative credit, etc. Debit cards. If you, or someone else, uses your debit card, money is deducted from your checking account. For pre-authorized purchases (e.g. gasoline or motels) a hold is placed on your checking account, usually for an amount larger than the expected charge. This hold can cause other checks or charges to be returned ... 

Read Full Article  


Forecasting The Future Value Of Your 401(k)

... it and to which youre contributing $200-a-month. Further suppose that you want to know the account balanceits future valuein 25 years and that you expect to earn 10% annual interest. To calculate the future value of the 401(k) account in this case using the FV function, you enter the following into a worksheet cell: =FV(10%/12,25*12,-200,-10000,0) The function returns the value 385936.13roughly $386,000 ... 

Read Full Article  


Pay Off Credit Card Debt

... yourself loose on the path to another credit card debt. Most of the rules that you followed when you were trying to pay off credit card debt, will also hold good after you have paid off your credit card debt. Here is a quick synopsis of things that you should take care of even after you pay off credit card debt: 1) Do not overspend. Yielding to the sale offers for something that you don t really need, ... 

Read Full Article  


Convert To Roth IRA Regardless Of Income 2010

... be made after you pass the age of 59 years and six months. Second, you must have owned the Roth IRA for at least five years. If you meet this test, the money is yours free and clear including all the gains you have made from your investments over the years. The only criticism of Roth IRAs has to do with income caps. Simply put, a person with a modified gross adjusted income of $100,000 or more cannot ... 

Read Full Article