XIRR of ₹5,000/Month SIP for 2 Years

Calculate the XIRR of a ₹5,000/month SIP started in January 2023 with a current value of ₹1.55 lakh in January 2025.

This calculation's inputs

Number of cash flows: 25
Total investments: 24 transactions
Start date: 2023-01-01
End / valuation date: 2025-01-01

Customise this calculation →

XIRR result

XIRR (annualised return)

26.61%

Accounts for exact timing of each investment

Total invested

₹1.2 Lakh

₹1,20,000

Current / final value

₹1.55 Lakh

₹1,55,000

Absolute gain

₹35,000

Calculate XIRR for your own investments →

About this scenario

CAGR only works for a single lumpsum investment at one date. A SIP involves multiple investments at different dates. XIRR accounts for the timing of every instalment to give you a true annualised return. Two SIPs with the same total invested and same end value can have very different XIRRs if the timing differs.

Mutual fund factsheets show point-to-point NAV returns, not your personalised XIRR. Your actual XIRR depends on exactly when you invested. In a rising market, early SIP instalments benefit more; in a falling market, later instalments buy at lower NAV. XIRR shows your personal experience, not the fund's abstract performance.

Frequently asked questions

XIRR (Extended Internal Rate of Return) is the annualised return on investments with irregular cash flows on specific dates. Unlike CAGR, it accounts for the exact dates of each investment and withdrawal. It is the standard method used by mutual fund houses and AMCs to report SIP returns.

CAGR is suitable for a single lump sum investment held for a fixed period. XIRR is for multiple cash flows on different dates, such as monthly SIPs or staggered investments. For a regular SIP, CAGR will overstate returns if used incorrectly, because you did not invest the entire amount on day one. XIRR gives the accurate per-year return for irregular investment patterns.

A 12-15% XIRR on an equity SIP over 10+ years is generally considered good for Indian markets, broadly in line with the Nifty 50 long-term average. Large-cap funds typically deliver 10-13%, mid-cap and small-cap funds may deliver higher returns with more volatility. Compare your XIRR to the benchmark return of the fund category.

List every SIP instalment as a negative cash flow with its exact date, then add the current NAV or redemption value as a positive cash flow with today's date (or the redemption date). Enter these in the XIRR calculator above. The calculator solves for the annualised return using Newton-Raphson iteration.

A negative XIRR means your investment has lost value on an annualised basis: you put in more money than the current worth of your portfolio. This can happen after a significant market fall, or if you invested near a market peak and are evaluating returns over a short period. A negative XIRR does not necessarily mean you should exit; market cycles often recover over longer horizons.

Related calculators

XIRR uses Newton-Raphson iteration and matches Excel XIRR output. Past returns are not indicative of future performance.

XIRR of ₹5,000/Month SIP for 2 Years

About this scenario

Why use XIRR instead of CAGR for SIP returns?

How does XIRR compare to what a fund house shows as returns?

Frequently asked questions

What is XIRR?

What is the difference between XIRR and CAGR?

What is a good XIRR for an SIP in India?

How do I calculate XIRR for mutual funds?

Why is my XIRR negative?