OK. Need additional clarity.

It seems what I am looking for is the compound annual growth rate but
it doesn't seem to work with my example. I don't think I want the
5-year average.

First - these are median averages for an entire year. What would be
best for using the XIRR formula? July 1, 200x?

Second - the XIRR expects at least one positive cash flow and one
negative (according to the MS help). I certainly have tracts that have
gained in every year and I get an error message for those.


--
James Hobart
------------------------------------------------------------------------
James Hobart's Profile: http://www.excelforum.com/member.php...o&userid=17540
View this thread: http://www.excelforum.com/showthread...hreadid=526223