NPV

FINANCE.NPV

FINANCE.NPV(rate, cashflows...)

Calculates the net present value of an investment, based on a supplied discount rate, and a series of future payments and income.

• rate: Discount rate of the investment over one period.
• cashflows: Comma-separated list of future cashflows.