2 Replies Latest reply: Apr 13, 2017 11:14 AM by Akl Kallassi RSS

    Generating cash flow

    Akl Kallassi

      Hello,

      I have a set of data that looks like this

       

      Company NameDividendGrowth RateDiscount RateTerminal PeriodGrowth after Terminal Period
      ABC5$0.030.0430.02
      XYZ4$0.050.0440.03
      MNO6$0.020.0420.01

       

      What I am trying to do is a discounted cash flow model. I wan to generate the cash flows of each company for a number of years, let's say 6 years. My output should look like this:

      Companyyear 1year 2year 3year 4year 5year 6
      ABC5*(1.03)5*(1.03)^25*(1.03)^35*(1.03)^3*(1.02)5*(1.03)^3*(1.02)^25*(1.03)^3*(1.02)^3
      XYZ4*(1.05)4*(1.05)^24*(1.05)^34*(1.05)^44*(1.05)^4*(1.03)4*(1.05)^4*(1.03)^2
      MNO6*(1.02)6*(1.02)^26*(1.02)^2*(1.01)6*(1.02)^2*(1.01)^26*(1.02)^2*(1.01)^36*(1.02)^2*(1.01)^4

       

      How can I have  QLIK SENSE do that ??

      Thank you for the help !