NPV and IRR: is a project worth it?
Bring all of a project’s cash flows back to today, strike the balance, and find the rate that makes it zero.
Lesson 29 min
By the end of this lesson
- Calculate a project’s net present value from its cash flows
- Define the IRR and apply its decision rule against the cost of capital
- Explain why NPV decides between projects of different sizes
A project costs money today and pays back later. To know whether it is worth it, you bring all its cash flows back to today, as in the previous lesson, then strike the balance. What you will learn: calculate a project's net present value and read its internal rate of return, the rate at which that balance falls to zero.
Net present value
The OpenStax textbook defines it as the difference between the present value of cash inflows and that of cash outflows; the rule is simple: accept a project with a positive NPV, reject one with a negative NPV (OpenStax, Principles of Finance, 16.2). The same textbook lists its strengths: it accounts for the time value of money, gives a clear answer, and its rate can be raised for a riskier project.
Net present value (NPV)
The sum of all a project's cash flows, each brought back to today at the discount rate, with outflows counted as negative. If positive, the project earns more than the required rate.
Writing for the cash flow in year (negative for an outflow, being the cost paid today), for the discount rate and for the project's last year:
Prince's drying workshopFictional
Prince is considering a drying workshop. It costs 10,000,000 FCFA today and should bring in 3,000,000 FCFA in one year, 4,000,000 FCFA in two years and 5,000,000 FCFA in three years. Investing this money elsewhere, at comparable risk, would earn 8% a year.
- Year 1: 3,000,000 ÷ 1.08 = 2,777,778 FCFA.
- Year 2: 4,000,000 ÷ 1.08² = 4,000,000 ÷ 1.1664 = 3,429,355 FCFA.
- Year 3: 5,000,000 ÷ 1.08³ = 5,000,000 ÷ 1.259712 = 3,969,161 FCFA.
- Sum of discounted inflows: 2,777,778 + 3,429,355 + 3,969,161 = 10,176,294 FCFA.
- NPV: 10,176,294 − 10,000,000 = 176,294 FCFA, positive: the project earns a little more than 8%.
Without discounting, you would have seen 12,000,000 − 10,000,000 = 2,000,000 FCFA of gain: a misleading figure that forgets the money has to wait.
If the required rate went from 8% to 9%, would the workshop's NPV rise or fall? Why?
The internal rate of return
If NPV falls as the rate rises, there is a rate at which it is exactly zero. OpenStax calls the internal rate of return (IRR) the discount rate that makes the present value of inflows equal to that of outflows; you accept the project if its IRR exceeds the cost of capital (OpenStax, 16.3).
Internal rate of return (IRR)
The discount rate at which a project's NPV is zero. It is the annual return the project "contains".
In plain wordsThe sums behind a cocoa field
Planting a cocoa field costs money today; the harvests only come years later. NPV does the honest sum: each future harvest is brought back to its value today, then the cost of planting is taken away. If something is left, the field earns more than the money would elsewhere. IRR answers a different question: what yearly return does the field give on its own? If it beats what the money would earn elsewhere, the field is worth it. Except that a percentage says nothing about size: a small garden can show a better return than a large plantation and still earn far less.
With the same letters, the IRR is the rate that satisfies:
The IRR is found by trial: at 8%, NPV = +176,294; at 9%, NPV ≈ −20,069. The zero therefore lies between the two, closer to 9%: about 8.90%. The calculator finds it by halving the interval again and again. Slide the rate and watch the yellow square move down the curve until it crosses zero.
Year 0
−10,000 k
Year 1
2,778 k
Year 2
3,429 k
Year 3
3,969 k
Net present value
176,294 FCFA
positive: the project creates value at this rate
Internal rate of return
8.90%
the rate at which NPV is zero
Fictitious project. NPV = sum of cash flows divided by (1 + r)^year; IRR found by bisection. Rules: positive NPV, or IRR above the cost of capital (OpenStax, 16.2 and 16.3).
To check the method on a published case: the OpenStax example, a 16,000-dollar machine returning 2,000, 4,000 and then 5,000 dollars a year from year 3 to year 6, has an NPV of 2,835.63 dollars at 9% and an IRR of about 14.09% (OpenStax, 16.2 and 16.3).
When the IRR misleads
OpenStax points out three traps (16.3):
- Several IRRs. If cash flows change sign more than once (an outlay, income, then a large clean-up cost), NPV can cross zero twice: two IRRs, neither of them reliable.
- Size ignored. An IRR is a percentage: 30% on 100,000 FCFA earns less than 12% on 50,000,000 FCFA. To choose between mutually exclusive projects, NPV decides.
- Assumed reinvestment. The IRR assumes the cash received is reinvested at the same rate, which is not always possible.
A project's cash flows are forecasts, not certainties: a positive NPV computed on over-optimistic income protects you from nothing. Run the calculation with a cautious scenario, and be wary of any pitch that announces a high IRR without showing the cash flows. These methods are general: our sources describe no rule specific to the CEMAC zone for appraising projects.
From memory: what is the decision rule with NPV, then with IRR? When should you prefer NPV?
Your turn
Read next: OpenStax, Principles of Finance 2e, 16.3 « Internal Rate of Return (IRR) Method »
A question? Ask your teacher, or an AI assistant, giving it the title of this lesson.