Step 4
Step 4: NPV Calculator
Discounting & NPV
NPV = Σ (Benefitsₜ − Costsₜ) / (1 + r)ᵗ, summed over every year t of the time horizon.
r = discount rate · t = year (0 = start year) · DF = discount factor 1/(1+r)ᵗ · Net Avg = average of From and To benefits minus costs for the year, discounted · Cum NPV = running total of Net Avg.
Set in Step 1
NPV Avg
€0
NPV From-To
€0 – €0
BCR
0.00
IRR
10.0%
Payback (yrs)
—
Cumulative NPV (From–To range)
Year 1 includes the one-off implementation costs; later years only carry recurring operation costs and benefits. If you change Step 3 later, click "Update from Step 3" or use the fill-down button to copy a year to all following years. You can also edit any year directly, e.g. for benefits that only start in a later year.
| Year | Implementation Costs From | Implementation Costs To | Operation Costs From | Operation Costs To | Benefits From | Benefits To | DF | Net Avg | Cum NPV | |
|---|---|---|---|---|---|---|---|---|---|---|
| 2025 | 1.000 | €0 | €0 | |||||||
| 2026 | 0.976 | €0 | €0 | |||||||
| 2027 | 0.952 | €0 | €0 | |||||||
| 2028 | 0.929 | €0 | €0 | |||||||
| 2029 | 0.906 | €0 | €0 | |||||||
| 2030 | 0.884 | €0 | €0 | |||||||
| 2031 | 0.862 | €0 | €0 | |||||||
| 2032 | 0.841 | €0 | €0 | |||||||
| 2033 | 0.821 | €0 | €0 | |||||||
| 2034 | 0.801 | €0 | €0 | |||||||
| 2035 | 0.781 | €0 | €0 | |||||||
| 2036 | 0.762 | €0 | €0 | |||||||
| 2037 | 0.744 | €0 | €0 | |||||||
| 2038 | 0.725 | €0 | €0 | |||||||
| 2039 | 0.708 | €0 | €0 | |||||||
| 2040 | 0.690 | €0 | €0 | |||||||
| 2041 | 0.674 | €0 | €0 | |||||||
| 2042 | 0.657 | €0 | €0 | |||||||
| 2043 | 0.641 | €0 | €0 | |||||||
| 2044 | 0.626 | €0 | €0 | |||||||
| 2045 | 0.610 | €0 | €0 | |||||||
| 2046 | 0.595 | €0 | €0 | |||||||
| 2047 | 0.581 | €0 | €0 | |||||||
| 2048 | 0.567 | €0 | €0 | |||||||
| 2049 | 0.553 | €0 | €0 | |||||||
| 2050 | 0.539 | €0 | €0 | |||||||
| 2051 | 0.526 | €0 | €0 | |||||||
| 2052 | 0.513 | €0 | €0 | |||||||
| 2053 | 0.501 | €0 | €0 | |||||||
| 2054 | 0.489 | €0 | €0 |