XIRR Calculator
Your result will appear here
XIRR Calculator summary
Calculation schedule
Figures may be rounded for display.
Saved calculations
Saved only in this browser on this device.
XIRR calculator formula
XIRR finds one yearly rate that balances all money paid and received after allowing for the exact dates.
Find rate r where: 0 = sum of [cash flow ÷ (1 + r)^(days from first date ÷ 365)] Money invested = negative amount Money received or current value = positive amount XIRR = r × 100%
The answer cannot normally be found in one simple step, so the calculator tests rates until the balance is close to zero.
You need at least one negative cash flow and one positive cash flow.
Example with numbers
Enter −₹1,00,000 on 1 January 2024, −₹50,000 on 1 January 2025 and +₹1,80,000 on 1 January 2026. The XIRR is about 11.46% a year. The dates matter, so this tells you more than the ₹30,000 cash gain alone.
What is XIRR and when should you use it?
XIRR means Extended Internal Rate of Return. It gives one annualised return for money that moved in or out on different dates.
It is useful for SIP payments, extra investments, partial withdrawals and a portfolio that has not yet been sold. CAGR is usually better for one starting amount and one ending amount.
How to use the XIRR calculator
- Add every investment with its real date and a minus sign.
- Add withdrawals, sale money or today’s portfolio value as positive amounts.
- Check that no transaction is missing or entered twice.
- Calculate XIRR and compare the cash-flow table with your statement.
What the results mean
- XIRR: the yearly return produced by the dated cash flows.
- Total invested: all negative cash flows added without the minus sign.
- Total received/value: all positive cash flows added together.
- Cash gain: positive cash flows minus money invested, before annualising.
How this XIRR calculator works
Each date becomes a fraction of a 365-day year. The calculator keeps changing the trial return until the present value of positive and negative cash flows balances.
Some unusual cash-flow patterns can have more than one answer, or no usable answer. In that case the calculator shows an error instead of making up a rate.
Why an XIRR calculator is useful
- It uses actual dates, not equal monthly gaps.
- It handles investments, withdrawals and a current value together.
- It gives an annualised number that is easier to compare across periods.
- The full dated list can be checked and downloaded.
Why XIRR may differ from Excel or your app
A missing dividend, fee, tax, wrong date or old portfolio value can change the result. Even one day can make a small difference.
When cash flows change from positive to negative several times, there may be more than one mathematical answer. Different tools may find different roots.
Sources
Rule and source review: Numerical method and 365-day exponent convention reviewed 31 August 2026.
Disclaimer
XIRR is a calculation from the cash flows entered by you. It is not a forecast, guarantee or investment recommendation. Use complete transaction records and the correct valuation date before relying on the result.
Frequently asked questions
What does XIRR mean?
XIRR means Extended Internal Rate of Return. It is an annualised return for cash flows on different dates.
Why do investments need a minus sign?
An investment is money leaving you, so it is entered as negative. Money received is positive.
Can I calculate XIRR before selling?
Yes. Add the current portfolio value as a positive cash flow on the valuation date.
What is the difference between XIRR and CAGR?
CAGR uses one start and one end value. XIRR also handles payments and withdrawals between those dates.
Why is my XIRR not calculating?
Check that you have at least one negative and one positive cash flow. Some patterns still have no usable single answer.