CAGR & XIRR Calculator
Find out what yearly return your investment really earned. Use CAGR for a single investment, or XIRR when money went in and out on different dates, as with SIPs, top-ups and partial withdrawals.
Page updated
Estimates only. These results are for general information and are not financial, investment or tax advice. Check important figures with your bank, the official source or a qualified adviser before you decide. Read the disclaimer.
How to Use
- Choose one-time (CAGR) or several dates (XIRR).
- For CAGR, enter the amount invested, today's value and how long you held it.
- For XIRR, add each investment or withdrawal with its date, then the current value.
- Read the yearly return and download your cash flows if you like.
Limitations
- XIRR needs at least one investment and one withdrawal or current value.
- Dividends paid out should be entered as withdrawals on the date received.
Frequently Asked Questions
CAGR or XIRR?
CAGR suits one investment held for a period. XIRR handles several investments and withdrawals on different dates, so it is the right measure for a SIP or a portfolio you add to.
Is this the same as Excel's XIRR?
Yes. It uses the same 365-day-year formula and gives the same result as Excel's XIRR for the same dates and amounts.
Are the numbers I enter saved or sent anywhere?
No. Everything is calculated in your browser and nothing is stored. A link to your numbers is only created if you click Copy link.
What is the CAGR formula?
CAGR = (final value ÷ starting value)^(1 ÷ years) − 1. In Excel: =(end/start)^(1/years)-1, or =RRI(years, start, end). An investment that grows from ₹1 lakh to ₹2 lakh in 6 years has a CAGR of about 12.2%.