<P>Forecasting the Future Value of Your Roth-IRA or Roth-401(k)</p>

By:Stephen L. Nelson, CPA

Curious about how much money you'll accumulate in your Roth retirement account?

If you’ve 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 Roth IRA or Roth 401(k).

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 individual retirement account that’s already got $20,000 in it and to which you are contributing $400-a-month. Further suppose that you want to know the account balance—its future value—in 25 years and that you expect to earn 10% annual interest.

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

=FV(10%/12,25*12,-400,-20000,0)

The function returns the value 771872.26—roughly $772,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 you ultimately receive.

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.

Digg del.icio.us Blink Stumble Spurl Reddit Netscape Furl

Article keywords: roth, roth ira, roth 401(k), roth 401(k), retirement, investing

Article Source: http://www.articles2k.com

Stephen L. Nelson is the author of Quicken for Dummies and Do-It-Yourself Kits for LLC Formation & Limited Liability Company Incorporation for all fifty states. Formerly an adjunct tax professor at Golden Gate University—the nation’s largest graduate tax school—Nelson is a CPA in Seattle. Copyright © by 2006 by Stephen L. Nelson, CPA. Contact him at www.llcsexplained.com.

Top Personal Finance Articles
1). Dealing with The Stress of Debt! By : Paul Duxbury As the New Year begins many people resolve to address the problems caused by their debts. This article provides some insights into dealing with the stress of debts.
2). Forecasting the Future Value of Your 401(k) By : Stephen L. Nelson, CPA If you’ve 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 401(k) 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.
3). What Makes a Credit Score Rise or Fall? By : Nathan Dawson OUR financial decisions can affect your credit score in surprising ways. Two credit-scoring simulators can help consumers understand the potential impact.
4). Handling Your Money Effectively By : Mary Williams There is inflation every year. You cannot stop an increasing in living expenses as prices of consumer goods increasing all the time. Saving money becomes an extremely difficult task to do. Here are some solutions for saving a little so that you can still meet your needs and still find ways to trim off a little for the future. 1. Budget – Get one and stick with it! And set aside at least a small portion for savings while you’re at it; savings for your future, your retirement, your education, your vacation, whatever.
5). An Overview Of The Direct Deposit System By : Bob Benson Direct deposit is an excellent feature offered by many banks all around your area. Banking is supposed to be convenient and easy, it has been made that much easier and more convenient with the offering of direct deposits. When thinking about direct deposit, consider many of the things that could apply to you. Have you found yourself hurrying off to.
6). Post-Christmas Financial Difficulties By : Mike Hanna If you’ve spent more than your budget can cope with, then maybe you’re thinking about credit to help you through January. Many people fear the long, broke month of January. After a lovely Christmas full of joyous smiles January can see a mood swing in the wrong direction. Many of us turn to credit cards to help get through this terrible month. But without knowledge of the financial industry a person without a great income can fall victim to the evil grip of unscrupulous credit companies.
7). Boost your savings By : Bob Benson It is general knowledge that residents of the United Kingdom are typically not savers. They tend to spend much more than they save; according to studies, saving money is not as popular as it once was. Saving is extremely important to the quality of life you expect to live in the future. Think about it, what would happen if your car suddenly quit working?.
8). How To Get Personal Loans For People With Bad Credit By : Susan Dean Personal loans for people with bad credit are available. There are a number of opportunities for those who are looking for money that do not have the highest scores out there.
9). If You Want To Make Money: Avoid Debt! By : Rene Graeber Everybody starting in life should avoid running into debt. There is scarcely anything that drags a person down like debt. It is a slavish position to get ill, yet we find many a young man, hardly out of his "teens," running in debt. He meets a chum and says, "Look at this: I have got trusted for a new suit of clothes." He seems to look upon the clothes as so much given to him; well, it frequently is so, but, if he succeeds in paying and then gets trusted again, he is adopting a habit which will keep him in poverty through life.
10). Refinance With Help From The FHA By : Lorna Mclaren Refinance, Home Loan - The FHA can help...

New Personal Finance Articles
1). How To Consolidate Your Debt If You Are A Homeowner With Bad Credit By : Craig Thornburrow Different debt consolidation methods you can use if you are a home owner with bad credit.
2). Bargain Buys for You in the Wholesale Market By : james lowe If you buy lots of goods you can save big money by learning how to use wholesale markets
3). Gold Coins - An Investment in Your Financial Liberty By : Ricardy Banks When you have a child, or even before you do, start collecting gold coins. When your child grows up, cash them in to send your high school graduate to the University of their choice.
4). Estate Planning: The Gift that Keeps on Giving By : Robert Valentine Gifting is one of the many estate planning tools available.
5). Living Debt-Free By : Debbie Dragon Do you dream of living without the burden of excessive debt hanging over your head? It’s possible, but not easy. Living debt free requires financial discipline, all the time. To become debt free and maintain a debt free life, try the following three steps: 1. Get rid of existing debt. This is obviously your first step to living a debt free lifestyle.
6). Accountant By : Jason Gluckman An accountant is a person who manages financial issues, including the preparation of financial plans and budgets, as well as the management of accounts and staff welfare. In most countries, officially licensed accountants are recognized by titles. In the UK, they are termed as “chartered accountants.” In the U.S., accountants are commonly known as “certified public accountants,” whereas in Canada, they are either known as “certified management accountants” or “certified general accountants.
7). Roth 401k – New Retirement Savings Plan. By : Simon Fox Brand new employer sponsored retirement plan is a hybrid of a traditional 401k and a Roth IRA. Income tax rates have been cut, the marriage penalty done away with, and the "death tax" is also on a path to no more. All of this is a result of the Bush administration's Economic Growth and Tax Relief Reconciliation Act which was passed by a Republican congress in 2001.
8). Budget Backyard Family Vacations By : Cheryl Johnson When travel and lodging are cost prohibitive, you can still have a vacation right at home. Yes, in your own backyard. Many of us live within reasonable distance to museums, campgrounds, historic sites, and beautiful state parks. You might be surprised at what you find in your own local area. Do some research in your area to find free or low cost activities and sites to visit.
9). The Cost Of Talking By : blueboy With so many companies offering “the lowest call rates, and the best service" who do you believe and are there any additional costs hidden in the small print? Do they all give per second billing by email, full cost analysis, discounted BT line rental and personal account managers? On mobiles do they offer free connection, and line rentals from £4? There has never been a better time to review the cost of your telephone charges and the service you are getting.
10). Asking for a lot of money By : James C. Samans Most people dream of making a lot of money. The question is, what does that mean? The truth is that money is highly subjective. Certainly, a billion dollars is a lot of money; there are only a handful of billionaires in the world. Is a million dollars a lot? In terms of total wealth, no; a significant minority of the population has a million dollars or more in total assets to leave to their heirs, largely due to the appreciation of real estate.