XIRR Calculator — Calculate Annualised Return for Irregular Cash Flows

Cash Flows (one per line: date,amount) Format: YYYY-MM-DD,amount — use negative for investments/outflows, positive for the final redemption/inflow Enter at least two valid cash flow lines with at least one negative and one positive value.

XIRR (Annualised Return)

—

How to Use This Tool

List each of your cash flows — one per line, formatted as "date,amount" (e.g., 2022-01-15,-50000).
Use negative amounts for money invested (outflows) and positive amounts for money received back (inflows/redemptions).
Click Calculate XIRR to get your annualised rate of return across all the irregular cash flows.

What XIRR Measures

XIRR (Extended Internal Rate of Return) calculates the annualised return of an investment with cash flows occurring on irregular dates — unlike simple CAGR, which assumes a single lump-sum investment and a single withdrawal. This makes XIRR the correct metric for SIPs, staggered lump-sum investments, or any portfolio with multiple deposits and withdrawals over time.

How XIRR Is Calculated

XIRR finds the discount rate that makes the Net Present Value (NPV) of all your cash flows — each discounted back to today based on its specific date — equal to zero. Because this requires solving a nonlinear equation, this calculator uses an iterative numerical method (bisection) to converge on the correct rate, the same underlying approach spreadsheet software uses internally.

Why XIRR Matters More Than Absolute Returns

Two investors who put in the same total amount but at different times can have very different actual returns — an investor who invested most of their money right before a market rally will show a much higher XIRR than one who invested steadily throughout, even with identical total contributions and final value. XIRR captures this timing effect that a simple percentage return calculation misses entirely.

Common Uses

Evaluating actual SIP (Systematic Investment Plan) mutual fund returns
Comparing real estate or business investment returns with irregular income and expense timing
Assessing true portfolio performance when you've made multiple deposits and partial withdrawals over time

Frequently Asked Questions

What's the difference between XIRR and CAGR?

CAGR assumes a single investment made once and withdrawn once, growing smoothly at a constant rate. XIRR accounts for multiple cash flows on different dates, making it the correct metric for SIPs or any investment with irregular contribution timing.

Why do I need at least one negative and one positive cash flow?

XIRR represents a rate of return between money going out (investments, shown as negative) and money coming back (returns/redemptions, shown as positive) — without both, there's no meaningful rate of return to calculate.

Can I use this for calculating my mutual fund SIP returns?

Yes — list each SIP instalment as a negative cash flow on its investment date, and your current fund value (or redemption amount) as a positive cash flow on today's date, then calculate to get your true annualised SIP return.

This calculator is provided for general informational and estimation purposes only. Results should not be treated as professional financial, tax, legal, medical, or engineering advice. Always verify critical calculations with a qualified professional or official source before making decisions.