XIRR FUNCTION

[Lynndale]

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

 

[pshepard]

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]

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

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

 

[pshepard]

Hi Lynndale,

enter into cell A1: -83948.81
enter into cell A2: 84568.12
enter into cell B1: 4/1/2008
enter into cell B2: 4/30/2008
enter into cell A4: =XIRR(A1:A2,B1:B2,0.1)

Peggy

 

[Lynndale]

Peggy,
I don't want to appear dense, but isn't your response what I entered in my
last reply? If I didn't enter it correctly could you show me my error.
Thanks,
Lynndale

 

[pshepard]

Hi Lynndale,

You are using values in the formula:
=XIRR("-83948.81:84568.12",(4/1/6:2008/30/2008),0.1)

I am referring to cell addresses that have values:
=XIRR(A1:A2,B1:B2,0.1)

When I tried entering the formula they way that you show in your original
post, when I use double quotes around the values before the first comma, I
also get the Value error - I think it is because it sees the values as text
and needs numbers.

I also played around with the dates, and I was also able to replicate the
dates changing from 4/1/2008:4/30/2008, and Excel somehow managed to mix up
the numbers something like what you have - to 4/1/4:2008/30/2008 - I don't
know why.

I also did a search on XIRR, and found other postings, however none with a
similar way of creating the formula as your post, so as far as I can tell -
the function works when referencing cell addresses, not when entering values
themselves into the formula.

Thanks,
Peggy

 

[Lynndale]

Peggy,
Thank you for being so patience with me. I started out using the formula
function wizzard and the result was what I put in my first post. From then on
I tried to create and change the formula in the format of the wizzard . I
know your first reply referred to entering the date in cells but that didn't
click until your last reply. So when I did it like you told me it works.

Thanks again
Lynndale