Must Knows

What is XIRR and how to calculate it?

[] XIRR is highly beneficial in showing return values on investments with multiple transactions at various periods.

Extended internal rate of return  or XIRR is used to determine the current value of any investment you have made. It shows a single rate of return, which can be calculated with each instalment to find the present rates. XIRR value will reflect your original investment return by showing the individual rate of return.

You are reading: What is XIRR and how to calculate it?

XIRR is highly beneficial in showing return values on investments with multiple transactions at various periods. When there is a SIP, it becomes challenging to find the exact return values due to multiple investments and times. In mutual funds, the SIP returns can be better showcased using XIRR values.

XIRR is the ultimate way to determine practical investment returns. While CAGR is beneficial when investing in a mutual fund, XIRR value will be indispensable when calculating the risk and returns of the investment.

How is XIRR important in mutual funds?

Read also : Section 24 of Income Tax Act: Tax deduction against home loan interest payment

If you spend Rs 5,000, Rs 10,000, Rs 6,000, Rs 5,000, and Rs 7,500 in SIPs over five years and earn Rs 54,000 at the end of the tenure, your return on investment is 22%. The IRR can be viable when you have made investments in evenly distributed spending.

However, some contributions or investors are not spread equally like they are in mutual funds. In mutual funds, investments are made and redeemed as per convenience and at irregular times.

In this scenario, the cash inflows and outflows occur at varying periods. Here, both the amount invested and the length of time are important in finding exact values of return from the total investments. The principle of XIRR will be beneficial here as it will be helpful in determining returns in the case of lump sums with varying periods of redemption.

Step-by-step process to calculate XIRR in excel

First, construct a single column that contains all your purchases. Any outflow, like investments and acquisitions, will be considered as market negative. Any inflow or redemption will be considered market positive. Now add the transaction dates to the next column.

Mention the current value of your investment and the date in the last row.

Read also : All about Axis Bank credit card and its benefits

In excel, you will find the XIRR function, which is denoted by this: = XIRR (values, date, Guess).

Now, input the values for a series of cash flows that match a payment schedule in dates. The date columns will represent the date of the first investment and the time when cash flows were obtained. The Guess parameter is not compulsory. 

Points to keep in mind while calculating XIRR in excel

  • All cash outflows must be entered as negative values and all cash inflows as positive.
  • If you haven’t redeemed your units, enter the current investment value and the date of the NAV.
  • Exempt dividend reinvestment from the calculations.

What is the difference between XIRR and IRR?

IRR doesn’t account for the actual flow and rolls them into annual periods. But XIRR considers the actual dates of the cash flow.

Are XIRR and CAGR the same?

XIRR is a combination of multiple CAGRs. For example, you make numerous investments in a fund, then, you can easily use the XIRR formula to calculate your overall investment CAGR.

Copyright belongs to:

Category: Must Knows

Debora Berti

Università degli Studi di Firenze, IT

Leave a Reply

Your email address will not be published. Required fields are marked *

Back to top button