ExcelFlux

NPV function

the net present value of an investment based on a series of periodic cash flows and a discount rate.

Financial

Where can you use it?

Budgeting, treasury and finance teams. When reviewing a scenario with cash flows, payment periods and rate assumptions, compare the input and output units in the example.

Scenario in the workbook

Discount end-of-period cash flows. The first amount is received one period from now.

A worked example from the workbook

RowABC
6InputCriterionAmount
70100200
80.1110121
90025
Record 1
=NPV(A7,B7,C7)

Expected result300

See the inputs and instructions for all 3 examples

Copyable formulas

English Excel · en-US
=NPV(0,100,200)
Turkish Excel · tr-TR
=NBD(0;100;200)

Expected result

300

Worked examples

Discount end-of-period cash flows. The first amount is received one period from now.

Open the English sheet. Inputs begin at A6. F7:F9 show the live results and G7:G9 show the original results for comparison.

Row A B C
6 Input Criterion Amount
7 0 100 200
8 0.1 110 121
9 0 0 25
Case Formula Expected result
Record 1 =NPV(A7,B7,C7) 300
Record 2 =NPV(A8,B8,C8) 200
Record 3 =NPV(A9,B9,C9) 25
Microsoft Excel reference