Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I am successfully using the NPV function for leases with flat payment structures (meaning for example 36 payments of $1,000). 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. 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:-
Begin End Rent AMT
1 12 1000
13 24 2000
25 36 3000
Does anyone have a methodology for calculating NVP on such a payment structure?
Many thanks.
Check out the following Help link, think this may be what you need in this case:
Regards,
Brett