XIRR Calculator

When you invest through a Systematic Investment Plan (SIP), you may put money into a mutual fund every month rather than investing the entire amount at once. Since each instalment is invested on a different date, calculating your actual investment return can be more complicated than simply comparing the amount invested with the current value.

An XIRR Calculator helps you estimate the annualised return on investments made or withdrawn on different dates. It considers the timing and amount of each cash flow, making it particularly useful for evaluating SIPs, mutual fund investments, and portfolios with multiple transactions.

With an XIRR return calculator, you can enter your investment dates, amounts, and current portfolio value to understand how your money has performed over time. The result can help you review your investment progress, compare returns, and make more informed financial decisions.

What Is an XIRR Calculator?

An XIRR Calculator is an online financial tool that calculates the annualised rate of return for a series of cash flows occurring on different dates. XIRR stands for Extended Internal Rate of Return and is commonly used to measure returns when investments are made at irregular intervals.

Unlike a simple return calculation, XIRR accounts for both the amount and timing of each cash flow. This makes it suitable for investments where you make monthly SIP contributions, add money at different times, or withdraw funds before the end of the investment period.

For example, suppose you invest ₹5,000 every month in a mutual fund. Each instalment remains invested for a different length of time. An XIRR Calculator considers the dates of those instalments and the value of your investment on the calculation date to estimate an annualised return.

An XIRR calculator online can be useful for:

• Evaluating mutual fund SIP returns.
• Measuring returns from multiple investments made on different dates.
• Reviewing partial withdrawals and additional contributions.
• Estimating the annualised return on an investment portfolio.
• Comparing investment performance over a specific period.

XIRR is an estimate based on the cash flows and dates you enter. It does not guarantee future returns or indicate whether an investment is suitable for your financial goals.

How to Use an XIRR Calculator?

Using an XIRR Calculator is straightforward. You need the dates and amounts of your investments, any withdrawals, and the current or final value of the investment.

Follow these steps:

1. Enter the investment date: Add the date on which your first investment was made.
2. Enter the investment amount: Record the amount invested on that date.
3. Add subsequent transactions: Enter every additional contribution, SIP instalment, or withdrawal with its corresponding date.
4. Enter the final investment value: Add the current portfolio value or the amount received when the investment was sold.
5. Check the cash-flow signs: Treat money invested as a negative cash flow and money received, including the final value, as a positive cash flow.
6. Calculate XIRR: Click the calculate button to estimate the annualised return.
7. Review the result: Use the percentage to understand how your investment performed over the period covered by the cash flows.

For an accurate result, ensure that the transaction dates and amounts match your investment records. If your portfolio includes multiple funds, calculate each fund separately or use a combined cash-flow calculation if you want to evaluate the portfolio as a whole.

When Should You Use an XIRR Calculator?

An XIRR Calculator is most useful when your investments involve multiple cash flows on different dates. A simple CAGR calculation may not adequately represent these investments because it generally assumes one initial investment and one final value.

Consider using XIRR in the following situations:

• Monthly SIP investments: Calculate the annualised return when you invest a fixed amount every month.
• Irregular investments: Measure returns when you add money at different intervals or in varying amounts.
• Partial withdrawals: Account for money withdrawn from your investment before the final calculation date.
• Multiple mutual fund transactions: Evaluate investments involving purchases, redemptions, and additional contributions.
• Portfolio reviews: Estimate the annualised return on a portfolio with several dated cash flows.
• Investment comparisons: Compare returns across investments when their cash-flow dates and patterns are taken into account.

If you made a single lump-sum investment and held it until the end of the period, CAGR may be sufficient. If you invested or withdrew money at different times, XIRR is generally more appropriate.

How This XIRR Calculator Works

An XIRR Calculator estimates the annualised rate of return that makes the net present value of all dated cash flows equal to zero. In simple terms, it finds the annual rate that balances the money you invested against the money you received, taking the dates of the transactions into account.

The XIRR formula is:

Where:

• C_i = Cash flow for each transaction, including investments and withdrawals.
• r = XIRR, expressed as an annual rate.
• d_i = Date of each cash flow.
• d₁ = Date of the first cash flow.
• n = Total number of cash flows.

The calculator solves this equation numerically because the annualised rate cannot usually be isolated through a simple rearrangement.

Example of XIRR Calculation

Suppose you invest ₹10,000 in a mutual fund on 1 January and invest another ₹10,000 on 1 July. On 31 December, your investment is worth ₹22,000.

