XIRR Calculator
Your real yearly return on a SIP or mutual fund. Use a regular monthly SIP below, or enter each investment and withdrawal with its date.
Exact XIRR from your transactions
Skipped instalments, top-ups or withdrawals? Enter each one with its date, then today’s value. This works like Excel’s XIRR. The example below is yours to change.
What is XIRR?
XIRR (extended internal rate of return) is the yearly return on money invested at different times. A SIP is the usual case: each instalment has been invested for a different length of time, so the total gain divided by the total invested (absolute return) or CAGR would mislead. XIRR finds the one yearly rate that, applied to every investment from its own date, adds up to what you have today.
Investments are negative, withdrawals and today’s value are positive, daysi is the number of days from the first transaction. There is no closed form, so the calculator solves it numerically, the same way Excel does.
Worked example
A SIP of ₹10,000 a month for 10 years is ₹12 lakh invested. If it is worth ₹25 lakh today, the XIRR is 14.05% a year. The absolute return is 108%, which sounds bigger but ignores that most instalments were invested for only a few years.
Where to find your numbers
Your Consolidated Account Statement (CAS) from CAMS or KFintech lists every purchase and redemption with its date, and your fund app shows today’s value. Enter those in the exact-dates section above. Most apps also show an XIRR; this lets you check it, or work it out across funds and platforms together.
Frequently asked questions
What is XIRR in mutual funds?
XIRR is the yearly return on investments made at different times, such as SIP instalments, top-ups and withdrawals. It weighs each amount by how long it was invested, so a rupee invested last month counts for less than one invested five years ago. Fund statements and apps show XIRR for this reason.
How do I calculate XIRR for my SIP?
For a regular SIP, enter the monthly amount, how many years you have invested and today's value in the calculator at the top. If you skipped instalments, changed the amount, or withdrew money, use the exact-dates section instead: enter each transaction with its date and today's value.
Why XIRR instead of CAGR?
CAGR is for one investment made once, like a lump sum. With a SIP, most of your money has been invested for much less than the full period, so CAGR on the total would understate your real return. XIRR accounts for the date of each instalment.
Is this the same as Excel's XIRR?
Yes. The exact-dates section uses the same definition as Excel's XIRR function: actual days between dates, divided by 365. For the example in Microsoft's documentation it gives 37.34%, the same as Excel.
Can XIRR be negative?
Yes. If today's value plus what you withdrew is less than what you invested, XIRR is negative. Early in a SIP a short market fall can make it look very negative; it means more after a few years.
What is a good XIRR?
For equity mutual funds held 5 years or more, 12% or above is good and 15% or above is excellent. Compare it with the index fund return for the same period: if a Nifty 50 index fund did better, your fund lagged its benchmark.