XIRR Calculator 2026 – SIP Portfolio Ka Accurate Return Calculate Karo
Tumne 3 saal se SIP kar rakhi hai aur Groww ya Zerodha app dikhata hai "XIRR: 14.3%" – lekin tum soch rahe ho yeh number aaya kahan se? Ya tumhara portfolio statement dekh ke confused ho ki CAGR alag kyu dikhta hai? XIRR (Extended Internal Rate of Return) woh metric hai jo tumhare SIP portfolio ka sabse accurate return calculate karta hai – exact transaction dates aur amounts consider karke. Hamare Finance Adhikar XIRR Calculator mein apni transactions daalo aur apna true return jaano.
XIRR Kya Hota Hai?
XIRR (Extended Internal Rate of Return) ek financial metric hai jo irregular cash flows – alag alag dates pe alag alag amounts – ke liye accurate return calculate karta hai.
XIRR kyun unique hai:
- ✅ Har transaction ki exact date consider karta hai
- ✅ January mein invest kiya paisa December mein invest kiye se zyada time work karta hai – XIRR yeh samajhta hai
- ✅ Multiple investments + withdrawals sab handle karta hai
- ✅ Yahi number Groww, Zerodha, ET Money dikhate hain tumhara portfolio return
- ✅ SEBI ke guidelines mein SIP return reporting ke liye XIRR recommended hai
CAGR vs XIRR – Kab Kaunsa Use Karein?
| Situation | Use CAGR | Use XIRR |
|---|---|---|
| Investment Type | Single lumpsum investment | Multiple investments (SIP) |
| Cash Flows | One in, one out | Multiple in/out at different dates |
| Accuracy for SIP | ❌ Inaccurate – ignores dates | ✅ Accurate – dates matter |
| Complexity | Simple formula | Iterative calculation needed |
| Best For | Lumpsum, FD, PPF | SIP, irregular investments, portfolio |
| Used By | Mutual fund fact sheets (point-to-point) | Portfolio apps, personalized returns |
XIRR Formula – Math Ka Logic
XIRR woh rate (r) find karta hai jisme Net Present Value (NPV) of all cash flows = 0:
0 = Σ [Cash Flow_i / (1 + XIRR)^(d_i / 365)]
- Cash Flow_i = Amount (negative for investment, positive for redemption/current value)
- d_i = Days from first transaction to transaction i
- XIRR = The rate we are solving for (iteratively)
Yeh calculation manually karna practically impossible hai multiple transactions ke liye – isliye hamare calculator mein sirf dates aur amounts daalo!
XIRR Calculator Kaise Use Karein?
Steps:
- Step 1: Har SIP/investment transaction ki date aur amount daalo (negative sign – outflow)
- Step 2: Current portfolio value ya redemption amount daalo (positive – inflow)
- Step 3: Current date ya redemption date daalo
- Step 4: Calculator XIRR instantly calculate karega
Sign Convention yaad rakho:
- Investments (outflows) = Negative (–) amounts
- Redemptions / Current Value = Positive (+) amounts
Practical Example – 12 Month SIP Ka XIRR
Monthly Rs.5,000 SIP, January 2024 se December 2024 tak, current value January 2025 mein Rs.68,000:
| Date | Transaction | Amount |
|---|---|---|
| 01-Jan-2024 | SIP Investment | –Rs.5,000 |
| 01-Feb-2024 | SIP Investment | –Rs.5,000 |
| 01-Mar-2024 | SIP Investment | –Rs.5,000 |
| 01-Apr-2024 | SIP Investment | –Rs.5,000 |
| 01-May-2024 | SIP Investment | –Rs.5,000 |
| 01-Jun-2024 | SIP Investment | –Rs.5,000 |
| 01-Jul-2024 | SIP Investment | –Rs.5,000 |
| 01-Aug-2024 | SIP Investment | –Rs.5,000 |
| 01-Sep-2024 | SIP Investment | –Rs.5,000 |
| 01-Oct-2024 | SIP Investment | –Rs.5,000 |
| 01-Nov-2024 | SIP Investment | –Rs.5,000 |
| 01-Dec-2024 | SIP Investment | –Rs.5,000 |
| 01-Jan-2025 | Current Portfolio Value | +Rs.68,000 |
Total Invested: Rs.60,000 | Current Value: Rs.68,000 | Profit: Rs.8,000
Absolute Return: 13.3% | XIRR: ~25.6%
Absolute return 13.3% dikhta hai lekin XIRR 25.6% hai! Kyunki January wali investment ne poora saal work kiya jabki December wali sirf 1 mahine – XIRR yeh fark accurately capture karta hai.
SIP Duration Ka XIRR Pe Impact
Monthly SIP: Rs.10,000 | Expected Fund Return: 12% CAGR
| SIP Duration | Total Invested | Portfolio Value | Absolute Return | XIRR (Approx) |
|---|---|---|---|---|
| 1 Saal | Rs.1,20,000 | Rs.1,28,000 | 6.7% | ~13% |
| 3 Saal | Rs.3,60,000 | Rs.4,35,000 | 20.8% | ~13.5% |
| 5 Saal | Rs.6,00,000 | Rs.8,17,000 | 36.2% | ~13.2% |
| 10 Saal | Rs.12,00,000 | Rs.23,00,000 | 91.7% | ~13.1% |
| 15 Saal | Rs.18,00,000 | Rs.50,00,000 | 177.8% | ~13.0% |
| 20 Saal | Rs.24,00,000 | Rs.99,91,000 | 316.3% | ~12.9% |
Interesting observation: Absolute return time ke saath dramatic growth dikhata hai (6.7% → 316.3%) lekin XIRR roughly stable rehta hai (~13%) – kyunki fund consistently 12% CAGR de raha hai. XIRR hi true performance indicator hai.
XIRR Excel Mein Kaise Calculate Karein?
Excel/Google Sheets mein XIRR function available hai:
- Column A: Dates (DD-MM-YYYY format)
- Column B: Cash flows (investments negative, redemption positive)
- Formula:
=XIRR(B1:B13, A1:A13) - Result percentage mein milega
Common Error: Agar result #NUM! aaye toh check karo – koi positive cash flow (redemption/current value) hai ya nahi. Sirf negative values se XIRR calculate nahi hoti.
XIRR Ko Affect Karne Wale Factors
1. Market Timing Ka Effect
Same fund, same SIP amount, same duration – alag start dates pe XIRR alag ho sakti hai. Bull market mein shuru kiya toh XIRR zyada, bear market mein shuru kiya toh XIRR kam (short-term mein). Long-term mein yeh difference smooth ho jaata hai.
2. Lumpsum vs SIP Ka Paradox
Ek interesting phenomenon: Rising market mein lumpsum ka XIRR SIP se better hoga. Falling market mein SIP ka XIRR better hoga. Yeh isliye hota hai kyunki SIP mein average cost hoti hai – ups aur downs dono mein units milti hain.
3. Partial Redemptions
Beech mein kuch paisa nikala? XIRR mein woh positive cash flow ke roop mein add karo. XIRR automatically adjust kar leta hai – yahi iska power hai. CAGR mein yeh possible nahi hai.
Apna Portfolio XIRR Kaise Improve Karein?
- Better performing funds choose karo – XIRR direct fund performance reflect karta hai
- Regular investing continue karo – SIP band karna XIRR damage karta hai
- Market dip mein extra invest karo – lumpsum add karna average cost kam karta hai, XIRR badhta hai
- Direct plans use karo – 0.5-1% expense ratio ki saving directly XIRR mein add hoti hai
- Long-term hold karo – compounding time ke saath XIRR improve karta hai
🔗 Related Calculators
- 📊 CAGR Calculator – Lumpsum return calculate karo
- 🎯 Absolute Return Calculator – Simple profit/loss
- 📈 SIP Calculator – Future corpus estimate karo
- 🏦 FD Calculator – Guaranteed return compare karo
- 📉 MF Returns Calculator – Fund performance analyze karo
❓ Aksar Pooche Jaane Wale Sawaal (FAQ)
Q1. XIRR aur CAGR mein practically kya fark hai?
CAGR sirf do points consider karta hai – start amount aur end amount – aur assume karta hai ek hi investment tha. SIP mein har mahine naya investment hota hai, isliye CAGR inaccurate hota hai. XIRR har transaction ki exact date aur amount consider karta hai – isliye SIP portfolio ke liye XIRR zyada accurate hai. Simple example: Rs.10,000/month SIP 12 mahine, same fund ka CAGR 15% ho sakta hai lekin tumhara personal XIRR 13% ya 17% ho sakta hai depending on exact dates aur market performance.
Q2. Achha XIRR kitna hota hai?
XIRR ko benchmark se compare karo, absolute number se nahi. Equity large cap fund ke liye 10-13% XIRR (long-term) achha hai. Mid cap ke liye 13-16%+. Agar tumhara XIRR fund ke declared CAGR ke aas paas hai, toh tumhara investment on track hai. Agar significantly kam hai, toh shayad tumhare SIP timing ya fund choice mein issue hai. Short-term (1-2 saal) mein XIRR bahut variable hoti hai – long-term picture (5+ saal) pe focus karo.
Q3. XIRR negative kyun aati hai?
XIRR negative hoti hai jab tumhara current portfolio value tumhare total investments se kam ho – net loss ki situation. Bear market mein ya recent market correction ke baad short-term mein yeh possible hai. Panic mat karo – SIP continue karo. Long-term (5-7+ saal) equity investments mein negative XIRR historically very rare hai. Negative XIRR dekh ke SIP band karna sabse badi galti hai – wahi time hota hai jab zyada units mil rahi hain saste mein.
Q4. Groww ya Zerodha mein jo XIRR dikhta hai woh sahi hota hai?
Haan, yeh platforms XIRR accurately calculate karte hain tumhare actual transaction history ke basis pe. Lekin dhyan do – yeh tumhara personal XIRR hai, fund ka overall CAGR nahi. Tumhara XIRR alag ho sakta hai kyunki tumhare specific transaction dates aur amounts alag hain. Agar tum SIP step-up karte ho ya beech mein lumpsum daala ho toh woh sab factor hota hai. Portfolio apps ka XIRR most reliable source hai tumhare personal investment performance ke liye.
Q5. Kya XIRR se different funds compare kar sakte hain?
Technically nahi – tumhara personal XIRR tumhari specific investment dates pe depend karta hai. Do alag log same fund mein invest karein alag dates pe – unka XIRR alag hoga. Fund comparison ke liye fund ka declared CAGR ya rolling returns use karo – jo fund house report karte hain standardized basis pe. XIRR sirf tumhara personal return measure karta hai – yeh batata hai ki tumhare specific investment decisions ne kitna return diya, not the fund itself ki quality.
Conclusion – True Return Jaano, Smart Decision Lo
XIRR woh truth teller hai jo tumhe batata hai ki tumhara paisa sach mein kitni efficiency se kaam kar raha hai – na zyada, na kam. Portfolio apps ka XIRR number sirf dekh ke satisfied mat ho – samjho ki yeh kaise bana aur kaise improve ho sakta hai.
Hamare XIRR Calculator mein apni SIP transactions daalo – exact dates ke saath – aur apna true return jaano. Informed investor bano, XIRR samjho, better decisions lo! 💪