ANALYSIS
XIRR calculator for mutual funds
Real annualised return on SIPs and irregular investments · Accounts for the exact date of every cash flow
How it works
Add every investment (money out) with its date and amount, then add the current or redemption value (money back) with today's date. XIRR finds the single annualised return rate that makes all of these cash flows balance to zero - the same math Excel's XIRR function uses, solved here by bisection search. This is the right way to measure return on a SIP, since a SIP has no single start date or lumpsum amount for CAGR to work with.
Solved by bisection search to 0.0001% precision · Not financial advice
Frequently asked questions
What is XIRR, and why not just use CAGR for a mutual fund SIP?
CAGR assumes a single lumpsum invested on one date. A SIP puts money in on many different dates in different amounts, so there is no single holding period to apply CAGR to. XIRR solves for the one annualised rate that makes all your cash flows - every SIP installment (money out of your pocket) and the final redemption value (money back) - balance to zero, accounting for exactly when each rupee went in.
Why does my XIRR differ from the fund's published CAGR?
A fund's published CAGR describes the fund itself - how its NAV moved over a fixed period, as if you had invested a lumpsum on day one. Your personal XIRR depends on your own transaction dates and amounts, so it will differ from the fund's CAGR unless you also invested a single lumpsum on that exact start date.
Does this calculator need my exact bank statement?
No - it only needs the date and amount of each SIP installment (or any other investment) and the date and current/redemption value of your holding. You can get installment dates and amounts from your fund's transaction statement, and the current value from its latest NAV × units held.