WhatsApp Logo Follow Now
Advertisement

Why a 10% SIP Return Can Really Mean 19% a Year — Absolute Return vs XIRR Explained

Advertisement
Why a 10% SIP Return Can Really Mean 19% a Year — Absolute Return vs XIRR Explained
Why a 10% SIP Return Can Really Mean 19% a Year — Absolute Return vs XIRR Explained

Mutual funds · SIP returns · Absolute return vs XIRR

Why a 10% SIP Return Can Really Mean 19% a Year — Absolute Return vs XIRR Explained

A ₹10,000 monthly SIP that grows to ₹1.32 lakh after a year shows a 10% gain, but its XIRR is about 19%. The gap comes from time, not from a calculation error, and it can work in either direction.

By The Money DeskFact-checked against AMC investor-education material, AMFI monthly data and published SIP studies; XIRR figures recalculated by usUpdated 17 November 2026Scope: equity mutual fund SIPs in India

You started a ₹10,000 monthly SIP a year ago. You have put in ₹1.2 lakh. The app now shows ₹1.32 lakh. A ₹12,000 gain, or 10%. Not bad, not great, roughly what a good fixed deposit might pay. Just okay.

Advertisement

Except that it is not 10% a year. Your first ₹10,000 has been invested for 12 months, but your last ₹10,000 for barely one. On average, your money has been in the market for only about half a year. Earning 10% on money that has worked for six months is a very different achievement from earning 10% in twelve. Measured properly, the same SIP has earned about 19% a year.

The Same ₹1.32 Lakh, Read Two Ways

Kotak Mahindra Mutual Fund used exactly this case in an investor-education note published on 17 June 2026. A lump sum of ₹1 lakh that grows to ₹1.2 lakh in a year shows 20% both ways, because there is one investment date and one period. But a ₹10,000 monthly SIP for 12 months, totalling ₹1.2 lakh and worth ₹1.32 lakh at the end of the year, shows an absolute return of 10% and an XIRR of about 19%.

The fund house’s explanation is short: the XIRR is much higher because each instalment was invested on a different date, and XIRR accounts for that timing. We rebuilt the cash flows ourselves, with ₹10,000 going in on the first of each month and the value read a month after the last instalment. The answer came to 18.9% a year.

  • 10%Absolute return₹12,000 gain divided by ₹1,20,000 invested. No time involved.
  • 20%Lump-sum comparison₹1 lakh to ₹1.2 lakh in one year. Absolute return and XIRR are the same.
  • 18.9%SIP XIRREach ₹10,000 instalment weighted by how long it was invested.

Why the average rupee worked for only half a year

A SIP is not one investment. It is twelve small ones made on twelve dates. The January instalment had a full year to grow. The December one had a month. Absolute return treats all twelve as if they had been invested for the same time, which is why it understates what short SIPs have earned.

How long each ₹10,000 instalment was invested

Months each instalment spent invested in a 12-month SIP valued one month after the last instalment. Our illustration. The average across all 12 instalments is 6.5 months.

Instalment 1
12 months
Instalment 4
9 months
Instalment 7
6 months
Instalment 10
3 months
Instalment 12
1 month

What people get wrong: comparing a SIP’s absolute return with an FD rate. An FD rate is an annual rate on money invested for the full year. A one-year SIP’s absolute return is earned on money invested for half a year on average. Comparing them puts the SIP at a built-in disadvantage of almost half.

What XIRR Actually Calculates

XIRR, the extended internal rate of return, finds the single annual rate that, applied to each instalment for the exact time it was invested, produces today’s value. It is the same idea as the interest rate on a loan with uneven payments, run in reverse. Excel and Google Sheets both have an XIRR function: list each instalment as a negative amount with its date, the current value as a positive amount with today’s date, and the function returns the rate.

Value Research, in an explainer on why SIP dashboards mislead, gives a second illustration. About ₹4,167 a month for two years, totalling about ₹1 lakh and ending at ₹1.2 lakh, gives an XIRR of 14.82%, against 9.54% if you wrongly treat the whole ₹1 lakh as a lump sum invested on day one. The first instalment had 24 months to grow, the last about one.

Where CAGR fits, and where it does not

