XIRR calculator
OVER 4.24 YEARS
11.49% a year
You put in ₹5,10,000.
XIRR basics
What is XIRR?
XIRR is the single yearly rate that links every dated amount you put in or took out to what the holding is worth now. It is the usual measure for a SIP, and many statements and apps show it.
It turns a list of dated amounts and one value now into one number. It is a summary, not a year-by-year record: real returns rarely arrive at the same rate each year.
How is XIRR calculated?
f(rate) = Σ amount ÷ (1 + rate) ^ (days ÷ 365)
XIRR is the rate that makes f(rate) = 0
Days between dates are counted whole and divided by 365, the same as Excel and Google Sheets, so a figure worked out here matches a spreadsheet.
The CAGR calculator divides by 365.25 instead, so the same dates can give a slightly different figure there.
There is no formula that gives the rate directly, so the calculator narrows it down until the amounts balance. The rate is compounded once a year.
For a monthly amount, each instalment falls on the 15th, running from Since to Stopped or to the month of the worth-now date, whichever comes first; an instalment dated after the worth-now date is not counted. When a step-up is set, the amount rises after every 12 instalments.
Worked example: ₹1,00,000 put in on 1 Apr 2024 and ₹50,000 on 1 Oct 2024, worth ₹1,70,000 on 1 Apr 2026 — 183 and 730 days. The rate that balances these amounts is 7.06% a year.
What do the inputs mean?
- Every month you put in
- The amount of each SIP instalment, before any step-up.
- Since
- The month of the first instalment.
- What it's worth now
- The value on the date shown beside it, from your statement or app. It can be lower than what you put in.
- Its date
- The date it was worth that amount. It starts as today; entering your statement’s own date brings the result closer to the statement’s.
- Stopped
- The month of the last instalment, if the SIP has stopped. Otherwise leave it as still running.
- Step-up, a year
- How much the monthly amount rises after every 12 instalments.
- One-off amounts
- A single amount put in (In) or taken out (Out), with its date. With no SIP, every amount is entered this way.
The calculator applies these bounds to each input:
- Every month you put in: ₹100 to ₹1,00,00,000
- Since: January 1990 to the month of the worth-now date
- What it's worth now: ₹0 to ₹1,00,00,00,000 (a loss is allowed)
- Its date: 1 January 1990 to today
- Stopped: still running, or Since or later
- Step-up, a year: 0% to 50%
- One-off amounts: up to 25, each ₹1 to ₹1,00,00,00,000, dated 1 January 1990 to the worth-now date
How do I read the result?
This rate is a single average across the whole period. It does not describe the path the value took in between: two holdings with the same XIRR can have taken very different routes.
It may differ from the figure your statement or app shows. They use the exact instalment dates, their own valuation date, and amounts you have not entered here. Entering the date on your own statement, next to the value, brings the two closer.
What does XIRR leave out?
Figures are gross of tax, of any product charge, and of any fee payable to a research analyst.
A statement value already has the running charges of the holding taken out. Anything charged to you separately is not, so it is not reflected in the rate.
Frequently asked questions
How do I calculate XIRR in Excel?
List every dated amount in two columns: the dates in one, the amounts in the other, with money put in as a negative number and money taken out — including the value now — as a positive one. Then enter =XIRR(amounts, dates) and format the cell as a percentage. Google Sheets uses the same function. This calculator counts the days between dates and divides by 365, matching both.
What is the difference between XIRR and CAGR?
CAGR needs only two amounts, a start and an end, with nothing added or taken out between. XIRR takes several dated amounts in and out, such as a SIP, and needs every date and amount. For two amounts and a length of time, use the CAGR calculator.
Can XIRR be negative?
Yes, XIRR can be negative. When what the holding is worth now, together with anything taken out, is less than what was put in, the rate is negative: a loss, shown as one.
What is a good XIRR?
There is no single figure that counts as good. Whether a rate is high or low depends on the period it covers, what the money was invested in, and what you compare it with, such as inflation over the same years.
Why is my XIRR different from my app's?
An app uses the exact date and amount of every instalment, its own valuation date, and any charge or income you have not entered here. A small difference is usual. Entering the date your statement was valued, next to that value, brings the two closer.
Does the calculator save or send my numbers?
No, the XIRR calculator does not save or send your numbers. It runs in your browser. No number you type is stored or sent anywhere, or added to the page address. Sharing the calculator sends only a link to this page.