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 !

[simondachstr]

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

[#3]

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?

[sunny_talwar]

On the front end or the backend of the application?

[#5]

Front end

[#6]

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?

[sunny_talwar]

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

[#8]

Can you please tell me the steps to do it?

[sunny_talwar]

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

[#10]

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