|
|
|
date: Tue, 8 Jul 2008 16:14:00 -0700,
group: microsoft.public.excel.worksheet.functions
back
RE: XIRR FUNCTION
"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
date: Wed, 9 Jul 2008 10:22:00 -0700
author: Lynndale
RE: XIRR FUNCTION
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" wrote:
>
>
> "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
date: Wed, 9 Jul 2008 10:50:00 -0700
author: pshepard
RE: XIRR FUNCTION
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" wrote:
> 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" wrote:
>
> >
> >
> > "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
date: Wed, 9 Jul 2008 19:20:00 -0700
author: Lynndale
RE: XIRR FUNCTION
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" wrote:
> 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" wrote:
>
> > 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" wrote:
> >
> > >
> > >
> > > "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
date: Wed, 9 Jul 2008 22:51:00 -0700
author: pshepard
RE: XIRR FUNCTION
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
"Lynndale" wrote:
> 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" wrote:
>
> > 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" wrote:
> >
> > >
> > >
> > > "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
date: Thu, 10 Jul 2008 16:03:01 -0700
author: Lynndale
|
|
