Hello,
I have a set of data that looks like this
| Company Name | Dividend | Growth Rate | Discount Rate | Terminal Period | Growth after Terminal Period |
|---|
| ABC | 5$ | 0.03 | 0.04 | 3 | 0.02 |
| XYZ | 4$ | 0.05 | 0.04 | 4 | 0.03 |
| MNO | 6$ | 0.02 | 0.04 | 2 | 0.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:
| Company | year 1 | year 2 | year 3 | year 4 | year 5 | year 6 |
|---|
| ABC | 5*(1.03) | 5*(1.03)^2 | 5*(1.03)^3 | 5*(1.03)^3*(1.02) | 5*(1.03)^3*(1.02)^2 | 5*(1.03)^3*(1.02)^3 |
| XYZ | 4*(1.05) | 4*(1.05)^2 | 4*(1.05)^3 | 4*(1.05)^4 | 4*(1.05)^4*(1.03) | 4*(1.05)^4*(1.03)^2 |
| MNO | 6*(1.02) | 6*(1.02)^2 | 6*(1.02)^2*(1.01) | 6*(1.02)^2*(1.01)^2 | 6*(1.02)^2*(1.01)^3 | 6*(1.02)^2*(1.01)^4 |
How can I have QLIK SENSE do that ??
Thank you for the help !
