Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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 !
Hi Akl,
Well I can't really help you with that but
There are a couple of financial functions available in Qlik Sense out of the box, e.g.
- BlackAndScholes Model
- FV/PV/PMT/Rate/nRate calculations
You can read more about them here:
Also check these:
A Financial Services Compass | Qlik
Cash Flow Statement (with Income Statement & Ba... | Qlik Community
Hope this helps,
Hello,
Thank you for the help. I already looked at the links but I couldn't accomplish what I was trying to do.