Ask Experts Questions for FREE Help !
Ask
    dankelly79's Avatar
    dankelly79 Posts: 1, Reputation: 1
    New Member
    		  
    #1

    Jul 3, 2007, 12:53 PM
    Annual rate of return
    How do I calculate annual rate of return for an account for which I have added deposits during the year? What formula should I use?
    ebaines's Avatar
    ebaines Posts: 12,131, Reputation: 1307
    Expert
    		  
    #2

    Jul 4, 2007, 06:09 AM
    A relatively straight forward way is to use the time value of each addition:


    A pretty good approximation of this is:

    Where is the percentage of the year that has been in the account.

    While this is not exact, it's awfully close, especially if the magnitudes of the additional investments are relatively small compared to the original investment.

    Here's an example:

    If you start the year with $100, and add $25 each on March 31, June 30 and Sep 30, and the account finishes the year values at $225, the average return is approximately:

    (225-100-25-25-25)/(100+.75*25 +.50*25 + .25*25) = $50/(100+18.75+12.5+6.25)
    = $50/$137.5 = 0.3636

    So, you made an average return of 36.4%.
Not your question? Ask your question View similar questions
 

Question Tools Search this Question
Search this Question:

Advanced Search

Add your answer here.


Check out some similar questions!

Calculating Annual rate of return [ 1 Answers ]

What is the annual rate of return on an investment in a common stock that cost $40.50 if the current dividend is $1.50 and the growth in the value of the shares and the dividend is 8 percent?

Rate of Return [ 2 Answers ]

Would the normal rate of return be the same in all industries? Would it change over time?

Calculating Annual Return on Investment w/ additional monies added. [ 2 Answers ]

I’m trying to calculate my annual rate of return on an investment where I added additional money during the year. For example, let’s say at the beginning of the year my account had $1000. On the last day of the year the account balance was $1500. However, during the year I added $200 to the...

Annual return calculation [ 0 Answers ]

How do I link the annual return to get a 3 yr annual return in excel? For example 2006 - .7911 2005 - 10.6301 2004 - 12.8057 2003 - 1.7170

View more questions Search