XIRR Calculator

What is an XIRR Calculator?

An XIRR Calculator, or Extended Internal Rate of Return Calculator, is an online financial tool that calculates the true annualised return on an investment that involves multiple cash flows happening at different points in time. Instead of assuming a single investment made on one date, it accounts for every individual transaction, including its date and amount, to give you your real personal rate of return.

This calculator is essential for any investor who invests through a Systematic Investment Plan (SIP), makes additional lump sum top-ups at irregular intervals, or partially withdraws from a mutual fund at different times. If you have ever wondered what your actual annual return is across your entire investment history, the XIRR Calculator gives you that answer with precision. It works hand in hand with tools like the Dhanarthi SIP Calculator for planning and the Dhanarthi Mutual Fund Returns Calculator for benchmarking.

How Does the XIRR Calculator Work?

The XIRR Calculator works by finding the single annualised rate of return that, when applied to each and every cash flow in your investment history, makes the net present value (NPV) of all those cash flows equal to zero.

Here is what happens step by step. You provide all your investment transactions as negative cash flows (money going out) along with their respective dates, and your current portfolio value or redemption amount as a positive cash flow (money coming in) with today's date or the date of redemption. The calculator then uses an iterative numerical method called the Newton-Raphson method to solve for the rate r that satisfies this condition:

NPV = Sum of [ CFi / (1 + r) raised to the power (di minus d0) / 365 ] = 0

The rate it finds is expressed as an annual percentage and represents your actual, time-weighted, personalised return across the entire investment period. It is not an average or an estimate. It is the exact annualised return that accounts for how long each rupee was invested.

For example, a SIP instalment made three years ago has had more time to compound than one made three months ago. XIRR respects that difference. CAGR, by contrast, does not. This is why XIRR is the standard metric used by all major mutual fund platforms and financial advisors to report personal investment performance.

XIRR Formula

The mathematical condition that XIRR satisfies is:

Sum of [ CFi / (1 + XIRR) raised to the power (di - d0) / 365 ] = 0

Where:

Since this equation cannot be solved directly, the calculation uses iterative trial-and-error, typically beginning with an initial guess of 10%, to converge on the exact value. This is why XIRR calculations require a calculator or software like Microsoft Excel. The Excel formula for XIRR is simply: =XIRR(values, dates, [guess]), where values is your column of cash flows and dates is your column of corresponding transaction dates.

Example Calculation

Let us walk through a practical example of how XIRR is calculated for a simple SIP investment.

Scenario: An investor starts a monthly SIP of Rs. 5,000 for 6 months and redeems the full amount at the end.

Cash Flows:

• Total Invested: Rs. 30,000
• Redemption Value: Rs. 32,000
• Profit: Rs. 2,000

If you apply the XIRR formula to these values and dates, the result works out to approximately 25.38% per annum. This might seem high for a Rs. 2,000 profit, but it is because the earlier investments were only in the market for a short time, meaning each rupee earned that return over a compressed period. This is what XIRR captures. CAGR applied naively to the same data would give a misleading, lower figure because it does not account for the staggered timing of each instalment.

How to Use Dhanarthi's XIRR Calculator?

• Step 1: Select Your Input Mode: The Dhanarthi XIRR Calculator typically offers two modes. In SIP Mode, you simply enter your monthly SIP amount, the start date, the end date, and your current portfolio value. The calculator auto-generates all the cash flows. In Manual Mode, you enter each individual transaction with its date and amount for greater precision.
• Step 2: Enter Investment Transactions as Negative Values: Each amount you invested should be entered as a negative number. This represents money flowing out of your pocket and into the investment.
• Step 3: Enter the Current Value or Redemption as a Positive Value: Your current portfolio value or the amount you received upon redemption should be entered as a positive number. This represents money flowing back to you.
• Step 4: Enter the Correct Date for Each Transaction: The accuracy of XIRR depends entirely on the dates being correct. Use the exact dates of each SIP debit or redemption from your mutual fund statement.
• Step 5: Click Calculate: The calculator immediately displays your XIRR as an annualised percentage, giving you your true personal rate of return on that investment.
• Step 6: Compare and Interpret: Compare your XIRR against the fund's own CAGR (published on its fact sheet) to understand how your entry timing and investment pattern influenced your actual returns versus the fund's theoretical performance.

