For a single conventional project, NPV and IRR give the same accept or reject answer. They can disagree when projects are mutually exclusive and differ in scale or timing, and the IRR can fail when cash flows change sign more than once.
When two options exclude each other, choose the one with the higher net present value at the hurdle rate. If you want a percentage, compute the IRR of the difference between the options. In the case below, the conveyor has the higher IRR (24.3% against 16.3%) but the robotic cell adds more value ($310,000 against $255,000), and the extra investment earns 11.2%, above the 9% hurdle.
Worked in full in The Capital Budgeting Handbook by Julian R. Sterling, with every figure reproduced in a free workbook.Get the PDF, $19.99 →or the paperback
Ellsmere Plastics, a fictional packaging manufacturer, wants to automate manual palletizing. A robotic cell costs $1,200,000 and saves $300,000 a year after tax for seven years. A semi-automatic conveyor costs $450,000 and saves $140,000 a year after tax for seven years. Only one can be installed. The hurdle rate for cost-reduction projects is 9%.
| Option | Outlay | Annual saving | NPV at 9% | IRR | PI |
|---|---|---|---|---|---|
| Robotic cell | 1,200 | 300 | 310 | 16.3% | 1.26 |
| Conveyor | 450 | 140 | 255 | 24.3% | 1.57 |
| Robot minus conveyor | 750 | 160 | 55 | 11.2% |
The conflict is one of scale. The conveyor earns a higher percentage on a small investment; the robot earns a lower percentage on a larger one and creates more value in total. Choosing the robot means investing an extra $750,000 to save an extra $160,000 a year. That incremental project has a net present value of $55,000 at 9%, exactly the difference between the two net present values, and an internal rate of return of 11.2%. Since 11.2% is above 9%, the extra investment is worth making.
The incremental IRR, 11.2%, is also the crossover rate: the discount rate at which both options have the same net present value. Below it the robot is worth more; above it the conveyor is. At 13%, the robot's net present value would be $127,000 and the conveyor's $169,000. The decision therefore depends on whether the hurdle rate is below 11.2%, and at 9% it is.
The profitability index has the same bias as the IRR: it measures value per dollar, so it favors the smaller option. Use it only to rank independent projects under a single budget constraint, and even then test the combinations.
A mold program costs $1,000,000, brings in $2,500,000 in year 1 and requires $1,540,000 in year 2 to decommission tooling. The cash flows change sign twice, and there are two IRRs: 10.0% and 40.0%. At the 9% hurdle the net present value is -$3,000, so the project should be rejected, although both IRRs exceed 9%. Count the sign changes before trusting an IRR, and use the net present value when there is more than one.
The modified IRR compounds inflows at a stated reinvestment rate. For a $4,500,000 production line in the same case, the IRR is 15.0% and the MIRR, with reinvestment at 9%, is 11.9%. The MIRR is a more realistic percentage, but it still does not resolve conflicts of scale: only the net present value does.
Free Excel template: Capital Project Appraisal Workbook (incremental cash flows, NPV, IRR, MIRR, sensitivity, lease versus buy and capital rationing).
Also on this site: a capital budgeting example with taxes · lease versus buy for equipment.
Because the IRR ignores scale and timing. A small project can earn a higher percentage while creating less value than a larger one; projects whose cash arrives early can show a higher IRR with a lower NPV.
The net present value at the hurdle rate. If a percentage is required, compute the IRR of the incremental cash flows (larger option minus smaller) and compare it with the hurdle.
The discount rate at which two projects have equal net present values. It equals the IRR of their incremental cash flows. Below it, the project with the larger, later cash flows is worth more.
Yes, when its cash flows change sign more than once, for example an outlay, inflows and then a decommissioning cost. Each IRR makes the NPV zero; use the NPV at the hurdle rate instead.
Sources: IRC 168(k) as amended in July 2025, IRS Notice 2026-11, IRS Publication 946, Rev. Proc. 2025-32 and ASC 842, checked on 18 November 2026. Figures computed by the author's model for a fictional company. Education only, not tax, accounting or investment advice.
This article is one calculation from The Capital Budgeting Handbook. The book follows one manufacturer's capital plan from the call for projects to the board's approval and a post-completion review, and every figure it prints is a live formula in the free workbook.
Get the PDF edition, $19.99 Paperback · Free companion files