Date	Cash flow	Description
1 January	−₹10,000	First investment
1 July	−₹10,000	Second investment
31 December	+₹22,000	Final investment value

Your total contribution is ₹20,000, and the final value is ₹22,000. The simple total return is 10%, but the XIRR is higher because the second ₹10,000 was invested for only about half a year.

Using these illustrative dates and amounts, the annualised XIRR is approximately 13.5%. The exact result depends on the dates entered and the calculator's day-count convention.

This example shows why XIRR can be more informative than a simple percentage gain when investments are made at different times.

How to Enter Values Correctly

The accuracy of your XIRR result depends on entering the right cash flows and dates. Even a small input error can change the calculated return.

Follow these guidelines:

• Use actual transaction dates: Enter the date when each investment or withdrawal took place, rather than using the same date for every transaction.
• Enter investments as negative amounts: Money leaving your bank account to fund an investment should generally be entered as a negative cash flow.
• Enter withdrawals as positive amounts: Money received from a redemption or withdrawal should generally be entered as a positive cash flow.
• Include the current value: If you still hold the investment, enter its current market value as a positive cash flow on the valuation date.
• Include all relevant transactions: Account for additional investments and partial withdrawals within the calculation period.
• Check for duplicate entries: Avoid entering the same investment or redemption more than once.
• Use consistent units: Enter all amounts in the same currency, such as Indian rupees.

A standard XIRR calculation generally requires at least one negative cash flow and one positive cash flow. If all cash flows have the same sign, or if the transaction pattern does not produce a suitable solution, the calculator may not return a meaningful result.

Why Investors Prefer XIRR for SIP Evaluation

XIRR is widely used to evaluate SIP performance because each instalment is invested on a different date. Earlier instalments remain invested for longer, while more recent instalments have less time to grow or decline.

A simple total-return calculation shows the gain or loss relative to the money invested, but it does not fully account for when each instalment was made. XIRR accounts for the dates and amounts of those transactions.

For example, two investors may contribute the same total amount to the same mutual fund but invest on different dates. Their portfolio values and annualised returns can differ because their money was invested for different periods.

XIRR helps investors:

• Estimate the annualised return on SIP contributions.
• Account for additional investments and partial withdrawals.
• Review performance across a chosen period.
• Compare investment outcomes using dated cash flows.
• Understand how investment timing affects realised performance.

However, XIRR does not predict future performance. Past returns can differ significantly from future returns, especially in market-linked investments.

Things to Remember While Using XIRR

Before relying on an XIRR result, keep these points in mind:

• XIRR is an annualised return: It is not the same as the total percentage gain on your investment.
• Dates matter: Incorrect or approximate transaction dates can change the result.
• Include every relevant cash flow: Missing contributions or withdrawals can distort the calculated return.
• Account for the final value: For an investment you still hold, include its value on a specific valuation date.
• Fees and taxes may be excluded: Unless you include them in the cash flows, the result may not represent your final after-cost return.
• Past performance is not a guarantee: A high XIRR does not mean an investment will continue to deliver the same return.
• Unusual cash flows can complicate results: Multiple changes between investments and receipts can sometimes produce more than one mathematical solution or make a result difficult to interpret.
• Compare like with like: When comparing investments, use consistent valuation dates and consider differences in risk, costs, and cash-flow patterns.

What Does a Negative XIRR Mean?

A negative XIRR generally means the investment's dated cash flows have produced a loss on an annualised basis over the period being evaluated.

For example, suppose you invest ₹1,00,000 and the value of your investment falls to ₹90,000 after one year, with no other cash flows. The annualised return is approximately −10%.

For SIPs or investments with several transactions, the XIRR calculation also accounts for the dates and amounts of each contribution and withdrawal. A negative result may reflect a fall in market value, an unfavourable selling price, or the timing of your cash flows.

A negative XIRR does not automatically mean the investment will continue to lose value. Review the investment's purpose, time horizon, risk, and underlying performance before making a decision based on the result alone.

XIRR vs CAGR – Key Difference

XIRR and CAGR both express investment performance as an annualised percentage, but they are designed for different cash-flow patterns.

Feature	XIRR	CAGR
Best suited for	Multiple investments or withdrawals on different dates	A single initial investment and a final value
Cash-flow timing	Accounts for individual dates	Does not account for intermediate cash flows
Common use	SIPs, mutual fund transactions, portfolios with additions or withdrawals	Lump-sum investments held over a period
Calculation method	Solves for a rate using dated cash flows	Uses starting value, ending value, and time
Interpretation	Annualised return based on cash-flow timing	Compound annual growth rate between two values

