Your mutual fund app shows an XIRR figure. It changes every day. It sometimes looks wildly high, sometimes oddly low.
Nobody tells you where it comes from.
So you either trust it blindly or ignore it completely. Neither is a good habit.
At Belong, we often get asked what XIRR is and how it is calculated. NRIs running SIPs from abroad ask it. So do resident Indians tracking their first global fund. This guide opens up the calculation so you can check the number yourself.
What Is XIRR?
XIRR stands for extended internal rate of return. It is the single annual rate that explains all your investments and withdrawals, each on its exact date.
Think of it as the interest rate your money effectively earned. That is, if every rupee had grown at one steady yearly rate from the day it went in.
DSP Mutual Fund describes XIRR as an annualised return for irregular cash flows, such as SIPs, top-ups and partial withdrawals.
Why XIRR Exists
Simple return only compares what you put in with what you have now. It ignores time.
CAGR handles time, but only for one investment at the start. Real investing is messier. You invest monthly, top up after a bonus, and withdraw for a family need.
XIRR was built for exactly this. Each cash flow gets weighted by how long it stayed invested.
The Equation Behind XIRR
Here is the idea in plain words. Bring every cash flow back to day one. XIRR is the rate at which they all add up to zero.
Written out, it looks like this:
Sum of [ Cash Flow / (1 + r) ^ (Days Since First Cash Flow / 365) ] = 0
Here, r is the XIRR you are solving for. Each cash flow is divided by a growth factor based on its own date.
In finance language, this is setting the net present value to zero. You do not need to memorise that. You only need to know the logic.
Why There Is No Simple Formula
You cannot rearrange this equation to get r directly. It has to be solved by trial and error.
The calculator guesses a rate, checks the result, and adjusts. It repeats until the total lands close to zero. Excel and Google Sheets do this in a fraction of a second.
Nippon India Mutual Fund describes XIRR as a weighted average of the CAGRs of each instalment. That is a helpful way to picture it, even though the solver works through the equation above.
A Worked Example You Can Recreate
Let us build a real-looking cash flow history. All figures are hypothetical.
You invested 85,000 rupees in total. You have received or hold 95,000 rupees. Your simple gain is 10,000 rupees.
The XIRR on this history works out to roughly 12.4 percent a year.
How the Solver Gets There
Here is the trial-and-error process, simplified. The "result" is the total of all discounted cash flows at each guessed rate.
A positive result means the guessed rate is too low. A negative result means it is too high. The solver narrows the gap until the result reaches zero.
Tip: You can check any XIRR yourself this way. If the discounted total is not near zero, a cash flow is missing or wrong.
How to Calculate XIRR in Excel or Google Sheets
Here is the detailed step-by-step process. It works the same way in both tools.
In column A, enter every transaction date.
In column B, enter each amount.
Enter every investment as a negative number. Money leaving your pocket is negative.
Enter withdrawals and cash payouts as positive numbers.
In the last row, enter today's date and current value as a positive number.
In an empty cell, type =XIRR(B2:B10, A2:A10).
Format the result as a percentage.
DSP Mutual Fund uses the same sign rule. Investments are negative, while redemptions and current value are positive.
Excel also accepts an optional third input, called guess. You rarely need it. It helps only when the solver struggles to find an answer.
Common Errors and How to Fix Them
The #NUM! error: Usually means all cash flows have the same sign. Check that the final value is positive.
Dates stored as text: XIRR needs real dates. Re-enter them or convert the column to date format.
Missing current value: DSP Mutual Fund flags this as a frequent mistake. It makes returns look worse than they are.
Mismatched ranges: The values and dates columns must have the same number of rows.
Missed cash payouts: Dividends paid to your bank are inflows. Leaving them out understates your return.
What Counts as a Cash Flow?
This is where most self-calculated XIRRs go wrong. Getting the inputs right matters more than the formula.
SIPs and top-ups: Every instalment is a negative cash flow on its own date.
Redemptions: Positive cash flows, recorded at the amount actually received. If an exit load applied, use the net amount. Our guide on entry load vs exit load explains how these charges work.
Dividends or IDCW payouts: DSP Mutual Fund notes that cash dividends are positive inflows. Reinvested dividends usually are not separate cash flows, since the money never left. Our comparison of growth option vs IDCW option explains the difference.
Switches between funds: For one fund's XIRR, a switch out is an inflow. A switch in is an outflow. For your whole portfolio's XIRR, ignore internal switches. The money stayed with you.
Tax and charges: If you want post-tax XIRR, use the amount you actually kept after tax.
Portfolio XIRR vs Fund XIRR
You can calculate XIRR for one fund or for your entire portfolio. Both are useful, for different reasons.
Fund XIRR tells you how a specific holding has worked for you. Portfolio XIRR tells you how your overall investing has gone. It is closer to how your net worth has actually grown.
For portfolio XIRR, combine every external cash flow across all funds into one list. Add the total current value at the end.
If your portfolio has too many overlapping funds, this exercise often reveals it. Our article on too many mutual funds vs too few explores that problem.
XIRR vs IRR: A Quick Note
IRR is the older cousin. It assumes cash flows happen at equal intervals, such as once a year.
XIRR uses the actual date of each cash flow. Real investments rarely follow perfect intervals. That is why XIRR is the standard for mutual fund investors.
The NRI Scenario: XIRR When Money Crosses Borders
If you're working in Kuwait and sending money home unevenly, XIRR is the fairest way to measure return. Remittances rarely land on the same date each month.
Your Indian statements show XIRR in rupees. But you might eventually spend this money in dirhams, dinars or dollars.
A simple fix is to keep two value columns in your worksheet. One holds rupee amounts. The other converts each cash flow at that date's exchange rate. Run XIRR on both and compare.
The gap between the two numbers is your currency effect. If the rupee weakened during your investing period, your home-currency XIRR will be lower.
Two practical points matter for NRIs:
Tax: Capital gains on Indian mutual funds are taxable in India for NRIs. The Income Tax Department's non-resident help page explains filing obligations. Our guide to mutual fund taxation covers the details.
Repatriation: Your true XIRR is what reaches your foreign account. Our guide to repatriation rules after selling investments in India explains the process.
If you are setting up SIPs from abroad, our SIP guide for NRIs is a good starting point.
The Resident Indian Scenario: XIRR on Global Funds
If all your SIPs today run into Indian funds, your XIRR reflects only one market and one currency.
Adding a global fund changes that. When you invest in a USD fund from India, your rupee XIRR includes currency movement too.
Use the same two-column method in reverse. Track the dollar amount of each instalment and its rupee cost. Run XIRR on both. You will see how much currency added or subtracted.
Our guide on the benefits of USD investments explains why this matters for Indian investors. Our framework for evaluating USD mutual funds helps you compare options.
Resident Indians can invest abroad under the RBI's Liberalised Remittance Scheme. The RBI's LRS FAQs explain what is allowed.
GIFT City funds offer a simpler route to global investing from India. Browse them on our GIFT City mutual funds tool, or read our guide to investing in the USA from India.
What XIRR Cannot Tell You
XIRR is powerful. But DSP Mutual Fund lists clear limits, and we agree with them.
It looks backward. It does not predict future returns.
It hides volatility. A smooth number can sit on top of a painful ride.
It does not compare your return with alternatives you skipped.
Over short periods, it swings sharply with market timing.
For holdings under a year, absolute return is usually more meaningful.
The Comfort and Trap of a Single Number
XIRR feels authoritative because it is precise. Two decimal places suggest certainty.
But XIRR describes your past decisions, not your future ones. A high XIRR after a rally can encourage overconfidence. A low XIRR after a fall can push people to sell at the worst time.
Our piece on what to do in a market crash addresses exactly that moment. The number is a mirror. It is not a steering wheel.
Where Else XIRR Is Useful
XIRR works for any investment with dated cash flows.
Loans: XIRR can reveal a loan's true cost, including processing fees. Treat the loan amount as an inflow and each EMI as an outflow.
This connects to amortization, the schedule by which a loan is repaid. Our NRI home loans guide explains how home loans work. A stronger CIBIL score usually improves the terms you are offered.
Credit cards: Revolving dues compound against you. Our guide to the best credit cards in India helps you choose a card that suits how you pay.
Property: Down payment, renovation costs, rent received and sale value are all dated cash flows. XIRR captures a property asset far better than headline price growth.
Stocks bought in tranches: XIRR handles staggered buying well. Our best stocks list is a research starting point, not a recommendation.
IPOs: Short holding periods inflate annualised returns. Read about GIFT City IPOs or explore IPO investing on our platform with that in mind.
Derivatives: XIRR is a poor fit for margin-based trading, where exposure far exceeds cash put in. Before exploring futures and options, read our guide to GIFT Nifty futures.
Index context: To compare your XIRR with the market, look at how the index moved. Our GIFT Nifty historical data, GIFT Nifty chart guide and weekly GIFT Nifty outlook help. You can also follow the GIFT Nifty live tracker.
Your XIRR Decision Guide
If you want to know your personal return on a SIP, calculate XIRR.
If you want to compare two funds, compare their CAGR over the same period instead.
If you have withdrawn money, include every withdrawal as a positive cash flow.
If your goal is in a foreign currency, calculate XIRR in that currency too.
If your holding period is under a year, avoid relying on XIRR.
If your app's XIRR and your own calculation differ, check for missing cash flows first.
What happens if you ignore this?
A wrong XIRR leads to wrong conclusions. You may drop a good fund over a missed dividend. Or you may keep a weak one over a missing withdrawal.
What NRIs and Resident Indians Should Do Next
If you're an NRI: Build one worksheet with rupee and home-currency columns. Recalculate XIRR once a year, after including tax and repatriation costs. Our guide on how residency status changes affect NRI investments explains what shifts if you move back.
If you're a resident Indian: Track the rupee XIRR of any global SIP separately. Compare it with your domestic funds to see what diversification is actually adding.
Tracking XIRR Without the Spreadsheet Pain
Most investors give up on XIRR because maintaining records feels tedious. A good tracking habit fixes that.
Our review of portfolio tracking apps in the UAE compares options. Our guide on tracking your finances as an NRI shows how to build a routine.
Also check whether you hold direct or regular plans. Our comparison of direct vs regular mutual funds shows how costs quietly reduce XIRR over time.
Comparing Options Before You Invest
XIRR measures your past. Fund comparisons shape your future.
Browse the GIFT City mutual funds tool and the GIFT City AIF tool. Fund pages include the DSP Global Equity Fund and the Edelweiss Greater China Equity Fund.
India-focused options include the Tata India Dynamic Equity Fund and the Sundaram India Mid Cap Fund. You can also explore our USD mutual fund options.
For a dollar-denominated anchor, USD fixed deposits through GIFT City earn returns directly in dollars. Compare rates on our NRI FD rates tool. Our comparison of GIFT City FD vs FCNR vs NRO and NRE FDs explains the trade-offs.
If tax is the part that worries you, our tax filing service can help. Our regulatory credentials are on our licences page.
Want help reading your own XIRR? Download the Belong app and join our WhatsApp community to discuss it with other investors.
Frequently Asked Questions
What is a good XIRR for mutual funds?
There is no fixed number. A good XIRR beats inflation, beats a relevant benchmark over the same period, and suits the risk you took.
Why is my XIRR negative?
Your current value plus withdrawals is less than what you invested. Early in a SIP, a small market dip can also show a sharply negative XIRR.
Is XIRR the same as CAGR?
Not usually. They match only when there is one investment and one final value. With multiple cash flows, XIRR is the more accurate measure.
Why does XIRR show #NUM! in Excel?
This usually means the cash flows lack both negative and positive values. Check that investments are negative and the current value is positive.
Should I include dividends in my XIRR calculation?
Yes, if they were paid out to your bank account. Reinvested dividends usually stay inside the fund value and need no separate entry.
Sources
Disclaimer
This article is for educational purposes only and is not investment, tax or legal advice. All figures in examples are hypothetical and used for illustration. Investments are subject to market and currency risk. Please consult a qualified advisor before making investment decisions.