Absolute return vs XIRR
₹10,000 a month for 3 years is ₹3.6 lakh invested. If it is worth ₹4.5 lakh, the absolute return is 25%. The average rupee was invested for only about 18 months, so the XIRR is 15% a year.
Example: Parag Parikh Flexi Cap. Search to pick yours.
5 thousand
Value today
…
Loading NAV history from AMFI.
Each SIP instalment buys units at that day's net asset value (NAV), the fund's assets per unit after expenses. Your value is the units you hold times the latest NAV. The tool uses the first NAV published on or after each SIP date, from AMFI data. Since July 2020 a stamp duty of 0.005% applies to purchases, and many equity funds charge an exit load of about 1% if you sell within a year. The tool leaves out both.
Because each instalment is invested for a different length of time, the right return measure is XIRR. It is the single yearly rate that makes all the cash flows add up to today's value. Absolute return just divides the gain by the total invested and ignores time. CAGR is only correct for one lump sum. A 5-year SIP with a 40% absolute gain might have an XIRR of about 13%.
Tax depends on the fund type. For equity funds, gains on units held over 12 months are long-term and taxed at 12.5% on the amount above ₹1.25 lakh a year. Shorter-term gains are taxed at 20%. Each instalment has its own holding period. To plan forward rather than look back, use the SIP calculator or the step-up SIP calculator. For one-off investments there is the lumpsum calculator, and for taking money out the SWP calculator.
value =Σ (monthly ÷ NAV on SIP date) × latest NAVRead the full methodologyFound an error? Contact us
Each example is worked out by the same code as the calculator above.
₹10,000 a month for 3 years is ₹3.6 lakh invested. If it is worth ₹4.5 lakh, the absolute return is 25%. The average rupee was invested for only about 18 months, so the XIRR is 15% a year.
The frame shows the tool only.
<iframe src="/embed/mutual-fund-returns" title="Mutual fund returns" width="100%" height="720" style="border:0;max-width:42rem" loading="lazy"></iframe>AMFI's daily NAV data, served by the free MFAPI.in service and cached on our server.
In a SIP, each instalment is invested for a different length of time. XIRR weights them correctly; CAGR would understate the return.
Pick the exact plan you hold. Direct plans have lower expenses, so their NAV grows a little faster.
The yearly rate that accounts for the date of every instalment. It is the standard way to report SIP returns.
Units held over 12 months: 12.5% on long-term gains above ₹1.25 lakh a year. Held 12 months or less: 20%.
Apps may use different NAV dates, include stamp duty, or show absolute return rather than XIRR.