Calculation guide
Discount each replacement-cycle NPV to time zero.
Chain NPV = Σ single-cycle NPV / (1+r)^(cycle start)
Inputs
Single-cycle NPV A
Example entry 1000 (in the selected currency).
Single-cycle NPV B
Example entry 1500 (in the selected currency).
Project A life in years
Example entry 2. Use whole numbers.
Project B life in years
Example entry 3. Use whole numbers.
Annual discount rate
Example entry 10 %. Allowed range 0 to 100.
Worked example
| Input | Value |
|---|---|
| Single-cycle NPV A | 1,000 |
| Single-cycle NPV B | 1,500 |
| Project A life in years | 2 |
| Project B life in years | 3 |
| Annual discount rate | 10% |
| Result | Value |
|---|---|
| Repeated project A NPV | 2,509.459736 |
| Repeated project B NPV | 2,626.972201 |
| Common horizon | 6 years |
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 |
|---|---|---|---|---|---|
| Single-cycle NPV A | 1,000 | 1,100 | Repeated project A NPV | 2,509.459736 | 2,760.40571 |
| Single-cycle NPV B | 1,500 | 1,650 | Repeated project B NPV | 2,626.972201 | 2,889.669421 |
| Project A life in years | 2 | 3 | Repeated project A NPV | 2,509.459736 | 1,000 |
| Project B life in years | 3 | 4 | Repeated project A NPV | 2,509.459736 | 1,826.446281 |
| Annual discount rate | 10% | 11% | Repeated project A NPV | 2,509.459736 | 2,470.353407 |
