XIRR FUNCTION

  • Thread starter Thread starter Lynndale
  • Start date Start date
L

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
 
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
 
pshepard said:
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
Click to expand...

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
 
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
 
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
 
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
 
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
 
Back
Top