Forecasting The Future Value Of Your Roth-IRA Or Roth-401(k)
Summary:
Curious about how much money you'll accumulate in your Roth-IRA or Roth-401(k)? Just use Microsoft Excel to calculate a pretty good estimate says author and CPA Stephen L. Nelson.
Article Body:
Curious about how much money you'll accumulate in your Roth retirement account?
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 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 thats already got $20,000 in it and to which you are contributing $400-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 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.26roughly $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.
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
More Articles
Forecasting The Future Value Of Your 401(k)
Free Money For Your Retirement?
In Debt Over Your Head? These 5 Simple Steps Will Help
5 Super Wealth-Building Tips Pave The Way To Financial Freedom
7 Quick Cash Fixes To Recover From A Money Emergency
Related Products And FREE Videos
More Articles
TAKE CHARGE OF YOUR FINANCES: TIPS ON BUDGETING
... you use your income and empower you on your economic stability as a working individual. Your source of income, lifestyle, spending habits, current job and house location, cost of living, payables and loans determines your level of budgeting needs. Starting to take charge of your finances is one sure way of becoming successful in a field of self-fulfillment and success. The following tips and recommendations ...
... a year $2400 in five years .plus interest. See what I mean it really IS the little things and you still eat lunch everyday AND that was only one place to save money in your daily living without doing without one thing you really need. There are a lot of places to cut expenses if you look for them. Set some specific long term and short term goals. There are no wrong answers here. If it s important to ...
Thinking About Buying A Vehicle?
... much money do you have to spend for a vehicle which will fit comfortably within your budget? Thats right! Can you afford to add a monthly payment to your budget for a vehicle? If so, how much can you afford to spend without creating problems with your finances. Think about it, and make the decision which will be right for you. 2) After you make the decision to purchase a vehicle, determine what you ...
5 Crucial Home Business Tips To Realize Financial Freedom
... Even if it's in the corner of another room, block its view with office sectional walls or some type of barrier wall to give a sense of privacy. An office should be just an "office" and nothing else. When you arrive at your office, you're ready for work. When you leave the office space, the workday is over. 3. Get Organized Once you have a defined work area for your home business, fill it with supplies ...
7 Quick Cash Fixes To Recover From A Money Emergency
... end of your driveway. You can make a quick $300 this way with very little time and effort. Budgeting Tip #5: If you have a larger item to sell, call into the local radio stations to see if they have a call in swap show on the weekends. This is a very popular way to quickly convert gently used and more expensive items to fast cash. Budgeting Tip #6: Another quick option is with utility and telephone ...