A Systematic Investment Plan (SIP) is one of the most effective ways to build wealth — it automates discipline, averages out market volatility, and compounds small amounts into substantial sums over time. But the math behind SIP returns is less intuitive than a lump sum. Here's how to understand and calculate what your SIP is actually earning.
What Is a SIP?
A SIP is a method of investing a fixed amount at regular intervals — weekly, monthly, or quarterly — into a mutual fund, ETF, or similar instrument. Each installment buys units at the current NAV (Net Asset Value). When prices are low, you buy more units; when prices are high, you buy fewer. This is rupee-cost averaging (or dollar-cost averaging).
Key benefit: You don't need to time the market. Consistent investment smooths out the impact of market volatility over time.
The Three Return Metrics for SIP
1. Absolute Returns
The simplest metric: total profit divided by total amount invested.
Absolute Return = (Current Value - Total Invested) ÷ Total Invested × 100
Example:
- Monthly SIP: ₹5,000
- Duration: 5 years (60 months)
- Total invested: ₹3,00,000
- Current portfolio value: ₹4,20,000
Absolute Return = (4,20,000 - 3,00,000) ÷ 3,00,000 × 100 = 40%
The problem: Absolute return ignores time. A 40% return over 5 years is very different from a 40% return over 2 years. It's useful for a quick snapshot but misleading for comparison.
2. CAGR (Compound Annual Growth Rate)
CAGR converts absolute returns into an annualized rate, making comparison possible. For a lump-sum investment, CAGR is calculated as:
CAGR = (Ending Value ÷ Beginning Value)^(1/years) - 1
For SIP, CAGR is an approximation because each installment was invested for a different period. A strict CAGR calculation for SIP understates returns (since early installments compounded longest but all are treated equally).
3. XIRR (Extended Internal Rate of Return)
XIRR is the correct metric for SIP returns. It accounts for the different timing of each investment installment.
XIRR calculates the rate that equates the net present value of all cash flows to zero:
Each monthly SIP installment is a negative cash flow (you're investing out). The final portfolio value is a positive cash flow (you're receiving it). XIRR finds the annualized rate that makes these cash flows balance.
In Excel/Google Sheets:
=XIRR(values_array, dates_array)
Where values_array contains negative amounts for each SIP installment and a positive final portfolio value, and dates_array contains the corresponding dates.
Example:
- ₹5,000/month for 60 months → total 60 entries of -5000
- Final value: ₹4,20,000 → entry of +420000
- XIRR gives you the actual annualized return
XIRR is the standard used by mutual fund advisors and regulators. It's what DevZone's SIP Calculator uses to show your projected returns.
How to Project SIP Returns
The SIP future value formula assumes a constant rate of return:
FV = P × [((1 + r)^n - 1) ÷ r] × (1 + r)
Where:
- FV = Future value
- P = Monthly SIP amount
- r = Monthly return rate (annual rate ÷ 12)
- n = Number of monthly installments
Example:
- SIP: ₹10,000/month
- Expected annual return: 12%
- Duration: 15 years (180 months)
- Monthly return (r) = 12 ÷ 12 ÷ 100 = 0.01
FV = 10,000 × [((1.01)^180 - 1) ÷ 0.01] × (1.01)
= 10,000 × [5.9958 - 1) ÷ 0.01] × 1.01
= 10,000 × 499.58 × 1.01
= ₹50,45,760
You invested ₹10,000 × 180 = ₹18,00,000. The fund grew it to ₹50,45,760 — a gain of ₹32,45,760.
How SIP Returns Compare to Lump Sum
Scenario: ₹1,80,000 invested all at once vs. ₹10,000/month for 18 months, both at 12% annual returns:
- Lump sum at 12% for 1.5 years: ₹1,80,000 × (1.12)^1.5 = ~₹2,12,000
- SIP over 1.5 years: ~₹1,97,000
The lump sum outperforms in a rising market because the entire capital is deployed immediately. SIP outperforms in a volatile or falling market because you buy more units when prices are low.
Over long periods in equity markets with significant volatility, SIP often comes close to lump-sum returns due to cost averaging, with substantially lower risk of investing at a market peak.
Benchmarking Your SIP Returns
For equity mutual funds in India, compare your fund's XIRR to its benchmark index's return over the same period.
Historical context for Indian equity SIPs (15-year periods ending 2024):
- Large-cap funds: 12–15% XIRR
- Mid-cap funds: 15–18% XIRR
- Small-cap funds: 18–22% XIRR (with higher volatility)
Past performance doesn't guarantee future results. Use 10–12% as a conservative planning assumption for equity-oriented SIPs.
Key Strategies to Maximize SIP Returns
Step-up SIPs: Increase your SIP amount by 10–15% annually, aligned with income growth. This dramatically improves outcomes:
| Strategy | 15-year final value (₹10K start, 12% return) |
|---|---|
| Fixed SIP ₹10,000/month | ₹50.5 lakhs |
| Step-up 10%/year | ₹1.11 crore |
| Step-up 15%/year | ₹1.49 crore |
Increase tenure, not just amount. An extra 5 years often adds more value than doubling the monthly amount.
Don't pause during downturns. This is when rupee-cost averaging works hardest. Pausing during a crash and resuming at recovery is the worst possible SIP pattern.
FAQ
What's a good return for an SIP?
For equity mutual funds over 10+ year periods, 10–14% XIRR is considered solid. Returns below inflation (currently ~5–6% in India) mean you're not growing real wealth. Anything consistently above 15% for a large-cap fund is exceptional.
How is XIRR different from CAGR for SIP?
CAGR treats all investments as if they were made on the same date. XIRR accounts for when each installment was actually made, giving a more accurate picture. For SIP, XIRR is always the correct metric. The difference can be 1–3 percentage points.
Can I compare SIP returns across mutual funds?
Yes — compare the 3-year, 5-year, and 10-year XIRR of different funds investing in the same category. Also compare against the category average and the benchmark index. Consistent outperformance over 5+ years is meaningful; outperformance over 1 year may be noise.
What happens if I miss a SIP installment?
Most funds allow you to miss installments without penalties. The missed installment reduces your total invested amount and units purchased for that period, but doesn't cancel the SIP. Regular SIP installments resume as scheduled.