Systematic Investment Plan (SIP) has become the most popular mode of investing in mutual funds in India. It allows investors to invest a fixed amount regularly (monthly, quarterly, or annually) in a mutual fund scheme, thereby averaging the purchase cost and reducing the impact of market volatility. However, understanding how SIP returns are calculated can be confusing for many investors.
This comprehensive guide demystifies mutual fund SIP returns calculations. We will explore the difference between absolute returns, CAGR, and XIRR, show you how to calculate SIP returns manually, explain the importance of compounding, and demonstrate how to use our SIP calculator to plan your investments effectively.
A Systematic Investment Plan (SIP) is an investment method offered by mutual funds where an investor invests a fixed amount of money at regular intervals (usually monthly) in a specific mutual fund scheme. SIP works on the principle of rupee cost averaging and compounding, making it one of the most disciplined and effective ways to build wealth over the long term.
The key advantages of SIP investing include:
When it comes to calculating returns on SIP investments, there are three primary metrics that investors need to understand:
Absolute returns measure the total profit or loss on your investment as a percentage of the total amount invested. It does not consider the time factor. The formula is:
Absolute Return (%) = [(Current Value — Total Invested Amount) / Total Invested Amount] × 100
For example, if you invested ₹1,00,000 in a mutual fund through SIP and the current value is ₹1,50,000, your absolute return is 50%. However, this metric is misleading for SIP investments because the money was invested over a period of time, not all at once.
CAGR is the most commonly used metric to calculate returns on lump sum investments. It represents the average annual growth rate of an investment over a specific period, assuming that the profits are reinvested at the end of each year. The formula is:
CAGR (%) = [(Ending Value / Beginning Value) ^ (1 / Number of Years)] — 1 × 100
CAGR is not ideal for SIP returns because SIP investments are made at regular intervals, not as a single lump sum.
XIRR is the most accurate metric for calculating SIP returns. It takes into account the timing and amount of each SIP installment. XIRR calculates the internal rate of return for a series of cash flows that occur at irregular intervals. Since SIP involves multiple investments at different dates, XIRR is the appropriate measure.
XIRR can be calculated using Excel or Google Sheets using the formula: =XIRR(values, dates, guess)
Where:
Let us understand SIP returns calculation with a practical example:
Suppose you invest ₹10,000 per month in a mutual fund SIP for 12 months. Here is how the returns will be calculated:
Step 1: Track SIP Investments and Unit Allotment
| Month | NAV (₹) | Amount (₹) | Units Allotted |
|---|---|---|---|
| 1 | 50 | 10,000 | 200.00 |
| 2 | 52 | 10,000 | 192.31 |
| 3 | 48 | 10,000 | 208.33 |
| 4 | 55 | 10,000 | 181.82 |
| 5 | 53 | 10,000 | 188.68 |
| 6 | 58 | 10,000 | 172.41 |
| 7 | 60 | 10,000 | 166.67 |
| 8 | 56 | 10,000 | 178.57 |
| 9 | 62 | 10,000 | 161.29 |
| 10 | 65 | 10,000 | 153.85 |
| 11 | 63 | 10,000 | 158.73 |
| 12 | 70 | 10,000 | 142.86 |
Step 2: Calculate Total Investment and Total Units
Total Amount Invested: ₹1,20,000 (₹10,000 × 12 months)
Total Units Allotted: Sum of units = 200.00 + 192.31 + 208.33 + 181.82 + 188.68 + 172.41 + 166.67 + 178.57 + 161.29 + 153.85 + 158.73 + 142.86 = 2,105.52 units
Step 3: Calculate Current Value
Current Value = Total Units × Current NAV
Current Value = 2,105.52 × 70 = ₹1,47,386.40
Step 4: Calculate Return Percentages
Absolute Return = [(1,47,386.40 — 1,20,000) / 1,20,000] × 100 = 22.82%
XIRR Calculation: Using the XIRR formula in Excel with the dates and amounts, the XIRR for this investment would be approximately 39.5% (annualized).
The true magic of SIP investing lies in the power of compounding. When your mutual fund investments generate returns, those returns are reinvested, generating their own returns. Over long periods, this creates exponential growth.
Let us look at how different monthly SIP amounts grow over different time horizons, assuming a 12% annual return:
| Monthly SIP | 5 Years | 10 Years | 15 Years | 20 Years | 25 Years | 30 Years |
|---|---|---|---|---|---|---|
| ₹1,000 | ₹82,422 | ₹2,30,038 | ₹5,00,000 | ₹9,91,480 | ₹18,90,000 | ₹35,00,000 |
| ₹5,000 | ₹4,12,110 | ₹11,50,190 | ₹25,00,000 | ₹49,57,400 | ₹94,50,000 | ₹1,75,00,000 |
| ₹10,000 | ₹8,24,220 | ₹23,00,380 | ₹50,00,000 | ₹99,14,800 | ₹1,89,00,000 | ₹3,50,00,000 |
| ₹25,000 | ₹20,60,550 | ₹57,50,950 | ₹1,25,00,000 | ₹2,47,87,000 | ₹4,72,50,000 | ₹8,75,00,000 |
| ₹50,000 | ₹41,21,100 | ₹1,15,01,900 | ₹2,50,00,000 | ₹4,95,74,000 | ₹9,45,00,000 | ₹17,50,00,000 |
| ₹1,00,000 | ₹82,42,200 | ₹2,30,03,800 | ₹5,00,00,000 | ₹9,91,48,000 | ₹18,90,00,000 | ₹35,00,00,000 |
Notice how the corpus grows exponentially — not linearly. In the first 5 years, a ₹10,000 monthly SIP grows to approximately ₹8.2 lakhs. But in 30 years, the same SIP grows to ₹3.5 crores. This is the power of compounding at work.
Many investors wonder whether SIP is better than lump sum investing. The answer depends on market conditions and the investor's goals:
Our SIP returns calculator at toolsofindia.com makes it easy to estimate your investment growth. Here is how to use it:
230+ free Indian calculators and tools for GST, TDS, SIP, EMI, and more.
Browse All Tools →