CAGR, the compound annual growth rate, works for a single investment held for a fixed period. Kotak’s note makes the same split: absolute return suits a single lump sum, CAGR fits one investment over a fixed period, and XIRR suits SIPs and portfolios with many transactions. Applying CAGR to a SIP assumes all the money went in on the first day, which understates the return. Using absolute return over many years does the opposite and makes the number look larger than the annual rate.

Return labelWhat it measuresAccounts for time?Best used forTrap for SIP investors
Absolute returnTotal gain as % of total investedNoLump sums held under a yearUnderstates short SIPs, overstates long ones
CAGRAnnual growth of one investmentYes, one dateLump sums over a fixed periodAssumes all SIP money went in on day one
XIRRAnnual rate across many dated cash flowsYes, every dateSIPs, top-ups, part withdrawalsVery unstable in the first one or two years
Fund’s trailing returnNAV growth over 1, 3 or 5 yearsYes, lump sum basisComparing fundsNot your own return if you invested monthly
Benchmark SIP XIRRAn index’s XIRR for the same SIP datesYes, every dateJudging your fund fairlyRarely shown by default in apps

Same 10% Gain, Very Different Years

Hold the absolute return constant and change only how long the SIP ran, and the annual rate collapses. We modelled a ₹10,000 monthly SIP that ends exactly 10% above the money put in, over periods from one to ten years.

XIRR when a ₹10,000 SIP shows a 10% absolute return

% a year, our calculation. Monthly instalments, value read one month after the last instalment. Bars scaled to the one-year figure.

1-year SIP
18.88%
2-year SIP
9.42%
3-year SIP
6.27%
5-year SIP
3.76%
10-year SIP
1.88%

That is why “my SIP is up 10%” means almost nothing on its own. After one year it is a strong result. After five years it is worse than a savings account. The missing piece of information is always the same: over how long, and at what pace did the money go in.

The mirror image: a huge gain that is merely solid

The distortion is just as large at the other end. Business Standard, citing a SIP study on the BSE Sensex TRI, reported that a ₹10,000 SIP started in January 2008, at the market peak, would have taken in ₹21.2 lakh by August 2025 and been worth ₹75.23 lakh. That is an absolute gain of about 255% by our arithmetic, which sounds spectacular. The XIRR was 12.96%: good, in line with long-run equity returns, but not extraordinary.

What Absolute Gain You Need for a Given Annual Return

Turn the question around. If you want to know whether your SIP is on track, it helps to know what absolute gain a given XIRR produces over different periods. The table uses a ₹10,000 monthly SIP and three annual rates: 7%, close to what a fixed deposit has paid in recent years; 12%, a common long-term equity assumption; and 19%, the rate in our one-year example.

SIP periodTotal investedValue at 7% XIRRValue at 12% XIRRValue at 19% XIRR
1 year₹1.2 lakh₹1.25 lakh (3.8% gain)₹1.28 lakh (6.4% gain)₹1.32 lakh (10.0% gain)
3 years₹3.6 lakh₹4.00 lakh (11.2%)₹4.31 lakh (19.7%)₹4.76 lakh (32.2%)
5 years₹6 lakh₹7.16 lakh (19.3%)₹8.11 lakh (35.2%)₹9.63 lakh (60.6%)
10 years₹12 lakh₹17.2 lakh (43.3%)₹22.4 lakh (86.7%)₹32.6 lakh (171.8%)
15 years₹18 lakh₹31.3 lakh (73.8%)₹47.6 lakh (164.4%)₹87.5 lakh (386.0%)

Our calculations, using monthly compounding equivalent to each annual rate and value read one month after the last instalment. Figures are illustrations, not projections.

Absolute gain needed to earn 12% a year through a SIP

% gain over total invested for a ₹10,000 monthly SIP at a 12% XIRR, by SIP length. Our calculation. Bars scaled to the 15-year figure.

1 year
6.4%
3 years
19.7%
5 years
35.2%
10 years
86.7%
15 years
164.4%

Worked example, our illustration. Meera and Rahul both see “up 35%” on their SIP dashboards. Meera has run a ₹10,000 SIP for five years: ₹6 lakh in, about ₹8.1 lakh now. That is roughly a 12% XIRR, a healthy equity result. Rahul has run the same SIP for ten years: ₹12 lakh in, about ₹16.2 lakh now. His XIRR is under 6%, below what a fixed deposit would have paid.

Same headline number, opposite verdicts. Neither of them could tell which from the absolute return alone.

