How to assess a project: NPV, IRR and payback
Before investing in a new machine, location or product line, it is worth answering one question: will the cash the project generates pay back the investment and still reward the capital adequately? A feasibility analysis answers it with a few indicators calculated on the project’s annual cash flow.
The main indicators
| Indicator | What it shows | Feasible when |
|---|---|---|
| NPV (net present value) | how much value the project creates, in today’s money, above the required return | greater than zero |
| IRR (internal rate of return) | the project’s annual return | greater than the hurdle rate |
| MIRR (modified IRR) | the IRR assuming cash is reinvested at a realistic rate | greater than the hurdle rate |
| Payback | how many years until the investment comes back | shorter than the acceptable period |
| Profitability index | present value of inflows ÷ investment | greater than 1 |
Example
An investment of $100,000 that generates $30,000 a year for 5 years, with a 12% hurdle rate, has an NPV of about $8,143 and an IRR of 15.2%. It is feasible: it earns more than the required 12%.
Project and equity
The project view looks at the whole investment, without the loan. The equity view looks only at the owners’ money, with the loan proceeds coming in and interest and principal going out. A cheap loan can raise the equity IRR considerably. The calculator also shows debt coverage (DSCR): whether each year’s cash is enough to make the loan payments.
What must not be left out
Taxes on revenue and on profit, the extra working capital (inventory and customer credit of the new business), depreciation and the residual value of the equipment at the end of the period. Forgetting working capital is one of the most common mistakes and usually makes the project look better than it is. For large decisions, have the study reviewed by a professional.