Benefits of Using This Calculator

• Gives You Your True Personal Rate of Return: The single biggest benefit of the XIRR Calculator is that it tells you what you actually earned, not what the fund delivered in isolation. Two investors in the same fund can have different XIRRs depending on when they started and how much they invested each month. This calculator gives you your specific number.
• Handles Irregular Cash Flows Perfectly: Whether you missed an SIP instalment, made a lump sum top-up during a market dip, or partially redeemed some units, XIRR handles all of this seamlessly. No other simple metric like CAGR or absolute return can accommodate these real-world scenarios. You can also use it alongside the Dhanarthi CAGR Calculator to compare your personal returns against the fund's reported returns.
• Helps Compare Performance Across Different Investments: Once you know the XIRR of each investment in your portfolio, comparing them becomes straightforward. You can immediately see which SIP, mutual fund, or stock has delivered the best annualised returns given the timing of your actual transactions.
• Works for All Investment Types: XIRR is not limited to mutual funds. You can use it for stocks bought on different dates, recurring deposits, real estate rental income, fixed deposits with varying tenures, or any investment where money flows in and out over time.
• Eliminates Guesswork and Manual Errors: Calculating XIRR manually using Excel requires careful entry of multiple rows of data and the correct application of the formula. The online calculator eliminates all of that, giving you instant results without the risk of spreadsheet errors.

Who Should Use This XIRR Calculator?

• SIP Investors in Mutual Funds: This is the primary audience. Every investor running a monthly or quarterly SIP who wants to know their true annualised return should use the XIRR Calculator. Mutual fund apps and platforms display XIRR by default for SIP portfolios for exactly this reason.
• Investors with Irregular Investment Patterns: People who invest lump sums at different times, pause and restart SIPs, or make one-time top-ups during market corrections will find CAGR completely inadequate for measuring their returns. XIRR is the only accurate metric for such portfolios.
• Investors Who Have Made Partial Withdrawals: If you have redeemed part of your mutual fund units through a Systematic Withdrawal Plan or an ad hoc redemption, the XIRR Calculator allows you to factor those outflows in and still get an accurate picture of your net annualised return. The Dhanarthi SWP Calculator can help you plan withdrawals, while the XIRR Calculator helps you evaluate performance after the fact.
• Financial Advisors and Wealth Managers: Professionals who need to report meaningful performance numbers to clients, especially those with complex SIP histories, step-up investments, or rebalancing events, rely on XIRR as the standard reporting metric.
• Business Owners Evaluating Project Returns: XIRR is also used in corporate finance to evaluate the return on projects or capital expenditure where cash flows are not evenly spaced. Business owners comparing the return from a ব্যবসা investment against a mutual fund SIP can use XIRR to compare both on an equal, annualised basis.
• Anyone Preparing for Retirement or a Major Goal: Investors tracking progress toward a long-term goal like retirement need to periodically check their actual annualised returns to ensure they are on track. XIRR gives them that benchmark. It pairs well with the Dhanarthi Retirement Calculator for a complete goal-tracking picture.

Where Can You Use This XIRR Calculator?

• Reviewing Annual Mutual Fund Portfolio Performance: At the end of each financial year, use the XIRR Calculator to evaluate how each fund in your portfolio has truly performed given your specific investment pattern. This is far more meaningful than just looking at the fund's published 1-year or 3-year CAGR.
• Before Redeeming an Investment: Calculate your current XIRR before redeeming to understand whether you have met your target return. If your XIRR is lower than expected, you may want to remain invested longer rather than booking sub-optimal returns.
• When Comparing Two Investment Products: Use XIRR to compare, say, a mutual fund SIP against a recurring deposit or a stock purchased in tranches. Both investments will have multiple cash flows, and only XIRR gives you a fair, apples-to-apples annualised comparison.
• When Evaluating a Fund Manager's Value: Compare your XIRR against the benchmark index CAGR over the same period. If your XIRR is consistently higher than the benchmark, the fund and your investment timing are working well together. If it is lower, it may be time to reconsider the fund.
• For Tax Planning and Gain Assessment: XIRR gives you the most accurate view of your real returns, which is useful context when using the Dhanarthi Income Tax Calculator or the Dhanarthi TDS Calculator to estimate your capital gains tax obligations.
• Anytime, on Any Device: The Dhanarthi XIRR Calculator is available on mobile and desktop, so you can quickly evaluate any investment performance while reviewing your portfolio statement, speaking with a financial advisor, or planning your next investment move.

