Zen Calculator
XIRR Calculator
Calculate XIRR online for SIP, lumpsum and irregular investments. Enter your dates and amounts to get your true annualised return, worked out the same way as the Excel XIRR function.
- Matches Excel XIRR
- No data stored
- Perfect on mobile
Method last checked: 19 November 2026, against Microsoft’s XIRR reference
How it works
What Is XIRR and How Is It Calculated?
XIRR (Extended Internal Rate of Return) is the single yearly rate at which all your dated investments, withdrawals and current value add up to zero. It is money-weighted, so every rupee counts for exactly as long as it was invested. That is why it suits SIPs, top-ups and part redemptions, where a simple percentage gain misleads.
CF = cash flow (investments negative, money back positive) • d = date • r = XIRR
There is no closed-form answer, so the rate is found by repeated trial. This XIRR return calculator uses a 365-day year and the first date as the starting point, which is the same rule Excel and Google Sheets use.
Worked example
₹5,000 on the 1st of every month for 24 months from 1 Jan 2024, worth ₹1,40,000 on 1 Jan 2026: invested ₹1,20,000, absolute gain 16.67%, XIRR 15.53%.
Why XIRR beats absolute return
Most SIP money was invested for under a year, so the gain is earned over a short time. XIRR spreads it over the time each rupee was actually invested.
Signs matter
Money you put in is negative and money you get back is positive. You need at least one of each, on different dates.
Compare
XIRR vs CAGR vs Absolute Return
| Feature | XIRR | CAGR | Absolute return |
|---|---|---|---|
| Handles many investments | Yes | No | No |
| Uses exact dates | Yes | Start and end only | No |
| Annualised | Yes | Yes | No |
| Best for | SIPs, top-ups, part withdrawals | One lumpsum | Periods under 1 year |
A fund factsheet usually quotes CAGR, while your own XIRR depends on when you invested, so the two can differ for the same fund. For one investment and one redemption, XIRR and CAGR are identical.
Excel and Sheets
How to Calculate XIRR in Excel or Google Sheets
- Put your dates in column A, in real date format. The first row should be your earliest investment and the last row the date you value the portfolio.
- Put the cash flows in column B. Investments are negative numbers, and withdrawals and the current value are positive.
- Type
=XIRR(B2:B14, A2:A14)and format the cell as a percentage. - If you see
#NUM!, check that you have both negative and positive values, and that no date is earlier than the first date.
You can check any Excel answer here. Use the Irregular tab, enter the same rows, and compare the two results.
Which tab to use
XIRR Calculator for SIP, Lumpsum and Irregular Investments
- SIP XIRR calculator: pick monthly, quarterly, half-yearly, yearly or every 14 days, add the first instalment date, the valuation date and the current value. This works for a mutual fund SIP or any recurring plan.
- Lumpsum XIRR calculator: enter one investment, its date, and the value on a later date.
- Irregular investments: add each purchase, redemption and the current value as separate rows. Use this for top-ups, part withdrawals and portfolio statements.
- LIC or ULIP: use the SIP tab with yearly frequency for equal premiums, or the Irregular tab if premiums differ. Add the maturity or surrender value as the final amount. Note that the result ignores the life cover you also paid for.
Want to project future value instead? Use the SIP calculator on our home page. For a fixed-return option, compare your XIRR with the NSC Calculator, and for postal insurance plans use the PLI Calculator.
Read the result
How to Read Your XIRR
- There is no single good XIRR. Compare yours with inflation, a low-cost index fund over the same dates, and the rate your goal needs.
- Short periods look extreme. A 5% gain in 3 months annualises to about 21.6%. Treat annualised figures under one year with care.
- A negative XIRR is not an error. It means your withdrawals plus current value are worth less than what you invested, after allowing for timing.
- Taxes and fees are not included. Reduce the final value by exit load and tax to see a net XIRR.
- Several sign changes can give more than one answer. This is rare, and the calculator warns you when it happens.
About this tool
How We Check This Calculator
- Method: the XIRR rate is found by repeated narrowing until the cash flows discount to zero, with a 365-day year, as in Excel.
- Test 1: Microsoft’s own XIRR example gives 37.34%, the same as Excel.
- Test 2: a monthly SIP of ₹10,000 from 5 Jan 2025 to 5 Jan 2026, worth ₹1,30,000, gives 15.67%.
- Test 3: ₹1,00,000 doubling over 1,095 days (3 years of 365 days) gives 25.99%, which matches 21/3 − 1.
Zen Calculator is independent. Read more about us, or contact us if you find an error.
FAQ
XIRR Calculator FAQs
What is XIRR?
XIRR is the annualised return on investments made on different dates. It finds the one yearly rate that makes your dated investments, withdrawals and current value net to zero.
How do I calculate XIRR for a SIP?
Open the SIP tab, choose the frequency, enter the amount, the first instalment date, the valuation date and the current value. The calculator builds one dated cash flow per instalment and solves for the rate.
What is the difference between XIRR and CAGR?
CAGR assumes one investment and one final value. XIRR handles many investments and withdrawals on different dates. For a single lumpsum the two are identical.
Is this the same as the Excel XIRR function?
Yes. It solves the same equation with a 365-day year. Microsoft’s example (-10,000 followed by four inflows) returns 37.34% here, as it does in Excel.
Why does Excel show #NUM! for XIRR?
Usually all cash flows have the same sign, or a date is earlier than the first date in the list. Make investments negative, make withdrawals and the current value positive, and keep the earliest date first.
Can XIRR be negative?
Yes. If everything you took out, including the current value, is worth less than you put in after allowing for timing, XIRR is negative.
Does XIRR include tax and charges?
No. It uses only the amounts you enter. To see a net XIRR, reduce the final value by exit load, tax and fees.
How do I calculate XIRR for a lumpsum investment?
Use the Lumpsum tab. Enter the amount, the investment date, the current value and the valuation date. The result equals the CAGR of that single investment.
Can I use this XIRR calculator for LIC or ULIP?
Yes. Choose yearly frequency for equal premiums, or use the Irregular tab for uneven ones, and add the maturity or surrender value. The result does not account for the insurance cover.
What is a good XIRR for mutual funds?
There is no fixed number. Compare your XIRR with inflation, a benchmark index fund over the same period, and your goal. Short periods can make XIRR look very high or very low.
More calculators
Related Calculators
NSC Calculator
Compare your XIRR with a fixed return. See what a National Savings Certificate grows to at maturity.
Open the NSC Calculator →Sovereign Gold Bond Calculator
Check returns on a government-backed sovereign gold bond, then compare them with your XIRR.
Open the Sovereign Gold Bond Calculator →PF Calculator
Estimate your provident fund balance and see how it adds to your long-term savings.
Open the PF Calculator →PLI Calculator
Check premiums and returns on Postal Life Insurance, another way to save regularly.
Open the PLI Calculator →Results are estimates from the figures you enter. They are not investment advice. Mutual fund investments are subject to market risks, and past performance does not guarantee future returns.