XIRR Calculator

The XIRR Calculator helps you determine the Extended Internal Rate of Return for a series of cash flows that occur at irregular intervals. Unlike a simple annual return, XIRR provides a more accurate annualized return for investments where you make multiple deposits and withdrawals over time, such as SIPs, mutual funds, or stock portfolios.

This tool is essential for investors who want to understand the true performance of their investments, taking into account the exact timing and amount of each transaction. By inputting your investment dates and corresponding amounts (deposits as negative, withdrawals as positive), you can quickly calculate the annualized return your investment has generated.

Calculate Your Investment's XIRR

Enter your investment transactions below. Use a negative value for money invested (outflow) and a positive value for money received (inflow).

Date: Amount (₹):

Results

Calculated XIRR

How XIRR is Calculated

The Extended Internal Rate of Return (XIRR) is a sophisticated financial metric used to calculate the annualized return for a series of cash flows that are not necessarily periodic. It is the discount rate at which the Net Present Value (NPV) of all cash flows (both inflows and outflows) equals zero.

Formula

The XIRR is found by solving for r in the following equation:

NPV = Σ (C_i / (1 + r)^{(d_i - d₀) / 365}) = 0

Where:

C_i = The i-th cash flow (amount). Negative for outflows (investments), positive for inflows (withdrawals/returns).
d_i = The date of the i-th cash flow.
d₀ = The date of the first cash flow (or any reference date).
r = The XIRR (the rate we are solving for).
Σ = Summation over all cash flows.
365 = Number of days in a year (for annualization).

Methodology

Since the XIRR formula cannot be solved algebraically for r, it is typically calculated using an iterative numerical method, such as the Newton-Raphson method. This method involves making an initial guess for r and then refining it through successive approximations until the NPV of the cash flows is sufficiently close to zero.

The calculator performs these iterations internally to find the most accurate XIRR for your provided cash flows.

Assumptions

All cash flows are reinvested at the XIRR rate.
The calculation assumes a 365-day year for annualization.
At least one negative cash flow (investment) and one positive cash flow (return/withdrawal) are required for a meaningful XIRR calculation.

Understanding Your XIRR Result

The XIRR result is presented as an annualized percentage. It represents the effective rate of return your investment has generated, considering the exact dates and amounts of all your transactions. A higher XIRR indicates better investment performance.

Positive XIRR: Your investment has generated a profit on an annualized basis.
Negative XIRR: Your investment has incurred a loss on an annualized basis.
Zero XIRR: The total value of your inflows equals the total value of your outflows, effectively breaking even.

Comparing the XIRR of different investments allows you to assess their performance on a standardized, annualized basis, even if their cash flow patterns are irregular. It's a powerful tool for evaluating the true profitability of your portfolio.

Worked Example: XIRR Calculation

Let's consider an investor, Mr. Sharma, who made the following transactions in a mutual fund:

Date	Transaction Type	Amount (₹)
2021-04-15	Investment (Outflow)	-50,000
2022-01-20	Additional Investment (Outflow)	-30,000
2023-03-10	Partial Withdrawal (Inflow)	20,000
2024-04-15	Final Redemption (Inflow)	85,000

Calculation Steps:

Identify Cash Flows and Dates:
- C1 = -50,000, d1 = 2021-04-15
- C2 = -30,000, d2 = 2022-01-20
- C3 = 20,000, d3 = 2023-03-10
- C4 = 85,000, d4 = 2024-04-15
Set Reference Date (d₀): The earliest date, 2021-04-15.
Calculate Days from Reference Date:
- d1 - d0 = 0 days
- d2 - d0 = 280 days (from 2021-04-15 to 2022-01-20)
- d3 - d0 = 694 days (from 2021-04-15 to 2023-03-10)
- d4 - d0 = 1096 days (from 2021-04-15 to 2024-04-15)
Apply XIRR Formula Iteratively: The calculator uses numerical methods to find 'r' such that:
-50,000/(1+r)^0/365 + -30,000/(1+r)^280/365 + 20,000/(1+r)^694/365 + 85,000/(1+r)^1096/365 = 0

Result:

After performing the iterative calculation, the XIRR for Mr. Sharma's investment would be approximately 7.85%.

This means that, considering all his investments and withdrawals at their exact dates, his mutual fund portfolio has generated an annualized return of 7.85%.

What is XIRR?

XIRR, or Extended Internal Rate of Return, is a financial metric used to calculate the annualized return for a series of cash flows that occur at irregular intervals. It is a more flexible and accurate measure of investment performance compared to the traditional Internal Rate of Return (IRR), which assumes periodic cash flows.

