₹ 1,000
₹ 10,00,000
BAJAJ ASSET MANAGEMENT LIMITED.


₹ 1,000
₹ 10,00,000
₹ 2,000
₹ 1,00,00,000
Here's the Extended Internal Rate of Return (XIRR) for your investments
An XIRR return calculator measures the annualised return on investments using their amounts and transaction dates. It is useful for SIPs and additional investments made at different times.
The Bajaj AMC online XIRR calculator lets you enter the investment dates and amounts, followed by the return date and return amount. It then helps you calculate XIRR online from those cash flows, without requiring you to work through the calculation manually.
The XIRR formula accounts for each cash flow separately because every investment or receipt may occur on a different date. XIRR is the value of r that satisfies:
i=0∑n(1+r)(di-d0)/365Ci=0
Where:
In formula-based calculations such as Excel, investments or other cash outflows are entered as negative values, while amounts received or the ending value are entered as positive values. The calculation considers the actual number of days between the cash-flow dates and uses a 365-day year.
Unlike CAGR, XIRR calculation cannot be reduced to a beginning value, ending value and time period when there are multiple cash flows. A calculator or spreadsheet function solves for the rate iteratively.
To calculate XIRR manually, you would need to test different rates until the discounted cash flows add up to approximately zero. This is why XIRR is generally calculated using Excel or an online calculator rather than by hand.
For example, suppose an investor invests ₹5,000 on the first day of every month for 12 months, taking the total investment to ₹60,000. If the investment is worth approximately ₹64,163 on 1 January of the following year, the XIRR based on those exact dates and cash flows is 13%. Each instalment has been invested for a different period, which is why the calculation considers every date separately.
The figures shown are for illustrative purpose only
Source: Microsoft Support, XIRR function.
You can calculate XIRR in Excel using the function:
=XIRR(values, dates, [guess])
Enter your cash flows in one column and their corresponding dates in another. For an investment return calculation, investment amounts are generally entered as negative cash flows, while redemption proceeds or the current value are entered as positive cash flows.
For example, if the values are in cells A2 to A6 and the corresponding dates are in B2 to B6, the formula would be:
=XIRR(A2:A6,B2:B6)
The guess argument is optional. Excel requires the values to contain at least one positive and one negative cash flow for XIRR to be calculated.
Source: Microsoft Support, XIRR function.
You can calculate XIRR for SIP instalments or other investments by entering each investment amount and date, followed by the current or redemption value and its date. Suppose you invested ₹20,000 on 1 January 2026 and the investment is worth ₹22,600 on 1 January 2027.
This calculator accepts up to four investment entries and one final investment value. For longer SIP histories or transactions involving intermediate withdrawals, use Excel’s XIRR function with the complete cash-flow record.
The figures shown are for illustrative purpose only
An XIRR calculator is useful when an investment involves multiple cash flows on different dates. Common examples include SIP instalments, additional lumpsum investments, top-ups and a series of investments that you want to measure against their current or redemption value. You can also use a lumpsum XIRR calculator for a single investment and its ending value. CAGR is usually sufficient when there are no intermediate cash flows.
XIRR does not separately calculate tax, charges or exit load. It calculates the return from the cash flows entered.
If the return amount you enter is after applicable tax, exit load or other deductions, the resulting XIRR will reflect that net cash flow. If you enter an amount before those deductions, they will not be separately accounted for by the calculation.
For mutual funds, expenses that are already incorporated into the scheme’s NAV are also reflected in a portfolio value calculated using that NAV. SEBI’s valuation framework requires accrued expenses and income to be incorporated into the computation of NAV.
Source: SEBI, Master Circular for Mutual Funds, 20 March 2026.
XIRR, CAGR and absolute return all measure investment performance, but they answer different questions. The appropriate measure depends largely on whether the investment involves a single cash flow or several transactions made on different dates.
| Factor | XIRR | CAGR | Absolute return |
| What it measures | Annualised return based on multiple dated cash flows | Annualised growth between a starting value and an ending value | Total percentage gain or loss over the investment period |
| Considers time | Yes | Yes | No |
| Multiple cash flows | Accounts for investments and withdrawals on different dates | Does not account for intermediate cash flows | Does not account for when individual cash flows occurred |
| SIPs | Suitable because each instalment has a different investment date | Not suitable for measuring the investor’s return across multiple SIP instalments | May show the total gain or loss but not the annualised return based on each instalment’s holding period |
| Lumpsum investments | Can be used | Usually suitable for measuring annualised growth | Useful for measuring the total gain or loss |
| Result | Annualised percentage | Annualised percentage | Total percentage return |
For an SIP, XIRR is useful because ₹10,000 invested today has been invested for longer than ₹10,000 contributed several months later. Absolute return can show how much the investment has gained or lost in total, but it does not account for how long each contribution remained invested. CAGR is generally more useful when there is one starting investment and one ending value.
Source: Microsoft Support, XIRR function and calculate a compound annual growth rate (CAGR) in Excel.
A negative XIRR means that the dated cash flows produce an annualised rate of return below zero.
For an investment with contributions followed by one current or redemption value, this can occur when the value received is not sufficient to offset the amounts invested after accounting for when each investment was made. With more complex cash flows, the full pattern of investments and receipts needs to be considered rather than comparing only the total invested with the ending value.
A negative XIRR reflects the return over the period being measured. It does not indicate what the investment may do in the future.
An XIRR calculator can be useful in several ways:
XIRR is an annualised return based on the cash flows and dates entered, not the return earned in every individual year. Annualised figures over short periods can also appear unusually high or low, so the length of the measurement period matters.
For an accurate calculation, include all relevant cash flows, such as investments, additional contributions, withdrawals and redemptions, along with their actual transaction dates. Leaving out a transaction or entering an incorrect date can change the XIRR.
When comparing XIRRs, consider investments with a similar asset class, risk profile and measurement period. For mutual funds, a relevant benchmark and the performance of comparable schemes can provide additional context. Two investors in the same mutual fund may also have different XIRRs because their investment amounts and transaction dates can differ.
Past performance may or may not be sustained in future




















