NPV, IRR and payback calculator
A free project selection calculator — enter the initial investment, a discount rate and the cost and benefit for each period to get NPV, IRR, payback period, benefit-cost ratio and ROI, with the cash flows worked through.
| Period | Net | Cumulative | Discounted |
|---|---|---|---|
| 0 | |||
- NPV = −initial + Σ net ÷ (1 + r)t
- ROI = (benefits − total cost) ÷ total cost
What each number tells you
- NPV (net present value): today's value of all the future net cash flows, minus the initial investment, at your discount rate. Above zero, the project creates value at that rate. It's the decision metric.
- IRR (internal rate of return): the discount rate at which NPV would be exactly zero. Compare it with your hurdle rate: above it, the project clears the bar.
- Payback period: how many periods until the cumulative net cash flow turns positive. Shorter is safer, but it ignores everything after payback and the time value of money.
- BCR (benefit-cost ratio): present value of benefits ÷ present value of costs. Above 1 pays back.
- ROI: total benefit minus total cost, over total cost. Simple, but not discounted.
How to use it
Enter the initial investment (period 0), the organisation's discount (hurdle) rate, then the cost and benefit for each period. The table shows the net, cumulative and discounted cash flow per period, so you can see where payback falls.
On a real project
The business case for the Coral Ridge sample clears its 12% hurdle with an IRR of about 18%. The value-based delivery lesson shows how those numbers are revisited during the project, not only at the start.
See it used on a real project: Pr3 · Help ensure value-based delivery