What this estimate uses
Initial investment, Initial investment date, Additional investment, Additional investment date, Current or redemption value, Valuation or redemption date.
Investments calculator
XIRR Calculator India: Return by Exact Dates
What annual return did irregular cash flows earn?
Estimate an annualised return from irregular cash flows using their exact dates.
Your estimate
Live result
Estimated XIRR
—How it works
A useful estimate, with the assumptions out in the open.
XIRR is the annual rate that makes the present value of the dated cash flows equal to zero. Investments are negative cash flows, the final value is positive, and exact day differences use a 365-day year.
This result is an educational estimate. Rates, taxes, fees, product rules, and market returns can change.
India-focused guide
What annualised return did investments made on different dates earn?
Enter the initial and additional investments with their exact dates, then enter the current or redemption value and valuation date. The calculator finds the annual rate that makes the net present value of those dated cash flows equal to zero.
Important assumption
XIRR is the annual rate that makes the present value of the dated cash flows equal to zero. Investments are negative cash flows, the final value is positive, and exact day differences use a 365-day year.
Created and maintained byAll Tool Central
Formula and content reviewed16 October 2026
See how estimates are builtCalculation methodology
Detailed guide
Understand the result before using it.
This XIRR calculator uses exact transaction dates to estimate the annual rate that makes the net present value of irregular cash flows equal to zero. It is designed for an initial investment, one additional investment and a final valuation or redemption amount.
Why exact dates matter
A rupee invested earlier is exposed to the investment for longer. XIRR therefore discounts each cash flow by the exact number of days from the first cash flow, using a 365-day year, instead of pretending every contribution happened at a regular interval.
Investments are entered as positive amounts in the form but treated as negative cash flows inside the calculation. The final current or redemption value is treated as the positive cash flow.
FormulaFind r such that Σ cash flow ÷ (1 + r)^(days from first cash flow ÷ 365) = 0
Worked example with two investments
An investment of ₹1 lakh on 1 January 2024, another ₹50,000 on 1 September 2024 and a value of ₹2.10 lakh on 1 January 2026 produces an estimated XIRR of about 20.69%.
| Date | Cash flow | Treatment |
|---|---|---|
| 1 January 2024 | ₹1,00,000 invested | Negative |
| 1 September 2024 | ₹50,000 invested | Negative |
| 1 January 2026 | ₹2,10,000 value | Positive |
| Estimated result | 20.69% a year | XIRR |
XIRR is not the same as absolute return or CAGR
Absolute return ignores timing. CAGR works cleanly for one starting value and one ending value. XIRR is useful when money enters or leaves on different dates because it gives each cash flow its own time weight.
The result is backward-looking for the entered value and dates. It does not forecast a future return, deduct fees or taxes, or resolve the multiple possible answers that complex cash-flow patterns can sometimes produce.
Enter clean cash-flow data
- Use settlement or transaction dates consistently rather than mixing statement dates.
- Use the portfolio value on the exact valuation date for an open investment.
- Include fees in the cash-flow amounts if you want a net-of-fee return.
- For many contributions and withdrawals, use a spreadsheet or portfolio tool that accepts the complete cash-flow list.
Common questions
Frequently asked questions
Why did the calculator switch from months to dates?
Exact dates are the defining feature of XIRR. A month-based approximation can produce a different result when cash flows occur on irregular days.
Is XIRR an annual return?
Yes. It is an annualised rate derived from the dated cash flows using a 365-day basis.
Should the current portfolio value be entered as a cash flow?
Yes. For an open investment, use its current value as the final positive cash flow on the valuation date.
Why can XIRR fail to solve?
A solution requires both negative and positive cash flows and a pattern that brackets a valid rate. Certain complex sign changes can have no unique result.
Continue planning