XIRR Calculator

Calculate returns on SIPs and irregular investments

Cash Flows

Date

Amount

Type

Date

Amount

Type

Date

Amount

Type

Add transactions and click Calculate to see your XIRR

Why use XIRR?

The most accurate way to measure SIP and irregular investment returns

Real Return Tracking

Calculates the actual return on investments with multiple cash flows at irregular intervals.

Handles Irregularity

Unlike CAGR, XIRR accounts for the specific dates of every investment and redemption.

SIP Accuracy

The best metric to measure SIP performance as each installment is invested on a different date.

Time Weighed

Gives weightage to time, acknowledging that money invested earlier has more time to grow.

Portfolio Review

Essential for reviewing the overall performance of a portfolio with frequent buy/sell transactions.

Correct Benchmarking

Helps in comparing your personal investment returns against the benchmark indices correctly.

What is XIRR?

Extended Internal Rate of Return (XIRR) is a method used to calculate returns on investments where there are multiple transactions happening at different times. Unlike CAGR which only considers start and end values, XIRR considers every inflow and outflow corresponding to its date.

Precision

Exact day-wise calculation

Flexibility

Handles any timeline

Industry Std

Used by Mutual Funds

When to use XIRR vs CAGR?

1

One-time Investment (Lumpsum)

Use CAGR. Since there is only one start date and one end date, CAGR is sufficient and accurate.

2

Multiple Investments (SIP)

Use XIRR. Since money is invested on various dates, CAGR cannot capture the time value of each installment correctly.

3

Irregular Withdrawals

Use XIRR. If you partially withdrew money during the investment period, XIRR factors this in.

4

Simple Growth Check

Use CAGR. For a quick check of point-to-point growth.

Frequently Asked Questions

Common queries about XIRR

In a SIP, every installment is invested for a different duration. The first installment is invested for the longest time, and the last for the shortest. XIRR calculates the return by accounting for these different holding periods, which a simple CAGR calculation cannot do.