Net Present Value:

The program calculates the Net Present Value (NPV) of a cash flow. Cash inflows are positive numbers, while cash outflows are negative. This program is flexible and you can change the year of the cash flow. The NPV is displayed in the last cell in the table.

Fill in the fields

Year: Present Value:
Year: Future Value:
Year: Future Value:
Year: Future Value:
Year: Future Value:
Year: Future Value:
Year: Future Value:
Year: Future Value:
Year: Future Value:
Year: Future Value:
Year: Future Value:

Discount Rate (%)

Total NPV ($)

Using the Program

If you leave a cell blank, then a zero is entered into the calculation for that year. You cannot enter commas or dollars signs into the fields. The program does not understand them.

The following arithmetic operations can be inserted into any of the cells

  • Addition is +
  • Subtraction is -
  • Multiplication is *
  • Division is /
  • For example, entering 1000-10*10 into the amount of the loan results in 900.