XIRR from calculated values

Hi,

Could you send me the equation, and the link to your webpage to check it in detail, please?

Best regards.

the calculator is at https://www.SourceEO.com You have to select some measures on the glorious custom code you did for me in order to get any calculated results at the bottom…And Yes I know it runs slow. I’ll work on that later…

.
I started with the example equation when you select the XIRR function:
XIRR([-10000,2000,2500,5000,1000],[’01/01/2001′, ’01/02/2001′, ’03/15/2001′, ’05/12/2001′, ’08/10/2001′],10) which worked; returning the expected value of 0.1948184751.

I tried substituting a fieldname directly for the first number. I tried these permutations: “fieldname223, -fieldname223, -1*fieldname223, and -1*(fieldname223) . All gave a null result.

Hi,

Pay attention there are a typo error in your equation: specifically in ’01/01/2006,’

There is a comma symbol as part of the date.

Best regards.

fixed that but the problem persists. I pre-selected a couple of measure so you don’t have to wait through that. The full text I inputted is:
.
XIRR([-1*fieldname270,fieldname270/10,fieldname270/10,fieldname270/10,fieldname270/10,fieldname270/10,fieldname270/10,fieldname270/10,fieldname270/10,fieldname270/10,fieldname270/10],[’01/01/2001′, ’01/01/2002′, ’01/01/2003′, ’01/01/2004′, ’01/01/2005′, ’01/01/2006′, ’01/01/2007′, ’01/01/2008′, ’01/01/2009′, ’01/01/2010′],10)

Hi,

First, in your equation there are not a correspondence between the number of entries in the cash flow array (the first parameter), and new number of dates (the second parameter), furthermore, in your form the value by default of the fieldname270 is zero.

Best regards.

I must be missing something. The value of fieldname270 is $513,000 at the start. The label is “ACTUAL NET Project Cost Maximum CONSERVATIVE” and there are ten each of cash flows and dates in the array.

Hi,

As I said previously, the number of items in the cash flow array, and the number of items in the second array are different, and the default value o the fieldname270 is zero.

After correct the number of items in both arrays, and replace the text fieldname270 by 513000, the result of the operation is -0.020559652250773372

Please, check the equations in your form.

Best regards.

you keep syaing they’re not equal I counted. I copied and transpose paste into an excel file just to make sue I have an equal number. I do. It’s 10. There are ten payments, and ten dates. And if you look at the page at https://www.SourceEO.com, you can plainly see that the value (which is a calculated value is at $513,000 with the default inputs (I changed them after the first post by selected a couple of measures to come up already checked.) I truly appreciate your continuing to look at this but it would be helpful if you were to say, “I count 72 dates and sixteen payments. There’s your problem” instead of just, “They’re unequal.” They ARE equal.

I just counted them again from the list I pasted above. Ten each. What am I missing? Perhaps the first date s the date of the initial investment, and so there should be an additional payment?

Hi,

There are eleven elements in the cash flow array, and ten elements in the date array, furthermore you have a typo in the current equation, has been removed the last right parenthesis “)”

Please, follows the steps below:

1. Go to your form settings.

2. Select the “Internal Rate of Return (IRR)” field.

3. Untick the option: “Optimize Form Equations”

4. Enter the following equation:

XIRR([-1*fieldname270,fieldname270/10,fieldname270/10,fieldname270/10,fieldname270/10,fieldname270/10,fieldname270/10,fieldname270/10,fieldname270/10,fieldname270/10],['01/01/2001', '01/01/2002', '01/01/2003', '01/01/2004', '01/01/2005', '01/01/2006', '01/01/2007', '01/01/2008', '01/01/2009', '01/01/2010'],10)

and that’s all.
Best regards.

OK thanks. I thought the first element in the cash flow was not counted among the payments; that’s why I was coming up with ten.