A 20% XIRR means your dated investments and receipts produced a 20% annualised return over the measured period. It does not mean you earned exactly 20% every year.
Yes, XIRR can be negative. A negative XIRR means the investment’s dated cash flows resulted in an annualised return below zero over the period being measured.
Use XIRR for multiple investments or withdrawals on different dates, and CAGR for one investment with no intermediate cash flows. An XIRR return calculator is therefore more suitable for measuring SIP performance.
XIRR in SIP is the annualised return calculated after considering the amount and date of every SIP instalment. Since each instalment has a different investment date and holding period, XIRR treats them as separate cash flows and combines them into one annualised return. CAGR is generally more suitable for an investment with one starting value and one ending value.
XIRR is expressed as an annualised percentage, but you can calculate it whenever you have updated cash flows and an investment value. To calculate XIRR for SIP, use each instalment’s actual date and amount.
For investments followed by one ending value, XIRR is zero when that value equals the total invested. If an online XIRR calculator displays 0%, also check your entries and whether a very small return has been rounded to zero.
A positive XIRR indicates an annualised gain; a negative XIRR indicates an annualised loss. For example, 10% represents a 10% annualised return based on your cash-flow dates, rather than a 10% total gain.
Neither 7% nor 15% is automatically a good XIRR. Compare the result with investments of similar risk over the same period. Calculate XIRR using all relevant transactions before assessing performance.
To use Bajaj AMC’s XIRR calculator online, enter investment amounts as positive numbers; the tool treats them as outflows automatically. Add the investment value and valuation date under Returns Amount and Returns Date. In Excel, enter investments as negative values and receipts as positive values.
Call, chat or write to us if you
need investment help

Toll-free number
Write to us at
Investor WhatsApp channel
Share your details and our experts will guide you.

By submitting my details, I agree to receive a call from
Bajaj AMC for assistance.
The calculator alone is not sufficient and shouldn’t be used for the development or implementation of an investment strategy. This tool is created to explain basic financial / investment related concepts to investors. The tool is created for helping the investor take an informed investment decision and is not an investment process in itself. Bajaj AMC has tied up with AdvisorKhoj for integrating the calculator to the website. Mutual Fund does not provide guaranteed returns. Also, there is no assurance about the accuracy of the calculator. Past performance may or may not be sustained in future, and the same may not provide a basis for comparison with other investments. Investors are advised to seek professional advice from financial, tax and legal advisor before investing in mutual funds.

Need help planning your investments?

Our Investment Philosophy reflects what we, as an organisation, believe will generate a good return on equity investment for our investors in the long term. It dictates our goals and guides decision making.
Alpha (a) is a term used in investing to describe an investment strategy’s ability to beat the market.
Alpha is thus also often referred to as excess return or the abnormal rate of return in relation to a benchmark, when adjusted for risk. Essentially, it means doing better than the crowd without taking disproportionate risk.

Collecting superior information
Analysts and portfolio managers strive to collect superior information about the business and the management of the company. They try to generate superior earnings forecast and the balance strength of the company and the industry, thereby trying to 'beat the market' on information edge. This is an important source of alpha for an investor. However, over the years, retaining the information edge has become more difficult and expensive. With a whole lot of investors trying to collect superior information, how can an investor be sure to continuously have accurate and material information about the companies, ahead of others, all the time?

Processing information better
Even if you don't have material information earlier than the crowd, you can still generate better outcomes if you are able to process this information better. Investors develop models and algorithms with enhanced predictive powers to forecast the next move. Fund managers who invest based on some pure formal analytical models are quantitative managers. Here, the goal is to try and beat other investors based on the sophistication of procedures or analytics. The analytical edge can be quite useful until it gets copied by many, and then it may stop generating superior returns.

Exploiting behavioural biases
As the name suggests, this edge is achieved by superior behaviour in reacting to the inputs available to maximise alpha. Modern finance assumes people behave with extreme rationality. However, researchers in behavioural finance have shown that this is not true. Moreover, these deviations from rationality are often systematic. Behavioural managers try to exploit situations where securities are mispriced by the market because of behavioural factors. At Bajaj AMC, we endeavour to combine the best of these edges.