topic Re: How to calculate IRR in QlikView

How to calculate IRR

Tue, 08 Oct 2013 16:06:30 GMT

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

Re: How to calculate IRR

bbi_mba_76 — Tue, 08 Oct 2013 16:10:29 GMT

Hi,

could you explain which formula do you use in excel ?

Re: How to calculate IRR

Tue, 08 Oct 2013 16:15:36 GMT

sure

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

-1,875,000.00

200,000.00

233,000.00

total is -14.59%

Re: How to calculate IRR

Clever_Anjos — Tue, 08 Oct 2013 16:30:58 GMT

QlikView has IRR function, just use it

=IRR(yourfield)

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

Re: How to calculate IRR

Tue, 08 Oct 2013 16:36:20 GMT

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

Re: Re: How to calculate IRR

jvitantonio — Tue, 08 Oct 2013 17:00:20 GMT

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)

Re: Re: How to calculate IRR

Tue, 08 Oct 2013 17:05:22 GMT

Thank you so much for this.

Tom

Re: How to calculate IRR

ajaygcet — Wed, 12 Feb 2014 11:28:47 GMT

Hello,

I just Want to know How IRR Function Calculation Works.