Investing Term

Extended Internal Rate of Return (XIRR)

Definition

A financial metric that calculates the annualized rate of return for a series of irregular, date-specific cash flows (inflows and outflows).

Mathematical Formula

\sum_{i=1}^{N} \frac{CF_i}{(1 + XIRR)^{\frac{d_i - d_1}{365}}} = 0

Context & Practical Application

What is XIRR? (Simple Terms)

XIRR is a special interest rate calculator.

If you make one single deposit and let it grow, you can use CAGR to find your interest rate. But what if you add money on different days, like investing ₹5,000 every month and occasionally withdrawing some?

Since the money has been in the fund for different amounts of time, standard interest formulas won’t work. XIRR figures out the exact dates of all your deposits and withdrawals to give you the true, average annual interest rate for your actual portfolio.

Understanding Extended Internal Rate of Return (XIRR)

Extended Internal Rate of Return (XIRR) is the industry standard for measuring investment returns on portfolios with multiple cash flows.

Unlike CAGR, which only considers a single start and end point, XIRR factors in the exact dates of every transaction:

Positive cash flows (withdrawals or redemptions).
Negative cash flows (deposits or purchase installments).

By aligning transaction amounts with their respective durations in the market, XIRR calculates the true annualized rate of return for your overall portfolio.

Mathematical Solver for XIRR

XIRR calculates the discount rate that sets the Net Present Value ( $NPV$ ) of a series of irregular cash flows occurring at specific dates to zero.

The mathematical relation is expressed as:

\sum_{i=1}^{N} \frac{CF_i}{(1 + XIRR)^{\frac{d_i - d_1}{365}}} = 0

Where:

$CF_i$ is the cash flow amount at transaction $i$ (outflows are negative, inflows are positive).
$d_i$ is the date of transaction $i$ .
$d_1$ is the date of the initial transaction (the baseline date).
$N$ is the total number of transactions.

Because XIRR cannot be solved algebraically, financial engines (such as MoneyInFuture) resolve the equation numerically using the Newton-Raphson method:

X_{n+1} = X_n - \frac{f(X_n)}{f'(X_n)}

Where $f(X)$ is the NPV function and $f'(X)$ is its first derivative. If Newton-Raphson diverges due to extreme cash flow patterns, engines fall back to a Bisection search to locate the root.

Referenced In Guides & Comparisons

Learn how Extended Internal Rate of Return (XIRR) is applied in real-world scenarios across our pathways:

Guide (curriculum-lesson)CAGR vs XIRR: Which Return Metric Should You Trust?Guide (curriculum-lesson)Risk, Return, and Diversification