Content par jaayein

Agla concept dhoondhein

Shabdkosh term

XIRR: jab paisa alag alag dates par aata jaata hai.

Doosre naam: xirr, extended internal rate of return, irr on dates, money weighted return.

XIRR ek saalana rate hai jo un cash flows par kaam karta hai jo tay calendar dates par hote hain. Yeh woh rate hai jis par saare flows present value mein jud kar shoonya ho jaate hain. Seedha shuruaat se anth ka rate dates ko andekha karta hai. XIRR har contribution aur har nikaasi ki asli date ginta hai.

Ise kaise padhein

Agar paisa ek hi baar laga aur ek hi baar nikla, toh seedha saalana rate kaafi hai. Lekin jab har mahine kuch jaata hai aur beech mein kuch nikalta hai, tab har rakam alag samay tak lagi rehti hai.

XIRR wahi antar ginta hai. Har flow ki apni date, apna samay — aur un sab ko jodne wala ek hi saalana rate.

Yeh kya nahi batata

XIRR ka gaanitik jawab har baar unique nahi hota. Asaamanya cash-flow patterns par ek se zyada jawab ho sakte hain, aur kabhi kabhi jawab milta hi nahi.

Aise mein solver error deta hai. Us error ka matlab yeh hai ki is pattern par jawab nikaala nahi ja saka — yeh nahi ki return shoonya tha.

Reference. Microsoft Support - XIRR uses actual payment dates on a 365-day basis and requires at least one negative and one positive cash flow.
Yeh term is lesson mein aata hai

Ek account, 3 return figures — aur yeh 3 alag sawaalon ke jawab hain.

Ek hi account par 3 return figures alag jawab dete hain. Kaunsa lump sum par sahi hai, kaunsa dated contributions par, aur har ek kya chhupa leta hai.

Lesson kholo