Home | Product Overview | Screen Shots | Testimonials | Downloads/Purchase | Contact Us | Links Friday, May 09, 2008

Rate of Return Version 10/98

All Data Entry cells show up in red.

If you know the beginning balance of any of your investment accounts and the ending balance after a certain number of months, this calculator will tell you the rate of return you have achieved. For example: You have a mutual fund account that has $5,000 in it at the beginning of 1998. You have been adding to the account $100 monthly. The account balance at the end of 1998 was $7,000. This calculator will indicate that you experienced a 13.57% return in this account over the 12 month period.

Beginning Balance: Enter here the starting account balance from the beginning of the time frame you want to evaluate the rate of return.

Monthly Additions: If you have been adding to this account on a monthly basis, enter here the amount of monthly contributions being made. This calculator will not accommodate additions of any other frequency.

Number of Months in Period: If you are examining a one year period enter 12 (for 12 months in year) in this cell. If you are looking at a year and a half enter 18, etc.

Ending Balanced: Enter here the balance at the end of the examination period.

Your Annualized Return Over Specified Time Frame: This is the return you have achieved over the month you have indicated.

This calculator can be helpful when you receive a statement from your mutual fund family indicating your account balances a year ago relative to today. Keep in mind if you have made additions to the account, this changes the calculation. This calculator accommodates a systematic monthly addition. Additions of other frequencies will require a more sophisticated calculation.

Copyright 2004 Planningtemplates.com All Rights Reserved