Insights Page/Mutual Funds

XIRR Calculator: How It Works, Formula and a Worked Example

Calculate returns for irregular cash flows. Here is the formula, a worked example, the mistakes to avoid, and a free calculator with a downloadable PDF report.

Abhishek sharma
Editorial Lead
Updated September 17, 2026
4 Min Read

Most people meet the xirr calculator the same way — someone quotes a number, it sounds reasonable, and there is no easy way to check it. That is exactly the gap this guide closes. By the end of it you will know what the number is made of, where it usually goes wrong, and you will have run your own figures through our free xirr calculator.

Cover image slot — add a screenshot or illustration from Admin → Blog when it is ready.

Prefer to start with your own figures? Use the XIRR Calculator now, or continue for the formula and a worked example.

How this is worked out

Extended Internal Rate of Return (XIRR) is used when you have multiple investments and withdrawals at different dates.

The formula behind it:

Internal Rate of Return for non-periodic cash flows
Symbol What it means
CF Cash Flows
D Dates

Nothing is rounded away quietly and nothing is assumed on your behalf. If a figure appears in the result, it came from something you entered.

A worked example you can follow

Investing different amounts every few months and checking overall return.

Change any one input and watch the result move — that sensitivity is the real lesson. It is far more useful than memorising a single outcome, because your own rate, tenure or contribution will never match the example exactly.

Using the XIRR Calculator, step by step

  1. Open the XIRR Calculator.
  2. Enter your figures. Use the ones on your statement, sanction letter or scheme document rather than a remembered number.
  3. Read the result card — the headline figure plus the breakdown that produced it.
  4. Adjust one input at a time to see what genuinely moves the outcome.
  5. Tap Download PDF to keep a copy of the calculation, with your inputs and assumptions printed on it.

The PDF takes a few seconds to build because it is a properly typeset report, not a screenshot. You will see a progress message while it is being prepared, and the download starts on its own.

Practical pointers

  • Use this for mutual fund portfolios with SIPs and lumpsums.

Common mistakes worth avoiding

  • Comparing CAGR with XIRR for irregular flows.

If you want to go a level deeper afterwards, read up on xirr vs cagr. Both come up the moment you start comparing options seriously.

Interactive calculator

Try the XIRR Calculator

Enter your own figures below. The same calculator and PDF report remain available on the focused calculator page.

%
Yrs

Scenario Analysis (Assumed Returns)

Conservative

10%

33,637

Base

12%

48,231

Higher

14%

68,717

Labels are estimates based on your base rate (12%).

Estimated Maturity Value

₹0

Total Principal

₹5,000

Estimated Returns

₹0

Portfolio Mix

Invested
Returns

Growth Curve

Visual graph available for compounding tools

You invest ₹5,000 every month for 20 years. At an estimated 12% annual return, your total investment is ₹0 and the estimated total value is approximately ₹0. Around ₹0 represents estimated growth.

Next Architectural Steps

Open the full calculator

What else you will find on VIA Capital

The calculator is one corner of a much bigger free toolkit. While you are here:

New tools and sections go live regularly, and each one gets written up here the same way.

Questions people ask us

Is the XIRR Calculator free to use? Yes. Every calculator on VIA Capital is free, works without a login, and nothing you type is stored on our servers.

How accurate is it? The arithmetic is exact — it is the formula shown above, nothing hidden. Accuracy of the answer depends on your inputs. Rates, tenures and charges change, so use the figures from your own statement or sanction letter rather than a number you remember.

Can I save or share the result? You can download a formatted PDF report of your calculation and share it with your family, your CA or your bank. The download link sits right under the result.

Does it work on a phone? It does. The xirr calculator is built mobile-first, which is how most people in India actually search for "xirr".

Is this investment advice? No. VIA Capital is an education platform. We show you the maths and the assumptions; the decision, and the responsibility for it, stays with you. For anything personalised, speak to a SEBI-registered professional.

The short version

Calculate returns for irregular cash flows. The formula is public, the assumptions are printed on the page, and the calculation is yours to keep as a PDF.

👉 Run your own numbers in the XIRR Calculator

VIA Capital publishes financial education only. Nothing here is investment advice or a personalised recommendation, and no calculator output should be treated as a promise of returns.

Educational content only. Educational content only. Not investment advice or a personalised recommendation.

Written by

Abhishek sharma

Discussion (0)

Log in to join the conversation.

Sign In to Comment