NPV and IRR for Capital Budgeting Decisions

Hello! Welcome to the third lesson in our module on the Foundations of Corporate Finance.

In our last session, we calculated the Weighted Average Cost of Capital (WACC) and established its role as a company's "hurdle rate." This rate represents the minimum return a company must earn on its investments to satisfy its debt and equity investors.

Today, we will put that hurdle rate to work. Our learning outcome is to apply Net Present Value (NPV) and Internal Rate of Return (IRR) criteria to evaluate and select capital budgeting projects. These two methods are the cornerstones of modern capital budgeting, providing a systematic framework for deciding which investments will create value and which will destroy it. Given your background in quantitative modeling and optimization, you'll find the mechanics straightforward; our focus will be on the interpretation, underlying assumptions, and the critical judgment required when these two powerful tools give conflicting signals.

1. Net Present Value (NPV): The Gold Standard

The most direct way to measure if an investment creates value is to calculate its Net Present Value. NPV measures the difference between the present value of a project's future cash inflows and the present value of its cash outflows. In simpler terms, it calculates the net increase or decrease in firm value, in today's dollars, if the project is undertaken.

The formula for NPV is:
$NPV = \sum_{t = 0}^{n} \frac{C F _{t}}{( 1 + r ) ^{t}} = C F_{0} + \frac{C F _{1}}{( 1 + r ) ^{1}} + \frac{C F _{2}}{( 1 + r ) ^{2}} + \dots + \frac{C F _{n}}{( 1 + r ) ^{n}}$

Where:

$C F_{t}$ is the net cash flow in period $t$ .
$C F_{0}$ is the initial investment (a negative value).
$r$ is the discount rate, which is typically the firm's WACC.
$n$ is the life of the project.

The NPV Decision Rule

The decision rule is simple and powerful:

If NPV > 0, the project is expected to generate returns greater than the cost of capital. It will add value to the firm and should be accepted.
If NPV < 0, the project's returns are less than the cost of capital. It will destroy value and should be rejected.
If NPV = 0, the project is expected to earn exactly the cost of capital. The firm is indifferent.

For a practical demonstration of how NPV is calculated, please watch the following segment.

Capital Budgeting: NPV, IRR, Payback | MUST-KNOW for Finance Roles

Let's start with a practical overview of capital budgeting and see how NPV is calculated. This video from Kenji Explains provides a clear example in Excel.

Watch the introduction and the section on NPV, from the beginning until 04:41. Pay attention to how the Excel NPV function is used and, critically, why the initial cash flow (Year 0) is handled outside the function.

As the video highlights, a common pitfall is the application of Excel's NPV function. The function is programmed to assume the first cash flow you provide occurs one period from now (t=1). Therefore, the correct approach is to calculate the present value of the future cash flows (from Year 1 onwards) using the NPV function and then add the initial investment (which is already in present value terms at t=0) to the result.

2. Internal Rate of Return (IRR): The Project's Intrinsic Return

While NPV gives us an absolute measure of value created, the Internal Rate of Return (IRR) provides a relative measure. The IRR is defined as the discount rate that makes the NPV of a project exactly equal to zero.

$0 = NPV = \sum_{t = 0}^{n} \frac{C F _{t}}{( 1 + IRR ) ^{t}}$

Think of it as the project's intrinsic, annualized compound rate of return. Because the formula cannot be solved directly for IRR, it is found using iterative methods, which are built into financial calculators and spreadsheets.

The IRR Decision Rule

The IRR is compared against the WACC (our hurdle rate) to make a decision:

If IRR > WACC, the project's expected return exceeds its cost. It is a value-creating project and should be accepted.
If IRR < WACC, the project's return is not sufficient to cover its cost. It should be rejected.

Let's see how IRR is calculated in the same example.

Capital Budgeting: NPV, IRR, Payback | MUST-KNOW for Finance Roles

Now let's look at the second key metric, the Internal Rate of Return. The same video explains what IRR is and how to calculate it.

Watch the segment on IRR from 04:41 to 06:20. Notice how IRR is defined as the rate where NPV is zero and observe the decision rule (IRR > cost of capital).

For independent projects, NPV and IRR will always lead to the same accept/reject decision. If NPV is positive, IRR will be greater than the WACC, and vice-versa. The real challenge arises when you must choose between two or more mutually exclusive projects.

3. The NPV vs. IRR Debate: When Rules Collide