Why XIRR is Important for Indian Investors

Many popular investment avenues in India, such as Systematic Investment Plans (SIPs) in mutual funds, stock market investments, or even real estate transactions, involve cash flows that are not strictly periodic. For instance, SIPs might have varying payment dates due to holidays or bank processing, and stock investments involve buying and selling shares at different times. In such scenarios, XIRR provides a true picture of the investment's performance.

SIPs and Mutual Funds: If you invest through SIPs and make occasional lump sum investments or withdrawals, XIRR accurately reflects the return on your entire investment journey.
Stock Portfolios: For active traders or long-term investors who buy and sell stocks at different times, XIRR helps evaluate the overall profitability of their stock holdings.
Real Estate: When buying, renovating, and selling properties, XIRR can help assess the annualized return on the capital deployed over the project's duration.

XIRR vs. CAGR (Compound Annual Growth Rate)

While both XIRR and CAGR measure annualized returns, they apply to different scenarios:

CAGR: Best suited for investments with a single initial investment and a single final value, or for measuring the growth of a specific metric (like revenue) over a period. It doesn't account for multiple intermediate cash flows.
XIRR: Designed specifically for investments with multiple, irregular cash inflows and outflows. It provides a more comprehensive and accurate return for dynamic investment portfolios.

In essence, XIRR is the most appropriate metric for evaluating the performance of investments where the timing and amount of cash flows are not uniform, offering a robust and reliable measure of your actual annualized returns.

Important Considerations

Data Accuracy: The accuracy of the XIRR calculation heavily depends on the correctness of the dates and amounts of your cash flows. Any error in input will lead to an inaccurate result.
At Least One Inflow and Outflow: For a meaningful XIRR, you must have at least one negative cash flow (investment) and one positive cash flow (return/withdrawal). If all cash flows are of the same sign, the calculator may not find a valid XIRR or the result may be misleading.
No Guaranteed Returns: The XIRR is a historical measure of performance. It does not guarantee future returns or indicate that similar returns will be achieved in the future.
Inflation and Taxes: The calculated XIRR is a nominal return. It does not account for inflation or taxes. Your real (inflation-adjusted) and post-tax returns will be lower.
Multiple Solutions: In rare cases, complex cash flow patterns can lead to multiple XIRR values. This calculator aims to find the most financially relevant solution.
Investment Fees: The XIRR calculation does not explicitly include investment fees unless they are accounted for as part of your cash flow amounts (e.g., net amounts after fees).

Common Questions about XIRR

What is the difference between XIRR and IRR?

IRR (Internal Rate of Return) assumes that cash flows occur at regular intervals (e.g., monthly, annually). XIRR (Extended Internal Rate of Return) is a more flexible version that can handle cash flows occurring at irregular dates, making it suitable for real-world investment scenarios like SIPs or stock trading.

When should I use an XIRR Calculator?

You should use an XIRR calculator when you have made multiple investments and withdrawals at different, irregular dates in an investment, such as a mutual fund SIP, a stock portfolio, or a real estate project. It helps you find the true annualized return of your overall investment.

Can XIRR be negative?

Yes, XIRR can be negative. A negative XIRR indicates that your investment has resulted in a loss on an annualized basis, meaning the total value of your outflows exceeded the total value of your inflows, considering the time value of money.

What if I only have investments and no withdrawals?

If you only have investments (negative cash flows) and no withdrawals or current valuation (positive cash flow), the XIRR cannot be calculated meaningfully. To get an XIRR, you need to include a final positive cash flow representing the current market value of your investment as of a specific date.

How many cash flow entries do I need for XIRR?

You need at least two cash flow entries for XIRR: typically, one initial investment (negative) and one final redemption/current value (positive). For meaningful results, it's best to include all relevant transactions.

Does XIRR account for inflation or taxes?

No, XIRR calculates the nominal rate of return. It does not automatically adjust for inflation or account for any taxes (like Capital Gains Tax) that might be applicable to your investment returns. You would need to consider these factors separately to determine your real, post-tax return.

Related Investment Tools

SIP Calculator: Calculate the future value of your Systematic Investment Plans.
Lumpsum Calculator: Project the growth of a one-time investment over time.
FD Calculator: Determine the maturity value and interest earned on Fixed Deposits.
PPF Calculator: Estimate returns and maturity value for your Public Provident Fund investments.
SWP Calculator: Plan regular withdrawals from your mutual fund investments.