XIRR vs CAGR

Understanding when to use XIRR versus CAGR is one of the most important distinctions in personal finance in India, especially for mutual fund investors.

The key insight is this: mutual fund fact sheets show CAGR to tell you how the fund performed. Your portfolio statement shows XIRR to tell you how you performed as an investor in that fund. These two numbers can be very different depending on when you started investing, whether you continued investing during market corrections, and whether you made any withdrawals. Neither metric is categorically better. They answer different questions. For any investment involving more than one transaction, XIRR is the only accurate metric.

XIRR vs IRR

While XIRR and IRR (Internal Rate of Return) are related concepts, they are designed for different scenarios.

IRR assumes that cash flows occur at perfectly equal intervals, such as exactly one year apart or exactly one month apart. It does not use actual calendar dates. XIRR extends IRR by using the exact dates of each cash flow, making it suitable for real-world investments where transactions rarely happen at perfectly uniform intervals.

In practice, almost all personal investment scenarios involve uneven intervals. SIP dates shift slightly due to weekends and holidays. Lump sum investments happen on arbitrary dates. Partial redemptions are made based on financial needs, not a calendar. For all of these cases, XIRR is the appropriate metric, not IRR.

What is a Good XIRR for Mutual Funds in India?

A good XIRR depends on the type of fund you are invested in and the broader market conditions during your investment period.

• For equity mutual funds with a long investment horizon of five years or more, an XIRR of 12% to 15% is considered good and aligns with the historical long-term return of the Nifty 50 index. An XIRR above 15% is excellent. An XIRR between 8% and 12% is acceptable, especially over shorter periods or in volatile market phases. An XIRR below 6% means your real wealth is barely growing after accounting for inflation.
• For hybrid or balanced advantage funds, a good XIRR typically falls in the range of 9% to 12%.
• For debt funds and liquid funds, a good XIRR is 6% to 8%, in line with current interest rate environments.

Always compare your XIRR against two benchmarks: the inflation rate and the relevant index CAGR for the same period. If your XIRR beats both, your investment and timing have worked well together.

Common Mistakes to Avoid

• Entering Wrong Dates: The accuracy of XIRR is entirely dependent on accurate dates. A single incorrect date in the cash flow table can significantly distort the result. Always verify transaction dates against your actual mutual fund statement or broker record, not from memory.
• Forgetting to Enter All Transactions: If you missed a SIP instalment, made an extra top-up, or received a dividend reinvestment on a specific date, those transactions must be included. Omitting any cash flow makes the XIRR inaccurate because it shifts the effective timing of your investment.
• Mixing Up Positive and Negative Signs: Investments (money going out) must be entered as negative values. Redemptions and the current portfolio value (money coming in) must be entered as positive values. Reversing the signs is a common error that produces nonsensical or negative XIRR results.
• Comparing XIRR with CAGR Directly: As explained above, XIRR and CAGR measure different things. Comparing your personal XIRR with a fund's published CAGR as if they are equivalent is misleading. Your XIRR reflects your timing and cash flows; the fund's CAGR reflects the fund's performance assuming a single start date.
• Using XIRR for Very Short Time Periods: XIRR can produce unusually high or volatile numbers for very short investment horizons, such as less than 6 months, because small absolute gains get annualised over a compressed period. Use XIRR primarily for investment horizons of one year or more for stable, meaningful results.
• Not Updating the Current Value Regularly: The positive cash flow entry representing your current portfolio value must reflect today's NAV multiplied by your units. Using an outdated portfolio value will show you a historical XIRR, not your live one.