18 Replies Latest reply: Apr 12, 2017 1:43 PM by Martin Mahler RSS

    Discounted cash flow model

    Akl Kallassi

      Really new to Qlik Sense.

       

      I am creating a discounted cash flow model. That is, I want to be able to perform this calculation:

      Discounted Cash Flow (DCF)

      All cash flows are equal and given ,as well as the discount rate.

      Example:

      Company NameCash flowRateNumber of periods (n)DCF
      ABC105%5
      XYZ203%10
      MNP152%5

       

      How can I apply the formula above to the given information ?

       

      Please help !