Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Generating cash flow

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 !

2 Replies
OmarBenSalem

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:

https://help.qlik.com/en-US/sense/3.1/Subsystems/Hub/Content/Scripting/FinancialFunctions/financial-...

Also check these:

A Financial Services Compass | Qlik

Cash Flow Statement (with Income Statement & Ba... | Qlik Community

Hope this helps,

Not applicable
Author

Hello,

Thank you for the help. I already looked at the links but I couldn't accomplish what I was trying to do.