Why a 19% XIRR After One Year Should Not Excite You Either

There is a catch in the other direction. XIRR on a young SIP is extremely sensitive to recent market moves, because most of the money has only just gone in. A few percentage points of market movement in the last couple of months can swing a one-year XIRR by ten points or more.

Value Research described exactly this in its April 2026 Mutual Fund Insight cover story: an investor whose XIRR stood at about 40% after year one, and still 39% at 18 months, before a correction pulled it sharply lower. A FundsIndia study of Nifty 50 SIPs since 2000, reported in February 2026, found one-year SIP XIRRs as low as about minus 65% in extreme cases, and two- and three-year windows near minus 40% and minus 22%.

Read early XIRR as noise, not a forecast. A 19% XIRR after 12 months says the market was kind to your recent instalments. It does not mean the fund will earn 19% a year. Over long periods, broad Indian equity SIPs have tended to land in the low-to-mid teens.

What long SIPs have actually delivered

A WhiteOak Capital SIP analysis covering August 1996 to July 2026 found that a monthly SIP in the BSE Sensex TRI earned an XIRR of about 13.5%, and that the result barely changed with the SIP date chosen, ranging from 13.50% to 13.56% across dates in the month. Geojit research, reported by Business Standard, found that 74% of five-year Sensex SIP periods returned above 10% a year, and 93.5% of ten-year periods did. Time narrows the range of outcomes.

Reference points for SIP XIRR

% a year. Sources as named in the text: Kotak Mahindra MF illustration, Business Standard, WhiteOak Capital SIP report; 7% FD comparison is our illustrative assumption. Bars scaled to the highest.

1-year SIP, Kotak example
About 19%
Sensex TRI SIP, 1996 to 2026
13.5%
Sensex SIP from Mar 2009
13.05%
Sensex SIP from Jan 2008
12.96%
FD-style comparison
7%

How Big the SIP Habit Has Become

This is not an academic distinction. AMFI data for October 2026 shows SIP contributions of ₹32,160 crore in the month, from 9,99,87,082 contributing accounts. SIP assets stood at ₹17.68 lakh crore, or 21.2% of the mutual fund industry’s assets. Contributions hit a record ₹32,490 crore in September 2026. For millions of investors, the first year of a SIP is when they decide whether to continue, and absolute return is often the number they see first.

  • ₹32,160 croreSIP contributions in October 2026, AMFI
  • 9.99 croreContributing SIP accounts in October 2026
  • ₹17.68 lakh croreSIP assets, 21.2% of industry AUM
  • ₹32,490 croreRecord SIP contributions, September 2026
  • ₹29,529 croreSIP contributions in October 2025
  • 8.9%Year-on-year rise in October 2026 SIP flows
Monthly SIP contributions, 2025 to 2026

₹ crore, AMFI monthly data as reported by Outlook Money, Tata Mutual Fund, Cafemutual, Kotak Neo and FinTech BizNews. Bars scaled to September 2026.

October 2025
29,529
January 2026
31,002
July 2026
31,961
August 2026
32,297
September 2026
32,490
October 2026
32,160

A One-Year SIP, Month by Month

Following the ₹10,000 SIP through its year shows why the number on the dashboard keeps changing, even when the market does not.

  1. First ₹10,000 goes in. It will be invested for 12 months by the time we measure.
  2. ₹60,000 invested. Half the year’s money has been in for under three months.
  3. Last ₹10,000 goes in. Total invested reaches ₹1.2 lakh.
  4. Value is ₹1.32 lakh: 10% absolute, about 19% XIRR.
  5. XIRR settles as new instalments become a smaller share of the total.

How to Check Whether Your SIP Is Actually Doing Well

  1. Find the XIRR or “annualised return” figure in your app or consolidated account statement, not just the gain.
  2. Note the SIP start date. Treat any XIRR under two or three years old as provisional.
  3. Compare your XIRR with the fund benchmark’s XIRR for a SIP on the same dates, not with an FD rate.
  4. Check the fund’s category average over three and five years to see if it is keeping pace.
  5. If you calculate yourself, enter every instalment with its exact date and today’s value in a spreadsheet XIRR function.
  6. Decide on switches only after several years of clear underperformance, and after counting exit load and tax.

Tax note. Each SIP instalment has its own holding period. Units held over 12 months from equity funds are taxed as long-term gains at 12.5% above the annual exemption, and units held for less at 20% as short-term gains. Redeeming a young SIP can trigger short-term tax on the recent instalments, which reduces the real return further.

