Discounted cash flow model

[#1]

Really new to Qlik Sense.

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

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

Example:

Company Name	Cash flow	Rate	Number of periods (n)	DCF
ABC	10	5%	5
XYZ	20	3%	10
MNP	15	2%	5

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

Please help !

[sunny_talwar]

Does that mean a single rate to all transactions regardless of company or any other dimension?

[#3]

yes

[#4]

How do i do this? I am working on qlik sense.

[sunny_talwar]

Oh my god... all this time... why didn't you mention that you were using Qlik Sense

May be use an extension for input box

Qlik Branch

[#6]

I am sorry.

I did find this extension but I am not knowing how to use it

[OmarBenSalem]

First thing, you put the extension under :

C:\Users\YourUser\Documents\Qlik\Sense\Extensions

and unzip it;

You'll find it here:

Then create your variable and initiate it with a value :

exp:

Then choose your extension, and configure it (put the name of your variable you want to update and work with vExtension):

[simondachstr]

Check the forum it has been posted in

[sunny_talwar]

Yes, I should have... 

[#10]

Thank you for your help. I did figure it out. I have one more question. I am using 3 input box for a table with 3 different columns. Each column is associated with one input box. Only 1 column is being updated when I change the values in the input box. How can I make it so that all of them change when I change the respective input box?