What is XIRR Calculator?
XIRR Calculator helps you calculate an annualized return for cash flows on irregular dates.
The main result is annualized XIRR. The formula, example and assumptions below explain how to interpret it.
How to use XIRR Calculator
Use the example to get familiar with the form, then enter your own figures. Any rates in the example are illustrative. Check the field labels and units before calculating.
- Gather cash flows: date, amount. Use values from the same situation or reporting period.
- Replace the example cash flows: date, amount with your own value, then complete the other fields. Check the displayed units.
- Select Calculate and read annualized XIRR. Change one input and calculate again to compare a second scenario. Reset restores the original example.
- Enter cash flows: date, amount in the format shown by the example. Keep the same separators and row structure. One YYYY-MM-DD, amount pair per line. Investments are negative; receipts / current terminal value are positive.
XIRR Calculator: a worked example
With the inputs below, the result is 10 % (annualized XIRR). Follow the example, then replace these illustrative values with your own.
| Input or output | Example value |
|---|---|
| Cash flows: date, amount | 2025-01-01, -100000; 2026-01-01, 110000 |
| Annualized XIRR | 10 % |
Understanding the XIRR result
The main output is annualized XIRR, expressed in %. It applies to the inputs and operation you selected.
Displayed results use a readable number of decimal places. When checking a result by hand, keep extra precision until the last step. To compare scenarios, change one input at a time and keep the others fixed.
XIRR Calculator: assumptions and common mistakes
A useful estimate starts with the right inputs. Check the following assumptions and limits before applying the result to your situation.
- Includes the final portfolio value as a positive cash flow on its valuation date. The numerical solver rejects detected multiple roots or an unfound root.
- A projected return is an assumption. Check whether fees, tax and inflation are included before comparing products.
For wider guidance, visit SEBI Investor Education. The formula and scope of this specific tool are stated on this page.






