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?
![]() |
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?
A relatively straight forward way is to use the time value of each addition:
A pretty good approximation of this is:
Whereis 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%.
All times are GMT -7. The time now is 11:47 AM. |