XIRR in Mutual Fund Kya Hota Hai? . Yaar, ek baat batao jab aap apna mutual fund account check karte ho aur wahan “Returns” section mein XIRR likhा hota hai, tab aapke mann mein pehla sawaal kya aata hai?
Yahi na “Yeh XIRR kya bakwaas hai bhai? CAGR toh samajh mein aata tha!”
Don’t worry. Aaj main Sagar Yelave l, SEBI-certificate Mutual Fund Distributor aur AMFI-registered advisor aapko bilkul simple bhasha mein samjhaungi ki XIRR kya hota hai, yeh kyun important hai, aur isse Excel mein calculate karna itna aasaan kyun hai ki aap khud hairan ho jaoge.
Toh chalte hain ekdum basics se!
XIRR in Mutual Fund Kya Hota Hai?3
XIRR = Extended Internal Rate of Return
Iska seedha matlab hai aapki investment ka actual annualised (per year) return.
Ab yahan ek trick hai. Jab hum aam zindagi mein “return” bolte hain toh simple calculation mein yahi sochte hain:
Table of Contents
“Maine ₹1,00,000 lagaye, ab ₹1,20,000 ho gaye toh 20% return mila!”
Lekin yeh sirf tab sahi hai jab aapne ek hi baar, ek hi din paisa lagaya ho (lump sum). Asal zindagi mein hum SIP karte hain har mahine ₹5,000, ₹10,000 alag-alag dates par. Toh ek simple percentage se actual return nahi nikalta.
se actual return nahi nikalta.
Yahan XIRR kaam aata hai.
XIRR vs CAGR — Kya Fark Hai?
| Feature | CAGR | XIRR |
|---|---|---|
| Full Form | Compounded Annual Growth Rate | Extended Internal Rate of Return |
| Best For | Lump Sum investment | SIP / Multiple investments |
| Cash Flows | Single (start & end) | Multiple, different dates |
| Accuracy for SIP | ❌ Galat/Misleading | ✅ Bilkul Sahi |
| Excel Formula | =(End/Start)^(1/Years)-1 | =XIRR(values, dates) |
Simple rule: Ek baar paisa lagaya → CAGR use karo. Baar baar paisa lagaya (SIP) → XIRR use karo.
XIRR Kaam Kaise Karta Hai? Seedha Example
Maan lo aapne yeh SIP kiya:
| Date | Transaction | Amount (₹) |
|---|---|---|
| 01-Jan-2024 | SIP Investment | -5,000 |
| 01-Feb-2024 | SIP Investment | -5,000 |
| 01-Mar-2024 | SIP Investment | -5,000 |
| 01-Apr-2024 | SIP Investment | -5,000 |
| 01-May-2024 | SIP Investment | -5,000 |
| 01-Jun-2024 | SIP Investment | -5,000 |
| 23-Jun-2026 | Current Value (Redemption) | +38,500 |
Yahaan total invest = ₹30,000 | Current value = ₹38,500 | Profit = ₹8,500
Ab agar aap sirf simple calculation karein toh bologe “28.3% return mila” lekin yeh galat hoga kyunki harr installment alag time par lagi thi! XIRR in sab dates ko consider karke ek accurate annualised return % dega.
Excel Mein XIRR Calculate Kaise Karein?
Yeh bilkul simple hai sirf 3 steps:
- Column A mein dates daalo Harr SIP date aur last mein aaj ki date (current value ki date)
2. Column B mein amounts daalo Investments ko negative (-5000) aur current portfolio value ko positive (+38500) mein likhо
3 Kisi bhi empty cell mein type karo:
Enter dabaо aapka XIRR aa jayega!
Expert Insight – Sagar Yelave , SEBI MFD
“Mere paas bahut saare clients aate hain jo kehte hain ‘Yaar, mera fund 15% return de raha hai lekin mujhe toh 8% hi mila!’ Reason yahi hota hai fund ka official return NAV-based hota hai, aapka personal XIRR depend karta hai aapne kab paisa lagaya. Market high par SIP shuru karne wale investors ka XIRR naturally fund ke quoted return se kam hoga. Isliye apna XIRR zaroor check karo woh aapki real story batata hai.”
Positive vs Negative XIRR Kya Matlab Hai?
Positive XIRR
Aapki investment grow kar rahi hai. Jitna zyada XIRR, utna better return. 12-15% XIRR long-term SIP ke liye excellent maana jaata hai.
Negative XIRR
Aapki current value invested amount se kam hai loss mein ho. Yeh tab hota hai jab markets recently gire hon. Panic mat karo SIP jari rakho!
XIRR Ke Baare Mein Common Galtiyan
Galti #1: XIRR ko fund return samajhna
Nahi! XIRR aapka personal return hai. Fund ka quoted return alag hota hai.
Galti #2: Sirf 1-2 mahine mein XIRR judge karna
Itne short time mein XIRR 100%+ ya -50% aa sakta hai yeh misleading hai. XIRR minimum 1 saal ke baad meaning hota hai.
Galti #3: Dividend income ko XIRR mein na jodna
Agar aapne dividend plan liya hai, toh received dividends bhi XIRR calculation mein add karo (positive values mein) warna return understated hoga.
Galti #4: Current value ko negative daalna
Current portfolio value hamesha positive hogi yeh aapka “paisa wapas aana” hai. Galat sign dene par XIRR ka result galat aayega.
Key Takeaways
- XIRR = Extended Internal Rate of Return SIP investors ke liye sabse sahi return calculator
- CAGR sirf lump sum ke liye sahi hai; XIRR multiple cash flows handle karta hai
- Har SIP installment ek alag cash flow hoti hai XIRR inhe individually treat karta hai
- Excel mein
=XIRR(values, dates)formula se aasaani se calculate karein - Negative XIRR = loss mein ho; Positive XIRR = growth mein ho
- Aapka XIRR aur fund ka official return alag ho sakta hai