Financial

NPV

Calculates the net present value of an investment by using a discount rate and a series of future payments and income.

Syntax
NPV(rate, value1, [value2], ...)
Usage Examples
See how this formula can be used in real-world scenarios, generated by AI.
AI Assistant

Ask me anything about Excel formulas!