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
| Input | Value |
|---|---|
| Effective annual discount rate (%) | 10% |
Dated cash flows
| Cash-flow date | Signed cash flow |
|---|---|
| 2025-01-01 | -1,000 |
| 2026-01-01 | 1,100 |
| Result | Value |
|---|---|
| Dated net present value | -1.13687e-13 |
How each input affects this example
Each row starts from the worked example and changes one input.
| Input | Original input | New input | Affected result | Original result | New result |
|---|---|---|---|---|---|
| Effective annual discount rate (%) | 10% | 11% | Dated net present value | -1.13687e-13 | -9.009009 |
| Cash-flow date (row 1) | 2025-01-01 | 2025-01-02 | Dated net present value | -1.13687e-13 | 0.261158 |
| Signed cash flow (row 1) | -1,000 | -900 | Dated net present value | -1.13687e-13 | 100 |
