XIRR Calculator
Find the annualized return (XIRR) for investments with irregular cash flows. Choose how many cash flows you have (2–12), then enter each amount and time from start in years and months (e.g. 0 yr 0 mo for today, 0 yr 6 mo for 6 months, 1 yr 0 mo for 1 year). Use negative amounts for outflows (money you invested), positive amounts for inflows (money you received back).
How to use this calculator
- Select the number of cash flows (2–12) using the dropdown.
- Enter each cash flow amount — use negative for money invested, positive for money received.
- Set the timing for each cash flow in years and months from your start date.
- The XIRR result appears automatically as an annualized percentage return.
How This Calculator Works
XIRR uses Newton-Raphson iteration to solve for the discount rate r where the net present value (NPV) of all cash flows equals zero. Each cash flow is discounted by its time from the start date. The algorithm iterates until the NPV converges to zero (within a tiny tolerance), giving you the precise annualized return.
Formula Used
XIRR solves: Σ (CF_i / (1 + r)^t_i) = 0, where CF_i is each cash flow amount, r is the annual rate of return, and t_i is the time in years from the first cash flow. Negative cash flows represent investments (outflows), and positive cash flows represent returns (inflows).
Example Calculation
Suppose you invest $10,000 today, receive $2,000 after 6 months, $3,000 after 1 year, and $8,000 after 2 years. Enter: CF1 = -10000 at 0y 0m, CF2 = 2000 at 0y 6m, CF3 = 3000 at 1y 0m, CF4 = 8000 at 2y 0m. The calculator finds the annualized return accounting for the timing of each cash flow.
When to Use This Calculator
Use XIRR when evaluating investments with multiple, irregularly timed cash flows — such as SIP mutual funds, real estate with rental income, private equity distributions, angel investments, or any portfolio where you add or withdraw money at different dates.
Use XIRR when you have multiple cash flows at different times (e.g. several deposits, withdrawals, or dividends). Use CAGR when you have a single starting value and a single ending value with no intermediate cash flows.
A negative XIRR means your investment lost money on an annualized basis. For example, an XIRR of -5% means you lost 5% per year when accounting for the timing of all your cash flows.
IRR assumes cash flows occur at regular, equal intervals (e.g. monthly or annually). XIRR handles irregular timing — cash flows can happen on any date, making it more flexible and realistic for most real-world investments.
Yes. Enter each SIP installment as a negative cash flow at its time from start, and the current portfolio value as a positive cash flow at the end. XIRR will calculate your true annualized return accounting for every installment.
Copy the code below to embed this calculator on your site.
<iframe src="https://smartcalculators.tools/embed/xirr-calculator" title="XIRR Calculator" width="100%" height="400" frameborder="0"></iframe>