How to work out the real return on your SIPs
Run XIRR on each instalment's date and amount, with today's value as the last entry. A detailed CAS prints every one of those dates, so you have everything you need.
Why value ÷ invested misleads
Today's value divided by the total invested gives a multiple, say 1.17×. It says nothing about how long the money was in. In a two-year SIP the first instalment has been invested for two years and the last for one month. Spread that multiple over two years and you treat them all as two-year money.
XIRR gives every instalment its own date. XIRR vs CAGR shows where the simpler measures go wrong.
An example
This is an invented example with round numbers, to show the idea. It is not a real fund and not a forecast.
A SIP of ₹5,000 is invested on the 5th of every month from 05-Jan-2022 to 05-Dec-2023: 24 instalments, ₹1,20,000 in all. On 05-Jan-2024 the holding is worth ₹1,40,000.
| Way of working it out | Result |
|---|---|
| Value ÷ invested | 1.17× (gain of ₹20,000, 16.7%) |
| That multiple spread over 2 years | 8.0% a year |
| XIRR on the 24 dated instalments | 15.5% a year |
Why the gap: counted to 05-Jan-2024, the average instalment was invested for 381 days, a little over a year, not two. A 16.7% gain on money that sat for about a year lands near the 15.5% XIRR. Spread over two years, it shrinks to 8.0%.
Steps with your own statement
- Request a detailed CAS from 01-Jan-1990, with zero-balance folios included. A summary CAS won't do: it has no instalments. How to get it.
- Choose Open your CAS in Sachfolio and pick the PDF. It is read on your device.
- Open a scheme. Its XIRR uses every purchase date and amount, with the current value as the closing entry.
- Look at the list of flows used. Each points to the page of the PDF it came from.
- For the whole portfolio, read the overall XIRR. It runs all schemes' flows through one calculation; it is not an average of the scheme figures.
In a spreadsheet: one row per instalment with its date and the amount as a negative number, a last row with today's date and value as a positive number, then =XIRR(amounts, dates). Getting your CAS into a spreadsheet.
What can change the number
- Switches. Moving money between your own schemes is not new money. Sachfolio pairs the switch-out with the switch-in so it isn't counted as new investment.
- Missed or stopped instalments. XIRR uses what was actually allotted, not the SIP you registered.
- Short history. Under a year, the rate is annualised and can swing wildly: a 3% gain in two months reads as about 19% a year. Sachfolio adds a note.
- Incomplete statement. If the statement starts after your first purchase, Sachfolio shows "not available" rather than a wrong figure.
The result is a measure of past returns on your own dated flows. It is not a forecast, and it does not include tax.
Questions
How do I calculate the return on my SIP?
XIRR on the dated instalments, with the current value as the last entry. A detailed CAS has every date and amount.
Is SIP return the same as the fund's return?
No. The fund's published return follows one lump sum over a fixed period. Yours follows your own instalment dates, so the two rarely match.
Can my SIP XIRR be negative?
Yes, when the holding is worth less than what you put in, allowing for when you put it in.
Why does my XIRR differ between schemes and overall?
Each scheme has its own dates and amounts. The overall figure puts every flow through one calculation, so the bigger and older holdings weigh more.
See the XIRR of each of your SIPs
Sachfolio lists the instalments used, on your device.