Internal Rate of Return (IRR) Calculator

The Internal Rate of Return (IRR) is the discount rate that sets the Net Present Value (NPV) of all investment cash flows to zero. It is the most reliable measure of an investment's true performance because it accounts for:

• Cash flow timing: A euro invested 10 years ago has more value than a euro invested yesterday. The IRR weights each flow by its date, unlike simple return calculations.
• All cash flows: Initial capital, periodic contributions, and final capital are all integrated into the calculation.
• Newton-Raphson method: The calculation uses an iterative algorithm to find the rate that eliminates the difference between the theoretical future value and the actual final capital.

Formula: The IRR is the rate r such that: Initial Capital x (1+r)^n + sum of contributions x (1+r)^(n-k) = Final Capital.

The Internal Rate of Return is a fundamental concept in finance, used by both wealth management professionals and individual investors. To use it effectively, it is essential to understand its mathematical definition, advantages, and limitations.

Mathematical definition of IRR

The IRR is the discount rate that sets the Net Present Value (NPV) of all financial flows of an investment to zero. In simple terms, it is the rate that makes the amounts invested and the amounts received equivalent, taking time into account. Mathematically, we seek the rate r such that the sum of all discounted flows equals zero: each flow (contribution or withdrawal) is divided by (1 + r) raised to the power of the number of periods. The calculation is done by iteration (Newton-Raphson method) as there is no direct analytical formula.

Why IRR is more relevant than simple return

Simple return (total gain divided by invested capital) gives a misleading picture of actual performance, especially when cash flows are irregular or spread over time. Consider a concrete example: you invest 10,000 euros today, then 500 euros per month for 10 years, and your final capital is 100,000 euros. The simple return would give (100,000 - 70,000) / 70,000 = 42.8%, or 4.28% per year linear. But this calculation is wrong because it ignores that the last month's 500 euros only worked for 30 days, while the initial 10,000 euros worked for 10 years. The IRR corrects this bias by weighting each flow by its actual investment duration. It thus provides a comparable annualized rate between different investments.

Limitations of IRR

Despite its relevance, IRR has certain limitations worth knowing:

• Reinvestment assumption: IRR implicitly assumes that intermediate cash flows (dividends, coupons) are reinvested at the same rate as the IRR itself. This assumption rarely holds in practice. An 8% IRR assumes that each euro received along the way is reinvested at 8%, which is not guaranteed.
• Multiple IRRs: When an investment has alternating positive and negative cash flows (e.g., a real estate investment with major renovation costs along the way), the calculation may produce multiple IRR values. In such cases, the analysis should be supplemented with other indicators such as NPV.
• Duration sensitivity: IRR favors short-term investments. A placement yielding 20% in 1 year will have a higher IRR than one yielding 150% over 10 years, even though the latter generates a much larger absolute gain.

Difference between gross IRR and net IRR

It is crucial to distinguish gross IRR (before fees and taxes) from net IRR (after deducting all costs). Gross IRR does not reflect the performance actually received by the investor. To obtain a relevant net IRR, the final capital must incorporate the deduction of annual management fees, entry and switching fees, and exit taxation (tax on gains and social contributions). It is this net IRR that should serve as the basis for comparison between different investment wrappers.

IRR is the ideal tool for objectively comparing different investment wrappers. Life insurance, PER, PEA: each wrapper has its own tax rules, fees, and constraints. IRR allows you to put them on an equal footing.

Comparing life insurance, PER, and PEA after taxation

For a meaningful comparison, you must calculate the after-tax net IRR for each wrapper. Life insurance after 8 years benefits from an annual allowance of 4,600 or 9,200 euros on gains, then a reduced rate of 24.7% (7.5% tax + 17.2% social contributions) for contributions below 150,000 euros. PER offers a contribution deduction at entry (immediate tax savings) but taxes capital and gains at exit under the income tax scale. PEA exempts gains from income tax after 5 years (only the 17.2% social contributions apply). For each wrapper, the net IRR integrates these specificities and provides a comparable rate.

Integrating fees into the calculation

