XIRR Kya Hota Hai? — Irregular SIP aur Investment Returns Kaise Measure Karein
Mumbai mein Priya ne 5 saal SIP ki — har mahine ₹5,000. Total ₹3 lakh invest kiye aur ab woh ₹4.5 lakh ho gaye. Mutual fund ke factsheet mein 15% return dikha raha hai, lekin Priya ka actual return kya hai? Yahi confusion har SIP investor ko hoti hai, aur iska sahi jawaab ek metric mein hai — XIRR kya hota hai SIP mein. CAGR yahan galat number dega, sirf XIRR aapka asli return batata hai.
Is guide mein hum XIRR ka concept, XIRR vs CAGR ka fark, Excel calculation aur real examples samjhenge. Apna SIP ka actual return nikaalne ke liye CalcDesk ka XIRR Calculator use karein, aur lump-sum ke liye CAGR Calculator.
XIRR Kya Hota Hai?
XIRR (Extended Internal Rate of Return) ek metric hai jo multiple ya irregular cash flows (jinke alag-alag dates hon) par actual annualized return nikaalta hai. Yeh khaaskar SIP jaise investments ke liye banaya gaya hai jahan aap har mahine alag date par paisa lagate hain. Yeh CAGR ka advanced version hai jo real-world irregular investing ko handle kar sakta hai.
Sabse aam misconception — “SIP ka return CAGR se nikaalte hain”. Aisa nahi. CAGR sirf single lump-sum investment ke liye hai — ek baar paisa, ek final value. SIP mein aapka paisa 60 alag installments (5 saal × 12 mahine) mein alag dates par jaata hai, aur har installment ka time period alag hota hai. CAGR yeh handle nahi kar sakta, isliye SIP ke liye sirf XIRR sahi hai.
XIRR Kaise Kaam Karta Hai
XIRR Concept aur Excel Formula
values = invested (negative) + redeemed (positive)
dates = har cash flow ki actual date
Har installment ka apna time period count hota hai
Result = single annualized return (%)
Har part samjhein: “values” — jo paisa aapne invest kiya woh negative (bahar gaya), aur jo maturity par wapas mila woh positive (andar aaya). “dates” — har cash flow ki actual date. Step by step: SIP ke har mahine ki ₹5,000 entry ko us date ke saath negative value ke roop mein daalein, aur last mein maturity value positive value ke saath. XIRR har installment ke actual investment period ko count karta hai — January ka paisa 12 mahine, December ka sirf 1 mahina invested. Yeh complex iterative math hai, isliye Excel ya CalcDesk ka calculator use karna sabse aasaan tarika hai. Result ek single annualized return deta hai jo aapki asli SIP performance dikhaata hai.
Real Examples — 3 Scenarios
Example 1 — Priya, Equity SIP (₹5,000/month, 5 saal)
60 installments, total invested ₹3 lakh, maturity ₹4.5 lakh.
XIRR ≈ 14.3% per year. Yeh Priya ka asli return hai. Agar factsheet mein 15% CAGR dikh raha tha, to woh lump-sum ke liye tha — SIP ka actual XIRR usse thoda alag hai.
Example 2 — Ravi, Lump-sum vs SIP (same fund)
Ravi ne ₹3 lakh ek saath (lump-sum) daale, Priya ne ₹5,000/month SIP.
Ravi ka return CAGR se, Priya ka XIRR se. CAGR SIP par apply karne se return overstate hota hai kyunki woh maan leta hai saara paisa day 1 se laga tha — jo SIP mein galat hai.
Example 3 — Sunita, Irregular Investments
Sunita ne alag-alag samay par alag amounts daale — ₹50,000 January, ₹30,000 June, ₹1 lakh December.
In irregular cash flows ka return sirf XIRR se nikal sakta hai, kyunki har entry ki date aur amount alag hai. CAGR yahan kaam hi nahi karta.
Tables — XIRR vs CAGR aur Excel Steps
Table 1: XIRR vs CAGR — 3 scenarios showing why they differ for SIP.
| Scenario | CAGR Deta Hai | XIRR Deta Hai | Sahi Metric |
|---|---|---|---|
| Lump-sum (1 entry) | Accurate | Same as CAGR | CAGR ya XIRR |
| Monthly SIP | Overstated | Accurate | XIRR |
| Irregular investing | Kaam nahi karta | Accurate | XIRR |
Table 2: Excel XIRR — step by step with sample data.
| Date | Cash Flow | Sign | Reason |
|---|---|---|---|
| 01-Jan-2021 | −₹5,000 | Negative | SIP invested |
| 01-Feb-2021 | −₹5,000 | Negative | SIP invested |
| …(58 more)… | −₹5,000 each | Negative | Monthly SIP |
| 31-Dec-2025 | +₹4,50,000 | Positive | Maturity/redeem |
Formula: =XIRR(values, dates) → ~14.3%. Yeh saari entries aur dates ko lekar single annualized return deta hai.
Common Galtiyan
- Galti: SIP ka return CAGR se nikaalna → Sahi Tarika: SIP ke liye XIRR use karein — CAGR return ko overstate karta hai.
- Galti: Factsheet ka lump-sum CAGR apna SIP return maan lena → Sahi Tarika: Apna actual SIP XIRR alag se nikaalein.
- Galti: Invested amount ko positive daalna → Sahi Tarika: Excel mein invested = negative, redeemed = positive.
- Galti: Short-term (1 saal) XIRR ko final maan lena → Sahi Tarika: Equity SIP ka XIRR long-term mein hi meaningful hota hai.
- Galti: Dates ignore karna → Sahi Tarika: XIRR ka poora point dates hai — har cash flow ki actual date daalein.
Tips aur Tricks
- Apni SIP ka asli return jaanein XIRR Calculator se — factsheet ke CAGR par mat jaayein.
- Lump-sum aur SIP dono ke liye sahi metric chunein — lump-sum ke liye CAGR, SIP ke liye XIRR.
- Alag mutual funds compare karte waqt sabka XIRR dekhein, na ki advertised CAGR.
- XIRR ko hamesha inflation (5%) aur FD (7%) se compare karein — usse zyada ho tabhi real value.
- ROI aur CAGR ka basic samajhne ke liye CAGR Calculator aur ROI guide padhein, aur SIP plan karein SIP Calculator se.
XIRR Calculator — Free aur Instant
CalcDesk ke XIRR Calculator se seconds mein apni SIP ka actual annualized return pao — koi registration nahi, bilkul free.
XIRR Calculator Open Karein →Aksar Pooche Jane Wale Sawaal
Yeh article sirf educational purpose ke liye hai aur financial advice nahi hai. Mutual fund returns market ke saath badalte rehte hain aur past performance future ki guarantee nahi. Investment decisions se pehle qualified financial advisor se salah lein. Poora disclaimer padhein →