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

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%.