Website of Vivek Kumar Malviya · Not the official website of Angel One Ltd.Never share OTP or PIN · Stay safe →
Vivek Malviya.Authorised Person · Angel One Ltd

What Is XIRR?

XIRR explained: how it works out a yearly rate of return when money goes in on different dates, why it suits SIPs and how it differs from a simple return.

What is XIRR?

XIRR, or extended internal rate of return, is a way to express returns as one yearly rate when money goes in or out on different dates, as in a monthly SIP. Because each amount is invested for a different time, a simple return would be misleading. Spreadsheets have an XIRR function. It describes the past and is not a forecast.

Key points

Why it exists: money goes in on different dates.

Result: one yearly rate.

Tool: spreadsheets have an XIRR function.

Looks back: it describes the past only.

XIRR and CAGR

CAGRCAGR CAGR is the steady yearly growth rate that would take a starting value to an ending value over a period. Read more › suits one amount invested once. XIRR suits a series of dated amounts. See CAGR meaning and the SIP calculator for an illustration.

Official sources

SEBI

Frequently asked questions

Is XIRR the same as CAGR?

No. CAGR is for one amount over a period. XIRR is for several dated amounts.

Does a high XIRR mean it will continue?

No. It describes past results only.

Where can I calculate it?

Spreadsheet software has an XIRR function.

Is this advice?

No. It explains the term only.

खाता खोलें →WhatsApp →
ACCOUNT OPENING HELP

आपकी शुरुआत यहाँ से होगी।

यह केवल डिज़ाइन का नमूना है। आपका मोबाइल नंबर कहीं भेजा या सेव नहीं किया गया। असली प्रक्रिया देखने के लिए नीचे मौजूदा वेबसाइट खोल सकते हैं।

असली प्रक्रिया समझें →
FIND YOUR WAY

आप क्या ढूँढ रहे हैं?

Search articles, guides and account help.