Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Highlighted
Not applicable

How to calculate IRR

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

Tags (2)
1 Solution

Accepted Solutions
Luminary
Luminary

Re: Re: How to calculate IRR

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)

View solution in original post

7 Replies
Partner
Partner

Re: How to calculate IRR

Hi,

could you explain which formula do you use in excel ?

Not applicable

Re: How to calculate IRR

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%

Employee
Employee

Re: How to calculate IRR

QlikView has IRR function, just use it

=IRR(yourfield)

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

Not applicable

Re: How to calculate IRR

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

Luminary
Luminary

Re: Re: How to calculate IRR

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)

View solution in original post

Not applicable

Re: Re: How to calculate IRR

Thank you so much for this.

Tom

ajaygcet
New Contributor II

Re: How to calculate IRR

Hello,

I just Want to know How IRR Function Calculation Works.