Free XIRR Calculator | Unit Converters

Cash Flows

Total Invested

15,000

Total Returned

18,000

XIRR

23.45%

Annualized return

How It Works

1

Add Cash Flows

Enter dates and amounts (negative for investments)

2

Calculate XIRR

Get annualized return rate

XIRR
Extended Internal Rate of Return

What is XIRR Calculator?

📊

What

XIRR calculator helps you find the annualized return rate for investments with irregular cash flows and different dates.

💰

Why

Used for analyzing SIP returns, mutual fund performance, and comparing different investment options with varying cash flows.

🎯

Applications

SIP analysis, portfolio performance, investment comparison, mutual fund returns, and irregular investment tracking.

Common Examples

SIP Investment Example

Jan 2023: Investment-₹10,000
Jun 2023: Investment-₹5,000
Jan 2024: Redemption+₹18,000
XIRR Result:~15.2%

Lumpsum Investment Example

Mar 2023: Investment-₹50,000
Sep 2023: Additional-₹25,000
Mar 2024: Redemption+₹85,000
XIRR Result:~18.7%

XIRR Calculation Table

Investment AmountTime PeriodFinal ValueXIRR (%)
₹10,0001 Year₹11,20012.0%
₹25,0002 Years₹31,25012.5%
₹50,0003 Years₹70,00011.9%
₹1,00,0005 Years₹1,80,00012.5%

Frequently Asked Questions

1

What is XIRR?

XIRR (Extended Internal Rate of Return) calculates the annualized return rate for investments with irregular cash flows and different dates.

2

How to enter cash flows?

Enter negative amounts for investments (money going out) and positive amounts for returns (money coming in). Include exact dates for accurate calculation.

3

When to use XIRR?

Use XIRR when you have irregular investment amounts and dates, like SIP investments, lumpsum investments at different times, or mixed investment patterns.

4

What is a good XIRR rate?

A XIRR of 12-15% is considered good for equity investments, while 8-10% is reasonable for debt investments. Higher rates indicate better performance.

5

XIRR vs IRR difference?

IRR assumes regular cash flows at equal intervals, while XIRR handles irregular cash flows with specific dates, making it more accurate for real investments.

6

Can XIRR be negative?

Yes, XIRR can be negative if your investment has lost money. A negative XIRR indicates that your returns are less than your investments.

Quick Reference

📏1 meter
3.28 feet
⚖️1 kilogram
2.2 pounds
🌡️0°C
32°F
🥤1 liter
0.26 gallon