XIRR Calculator: Returns on Irregular Cash Flows [Free 2026]

How to Use the XIRR Calculator

Enter each cash flow with its date. Investments (outflows) should be negative. Returns (inflows) should be positive.
Include all cash flows: initial investment, additional investments, dividends, partial withdrawals, and final redemption.
XIRR handles irregular timing automatically. Unlike CAGR which assumes a single investment and single redemption, XIRR accounts for the actual dates of every cash flow.

XIRR vs CAGR: When to Use Each

Use CAGR when: Single lumpsum investment with single redemption. Simple point-to-point return calculation. Use our CAGR Calculator for this.

Use XIRR when: Multiple investments at different times (like SIP), partial withdrawals, dividends received during the holding period, or any investment with irregular cash flows. XIRR gives the true annualized return that accounts for the timing of every rupee invested and received.

Example: You invest Rs 1L on Jan 1, another Rs 1L on Jul 1, and redeem Rs 2.5L on Dec 31. CAGR on the total would give a misleading number because it ignores that the second Rs 1L was invested for only 6 months. XIRR correctly accounts for the timing and gives the true annualized return of approximately 23.4%.

XIRR Benchmarks for Indian Investments

Nifty 50 SIP (15+ years): 12-14% XIRR
Mid-cap fund SIP (10+ years): 14-18% XIRR
Equity mutual funds (3-5 years): Varies widely, 8-25% XIRR
Fixed deposits: 6-7.5% XIRR (pre-tax)
Real estate (metro cities): 8-12% XIRR including rental yield
Gold (10+ years): 9-11% XIRR in INR terms

Sources: AMFI data, NSE index returns, RBI data on deposit rates.

Use our CAGR to XIRR Converter to compare returns across different calculation methods, and our SIP Step-Up Calculator to model how annual SIP increases affect long-term XIRR.

Watch how to calculate your real investment returns easily with XIRR

Other Calculators

Similar Blogs

Fi Money: From Zero to Top Authority in Google AI Overviews

How upGrowth helped Fi Money dominate AI Overviews for smart deposit queries.

Sales Growth Guide [2026]

Complete guide to sales growth formulas.

MoM vs QoQ vs YoY Growth

Choosing the right growth metric.

Scripbox: 198K Traffic via Organic in 2 Months

How upGrowth helped Scripbox achieve 198K traffic and 8M impressions via organic.

Lendingkart: 20% Business Growth Through Google Ads

How upGrowth helped Lendingkart achieve 20% business growth through Google Ads.

Fintech Marketing Guide [2026]

Channels, compliance, growth.

FAQs

FAQs about XIRR Calculator

What is XIRR?

XIRR (Extended Internal Rate of Return) calculates annualized returns for cash flows occurring at irregular intervals. Unlike regular IRR which assumes equal periods, XIRR handles any date pattern. It is the correct way to measure returns on SIPs, real estate, and any investment with multiple cash flows at different dates.

How is XIRR different from IRR?

IRR assumes cash flows at regular intervals (monthly, annually). XIRR handles cash flows at any date. For SIPs that are always on the same date monthly, both give similar results. For irregular investments (lumpsum + SIP + bonus investment), XIRR is more accurate because it accounts for exact dates.

What is a good XIRR for mutual funds?

For equity mutual funds over 5+ years: 12-15% XIRR is good, matching or beating Nifty 50. Above 15% is strong. Above 20% is exceptional and unlikely to sustain. For debt funds: 7-9% XIRR is good. Always compare against the relevant benchmark index XIRR for the same period.

Why is my mutual fund XIRR different from the fund return?

Fund returns are calculated on NAV (point-to-point). Your XIRR depends on when you invested. If you invested a lumpsum at a market peak, your XIRR will be lower than the fund return. If you invested via SIP through a correction, your XIRR may be higher. XIRR is personal to your cash flow pattern.

How do I calculate XIRR for SIP in Excel?

In Excel: Column A = dates, Column B = amounts (negative for SIP installments, positive for current value). Formula: =XIRR(B1:B25, A1:A25). The last row should be today’s date with the current portfolio value as a positive number. This gives your true annualized SIP return.

Can XIRR be negative?

Yes. Negative XIRR means your investment lost money on an annualized basis. This happens when the total value of returns is less than total investments. During bear markets, SIP XIRR can be negative for 1-2 year periods. Over 5+ years in equity, negative XIRR is rare.

XIRR for real estate: how to calculate?

Cash flows: down payment (negative), EMIs (negative monthly), registration/stamp duty (negative), rental income (positive monthly), maintenance costs (negative), and sale proceeds (positive). Include ALL cash flows with actual dates. XIRR gives the true annualized return on your total real estate investment.