Hi,
I am trying to calculate IRR.
Here are my numbers, I Add Max_EIR and Sum_EIR into one so I can use the summarize IRR tool.
But I am expecting
0.002953
Does anyone know what I am doing wrong?
Hey @wonka1234,
Doing IRR on 4541291.81 in Excel gets an error, not sure how your getting 0.002953. Can you give an example file?
Thanks,
Ira
@IraWatt
doing an IRR calculation on these:
@wonka1234 I put this into Excel and still got error:
Ive attached the workbook can you show how you got 0.002953
Hi @IraWatt , @wonka1234
it seems to work in both Excel and Alteryx.
In Excel, a formula correction (include payment at the beginning of the time series) solves the problem:
If needed, increase number of iterations in Excel Options:
But: It also works in Alteryx (version 2022.1) using the Excel file @IraWatt created.
Best,
Roland
@RolandSchubert do i need my values in a column in alteryx to get correct IRR? getting 99999.
Im guessing I need a time series?
I am taking the IRR of EIR Re-Calc
Hi @wonka1234 ,
both is true, you need a time series, but your values in one column, starting with a payment, subsequent rows contain the returns .
The values have to be ordered ascending by time, an additional assumption is, that there are constant time intervals. In general, the Excel file @IraWatt created, represents a suitable format.
@Qiu Please help me Qiu!
