NPV vs IRR vs Payback Period: Capital Budgeting Metrics Explained
When evaluating a potential investment, finance teams often calculate several measures including Net Present Value, Internal Rate of Return and Payback Period. The challenge is that these metrics do not always point in exactly the same direction. One project might produce the highest NPV. Another might generate the highest IRR. A third might recover the original investment more quickly.
Understanding what each metric actually measures is therefore essential.
Rather than asking which single measure is "best", a more useful approach is to understand what information each metric contributes to the investment decision.
What Does NPV Measure?
Net Present Value (NPV) measures the value of projected future cash flows after allowing for the time value of money. Future cash flows are discounted using a required rate of return, often represented by the company's cost of capital. In simplified terms:
NPV = Present value of future cash inflows − Present value of investment outflows
If an investment generates a positive NPV, the forecast cash flows exceed the return required by the selected discount rate. One important characteristic of NPV is that it measures value in monetary terms. For example:
Project A may generate an NPV of €500,000.
Project B may generate an NPV of €150,000.
The difference gives a direct indication of the amount of value each investment is expected to generate under the assumptions used.
What Does IRR Measure?
Internal Rate of Return expresses the return as a percentage. It is the discount rate at which the NPV of the investment equals zero. If a project has an IRR of 18% and the company's required return is 10%, the model indicates that the projected return exceeds the assumed hurdle rate.
IRR is popular because percentages are easy to communicate. However, percentage returns can sometimes make smaller projects look more attractive than larger projects that create more absolute value.
Why Can NPV and IRR Disagree?
Consider two investments.
A small project requires €100,000 and generates a very high percentage return.
A much larger project requires €1 million and generates a lower percentage return but substantially greater cash profits.
The smaller investment could have the higher IRR while the larger investment has the higher NPV. Neither result is necessarily incorrect. The two calculations answer different questions.
IRR focuses on the percentage return implied by the cash flows.
NPV focuses on the amount of value generated after accounting for the required return.
This distinction is particularly important when investments are mutually exclusive and only one can be selected.
What Does Payback Period Measure?
Payback Period measures how long it takes to recover the initial investment from the project's cumulative cash flows. For example, an investment costing €500,000 that recovers that amount after 3.2 years has a payback period of approximately 3.2 years.
Payback is useful because it provides an intuitive measure of how quickly capital is recovered.
This can be relevant where businesses:
face liquidity constraints
operate in uncertain markets
want to reduce exposure to long-duration projects
place importance on fast cash recovery
However, basic payback has important limitations. It normally ignores the time value of money and does not give credit for cash flows generated after the payback point. A project that pays back in three years but creates limited value thereafter may therefore appear more attractive than a project with a four-year payback and significantly greater long-term value.
What is MIRR?
Modified Internal Rate of Return attempts to address some of the conceptual limitations associated with IRR. Standard IRR implicitly incorporates assumptions about reinvesting interim cash flows. MIRR instead applies explicit financing and reinvestment assumptions.
It can therefore provide an additional percentage-return measure, particularly where project cash flows are more complex.
What is ARR?
Accounting Rate of Return measures the project using accounting profit rather than cash flows. Because it is earnings-based, ARR can be useful when users want to understand the project's accounting impact. However, it does not directly incorporate the timing of cash flows in the same way as NPV.
What is Profitability Index?
The Profitability Index measures the relationship between the present value of expected future cash inflows and investment outflows. A profitability index above 1.0 generally corresponds with a positive NPV. The metric can be particularly useful where capital is constrained and management wants to consider value generated relative to the amount invested.
What is Equivalent Annual Annuity?
Equivalent Annual Annuity converts an investment's NPV into an equivalent annual amount over the project's economic life. This is useful when comparing investments with different durations. For example, comparing the NPV of a five-year project directly with a ten-year project may not always provide a complete picture.
EAA provides an additional way of considering the annualised economic value generated by each option.
Comparing the Metrics Side by Side
Imagine three projects:
Project A has the largest initial investment and the highest NPV.
Project B has a smaller NPV but a higher IRR.
Project C has the shortest payback period and highest profitability index.
A decision based only on one metric could overlook important characteristics of the other projects. A more comprehensive assessment would examine:
Value creation: NPV
Percentage return: IRR and MIRR
Capital recovery: Payback Period
Accounting profitability: ARR
Return relative to investment: Profitability Index
Different project lives: Equivalent Annual Annuity
This is one reason why side-by-side investment comparison can be more useful than reviewing calculations independently. In practice, capital budgeting is usually better supported by a combination of measures rather than one calculation.
NPV can provide insight into absolute value creation.
IRR and MIRR provide percentage-return perspectives.
Payback highlights capital recovery.
Profitability Index can help when capital is constrained.
EAA can assist when comparing projects with different lives.
The appropriate emphasis will depend on the objectives, constraints and risk profile of the organisation.
Compare Capital Budgeting Metrics with Capital Budgeting Pro
Capital Budgeting Pro calculates the major investment appraisal measures automatically from the assumptions entered. Users can compare up to five investments side by side and review: NPV, IRR, MIRR, ARR, Payback Period, Profitability Index, Equivalent Annual Annuity, investment amount, total cash flows and detailed annual results.
The Results section also provides appraisal charts, project rankings and detailed Cash View and P&L View schedules. This makes it easier to understand why different metrics may favour different projects.
Try the Calculations Yourself
Capital Budgeting Pro is a free capital budgeting and investment appraisal app that allows businesses to model projects and compare their financial results without building a spreadsheet from scratch.
The analysis and PDF preview are free. A downloadable professional PDF report and Excel workbook are available for EUR 15.00.
Try Capital Budgeting Pro: https://capitalbudgetingpro.com/
Disclaimer Capital Budgeting Pro is intended for general planning and illustrative purposes only and does not constitute financial, investment, accounting, legal or tax advice.
Comments