What NPV and IRR Mean
Net present value and internal rate of return are two fundamental metrics that help investors evaluate whether a project or investment will create value. While they measure different things, both metrics rely on analyzing cash flows over time. Understanding how each works—and when to use one over the other—is critical for making sound investment decisions.
Net Present Value (NPV)
NPV measures the total value an investment creates in today’s dollars. It calculates the present value of all future cash flows (both inflows and outflows), then subtracts the initial investment. Essentially, NPV tells you: “How much profit will this investment generate above my required return?”
An investment with positive NPV creates value beyond your cost of capital. Conversely, a negative NPV means the investment destroys value. NPV works in absolute dollar terms, not percentages, which is important when comparing projects of different sizes.
Internal Rate of Return (IRR)
IRR is the discount rate at which an investment’s NPV equals zero. Put another way, it’s the percentage return the investment is expected to deliver annually. IRR allows you to compare projects on an apples-to-apples basis regardless of their size, because you’re evaluating the rate of return rather than the dollar amount.
Investors often compare IRR to a minimum acceptable return, called the hurdle rate. If IRR exceeds the hurdle rate, the project clears the threshold. If it falls below, the project doesn’t meet the required return standard.
How to Calculate Each Metric
Both NPV and IRR rely on the same foundation: projected cash flows. The difference lies in what you’re solving for and how you interpret the result. Let me walk you through each calculation.
NPV Formula and Discount Rate Inputs
The NPV formula is:
NPV = ? [CFt / (1 + r)^t] – Initial Investment
Where CFt is the cash flow in year t, r is the discount rate, and t is the time period.
To calculate NPV, you need three inputs: your projected cash flows, the discount rate (your required return), and the investment’s timeline. The discount rate is critical—it reflects your cost of capital and acceptable risk level. Choose a rate that matches the investment’s risk profile. Higher-risk investments warrant higher discount rates.
IRR Formula and Cash Flow Inputs
IRR is more complex mathematically because it’s solved iteratively. Rather than plugging in a discount rate, you’re solving for the rate that makes NPV equal zero:
0 = ? [CFt / (1 + IRR)^t] – Initial Investment
To calculate IRR, you need your projected cash flows and the investment timeline. Most financial calculators and spreadsheet software (Excel’s IRR function, for example) solve this automatically. You simply input your cash flows in order, and the tool finds the rate.
How to Interpret the Results
Both metrics give you different information, and interpreting them correctly is essential for comparing investment opportunities.
When NPV is Positive or Negative
A positive NPV means the investment is expected to generate returns above your required rate of return. The larger the positive NPV, the more value the project creates. A negative NPV signals that the investment will not meet your return threshold and should generally be rejected.
When comparing multiple independent projects, accept all projects with positive NPV. When evaluating mutually exclusive projects (you can only choose one), select the project with the highest positive NPV, as it creates the most value in dollar terms.
When IRR is Above or Below the Hurdle Rate
If IRR exceeds your hurdle rate, the project clears your minimum return threshold. If IRR falls below the hurdle rate, the project doesn’t meet your required return. In theory, you should reject projects where IRR is below the hurdle rate.
IRR’s percentage-based approach makes it intuitive for investors to understand quickly. However, interpreting IRR alone can be misleading in certain scenarios, particularly when comparing projects of different sizes or with different timing of cash flows.
When to Use NPV vs IRR in Real-World Decisions
In practice, NPV and IRR sometimes give conflicting signals about which project to pursue. Understanding when to rely on each metric helps you make better decisions.
Mutually Exclusive Projects, Conflicting Rankings, and Multiple IRRs
When choosing between two mutually exclusive projects, NPV and IRR may rank them differently. This happens when projects have different scales or when cash flows are distributed unevenly over time. In such cases, NPV provides the more reliable recommendation because it shows which option adds more total value.
A more serious issue arises with multiple IRRs. Projects with non-traditional cash flow patterns—those with both positive and negative cash flows at different stages—can produce more than one IRR value. This makes IRR ambiguous and unreliable for decision-making. NPV avoids this problem entirely.
Real Estate, Acquisitions, and Capital Budgeting Applications
In real estate investing, you frequently use NPV vs IRR to evaluate acquisitions and development projects. Both metrics analyze expected rental income, appreciation, and capital expenses against your required return. Real estate investors often rely on NPV to compare deals because properties vary widely in purchase price and timeline.
In acquisitions and broader capital budgeting, companies use NPV as the primary decision metric because it measures shareholder value creation directly. IRR serves as a useful secondary check, but NPV ultimately drives the decision. When NPV and IRR conflict—which happens in non-conventional cash flow scenarios—trust NPV.
FAQ
What is the main difference between NPV and IRR?
NPV measures value added in dollars, while IRR measures the investment’s return as a percentage.
Which is better: NPV or IRR?
NPV is usually better for choosing between mutually exclusive projects because it shows which option adds more total value.
When should investors prefer NPV over IRR?
Use NPV when comparing projects with different sizes, different timing of cash flows, or non-traditional cash flow patterns.
What does a positive NPV mean?
A positive NPV means the project is expected to create value above the required return.
What does IRR tell you?
IRR is the discount rate at which a project’s NPV equals zero, helping investors judge whether the return clears the hurdle rate.
Why can NPV and IRR give conflicting answers?
They can conflict when projects are mutually exclusive, have different scales, or have uneven cash flow timing.
Can IRR have multiple values?
Yes. Projects with non-traditional cash flows can produce multiple IRRs, which is one reason NPV is often more reliable.
How are NPV and IRR used in real estate investing?
They are used to evaluate acquisitions, development projects, and underwriting decisions by comparing expected cash flows against the required return.
