Assume dates in Column A:
1-Jan-07
1-Feb-07
1-Mar-07
1-Apr-07
1-May-07
1-Jun-07
1-Jul-07
1-Aug-07
1-Sep-07
1-Oct-07
1-Nov-07
1-Dec-07

Assume Dollars in Column B:
-100
10
10
10
10
10
10
10
10
10
10
10


=XIRR(B1:B12,A1:A12,0.1)
=21.43%

Regards,
Ryan--


--
RyGuy


"Don Guillett" wrote:

Look in the help index for XIRR and MIRR

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"monkeytrader" wrote in message
...
thanks in advance for your help.
i wanted to know if there is a function in excel that can calculate an
annual rate of return on reinvestments.
specifically: over a 1 year (12month) timeline. i need to figure out
what
the annual return rate is if i start with $100 and make $10 every month,
but
withdrawl the $10 in profit every month.

ex) january - $100 initial investment with $10 profit
withdrawl the $10 in profit so february - $100 initial investment and
$10 profit.
etc, etc.

end of year i have $120 in profit plus the $100 inital investment.

is there a function in excel that i can use to calculate my annual
reinvested rate of return?

thanks.