What the metrics mean
NPV = −I + Σ CFₜ ÷ (1 + r)ᵗ
IRR: the rate at which NPV = 0
ROI = (Σ CF − I) ÷ I
- NPV > 0: the project earns more than the required return. Among several projects, the one with the higher NPV is better.
- If IRR is higher than the discount rate, the project is worthwhile. Compare it with the loan interest rate too.
- Payback period shows how many years it takes to recover the investment. The discounted version accounts for the time value of money.
Example
New equipment costs 100,000 ₼, with expected net cash flows of 30, 40, 45, 35 and 25 thousand ₼ over 5 years. At a 15% discount rate, NPV is 18,362 ₼ and IRR is 22.6%. The investment pays back in 2.7 years, or 3.7 years on a discounted basis.
For cash flow, use the project's actual cash receipts and payments (including taxes), not profit. Depreciation is not a cash outflow. If you finance the project with a loan: loan calculator.
Frequently asked questions
How do I choose the discount rate?
Use the company's cost of capital: the loan interest rate, the return the owner expects and the project risk. Choose a higher rate for a riskier project.
What if NPV is negative?
The project does not pay off at the chosen rate. Recheck costs, prices and timing, or compare it with alternative projects.
Why is IRR not shown?
IRR does not exist when all cash flows are positive or all are negative. Enter the initial investment and at least one positive cash flow.