Fees have a considerable impact on net IRR, especially over the long term. Here are the main fees to consider for each wrapper:

• Entry fees: From 0% (online contracts) to 5% (traditional bank contracts). On a 10,000 euro contribution, 5% entry fees represent 500 euros that will never be invested.
• Annual management fees: From 0.5% to 1% per year for the contract, plus fund fees (unit-linked) of 1.5% to 2.5% per year. These fees compound and erode returns every year.
• Switching fees: From 0% (online contracts) to 1% of the amount switched. They impact IRR if you regularly rebalance your allocation.

Accounting for exit taxation

Exit taxation varies considerably depending on the wrapper and holding period. For the net IRR, you must deduct from the final capital the amount of tax and social contributions due upon withdrawal. This is the only way to obtain an honest comparison between a PER (deduction at entry, taxation at exit), a PEA (no deduction, but partial exemption at exit), and life insurance (no deduction, reduced taxation after 8 years).

Comparative example over 15 years

Consider an investor contributing 500 euros per month for 15 years, with a gross return of 5% per year, across three different wrappers:

• Life insurance (online contract, 0.6% management fees): Gross final capital of approximately 130,000 euros, post-8-year taxation with allowance, estimated net IRR of approximately 3.4% per year.
• PER (same fees, 30% TMI): Immediate tax savings of 1,800 euros per year, but capital taxed at exit. If the capital is withdrawn as a lump sum or annuity at retirement (potentially lower TMI), the net IRR can reach 3.8% to 4.2% depending on the situation.
• PEA (0.4% fees, equities only): Comparable final capital, only 17.2% social contributions on gains, estimated net IRR of approximately 3.7% per year.

This example illustrates that there is no universally superior wrapper: the net IRR depends on your TMI, investment horizon, contract fees, and exit situation. IRR is the tool that allows you to quantify these differences.

IRR is a powerful indicator, but its interpretation requires some precautions to avoid hasty conclusions. First, always compare your IRR to inflation. A nominal IRR of 3% may seem adequate, but if average inflation over the period is 2.5%, your real return is only 0.5%. Your purchasing power has barely increased. To evaluate the real performance of your investment, systematically subtract the average inflation rate from the IRR obtained.

Second, keep in mind that IRR does not measure risk. Two investments can show the same 6% IRR, but one with very low volatility (diversified euro fund) and the other with fluctuations of plus or minus 20% per year (equities). IRR alone does not tell you whether the performance was steady or the result of a single exceptional year. For a complete analysis, combine IRR with other indicators such as volatility or the Sharpe ratio. Finally, remember that the IRR calculated here assumes regular and constant contributions. If your actual contributions are irregular, the displayed IRR will be an approximation. For maximum precision, use the XIRR method which accounts for the exact dates of each cash flow.

Marc, age 52, opened a life insurance contract 15 years ago with an initial contribution of 30,000 euros, then contributed 250 euros per month without interruption. Today, the surrender value of his contract is 98,000 euros. He wants to know whether his investment has performed well.

Total invested calculation: Marc contributed 30,000 euros initially, plus 250 euros per month for 15 years, i.e., 250 x 12 x 15 = 45,000 euros in regular contributions. His total investment is therefore 75,000 euros. His gross capital gain is 98,000 - 75,000 = 23,000 euros, an apparent gain of 30.7%.

IRR calculation: The simple return of 30.7% over 15 years would give a linear annual rate of 2.04%. But this calculation is misleading because it does not account for the fact that the earliest contributions worked for 15 years while the most recent ones only worked a few months. The IRR, which weights each flow by its duration, gives a result of 2.85% per year. This rate is higher than the simple return because the oldest contributions (which contributed more to the performance) carry more weight in the calculation.

Interpretation: With an IRR of 2.85%, Marc is above average inflation (about 2% over the period) but below the average euro fund return (about 3%). This suggests that his contract fees (probably high, around 0.80 to 1% management fees plus contribution fees) have significantly eroded the gross performance of the underlying investments. Marc could improve his future IRR by opening a complementary contract with lower fees.