Nonperiodic net present value from dated cash flows · Calculation guide

Value all signed receipts and payments on the first listed date.

Calculation guide

Later rows may share dates and use actual elapsed days divided by 365.

NPV = Σ cash(i)/(1+r)^((date(i)−date(0))/365)

Inputs

Effective annual discount rate (%)

Example entry 10 %. Allowed range -90.0 to 100.0.

Cash-flow date

Enter the calendar date in the date field.

Signed cash flow

Example entry -1000 (in the selected currency).

Worked example

InputValue
Effective annual discount rate (%)10%

Dated cash flows

Cash-flow dateSigned cash flow
2025-01-01-1,000
2026-01-011,100
ResultValue
Dated net present value-1.13687e-13

How each input affects this example

Each row starts from the worked example and changes one input.

InputOriginal inputNew inputAffected resultOriginal resultNew result
Effective annual discount rate (%)10%11%Dated net present value-1.13687e-13-9.009009
Cash-flow date (row 1)2025-01-012025-01-02Dated net present value-1.13687e-130.261158
Signed cash flow (row 1)-1,000-900Dated net present value-1.13687e-13100
Nonperiodic net present value from dated cash flows →

Sources