Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi all.
To see my point better, refer to this site:
FIRST
The example shown is wrong. The calculation way is wrong. The result is wrong.
They are all wrong for the same reason.
This example in the help menu must be reviewed and temporally hidden. It is confusing people.
Cashflow:
LOAD 2013 as Year, * inline [ ///it’s wrong, last date’s year is 2014
Date|Discount|Payments
2013-01-01|0.1|-10000
2013-03-01|0.1|3000
2013-10-30|0.1|4200
2014-02-01|0.2|6800
] (delimiter is '|');
The function is: Xnpv(Discount, Payments, Date). Net Actual Value of a rent
If I do that with a fixed interest, discount of 10%, that is 0.1, the result is 2967.63 $.
If I do it in excel with the same parameters (VNA.NO.PER), the result is also 2967.63 $.
In the example, it says -3164.35 $. Its wrong, it can’t be negative. If the interpretation is ‘read it positive’, it’s wrong too because the last payment has a bigger discount therefore the actual net value is smaller.
In any case its wrong and needs to be reviewed or maybe explained, for me to understand.
SECOND
The question is:
Is the first parameter of the XNPV function a field or a constant?
Xnpv(Discount, Payments, Date)
If I do it with a constant it works. Otherwise it does not.
Please, please, please, review the help menu.
Please, tell me if it is possible to calculate this function with a variable discount rate
Thank you very much to everyone who has read this post.
Thank you very much to the workers of the community and help menu.
Thank you very much to those who I haven’t mentioned before.
Nobody?
The discount rate must be a unique value (the same way Excel would work)
When you have multiple discount rates the calculation is more complex; not sure how easily it can be done in Qlik Sense
See here: https://www.excelforum.com/excel-general/822608-npv-help.html