Pecoflyer:

My problem is that the XIRR function requires a negative value as part of data in formula, and I have no negative values in the tables in which I need to calculate a CAGR ..I will post attachment again with calculation included.
See this website: http://office.microsoft.com/en-us/excel-help/xirr-HP005209341.aspx?CTT=5&origin=HP001122506...
Thanks sooo much, I need an expert here. MMM