How it works
NPV = Σ CFk ÷ (1 + r)k
- CF — cash flow in period k (k = 0 for today)
- r — discount rate ÷ 100
The IRR is the discount rate at which the NPV is exactly zero — the yearly return the investment earns. If the IRR is above the return you require, the project is worth doing; a positive NPV at your required rate says the same thing in money.
Separate the values with commas, spaces or new lines. Periods are usually years, but they can be months — then the IRR is a monthly rate.