FINBIZTOOLS
XIRR Calculator
Calculate annualized returns from dated investments and receipts.
Private by design · Inputs and downloads stay in your browser
Use negative amounts for investments and positive amounts for receipts, including the final portfolio value. Dates use day/month/year in browsers that follow that locale. Multiple-sign-change series are not supported because their return can be ambiguous.
How to enter transactions
Add a row for every dated cash flow. Investments you pay are negative; withdrawals and the final portfolio value are positive. Include at least two valid dates and both cash-flow signs. Add transaction inserts a row; Remove deletes it while keeping at least two rows. Reset restores the three example transactions.
Formula and numerical method
XIRR finds r where Σ cash flow i ÷ (1 + r)^[(date i − earliest date)/365] = 0. Dates use actual UTC days divided by 365, including leap days. We combine same-day cash flows and solve in log(1 + r) with bisection, at most 200 iterations, a normalized residual tolerance of 10^−12 and log-rate interval tolerance of 10^−10.
Example
Enter −₹10,000 on 1 January 2026, −₹5,000 on 1 July 2026 and ₹18,000 on 1 January 2027. The calculator solves the dated equation; treating all ₹15,000 as invested for a full year would give a different answer. A simpler −₹10,000 and +₹11,000 exactly 365 days apart produces 10% XIRR.
Ambiguous or unsupported cash flows
There may be no solution or more than one solution. After combining dates, this implementation accepts exactly one sign change; it rejects multiple-sign-change series rather than selecting an arbitrary answer. Search is bounded between −99.9999% and 1,000,000%. A result outside that range is reported as unavailable. Up to 200 rows and dates from 1900 to 2200 are supported.
Frequently asked questions
What is the difference between XIRR and CAGR?
CAGR uses two values and a duration. XIRR accounts for multiple dated cash flows.
Why does the tool reject multiple sign changes?
Such cash flows may admit multiple annualized rates. The tool avoids presenting one arbitrary solution as definitive.
What date convention is used?
Actual elapsed UTC days divided by 365, even across leap years.
Why include the ending value?
The ending portfolio value represents a hypothetical receipt on the valuation date and closes the cash-flow series.
Related tools
Disclaimer
This calculator provides an estimate based on the assumptions entered and does not guarantee investment returns. Results are informational, not financial, lending, tax or legal advice. Verify important decisions with a qualified professional. See our Disclaimer.