For a single lump-sum investment with no intermediate cash flows, XIRR and CAGR will generally be close when the same start and end dates are used, though the exact result may differ because of the date convention.

For regular SIPs or irregular contributions, XIRR is generally the more appropriate measure.

Does XIRR Include Tax, Charges, or Exit Load?

An XIRR Calculator includes taxes, fees, and exit loads only if you account for them in the cash flows you enter.

For example, if you invest ₹10,000 and pay a ₹100 transaction charge separately, you can include the charge in the investment outflow if you want to measure your return after that cost. If your final redemption amount is already reduced by an exit load or tax, use the actual amount received.

For a realistic estimate:

• Use actual amounts invested, including relevant costs.
• Include the net amount received when redeeming an investment.
• Account for taxes paid separately if they are not already reflected in the cash flows.
• Check whether your fund's reported value includes any applicable charges.

A calculator using only investment contributions and the current portfolio value may show a return that differs from your final after-tax return.

Steps to Calculate XIRR in Excel

Microsoft Excel includes an XIRR function that calculates the annualised return for cash flows occurring on different dates.

Follow these steps:

Step 1: Enter transaction dates

In column A, enter the date of each investment, withdrawal, and final valuation.

Step 2: Enter cash flows

In column B, enter investments as negative values and withdrawals or final proceeds as positive values.

Step 3: Select a cell for the result

Enter the XIRR formula:

=XIRR(B2:B5,A2:A5)

Here, B2:B5 contains the cash flows and A2:A5 contains their corresponding dates. Adjust the ranges to match your data.

Step 4: Format the result as a percentage

Select the result cell and apply percentage formatting to make the annualised return easier to read.

Step 5: Check the inputs

Confirm that the dates are valid, cash flows have the correct signs, and the data contains both negative and positive values.

You can also provide an optional starting estimate, known as a guess, if Excel has difficulty finding a solution:

=XIRR(B2:B5,A2:A5,0.1)

In this example, 0.1 represents a starting estimate of 10%. It is not the assumed final return.

When to Use XIRR?

Use XIRR when you want to measure the annualised performance of an investment with multiple cash flows occurring on different dates.

Common use cases include:

• Mutual fund SIPs: Measure returns from monthly or irregular contributions.
• Additional investments: Include lump-sum additions made after the initial investment.
• Partial redemptions: Account for money received before the investment is fully sold.
• Portfolio performance: Evaluate a portfolio with multiple contributions and withdrawals.
• Private or alternative investments: Estimate returns when capital is contributed and distributions are received at different times, provided the cash flows can be represented meaningfully.

For a simple lump-sum investment with no intermediate transactions, CAGR may be sufficient. For an investment with multiple dated cash flows, XIRR generally gives a more useful annualised measure.

What Is the Difference Between CAGR and XIRR?

CAGR measures the compound annual growth rate between an investment's starting and ending values over a period. XIRR calculates an annualised return by considering the dates and amounts of all relevant cash flows.

The CAGR formula is:

Where n is the investment period in years.

For example, if ₹1,00,000 grows to ₹1,21,000 over two years, the CAGR is approximately 10% per year.

XIRR is better suited to situations where additional contributions or withdrawals occur during those two years. It uses each cash flow's date rather than treating the entire investment as if it were invested at the beginning.

Neither metric tells you what an investment will earn in the future. Both describe past performance based on the information used in the calculation.

Benefits of XIRR Calculator

An XIRR Calculator can help investors understand investment performance without having to solve a complex equation manually.

• SIP return estimation: Calculates annualised returns when contributions are made on different dates.
• Accurate cash-flow treatment: Accounts for the timing and size of investments and withdrawals.
• Simpler portfolio reviews: Helps evaluate investments with multiple transactions.
• Better performance comparisons: Provides an annualised measure for comparing investments with different cash-flow patterns, when interpreted carefully.
• Time savings: Performs the calculation quickly once the required data is entered.
• Flexible calculations: Allows you to evaluate different periods by changing the transactions and valuation date.
• Improved record analysis: Helps you use investment statements to understand your portfolio's historical performance.

For meaningful comparisons, consider investment risk, costs, taxes, and the period covered by the calculation in addition to the XIRR percentage.