Definition of IRR: Comprehensive Guide for Investors

The IRR, or Internal Rate of Return, is one of the most commonly used financial indicators by investors and companies to evaluate the real profitability of a project or investment. This comprehensive guide offers an in-depth look at the definition, calculation, interpretation, and benefits of IRR, with concrete examples and practical advice to make it a relevant tool in investment decision-making.

What is IRR in Finance?

The Internal Rate of Return (IRR), also known as internal rate of return (IRR) in English, is a discount rate that nullifies the net present value (NPV) of a series of cash flows, typically those generated by an investment over its lifetime. It measures the average annual return generated by an invested capital, while incorporating the concept of time value of money.

In other words, the IRR indicates the rate at which the sum of future cash flows discounted to the present equals the initial investment. It is always expressed in percentage, characterizing the average annual return of a project or asset, and not in euros.

Why is IRR Essential for Investors?

  • Compare the profitability of several projects with different durations, amounts, or risks into a single synthetic indicator.
  • Evaluate the real performance of an investment by taking into account the temporal horizon and financial feedback.
  • Decide to invest when the IRR is higher than the cost of capital or the required rate of return.
  • Identify opportunities that generate value to maximize the overall returns of a portfolio.

Calculation Formula of IRR

The calculation of IRR relies on solving an equation where the net present value of the future cash flows invested is zero. It then becomes the rate that equalizes the initial cost of the project and the discounted cash inflows:

0 = ∑ (CFt / (1 + IRR)t) - Initial_investment

Where CFt represents the cash flow at period t and the initial_investment is the amount invested initially.

Schematic Example:

Initial investment: 20 000 €
Annual cash flows received: 800 € over 10 years (totaling 8 000 €)
Final value of shares: 22 000 € after 10 years

IRR formula over 10 years: 

IRR = {[(22 000 € + 8 000 €) ÷ 20 000 €]^(1/10)} − 1
IRR ≈ 4.14 %

Comparison of IRR with Other Financial Indicators

Indicator Definition Objective Unit
TRI Discount rate that nullifies the NPV. To measure the real annual profitability of an investment. %
NPV Difference between the present value of future cash flows and the initial cost. To evaluate the value created or destroyed by the project. €
P/E Ratio Market Capitalization / Net Earnings To evaluate the valuation of a listed company x
Beta Sensitivity of an asset to market fluctuations To measure the relative risk of a listed investment n/a

Note: The TRI is neither a security nor a listed stock; it has no market capitalization, price, dividend, beta, or P/E ratio. It is obtained through a calculation applied to projects or assets, and not on a specific financial instrument.

How to Interpret the TRI?

  • TRI > cost of capital: the project creates value, the investment is relevant.
  • TRI = cost of capital: the investment just compensates for the cost of the funds engaged, the profitability is neutral.
  • TRI < cost of capital: the project destroys value, it is better to exclude it.

A high TRI generally attracts investors, but this figure should always be put into perspective with the level of risk, the investment horizon, liquidity, and the stability of expected cash flows.

Limits of the TRI

  • The TRI assumes that all intermediate cash flows are reinvested at the TRI, which is often unrealistic.
  • Its calculation is complex when cash flows are irregular or multiple; it then requires computer methods or financial software.
  • With several changes of sign in the cash flows, there may be several mathematical solutions (multiple TRIs).
  • It does not indicate the absolute value created (unlike the NPV).
  • It does not always allow evaluating the inherent risk of the project.

Practical Use of the TRI for Investors

For individual or professional investors, the TRI is used systematically during the selection process:

  • Of a real estate project (example: purchase of SCPI, rental property)
  • Of a business project or innovation (startup, SME)
  • Of financial placements analysis on life insurance contracts or structured funds

An investor wishes to compare two rental projects:

  • Project A: Target TRI of 5.2% over 12 years
  • Project B: Target TRI of 3.8% over 20 years
The one offering the highest TRI seems initially the most profitable, but it is also necessary to analyze the risks, the regularity, and the quality of the cash flows.

Practical Case of TRI Calculation

Let's assume an investment in SCPI shares:

  • Investment amount: 30,000 €
  • Annual cash flows: 1,200 € paid out over 15 years
  • Resale value at the end: 35,000 €

Calculation of IRR:

