Calculating IRR for Multi-Year Investments

Hello! Welcome back to our journey through real estate investment metrics.

In our last lesson, we focused on Net Present Value (NPV), a metric that tells you in today's euros exactly how much value an investment creates relative to your required rate of return. We answered the question, "Does this investment exceed my target return?"

Today, we'll tackle a related and equally important question: "What is the actual percentage return this investment is projected to generate over its lifetime?" This brings us to your learning outcome for this lesson: to calculate the Internal Rate of Return (IRR) for multi-year investment cash flows. IRR is one of the most frequently cited metrics in real estate, so understanding how to calculate and interpret it is crucial for analyzing deals.

1. What is the Internal Rate of Return (IRR)?

At its core, the Internal Rate of Return is the annualized rate of return that an investment is expected to generate. It considers all cash flows over the entire holding period—your initial investment, the annual cash flows from rent, and the final proceeds from the sale—and accounts for the time value of money.

Conceptually, you can think of IRR as the break-even discount rate. It is the specific discount rate that makes the Net Present Value (NPV) of all cash flows equal to zero. In Spain, you will see IRR referred to as TIR (Tasa Interna de Retorno).

Let's start with a video that provides an excellent high-level introduction to IRR, explaining what it is and how it differs from other metrics you've seen.

2. The Relationship Between IRR and NPV

As the video explained, IRR and NPV are deeply connected.

• NPV takes a discount rate (your required return) and gives you a value in euros.
• IRR takes the cash flows and gives you a discount rate (the project's intrinsic return).

This leads to a simple and powerful decision rule:

An investment is considered attractive if its Internal Rate of Return (IRR) is greater than your required rate of return (the discount rate you'd use for NPV).

Why? If IRR > Required Return, it mathematically guarantees that NPV > 0. They are two sides of the same coin.

The image below, from a Spanish financial education site, perfectly illustrates this. It shows that the IRR (TIR) is the rate where the NPV (VAN) of the cash flows equals zero. When comparing two projects, the one with the higher IRR is generally preferred, assuming they have similar risk profiles.

3. Calculating IRR with Python

While the concept is straightforward, calculating IRR isn't as simple as plugging numbers into a formula like we did for NPV. It requires solving a polynomial equation to find the rate r where the NPV formula equals zero. This is an iterative process, perfectly suited for a computer.

Given your background, you'll find it much more efficient and scalable to use Python. We'll use the numpy_financial library, just as we did for NPV.

Let's watch a short demonstration on how to use the irr function. This video picks up exactly where the NPV tutorial from our last lesson left off.

Python Implementation

The npf.irr() function is simpler to use than npf.npv() because it takes the entire cash flow series as one argument, including the initial investment at time 0.

Let's use the same cash flow series from our NPV example in the previous lesson:

• Initial Investment ($C_0$): -€150,000
• Future Cash Flows ($C_1$ to $C_5$):
  • Year 1: €5,100
  • Year 2: €5,400
  • Year 3: €5,700
  • Year 4: €6,000
  • Year 5 (Annual CF + Reversion): €995,526

Here is the Python code to calculate the IRR for this investment:

import numpy_financial as npf

# The full cash flow series, including the initial investment (negative) at time 0.
cash_flows = [
    -150000, # C0
    5100,    # C1
    5400,    # C2
    5700,    # C3
    6000,    # C4
    995526   # C5
]

# Calculate the IRR
internal_rate_of_return = npf.irr(cash_flows)

print(f"The Internal Rate of Return (IRR) is: {internal_rate_of_return:.2%}")

# Decision making using IRR
required_return = 0.08 # Our discount rate from the last lesson
if internal_rate_of_return > required_return:
    print(f"The IRR of {internal_rate_of_return:.2%} is greater than the required return of {required_return:.2%}. Project is attractive.")
else:
    print(f"The IRR of {internal_rate_of_return:.2%} is not greater than the required return of {required_return:.2%}. Project should be rejected.")

Output:

The Internal Rate of Return (IRR) is: 45.47%
The IRR of 45.47% is greater than the required return of 8.00%. Project is attractive.

This confirms the conclusion from our NPV analysis, but provides a new, powerful piece of information: the investment is projected to yield an annualized return of 45.47%.

Handling Irregular Cash Flows: XIRR

A common real-world scenario is that cash flows don't occur at perfect yearly intervals. You might pay for the property on March 30, receive your first rent payment on May 1, and so on. The standard IRR function assumes equal time periods between each cash flow.

For irregular timings, you should use a function called XIRR. While Excel has this built-in, in Python you can use a specialized library like pyxirr. This is a practical tool to be aware of as you build more sophisticated models.

4. Pros and Cons of Using IRR

IRR is powerful, but it's not perfect. It's essential to understand its advantages and limitations. For this, we'll return to the Coach Carson video, which provides a balanced view.

To summarize the key points from the video:

Pros:

• Includes All Returns: Accounts for income, appreciation, and loan paydown.
• Time Value of Money: Properly weighs cash flows based on when they occur.
• Comparability: As a percentage, it's easy to compare different projects (e.g., Project A's 15% IRR vs. Project B's 12% IRR).

Cons:

• Reinvestment Rate Assumption: IRR implicitly assumes that all intermediate cash flows are reinvested at the IRR itself. If your IRR is 25%, the formula assumes you can reinvest your annual profits at that same high rate, which is often unrealistic. This can overstate the true return. (A metric called Modified IRR (MIRR), which we'll see later, addresses this).
• Sensitive to Assumptions: Small changes to the holding period or exit price can dramatically change the IRR, making it easy to manipulate. Always scrutinize the underlying assumptions.
• Multiple/No IRR: With unconventional cash flows (e.g., a large capital expense midway through the project), it's possible to have multiple valid IRR solutions or none at all.

Conclusion

You have now added the Internal Rate of Return to your analytical toolkit, giving you a powerful way to measure and compare the total, time-adjusted return of potential real estate deals. By understanding its relationship with NPV and its inherent limitations, you can use it wisely to make better investment decisions.

Key Takeaways:

• IRR is the annualized rate of return that makes the NPV of an investment equal to zero.
• It provides a single percentage that represents the total return of a project, accounting for all cash flows and the time value of money.
• The primary decision rule is: Accept if IRR > Required Rate of Return.
• In Python, use npf.irr(cash_flows) where cash_flows is a list that includes the initial negative investment.
• Be mindful of IRR's limitations, particularly the reinvestment rate assumption and its sensitivity to your projected exit value and timeline.

Preview of the Next Lesson:
So far in this module, we've focused on using discounted cash flow analysis (NPV and IRR) to evaluate an investment's profitability. These methods are part of what's called the Income Approach to valuation. In the next module, we will broaden our perspective and explore other ways to determine a property's value. We'll start by learning how to describe the methodology of the Sales Comparison Approach, a fundamental technique used by appraisers that relies on the prices of recently sold, similar properties.