Worked example
Example: 1 000 000 investment, 300 000 a year rising 5 %, 10 years, 10 %. The inputs, in the units selected above:
| Input | Value |
|---|---|
| Investment at the start (your currency) | 1,000,000 - |
| Saving or net cash flow in year 1 (your currency) | 300,000 - |
| Yearly escalation of the saving | 5.0000 % |
| Life (years) | 10.000 - |
| Discount rate | 10.000 % |
Applying the formula below gives:
| Result | Value |
|---|---|
| Net present value (your currency) | 1,231,944 |
| Internal rate of return | 31.944 % |
| Simple payback (years) | 3.3333 |
| Discounted payback (years; 0 = not within the life) | 3.9209 |
| Profitability index (PV of savings ÷ investment) | 2.2319 |
Open this example in the calculator and change any input.
Formula
\(NPV = -C_0 + \sum_{t=1}^{n}\frac{S\,(1+g)^{t-1}}{(1+i)^t} \qquad NPV(IRR) = 0 \qquad n_s = \frac{C_0}{S} \qquad PI = \frac{NPV + C_0}{C_0}\)
Variables
| Symbol | Meaning | SI unit |
|---|---|---|
| \(C_0\) | investment | currency |
| \(S\) | year-1 saving | currency |
| \(g\) | escalation | – |
| \(n\) | life | years |
| \(i\) | discount rate | – |
| \(NPV\) | net present value | currency |
| \(IRR\) | internal rate of return | – |
| \(n_s\) | simple payback | years |
| \(n_d\) | discounted payback | years |
| \(PI\) | profitability index | – |
| \(t\) | year | – |
Method and standards
End-of-year discounted cash flows; IRR by bisection; discounted payback interpolated within the year it turns positive.
Where it is used
- Energy saving projects.
- Equipment replacement.
- Comparing options with different lives (with care).
Common mistakes
- Comparing IRRs of projects of different size.
- Forgetting tax and depreciation.
- Escalating savings faster than the discount rate.
Assumptions and limits
- End-of-year cash flows; no tax, depreciation or residual value.
References
- Discounted cash flow (engineering economics)
Questions and answers
Is 1 000 000 for 300 000 a year (rising 5 %) over 10 years worth it at 10 %?
Yes: NPV 1.23 million, IRR 31.9 %, simple payback 3.3 years, discounted payback 3.9 years.
What discount rate should I use?
Your company's cost of capital or hurdle rate.
Why may there be no IRR?
If the undiscounted savings never repay the investment.
Method and article reviewed by FireCAD engineering on 12 November 2026. Every result is checked against an independent calculation on each release: how we verify our calculators.