XIRR Calculator

Calculate the true annualised return of an investment with irregular cash flows — the correct method for SIPs, top-ups and staggered withdrawals.

Share

Ready to start investing?

Partner offers

We may earn a commission if you sign up through these links, at no extra cost to you.

Advertisement
FinanceYour ad here

What is the XIRR Calculator?

XIRR (Extended Internal Rate of Return) is a single annual rate of return that accounts for the exact timing and size of every cash flow. It's the right way to measure SIP or multi-transaction returns, where CAGR would mislead.

How to Calculate

XIRR finds the rate at which the net present value of all dated cash flows equals zero, solved iteratively (the same method Excel's XIRR uses). Enter each transaction with its date — money invested is negative, money received is positive.

Formula

Solve for r in Σ CFᵢ / (1+r)^(dᵢ/365) = 0

How to Use

  1. Enter your details in the fields above.
  2. The result updates instantly as you type.
  3. Use Copy, Print or Download PDF to save your result.

Frequently Asked Questions

When should I use XIRR instead of CAGR?
Use XIRR whenever there are multiple cash flows at different times (SIPs, SWPs, top-ups). CAGR only works for a single lump-sum with one entry and one exit.
Advertisement
FinanceYour ad here
Was this calculator helpful?
Embed this calculator

Copy this code to add the calculator to your own website: