NPV Function in Excel: Syntax, Examples and Free Practice
NPV is an Excel Financial function. Calculates the net present value of a series of cash flows.
NPV syntax
Arguments
rate: The interest rate per periodvalue1: The first valuevalue2: An additional value (optional)
When to use NPV
NPV is used in loan, investment, or valuation models where precise financial math is required.
Practice NPV online, free
Open the live Excel-style spreadsheet and try NPV yourself. No Excel install or sign-up needed to start.
Practice NPV now →More Financial functions
Frequently asked questions
What does the NPV function do in Excel?
Calculates the net present value of a series of cash flows.
What is the syntax of NPV in Excel?
The syntax is =NPV(rate, value1, [value2], ...). rate: The interest rate per period; value1: The first value; value2: An additional value (optional).
Where can I practice NPV online for free?
Open the free live spreadsheet on Cellgrids and try NPV yourself. No Excel install is needed and you can start without signing up.
All Excel formulas · Cheat sheet · Excel exercises · Financial functions · Excel case studies · Excel tutorials · Excel shortcuts