Charles

That is what I thought, but I was hoping for a simple calculation.

This is one of those projects in which I agreed to help out an investment club gratis, and it has turned into more of a learning experience than I thought.

Seeing as how I have had to use Excel objects for several other projects, I think I am well along on the learning curve. This will only add to it.

Thanks for your quick response.
Gaylen


>Hi Gaylen,
>
>What you are describing is an internal rate of return calculation, or IRR. There is no straight forward formula to compute IRR, you have to use an iterative approach.
>
>However, rather than trying to code the entire solution, you can create an Excel object and use either the IRR, MIRR or XIRR functions to solve for the internal rate of return.
>
>Hope this helps.
>Charles