How to Calculate SIP Returns — CAGR, XIRR, Absolute Returns

You've been investing Rs 10,000 per month in a mutual fund via SIP. Your portfolio now shows a value higher than what you invested. But what's your actual return? The answer depends on which method you use — and using the wrong one can significantly mislead you.

Here's how to calculate SIP returns correctly, with formulas and examples. You can verify calculations using the CalcHub SIP calculator.

Method 1: Absolute Return

The simplest measure — total gain as a percentage of total investment.

Absolute Return = ((Current Value - Total Invested) / Total Invested) × 100

Example:

• Total invested: Rs 3,60,000 (Rs 10,000/month for 36 months)
• Current value: Rs 4,32,000

Absolute Return = ((4,32,000 - 3,60,000) / 3,60,000) × 100 = 20%

When to use: Only for quick ballpark assessment. Absolute return doesn't account for time — a 20% return over 3 years is very different from 20% over 10 years.

Method 2: CAGR (Compound Annual Growth Rate)

CAGR gives you the annualized return, making it useful for comparing across different time periods.

CAGR = ((Final Value / Initial Value)^(1/years)) - 1

But there's a problem with SIP: CAGR works for lumpsum investments (one initial amount). In a SIP, you invest a different amount each month, each for a different duration. Your first SIP installment has been invested for 36 months; your last installment for just 1 month.

Approximate SIP CAGR:

For rough estimates, you can use the total invested as "initial value" and the investment duration:

Approximate CAGR = ((4,32,000 / 3,60,000)^(1/3)) - 1
= (1.2)^(0.333) - 1
= 1.0627 - 1
= 6.27%

Warning: This significantly underestimates the actual return because it assumes the entire Rs 3,60,000 was invested from day one. In reality, the average investment duration is about half the total period.

Method 3: XIRR (Extended Internal Rate of Return)

XIRR is the correct method for SIP returns. It considers the exact date and amount of every cash flow — each monthly SIP and the final redemption.

XIRR cannot be solved with a simple formula — it requires iterative computation. Here's how it works conceptually:

XIRR finds the discount rate that makes the net present value of all cash flows equal to zero:

0 = Σ [Cash flow_i / (1 + XIRR)^(date_i - date_0)/365]

Example with XIRR:

For our Rs 10,000/month SIP over 36 months with a final value of Rs 4,32,000:

• 36 cash outflows of -Rs 10,000 each (on specific dates)
• 1 cash inflow of +Rs 4,32,000 (redemption date)

Using XIRR calculation, the annualized return is approximately 12.1% — much higher than the 6.27% from the approximate CAGR method.

This is why XIRR matters. The approximate CAGR method underestimates SIP returns by roughly half.

Which Method to Use When

Scenario	Best Method	Why
SIP investment	XIRR	Accounts for irregular, periodic investments
Lumpsum investment	CAGR	Single investment, single duration
Quick comparison	Absolute Return	Fast but time-agnostic
Comparing funds over same period	XIRR	Fair comparison accounting for cash flow timing

How to Calculate XIRR Practically

You don't need to solve the iterative equation by hand:

1. Excel/Google Sheets: Use the =XIRR(values, dates) function. List all SIP amounts as negative values, the final redemption as positive, with corresponding dates.

1. CalcHub: The SIP returns calculator computes XIRR automatically from your investment details.

1. Mutual fund apps: Most platforms (Groww, Zerodha, ET Money) show XIRR in your portfolio dashboard.

Practical Tips

1. Compare funds using XIRR, not absolute returns. Two funds showing 25% absolute return could have very different XIRR if the investment periods differ. 2. Distinguish between regular and direct plans. Direct plans have lower expense ratios (0.5-1% less), which compounds significantly over time. A fund showing 12% XIRR in regular plan might show 13% in direct. 3. Factor in taxes. LTCG above Rs 1.25 lakhs on equity mutual funds is taxed at 12.5%. Your post-tax XIRR will be lower than the pre-tax number. For debt funds, gains are taxed at your income tax slab rate.

Is 12% SIP return realistic?

Based on Nifty 50 historical data, 12% annualized returns over 10+ year SIP periods have been achieved consistently. However, shorter periods can show much higher or lower returns depending on market conditions. 12% is a reasonable long-term assumption for equity funds, not a guarantee.

Why does my fund app show different return numbers?

Different platforms may display absolute returns, trailing returns, or XIRR. Check which metric is being used. Also, some platforms calculate returns on the current day's NAV while others use the previous day's closing NAV.

Does SIP timing matter — beginning or end of month?

Research shows minimal difference in long-term returns between SIP dates. Over 10+ years, the date of the month has negligible impact. Choose a date that aligns with your salary credit for convenience.

Related Calculators

• SIP Calculator — project future SIP corpus
• CAGR Calculator — calculate compound annual growth rate
• Mutual Fund Returns Calculator — comprehensive return analysis
• Lumpsum Calculator — compare lumpsum vs SIP projections