Find all NPV functions

Find all NPV functions

NPV is a common function used in Financial Models and it often is the key deciding number. However, there are a number of typical errors users make when using it including:

  • including period 0 in the values (should be from period 1 and add back period 0)
  • using inconsistent periods (e.g. cash flows go from months to years along the way)
  • Not including the cash flows all the way to the end.
Note: if you have stumbled onto this page it would be best if you started at the beginning

Below a video clip explaining what this test in Spreadsheet Professional means


Purchase Spreadsheet Professional


Back to: Auditing an Excel spreadsheet > Prioritise which formula to look in for errors