How to calculate IRR

[#1]

Hello everyone

I am trying to figure out how to calculate the IRR (internal rate of return) using the data from Qlikview.

Here are the numbers

Investment - 1.875 mln

cash flows 1 - 200k

cash flows 2 - 233k

cash flows 3 - 233k

cash flows 4  -233k

cash flows 5  -233k

When I calculate it in excel, the number should be -14.55%.

I don't know how to create the formula in qlikview.

I think there is a rangesum formula involved at some point, but I am unsure.

Any help would be very much appreciated.

Thanks
Tom

[bbi_mba_76]

Hi,

could you explain which formula do you use in excel ?

[#3]

sure

It's just =IRR(investment data and cash flows)

-1,875,000.00

200,000.00

233,000.00

233,000.00

233,000.00

233,000.00

total is -14.59%

[Clever_Anjos]

QlikView has IRR function, just use it

=IRR(yourfield)

Be careful, your investments and cash flows must have opposite signs

[#5]

Thanks

but how to I translate the above information into what qlikview will calculate which is

IRR([Total[<fld{,fld}>]]value)

Thanks my problem

Thanks

Tom

[jvitantonio · Accepted solution]

Hi Thomas, it should work just like that.

As an example, load this in your script:

LOAD * INLINE [
    IRR
    -1875000
    233000
    233000
    233000
    233000
    200000
];

and then in a text box object put this formula:

=IRR(IRR)

[#7]

Thank you so much for this.

Tom

[ajaygcet]

Hello,

I just Want to know How IRR Function Calculation Works.