What We Know

  • Kotak Mahindra MF’s example: ₹1.2 lakh in, ₹1.32 lakh out, 10% absolute, about 19% XIRR.
  • Our recalculation of that SIP gives 18.9% a year.
  • Absolute return ignores time; XIRR uses every instalment date.
  • A ₹10,000 SIP from January 2008 earned a 12.96% XIRR despite a gain of about 255%.
  • SIP contributions were ₹32,160 crore in October 2026.

What Is Still Unclear

  • Which figure each app shows by default; labels vary and some show both.
  • Whether a strong first-year XIRR will hold; early figures swing widely.
  • Your own XIRR depends on exact dates, top-ups and pauses, so illustrations are only a guide.
  • Future equity returns, which past SIP studies cannot promise.

Frequently Asked Questions

What is the difference between absolute return and XIRR in a SIP?

Absolute return is the total gain divided by the total invested, with no time element. XIRR is an annual rate that accounts for the date of every instalment. For SIPs, XIRR is the more accurate measure of what your money earned.

How can a 10% SIP return be 19% a year?

In a one-year SIP, the average rupee is invested for only about six and a half months. Earning 10% on money invested for about half a year works out to roughly 19% annualised, which is what XIRR measures.

Is XIRR or CAGR better for SIP returns?

XIRR. CAGR suits a single lump-sum investment held for a fixed period. Applied to a SIP, it assumes all the money went in on day one and understates the return.

What is a good XIRR for a mutual fund SIP?

Compare it with the benchmark’s SIP XIRR over the same dates rather than a fixed number. As a reference, a Sensex TRI SIP from 1996 to 2026 earned about 13.5% a year, according to a WhiteOak Capital analysis.

Why does my SIP XIRR keep changing so much?

In the first year or two, most of your money has been invested only recently, so small market moves change the annualised figure sharply. XIRR becomes more stable as the SIP ages.

How do I calculate SIP XIRR in Excel?

List each instalment as a negative amount with its date, add today’s value as a positive amount with today’s date, and use the XIRR function on the amounts and dates.

Can absolute return overstate SIP performance?

Yes, over long periods. A 35% gain over ten years of monthly investing is under 6% a year, while the same gain over five years is about 12% a year, by our calculation.

Should I stop a SIP if returns look low after a year?

Not on the absolute return alone. Check the XIRR, compare it with the benchmark over the same period, and remember that one-year SIP results swing widely in both directions.

The Short Version

A SIP that turns ₹1.2 lakh into ₹1.32 lakh in a year shows a 10% gain, but because the average rupee was invested for only about six and a half months, the annual rate is about 19%. Absolute return understates short SIPs and overstates long ones: a 255% gain over 17 years worked out to under 13% a year. Judge your SIP by its XIRR, compare it with the benchmark over the same dates, and treat any figure from the first two years as provisional.

Sources

  • Kotak Mahindra Mutual Fund, “Absolute Return vs XIRR”, 17 June 2026.
  • Value Research, explainer on misleading SIP returns, updated January 2026; Mutual Fund Insight cover story, April 2026.
  • AMFI monthly data for 2025 and 2026, via Equitybulls, FinTech BizNews, Cafemutual, Kotak Neo, Tata Mutual Fund and Outlook Money.
  • WhiteOak Capital SIP Analysis Report, August 2026; Business Standard on Sensex SIP studies and Geojit research; FundsIndia study as reported in February 2026.
  • All XIRR, absolute return and table figures marked as ours were calculated by The Money Desk. Details current as of 17 November 2026.

This article is general information, not investment or tax advice, and is not an official communication from AMFI, SEBI or any fund house. Mutual fund investments are subject to market risks. Past returns do not guarantee future results. Consult a SEBI-registered adviser for your situation.

By DKush

With over 15 years of experience in Banking, investment banking, personal finance, or financial planning, Dkush  has a knack for breaking down complex financial concepts into actionable, easy-to-understand advice. A MBA finance and a lifelong learner, Dkush is committed to helping readers achieve financial independence through smart budgeting, investing, and wealth-building strategies, Follow Dailyfinancial.in for practical tips and a roadmap to financial success!

Leave a Reply

Your email address will not be published. Required fields are marked *