When comparing mutually exclusive projects, the one with the higher IRR is not always the one with the higher NPV. This conflict is where a manager's true understanding is tested. The following reading delves into the reasons for these discrepancies.

Net Present Value and Internal Rate of Return

While IRR is intuitive ('the project's return is 20%'), it suffers from several theoretical problems that can lead to incorrect investment decisions, especially when comparing projects. This guide from CPA Ireland provides a detailed comparison of NPV and IRR.

Please read Section 4.0, 'Net Present Value v Internal Rate of Return' (pages 7-11). Focus on the three key issues discussed: (1) Absolute vs. Relative Return (project scale and duration), (2) the Rate of Reinvestment assumption, and (3) problems with Unconventional Cash Flows (multiple IRRs).

Let's synthesize the critical points from this reading. There are three main reasons why NPV is considered the superior decision criterion.

a) The Scale Problem: Absolute vs. Relative Returns

IRR is a percentage, which makes it blind to the scale of the investment. NPV, however, measures the absolute dollar value created.

Consider two mutually exclusive projects:

Project A: Invest $10,000, get $15,000 next year.
- IRR = 50%
- NPV (at 10% WACC) = $\frac{$15 , 000}{1.10} - $10, 000 = $3, 636$
Project B: Invest $1,000,000, get $1,250,000 next year.
- IRR = 25%
- NPV (at 10% WACC) = $\frac{$1 , 250 , 000}{1.10} - $1, 000, 000 = $136, 364$

The IRR rule would favor Project A (50% > 25%). However, the goal of the firm is to maximize shareholder wealth. Project B, despite its lower percentage return, creates vastly more absolute value ($136,364 vs. $3,636). The NPV rule correctly identifies Project B as the superior choice.

b) The Reinvestment Rate Assumption

This is a more subtle but crucial theoretical point.

NPV implicitly assumes that any intermediate cash flows generated by the project can be reinvested at the cost of capital (WACC). This is generally considered a reasonable and conservative assumption, as the firm should be able to find other projects that earn its average required rate of return.
IRR implicitly assumes that intermediate cash flows can be reinvested at the IRR itself. If a project has a very high IRR (e.g., 50%), this assumption is likely unrealistic. It's improbable that the firm can consistently find new projects yielding such high returns.

The NPV's more conservative and realistic reinvestment assumption makes it more reliable.

c) The Problem of Multiple IRRs

For a conventional project with one initial outflow followed by inflows, there will be only one IRR. However, for unconventional projects—those with multiple changes in the sign of cash flows (e.g., - + + -)—there can be multiple IRRs.

An example is a mining project that requires a large initial investment (negative CF), generates profits for several years (positive CFs), and then requires a significant expenditure for site reclamation at the end (negative CF). Such a project could have two or more IRRs, rendering the IRR decision rule ambiguous. Which IRR should you compare to the WACC?

NPV does not suffer from this problem. It produces a single, unambiguous value for any pattern of cash flows.

The Verdict

For these reasons, when NPV and IRR provide conflicting rankings for mutually exclusive projects, the NPV decision should always be followed. NPV directly measures the project's contribution to shareholder wealth, which is the primary objective of the firm.

IRR remains a valuable, intuitive metric for communicating a project's profitability as a percentage return, but NPV is the theoretically sound and reliable tool for making the final capital allocation decision.

Conclusion

In this lesson, we explored the two primary tools for capital budgeting and learned how to apply them to make investment decisions.

Key Takeaways:

Net Present Value (NPV) measures the absolute dollar value a project adds to the firm. The decision rule is to accept projects with a positive NPV.
Internal Rate of Return (IRR) measures a project's intrinsic percentage return. The decision rule is to accept projects where the IRR exceeds the cost of capital (WACC).
While both methods lead to the same decision for independent projects, they can conflict when ranking mutually exclusive projects.
NPV is the superior criterion because it is not distorted by project scale, relies on a more realistic reinvestment rate assumption, and is not ambiguous for unconventional cash flows.

Preview of the Next Lesson:

We have just learned how to use the WACC to select value-creating projects. But the WACC itself is determined by the firm's mix of debt and equity financing. In our next lesson, we will delve into this topic: "Analyze the impact of capital structure on firm value using the trade-off and pecking order theories." We will explore the strategic decisions behind how a company finances its operations and how that financing mix can, in itself, affect the company's value.

Recommended resources