Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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 !
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])
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?
On the front end or the backend of the application?
Front end
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?
You can have it in a table box object....
Can you please tell me the steps to do it?
Do you need a single rate for all transactions? or do you need the users to be able to enter different rates?
I want the user to be able to enter whatever rate he wants and this rate would apply to all transactions