Calculation guide
Subtract upfront retrofit cost.
npv = Σ(kWh × price × (1+growth/100)^(t−1)/(1+rate/100)^t) − capital
Inputs
Annual energy saved (kWh)
Example entry 10000.0.
First-year energy price per kWh
Example entry 0.2 (in the selected currency).
Annual price change (%)
Example entry 5.0.
Annual discount rate (%)
Example entry 5.0 %. Allowed range 0 to 100.
Useful life in years
Example entry 10.0. Minimum 1. Use whole numbers.
Upfront retrofit cost
Example entry 12000.0 (in the selected currency).
Worked example
| Input | Value |
|---|---|
| Annual energy saved (kWh) | 10,000 |
| First-year energy price per kWh | 0.2 |
| Annual price change (%) | 5 |
| Annual discount rate (%) | 5% |
| Useful life in years | 10 |
| Upfront retrofit cost | 12,000 |
| Result | Value |
|---|---|
| Present value net of retrofit cost | 7,047.619048 |
Interpreting the result
At a positive net present value, energy savings recover the initial retrofit investment at the specified discount rate.
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 |
|---|---|---|---|---|---|
| Annual energy saved (kWh) | 10,000 | 11,000 | Present value net of retrofit cost | 7,047.619048 | 8,952.380952 |
| First-year energy price per kWh | 0.2 | 1.2 | Present value net of retrofit cost | 7,047.619048 | 102,285.714286 |
| Annual price change (%) | 5 | 6 | Present value net of retrofit cost | 7,047.619048 | 7,885.027196 |
| Annual discount rate (%) | 5% | 6% | Present value net of retrofit cost | 7,047.619048 | 6,086.749652 |
| Useful life in years | 10 | 11 | Present value net of retrofit cost | 7,047.619048 | 8,952.380952 |
| Upfront retrofit cost | 12,000 | 13,200 | Present value net of retrofit cost | 7,047.619048 | 5,847.619048 |
