"pshepard" wrote:

Hi Lynndale,

With:

-83948.81 in cell A1
84568.12 in cell A2
4/1/2008 in cell B1
4/30/2008 in cell B2

=XIRR(A1:A2,B1:B2,0.1)

equals 9.69%

The dates in your formula are not clear.

Thanks
Peggy

"Lynndale" wrote:

USING THE FINANCIAL FUNCTION i AM TRYING TO CALCULATE THE ANNUAL RATE OF
RETURN FOR THE LAST QUARTER FOR A FUND. FILLING IN THE ARGUMENTS FOR THE
FUNCTION i GET THE FOLLOWING
"=XIRR("-83948.81:84568.12",(4/1/6:2008/30/2008),0.1)" THE FIRST VALUE IS THE
BEGINNING MARKET VALUE AND THE SECOND VALUE IS THE ENDING MARKET VALUE WITH
THE CORRESPONDING DATES.

COULD SOMEONE SHOW WHAT I AM DOING WRONG?

tHANKS

Thanks Peggy,
I thought I entereded the formula as you
suggested"=XIRR("-83949.81:84568.12",4/1/2008:4/30/2008,0.1)" but when I
pressed enter I got"=XIRR("-83949.81:84568.12",4/1/4:2008/30/2008,0.1)
VALUE ERROR" There seems to be a problem with the dates? Could you give me
an example as of how you entered the formula to get the result you did?
Thanks
Lynndale