Net present value (NPV) is used to estimate the profitability of projects or investments. You can calculate NPV in two ways using Microsoft Excel.

Investopedia contributors come from a range of backgrounds, and over 25 years there have been thousands of expert writers and editors who have contributed. Amy is an ACA and the CEO and founder of ...

Excel's MOD function doesn't have to be used to return a value—it can also be used to determine which cells should be formatted through conditional formatting.