payment - a
repeating field containing unequal payment amounts, or an
expression that returns a reference to one.
Use this function to calculate NPV. For example, if someone borrows money from you and pays you back in unequal amounts over a period of several years, you can use the
NPV function to calculate the result.
NPV(Loan;.05) returns
156.91277445..., when the repeating field, Loan, contains -2000 (the initial payment), 600, 300, 500, 700, and 400. The result (156.91277445...) is the actual profit in today’s dollars that will be realized from this transaction.
NPV(Amounts;.10) returns
16758.35604870..., when the repeating field, Amounts, contains -5000 (the initial investment), 10,000, 0, 10,000, and 10,000.