IRR: What is IRR in Mutual Funds? Full form, Meaning & Formula

IRR: What is IRR in Mutual Funds? Full form, Meaning & Formula

Last updated: 27 Nov, 2021 | 04:41 pm

XIRR: What is XIRR in Mutual Funds? Full form, Meaning & Formula | INDmoney

Total returns are something you should be aware of. When you invest in something, you get a return on your investment. When it comes to depositing, it's quite simple. You make a deposit on a specified date and receive a return for a specific period of time. It is simple to calculate because the investment is made on a certain date, and you withdraw your funds on a future date.

What is IRR?

IRR stands for internal rate of return and is used to estimate the profits of the potential investments in financial analysis. A discount rate makes the NPV or net present value of the cash flows to zero in an analysis of discounted cash flows. The IRR calculations and NPV calculations rely on one another. It is essential to note that IRR is not the value of the actual dollar of the project. It is the annual return that turns the net present value to zero.

Shortcomings of IRR? 

The shortcomings of the IRR are listed as follows:

  • Ignores the size of the project: IRR does not account for the project’s size when compared with other projects. Cash flows are compared to the capital’s amount outlay determining the cash flows.
  • Ignores reinvestment rates: IRR allows you to calculate the future cash flows, but it is calculated on the assumption that cash flows can be reinvested as IRR at the same rate as before, which is highly unconventional. It is not practical.

What is XIRR in mutual funds? With example: 

If you start a mutual fund SIP with Rs 5000, you will continue to invest this amount every month in the future. So your first SIP is for the entire term, your following month's SIP is for a month less than the entire period, and so on. It becomes difficult to calculate the returns on these investments. You must compute the internal rate of return for changing amounts of investments made at irregular points in time in order to do so. In the course of the day, we all want to increase our money and receive greater returns, so we invest in mutual funds. 

You could choose the best investment products for yourself if you understand the complexities of mutual fund returns. It also aids in determining whether you received a fair return on your investment once you've made it. These yields can be used to compare mutual fund investments against other options such as liquid funds, gold, and more. 

The tool that helps you calculate the same is XIRR. The Extended Internal Rate of Return (XIRR) is a single rate of return that gives the current value of the entire investment when applied to each installment (and any redemptions).

Why XIRR is accurate for Mutual Funds:

CAGR is required to be considered when planning to purchase a mutual fund, but XIRR is rather important for evaluating your returns on investments. XIRR is employed for investments where cash flows are evenly spread in time, but most investments are not as evenly spaced as in the case of mutual funds. When a sequence of investments is made over time, including outflows, rewards, switches, and other transactions, XIRR provides a better way to calculate the return. When computing mutual fund returns, XIRR is far superior to other methods.

Step by step guide to calculating XIRR in Excel: 

Microsoft Excel may be used to calculate XIRR. To calculate XIRR, Excel has a built-in function. The XIRR function in Excel is one of the more powerful functions in the spreadsheet for computing the annualized yield for a schedule of cash flows that occur at irregular intervals.

XIRR formula in excel is:= XIRR (value, dates, guess)

  • After creating a single column for all your purchase values, mark them in the negatives, such as investments and acquisitions, and all positive inflows, such as redemptions, will be recorded.
  • The next step is to fill the corresponding column with the amount or value of the transaction.
  • The values and the dates corresponding to the said values should be typed in the final column. 
  • Finally, utilize the XIRR function from MS excel: = XIRR (values, date, Guess).
  • The values of cash flows that need to be chosen should respond to a payment plan, with the columns for dates representing the date of the very first investment and the cash flows.

All funds (The periodic SIPs, for instance) must be recorded as values in the negatives (use a minus sign prior to the given amount), and all cash-inflows (profit, SWP, dividends, etc.) must be entered as positives to compute XIRR in mutual fund schemes. If you haven't yet purchased all of your units, you'll need to input the present investment value as well as the NAV data to estimate the XIRR of your MF commitment. Because some transactions, such as reinvested dividends, do not entail actual cash flows, they should be excluded from the XIRR computation. Transitions are problematic; if you're computing XIRR at the scheme level in MF, you should consider a switch as a redemption.

The XIRR formula accounts for various cash inflows and cash outflows. The annual average return of each installment is computed using the XIRR formula. Then, they are modified to tell you the average total annual rate of return for all your investments.

Why can’t we use CAGR instead? With a solved example: 

Before understanding the difference, let us first get to know a little bit more about CAGR or Compound Annual Growth Rate. When you need to check a mutual fund plan's rates of return or compare one plan's returns to another, CAGR comes in handy. CAGR is widely used in the financial sector, and earnings of mutual fund categories or schemes are frequently represented in CAGR.

CAGR = (Final Investment Value/Initial Investment Value)^1/n – 1

Where ‘n’ is the period of investment.

CAGR, on the other hand, ignores recurring investments. As a result, if many SIP investments are made in a year, the CAGR calculation will be unable to present an accurate picture of returns.

This is where the XIRR, or Extended Internal Rate of Return, comes into play.

Now let us understand their difference with an example.

Assume you started a monthly SIP of Rs. 5000 in a mutual fund plan and maintained it for five years. Assume that, after a number of ups and downs, your entire investment value increased to Rs. 6.37 lakh at the end of five years. Your initial Rs. 5000 instalment has been invested for 5 years or 60 months in this case. Because it was invested for the longest period of time, the annual rate of return on this initial month's deposit will be different.

In other words, because each instalment is invested for a varied amount of time, the CAGR varies. It will be difficult to comprehend the CAGR of each of these payments of a mutual fund scheme if you look at the CAGR of any of these instalments.


Mutual fund returns are calculated using both XIRR and CAGR. For single payment contributions, CAGR is commonly used, but for SIP instalments, XIRR is commonly employed. As an owner, it is usually preferable to be familiar with return calculations so that you are not reliant on others. INDmoney is a great platform that helps you invest and keep track of all your financial matters with additional inputs and broker fewer options. 


  • What is the formula of CAGR? 

The formula of the CAGR is as follows: CAGR = (Final Investment Value/Initial Investment Value)^1/n – 1

  • What is IRR? 

IRR stands for internal rate of return and is used to estimate the profits of the potential investments in financial analysis. A discount rate makes the NPV or net present value of the cash flows to zero in an analysis of discounted cash flows.

  • What is the formula of XIRR in Excel?

XIRR formula in excel is:= XIRR (value, dates, guess).