18 Replies Latest reply: Apr 12, 2017 1:43 PM by Martin Mahler

# Discounted cash flow model

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 NameCash flowRateNumber of periods (n)DCF
ABC105%5
XYZ203%10
MNP152%5

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

• ###### Re: Discounted cash flow model

So you just want to calculate the present value of future cashflows.

Use Qlik's PV() function:

e.g. =PV([Rate],[Number of periods (n)],[Cash flow])

PV ‒ QlikView

• ###### Re: Discounted cash flow model

Thank you !

Is there a way to create a user input for the rate? That is, can i have a dynamic table that would show the PV and give me the option to change the rate?

• ###### Re: Discounted cash flow model

On the front end or the backend of the application?

• ###### Re: Discounted cash flow model

Front end

• ###### Re: Discounted cash flow model

Can I have one input box outside of the table to enter the interest rate and then all rows in the table uses that field?

• ###### Re: Discounted cash flow model

You can have it in a table box object....

• ###### Re: Discounted cash flow model

Can you please tell me the steps to do it?

• ###### Re: Discounted cash flow model

Do you need a single rate for all transactions? or do you need the users to be able to enter different rates?

• ###### Re: Discounted cash flow model

I want the user to be able to enter whatever rate he wants and this rate would apply to all transactions

• ###### Re: Discounted cash flow model

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

• ###### Re: Discounted cash flow model

yes

• ###### Re: Discounted cash flow model

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

• ###### Re: Discounted cash flow model

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

• ###### Re: Discounted cash flow model

I am sorry.

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

• ###### Re: Discounted cash flow model

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):

• ###### Re: Discounted cash flow model

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?

• ###### Re: Discounted cash flow model

Check the forum it has been posted in

• ###### Re: Discounted cash flow model

Yes, I should have...