Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
XIRR FUNCTION
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
XIRR FUNCTION
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 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#7
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
XIRR Function - #NUM error | Excel Worksheet Functions | |||
XIRR - Function Missing | Excel Discussion (Misc queries) | |||
Please help for FV and XIRR function. | Excel Worksheet Functions | |||
xirr function | Excel Worksheet Functions | |||
XIRR function | Excel Worksheet Functions |