https://community.qlik.com/t5/QlikView/NPV-calculation-with-irregular-Step-payments/m-p/1611007#M597010 <P>I am successfully using the NPV function for leases with flat payment structures (meaning for example 36 payments of $1,000).&nbsp; However, some leases have irregular payments which increase/decrease or have balloon payments at the start or the end, and it is not clear how the NPV can be calculated for them.&nbsp; The input data is based on the start and end of a particular payment level, so if year 1 is $1,000, year 2 is $2,000 and year 3 is $3,000 a monthly payment plan would be specified as so:-</P><P>Begin &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; End &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp; Rent AMT</P><P>1 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 12 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 1000</P><P>13 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp; 24 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp; 2000</P><P>25 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 36 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 3000</P><P>Does anyone have a methodology for calculating NVP on such a payment structure?</P><P>Many thanks.</P> Sat, 16 Nov 2024 20:17:45 GMT Toxteth_OGrady 2024-11-16T20:17:45Z https://community.qlik.com/t5/QlikView/NPV-calculation-with-irregular-Step-payments/m-p/1611007#M597010 <P>I am successfully using the NPV function for leases with flat payment structures (meaning for example 36 payments of $1,000).&nbsp; However, some leases have irregular payments which increase/decrease or have balloon payments at the start or the end, and it is not clear how the NPV can be calculated for them.&nbsp; The input data is based on the start and end of a particular payment level, so if year 1 is $1,000, year 2 is $2,000 and year 3 is $3,000 a monthly payment plan would be specified as so:-</P><P>Begin &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; End &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp; Rent AMT</P><P>1 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 12 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 1000</P><P>13 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp; 24 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp; 2000</P><P>25 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 36 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 3000</P><P>Does anyone have a methodology for calculating NVP on such a payment structure?</P><P>Many thanks.</P> Sat, 16 Nov 2024 20:17:45 GMT https://community.qlik.com/t5/QlikView/NPV-calculation-with-irregular-Step-payments/m-p/1611007#M597010 Toxteth_OGrady 2024-11-16T20:17:45Z https://community.qlik.com/t5/QlikView/NPV-calculation-with-irregular-Step-payments/m-p/1617202#M597011 <P>Check out the following Help link, think this may be what you need in this case:</P> <P><A href="https://help.qlik.com/en-US/qlikview/April2019/Subsystems/Client/Content/QV_QlikView/Scripting/FinancialAggregationFunctions/XNPV.htm" target="_blank">https://help.qlik.com/en-US/qlikview/April2019/Subsystems/Client/Content/QV_QlikView/Scripting/FinancialAggregationFunctions/XNPV.htm</A></P> <P>Regards,<BR />Brett</P> Tue, 27 Aug 2019 15:38:44 GMT https://community.qlik.com/t5/QlikView/NPV-calculation-with-irregular-Step-payments/m-p/1617202#M597011 Brett_Bleess 2019-08-27T15:38:44Z