15 Replies Latest reply: Aug 29, 2017 11:40 AM by Bassam Frem RSS

    XIRR aggregating the data

    Bassam Frem

      Hello everyone,

      Is it possible to calculate the XIRR for the each of the below loans in Qlik ?

      For example: what is the XIRR for Loan1 having princiapl value of 3500 and repaid in 4 instalment 1000 each (total repayment 4000, resulting in 500 of interest)?

       

      the key question on how to arrange the data in qlik to arrive for XIRR(-3500,1000,1000,1000,1000; then dates array) ?

       

      thank you

       

       

      LoanIDSerial#PrincipalPayment AmountDue Date
      Loan11350010001/1/16
      Loan12350010001/2/16
      Loan13350010001/3/16
      Loan14350010001/4/16
      Loan21400012001/1/17
      Loans2400012001/2/17
      Loan23400012001/3/17
      Loan24400012001/4/17