IRR = {[(35,000 € + (1,200 € x 15)) ÷ 30,000 €]^(1/15)} − 1
IRR = {[(35,000 € + 18,000 €) ÷ 30,000 €]^(1/15)} − 1
IRR = {[53,000 € ÷ 30,000 €]^(1/15)} − 1
IRR = {[1.7667]^(1/15)} − 1
IRR ≈ 3.89%

This figure helps the investor judge whether the project is competitive compared to other opportunities or to traditional financial markets.

IRR and risk management

Maximizing IRR should not encourage ignoring associated risks:

  • Diversification: spreading investments to limit the risk of concentration
  • Fundamental analysis: examining the stability of revenues, the quality of the project, the contractual solidity
  • Market control: monitoring low periods, vacancy, non-payment, interest rate evolution
  • Regular recalculation: adjusting the IRR at each planned or unplanned change in cash flows

Watch out for common errors:

  • Never present IRR as a listed asset: it has no price, no market capitalization, no dividend, no P/E ratio, no beta.
  • Avoid conflating IRR with stock performance indicators that apply only to listed companies or funds.
  • IRR must always be associated with a specific project, investment, or series of real cash flows.

FAQ: Frequently Asked Questions about IRR

  • Is IRR suitable for all investments?
    Yes, provided that future cash flows can be reliably estimated and the duration of the investment is known.
  • How do you easily calculate IRR?
    Use the "IRR" function on Excel or any financial software, enter negative cash flows (outflows) and positive cash flows (inflows) in the respective time columns.
  • Can IRR be negative?
    Yes, if the investment generates less value than the cost of the capital invested.
  • Is IRR sufficient to choose a project?
    No, it must be complemented by an analysis of risk, liquidity, taxation, and economic prospects.
  • What differences between IRR and gross return?
    Gross return does not consider the time value of money, the evolution of capital, or intermediate cash flows. Therefore, IRR is more precise and relevant over time.

IRR in real estate investment

In rental real estate or SCPI investments, IRR integrates all received revenues (rents, dividends), final sale of the property or shares, and the initial capital investment. It helps to neutralize the effect of market fluctuations on resale value and to anticipate risks related to management (vacancy, charges, taxation).

In practice:

  • The investor estimates expected cash flows over the holding period.
  • He adjusts each of these cash flows according to the IRR formula.
  • He compares the options (residential real estate, SCPI, crowdfunding, etc.) to retain the most attractive one.

Application of IRR to funds, stocks, and other financial assets

It is necessary to distinguish:

  • IRR = profitability indicator of a project, calculated from cash flows, NOT a listed financial asset!
  • Market figures (price, market capitalization, P/E ratio, dividend, beta) are NEVER applied to IRR, but to stocks, mutual funds, ETFs or other listed securities.
  • The figures advanced on certain mutual funds or stocks must be verified on up-to-date financial platforms.

Example: To obtain the performance data of a fund such as Amundi Index Euro Corporate SRI, it is advisable to consult the issuer's website, Bloomberg or Morningstar, and strictly separate these information from the definition of IRR.

Best practices for using IRR in investment selection

  • Give priority to IRR when comparing multiple investments, by integrating expected revenues and final resale.
  • Consider the calculated IRR in relation to the real level of risk and other criteria such as taxation, stability of cash flows, liquidity, and market evolution.
  • Use simulation and calculation tools to obtain a reliable and updated estimate of IRR at each stage of the project.
  • Consider IRR as a complementary criterion to Net Present Value (NPV), gross yield, and payback period.

Error to avoid: Confusing IRR with performance indicators of listed companies

The IRR being neither a company nor a listed fund, it cannot under any circumstances be associated with a price, a stock market capitalization, a P/E ratio, a dividend, or a beta. It is a calculation indicator based on the cash flows of a project or an investment and is expressed exclusively as a percentage, never in euros.

Conclusion: IRR, an indispensable tool for savvy investors

The Internal Rate of Return (IRR) stands out as an essential indicator for accurately evaluating the true profitability of an investment over a given period, by integrating all cash flows and the time value of money. It should never be confused with a listed stock or fund and has no associated market figures. Mastering IRR allows investors to make strategic decisions, maximize value creation, and minimize inherent risks in each project. For an optimal approach, it is necessary to complement it with a comprehensive analysis of risk, taxation, and economic conditions, and to rely on reliable and up-to-date data for any project or asset considered.

This guide invites you to deepen your understanding of IRR in all your investment decisions, whether in real estate, business, or financial investments, to build a performing, sustainable, and goal-oriented portfolio.