Back to Calculators
INVESTMENT
XIRR Calculator - Internal Rate of Return
Calculate the accurate return for irregular cash flows. Use our XIRR tool for complex investments like SIPs with varied dates or amounts.
Use this Tool
Access the free online version of this calculator via our trusted partner.
Frequently Asked Questions
What is XIRR?
Extended Internal Rate of Return (XIRR) is a method to calculate returns when there are multiple, irregular cash flows.
When should I use XIRR instead of CAGR?
Use XIRR for SIPs or multiple buy/sell transactions; use CAGR for one-time lumpsum investments.
How do I calculate XIRR in Excel?
You use the =XIRR(values, dates) formula. Our calculator does this automatically for you.