XIRR Calculator: Annualized Return for Irregular Cash Flows Explained

When you evaluate a simple investment where you put in a single sum at the beginning and withdraw it at the end, calculating your return is straightforward. You can easily use the Compound Annual Growth Rate (CAGR) to find your annualized return. However, real-world investing is rarely that clean.

In everyday life, you might make a monthly Systematic Investment Plan (SIP) contribution, top up your investments when the market dips, receive sporadic dividend payouts, or withdraw money to cover unexpected expenses. These transactions occur on irregular dates and in varying amounts. For these scenarios, CAGR falls short. To calculate the true annualized performance of your portfolio under these conditions, you need the Extended Internal Rate of Return (XIRR). In this guide, we will unpack what XIRR is, explain the mathematical polynomial cash flow equation that defines it, compare CAGR vs. XIRR, and walk through a step-by-step example of how XIRR handles irregular mutual fund transactions.

---

What is XIRR (Extended Internal Rate of Return)?

XIRR is a mathematical metric used to calculate the annualized internal rate of return for a series of cash flows occurring at irregular intervals. Unlike the standard Internal Rate of Return (IRR), which assumes that cash flows occur at equal time intervals (such as monthly or annually), XIRR takes into account the exact dates of each transaction.

XIRR is a money-weighted return metric. This means it is highly sensitive to the timing and magnitude of your cash flows. If you deposit a large sum of money right before a major market rally, your XIRR will be significantly higher than if you had deposited that same sum right before a market drop, even if the underlying assets performed identically. XIRR is the standard performance metric used by mutual fund portals, banks, and investment platforms to display your personal investment returns.

---

The Mathematical Equation Behind XIRR

The XIRR is the discount rate ($r$) that sets the Net Present Value ($NPV$) of all cash flows (both positive and negative) equal to zero.

The equation is represented as:

> Formula:

> NPV = \sum_{i=1}^{N} [ CF_i / (1 + r)^((d_i - d_1) / 365) ] = 0

Where:

* CF_i = The $i$-th cash flow amount.

* Negative cash flows (-): Outflows (money you invest or pay out).

* Positive cash flows (+): Inflows (money you withdraw, dividends received, or the current value of your portfolio if you were to redeem it today).

* d_i = The exact date of the $i$-th cash flow.

* d_1 = The start date (the date of the very first transaction).

* r = The annualized XIRR (solved as a decimal).

* (d_i - d_1) / 365 = The fraction of a year that has elapsed between the first cash flow and the $i$-th cash flow.

Why Do We Need Iterative Solving?

Because the exponent (d_i - d_1) / 365 is a fraction, this formula becomes a high-degree polynomial equation. There is no algebraic way to solve for $r$ directly. Instead, computers and calculators use numerical methods, such as the Newton-Raphson method or the Secant method, to iterate through values of $r$ until the $NPV$ gets close to zero.

---

CAGR vs. XIRR: When to Use Which

Choosing the right metric depends entirely on the flow of money in your portfolio.

| Feature | CAGR | XIRR |

| :--- | :--- | :--- |

| Cash Flows | Single starting deposit, single ending redemption. No intermediate transactions. | Multiple deposits, withdrawals, dividends, and redemptions. |

| Transaction Dates | Start and end dates only. | Irregular, exact dates for every transaction. |

| Return Type | Time-weighted (measures asset performance, ignoring investor behavior). | Money-weighted (measures personal investor experience, including timing of deposits). |

| Best Used For | Evaluating index growth, benchmarking single-stock performance. | Personal mutual fund portals, stock portfolios with active trading, SIPs. |

If you calculate the CAGR of a mutual fund over 5 years, you are measuring how the fund itself grew. If you calculate the XIRR of your investments in that same fund, you are measuring how your specific dollars grew, taking into account when you bought and sold units.

---

Step-by-Step XIRR Calculation Example

Let's model an investor who makes irregular transactions in a mutual fund throughout 2024 and 2025.

Cash Flow Table:

1. Jan 01, 2024: Initial Investment of $5,000 (Outflow: -5,000)
2. Jun 15, 2024: Additional Top-up of $2,000 (Outflow: -2,000)
3. Dec 20, 2024: Dividend Payout of $500 (Inflow: +500)
4. Jun 01, 2025: Final Portfolio Value of $7,800 (Inflow: +7,800 representing current value if redeemed)

Step 1: Establish the Start Date ($d_1$) and Calculate Elapsed Days

* d_1 = January 1, 2024 (Day 0)

* Transaction 2 (Jun 15, 2024): Days between Jan 01, 2024 and Jun 15, 2024 = 166 days

* Transaction 3 (Dec 20, 2024): Days between Jan 01, 2024 and Dec 20, 2024 = 354 days

* Transaction 4 (Jun 01, 2025): Days between Jan 01, 2024 and Jun 01, 2025 = 517 days

Step 2: Set up the NPV Equation

NPV = -5,000 / (1 + r)^(0 / 365) - 2,000 / (1 + r)^(166 / 365) + 500 / (1 + r)^(354 / 365) + 7,800 / (1 + r)^(517 / 365) = 0

Simplifying the exponents:

NPV = -5,000 - 2,000 / (1 + r)^(0.4548) + 500 / (1 + r)^(0.9699) + 7,800 / (1 + r)^(1.4164) = 0

Step 3: Solve for $r$ using Numerical Iteration

Using a numerical solver (which tries different rates of $r$ to balance the equation):

* If we try r = 0.08 (8.00%): NPV ≈ $232.15 (Too low, need a higher rate to discount the positive flows)

* If we try r = 0.12 (12.00%): NPV ≈ -$14.50 (Close, but slightly too high)

* If we try r = 0.1172 (11.72%): NPV ≈ 0.00

The solver converges at r = 11.72%. Therefore, the XIRR for this irregular investment sequence is 11.72%.

---

FAQ: Frequently Asked Questions

1. Why does my XIRR calculation return an error?

XIRR calculations will fail or return an error for two main reasons:

* Sign Conventions: You must have both positive and negative values in your cash flow list. If all numbers are positive or all are negative, the equation cannot balance to zero.

* Invalid Dates: Dates must be formatted correctly, and chronological order is preferred. Duplicate dates with different values can also cause numerical errors.

2. Can XIRR be used to calculate stock returns?

Yes. XIRR is highly effective for stock portfolios where you buy shares at different times, receive dividend payouts, sell chunks of shares, and hold a terminal valuation. It gives you a highly accurate view of your actual annualized return.

3. How does XIRR handle tax and transaction fees?

XIRR is calculated based on the actual cash flows that enter and exit your investment account. If you pay transaction fees or taxes upon redemption, you should deduct those costs from the cash flow values to calculate your net, post-tax XIRR.

---

Calculate Your Irregular Returns

Do you have a list of uneven investment deposits, payouts, and withdrawals? Instead of struggling with complex spreadsheets, use our interactive XIRR calculator to find your exact annualized returns instantly:

👉 XIRR Calculator