rate of return -excel
"Ron Rosenfeld" wrote:
On Sat, 6 Jun 2009 19:19:01 -0700, Totonno
wrote:
My cash payments are not regular and are not equal. I prepared an excel spreadsheet applying an interest rate on a trial and error basis to come to a predetermined future value. It's very tedious and I thought there may be a quicker way.
Totonno
OK. You first wrote only that your cash payments are not equal, in which case
the IRR function would be appropriate.
If they are also not regular, you can use the XIRR function.
--ron
Thanks, I will try that.
|